原因:导入人大金仓数据库驱动版本错误
- 查看自带数据库对象管理工具文件所在位置
默认存放位置:C:\Program Files\Kingbase\ES\V8\ManagerTools
- 搜索*.jar或者kingbase.jar
导入这个驱动包而不是安装人大金仓目录中获取驱动包
注意:两个驱动包版本不一致,一定要使用数据库对象管理工具对应的驱动包版本
- 测试是否连接成功
import java.sql.*;
public class DBHelper {
//连接数据库基本配置信息:
private static final String DB_URL = "jdbc:kingbase8://localhost:54321/test";
private static final String USERNAME = "test";
private static final String PASSWORD = "test";
private static Connection connection = null;
//创建连接
public static Connection getConnection() throws Exception {
if (connection == null)
//加载数据库连接驱动:
DriverManager.registerDriver(new com.kingbase8.Driver());
connection = DriverManager.getConnection(DB_URL, USERNAME, PASSWORD);
return connection;
}
public static void queryInfo() throws Exception {
String str_sql = "SELECT * FROM user";
connection = getConnection();
try {
Statement statement = connection.createStatement();
PreparedStatement preparedStatement ==connection.prepareStatement(str_sql);
ResultSet rs = statement.executeQuery(str_sql);
while (rs.next()) {
System.out.println(rs.getString("name"));
}
rs.close();
statement.close();
} catch (Exception e) {
e.printStackTrace();
}
}
public static void main(String[] args) {
try {
Connection conn = DBHelper.getConnection();
if (conn != null)
System.out.println("数据库连接正常");
else
System.out.println("数据库连接异常");
// queryInfo();
} catch (Exception e) {
e.printStackTrace();
}
}
}