****************修改用户****************
1> HelloMyBatis.java
class HelloMyBaties{
@Test
public void Test4() throws IOException{
//配置文件
String resource = "sqlMapConfig.xml";
//读取配置文件
InputStream in = Resources.getResourceAsStream(resource);
//sqlSessionFactoryBuilder
SqlSessionFactoruBuilder ssfb = new sqlSessionFactoryBuilder();
//创建sqlSessionFactory
SqlSessionFactory ssf = ssfb.builder(in);
//生成一个sqlSession
SqlSession session = ssf.openSession();
//操作数据(原id=13的是小明)
User user = new User();
user.setU_id(13);
user.setU_username("张飞");
user.setU_password("111111");
user.setU_sex("2");
session.update("UserMapper.updateUser",user);
session.commit();
}
}
2> UserMapper.xml
<!-- 修改用户 -->
<update id="updateUser" parameterType="com.XXX.bean.User">
update user set u_username = #{u_username},u_password=#{u_password},u_sex=#{u_sex}
where u_id = #{u_id}
</update>