1.Mybatis是一个基于java的持久层框架,支持自定义SQL,存储过程和高级映射;它对原有的JDBC操作进行了封装,因此我们只需要关注SQL本身;Mybatis可以通过XML或者Annotation来配置执行SQL,并且自动完成ORM操作,并将执行结果返回。
2.Mybatis框架的配置
1)首先,我们先创建一个Maven项目,在pom.xml下导入我们所要用到的依赖:mybatis,druid,mysql;这三个主要依赖。
<!-- https://mvnrepository.com/artifact/org.mybatis/mybatis -->
<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis</artifactId>
<version>3.5.6</version>
</dependency>
<!-- https://mvnrepository.com/artifact/mysql/mysql-connector-java -->
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>8.0.25</version>
</dependency>
<!-- https://mvnrepository.com/artifact/com.alibaba/druid -->
<dependency>
<groupId>com.alibaba</groupId>
<artifactId>druid</artifactId>
<version>1.2.6</version>
</dependency>
<dependency>
<groupId>junit</groupId>
<artifactId>junit</artifactId>
<version>4.12</version>
<scope>test</scope>
</dependency>
</dependencies>
2)在java文件下创建com.xxx.pojo和com.xxx.dao存放实体类和对应的Dao层下的接口
注意:实体类文件要遵循JavaBean规范
例如:实体类:User
package com.qfedu.pojo;
import java.io.Serializable;
public class User implements Serializable {
private Integer id;
private String name;
private String password;
public User() {
}
public Integer getId() {
return id;
}
public void setId(Integer id) {
this.id = id;
}
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
public String getPassword() {
return password;
}
public void setPassword(String password) {
this.password = password;
}
@Override
public String toString() {
return "User{" +
"id=" + id +
", name='" + name + '\'' +
", password='" + password + '\'' +
'}';
}
}
Dao层下的:UserDao 接口
package com.qfedu.dao;
import com.qfedu.pojo.User;
public interface UserDao {
//通过id查询
User findById(Integer id);
}
3)在resources文件夹下创建db.properties外部文件,并且在java文件下创建com.xxx.datasource文件夹创建DruidDataSourceFactory连接池工厂
例如:db.properties外部文件
username=root
password=123456
url=jdbc:mysql://localhost:3306/java2109?serverTimezone=Asia/Shanghai
driverClassName=com.mysql.cj.jdbc.Driver
上面的username=自己数据库的名字;password=自己数据的密码;url中java2109改为自己数据库中的所需要的;driverClassName的配置要注意:导入的依赖是低版本的上述内容不加cj,高版本如上图;
DruidDataSourceFactory连接池工厂:
package com.qfedu.datasource;
import com.alibaba.druid.pool.DruidDataSource;
import org.apache.ibatis.datasource.pooled.PooledDataSourceFactory;
public class DruidDataSourceFactory extends PooledDataSourceFactory {
public DruidDataSourceFactory(){
this.dataSource=new DruidDataSource();
}
}
4)在resources文件下再创建一个mybatis-config.xml文件,这个文件包含了mybatis框架的核心设置,如获取数据库连接实例的数据源以及决定事务作用域和控制方式的事务管理
<?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.qfedu.pojo"/>
</typeAliases>
<!--配置环境-->
<environments default="development">
<environment id="development">
<transactionManager type="JDBC"/>
改回来就好
<dataSource type="com.qfedu.datasource.DruidDataSourceFactory">
<property name="driverClassName" value="${driverClassName}"/>
<property name="url" value="${url}"/>
<property name="username" value="${username}"/>
<property name="password" value="${password}"/>
</dataSource>
</environment>
</environments>
<mappers>
<package name="com.qfedu.dao"/>
</mappers>
</configuration>
5)在resources文件夹下创建com.xxx.dao文件夹,并且创建一个Mapper配置文件——UserDao.xml
注意:这个文件所在位置与dao层文件夹名字相同
<?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.qfedu.dao.UserDao">
<resultMap id="userMap" type="User">
<id property="id" column="id"></id>
<result property="name" column="name"></result>
<result property="password" column="password"></result>
</resultMap>
<!-- <!–开启二级缓存–>-->
<cache></cache>
<sql id="baseSql" >
select id,name,password from user
</sql>
<!--通过id查询-->
<select id="findById" resultMap="userMap">
<include refid="baseSql"></include>
where id=#{id}
</select>
</mapper>
6)在测试文件下创建测试类进行测试:
其中在第四项调用dao接口时,填入自己的dao接口,第五项调用自己dao接口下的方法
package com.qfedu.test;
import com.qfedu.dao.UserDao;
import com.qfedu.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.Test;
import java.io.IOException;
import java.io.InputStream;
public class MyBatisTest {
//通过id查询
@Test
public void test1() throws IOException {
//1.读取配置文件
InputStream resourceAsStream = Resources.getResourceAsStream("mybatis-config.xml");
//2.创建SqlSession工厂
SqlSessionFactoryBuilder sqlSessionFactoryBuilder = new SqlSessionFactoryBuilder();
SqlSessionFactory factory = sqlSessionFactoryBuilder.build(resourceAsStream);
//3.使用工厂创建SqlSession对象
SqlSession sqlSession = factory.openSession();
//4.使用sqlSession创建Dao接口代理对象
UserDao userDao = sqlSession.getMapper(UserDao.class);
//5.使用代理对象调用方法
User user = userDao.findById(2);
//6.关闭缓冲
sqlSession.close();
resourceAsStream.close();
}