SpringBoot项目集成JdbcTemplate 并封装jdbcTemplate_jdbctemplate二次封装-优快云博客

本文链接：https://blog.youkuaiyun.com/weixin_39592397/article/details/82661920

本文介绍如何在Spring Boot项目中集成MySQL数据库，包括Maven依赖配置、application配置文件设置、jdbcTemplate注入及使用，并提供了一个查询所有用户的示例。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

1.导入maven坐标

<parent>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-parent</artifactId>
<version>1.5.2.RELEASE</version>
<relativePath/> 
</parent>

<properties>
<project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
<project.reporting.outputEncoding>UTF-8</project.reporting.outputEncoding>
<java.version>1.8</java.version>
</properties>

<dependencies>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-web</artifactId>
</dependency>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-jdbc</artifactId>
</dependency>

<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<scope>runtime</scope>
</dependency>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-test</artifactId>
<scope>test</scope>
</dependency>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-test</artifactId>
</dependency>
<dependency>
<groupId>com.google.guava</groupId>
<artifactId>guava</artifactId>
<version>18.0</version>
</dependency>
</dependencies>


<build>
<plugins>
<plugin>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-maven-plugin</artifactId>
</plugin>
</plugins>
</build>

2.application配置文件

spring:
#端口号
port: 8081
#mysql连接
datasource:
driver-class-name: com.mysql.jdbc.Driver
url: jdbc:mysql://127.0.0.1:3306/dbgirl
username: root
password: root

3.注入jdbcTemplate

@Autowired
private JdbcTemplate template;

4.类参考

@RequestMapping(value={"/queryAll"},method=RequestMethod.GET)
   public List<Map<String,Object>> tset() {
       ArrayList<Object> list1 = new ArrayList<Object>();
       List<Map<String,Object>> list = template.queryForList("select * from users");
       return list;
   }

创建数据库

CREATE TABLE `users` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(255) DEFAULT NULL,
`email` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8;

我们可以把注入jdbcTemplate进行封装

创建一个抽象类里面两个方法

public static ApplicationContext getContext() {
return SpringContextHolder.getApplicationContext();
}

protected static JdbcTemplate getJdbcTemplate(){
       JdbcTemplate jdbc = (JdbcTemplate) SpringContextUtil.getBean("jdbcTemplate");
       return jdbc;
   }

在dao直接extends继承使用

getJdbcTemplate.queryForList("select * from users")

ok完成