Mybatis快速上手1 Mybatis的CRUD操作

其他章节及开发包：https://blog.csdn.net/XIMAX/article/details/106255196

环境 ：Eclipse+Tomcat9+JDK10+Mybatis-3.1.1、Navicat

test1~8分别对应八章，本章使用包test1、tool，文件config.xml、db.properties、log4j.properties

代码

建库，建表

create database mybatis;
use mybatis;
CREATE TABLE users(id INT PRIMARY KEY AUTO_INCREMENT, NAME VARCHAR(20), age INT);
INSERT INTO users(NAME, age) VALUES('Tom', 12);
INSERT INTO users(NAME, age) VALUES('Jack', 11);

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"></properties>
	 <typeAliases>
 		 <package name="com.rjxy.test1"/>
	<typeAliases>
	
	<environments default="development">
	  <environment id="development">
	   <transactionManager type="JDBC" />
	   <dataSource type="POOLED">
	    <property name="driver" value="${driver}" />
	    <property name="url" value="${url}" />
	    <property name="username" value="${username}" />
	    <property name="password" value="${password}" />
	   </dataSource>
	  </environment>
	 </environments>		
	
	<mappers>
	  <mapper resource="com/rjxy/test1/userMapper.xml"/>
	<mappers>
</configuration>

db.properties

com.mysql.cj.jdbc.Driver : 这里使用的tomcat9版本需要加 cj，否则会报错

driver=com.mysql.cj.jdbc.Driver
url=jdbc:mysql://localhost:3306/mybatis?serverTimezone=UTC
username=root
password=1234

log4j.properties

log4j.properties\uFF0C
log4j.rootLogger=DEBUG, Console
#Console
log4j.appender.Console=org.apache.log4j.ConsoleAppender
log4j.appender.Console.layout=org.apache.log4j.PatternLayout
log4j.appender.Console.layout.ConversionPattern=%d [%t] %-5p [%c] - %m%n
log4j.logger.java.sql.ResultSet=INFO
log4j.logger.org.apache=INFO
log4j.logger.java.sql.Connection=DEBUG
log4j.logger.java.sql.Statement=DEBUG
log4j.logger.java.sql.PreparedStatement=DEBUG

MyBatisUtils.java

package com.rjxy.tool;
import java.io.IOException;
import java.io.Reader;
import org.apache.ibatis.io.Resources;
import org.apache.ibatis.session.SqlSessionFactory;
import org.apache.ibatis.session.SqlSessionFactoryBuilder;
public class MybatisUtils {
	public static SqlSessionFactory getFactory() throws IOException {
	  String resource = "config.xml";
	  Reader reader =  Resources.getResourceAsReader(resource);
	  SqlSessionFactory sessionfactory = new SqlSessionFactoryBuilder().build(reader);
	  return sessionfactory;
	 }
}

userMapper.xml

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" 
"http://mybatis.org/dtd/mybatis-3-mapper.dtd"> 
<mapper namespace="com.rjxy.test1.userMapper">
<insert id="insertUser" parameterType="User">
  insert into users(name, age) values(#{name}, #{age});
 </insert>
 
 <delete id="deleteUser" parameterType="int">
  delete from users where id=#{id}
 </delete>
 
 <update id="updateUser" parameterType="User">
  update users set name=#{name},age=#{age} where id=#{id}
 </update>
 
 <select id="selectUser" parameterType="int" resultType="User">
  select * from users where id=#{id}
 </select>
 
 <select id="selectAllUsers" resultType="User">
  select * from users
 </select>
</mapper>

User.java

package com.rjxy.test1;
public class User {
 private int id;
 private String name;
 private int age;
 //省略 get、set及 toString 方法
}

JTest.java

每个test方法均可使用，由于插入和查询的先后问题先注释了部分方法来查看结果

package com.rjxy.test1;
import java.io.IOException;
import java.io.Reader;
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 com.rjxy.tool.MybatisUtils;
class JTest {
@Test
 public void test1() throws IOException {
 SqlSessionFactory sessionfactory = MybatisUtils.getFactory();
  SqlSession session = sessionfactory.openSession();
  
  String statement = "com.rjxy.test1.userMapper.selectUser";
  
  User user = session.selectOne(statement,2);
  System.out.println(user);
  session.close();
 }
 @Test
 public void test3() throws IOException{
  SqlSessionFactory factory = MybatisUtils.getFactory();
  SqlSession session = factory.openSession();
  
  String statement = "com.rjxy.test1.userMapper.updateUser";
  
  User user = new User();
  user.setAge(13);
  user.setName("Tom");
  user.setId(1);
  
  session.update(statement, user);
  session.commit();
  session.close();
 }
 // @Test
// public void test4() throws IOException{
//  SqlSessionFactory factory = MybatisUtils.getFactory();
//  SqlSession session = factory.openSession();
//  
//  String statement = "com.rjxy.test1.userMapper.deleteUser";
//  
//  User user = new User();
//  user.setId(3);
//  
//  session.delete(statement,user);
//  session.commit();
//  session.close();
// }
@Test
 public void test5() throws IOException{
  SqlSessionFactory factory = MybatisUtils.getFactory();
  SqlSession session = factory.openSession();
  
  String statement = "com.rjxy.test1.userMapper.selectAllUsers";
  
  System.out.println(session.selectList(statement));
  session.close();
 }
 // @Test
// public void test2() throws IOException{
//  SqlSessionFactory factory = MybatisUtils.getFactory();
//  SqlSession session = factory.openSession();
//  String statement = "com.rjxy.test1.userMapper.insertUser";
//  
//  User user = new User();
//  user.setName("李四");
//  user.setAge(22);
//  user.setId(3);
//  session.update(statement, user);
//  session.commit();
//  session.close();
// } 
}

结果

2020-05-20 22:24:53,208 [main] DEBUG [com.rjxy.test1.userMapper.selectUser] - ooo Using Connection [com.mysql.cj.jdbc.ConnectionImpl@306851c7]
2020-05-20 22:24:53,208 [main] DEBUG [com.rjxy.test1.userMapper.selectUser] - ==>  Preparing: select * from users where id=? 
2020-05-20 22:24:53,282 [main] DEBUG [com.rjxy.test1.userMapper.selectUser] - ==> Parameters: 2(Integer)
User [id=2, name=Jack, age=11]
2020-05-20 22:24:53,645 [main] DEBUG [com.rjxy.test1.userMapper.updateUser] - ooo Using Connection [com.mysql.cj.jdbc.ConnectionImpl@1536602f]
2020-05-20 22:24:53,645 [main] DEBUG [com.rjxy.test1.userMapper.updateUser] - ==>  Preparing: update users set name=?,age=? where id=? 
2020-05-20 22:24:53,645 [main] DEBUG [com.rjxy.test1.userMapper.updateUser] - ==> Parameters: Tom(String), 13(Integer), 1(Integer)
2020-05-20 22:24:53,901 [main] DEBUG [com.rjxy.test1.userMapper.selectAllUsers] - ooo Using Connection [com.mysql.cj.jdbc.ConnectionImpl@5241cf67]
2020-05-20 22:24:53,901 [main] DEBUG [com.rjxy.test1.userMapper.selectAllUsers] - ==>  Preparing: select * from users 
2020-05-20 22:24:53,901 [main] DEBUG [com.rjxy.test1.userMapper.selectAllUsers] - ==> Parameters: 
[User [id=1, name=Tom, age=13], User [id=2, name=Jack, age=11], User [id=5, name=李四, age=22]]