SpringBoot整合Mybatis XML形式
项目创建我就不演示了,我将项目需要的依赖列出来:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21
| <dependency> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter-web</artifactId> </dependency> <dependency> <groupId>org.mybatis.spring.boot</groupId> <artifactId>mybatis-spring-boot-starter</artifactId> <version>2.1.2</version> </dependency> <dependency> <groupId>com.alibaba</groupId> <artifactId>druid-spring-boot-starter</artifactId> <version>1.1.10</version> </dependency> <dependency> <groupId>mysql</groupId> <artifactId>mysql-connector-java</artifactId> <scope>runtime</scope> <version>5.1.27</version> </dependency>
|
数据库的配置:application.properties
1 2 3 4 5
| #替换成你自己的即可 spring.datasource.username=root spring.datasource.password=123456 spring.datasource.url=jdbc:mysql://localhost:3306/bigjava18?userUnicode=true&characterEncoding=UTF-8 spring.datasource.type=com.alibaba.druid.pool.DruidDataSource
|
配置好数据库后,接下来我们定义一个实体类:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42
| /** * @author xhq * @date 2020/5/5 8:52 */ public class User { private int id; private String username; private String address;
@Override public String toString() { return "User{" + "id=" + id + ", username='" + username + '\'' + ", address='" + address + '\'' + '}'; }
public int getId() { return id; }
public void setId(int id) { this.id = id; }
public String getUsername() { return username; }
public void setUsername(String username) { this.username = username; }
public String getAddress() { return address; }
public void setAddress(String address) { this.address = address; } }
|
接下来呢定义一个mapper;
创建一个UserMapper接口:
1 2 3 4 5
| public interface UserMapper {
List<User> getAllUser();
}
|
定义完之后我们就需要来创建 UserMapper.XML了,将相应的地址填写成你自己的即可
1 2 3 4 5 6 7 8 9
| <?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="cn.m5f.springbootmyabtis.mapper.UserMapper"> <select id="getAllUser" resultType="cn.m5f.springbootmyabtis.entil.User"> select * from user; </select> </mapper>
|
项目目录:
在这些都创建完成之后,我们创建UserController
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15
| /** * @author xhq * @date 2020/5/5 8:58 */
@RestController public class MyController { @Autowired UserMapper userMapper;
@GetMapping("/hello") public List<User> selectUser(){ return userMapper.getAllUser(); } }
|
最后别忘了在主配置类中添加:
@MapperScan(basePackages =”cn.m5f.springbootmyabtis”(替换成你自己的路径哟)
(将你写的Myabtis扫描进去)
接下来让我们来运行一下吧:
项目我已经上传到Git上,需要的同学可以去下载:https://github.com/xionghuaqiang/cn.m5f