index1.jsp
来自「在tomcat服务器上实现dbcp数据库链接池的小方案」· JSP 代码 · 共 39 行
JSP
39 行
<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%><%@ page import="javax.naming.InitialContext, javax.sql.DataSource, java.sql.Connection, java.sql.Statement, java.sql.ResultSet" %><% InitialContext cxt = new InitialContext(); DataSource ds = (DataSource)cxt.lookup("java:/comp/env/jdbc/lab8"); Connection conn = ds.getConnection(); Statement stmt = conn.createStatement(); ResultSet rs = stmt.executeQuery("select * from User"); %><html><head><meta http-equiv="Content-Type" content="text/html; charset=UTF-8" /><title>lab8</title></head><body> <table border="1"> <tr> <th>ID</th> <th>name</th> <th>age</th> <th>email</th> <th>birthday</th> </tr> <% while (rs.next()){ %> <tr> <td><%=rs.getString("id")%></td> <td><%=rs.getString("name")%></td> <td><%=rs.getInt("age")%></td> <td><%=rs.getString("email")%></td> <td><%=rs.getDate("birthday")%></td> </tr> <% } %> </table></body></html>⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?