Java Code Examples for org.apache.ibatis.session.SqlSession#insert()

The following examples show how to use org.apache.ibatis.session.SqlSession#insert() . You can vote up the ones you like or vote down the ones you don't like, and go to the original project or source file by following the links above each example. You may check out the related API usage on the sidebar.

Example 1

Source File: CeshiMyBatis.java From cg-blog with MIT License

6 votes

@Test
public void testInsert(){
    String resource = "sqlMapConfig.xml";           //定位核心配置文件
    InputStream inputStream = Resources.getResourceAsStream(resource);
    SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);        // 创建 SqlSessionFactory

    SqlSession sqlSession = sqlSessionFactory.openSession();            //获取到 SqlSession

    Person p = new Person();
    p.setId(5);
    p.setName("gavin");
    p.setAge(12);

    sqlSession.insert("yeepay.payplus.mapper.UserMapper.insert", p);
    sqlSession.commit();            //默认是不自动提交，必须手工提交
}

Example 2

Source File: BatchKeysTest.java From mybatis with Apache License 2.0

6 votes

@Test
public void testInsertJdbc3() throws Exception {
  SqlSession sqlSession = sqlSessionFactory.openSession(ExecutorType.BATCH);
  try {
    User user1 = new User(null, "Pocoyo");
    sqlSession.insert("insertIdentity", user1);
    User user2 = new User(null, "Valentina");
    sqlSession.insert("insertIdentity", user2);
    sqlSession.flushStatements();
    assertEquals(Integer.valueOf(0), user1.getId());
    assertEquals(Integer.valueOf(1), user2.getId());
    sqlSession.commit();
  } finally {
    sqlSession.close();
  }

  sqlSession = sqlSessionFactory.openSession();
  List<User> users = sqlSession.selectList("selectIdentity");
  Assert.assertTrue(users.size() == 2);
}

Example 3

Source File: ComponentTest.java From mybatis with Apache License 2.0

6 votes

@Test
public void shouldInsertNestedPasswordFieldOfComplexType() throws Exception {
  SqlSession sqlSession = sqlSessionFactory.openSession();
  try {
    //Create User
    User user = new User();
    user.setId(500000L);
    user.setPassword(new EncryptedString("secret"));
    user.setUsername("johnny" + Calendar.getInstance().getTimeInMillis());//random
    user.setAdministrator(true);

    sqlSession.insert("User.insert", user);

    //Retrieve User
    user = (User) sqlSession.selectOne("User.find", user.getId());

    assertNotNull(user.getId());

    sqlSession.rollback();
  } finally {
    sqlSession.close();
  }
}

Example 4

Source File: BatchKeysTest.java From mybaties with Apache License 2.0

6 votes

@Test
public void testInsertJdbc3() throws Exception {
  SqlSession sqlSession = sqlSessionFactory.openSession(ExecutorType.BATCH);
  try {
    User user1 = new User(null, "Pocoyo");
    sqlSession.insert("insertIdentity", user1);
    User user2 = new User(null, "Valentina");
    sqlSession.insert("insertIdentity", user2);
    sqlSession.flushStatements();
    assertEquals(Integer.valueOf(0), user1.getId());
    assertEquals(Integer.valueOf(1), user2.getId());
    sqlSession.commit();
  } finally {
    sqlSession.close();
  }

  sqlSession = sqlSessionFactory.openSession();
  List<User> users = sqlSession.selectList("selectIdentity");
  Assert.assertTrue(users.size() == 2);
}

Example 5

Source File: BatchKeysTest.java From mybaties with Apache License 2.0

6 votes

@Test
public void testInsert() throws Exception {
  SqlSession sqlSession = sqlSessionFactory.openSession(ExecutorType.BATCH);
  try {
    User user1 = new User(null, "Pocoyo");
    sqlSession.insert("insert", user1);
    User user2 = new User(null, "Valentina");
    sqlSession.insert("insert", user2);
    sqlSession.flushStatements();
    assertEquals(new Integer(50), user1.getId());
    assertEquals(new Integer(50), user2.getId());
    sqlSession.commit();
  } finally {
    sqlSession.close();
  }

  sqlSession = sqlSessionFactory.openSession();
  List<User> users = sqlSession.selectList("select");
  Assert.assertTrue(users.size() == 2);
}

