(急急-在线等)大家看看
为什么我每次通过程序对数据库进行插入或删除等操作时,tomcat中就会出现
No ResultSet was produced
No ResultSet was produced
No ResultSet was produced
No ResultSet was produced
每进行一次操作,就新产生一条:No ResultSet was produced
我想应该是我的数据库操作的javaBean有误。我的如下:
package car;
import java.sql.*;
public class conn {
String sDBDriver = "sun.jdbc.odbc.JdbcOdbcDriver";
String sConnStr = "jdbc:odbc:car";
Connection connect = null;
ResultSet rs = null;
public conn() {
try {
Class.forName(sDBDriver);
}
catch(java.lang.ClassNotFoundException e) {
System.err.println( e.getMessage());
}
}
public ResultSet executeQuery(String sql) {
rs = null;
try {
connect = DriverManager.getConnection(sConnStr);
Statement stmt = connect.createStatement();
rs = stmt.executeQuery(sql);
}
catch(SQLException ex) {
System.err.println(ex.getMessage());
}
return rs;
}
}
不知是那里错了??还是程序中对处理Rst,vote,conn等有错误。使用完后没有关闭它们??????