运行期建立HikariDataSource和JdbcTemplate

HikariDataSource是效率较高的数据源，JdbcTemplate又比JDBC省代码，两者结合一下高效而简洁。

以下是一个运行期建立HikariDataSource和JdbcTemplate的例子, 留着以备参考：

package com.hy.lab.hikari;

import com.zaxxer.hikari.HikariDataSource;
import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.jdbc.core.RowMapper;

import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.List;

class Emp{
    long id;
    String name;

    public String toString(){
        return "Emp id:"+id+" name="+name;
    }
}
public class Test {
    public static void main(String[] args){
        HikariDataSource ds=new HikariDataSource();
        ds.setDriverClassName("oracle.jdbc.OracleDriver");
        ds.setJdbcUrl("jdbc:oracle:thin:@127.0.0.1:1521:orcl");
        ds.setUsername("luna");
        ds.setPassword("1234");
        ds.setMinimumIdle(10);
        ds.setMaximumPoolSize(10);

        JdbcTemplate jdbcTplt = new JdbcTemplate(ds);

        StringBuilder sb=new StringBuilder();
        sb.append("create table emp0426(");
        sb.append("    id number(12),");
        sb.append("    name nvarchar2(20)");
        sb.append(")");
        String createTbSql=sb.toString();
        jdbcTplt.execute(createTbSql);

        jdbcTplt.execute("insert into emp0426(id,name) values(1,'Andy')");
        jdbcTplt.execute("insert into emp0426(id,name) values(2,'Bill')");
        jdbcTplt.execute("insert into emp0426(id,name) values(3,'Cindy')");
        jdbcTplt.execute("insert into emp0426(id,name) values(4,'Douglas')");

        List emps = jdbcTplt.query("select id,name from emp0426", new RowMapper() {
            @Override
            public Emp mapRow(ResultSet rs, int rowNum) throws SQLException {
                Emp emp=new Emp();
                emp.id=rs.getInt("id");
                emp.name=rs.getString("name");
                return emp;
            }});

        for(Emp emp:emps){
            System.out.println(emp);
        }
    }
}

输出：

2022-04-26 20:51:13.846 - HikariPool-1 - Starting...
2022-04-26 20:51:14.586 - HikariPool-1 - Start completed.
Emp id:1 name=Andy
Emp id:2 name=Bill
Emp id:3 name=Cindy
Emp id:4 name=Douglas

Process finished with exit code 0

END