Example 6

Source File: NoParamTypeTest.java From mybaties with Apache License 2.0

6 votes

@Test
public void shouldAcceptDifferentTypeInTheSameBatch() {
  SqlSession sqlSession = sqlSessionFactory.openSession(ExecutorType.BATCH);
  try {
    ObjA a = new ObjA();
    a.setId(1);
    a.setName(111);
    sqlSession.insert("insertUser", a);
    ObjB b = new ObjB();
    b.setId(2);
    b.setName("222");
    sqlSession.insert("insertUser", b);
    List<BatchResult> batchResults = sqlSession.flushStatements();
    batchResults.clear();
    sqlSession.clearCache();
    sqlSession.commit();
    List<User> users = sqlSession.selectList("selectUser");
    assertEquals(2, users.size());
  } finally {
    sqlSession.close();
  }
}

Example 7

Source File: BatchKeysTest.java From mybatis with Apache License 2.0

6 votes

@Test
public void testInsert() throws Exception {
  SqlSession sqlSession = sqlSessionFactory.openSession(ExecutorType.BATCH);
  try {
    User user1 = new User(null, "Pocoyo");
    sqlSession.insert("insert", user1);
    User user2 = new User(null, "Valentina");
    sqlSession.insert("insert", user2);
    sqlSession.flushStatements();
    assertEquals(new Integer(50), user1.getId());
    assertEquals(new Integer(50), user2.getId());
    sqlSession.commit();
  } finally {
    sqlSession.close();
  }

  sqlSession = sqlSessionFactory.openSession();
  List<User> users = sqlSession.selectList("select");
  Assert.assertTrue(users.size() == 2);
}

Example 8

Source File: ComponentTest.java From mybaties with Apache License 2.0

6 votes

@Test
public void shouldInsertNestedPasswordFieldOfComplexType() throws Exception {
  SqlSession sqlSession = sqlSessionFactory.openSession();
  try {
    //Create User
    User user = new User();
    user.setId(500000L);
    user.setPassword(new EncryptedString("secret"));
    user.setUsername("johnny" + Calendar.getInstance().getTimeInMillis());//random
    user.setAdministrator(true);

    sqlSession.insert("User.insert", user);

    //Retrieve User
    user = (User) sqlSession.selectOne("User.find", user.getId());

    assertNotNull(user.getId());

    sqlSession.rollback();
  } finally {
    sqlSession.close();
  }
}

Example 9

Source File: SelectKeyTest.java From mybaties with Apache License 2.0

5 votes

@Test(expected=PersistenceException.class)
public void testSeleckKeyReturnsNoData() {
  SqlSession sqlSession = sqlSessionFactory.openSession();
  try {
    Map<String, String> parms = new HashMap<String, String>();
    parms.put("name", "Fred");
    int rows = sqlSession.insert("org.apache.ibatis.submitted.selectkey.Table2.insertNoValuesInSelectKey", parms);
    assertEquals(1, rows);
    assertNull(parms.get("id"));
  } finally {
    sqlSession.close();
  }
}

Example 10

Source File: SelectKeyTest.java From mybaties with Apache License 2.0

5 votes

@Test(expected=PersistenceException.class)
public void testSeleckKeyReturnsTooManyData() {
  SqlSession sqlSession = sqlSessionFactory.openSession();
  try {
    Map<String, String> parms = new HashMap<String, String>();
    parms.put("name", "Fred");
    sqlSession.insert("org.apache.ibatis.submitted.selectkey.Table2.insertTooManyValuesInSelectKey", parms);
    sqlSession.insert("org.apache.ibatis.submitted.selectkey.Table2.insertTooManyValuesInSelectKey", parms);
  } finally {
    sqlSession.close();
  }
}

Example 11

Source File: SelectKeyTest.java From mybaties with Apache License 2.0

5 votes

