📄 index1.jsp
字号:
<%@ 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 + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -