springboot如何配置web項目請參考前一章，在此基礎上集成mybatis。
在pom文件中添加mybatis的依賴：
<dependency> <groupId>org.mybatis.spring.boot</groupId> <artifactId>mybatis-spring-boot-starter</artifactId> <version>1.2.0</version> </dependency>
添加mysql驅動：
<dependency> <groupId>mysql</groupId> <artifactId>mysql-connector-java</artifactId> </dependency>
添加druid和fastjson依賴，使用阿里巴巴druid連接池
<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中：
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掃描路徑：
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
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
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. */@Mapperpublic interface UserDao { List<UserEntity> searchAll();}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.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，測試一下可不可以查詢數據了：
@RestControllerpublic 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,輸出內容如下：
至此，springboot已完成對mybatis的集成。
以上就是本文的全部內容，希望對大家的學習有所幫助，也希望大家多多支持武林網。
新聞熱點
疑難解答
