Spring Boot应用连接数据库MySQL、及一个简单的demo
2023-09-11 14:19:55 时间
一、修改pom.xml文件
在项目的pom.xml文件上增加如下代码,添加依赖文件。
<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>
二、设置全局配置文件
在src/main/resources/application.properties中设置数据源和jpa配置。标红处是自己建的库
spring.datasource.url=jdbc:mysql://123.207.46.41:3306/gwfdemo?useUnicode=true&characterEncoding=utf-8
spring.datasource.username=root
spring.datasource.password=159753
spring.datasource.driver-class-name=com.mysql.jdbc.Driver
spring.datasource.max-idle=10
spring.datasource.max-wait=1000
spring.datasource.min-idle=5
spring.datasource.initial-size=5
server.port=8080
server.servlet.session.timeout=10
server.tomcat.uri-encoding=UTF-8
三、分层业务逻辑
POJO:domain层
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;
}
}
service层:
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();
}
}
dao层:
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();
}
Controller层:
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();
}
}
然后运行,即可查出数据,很简单的一个demo,但是代码结构大部分如此
相关文章
- Navicat Premium连接MySQL 1251错误和Mysql初始化root密码和允许远程访问
- 【Mysql 学习】mysqld_safe:MySQL服务器启动脚本
- 【MySql】mysql 数据库数据订正
- 【Spring Boot】Spring Boot之两种引入spring boot maven依赖的方式
- spring boot: spring Aware的目的是为了让Bean获得Spring容器的服务
- ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
- MySQL配置文件mysql.ini参数详解、MySQL性能优化
- Spring Boot启动时数据库初始化spring.datasource(转)
- 我们可以使用MySQL创建一个具有数字名称的数据库吗?
- spring boot:spring security用mysql数据库实现RBAC权限管理(spring boot 2.3.1)
- MySQL之父Michael Wideneus:有自己的电脑,我可以做任何事情
- Spring+Mybatis+SpringMVC+Maven+MySql搭建实例
- mysql 重新整理——索引简介[七]
- 连接Mysql提示Can’t connect to local MySQL server through socket的解决方法
- ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)
- spring boot:使用mybatis访问多个mysql数据源/查看Hikari连接池的统计信息(spring boot 2.3.1)
- MySQL DATE_FORMAT(d,f)按表达式 f的要求显示日期 d
- 为什么Spring Boot推荐使用logback-spring.xml来替代logback.xml来配置logback日志的问题分析
- 学习Spring Boot:(十四)spring-shiro的密码加密
- Python:mysql-replication监控MySQL的binlog变动
- 解决com.alibaba.fastjson.JSONException: write javaBean error问题以及解决Spring Boot加入Shiro导致spring aop失效的问题
- MySQL Study之--Mysql无法启动“mysql.host”
- spring boot 连接mysql mongodb with jpa
- Mysql报错:Can't connect to local MySQL server through socket '/tmp/mysql.sock'
- 使用Java Spring消费MySQL中的数据库存储过程
- mac apache php mysql nginx php接口的简单demo