springboot项目集成mybatis
之间写过一篇 最全的Spring-Boot集成Mybatis-Plus教程
突然发现不会配置单纯的mybatis了，稍微折腾了一下
创建项目
创建springboot项目，只选择mybatis和mysql两个依赖
pom.xml
<dependencies>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter</artifactId>
</dependency>
<dependency>
<groupId>org.mybatis.spring.boot</groupId>
<artifactId>mybatis-spring-boot-starter</artifactId>
<version>2.1.1</version>
</dependency>
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<scope>runtime</scope>
</dependency>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-test</artifactId>
<scope>test</scope>
</dependency>
</dependencies>
数据库配置
数据源配置
spring:
datasource:
url: jdbc:mysql://192.168.16.87:3306/pybbs?useSSL=false&characterEncoding=utf8&serverTimezone=Asia/Shanghai
username: root
password: 123123
表结构及数据
CREATE TABLE `user` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `username` varchar(255) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
表数据
INSERT INTO `user` (`id`, `username`) VALUES (1, 'tomoya'), (2, '朋也');
实体类mapper
User.java
public class User {
private Integer id;
private String username;
public Integer getId() {
return id;
}
public void setId(Integer id) {
this.id = id;
}
public String getUsername() {
return username;
}
public void setUsername(String username) {
this.username = username;
}
@Override
public String toString() {
return "User{" +
"id=" + id +
", username='" + username + '/'' +
'}';
}
}
文链接原: https://tomoya92.github.io/2019/10/29/spring-boot-mybatis/
UserMapper.java
@Mapper
public interface UserMapper {
// 注解方式查询
@Select("select * from user;")
List<User> selectAll();
// xml方式查询
List<User> selectAllWithXml();
}
UserMapper.xml 注意：这个xml文件我放在了 src/resources/mapper/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="com.example.multipledatasource.mapper.UserMapper">
<resultMap id="baseResultMap" type="com.example.multipledatasource.model.User">
<result column="id" property="id"/>
<result column="username" property="username"/>
</resultMap>
<select id="selectAllWithXml" resultMap="baseResultMap">
select *
from user;
</select>
</mapper>
最后配置启动时扫描 *Mapper.xml 文件
application.yml
mybatis: mapper-locations: classpath:mapper/*Mapper.xml
测试
@SpringBootTest
public class MultipleDatasourceApplicationTests {
@Autowired
private UserMapper userMapper;
@Test
void contextLoads() {
List<User> users = userMapper.selectAll();
for (User user : users) {
System.out.println(user.toString());
}
System.out.println("=========================");
List<User> users1 = userMapper.selectAllWithXml();
for (User user : users1) {
System.out.println(user.toString());
}
}
}
运行结果
User{id=1, username='tomoya'}
User{id=2, username='朋也'}
=========================
User{id=1, username='tomoya'}
User{id=2, username='朋也'}
原文链接:
正文到此结束
- 本文标签： 2019 GitHub mybatis db mapper sql XML root src https JDBC IDE BaseResultMap tab Property cat Select example java git springboot 数据 list classpath ACE 数据库 App dataSource spring ip id 配置 value 测试 Word tar CTO dependencies mysql pom IO map key ssl http
- 版权声明： 本文为互联网转载文章，出处已在文章中说明(部分除外)。如果侵权，请联系本站长删除，谢谢。
- 本文海报： 生成海报一 生成海报二
热门推荐
相关文章
Loading...
![[HBLOG]公众号](https://www.liuhaihua.cn/img/qrcode_gzh.jpg)
