jsp在线新闻与评论系统

package news; import java.sql.*; public class conn { String sDBDriver = "sun.jdbc.odbc.JdbcOdbcDriver"; String sConnStr = "jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ=C:/Program Files/Apache Group/Tomcat 4.1/webapps/jsp/news/news.mdb"; Connection connect = null; ResultSet rs = null; public conn() { try { Class.forName(sDBDriver); } catch(java.lang.ClassNotFoundException e) { System.out.println("注册出错"); System.err.println( e.getMessage()); } } public ResultSet executeQuery(String sql) { try { connect = DriverManager.getConnection(sConnStr); Statement stmt = connect.createStatement(); rs = stmt.executeQuery(sql); } catch(SQLException ex) { System.err.println(ex.getMessage()); } return rs; } public int executeUpdate(String sql) { int result = 0; try { connect = DriverManager.getConnection(sConnStr); Statement stmt = connect.createStatement(); result = stmt.executeUpdate(sql); } catch(SQLException ex) { System.err.println(ex.getMessage()); } return result; } }