java 连接 access数据库获取主键出错
lass.forName("sun.jdbc.odbc.JdbcOdbcDriver");
String dbUrl= "jdbc:odbc:driver={Microsoft Access Driver(*.mdb)};DBQ=d:\\Database\\AddressBook.mdb";
Connection con = DriverManager.getConnection(dbUrl,"","");
DatabaseMetaData dbmd=con.getMetaData();rs = dbmd.getPrimaryKeys(null, "HR","about");
while(rs.next()){
System.out.print("目录名:"+rs.getString(1));
System.out.print(" 模式名:"+rs.getString(2));
System.out.print(" 表名:"+rs.getString(3));
System.out.print(" 列名顺序号:"+rs.getString(4));
System.out.print(" 列名顺序号:"+rs.getString(5));
System.out.println(" 主键名:"+rs.getString(6));
}总是出现这样的提示
java.sql.SQLException: [Microsoft][ODBC 驱动程序 管理器] 驱动程序不支持此功能
应该如何改
谢谢
lass.forName("sun.jdbc.odbc.JdbcOdbcDriver");
String dbUrl= "jdbc:odbc:driver={Microsoft Access Driver(*.mdb)};DBQ=d:\\Database\\AddressBook.mdb";
Connection con = DriverManager.getConnection(dbUrl,"","");
DatabaseMetaData dbmd=con.getMetaData();rs = dbmd.getPrimaryKeys(null, "HR","about");
while(rs.next()){
System.out.print("目录名:"+rs.getString(1));
System.out.print(" 模式名:"+rs.getString(2));
System.out.print(" 表名:"+rs.getString(3));
System.out.print(" 列名顺序号:"+rs.getString(4));
System.out.print(" 列名顺序号:"+rs.getString(5));
System.out.println(" 主键名:"+rs.getString(6));
}总是出现这样的提示
java.sql.SQLException: [Microsoft][ODBC 驱动程序 管理器] 驱动程序不支持此功能
应该如何改
谢谢
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货