spring boot:访问数据库

Spring Data JPA 好处是能用方法名代替写sql做一些简单的数据库访问。

实现方式：写一个接口、写一个类继承一个类、写方法名

1.      安装mysql5.7.17

 用户名：root ；密码：root ；创建数据库test 表user

表结构如下

表内容如下

1.     添加依赖（添加Mysql和Mybatis依赖）

l  Mybatis插件mapper源码参考地址：https://gitee.com/free/Mapper

<dependency>           <groupId>mysql</groupId>           <artifactId>mysql-connector-java</artifactId>       </dependency>        <dependency>            <groupId>tk.mybatis</groupId>            <artifactId>mapper-spring-boot-starter</artifactId>            <version>1.1.0</version>        </dependency>        <dependency>            <groupId>com.github.pagehelper</groupId>            <artifactId>pagehelper-spring-boot-starter</artifactId>            <version>1.1.0</version>            <exclusions>               <exclusion>                   <artifactId>tomcat-jdbc</artifactId>                   <groupId>org.apache.tomcat</groupId>               </exclusion>            </exclusions>        </dependency>        <dependency>            <groupId>org.mybatis.generator</groupId>            <artifactId>mybatis-generator-core</artifactId>            <version>1.3.5</version>            <scope>test</scope>        </dependency>        <dependency>            <groupId>com.zaxxer</groupId>            <artifactId>HikariCP</artifactId>        </dependency>        <dependency>            <groupId>com.alibaba</groupId>            <artifactId>druid</artifactId>            <version>1.1.1</version>        </dependency>        <dependency>            <groupId>com.h2database</groupId>            <artifactId>h2</artifactId>        </dependency>        <dependency>            <groupId>mysql</groupId>            <artifactId>mysql-connector-java</artifactId>        </dependency>        <dependency>            <groupId>org.springframework.boot</groupId>            <artifactId>spring-boot-starter-aop</artifactId>        </dependency>         <dependency>            <groupId>org.springframework.boot</groupId>            <artifactId>spring-boot-starter-test</artifactId>        </dependency>

1.     添加数据库连接配置

在src/main/resources下的application.yml 或者bootstarp.yml添加数据库配置

spring:   aop:     auto:true     proxy-target-class:true   datasource:       type: com.alibaba.druid.pool.DruidDataSource       url: jdbc:mysql://localhost:3306/svw_account?useUnicode=true       driver-class-name: com.mysql.jdbc.Driver       username: root       password: root       initialSize: 5       minIdle: 5       maxActive: 20       maxWait: 60000       timeBetweenEvictionRunsMillis: 60000       minEvictableIdleTimeMillis: 300000       validationQuery: SELECT 1 FROM DUAL       testWhileIdle:true       testOnBorrow:false       testOnReturn:false       poolPreparedStatements:true       maxPoolPreparedStatementPerConnectionSize: 20       #slow sql record       connectionProperties: druid.stat.mergeSql=true;druid.stat.slowSqlMillis=5000       # merge datasoure monitor       useGlobalDataSourceStat:true       hikari:         maximumPoolSize: 10 mybatis:                                 mapperLocations: classpath*:META-INF/com/svw/tbox/tcloud/user/provider/mapper/*.xml   type-aliases-package: com.svw.tbox.tcloud.user.provider.entity mapper:                  mappers:     - tk.mybatis.mapper.common.Mapper   not-empty:false   mapper.identity: MYSQL   pagehelper:   helperDialect: mySql   reasonable:true<