mybatis java类注解式_mybatis之注解方式实现

1 packagezhujie;2

3 importbean.UserSalary;4 importfirst.UserBean;5 importorg.apache.ibatis.io.Resources;6 importorg.apache.ibatis.session.SqlSession;7 importorg.apache.ibatis.session.SqlSessionFactory;8 importorg.apache.ibatis.session.SqlSessionFactoryBuilder;9 importorg.junit.After;10 importorg.junit.Before;11 importorg.junit.Ignore;12 importorg.junit.Test;13

14 importjava.io.IOException;15 importjava.io.InputStream;16 importjava.util.List;17

18 /*

19 * 使用mybatis举例，使用注解方式实现20 * 不需要针对UserMapperI接口去编写具体的实现类代码，这个具体的实现类由MyBatis帮我们动态构建出来，我们只需要直接拿来使用即可。21 * 1、导入jar包：mybatis和mysql-connector22 * 2、mybatis配置文件：mybatis-config.xml，加载Mapper接口路径23 * 3、编写JavaBean类：UserBean24 * 4、编写执行sql接口25 * 5、编写测试类进行测试26 **/

27 public classTestZhuJie {28 String resource = "mybatis-config-zhujie.xml";29 SqlSessionFactory sqlSessionFactory = null;30 SqlSession session = null;31

32 @Before33 public voidbefore() {34 //System.out.println("Before");

35 try{36 InputStream inputStream =Resources.getResourceAsStream(resource);37 //创建工厂

38 sqlSessionFactory = newSqlSessionFactoryBuilder().build(inputStream);39 //创建session对象

40 session =sqlSessionFactory.openSession();41

42 } catch(IOException e) {43 e.printStackTrace();44 }45 }46

47 @After48 public voidclose() {49 session.close();50 //System.out.println("After");

51 }52

53 @Test54 public voidtestSelectOneUser() {55 //接口自动实例化

56 UserMapperInterface userMapperInterface = session.getMapper(UserMapperInterface.class);57 //执行sql

58 UserBean userBean = userMapperInterface.selectOneUser(1);59 System.out.println(userBean);60 }61

62 //批量查询

63 @Test64 public voidtestSelectAllUser() {65 //接口自动实例化

66 UserMapperInterface userMapperInterface = session.getMapper(UserMapperInterface.class);67 //执行sql

68 List listUserBean =userMapperInterface.selectAllUser();69 System.out.println("记录个数：" +listUserBean.size());70 System.out.println(listUserBean);71 }72

73 @Ignore74 @Test75 public voidtestInsertUser() {76 UserBean userBean = new UserBean("CoCo2", "50");77 UserMapperInterface userMapperInterface = session.getMapper(UserMapperInterface.class);78 int n =userMapperInterface.insertUser(userBean);79 //提交

80 session.commit();81 System.out.println("插入数据成功：" +userBean);82 }83

84 @Ignore85 @Test86 public voidtestUpdateUser() {87 UserBean userBean = new UserBean(2, "Tom44", "40");88 UserMapperInterface userMapperInterface = session.getMapper(UserMapperInterface.class);89 userMapperInterface.updateUser(userBean);90 session.commit();91 System.out.println("修改数据成功：" +userBean);92 }93

94 @Ignore95 @Test96 public voidtestDeleteUser() {97 UserBean userBean = new UserBean(15, "XXX", "40");98 UserMapperInterface userMapperInterface = session.getMapper(UserMapperInterface.class);99 int n =userMapperInterface.deleteByUserBean(userBean);100 session.commit();101 System.out.println("删除数据成功：" +userBean);102 System.out.println("操作成功记录数：" +n);103 }104

105 @Test106 public voidtestSelectOneUserSalary() {107 //接口自动实例化

108 UserMapperInterface userMapperInterface = session.getMapper(UserMapperInterface.class);109 //执行sql

110 UserSalary userSalary = userMapperInterface.selectOneUserSalary("Tom");111 System.out.println(userSalary);112 }113

114 }