SpringBoot 学习记录（七）- 连接Mysql数据库
SpringBoot 项目配置和连接MySql 数据库
官方文档参考链接:https://spring.io/guides/gs/accessing-data-mysql/
官方文档的例子写的很详细，建议看文档，实在看不懂的，可以往下看
安装的jdk 版本为：1.8
安装的maven版本为：3.3.9
安装和配置mysql数据库，jdk,maven请自己解决，
liunx系统安装mysql参考链接：http://blog.****.net/phpfzh/article/details/72879354
windows 系统安装mysql网上例子很多，自己找找
本次项目目录图：
application.properties代码：
server.context-path=/ROOT
spring.jpa.hibernate.ddl-auto=create
spring.datasource.url=jdbc:mysql://localhost:3306/db_example
spring.datasource.username=root
spring.datasource.password=j3550563
注意：自己mysql的用户名和密码，数据库一定要新建好。
pom.xml 代码：
<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.phpfzh</groupId>
<artifactId>phpfzh</artifactId>
<version>0.0.1-SNAPSHOT</version>
<packaging>war</packaging>
<parent>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-parent</artifactId>
<version>1.5.7.RELEASE</version>
</parent>
<dependencies>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-web</artifactId>
</dependency>
<dependency>
<!-- 移除嵌入式tomcat插件 -->
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-tomcat</artifactId>
<scope>provided</scope>
</dependency>
<!-- 添加jpa 依赖 -->
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-data-jpa</artifactId>
</dependency>
<!-- 添加mysql 依赖 -->
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
</dependency>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-test</artifactId>
<scope>test</scope>
</dependency>
</dependencies>
<properties>
<java.version>1.8</java.version>
</properties>
<build>
<finalName>ROOT</finalName>
<plugins>
<plugin>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-maven-plugin</artifactId>
</plugin>
</plugins>
</build>
</project>
实体类User 代码：
package com.phpfzh.model;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
@Entity
public class User {
@Id
@GeneratedValue(strategy = GenerationType.AUTO)
private Integer id;
private String username;
private String email;
public Integer getId() {
return id;
}
public void setId(Integer id) {
this.id = id;
}
public String getUsername() {
return username;
}
public void setUsername(String username) {
this.username = username;
}
public String getEmail() {
return email;
}
public void setEmail(String email) {
this.email = email;
}
}
UserRepository 代码：
package com.phpfzh.dao;
import org.springframework.data.repository.CrudRepository;
import com.phpfzh.model.User;
public interface UserRepository extends CrudRepository<User, Long>{
}
UserController 代码：
package com.phpfzh.web;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestParam;
import org.springframework.web.bind.annotation.ResponseBody;
import com.phpfzh.dao.UserRepository;
import com.phpfzh.model.User;
@Controller
@RequestMapping(path="/user")
public class UserController {
@Autowired
UserRepository userRepository;
@GetMapping(path = "/add")
public @ResponseBody String addNewUser(@RequestParam String name,@RequestParam String email){
User user = new User();
user.setEmail(email);
user.setUsername(name);
User user2 = userRepository.save(user);
System.out.println(user2);
return "success";
}
@GetMapping(path = "/all")
public @ResponseBody Iterable<User> getAllUsers(){
return userRepository.findAll();
}
}
ApplicationCore 代码：
package com.phpfzh;
import org.springframework.boot.SpringApplication;
import org.springframework.boot.autoconfigure.SpringBootApplication;
@SpringBootApplication
public class ApplicationCore {
public static void main(String[] args) {
SpringApplication.run(ApplicationCore.class, args);
}
}
SpringServletInitializer 代码：
package com.phpfzh;
import org.springframework.boot.builder.SpringApplicationBuilder;
import org.springframework.boot.web.support.SpringBootServletInitializer;
/**
* 修改启动类，继承 SpringBootStartApplication 并重写 configure 方法
*/
public class SpringServletInitializer extends SpringBootServletInitializer{
@Override
protected SpringApplicationBuilder configure(SpringApplicationBuilder application) {
return application.sources(ApplicationCore.class);
}
}
编译项目，启动测试：
右击项目 点击 run As ==> Maven clear ====> maven install
右击项目 点击 run As ===> java application ===
浏览器输入：
1：http://localhost:8080/ROOT/user/add?name=张三&email=dfdfdsdfdsfdsds
2：http://localhost:8080/ROOT/user/all