C3P0连接Impala数据库

〇、pom加入

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

<dependency>
    <groupId>com.mchange</groupId>
    <artifactId>c3p0</artifactId>
    <version>0.9.5.2</version>
</dependency>

 一、创建配置文件

c3p0.driverClass=com.cloudera.impala.jdbc41.Driver
c3p0.jdbcUrl=jdbc:impala://192.168.1.2:21050/dbname
#c3p0.user=admin
#c3p0.password=admin

二、连接工具类

import com.mchange.v2.c3p0.ComboPooledDataSource;
import org.apache.commons.dbutils.QueryRunner;
import org.apache.commons.dbutils.handlers.BeanListHandler;

import javax.sql.DataSource;
import java.sql.Connection;
import java.sql.SQLException;
import java.util.List;

/**
 * @ClassName: ImpalaC3P0Util
 * @Description: TODO
 * @Author Tan
 * @Date 2019/7/1
 */
public class ImpalaC3P0Util {

    private static DataSource ds;
    private static QueryRunner queryRunner;

    static {
        ds = new ComboPooledDataSource();
        queryRunner = new QueryRunner(ImpalaC3P0Util.getDatasSource());
    }

    public static DataSource getDatasSource() {
        return ds;
    }

    public static Connection getConn() {
        Connection con = null;
        try {
            con = ds.getConnection();//每一次从ds中获取一个新的连接
        } catch (Exception e) {
            e.printStackTrace();
        }
        return con;
    }

    public static <T> List<T> queryList(Class<T> entityClass, String sql, Object... params) {

        List<T> list = null;
        try {
            list = queryRunner.query(sql, new BeanListHandler<T>(entityClass), params);
        } catch (SQLException e) {
            e.printStackTrace();
        }

        return list;
    }

}

这里需要自己引入 Cloudera_ImpalaJDBC41_2.5.36 ，ImpalaJDBC连接jar包，因为maven包含不到，只能自己手动引入

资源链接：https://download.csdn.net/download/zhan107876/11274264

博客不能自定义积分了，本来想免费的，各位没有积分就网上去下吧。

三、使用

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

/**
 * @ClassName: Test
 * @Description: TODO
 * @Author Tan
 * @Date 2019/7/1
 */
public class Test {

    public static void main(String[] args) {

        //条件查询
        String sql3 = "select * from person where 1=1";
        List<Object> params = new ArrayList<Object>();
        System.err.println(params);
        sql3 += " and name=? order by id limit 10 OFFSET 0";
        params.add("我们");

        List<Person> persons = ImpalaC3P0Util.queryList(Person.class, sql3, params.toArray());

        System.out.println(persons.toString());

    }
}