Mybatis最小化环境创建

---

Maven下的Mybatis最小化环境创建

---

总览：mybatis最小化环境的项目结构

1.pom.xml

引入mybatis的相关依赖库&日志log4j依赖库

<dependency>
	<groupId>org.mybatis</groupId>
	<artifactId>mybatis</artifactId>
	<version>3.4.6</version>
</dependency>
<!-- https://mvnrepository.com/artifact/org.mybatis/mybatis-spring -->
<dependency>
	<groupId>org.mybatis</groupId>
	<artifactId>mybatis-spring</artifactId>
	<version>1.3.2</version>
</dependency>
<!-- https://mvnrepository.com/artifact/log4j/log4j -->
<dependency>
	<groupId>log4j</groupId>
	<artifactId>log4j</artifactId>
	<version>1.2.17</version>
</dependency>

2.student.java

创建一个student的entity类

package net.dfrz.entity;

import java.util.Date;

public class Student
{
	private String stuID;
	private String name;
	private Date birthday;
	private String sex;
	public Student() {
	}
	public Student(String stuID, String name, Date birthday, String sex) {
		this();
		this.stuID = stuID;
		this.name = name;
		this.birthday = birthday;
		this.sex = sex;
	}
	public String getStuID() {
		return stuID;
	}
	public void setStuID(String stuID) {
		this.stuID = stuID;
	}
	public String getName() {
		return name;
	}
	public void setName(String name) {
		this.name = name;
	}
	public Date getBirthday() {
		return birthday;
	}
	public void setBirthday(Date birthday) {
		this.birthday = birthday;
	}
	public String getSex() {
		return sex;
	}
	public void setSex(String sex) {
		this.sex = sex;
	}
}

3.StudentMapper.java

抽象DAO方法接口，类似于以前的StudentDAOI

package net.dfrz.mapper;

import net.dfrz.entity.Student;

public interface StudentMapper 
{
	int insertStudent(Student student);
	int deleteStudentById(String stuID);
	int updateStudentById(Student student);
	Student selectStudentById(String stuID);
}

4.mysql.properties

jdbc.driverClass=com.mysql.jdbc.Driver
jdbc.url=jdbc:mysql://localhost:3306/mybatis?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC
jdbc.username=root
jdbc.password=123456

5.student.xml 类似于 DAOImpl

特别重要！做到两个对应！mybatis可以自动匹配相同的名字！

1.命名空间 <mapper namespace=“net.dfrz.mapper.StudentMapper”>一定要和StudentMapper.java的这个抽象接口对应！！

2.id的值一定要和接口里得方法名对应！！

<?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">
  
  <!-- namespace：命名空间，做sql隔离 -->
<mapper namespace="net.dfrz.mapper.StudentMapper">
	
	<!-- 
		id:sql语句唯一标识
		parameterType:指定传入参数类型（不是数据库中的类型）
		resultType:返回结果集类型
		#{}:占位符，如果传入的类型是基本类型（String,long,double,int,boolean,float等），那么#{}中变量名称可以任意
	 -->
	
	<!-- 插入数据 -->
	<insert id="insertStudent" parameterType="net.dfrz.entity.Student">
		insert into t_student(stuid,name,birthday,sex) values(#{stuID},#{name},#{birthday},#{sex})
	</insert>
	
	<!-- 删除 -->
	<delete id="deleteStudentById" parameterType="string" >
		delete from t_student where stuid = #{stuID}
	</delete>
	
	<!-- 修改 -->
	<update id="updateStudentById" parameterType="net.dfrz.entity.Student">
		update t_student set name=#{name} where stuid = #{stuID}
	</update>
	
	<!-- 约定大于配置 -->
	<!-- 查询 -->
	<select id="selectStudentById" parameterType="string" resultType="student">
		select * from t_student where stuid = #{stuid}
	</select>
	
</mapper>

6.config.xml

将student.xml导入mappers，这个步骤有点类似ServiceImpl的作用。

<mappers>
	<mapper resource="mybatis/mapper/Student.xml" />
</mappers>

以下是完整的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="mybatis/db/mysql.properties"></properties>
	
	<!-- 设置包扫描 -->
	<typeAliases>
		<package name="net.dfrz.entity" />
	</typeAliases>
	
	<!-- unknown参数,后面会更新 -->
	<plugins>
		<plugin interceptor="com.github.pagehelper.PageHelper">
			<property name="dialect" value="mysql" />
			<property name="offsetAsPageNum" value="false" />
			<property name="rowBoundsWithCount" value="true" />
			<property name="pageSizeZero" value="true" />
			<property name="reasonable" value="false" />
			<property name="supportMethodsArguments" value="false" />
			<property name="returnPageInfo" value="none" />
		</plugin>
	</plugins>

	<!-- 配置信息 -->
	<environments default="development">
		<environment id="development">
			<transactionManager type="JDBC" />
			<dataSource type="POOLED">
				<!-- 配置连接信息 -->
				<property name="driver" value="${jdbc.driverClass}" />
				<property name="url"
					value="${jdbc.url}" />
				<property name="username" value="${jdbc.username}" />
				<property name="password" value="${jdbc.password}" />
			</dataSource>
		</environment>
	</environments>

	<!-- 配置映射文件：用来配置SQL语句和结果及类型等 -->
	<mappers>
		<mapper resource="mybatis/mapper/Student.xml" />
	</mappers>
</configuration>

7.TestStudentMapper.java

这个就类似于servlet层调用serviceImpl方法,获取studentMapper类我理解为类似获取了ServiceImpl的类，然后用这个类再继续调用内部的方法，层层下去。

StudentMapper studentMapper=sqlSession.getMapper(StudentMapper.class);

温馨提醒：测试的时候记得选择变量名就可以只测试该方法！

---

package net.dfrz.test;

import java.io.InputStream;
import java.io.Reader;
import java.util.Date;

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.Test;

import net.dfrz.entity.Student;
import net.dfrz.mapper.StudentMapper;

public class TestStudentMapper
{
	@Test
	public void testInsertUser() throws Exception{
		//读取配置文件
		String resource="mybatis/config.xml";
		InputStream inputStream =Resources.getResourceAsStream(resource);
		
		//创建sessionFactory
		SqlSessionFactory sqlSessionFactory=new SqlSessionFactoryBuilder().build(inputStream);
		
		//创建会话
		SqlSession sqlSession=sqlSessionFactory.openSession();
		
		StudentMapper studentMapper=sqlSession.getMapper(StudentMapper.class);
		//创建student对象
		Student student = new Student("s001","李四",new Date(),"男");
		
		studentMapper.insertStudent(student);
		//提交SQL
		sqlSession.commit();
		//测试是否成功取得student
		System.out.println(student.getStuID());
		//关闭会话
		sqlSession.close();
	}
}

8.配置日志文件

这个名字不要随便乱改！

log4j.properties

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=%-5p - %m%n

然后开始测试，记得要配置数据库哦！

create database mybatis; 

DROP TABLE IF EXISTS `t_student`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
 SET character_set_client = utf8mb4 ;
CREATE TABLE `t_student` (
  `stuid` varchar(256) NOT NULL,
  `name` varchar(45) DEFAULT NULL,
  `birthday` date DEFAULT NULL,
  `sex` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`stuid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

配置完成，运行成功！