import java.sql.*;
public class lin1{
public static void main(String args[]) throws Exception{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
String dburl ="jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ=data/test.mdb";//此为NO-DSN方式
//String dburl ="jdbc:odbc:test";
Connection conn=DriverManager.getConnection(dburl);
Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
//Statement stmt=conn.createStatement();
ResultSet rs=stmt.executeQuery("select * from test"); //System.out.println(rs.getString("department"));
System.out.println(rs.getString(2)); rs.close();
stmt.close();
conn.close();
}
}怎么结果老是说 无效的游标状态请指教!
public class lin1{
public static void main(String args[]) throws Exception{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
String dburl ="jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ=data/test.mdb";//此为NO-DSN方式
//String dburl ="jdbc:odbc:test";
Connection conn=DriverManager.getConnection(dburl);
Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
//Statement stmt=conn.createStatement();
ResultSet rs=stmt.executeQuery("select * from test"); //System.out.println(rs.getString("department"));
System.out.println(rs.getString(2)); rs.close();
stmt.close();
conn.close();
}
}怎么结果老是说 无效的游标状态请指教!
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货