<!-- 删除用户 -->

    <delete id="deleteUser" parameterType="java.lang.Integer">

     delete from user where id=#{id}

    </delete>

    <!-- 更新用户

    必须指定id，否则将会将表的内容全部更新

     -->

    <update id="updateUser" parameterType="ql.mybatis.pojo.User">

    update user set username=#{username},birthday=#{birthday},sex=#{sex},address=#{address} where id=#{id}

    </update>

    // 删除用户

    @Test

    public void deleteUserTest() throws IOException {

        // 通过工厂得到SqlSession

        SqlSession sqlSession = null;

        try {

            // mybatis配置文件

            String resource = "SqlMapConfig.xml";

            // 得到配置文件流

            InputStream inputStream = Resources.getResourceAsStream(resource);

            // 创建会话工厂，传入mybatis的配置文件信息

            SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder()

                    .build(inputStream);

            sqlSession = sqlSessionFactory.openSession();

            sqlSession.delete("test.deleteUser", 1);

            sqlSession.commit();

        } catch (IOException e) {

            e.printStackTrace();

        } finally {

            if (sqlSession != null) {

                // 释放资源

                sqlSession.close();

            }

        }

    }

    //更新用户

    @Test

    public void updateUserTest() throws IOException {

        // 通过工厂得到SqlSession

        SqlSession sqlSession = null;

        try {

            // mybatis配置文件

            String resource = "SqlMapConfig.xml";

            // 得到配置文件流

            InputStream inputStream = Resources.getResourceAsStream(resource);

            // 创建会话工厂，传入mybatis的配置文件信息

            SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder()

                    .build(inputStream);

            sqlSession = sqlSessionFactory.openSession();

            User user=new User();

            user.setId(22);

            user.setUsername("陈大明");

            user.setBirthday(new Date());

            user.setAddress("福建福州");

            user.setSex("2");

            sqlSession.update("test.updateUser",user);

            sqlSession.commit();

        } catch (IOException e) {

            e.printStackTrace();

        } finally {

            if (sqlSession != null) {

                // 释放资源

                sqlSession.close();

            }

        }

    }