springboot与jdbcTemplate和dbutils整合

springboot与jdbcTemplate整合

依赖架包

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

	<dependency>
		<groupId>mysql</groupId>
		<artifactId>mysql-connector-java</artifactId>
	</dependency>

在application.properties中配置如下数据库信息

spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver
spring.datasource.url=jdbc:mysql://118.24.13.38:3308/goods?characterEncoding=utf8&useSSL=false&serverTimezone=Asia/Shanghai
spring.datasource.username=root
spring.datasource.password=123456

测试一下

@Controller
public class HelloSpringBootTest {
   

	@Autowired
	JdbcTemplate jdbcTemplate;

	@GetMapping("/jdbc")
	@ResponseBody
	private Object jdbc() {
   
		List<Map<String, Object>> maplist=jdbcTemplate.queryForList("select * from t_user_test");
		return maplist;
	}
	
}

springboot与dbutils整合

依赖架包

    <dependency>
			<groupId>commons-dbutils</groupId>
			<artifactId>commons-dbutils</artifactId>
			<version>1.7</version>
	</dependency>	
 

package com.testfan.demo.dbutils; 

import java.sql.SQLException; 
import java.util.ArrayList; 
import java.util.List; 
import java.util.Map; 

import javax.sql.DataSource; 
import org.apache.commons.dbutils.QueryRunner; 
import org.apache.commons.dbutils.handlers.BeanHandler; 
import org.apache.commons.dbutils.handlers.BeanListHandler; 
import org.apache.commons.dbutils.handlers.MapHandler; 
import org.apache.commons.dbutils.handlers.MapListHandler; 
import org.apache.commons.dbutils.handlers.ScalarHandler; 
import org.apache.commons.logging.Log; 
import org.apache.commons.logging.LogFactory;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service; 

@Service
public class DbUtilsTemplate {