@Test(expected = PersistenceException.class)
public void testSeleckKeyWithWrongKeyProperty() {
  SqlSession sqlSession = sqlSessionFactory.openSession();
  try {
    Name name = new Name();
    name.setName("Kyoto");
    sqlSession.insert("org.apache.ibatis.submitted.selectkey.Table2.insertWrongKeyProperty", name);
  } finally {
    sqlSession.close();
  }
}

Example 12

Source File: SelectKeyTest.java From mybaties with Apache License 2.0

5 votes

@Test
public void testInsertTable1() {
  SqlSession sqlSession = sqlSessionFactory.openSession();

  try {
    Map<String, String> parms = new HashMap<String, String>();
    parms.put("name", "Fred");
    int rows = sqlSession.insert("org.apache.ibatis.submitted.selectkey.Table1.insert", parms);
    assertEquals(1, rows);
    assertEquals(11, parms.get("id"));

  } finally {
    sqlSession.close();
  }
}

Example 13

Source File: TestBatisXML.java From java-course-ee with MIT License

5 votes

public static void main(String[] args) throws IOException {
    String resource = "Configuration.xml";
    Reader reader = Resources.getResourceAsReader(resource);
    SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(reader);

    SqlSession session = sqlSessionFactory.openSession();
    try {
        Region region = new Region();
        region.setRegionName("12345");

        session.insert("ibatis.RegionMapper.insertRegion", region);
        session.commit();

        System.out.println("Region ID: " + region.getRegionId());

        findAndGet(session);

        region.setRegionName("54321");
        session.update("ibatis.RegionMapper.updateRegion", region);
        session.commit();
        findAndGet(session);

        session.delete("ibatis.RegionMapper.deleteRegion", region.getRegionId());
        session.commit();
        findAndGet(session);

    } catch (Exception e) {
        e.printStackTrace();
    } finally {
        session.close();
    }

}

Example 14

Source File: SqlSessionTestBase.java From pinpoint with Apache License 2.0

5 votes

protected final void testAndVerifyInsert() throws Exception {
    // Given
    final String insertId = "insertId";
    SqlSession sqlSession = getSqlSession();
    // When
    sqlSession.insert(insertId);
    sqlSession.insert(insertId, new Object());
    // Then
    PluginTestVerifier verifier = PluginTestVerifierHolder.getInstance();
    Method insert1 = sqlSession.getClass().getDeclaredMethod("insert", String.class);
    Method insert2 = sqlSession.getClass().getDeclaredMethod("insert", String.class, Object.class);
    verifier.verifyTrace(event("MYBATIS", insert1, Expectations.cachedArgs(insertId)));
    verifier.verifyTrace(event("MYBATIS", insert2, Expectations.cachedArgs(insertId)));
}

Example 15

Source File: SelectKeyTest.java From mybatis with Apache License 2.0

5 votes

@Test(expected = PersistenceException.class)
public void testSeleckKeyWithWrongKeyProperty() {
  SqlSession sqlSession = sqlSessionFactory.openSession();
  try {
    Name name = new Name();
    name.setName("Kyoto");
    sqlSession.insert("org.apache.ibatis.submitted.selectkey.Table2.insertWrongKeyProperty", name);
  } finally {
    sqlSession.close();
  }
}

Example 16

Source File: SelectKeyTest.java From mybatis with Apache License 2.0

5 votes

@Test
public void testInsertTable1() {
  SqlSession sqlSession = sqlSessionFactory.openSession();

  try {
    Map<String, String> parms = new HashMap<String, String>();
    parms.put("name", "Fred");
    int rows = sqlSession.insert("org.apache.ibatis.submitted.selectkey.Table1.insert", parms);
    assertEquals(1, rows);
    assertEquals(11, parms.get("id"));

  } finally {
    sqlSession.close();
  }
}

Example 17

Source File: UserMain.java From blog with BSD 2-Clause "Simplified" License

5 votes

