📄 query.jsp

📁 java的一系列产品中包括jsme,jmse,j2ee,本文件提供j2ee实现的源代码.

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