jar包导入到maven本地
打开电脑命令行窗口,快捷键win+r ,输入cmd.
mvn install:install-file -Dfile=F:/inceptor-driver-8.8.1.jar -DgroupId=com.xinghuan -DartifactId=inceptor-driver -Dversion=8.8.1 -Dpackaging=jar
pom文件增加
<dependency>
<groupId>com.xinghuan</groupId>
<artifactId>inceptor-driver</artifactId>
<version>8.8.1</version>
</dependency>
连接代码
public static void main(String[] args) {
// TODO 自动生成的方法存根
String driverName = "org.apache.hive.jdbc.HiveDriver";
Connection cn = null;
Statement st = null;
ResultSet rs = null;
PreparedStatement ps = null;
try {
Class.forName(driverName);
System.out.println("连接驱动成功");
} catch (ClassNotFoundException e) {
// TODO 自动生成的 catch 块
e.printStackTrace();
System.out.println("连接驱动失败");
}
String url = "jdbc:inceptor2://127.0.0.1:10000/sw";
String usename = "admin";
String password = "123";
try {
cn = DriverManager.getConnection(url, usename, password);
System.out.println("连接数据库成功");
st = cn.createStatement();
int start = 20000001;
System.out.println("创建会话成功");
// String sql ="insert into dm.rpt_syylj_dlf_date\n" +
// "(date_id, referid, refername, fzdm_referzjg_invite)\n" +
// "VALUES(DATE('2023-12-01','YYYY-MM-DD'), '20230000000', '郑某', '140000')";
String sql ="select * from dw.md_pub_jt_rlzy_staff";
rs = st.executeQuery(sql);
while (rs.next()) {
System.out.println(rs);
}
ps.executeBatch();
cn.commit();
} catch (SQLException e) {
// TODO 自动生成的 catch 块
e.printStackTrace();
System.out.println("连接数据库失败");
} finally {
if (rs != null) {
try {
rs.close();
} catch (SQLException e) {
// TODO 自动生成的 catch 块
e.printStackTrace();
}
}
if (ps != null) {
try {
ps.close();
} catch (SQLException e) {
// TODO 自动生成的 catch 块
e.printStackTrace();
}
}
if (st != null) {
try {
st.close();
} catch (SQLException e) {
// TODO 自动生成的 catch 块
e.printStackTrace();
}
}
if (cn != null) {
try {
cn.close();
} catch (SQLException e) {
// TODO 自动生成的 catch 块
e.printStackTrace();
}
}
}
}
驱动jar下载
不知道是不是有版权,我不敢放,哈哈哈哈