如何通过MyBatis实现增删改

UserMapper.xml

[html] view plain copy

1. <!--增加 -->
2. <insert id="add" parameterType="User">
3. insert into smbms_user(userCode,userName,userPassword,gender,birthday,phone,address,userRole,createdBy,creationDate)
4. values(#{userCode},#{userName},#{userPassword},#{gender},#{birthday},#{phone},#{address},#{userRole},#{createdBy},#{creationDate})
5. </insert>
7. <!-- 修改（4个起参数用对象）-->
8. <update id="updatee" parameterType="User">
9. update smbms_user set userCode=#{userCode},userName=#{userName},userPassword=#{userPassword},
10. gender=#{gender},birthday=#{birthday},phone=#{phone},address=#{address},userRole=#{userRole},modifyBy=#{modifyBy},modifyDate=#{modifyDate}
11. where id=#{id}
12. </update>
14. <!-- 修改密码（1-3参数使用@param） -->
15. <update id="updatePwd">
16. update smbms_user set userPassword=#{userPassword} where id=#{id}
17. </update>
19. <!-- 删除 -->
20. <delete id="deletee" parameterType="int">
21. delete from smbms_user where id=#{id}
22. </delete>

UserMapper.java

[html] view plain copy

1. //增加
2. public int add(User user);
4. //修改
5. public int updatee(User user);
7. //修改密码
8. public int updatePwd(@Param("id")Integer id,@Param("userPassword")String pwd);
10. //删除
11. public int deletee(Integer id);

MapperTest.java

[html] view plain copy

1. //添加数据条
2. @Test
3. public void test9() {
5. SqlSession sqlSession=null;
6. int count=0;
7. try {
8. sqlSession=MyBatisUtil.createSqlSession();
9. User user=new User();
10. user.setUserCode("003");
11. user.setUserName("用户0011");
12. user.setUserPassword("1234561");
14. //如何添加Date类型的生日日期
15. Date birthday=new SimpleDateFormat("yyyy-MM-dd").parse("2000-11-11");
16. user.setBirthday(birthday);
18. //如何添加 创建日期
19. user.setCreationDate(new Date());
21. user.setAddress("南京1");
22. user.setGender(1);
23. user.setPhone("13367891214");
24. user.setUserRole(1);
25. user.setCreatedBy(1);
27. count=sqlSession.getMapper(UserMapper.class).add(user);
29. } catch (Exception e) {
30. // TODO Auto-generated catch block
31. e.printStackTrace();
32. }finally{
34. MyBatisUtil.closeSqlSession(sqlSession);
35. }
36. System.out.println(count);
38. }
41. //修改某数据条中的3个以上字段对应的数据内容
42. @Test
43. public void test10() {
45. SqlSession sqlSession=null;
46. int count=0;
47. try {
48. sqlSession=MyBatisUtil.createSqlSession();
49. User user=new User();
50. user.setId(18);
51. user.setUserCode("17");
52. user.setUserName("用户00");
53. user.setUserPassword("1234");
54. Date birthday=new SimpleDateFormat("yyyy-MM-dd").parse("2000-11-11");
55. user.setBirthday(birthday);
56. user.setCreationDate(new Date());
57. user.setAddress("南京12");
58. user.setGender(1);
59. user.setPhone("133678912344");
60. user.setUserRole(2);
61. //user.setCreatedBy(1);
62. user.setModifyBy(1);
63. user.setModifyDate(new Date());
64. count=sqlSession.getMapper(UserMapper.class).updatee(user);
66. } catch (Exception e) {
67. // TODO Auto-generated catch block
68. e.printStackTrace();
69. }finally{
71. MyBatisUtil.closeSqlSession(sqlSession);
72. }
73. System.out.println(count);
75. }
77. //修改某数据条的3个之内字段对应的数据内容
78. @Test
79. public void test11() {
81. SqlSession sqlSession=null;
82. int count=0;
83. //密码和 id两个字段
84. String pwd="666888";
85. Integer id=1;
86. try {
87. sqlSession=MyBatisUtil.createSqlSession();
89. count=sqlSession.getMapper(UserMapper.class).updatePwd(id, pwd);
91. } catch (Exception e) {
92. // TODO Auto-generated catch block
93. e.printStackTrace();
94. }finally{
96. MyBatisUtil.closeSqlSession(sqlSession);
97. }
98. System.out.println(count);
100. }
102. //删除数据条
103. @Test
104. public void test12() {
106. SqlSession sqlSession=null;
107. int count=0;
109. Integer id=19;
110. try {
111. sqlSession=MyBatisUtil.createSqlSession();
113. count=sqlSession.getMapper(UserMapper.class).deletee(id);
115. } catch (Exception e) {
116. // TODO Auto-generated catch block
117. e.printStackTrace();
118. }finally{
120. MyBatisUtil.closeSqlSession(sqlSession);
121. }
122. System.out.println(count);
124. }