环境:XP professional ,access2000 ,WSAD5.1
问题:查询可以,insert,update,delete都不行,access数据库的权限设置为每个人都能完全控制;
代码:
public class DBConn {
private Connection conn = null;
private Statement stmt = null;
private ResultSet rs = null;
public DBConn() {
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver").newInstance();
conn = DriverManager.getConnection("jdbc:odbc:myodbc","","");
stmt = conn.createStatement();
} catch (Exception e) {e.printStackTrace();}
}
public ResultSet Quarry(String sql){
try{rs = stmt.executeQuery(sql);}
catch(Exception e){e.printStackTrace();}
return rs;
}
public int QuarryUpdate(String sql){
int i=-1;
try{i=stmt.executeUpdate(sql);}catch(Exception e){e.getMessage();}
return i;
}
}
在servlet中设置DBConn conn=new DBConn();
当提交后执行到conn.QuarryUpdate(sql);时,跳转到的页面也不报错,空白,数据库端数据也未有变化;
问题:查询可以,insert,update,delete都不行,access数据库的权限设置为每个人都能完全控制;
代码:
public class DBConn {
private Connection conn = null;
private Statement stmt = null;
private ResultSet rs = null;
public DBConn() {
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver").newInstance();
conn = DriverManager.getConnection("jdbc:odbc:myodbc","","");
stmt = conn.createStatement();
} catch (Exception e) {e.printStackTrace();}
}
public ResultSet Quarry(String sql){
try{rs = stmt.executeQuery(sql);}
catch(Exception e){e.printStackTrace();}
return rs;
}
public int QuarryUpdate(String sql){
int i=-1;
try{i=stmt.executeUpdate(sql);}catch(Exception e){e.getMessage();}
return i;
}
}
在servlet中设置DBConn conn=new DBConn();
当提交后执行到conn.QuarryUpdate(sql);时,跳转到的页面也不报错,空白,数据库端数据也未有变化;
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货