关于数据库的读写问题

[sunnystroller]

我用的是Tomcat 服务器，数据库是access,我写了一个bean来读写数据库，有两个函数1.ResultSet executeQuery() 2.boolean executeUpdate()
我在jsp 文件中调用这个bean 来进行数据库的读写,调用ResultSet executeQuery()函数能将数据读出来；当调用boolean executeUpdate()函数时却不能成功，我用的是表单中的数据，传过来的数据没有问题，就是不能写入数据库，请问是什么原因？还有什么更好的方法来进行写库操作？
谢谢

[pguard]

问题一定是出在executeUpdate()方法中,你把代码贴出来看看.

PS:你确定你对database有写入权限吗?

[lynx1111]

bean来读写数据库:

package firm;
import java.sql.*;

public class firm {
String sDBDriver = "sun.jdbc.odbc.JdbcOdbcDriver";
String sConnStr = "jdbc:odbc:firm";
private Connection conn = null;
private Statement stmt = null;
ResultSet rs = null;

public firm() {
try {
Class.forName(sDBDriver);
}
catch(java.lang.ClassNotFoundException e) {
System.err.println("firm(): " + e.getMessage());
}
}

public ResultSet executeQuery(String sql) {
rs = null;
try {
conn = DriverManager.getConnection(sConnStr);
stmt = conn.createStatement();
rs = stmt.executeQuery(sql);
}
catch(SQLException ex) {
System.err.println("aq.executeQuery: " + ex.getMessage());
}
return rs;
}

public void executeUpdate(String sql) {
stmt = null;
rs=null;
try {
conn = DriverManager.getConnection(sConnStr);
stmt = conn.createStatement();
stmt.executeQuery(sql);
stmt.close();
conn.close();
}
catch(SQLException ex) {
System.err.println("aq.executeQuery: " + ex.getMessage());
}
}

public void closeStmt(){
try{
stmt.close();
}
catch(SQLException e){
e.printStackTrace();
}
}
public void closeConn(){
try{
conn.close();
}
catch(SQLException e){
e.printStackTrace();
}
}
}

[lynx1111]

package test;
import java.sql.*;
public class faq {
String sDBDriver = "sun.jdbc.odbc.JdbcOdbcDriver";
String sConnStr = "jdbc:odbc:faq";
Connection conn = null;
ResultSet rs = null;
public faq() {
try {
Class.forName(sDBDriver);
}
catch(java.lang.ClassNotFoundException e) {
System.err.println("faq(): " + e.getMessage());
}
}
public ResultSet executeQuery(String sql) {
rs = null;
try {
conn = DriverManager.getConnection(sConnStr);
Statement stmt = conn.createStatement();
rs = stmt.executeQuery(sql);
}
catch(SQLException ex) {
System.err.println("aq.executeQuery: " + ex.getMessage());
}
return rs;
}
}

[monkeyhjl]

肯定是executeUpdate()的问题，把代码贴出来呀！