你说得grid在java中可以用JTable代替,dataSet由ResultSet代替。
和数据库相连用jdbc:odbc桥连接,下面就是一些代码,估计会给你一些启发的! try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
conn = DriverManager.getConnection(dbURL, userName, password);
Statement stmt = conn.createStatement();
Resultset rs = stmt.executeQuery("Select * from tablename");
while (rs.next){
String value = rs.getString("columname");
......
//把这些记录直接写道jtable中就可以了
......
}
SQLWarning warn = conn.getWarnings(); while (warn != null) {
System.out.println("SQLSTATE: " + warn.getSQLState());
System.out.println("Message: " + warn.getMessage());
System.out.println("Vendor: " + warn.getErrorCode());
warn = warn.getNextWarning();
}
return conn;
}
catch (Exception ex) {
ex.printStackTrace();
System.out.println(ex.getMessage());
return null;
}
有问题在给我发信吧:[email protected]
和数据库相连用jdbc:odbc桥连接,下面就是一些代码,估计会给你一些启发的! try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
conn = DriverManager.getConnection(dbURL, userName, password);
Statement stmt = conn.createStatement();
Resultset rs = stmt.executeQuery("Select * from tablename");
while (rs.next){
String value = rs.getString("columname");
......
//把这些记录直接写道jtable中就可以了
......
}
SQLWarning warn = conn.getWarnings(); while (warn != null) {
System.out.println("SQLSTATE: " + warn.getSQLState());
System.out.println("Message: " + warn.getMessage());
System.out.println("Vendor: " + warn.getErrorCode());
warn = warn.getNextWarning();
}
return conn;
}
catch (Exception ex) {
ex.printStackTrace();
System.out.println(ex.getMessage());
return null;
}
有问题在给我发信吧:[email protected]
比如你在ODBC数据源中有一个数据源:myDB,那么dbURL应该是jdbc:odbc:myDB
就好了!
C:\\MyDataBase\\a.MDF对不对?