JavaWeb学习笔记-mybatis-06-删除和跟新用户

映射文件

<!--删除用户-->
    <delete id="deleteUser" parameterType="java.lang.Integer">
        delete  from user where id = #{id}
    </delete>
    <!--更新用户-->
    <update id="updateUser" parameterType="java.com.sws.entity.User">
        update user set username=#{username},birthday=#{birthday},sex=#{sex},address=#{address} where id = #{id}
    </update>

//java代码
    //删除用户信息
    public void deleteUser() throws IOException {
        //mybatis配置文件
        String resource = "SqlMapConfig.xml";
        //得到配置流
        InputStream inputStream = Resources.getResourceAsStream(resource);
        //创建会话工厂
        SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);
        //通过工厂得到SqlSession
        SqlSession sqlSession = sqlSessionFactory.openSession();
        //通过sqlSession操作数据库
        sqlSession.delete("test.deleteUser",1);
        //需要执行提交
        sqlSession.commit();
        //获取用户id
        sqlSession.close();
    }

 //更新用户信息
    public void updateUser() throws IOException {
        //mybatis配置文件
        String resource = "SqlMapConfig.xml";
        //得到配置流
        InputStream inputStream = Resources.getResourceAsStream(resource);
        //创建会话工厂
        SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);
        //通过工厂得到SqlSession
        SqlSession sqlSession = sqlSessionFactory.openSession();
        //插入用户对象
        User user = new User();
        user.setId(1);
        user.setUsername("xxx");
        user.setBirthday(new Date());
        user.setSex("1");
        user.setAddress("xxx");
        //通过sqlSession操作数据库
        sqlSession.update("test.updateUser",user);
        //需要执行提交
        sqlSession.commit();
        //获取用户id
        sqlSession.close();
    }