jsp数据库连接代码

<%@ page import="java.sql.*" %>
<%@ page import="javax.naming.*" %>
<%@ page import="javax.sql.*" %>

<%
    Connection conn = null;
    Statement stmt = null;
    ResultSet rs = null;
    try {
        // 获取数据源
        Context initContext = new InitialContext();
        Context envContext = (Context)initContext.lookup("java:/comp/env");
        DataSource ds = (DataSource)envContext.lookup("jdbc/MyDB");

        // 获取连接
        conn = ds.getConnection();

        // 执行查询
        stmt = conn.createStatement();
        rs = stmt.executeQuery("SELECT * FROM myTable");

        // 处理结果集
        while (rs.next()) {
            // 处理每一行数据
        }
    } catch (SQLException | NamingException e) {
        e.printStackTrace();
    } finally {
        // 关闭资源
        try {
            if (rs != null) rs.close();
            if (stmt != null) stmt.close();
            if (conn != null) conn.close();
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }
%>