通过MyBatis修改MySQL中表的具体操作

首先创建一个sqlSession的工具类（需要有user数据库表及Java实体类，在前文中已经配置过）

package com.mabatis.pojo.utils;

import org.apache.ibatis.io.Resources;
import org.apache.ibatis.session.SqlSession;
import org.apache.ibatis.session.SqlSessionFactory;
import org.apache.ibatis.session.SqlSessionFactoryBuilder;

import java.io.IOException;
import java.io.InputStream;

public class SqlSessionUtil {
    public static SqlSession getSqlSession(){
        SqlSession sqlSession = null;
        //获取核心配置文件的输入流
        try {
            InputStream is = Resources.getResourceAsStream("mybatis-config.xml");
            //获取SqlSessionFactryBuilder
            SqlSessionFactoryBuilder sqlsessionfactorybuilder = new SqlSessionFactoryBuilder();
            //获取SqlSessionFactry对象
            SqlSessionFactory sqlsessionFactory = sqlsessionfactorybuilder.build(is);
            //获取SqlSession对象
            sqlSession = sqlsessionFactory.openSession(true);
        } catch (IOException e) {
            e.printStackTrace();
        }
        return sqlSession;
    }
}

其次在UserMapper的接口类中创建修改用户信息的方法

package com.mabatis.pojo.mapper;

public interface UserMapper {
/*
* 添加用户信息
* */
    int insertUser();
/*
* 修改用户信息
* */
    void updateUser();
}

在UserMapper.xml映射文件中写SQL语句

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper
        PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
        "https://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.mabatis.pojo.mapper.UserMapper">
    <!--int insertUser()-->
    <insert id="insertUser">
        insert into user values(null,'admin','12345',23,'女','12345@qq.com')
    </insert>

    <!--void updateUser();-->
    <update id="updateUser">
        update user set username='root',password='321' where id=6
    </update>

</mapper>

在MyBatisTest中配置进行测试

   @Test
    public void testUpdate() {
        SqlSession sqlSession  = SqlSessionUtil.getSqlSession();
        UserMapper mapper = sqlSession.getMapper(UserMapper.class);
        mapper.updateUser();
        sqlSession.close();
   }

测试通过