MyBatis从入门到精通:update用法、delete用法
2024-10-02 04:41:03
update用法:
1.接口类中添加的方法:
int updateById(SysUser sysUser);
2.映射文件中添加的代码:
<update id="updateById"> UPDATE sys_user SET user_name=#{userName}, user_password=#{userPassword}, user_email=#{userEmail}, user_info=#{userInfo}, head_img=#{headImg,jdbcType=BLOB}, create_time=#{createTime,jdbcType=TIMESTAMP} WHERE id=#{id} </update>
3.测试代码:
public void testInsert(){ SqlSession sqlSession = getSqlSession(); try{ UserMapper userMapper = sqlSession.getMapper(UserMapper.class); SysUser user = new SysUser(); user.setUserName("test2"); user.setUserPassword("123456"); user.setUserEmail("test@mybatis.tk"); user.setUserInfo("test info"); user.setHeadImg(new byte[]{1,2,3}); user.setCreateTime(new Date()); int result = userMapper.insert(user); Assert.assertEquals(1,result); Assert.assertNull(user.getId()); }finally { sqlSession.rollback(); sqlSession.close(); } }
delete用法:
1.接口类中添加的方法:
int deleteById(Long id); int deleteById(SysUser sysUser);
2.映射文件中添加的代码:
<delete id="deleteById"> DELETE FROM sys_user WHERE id = #{id} </delete> <delete id="deleteById2"> DELETE FROM sys_user WHERE id = #{id} </delete>
3.测试代码:
@Test public void testUpdateById(){ SqlSession sqlSession = getSqlSession(); try{ UserMapper userMapper = sqlSession.getMapper(UserMapper.class); SysUser user = userMapper.selectById(1L); Assert.assertEquals("admin",user.getUserName()); user.setUserName("junjie"); user.setUserPassword("123456"); user.setUserEmail("junjie@mybatis.tk"); user.setUserInfo("junjie test info"); int result = userMapper.updateById(user); Assert.assertEquals(1,result); user=userMapper.selectById(1L); Assert.assertEquals("junjie",user.getUserName()); }finally { sqlSession.commit(); sqlSession.close(); } } public void testDeleteById(){ SqlSession sqlSession = getSqlSession(); try{ UserMapper userMapper = sqlSession.getMapper(UserMapper.class); SysUser user = userMapper.selectById(1L); //System.out.println(); //Assert.assertNotNull(user); //Assert.assertEquals(1,userMapper.deleteById(1L)); //SysUser user2 = userMapper.selectById(1001L); //Assert.assertNotNull(user2); //Assert.assertEquals(1,userMapper.deleteById(user2)); //Assert.assertNull(userMapper.selectById(1001L)); }finally { sqlSession.rollback(); sqlSession.close(); } }
最新文章
- Struts的文件上传下载
- java 24 - 3 GUI之添加按钮
- ios截取号码
- node.js报错总结
- LPTHW 笨办法学python 20章
- java应用死循环排查方法或查找程序消耗资源的线程方法(面试)
- LeetCode----67. Add Binary(java)
- MySQL执行计划显示与执行过程不符合一例
- WPF编程学习——样式
- a code snip
- 关于hibernate映射过程中的笔记
- 水仙花 AC 杭电
- Java入门——(1)Java编程基础
- 201521123013 《Java程序设计》第3周学习总结
- win10安装配置jdk的环境变量
- go module下golang.org如何处理被墙
- 由javascript的闭包引申到程序语言编译上的自由变量作用域的考量
- Java -cp 命令查看 zookeeper 日志
- BZOJ1076:[SCOI2008]奖励关(状压DP,期望)
- Maven简单的配置Junit测试及使用简单的mock