Connect JSP

PHOTO EMBED

Fri Nov 15 2024 19:29:59 GMT+0000 (Coordinated Universal Time)

Saved by @signup1 

<%@ page import="java.sql.*" %>
<html>
<body>
<%
    String url = "jdbc:oracle:thin:@//localhost:1521/XE";
    String user = "system";
    String password = "abhi";
    Connection conn = null;
    try {
        Class.forName("oracle.jdbc.driver.OracleDriver");
        conn = DriverManager.getConnection(url, user, password);
        Statement stmt = conn.createStatement();
        ResultSet rs = stmt.executeQuery("SELECT * FROM employee");
        while (rs.next()) {
%>
            <p>User: <%= rs.getString("ename") %></p>
<%
        }
    } catch (Exception e) {
        out.println("Error: " + e.getMessage());
    } finally {
        if (conn != null) conn.close();
    }
%>
</body>
</html>
content_copyCOPY