📄 query.jsp
字号:
<%@ taglib uri="sql" prefix="sql" %>
<html>
<head>
<title>Custom SQL JSP Tags</title>
</head>
<body>
<p><img src="images/BEA_Button_Final_web.gif" align=right>
<font face="Helvetica">
<h1>Employee Database:</h1>
<blockquote>
<sql:connection pool_name="demoPool">
<% String query = "SELECT * FROM emp"; %>
<p> Making a query:
<font face="Courier New" size=-1 color=navy><%= query %></font>
<sql:query id="employees" sql="<%= query %>" >
<p> Here are the results...
<p><blockquote>
<table border=1>
<tr bgcolor=#DDDDFF>
<th>Employee Name</th>
<th>Job Role</th>
</tr>
<sql:results from_query="employees">
<tr>
<td><%= employees.getString("ename") %></td>
<td><%= employees.getString("job") %></td>
</tr>
</sql:results>
</table>
</blockquote>
</sql:query>
</sql:connection>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -