~~~ public class MybatisFirst { // 會話工廠 private SqlSessionFactory sqlSessionFactory; @Before public void createSqlSessionFactory() throws Exception{ // 配置文件 String resource = "sqlMapConfig.xml"; InputStream resourceAsStream = Resources.getResourceAsStream(resource); // 從配置文件中創建SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(resourceAsStream); } @Test public void testFindUserById(){ // 會話 SqlSession sqlSession = sqlSessionFactory.openSession(); // 查詢單條記錄 User user = sqlSession.selectOne("test.findUserById", 1); System.out.println(user.toString()); } @Test public void testFindUserByUsername(){ // 會話 SqlSession sqlSession = sqlSessionFactory.openSession(); // 查詢多條記錄 List<User> list = sqlSession.selectList("test.findUserByUsername", "bb"); System.out.println(list); } @Test public void testInserUser(){ // 會話 SqlSession sqlSession = sqlSessionFactory.openSession(); // 插入 User user = new User(); user.setUsername("test"); user.setBirthday(new Date(System.currentTimeMillis())); user.setSex("1"); user.setAddress("111"); // 成功返回1 int insert = sqlSession.insert("test.insertUser", user); System.out.println(insert); // 提交事務 sqlSession.commit(); } @Test public void testDeleteUserById(){ // 會話 SqlSession sqlSession = sqlSessionFactory.openSession(); // 查詢多條記錄 int result = sqlSession.delete("test.deleteUserById", 1); System.out.println(result); sqlSession.commit(); } @Test public void testUpdate(){ // 會話 SqlSession sqlSession = sqlSessionFactory.openSession(); // 更新 User user = new User(); user.setId(8); user.setUsername("test1111"); user.setBirthday(new Date(System.currentTimeMillis())); user.setSex("1"); user.setAddress("11122222"); int result = sqlSession.update("test.updateUser", user); System.out.println(result); sqlSession.commit(); } } ~~~