📄 test2.jsp
字号:
<%@page contentType="text/html"%><%@page pageEncoding="UTF-8"%><%@ page import="java.sql.*, javax.sql.*, java.io.*, javax.naming.*" %><html> <head> <title>基于连接池和数据源访问数据库</title> </head> <body> <h1>顾客信息</h1> <% InitialContext context = new InitialContext(); DataSource dataSource = (DataSource) context.lookup("java:comp/env/sample"); Connection conn = null; Statement stmt = null; ResultSet rset = null; try { conn = dataSource.getConnection(); stmt = conn.createStatement(); rset = stmt.executeQuery("select * from customer"); if (rset.next()) { %> <table width="100%" border="1"> <tr align="left"> <th>顾客ID</th><th>地址</th><th>电话</th> </tr> <% do { %> <tr> <td><%= rset.getString("customerid") %></td> <td><%= new String(rset.getString("address").getBytes("iso-8859-1")) %></td> <td><%= rset.getString("phone") %></td> </tr> <% } while (rset.next()); %> </table> <% } else { %> No results from query <% } } catch (SQLException e) { %> <%= e.getMessage() %> <% e.printStackTrace(); } finally { if (rset != null) { rset.close(); } if (stmt != null) { stmt.close(); } if (conn != null) { conn.close(); } if (context != null) { context.close(); } } %> </body></html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -