目录
运行环境:IDEA 2022、JDK8+
数据库:mysql5.5 ,可视化工具:Navicat for MySQL
更详细请看mybatis中文网:
一、创建创建一个空的maven项目
二、pom中导入依赖
<dependencies>
<!-- 连接数据库的依赖 -->
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>8.0.30</version>
</dependency>
<!-- mybatis的框架依赖 -->
<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis</artifactId>
<version>3.5.10</version>
</dependency>
<!-- 测试程序用的依赖 -->
<dependency>
<groupId>junit</groupId>
<artifactId>junit</artifactId>
<version>4.12</version>
<scope>test</scope>
</dependency>
<!-- 便于编写实体类 -->
<dependency>
<groupId>org.projectlombok</groupId>
<artifactId>lombok</artifactId>
<version>1.18.26</version>
</dependency>
<dependencies>
三、准备数据库
1.新建一个表,表名设置为stu
2.添加测试用的数据(可随意一点)
四、IDEA中创建相应文件
1.创建pojo包,并且在包内创建对应数据库的实体类
代码:
@Data
@NoArgsConstructor
@AllArgsConstructor
public class Stu {
private Integer id;
private String name;
private Integer age;
}
2.在java和resources下创建mapper包
(1)在Java包(蓝色)下创建mapper包,并在包内创建相关接口。
代码:
public interface StuMapper {
List<Stu> selectAll();
}
(2)在resources包下创建mapper包,并在包内创建相关的xml文件(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="mapper.StuMapper">
<select id="selectAll" resultType="pojo.Stu">
select * from stu
</select>
</mapper>
3.在resources包内创建db.properties文件
代码:
db.driver=com.mysql.cj.jdbc.Driver
db.url=jdbc:mysql://localhost:3306/****?serverTimezone\
=UTC&characterEncoding=UTF-8&useSSL=true
db.username=****
db.password=****
4.创建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"/>
<environments default="development">
<environment id="development">
<transactionManager type="JDBC"/>
<dataSource type="POOLED">
<property name="driver" value="${db.driver}"/>
<property name="url" value="${db.url}"/>
<property name="username" value="${db.username}"/>
<property name="password" value="${db.password}"/>
</dataSource>
</environment>
</environments>
<mappers>
<package name="mapper"/>
</mappers>
</configuration>
五、编写相应的测试文件
在tese包-->java包下创建一个类
代码:
public class test01 {
@Test
public void test001() {
String resource = "mybatis-config.xml";
InputStream inputStream = null;
try {
inputStream = Resources.getResourceAsStream(resource);
} catch (IOException e) {
throw new RuntimeException(e);
}
SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);
SqlSession session = sqlSessionFactory.openSession();
StuMapper mapper = session.getMapper(StuMapper.class);
List<Stu> stus = mapper.selectAll();
System.out.println(stus);
session.close();
}
}
六、结果
点击调试,会显示出stu表中全部的数据