〇、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());
}
}