query.jsp
来自「weblogic应用全实例」· JSP 代码 · 共 57 行
JSP
57 行
<%@ 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 + =
减小字号Ctrl + -
显示快捷键?