Mybatis03——增删改

mybatis – MyBatis 3 | XML 映射器

（数据库的增删改需要提交事务)session.commit()

一、增

int insertUser(User user);//编写接口

编写对应的mapper对应的接口

<insert id="insertUser" parameterType="com.jia.pojo.User">
    insert into mybatis.user(id,name ,pwd) value (#{id},#{name},#{pwd})
</insert>  

二、删

int deleteUserByid(int id);

<delete id="deleteUserByid" parameterType="int">
    delete from mybatis.user where id=#{id}
</delete>

三、改

int updateUser(User user);

<update id="updateUser" parameterType="com.jia.pojo.User">
    update mybatis.user set name=#{name},pwd=#{pwd} where id = #{id}
</update>

测试：

@Test 
public void testUpdateUser() { 
    SqlSession session = MybatisUtils.getSession(); 
    UserMapper mapper = session.getMapper(UserMapper.class); 
    User user = mapper.selectUserById(1); user.setPwd("asdfgh"); 
    int i = mapper.updateUser(user);
    System.out.println(i); 
    session.commit(); //提交事务,重点!不写的话不会提交到数据库
    session.close(); 
}