MyBatis框架，简单配置流程

ゝ一世哀愁。 2024-04-17 05:26 73阅读 0赞

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

先看下项目的整体目录：

![20190822105343822.png][]

上项目：

### 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][https_pan.baidu.com_s_1lJUOTggzviw7Ag5riypJ6g]

![20190822110814993.png][]

### **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>
    
    	
    	<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）
 *  最后进行测试

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzE5MjYwMDMz_size_16_color_FFFFFF_t_70][]

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

**完整项目下载地址**：[https://pan.baidu.com/s/1LnRY0yN9gfhQOuwXJdUurA][https_pan.baidu.com_s_1LnRY0yN9gfhQOuwXJdUurA]

[20190822105343822.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/11/38a39300c25f4fe799b64bc38b0994e3.png
[https_pan.baidu.com_s_1lJUOTggzviw7Ag5riypJ6g]: https://pan.baidu.com/s/1lJUOTggzviw7Ag5riypJ6g
[20190822110814993.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/11/9094d51ad12447a690ef34c4a769884d.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzE5MjYwMDMz_size_16_color_FFFFFF_t_70]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/11/53f7ab726fbb406982568025fc042292.png
[https_pan.baidu.com_s_1LnRY0yN9gfhQOuwXJdUurA]: https://pan.baidu.com/s/1LnRY0yN9gfhQOuwXJdUurA