SpringBoot封装JDBC的实现步骤
作者:要不一起ci个饭 时间:2022-09-13 04:04:31
Spring Boot中可以在配置文件中直接进行数据库配置,
spring.datasource.username= root
spring.datasource.password= 123456
spring.datasource.url=jdbc:mysql://localhost:3306/mybatis?useUnicode=true&characterEncoding=utf-8
spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver
SpringBoot可以直接生成数据库对象
默认数据源为Hikari
jdbc连接
import org.junit.jupiter.api.Test;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.boot.test.context.SpringBootTest;
import javax.sql.DataSource;
import java.sql.Connection;
import java.sql.SQLException;
@SpringBootTest
class DataSpringbootApplicationTests {
@Autowired
DataSource dataSource;
@Test
void contextLoads() throws SQLException {
System.out.println("默认数据源");
System.out.println(dataSource.getClass());
System.out.println("获得数据库连接");
Connection connection = dataSource.getConnection();
System.out.println(connection);
System.out.println("关闭数据源");
connection.close();
}
}
springboot中有很多template已经写好可以直接拿来用
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.PathVariable;
import org.springframework.web.bind.annotation.RestController;
import java.util.List;
import java.util.Map;
@RestController
public class JDBCController {
@Autowired
JdbcTemplate jdbcTemplate;
//查询数据库所有信息
@GetMapping("/userList")
public List<Map<String,Object>> userList(){
String sql = "select * from user";
List<Map<String, Object>> mapList = jdbcTemplate.queryForList(sql);
return mapList;
}
@GetMapping("/addUser")
public String addUser(){
String sql = "insert into mybatis.user(id,name,pwd) values (4,'hhh','451651')";
jdbcTemplate.update(sql);
return "update-ok";
}
@GetMapping("/deleteUser/{id}")
public String deleteUser(@PathVariable("id") int id){
String sql = "delete from mybatis.user where id = ?";
jdbcTemplate.update(sql,id);
return "delete-ok";
}
}
来源:https://blog.csdn.net/char_m/article/details/122157476
标签:SpringBoot,封装,JDBC
![](/images/zang.png)
![](/images/jiucuo.png)
猜你喜欢
JAVA如何按字节截取字符串
2023-11-25 13:31:41
C#实现类似新浪微博长URL转短地址的方法
2023-06-02 12:59:28
详解java基于MyBatis使用示例
2023-11-25 09:01:45
![](https://img.aspxhome.com/file/2023/0/59060_0s.png)
java二叉树的几种遍历递归与非递归实现代码
2022-06-29 19:19:47
![](https://img.aspxhome.com/file/2023/7/64787_0s.jpg)
Java基于接口实现模拟动物声音代码实例
2022-07-28 04:46:07
SPRING IOC注入方式过程解析
2023-10-11 12:59:13
![](https://img.aspxhome.com/file/2023/4/66944_0s.png)
spring boot如何指定启动端口
2021-06-27 19:52:14
![](https://img.aspxhome.com/file/2023/0/65370_0s.png)
java获取注册ip实例
2023-11-03 23:01:12
JAVA实现的CrazyArcade泡泡堂游戏
2022-12-25 11:55:23
![](https://img.aspxhome.com/file/2023/6/63156_0s.png)
Java抢红包的红包生成算法
2023-06-23 20:52:04
![](https://img.aspxhome.com/file/2023/2/57532_0s.jpg)
eclipse中maven插件安装教程
2023-06-23 17:08:23
![](https://img.aspxhome.com/file/2023/2/62972_0s.png)
一文带你入门SpringMVC的配置与使用
2021-06-24 12:30:52
![](https://img.aspxhome.com/file/2023/7/62137_0s.png)
C#利用System.Uri转URL为绝对地址的方法
2021-06-04 13:41:40
C# DataGridView绑定数据源的方法
2023-06-30 00:26:39
分析HashMap 的 JDK 源码
2022-01-17 06:29:54
![](https://img.aspxhome.com/file/2023/4/68164_0s.jpg)
Java设计模式之备忘录模式实现对象状态的保存和恢复
2023-08-28 15:22:27
![](https://img.aspxhome.com/file/2023/9/58439_0s.png)
浅谈Java中Map和Set之间的关系(及Map.Entry)
2023-08-25 02:23:48
![](https://img.aspxhome.com/file/2023/9/57949_0s.jpg)
使用Spring Cloud Feign远程调用的方法示例
2021-12-06 10:30:09
JDK1.8下载、安装和环境配置超详细教程(最新最完整)
2022-07-22 12:58:34
![](https://img.aspxhome.com/file/2023/5/62805_0s.jpg)
Springboot如何利用拦截器拦截请求信息收集到日志详解
2023-03-09 02:30:57