2021.3.31

mybatis update

 

//insert一个用户
int updateUser(User user);

<update id="updateUser" parameterType="Tool.MybatisUtils.pojo.User">
update mybatis.mybatis set name = #{name} where password = #{password}
</update>

@Test
public void addUser(){
SqlSession sqlSession = MybatisUtils.getSqlSession();
UserDao mapper = sqlSession.getMapper(UserDao.class);
int res = mapper.addUser(new User("王二狗","111"));
if(res>0){
System.out.println("插入成功");
}
//提交事务
sqlSession.commit();
sqlSession.close();
}