详解SpringBoot封装使用JDBC 详解SpringBoot封装使用JDBC

Spring Boot中可以在配置文件中直接进行数据库配置，

文章图片

spring.datasource.username= rootspring.datasource.password= 123456spring.datasource.url=jdbc:mysql://localhost:3306/mybatis?useUnicode=true&characterEncoding=utf-8spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver

【详解SpringBoot封装使用JDBC】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; @SpringBootTestclass DataSpringbootApplicationTests {@AutowiredDataSource dataSource; @Testvoid 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; @RestControllerpublic class JDBCController {@AutowiredJdbcTemplate jdbcTemplate; //查询数据库所有信息@GetMapping("/userList")public List userList(){String sql = "select * from user"; List mapList = jdbcTemplate.queryForList(sql); returnmapList; }@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"; }}