新闻发布系统 jsp+access

package dbBean; import java.sql.*; public class DBBean { private String driverStr = "sun.jdbc.odbc.JdbcOdbcDriver"; private String connStr = "jdbc:odbc:userInf"; private Connection conn = null; private Statement stmt = null; public DBBean() { try { Class.forName(driverStr); } catch(ClassNotFoundException ex) { System.out.println(ex.getMessage()); } } public void setDriverStr(String dstr) { driverStr=dstr; } public void setConnStr(String cstr) { connStr=cstr; } public ResultSet executeQuery(String sql) { ResultSet rs = null; try { conn = DriverManager.getConnection(connStr,"",""); stmt = conn.createStatement(); rs = stmt.executeQuery(sql); } catch(SQLException ex) { System.out.println(ex.getMessage()); } return rs; } public int executeUpdate(String sql) { int result=0; try{ conn = DriverManager.getConnection(connStr,"",""); stmt = conn.createStatement(); result = stmt.executeUpdate(sql); } catch(SQLException ex){ System.out.println(ex.getMessage()); } return result; } public void close() { try{ stmt.close(); conn.close(); } catch(SQLException ex){ System.out.println(ex.getMessage()); } } }