main 方法中操作jdbcTemplate

添加依赖

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

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

		<dependency>
			<groupId>org.apache.commons</groupId>
			<artifactId>commons-lang3</artifactId>
			<version>3.7</version>
		</dependency>

		<dependency>
			<groupId>com.alibaba</groupId>
			<artifactId>druid</artifactId>
			<version>1.2.16</version>
		</dependency>

构建jdbcTemplate

public class DbOperationUtils {

    /**
     * 数据库连接需要的字符串
     * */
    public static final String username = "root";
    public static final String password = "123456";
    public static final String jdbcUrl = "jdbc:mysql://localhost:3306/mydb?serverTimezone=GMT%2B8";
    public static final String driverName = "com.mysql.cj.jdbc.Driver";

    public static JdbcTemplate getJdbcTemplate() {

        // com.alibaba.druid.pool.DruidDataSource
        DruidDataSource dataSource = new DruidDataSource();


        // 设置数据源属性参数
        dataSource.setPassword(password);
        dataSource.setUrl(jdbcUrl);
        dataSource.setUsername(username);
        dataSource.setDriverClassName(driverName);

        // 获取spring的JdbcTemplate
        JdbcTemplate jdbcTemplate = new JdbcTemplate();
        // 设置数据源
        jdbcTemplate.setDataSource(dataSource);

        return jdbcTemplate;
    }
}

操作

JdbcTemplate jdbcTemplate = DbOperationUtils.getJdbcTemplate();
List<Map<String, Object>> list1 = jdbcTemplate.queryForList("select * from user");