基于javaweb+jsp的网络管理系统

// Java Document package sql; import java.sql.*; public class sql_data{ private String sDBDriver="sun.jdbc.odbc.JdbcOdbcDriver"; private String url="jdbc:odbc:meeting";//Notice:DatabaseName private String user="sa"; private String password="";//Notice: user and password. Connection conn; Statement stmt; ResultSet rs; public sql_data() { try{ Class.forName(sDBDriver); } catch(java.lang.ClassNotFoundException e){ System.err.println("sql_data():"+e.getMessage()); } } public void executeInsert(String sql){ try{ conn=DriverManager.getConnection(url,user,password); stmt=conn.createStatement(); stmt.executeUpdate(sql); stmt.close(); conn.close(); }catch(SQLException ex){ System.err.println("sql_data.executeUpdate:"+ex.getMessage()); } } public ResultSet executeQuery(String sql) { try { conn = DriverManager.getConnection(url,user,password); stmt = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY); rs = stmt.executeQuery(sql); } catch(SQLException ex) { System.err.println("sql_data.executeQuery:"+ex.getMessage()); } return rs; } /* public ResultSet executeQuery(String sql) { try{ conn=DriverManager.getConnection (url,user,password); stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY); rs=stmt.executeQuery(sql); stmt.close();////////////////////////////I changed; conn.close();////////////////////////////.......... }catch(SQLException ex){ System.err.println("sql_data.executeQuery:"+ex.getMessage()); } return rs; } */ public void executeUpdate(String sql){ try{ conn=DriverManager.getConnection(url,user,password); stmt=conn.createStatement(); stmt.executeUpdate(sql); stmt.close(); conn.close(); }catch(SQLException ex){ System.err.println("sql_data.executeQuery:"+ex.getMessage()); } } public void executeDelete(String sql){ try{ conn=DriverManager.getConnection(url,user,password); stmt=conn.createStatement(); stmt.executeUpdate(sql); stmt.close(); conn.close(); }catch(SQLException ex){ System.err.println("sql_data.executeDelete:"+ex.getMessage()); } } public void closeStmt(){ try{ stmt.close(); } catch(SQLException e){ e.printStackTrace(); } } public void closeConn(){ try{ conn.close(); }catch(SQLException e){ e.printStackTrace(); } } }