MyBatis快速入门
1.创建数据库
这里使用的是MySQL数据库
create database mybatis;
use mybatis;
drop table if exists tb_user;
create table tb_user(
id int primary key auto_increment,
username varchar(20),
password varchar(20),
gender char(1),
addr varchar(30)
);
INSERT INTO tb_user VALUES (1, '张三', '123', '男', '北京');
INSERT INTO tb_user VALUES (2, '李四', '456', '女', '上海');
INSERT INTO tb_user VALUES (3, '王五', '789', '男', '西安');
2.项目环境搭建
2.1打开idea创建一个新的maven项目:
2.2在pom.xml中导入mybatis、mysql和junit的坐标:
<dependencies>
<!--mybatis-->
<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis</artifactId>
<version>3.5.5</version>
</dependency>
<!--mysql-->
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>5.1.46</version>
</dependency>
<dependency>
<groupId>junit</groupId>
<artifactId>junit</artifactId>
<version>4.12</version>
</dependency>
</dependencies>
2.3创建实体类、配置文件以及测试类(如下图:):
User实体类:
public class User {
private Integer id;
private String username;
private String password;
private String gender;
private String addr;
// 此处省略getter、setter、toString
}
配置文件信息可以参考MyBatis官网文档来编写,也可以用下面的:
官网文档链接:https://mybatis.org/mybatis-3/zh/getting-started.html
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>
<environments default="development">
<environment id="development">
<transactionManager type="JDBC"/>
<!--配置数据源-->
<dataSource type="POOLED">
<property name="driver" value="com.mysql.jdbc.Driver"/>
<property name="url" value="jdbc:mysql://localhost:3306/mybatis?useSSL=false"/>
<!--数据库用户名-->
<property name="username" value="root"/>
<!--数据库密码-->
<property name="password" value="root"/>
</dataSource>
</environment>
</environments>
<mappers>
<!--加载UserMapper映射文件 resource指定映射文件路径-->
<mapper resource="UserMapper.xml"/>
</mappers>
</configuration>
UserMapper.xml:
<?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="test">
<select id="selectAll" resultType="com.fbst.pojo.User">
select * from tb_user;
</select>
</mapper>
3.测试
UserTest:
public class UserTest {
@Test
public void testSelectAll() throws IOException {
// 加载mybatis核心配置文件
InputStream is = Resources.getResourceAsStream("mybatis-config.xml");
SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(is);
SqlSession sqlSession = sqlSessionFactory.openSession();
// 调用方法
List<User> users = sqlSession.selectList("test.selectAll");
// 打印结果
for (User user : users) {
System.out.println(user);
}
// 释放资源
sqlSession.close();
}
}
控制台打印结果:
4.Mapper代理开发
4.1首先在main文件夹下创建UserMapper接口,把resources文件夹下的UserMapper.xml放在和UserMapper同一个文件夹中,因为编译原因我们直接在resources文件夹下创建预支对应的文件夹层级或者时直接把UserMapper.xml放在pojo包下(不管哪种方式,记得在mybatis核心配置文件mybatis-config.xnl中修改UserMapepr.xml的文件路径),这里我们采用第一种方式如下图:
4.2创建UserMapper接口
public interface UserMapper {
// 查询所有用户信息
List<User> selectAll();
}
4.3修改mybatis核心配置文件mybatis-config.xml中的配置信息
<mappers>
<!--加载UserMapper映射文件 resource指定映射文件路径-->
<!-- <mapper resource="UserMapper.xml"/>-->
<mapper resource="com/fbst/mapper/UserMapper.xml"/>
</mappers>
4.4修改映射文件UserMapper.xml配置信息
<mapper namespace="com.fbst.mapper.UserMapper">
<select id="selectAll" resultType="com.fbst.pojo.User">
select * from tb_user;
</select>
</mapper>
4.5修改测试代码
public class UserTest {
@Test
public void testSelectAll() throws IOException {
// 加载mybatis核心配置文件
InputStream is = Resources.getResourceAsStream("mybatis-config.xml");
SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(is);
SqlSession sqlSession = sqlSessionFactory.openSession();
// 获取Mapper代理对象
UserMapper mapper = sqlSession.getMapper(UserMapper.class);
// 调用方法
// List<User> users = sqlSession.selectList("test.selectAll");
List<User> users = mapper.selectAll();
// 打印结果
for (User user : users) {
System.out.println(user);
}
// 释放资源
sqlSession.close();
}
}
控制台打印结果: