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 + -
显示快捷键?