spring boot 集合mysql_Spring boot整合mysql和druid

Spring boot整合mysql和druid

集成mysql数据库

引入依赖

mysql

mysql-connector-java

runtime

org.springframework.boot

spring-boot-starter-jdbc

添加数据库配置

Spring boot项目的resources目录下的applicataion.properties

# datasource

spring.datasource.url=jdbc:mysql://127.0.0.1:3306/test?useUnicode=true&characterEncoding=UTF-8

spring.datasource.username=root

spring.datasource.password=root

spring.datasource.driver-class-name=com.mysql.jdbc.Driver

设计数据库表和实体

create table user(

id bigint primary key auto_increment,

name varchar(10) not null ,

age int default 0

);

insert into user (name, age) VALUES ('jack', 12);

public class User {

private int id;//id

private String name;//姓名

private int age;//年龄

//get set省略