public static void main(String[] args) throws IOException {
	String resource = "mybatis-config.xml";
	InputStream inputStream = Resources.getResourceAsStream(resource);
	SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);

	// 方式一
	SqlSession session1 = sqlSessionFactory.openSession();
	User user = new User();
	user.setId(102);
	user.setSex(Sex.FEMALE);
	user.setName("zhaohui");
	try {
		session1.insert("insertUser", user);
		session1.commit();
	} finally {
		session1.close();
	}

	SqlSession session2 = sqlSessionFactory.openSession();
	try {
		UserMapper userMapper = session2.getMapper(UserMapper.class);
		User user2 = userMapper.getUser(102);
		System.out.println(user2.toString());
	} finally {
		session2.close();
	}

}

Example 18

Source File: SelectKeyTest.java From mybatis with Apache License 2.0

5 votes

@Test(expected=PersistenceException.class)
public void testSeleckKeyReturnsNoData() {
  SqlSession sqlSession = sqlSessionFactory.openSession();
  try {
    Map<String, String> parms = new HashMap<String, String>();
    parms.put("name", "Fred");
    int rows = sqlSession.insert("org.apache.ibatis.submitted.selectkey.Table2.insertNoValuesInSelectKey", parms);
    assertEquals(1, rows);
    assertNull(parms.get("id"));
  } finally {
    sqlSession.close();
  }
}

Example 19

Source File: MonitNotifyHistoryDao.java From JavaTutorial with Apache License 2.0

5 votes

public int insert(MonitNotifyHistory record) {
    SqlSession session = _ssFactory.openSession(true);
    int result = 0;
    try {
        result = session.insert(assembleStatement("insertSelective"), record);
    } finally {
        close(session);
    }
    
    return result;
}

Example 20

Source File: MybatisTest.java From Oceanus with Apache License 2.0

4 votes

@Test
public void insertTest() throws SQLException {
	for(long id=1; id<=100; id++){
		SqlSession session = sqlSessionFactory.openSession(false);
		int result = -1;
		try {
			result = session.insert("com.bj58.oceanus.plugins.mybatis.entity.UserMapper.insertUser", new User(id, "uname"+id, RandomUtil.nextInt(10, 30)));
			System.out.println(result);
			id++;
			
			result = session.insert("com.bj58.oceanus.plugins.mybatis.entity.UserMapper.insertUser", new User(id, "uname"+id, RandomUtil.nextInt(10, 30)));
			System.out.println(result);
			id++;
			
			result = session.insert("com.bj58.oceanus.plugins.mybatis.entity.UserMapper.insertUser", new User(id, "uname"+id, RandomUtil.nextInt(10, 30)));
			System.out.println(result);
			id++;
			
			result = session.insert("com.bj58.oceanus.plugins.mybatis.entity.UserMapper.insertUser", new User(id, "uname"+id, RandomUtil.nextInt(10, 30)));
			System.out.println(result);
			id++;
			
			result = session.insert("com.bj58.oceanus.plugins.mybatis.entity.UserMapper.insertUser", new User(id, "uname"+id, RandomUtil.nextInt(10, 30)));
			System.out.println(result);
			id++;
			
			result = session.insert("com.bj58.oceanus.plugins.mybatis.entity.UserMapper.insertUser", new User(id, "uname"+id, RandomUtil.nextInt(10, 30)));
			System.out.println(result);
			id++;
			
			result = session.insert("com.bj58.oceanus.plugins.mybatis.entity.UserMapper.insertUser", new User(id, "uname"+id, RandomUtil.nextInt(10, 30)));
			System.out.println(result);
			id++;
			
			result = session.insert("com.bj58.oceanus.plugins.mybatis.entity.UserMapper.insertUser", new User(id, "uname"+id, RandomUtil.nextInt(10, 30)));
			System.out.println(result);
			id++;
			
			result = session.insert("com.bj58.oceanus.plugins.mybatis.entity.UserMapper.insertUser", new User(id, "uname"+id, RandomUtil.nextInt(10, 30)));
			System.out.println(result);
			id++;
			
			result = session.insert("com.bj58.oceanus.plugins.mybatis.entity.UserMapper.insertUser", new User(id, "uname"+id, RandomUtil.nextInt(10, 30)));
			System.out.println(result);
			
			session.commit();
		} catch(Exception e){
			e.printStackTrace();
			session.rollback();
		}finally {
			session.close();
		}
	}
}