这个操作数据库的javabean中的executeQuery方法能否执行insert,update,delete SQL语句?
import java.sql.*;
public class database {
String sDBDriver = "sun.jdbc.odbc.JdbcOdbcDriver";
String sConnStr = "jdbc:odbc:Soulclan";
Connection conn = null;
ResultSet rs = null;
public database() {
try {
Class.forName(sDBDriver);
}
catch(java.lang.ClassNotFoundException e) {
System.err.println(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;
}
}
是不是执行SQL更新语句时还需要一个executeUpdate方法?如果是的话,这个方法怎么写?