jsp增删改查oracle

db.url=jdbc:oracle:thin:@localhost:1521:orcl
db.username=scott
db.password=tiger

<%@ page import="java.sql.*" %>
<%@ page import="java.util.Properties" %>
<%
    Properties props = new Properties();
    props.load(application.getResourceAsStream("/WEB-INF/db.properties"));
    String url = props.getProperty("db.url");
    String username = props.getProperty("db.username");
    String password = props.getProperty("db.password");

    Connection conn = null;
    Statement stmt = null;
    ResultSet rs = null;

    try {
        Class.forName("oracle.jdbc.driver.OracleDriver");
        conn = DriverManager.getConnection(url, username, password);
        stmt = conn.createStatement();

        // 查询示例
        rs = stmt.executeQuery("SELECT * FROM employees");
        while (rs.next()) {
            out.println(rs.getString("ENAME") + "<br>");
        }

        // 插入示例
        stmt.executeUpdate("INSERT INTO employees (EMPNO, ENAME) VALUES (7890, 'NEWUSER')");

        // 更新示例
        stmt.executeUpdate("UPDATE employees SET ENAME = 'UPDATEDUSER' WHERE EMPNO = 7890");

        // 删除示例
        stmt.executeUpdate("DELETE FROM employees WHERE EMPNO = 7890");

    } catch (Exception e) {
        e.printStackTrace();
    } finally {
        try { if (rs != null) rs.close(); } catch (Exception e) {}
        try { if (stmt != null) stmt.close(); } catch (Exception e) {}
        try { if (conn != null) conn.close(); } catch (Exception e) {}
    }
%>