1、springboot的配置文件application.yml
#端口
server:
port: 8080
#模板页面
#注释的部分是Thymeleaf默认的配置,如有其它需求可以自行更改
spring:
thymeleaf:
cache: false
prefix: classpath:/templates/
suffix: .html
mode: LEGACYHTML5
# encoding: UTF-8
# content-type: text/html
##数据源一
#spring:
# datasource:
# driverClass: com.mysql.jdbc.Driver
# url: jdbc:mysql://127.0.0.1:3306/test?useUnicode=true&characterEncoding=utf-8
# username: xuan
# password: 123456
#数据源二
spring:
datasource:
url: jdbc:mysql://127.0.0.1:3306/test?useUnicode=true&characterEncoding=utf-8
username: xuan
password: 123456
# 使用druid数据源
type: com.alibaba.druid.pool.DruidDataSource
driver-class-name: com.mysql.cj.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
#spring-boot整合mybatis
mybatis:
#config-location: classpath:/mapper/config/mybatisConfig.xml #可以注射掉,没用到该配置文件
mapper-locations: classpath:/mapper/*Mapper.xml
#type-aliases-package: com.xuan.entity
2、maven的配置文件pom.xml (加入springboot整合mybatis的jar包,以及mysql驱动jar包,阿里的数据库链接池jar包)
以及mybatis 自动生成代码的一些配置
<?xml version="1.0" encoding="UTF-8"?>
<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
<modelVersion>4.0.0</modelVersion>
<groupId>com.xuan</groupId>
<artifactId>myspringboot</artifactId>
<version>0.0.1-SNAPSHOT</version>
<packaging>jar</packaging>
<name>myspringboot</name>
<description>Demo project for Spring Boot</description>
<parent>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-parent</artifactId>
<version>1.5.8.RELEASE</version>
<relativePath/> <!-- lookup parent from repository -->
</parent>
<properties>
<project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
<project.reporting.outputEncoding>UTF-8</project.reporting.outputEncoding>
<java.version>1.8</java.version>
<mybatis.generator.version>1.3.2</mybatis.generator.version>
<mysql.connector.java.version>6.0.6</mysql.connector.java.version>
<!-- Used by MyBatis Generator to Generate Codes -->
<!-- 运行命令: mvn mybatis-generator:generate -e -->
<!--<classPathEntry.mysql.location>${basedir}/target/${project.artifactId}/WEB-INF/lib/mysql-connector-java-${mysql.connector.java.version}.jar</classPathEntry.mysql.location>-->
<classPathEntry.mysql.location>/Users/chenqixuan/.m2/repository/mysql/mysql-connector-java/5.1.38/mysql-connector-java-5.1.38.jar</classPathEntry.mysql.location>
<javaModelGenerator.targetProject>${basedir}/src/main/java</javaModelGenerator.targetProject>
<sqlMapGenerator.targetProject>${basedir}/src/main/resources</sqlMapGenerator.targetProject>
<javaClientGenerator.targetProject>${basedir}/src/main/java</javaClientGenerator.targetProject>
<mybatis.generator.configurationFile>${basedir}/src/main/resources/generator/generatorConfig.xml</mybatis.generator.configurationFile>
<mybatis.generator.overwrite>true</mybatis.generator.overwrite>
</properties>
<dependencies>
<!--springboot整合redis-->
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-data-redis</artifactId>
</dependency>
<!--springboot整合mybatis-->
<dependency>
<groupId>org.mybatis.spring.boot</groupId>
<artifactId>mybatis-spring-boot-starter</artifactId>
<version>1.3.1</version>
</dependency>
<!--mysql jdbc驱动 -->
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>${mysql.connector.java.version}</version>
</dependency>
<!-- alibaba的druid数据库连接池 -->
<dependency>
<groupId>com.alibaba</groupId>
<artifactId>druid</artifactId>
<version>1.0.11</version>
</dependency>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-web</artifactId>
</dependency>
<!--模板页面-->
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-thymeleaf</artifactId>
</dependency>
<dependency>
<groupId>net.sourceforge.nekohtml</groupId>
<artifactId>nekohtml</artifactId>
<version>1.9.22</version>
</dependency>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-test</artifactId>
<scope>test</scope>
</dependency>
</dependencies>
<build>
<plugins>
<plugin>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-maven-plugin</artifactId>
</plugin>
<!-- mybatis generator 自动生成代码插件 -->
<plugin>
<groupId>org.mybatis.generator</groupId>
<artifactId>mybatis-generator-maven-plugin</artifactId>
<version>${mybatis.generator.version}</version>
</plugin>
</plugins>
</build>
</project>
3、mybatis的配置文件 (可以不要需要,因为在application.yml配置了)
<?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>
<settings>
<!-- changes from the defaults -->
<setting name="lazyLoadingEnabled" value="false" />
</settings>
<mappers>
<!--在application.yml配置文件中已经配置的*Mapper.xml,所以这里不需要重复添加了-->
<!--<mapper resource="mapper/UserMapper.xml" />-->
</mappers>
</configuration>
4、用户实体类xml映射文件 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.xuan.mapper.UserMapper">
<!-- 查询网校的用户数目 -->
<select id="getAllUser" resultType="com.xuan.entity.User">
SELECT * from user
</select>
</mapper>
5、自动生成配置文件 generatorConfig.xml(项目目录下运行命令: mvn mybatis-generator:generate -e )
注意:generatorConfig.xml配置文件中有些参数笔者是配置在pom.xml里的,另外mysql-connector-java-5.1.38.jar 数据库mysql驱动也不要使用太高的版本(笔者使用6.0.6版本是遇到错误,换成低版本就没事)
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE generatorConfiguration
PUBLIC "-//mybatis.org//DTD MyBatis Generator Configuration 1.0//EN"
"http://mybatis.org/dtd/mybatis-generator-config_1_0.dtd">
<generatorConfiguration>
<classPathEntry location="${classPathEntry.mysql.location}" />
<context id="mysqlTables" targetRuntime="MyBatis3">
<jdbcConnection driverClass="com.mysql.jdbc.Driver"
connectionURL="jdbc:mysql://127.0.0.1:3306/test?characterEncoding=utf8"
userId="xuan" password="123456">
</jdbcConnection>
<javaTypeResolver>
<property name="forceBigDecimals" value="false" />
</javaTypeResolver>
<javaModelGenerator targetPackage="com.xuan.entity"
targetProject="${javaModelGenerator.targetProject}">
<property name="enableSubPackages" value="true" />
<property name="trimStrings" value="true" />
</javaModelGenerator>
<sqlMapGenerator targetPackage="mapper"
targetProject="${sqlMapGenerator.targetProject}">
<property name="enableSubPackages" value="true" />
</sqlMapGenerator>
<javaClientGenerator type="XMLMAPPER"
targetPackage="com.xuan.mapper" targetProject="${javaClientGenerator.targetProject}">
<property name="enableSubPackages" value="false" />
</javaClientGenerator>
<!--
<table tableName="live_course_channel" domainObjectName="LiveCourseChannel"></table>
-->
<table tableName="video" domainObjectName="Video"></table>
</context>
</generatorConfiguration>
6、用户实体类:
package com.xuan.entity;
import java.io.Serializable;
/**
* Created by chenqixuan on 17/10/24.
*/
public class User implements Serializable{
private static final long serialVersionUID = 2120869894112984147L;
private Integer id;
private String name;
private Integer age;
private String address;
public Integer getId() {
return id;
}
public void setId(Integer id) {
this.id = id;
}
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
public Integer getAge() {
return age;
}
public void setAge(Integer age) {
this.age = age;
}
public String getAddress() {
return address;
}
public void setAddress(String address) {
this.address = address;
}
}
7、dao层是使用@Mapper注解接口代理,以前spring是使用自动扫描
package com.xuan.mapper;
import com.xuan.entity.User;
import org.apache.ibatis.annotations.Mapper;
import java.util.List;
/**
* Created by chenqixuan on 17/10/24.
*/
@Mapper
public interface UserMapper {
public List<User> getAllUser();
}
8、controller引用:
package com.xuan.controller;
import com.xuan.entity.User;
import com.xuan.mapper.UserMapper;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;
import java.util.*;
/**
* Created by chenqixuan on 17/10/24.
*/
@RestController
@RequestMapping("/user")
public class UserController {
@Autowired
private UserMapper userMapper;
@GetMapping(value="/all")
public List<User> getAllUser(){
return userMapper.getAllUser();
}
}
9、效果图:
10、目录结构: