JBuilder9下做数据库开发,用Access数据库,用JDBC-ODBC桥,我的操作语句这样写:
database1.setConnection(new com.borland.dx.sql.dataset.ConnectionDescriptor("jdbc:odbc:Hotel", " ", "", false, "sun.jdbc.odbc.JdbcOdbcDriver"));
queryDataSet1.setQuery(new com.borland.dx.sql.dataset.QueryDescriptor(database1, "SELECT * FROM Customer", null, true, Load.ALL));
==================================================================================
但为何不能插入和删除?
有没有其他方法,其他可实现的组件,及实现SQL操作的其他写法。望指教!(最好能有代码)
database1.setConnection(new com.borland.dx.sql.dataset.ConnectionDescriptor("jdbc:odbc:Hotel", " ", "", false, "sun.jdbc.odbc.JdbcOdbcDriver"));
queryDataSet1.setQuery(new com.borland.dx.sql.dataset.QueryDescriptor(database1, "SELECT * FROM Customer", null, true, Load.ALL));
==================================================================================
但为何不能插入和删除?
有没有其他方法,其他可实现的组件,及实现SQL操作的其他写法。望指教!(最好能有代码)
Connection conn = null;
try {
//Jdbc-odbc bridge
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
String url = "jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)}; DBQ=C:\\myAccessFile.mdb";
conn = DriverManager.getConnection(url, "", "");
conn.setAutoCommit(true);
} catch (Exception e) {
throw new SessionException("E001");
}
return conn;
}
Connection conn = DBUtil.getConnect();
PreparedStatement ps = null;
String strSql = "UPDATE ....";
try {
ps = conn.prepareStatement(strSql);
...
ps.executeUpdate();
} catch (SQLException e) {
} finally {
if (ps != null){
ps.close();
ps = null;
}
if (conn!= null){
if(!conn.isClosed()){
conn.close();
}
conn = null;
}
}
}
C:\myAccessFile.mdb