java高级
配置连接数据库信息
spring.datasource.username=root
spring.datasource.password=123456
spring.datasource.url=jdbc:mysql://192.168.31.162:3306/javagaoji
spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver
#更改数据源druid
spring.datasource.type=com.alibaba.druid.pool.DruidDataSource
pom文件
<!--连接数据库-->
<!--引入druid数据源-->
<dependency>
<groupId>com.alibaba</groupId>
<artifactId>druid</artifactId>
<version>1.1.20</version>
</dependency>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-jdbc</artifactId>
</dependency>
<dependency>
<groupId>org.mybatis.spring.boot</groupId>
<artifactId>mybatis-spring-boot-starter</artifactId>
<version>2.1.3</version>
</dependency>
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<scope>runtime</scope>
</dependency>
实体类
package com.huahua.springbootgaoji.bean;
import java.sql.Date;
/**
* @author wangtianxv
* @create 2020-09-30 9:41
*/
public class User {
public Integer id;
public String name;
public Integer age;
public String sex;
public Date birthday;
public double price;
public User() {
}
public String getSex() {
return sex;
}
public void setSex(String sex) {
this.sex = sex;
}
public Date getBirthday() {
return birthday;
}
public void setBirthday(Date birthday) {
this.birthday = birthday;
}
public double getPrice() {
return price;
}
public void setPrice(double price) {
this.price = price;
}
public User(Integer id, String name, Integer age, String sex, Date birthday, double price) {
this.id = id;
this.name = name;
this.age = age;
this.sex = sex;
this.birthday = birthday;
this.price = price;
}
public User(Integer id, String name, Integer age) {
this.id = id;
this.name = name;
this.age = age;
}
public Integer getId() {
return id;
}
public void setId(Integer id) {
this.id = id;
}
public String getName() {
return name;