【后端】JDBCTemplate小练习

JDBCTemplate小练习(一）

使用了Druid数据库连接池

import com.alibaba.druid.pool.DruidDataSourceFactory;
import org.springframework.jdbc.core.JdbcTemplate;

import javax.sql.DataSource;
import java.io.InputStream;
import java.util.Properties;

public class JDBCTemplate {
    public static void main(String[] args) throws Exception {
        //创建配置文件对象
        Properties p = new Properties();
        //类加载器获得输入流
        ClassLoader classLoader = c2p0demo.class.getClassLoader();
        System.out.println(classLoader);
        InputStream resourceAsStream = classLoader.getResourceAsStream("druid.properties");
        System.out.println(resourceAsStream);
        //加载配置文件
        p.load(resourceAsStream);
        System.out.println(p);
        //获取连接池对象
        DataSource dataSource = DruidDataSourceFactory.createDataSource(p);

        JdbcTemplate jb = new JdbcTemplate(dataSource);
        String sql="update account set balance = 200 where id = ?";
        int update = jb.update(sql, 1);
        System.out.println(update);



    }
}

Druid配置文件详情：

driverClassName=com.mysql.cj.jdbc.Driver
url=jdbc:mysql://localhost:3306/db01?serverTimezone=UTC&characterEncoding=utf-8&useSSL=false
username=root
password=root


initialSize=5
maxActive=10
maxWait=3000
minIdle=3
validationQuery:SELECT 1
testWhileIdle:true
testOnBorrow:false
testOnReturn:false

如果出现以下错误请使用以上的配置文件：
严重: maxIdle is deprecated，严重: testWhileIdle is true, validationQuery not set，Druid连接池连接MSQL报错处理