通过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();
}
测试通过