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