MyBatis框架，简单配置流程

MyBatis： 是支持普通 SQL 查询,存储过程和高级映射的优秀持久层框架

先看下项目的整体目录：

上项目：

1、创建表结构

CREATE TABLE `people` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(10) DEFAULT NULL,
  `age` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8

2、导入jar包

下载地址：https://pan.baidu.com/s/1lJUOTggzviw7Ag5riypJ6g

3、配置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>
	<!-- 别名 -->
	<typeAliases>
		<typeAlias type="com.fzx.Entity.People" alias="People" />
	</typeAliases>

	<!-- 环境配置 -->
	<environments default="mysql">
		<environment id="mysql">
			<!-- 事务管理 -->
			<transactionManager type="JDBC"></transactionManager>

			<!-- 连接配置 -->
			<dataSource type="POOLED">
				<property name="driver" value="com.mysql.jdbc.Driver"></property>
				<property name="url" value="jdbc:mysql://127.0.0.1:3306/test"></property>
				<property name="username" value="root"></property>
				<property name="password" value="root"></property>
			</dataSource>
		</environment>
	</environments>

	<!-- SQL文件映射配置 -->
	<mappers>
		<mapper resource="mapping/People.xml" />
	</mappers>
</configuration>

4、写表People的一个SQL映射文件

只写了一个表数据的查询sql，后期大家可以自己再写增、删、改SQL+接口

<?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.fzx.Service.PeopleService">
	<select id="getAllData" resultType="People">
		select * from people
	</select>
</mapper>

5、新建一个People的接口以及接口的实现类

5.1 在此之前，我们的得先获取处理数据库的会话工厂，所以我们先创建一个公共类：MySQLDao

package com.fzx.Dao;

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

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

public class MySQLDao {
	private static SqlSessionFactory sqlSessionFactory;

	static {
		try {
			InputStream is = Resources.getResourceAsStream("mybatis-config.xml");
			sqlSessionFactory = new SqlSessionFactoryBuilder().build(is);
		} catch (IOException e) {
			e.printStackTrace();
		}
	}

	public static SqlSessionFactory getSqlSessionFactory() {
		return sqlSessionFactory;
	}

	public static SqlSession getSqlSession() {
		return sqlSessionFactory.openSession();
	}
}

5.2 然后封装下会话里面的增、删、改、查基本操作，创建类：Dao

package com.fzx.Dao;

import java.util.List;
import java.util.Map;

import org.apache.ibatis.session.SqlSession;

public class Dao {
	private SqlSession sqlSession = MySQLDao.getSqlSession();

	public Object selectOne(String methodName, Map map) {
		return sqlSession.selectOne(methodName, map);
	}

	public List selectList(String methodName, Map map) {
		return sqlSession.selectList(methodName, map);
	}
}

5.3 创建Service接口：PeopleService

package com.fzx.Service;

import java.util.List;

import com.fzx.Entity.People;

public interface PeopleService {
	public List<People> getAllData();
}

5.4 创建Service接口实现：PeopleServiceImpl

package com.fzx.Service;

import java.util.List;

import com.fzx.Dao.Dao;
import com.fzx.Entity.People;

public class PeopleServiceImpl implements PeopleService {

	private Dao dao = new Dao();

	@SuppressWarnings("unchecked")
	@Override
	public List<People> getAllData() {
		return dao.selectList("getAllData", null);
	}

}

5.5 忘记了，还得创建一个实体类：People

package com.fzx.Entity;

public class People {
	private int id;
	private String name;
	private int age;

	public int getId() {
		return id;
	}

	public void setId(int id) {
		this.id = id;
	}

	public String getName() {
		return name;
	}

	public void setName(String name) {
		this.name = name;
	}

	public int getAge() {
		return age;
	}

	public void setAge(int age) {
		this.age = age;
	}

	@Override
	public String toString() {
		return "People [id=" + id + ", name=" + name + ", age=" + age + "]";
	}

}

5.6 开始写测试方法（提示：需要引入junit包）

package com.fzx.test;

import org.junit.jupiter.api.Test;

import com.fzx.Service.PeopleService;
import com.fzx.Service.PeopleServiceImpl;

public class T1 {
	@Test
	public void t1() {
		PeopleService peopleService = new PeopleServiceImpl();
		System.out.println(peopleService.getAllData());
	}
}

5.7 查看测试结果

结果正确，大功告成，这个只是单独的mybatis配置，流程很清晰明了：

• mybatis-config.xml
• 写SQL映射文件（People.xml）
• 写入公共方法，进一步封装Dao层，便于后面操作数据库直接调用（MySQLDao.java， Dao.java）
• 写实体类（People.java）
• 写Service接口+实现类（PeopleService.java， PeopleServiceImpl.java）
• 最后进行测试

题外话：mybatis配置完成后，可以融入spring+SpringMVC框架，最后构建一个完成的小项目出来

完整项目下载地址：https://pan.baidu.com/s/1LnRY0yN9gfhQOuwXJdUurA