JSP用户管理系统-示例程序代码

package yhgl; import java.sql.*; public class connectDB { String DBDriver = "oracle.jdbc.driver.OracleDriver"; String DBUrl = "jdbc:oracle:thin:@localhost:1521:ORACLE"; String DBUser = "jerry"; String DBPsw = "123456"; Connection conn = null; PreparedStatement stmt = null; public connectDB() { try { Class.forName(DBDriver); conn = DriverManager.getConnection(DBUrl,DBUser,DBPsw); } catch (Exception e) { e.printStackTrace(); } } public ResultSet executeQuery(String sql) throws Exception { try { this.stmt = null; this.stmt = conn.prepareStatement(sql); return this.stmt.executeQuery(); } catch (Exception e) { e.printStackTrace(); return null; } } public int executeUpdate(String sql) throws Exception { try { this.stmt = null; this.stmt = conn.prepareStatement(sql); return this.stmt.executeUpdate(); } catch (Exception e) { e.printStackTrace(); return 0; } } public void closeDB() { try { conn.close(); stmt.close(); } catch (Exception e) { e.printStackTrace(); } } }