改——修改
testUpdate方法
@Test
public void testUpdate()throws IOException{
//模拟user对象
User user = new User();
// 在数据库里面会自增,不能写死了
user.setUid(7);
user.setUage(26);
user.setUname("jyy");
user.setPosition("j");
//获得核心配置文件
InputStream resourceAsStream = Resources.getResourceAsStream("mybatis-config.xml");
//获得session工厂对象
SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(resourceAsStream);
//获得session会话对象
SqlSession sqlSession = sqlSessionFactory.openSession();
//执行操作 参数
sqlSession.update("updateUser",user);
sqlSession.commit();
// System.out.println(user);
//执行更新操作要提交事务
//释放资源
sqlSession.close();
}
testUpdate的select
<!-- 修改-->
<select id="updateUser" parameterType="com.itheima.pojo.User">
update users set uname=#{uname},uage=#{uage},eposition=#{eposition} where uid =#{uid}
</select>
运行前数据库
运行后idea
运行后数据库
查——根据id查找
userFindByIdTest方法
public void userFindByIdTest(){
String resources="mybatis-config.xml";
Reader reader=null;
try{
reader = Resources.getResourceAsReader(resources);
}catch (IOException e){
e.printStackTrace();
}
SqlSessionFactory sqlMapper=new SqlSessionFactoryBuilder().build(reader);
SqlSession session= sqlMapper.openSession();
User user=session.selectOne("findById",1);
System.out.println(""+user);
session.close();
}
userFindByIdTest的select
<select id="findById" resultType="com.itheima.pojo.User" parameterType="com.itheima.pojo.User">
select * from users where uid=#{uid}
</select>
运行前数据库
运行后idea
查——查找所有
testFindAll方法
public void testFindAll()throws IOException{
//获得核心配置文件
InputStream resourceAsStream = Resources.getResourceAsStream("mybatis-config.xml");
//获得session工厂对象
SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(resourceAsStream);
//获得session会话对象
SqlSession sqlSession = sqlSessionFactory.openSession();
//执行操作 参数
List<User> userList = sqlSession.selectList("com.itheima.pojo.User.findAll");
//打印数据
System.out.println(userList);
//释放资源
sqlSession.close();
}
testFindAll的select
<select id="findAll" resultType="com.itheima.pojo.User">
select * from users
</select>
运行前数据库
运行后idea
增——插入
testInsert方法
@Test
public void testUpdate()throws IOException{
//模拟user对象
User user = new User();
// 在数据库里面会自增,不能写死了
user.setUid(7);
user.setUage(26);
user.setUname("jyy");
user.setPosition("j");
//获得核心配置文件
InputStream resourceAsStream = Resources.getResourceAsStream("mybatis-config.xml");
//获得session工厂对象
SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(resourceAsStream);
//获得session会话对象
SqlSession sqlSession = sqlSessionFactory.openSession();
//执行操作 参数
sqlSession.update("updateUser",user);
sqlSession.commit();
// System.out.println(user);
//执行更新操作要提交事务
//释放资源
sqlSession.close();
}
testInsert的select
<!-- 插入-->
<select id="insertUser" parameterType="com.itheima.pojo.User">
insert into users(uname,uage,eposition) values (#{uname},#{uage},#{eposition})
</select>
运行前数据库
运行后idea
运行后数据库
删——删除
testDelete方法
@Test
public void testDelete()throws IOException{
//获得核心配置文件
InputStream resourceAsStream = Resources.getResourceAsStream("mybatis-config.xml");
//获得session工厂对象
SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(resourceAsStream);
//获得session会话对象
SqlSession sqlSession = sqlSessionFactory.openSession();
//执行操作 参数
sqlSession.delete("deleteUser",7);
sqlSession.commit();
sqlSession.close();
}
testDelete的select
<!-- 删除-->
<select id="deleteUser" parameterType="java.lang.Integer">
delete from users where uid=#{uid}
</select>
运行前数据库
运行后idea
运行后数据库
映射:UserMapper.xml
<!DOCTYPE mapper
PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.itheima.pojo.User">
<select id="findById" resultType="com.itheima.pojo.User" parameterType="com.itheima.pojo.User">
select * from users where uid=#{uid}
</select>
<select id="findAll" resultType="com.itheima.pojo.User">
select * from users
</select>
<!-- 插入-->
<select id="insertUser" parameterType="com.itheima.pojo.User">
insert into users(uname,uage,eposition) values (#{uname},#{uage},#{eposition})
</select>
<!-- 修改-->
<select id="updateUser" parameterType="com.itheima.pojo.User">
update users set uname=#{uname},uage=#{uage},eposition=#{eposition} where uid =#{uid}
</select>
<!-- 删除-->
<select id="deleteUser" parameterType="java.lang.Integer">
delete from users where uid=#{uid}
</select>
</mapper>
数据库连接信息配置:mybatis-config.xml
<?xml version="1.0" encoding="utf-8"?>
<!DOCTYPE configuration PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-config.dtd">
<configuration>
<properties resource="db.properties"/>
<environments default="development">
<environment id="development">
<transactionManager type="JDBC" />
<dataSource type="POOLED">
<property name="driver" value="${mysql.driver}" />
<property name="url" value="${mysql.url}" />
<property name="username" value="${mysql.username}" />
<property name="password" value="${mysql.password}" />
</dataSource>
</environment>
</environments>
<mappers>
<mapper resource="mapper/UserMapper.xml"/>
</mappers>
</configuration>
db.properties
mysql.driver = com.mysql.cj.jdbc.Driver
mysql.url = jdbc:mysql://localhost:3306/mybatis?serverTimezone=UTC&\
characterEncoding=utf8&useUnicode=true&useSSL=false
mysql.username=root
mysql.password=123456
findTest.java
package Test;
import com.itheima.pojo.User;
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 org.junit.jupiter.api.Test;
import java.io.IOException;
import java.io.InputStream;
import java.io.Reader;
import java.util.List;
public class findTest {
// public static void main(String[] args) {
// userFindByIdTest();
// userFindAll();
// }
@Test
public void userFindByIdTest(){
String resources="mybatis-config.xml";
Reader reader=null;
try{
reader = Resources.getResourceAsReader(resources);
}catch (IOException e){
e.printStackTrace();
}
SqlSessionFactory sqlMapper=new SqlSessionFactoryBuilder().build(reader);
SqlSession session= sqlMapper.openSession();
User user=session.selectOne("findById",1);
System.out.println(""+user);
session.close();
}
@Test
public void testFindAll()throws IOException{
//获得核心配置文件
InputStream resourceAsStream = Resources.getResourceAsStream("mybatis-config.xml");
//获得session工厂对象
SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(resourceAsStream);
//获得session会话对象
SqlSession sqlSession = sqlSessionFactory.openSession();
//执行操作 参数
List<User> userList = sqlSession.selectList("com.itheima.pojo.User.findAll");
//打印数据
System.out.println(userList);
//释放资源
sqlSession.close();
}
@Test
public void testInsert()throws IOException{
//模拟user对象
User user = new User();
// user.setUid();在数据库里面会自增,不能写死了
user.setUage(26);
user.setUname("jyy");
user.setPosition("j");
//获得核心配置文件
InputStream resourceAsStream = Resources.getResourceAsStream("mybatis-config.xml");
//获得session工厂对象
SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(resourceAsStream);
//获得session会话对象
SqlSession sqlSession = sqlSessionFactory.openSession();
//执行操作 参数
sqlSession.insert("insertUser",user);
sqlSession.commit();
// System.out.println(user);
//执行更新操作要提交事务
//释放资源
sqlSession.close();
}
@Test
public void testUpdate()throws IOException{
//模拟user对象
User user = new User();
// 在数据库里面会自增,不能写死了
user.setUid(7);
user.setUage(26);
user.setUname("jyy");
user.setPosition("j");
//获得核心配置文件
InputStream resourceAsStream = Resources.getResourceAsStream("mybatis-config.xml");
//获得session工厂对象
SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(resourceAsStream);
//获得session会话对象
SqlSession sqlSession = sqlSessionFactory.openSession();
//执行操作 参数
sqlSession.update("updateUser",user);
sqlSession.commit();
// System.out.println(user);
//执行更新操作要提交事务
//释放资源
sqlSession.close();
}
@Test
public void testDelete()throws IOException{
//获得核心配置文件
InputStream resourceAsStream = Resources.getResourceAsStream("mybatis-config.xml");
//获得session工厂对象
SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(resourceAsStream);
//获得session会话对象
SqlSession sqlSession = sqlSessionFactory.openSession();
//执行操作 参数
sqlSession.delete("deleteUser",7);
sqlSession.commit();
sqlSession.close();
}
}
User.java
package com.itheima.pojo;
public class User {
private int uid;
private String uname;
private int uage;
private String eposition;
@Override
public String toString() {
return "User{" +
"uid=" + uid +
", uname='" + uname + '\'' +
", uage=" + uage +
", position='" + eposition + '\'' +
'}'+'\n';
}
public String getPosition() {
return eposition;
}
public void setPosition(String position) {
this.eposition = position;
}
public int getUid() {
return uid;
}
public void setUid(int uid) {
this.uid = uid;
}
public String getUname() {
return uname;
}
public void setUname(String uname) {
this.uname = uname;
}
public int getUage() {
return uage;
}
public void setUage(int uage) {
this.uage = uage;
}
}
巩固mybatis配置
创建工程
引入相关依赖
创建数据库
创建数据库连接信息配置文件
创建mybatis核心配置文件
创建实体相关的数据库表
在idea中创建实体
创建映射文件
修改配置文件
懒得再配置一次啦