springboot链接数据库

来源:互联网 发布:电商行业转化率算法 编辑:程序博客网 时间:2024/06/05 17:19
//pom.xml<dependency>       <groupId>mysql</groupId>       <artifactId>mysql-connector-java</artifactId></dependency><dependency>           <groupId>org.springframework.boot</groupId>           <artifactId>spring-boot-starter-data-jpa</artifactId></dependency>

属性文件配置application.properties

###########################################################datasource########################################################spring.datasource.url = jdbc:mysql://localhost:3306/testspring.datasource.username = rootspring.datasource.password = rootspring.datasource.driverClassName = com.mysql.jdbc.Driverspring.datasource.max-active=20spring.datasource.max-idle=8spring.datasource.min-idle=8spring.datasource.initial-size=10########################################################### Java Persistence Api######################################################### Specify the DBMSspring.jpa.database = MYSQL# Show or not log for each sql queryspring.jpa.show-sql = true# Hibernate ddl auto (create, create-drop, update)spring.jpa.hibernate.ddl-auto = update# Naming strategyspring.jpa.hibernate.naming-strategy = org.hibernate.cfg.ImprovedNamingStrategy# stripped before adding them to the entity manager)spring.jpa.properties.hibernate.dialect = org.hibernate.dialect.MySQL5Dialect

新建实体测试

User.javapackage demo1.bean;import javax.persistence.Entity;import javax.persistence.GeneratedValue;import javax.persistence.Id;/** * Created by LM on 2017/8/6. */@Entitypublic class User{    @Id    @GeneratedValue    private long id;    private String name;    public long getId() {        return id;    }    public void setId(long id) {        this.id = id;    }    public String getName() {        return name;    }    public void setName(String name) {        this.name = name;    }}

启动成功后,数据库会生成对应表

原文:http://412887952-qq-com.iteye.com/blog/2291542