SpringBoot如何封装JDBC(jdbc,springboot,开发技术)

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可以直接生成数据库对象
默认数据源为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;@SpringBootTestclassDataSpringbootApplicationTests{@AutowiredDataSourcedataSource;@TestvoidcontextLoads()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;@RestControllerpublicclassJDBCController{@AutowiredJdbcTemplatejdbcTemplate;//查询数据库所有信息@GetMapping("/userList")publicList<Map<String,Object>>userList(){Stringsql="select*fromuser";List<Map<String,Object>>mapList=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"delete-ok";}}