?? 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 + -