数据库访问的JDBC通用格式:
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
/**
* 写一个工具类
* 能够连接jdbc hive支持sql语句需要加载mysql的驱动
*
*
*
*/
public class HiveUtils {
//Hive的驱动
private static String driver = "org.apache.hive.jdbc.HiveDriver";
//Oracle数据库: oracle.jdbc.OracleDriver
//Hive的URL地址
private static String url = "jdbc:hive2://192.168.128.111:10000/default";
//注册数据库的驱动
static{
try{
Class.forName(driver);
}catch(Exception ex){
throw new ExceptionInInitializerError(ex);
}
}
//获取数据库Hive的链接
public static Connection getConnection(){
try{
return DriverManager.getConnection(url,"hive","hive");
}catch(Exception ex){
ex.printStackTrace();
}
return null;
}
//释放资源
public static void release(Connection conn,Statement st,ResultSet rs){