SpringBoot封装JDBC的实现步骤

第SpringBoot封装JDBC的实现步骤spring.datasource.username=root

spring.datasource.password=123456

spring.datasource.url=jdbc:mysql://localhost:3306/mybatisuseUnicode=truecharacterEncoding=utf-8

spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver

SpringBoot可以直接生成数据库对象

默认数据源为Hikari

jdbc连接

importorg.junit.jupiter.api.Test;

importorg.springframework.beans.factory.annotation.Autowired;

importorg.springframework.boot.test.context.SpringBootTest;

importjavax.sql.DataSource;

importjava.sql.Connection;

importjava.sql.SQLException;

@SpringBootTest

classDataSpringbootApplicationTests{

@Autowired

DataSourcedataSource;

@Test

voidcontextLoads()throwsSQLException{

System.out.println("默认数据源");

System.out.println(dataSource.getClass());

System.out.println("获得数据库连接");

Connectionconnection=dataSource.getConnection();

System.out.println(connection);

System.out.println("关闭数据源");

connection.close();

}

springboot中有很多template已经写好可以直接拿来用

importorg.springframework.beans.factory.annotation.Autowired;

importorg.springframework.jdbc.core.JdbcTemplate;

importorg.springframework.web.bind.annotation.GetMapping;

importorg.springframework.web.bind.annotation.PathVariable;

importorg.springframework.web.bind.annotation.RestController;

importjava.util.List;

importjava.util.Map;

@RestController

publicclassJDBCController{

@Autowired

JdbcTemplatejdbcTemplate;

//查询数据库所有信息

@GetMapping("/userList")

publicListMapString,ObjectuserList(){

Stringsql="select*fromuser";

ListMapString,ObjectmapList=jdbcTemplate.queryForList(sql);

returnmapList;

@GetMapping("/addUser")

publicStringaddUser(){

Stringsql="insertintomybatis.user(id,name,pwd)values(4,'hhh','451651')";

jdbcTemplate.update(sql);

return"update-ok";

@GetMapping("/deleteUser/{id}")

publicStringdeleteUser(@PathVariable("id")intid){

Stringsql="deletefrommybatis.userwhereid=

jdbcTemplate.update(sql,id);

return"delet