Spring Boot应用连接数据库MySQL、及一个简单的demo

<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
</dependency>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-jdbc</artifactId>
</dependency>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-data-jpa</artifactId>
</dependency>

spring.datasource.url=jdbc:mysql://123.207.46.41:3306/gwfdemo?useUnicode=true&characterEncoding=utf-8
spring.datasource.username=root
spring.datasource.password=
spring.datasource.driver-class-name=com.mysql.jdbc.Driver
spring.datasource.max-idle=
spring.datasource.max-wait=
spring.datasource.min-idle=
spring.datasource.initial-size=
server.port=
server.servlet.session.timeout=
server.tomcat.uri-encoding=UTF-

package com.example.demo.Domain;public class Student {
private Integer id;
private String name;
private Integer age;
private String grade; public Integer getId() {
return id;
} public void setId(Integer id) {
this.id = id;
} public String getName() {
return name;
} public void setName(String name) {
this.name = name;
} public Integer getAge() {
return age;
} public void setAge(Integer age) {
this.age = age;
} public String getGrade() {
return grade;
} public void setGrade(String grade) {
this.grade = grade;
}}

package com.example.demo.Service;import com.example.demo.Dao.StudentDao;
import com.example.demo.Domain.Student;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;import java.util.List;@Service
public class StudentService {
@Autowired StudentDao studentDao;
public List<Student> getAll(){
return studentDao.getAll();
}
}

package com.example.demo.Dao;import com.example.demo.Domain.Student;
import org.apache.ibatis.annotations.Select;import java.util.List;public interface StudentDao {
@Select("select * from student")
public List<Student> getAll();
}

package com.example.demo.controller;import com.example.demo.Domain.Student;
import com.example.demo.Service.StudentService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.ResponseBody;
import org.springframework.web.bind.annotation.RestController;import java.util.List;
@RestController
public class StudentController {
@Autowired
StudentService studentService;
@ResponseBody
@RequestMapping("/student")
public List<Student> getStudents(){
return studentService.getAll();
}
}