SpringBoot封裝JDBC的實(shí)現(xiàn)步驟

第SpringBoot封裝JDBC的實(shí)現(xiàn)步驟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可以直接生成數(shù)據(jù)庫對象

默認(rèn)數(shù)據(jù)源為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("默認(rèn)數(shù)據(jù)源");

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

System.out.println("獲得數(shù)據(jù)庫連接");

Connectionconnection=dataSource.getConnection();

System.out.println(connection);

System.out.println("關(guān)閉數(shù)據(jù)源");

connection.close();

}

springboot中有很多template已經(jīng)寫好可以直接拿來用

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;

//查詢數(shù)據(jù)庫所有信息

@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