springboot如何配置web项目请参考前一章,在此基础上集成mybatis。
在pom文件中添加mybatis的依赖:
1
2
3
4
5
|
< dependency > < groupId >org.mybatis.spring.boot</ groupId > < artifactId >mybatis-spring-boot-starter</ artifactId > < version >1.2.0</ version > </ dependency > |
添加mysql驱动:
1
2
3
4
|
< dependency > < groupId >mysql</ groupId > < artifactId >mysql-connector-java</ artifactId > </ dependency > |
添加druid和fastjson依赖,使用阿里巴巴druid连接池
1
2
3
4
5
6
7
8
9
10
|
< dependency > < groupId >com.alibaba</ groupId > < artifactId >druid</ artifactId > < version >1.0.28</ version > </ dependency > < dependency > < groupId >com.alibaba</ groupId > < artifactId >fastjson</ artifactId > < version >1.2.30</ version > </ dependency > |
配置数据源,在application.yml中:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
|
spring: datasource: name: test url: jdbc:mysql://127.0.0.1:3306/test username: root password: 111111 # 使用druid数据源 type: com.alibaba.druid.pool.DruidDataSource driver-class-name: com.mysql.jdbc.Driver filters: stat maxActive: 20 initialSize: 1 maxWait: 60000 minIdle: 1 timeBetweenEvictionRunsMillis: 60000 minEvictableIdleTimeMillis: 300000 validationQuery: select 'x' testWhileIdle: true testOnBorrow: false testOnReturn: false poolPreparedStatements: true maxOpenPreparedStatements: 20 |
设置mybatis的mapper和model扫描路径:
1
2
3
4
|
mybatis: mapperLocations: classpath:mapper/*.xml typeAliasesPackage: com.yingxinhuitong.demo.model #更多配置请参见:http://www.mybatis.org/spring-boot-starter/mybatis-spring-boot-autoconfigure/ |
接下来我们新建userMapper.xml,UserEntity以及UserDao:
UserEntity.class
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
|
package com.yingxinhuitong.demo.model; /** * Created by jack on 2017/4/20. */ public class UserEntity { private Long id; private String username; private String password; public Long getId() { return id; } public void setId(Long id) { this .id = id; } public String getUsername() { return username; } public void setUsername(String username) { this .username = username; } public String getPassword() { return password; } public void setPassword(String password) { this .password = password; } } |
UserDao
1
2
3
4
5
6
7
8
9
10
11
12
13
14
|
package com.yingxinhuitong.demo.dao; import com.yingxinhuitong.demo.model.UserEntity; import org.apache.ibatis.annotations.Mapper; import java.util.List; /** * Created by jack on 2017/4/20. */ @Mapper public interface UserDao { List<UserEntity> searchAll(); } |
UserMapper.xml
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
|
<? 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.yingxinhuitong.demo.dao.UserDao" > <!-- 字段与实体的映射 --> < resultMap id = "BaseResultMap" type = "com.yingxinhuitong.demo.model.UserEntity" > < id column = "id" property = "id" jdbcType = "BIGINT" /> < result column = "username" property = "username" jdbcType = "VARCHAR" /> < result column = "password" property = "password" jdbcType = "VARCHAR" /> </ resultMap > <!-- 根据条件查询,全部 --> < select id = "searchAll" resultMap = "BaseResultMap" > select * from tab_user </ select > </ mapper > |
创建一个控制器,注入UserDao,测试一下可不可以查询数据了:
1
2
3
4
5
6
7
8
9
10
11
12
13
|
@RestController public class TestController { @Resource UserDao userDao; @RequestMapping ( "/getusers" ) public String test() { List<UserEntity> users = userDao.searchAll(); String usersJson = JSON.toJSONString(users); return usersJson; } } |
运行Application.class,启动成功后访问:http://localhost:9000/demo/getusers,输出内容如下:
[{"id":1,"password":"000000","username":"test"},{"id":2,"password":"111111","username":"test1"},{"id":3,"password":"222222","username":"test2"}]
至此,springboot已完成对mybatis的集成。
以上就是本文的全部内容,希望对大家的学习有所帮助,也希望大家多多支持服务器之家。
原文链接:http://www.cnblogs.com/jiangkuan/p/6737131.html