📄 0129.htm
字号:
<html>
<head>
<title>新时代软件教程:操作系统 主页制作 服务器 设计软件 网络技术 编程语言 文字编辑</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<style>
<!--
body, table {font-size: 9pt; font-family: 宋体}
a {text-decoration:none}
a:hover {color: red;text-decoration:underline}
.1 {background-color: rgb(245,245,245)}
-->
</style>
</head>
<p align="center"><script src="../../1.js"></script></a>
<p align="center"><big><strong>Servlet调用JavaBean输出结果集示例</strong></big></p>
<div align="right">---摘自互联网</div>
<br>//通过Servlet调用JavaBean输出结果集，并打印<br>
//JavaBean:TBean SourceCode<br>
package Demo;<br>
<br>
import java.io.*;<br>
import java.sql.*;<br>
/**<br>
* 在此处插入类型说明。<br>
* 创建日期：(00-7-10 8:30:32)<br>
* @author：Administrator<br>
*/<br>
public class TBean implements Serializable {<br>
protected Connection conn = null;<br>
protected Statement stmt = null;<br>
protected java.sql.ResultSet Result;<br>
/**<br>
* TBean 构造子注解。<br>
*/<br>
public TBean() {<br>
super();<br>
}<br>
/**<br>
* 在此处插入方法说明。<br>
* 创建日期：(00-7-10 8:31:06)<br>
*/<br>
public void execute() {<br>
try {<br>
Class.forName("COM.ibm.db2.jdbc.app.DB2Driver").newInstance();<br>
conn = DriverManager.getConnection("jdbc:db2:sample", "db2admin", "db2admin");<br>
stmt = conn.createStatement();<br>
String sql = "SELECT * FROM STAFF WHERE DEPT=20";<br>
ResultSet rs = stmt.executeQuery(sql);<br>
setResult(rs);<br>
<br>
} catch (SQLException e) {<br>
} catch (IllegalAccessException e2) {<br>
} catch (ClassNotFoundException e3) {<br>
} catch (InstantiationException e4) {<br>
}<br>
}<br>
/**<br>
* 在此处插入方法说明。<br>
* 创建日期：(00-7-10 8:36:42)<br>
* @return java.sql.ResultSet<br>
*/<br>
public java.sql.ResultSet getResult() {<br>
return Result;<br>
}<br>
/**<br>
* 在此处插入方法说明。<br>
* 创建日期：(00-7-10 8:36:42)<br>
* @param newResult java.sql.ResultSet<br>
*/<br>
public void setResult(java.sql.ResultSet newResult) {<br>
Result = newResult;<br>
}<br>
/**<br>
* 在此处插入方法说明。<br>
* 创建日期：(00-7-10 8:35:54)<br>
*/<br>
public void Sqlclose() {<br>
try {<br>
conn.close();<br>
stmt.close();<br>
} catch (SQLException e) {<br>
}<br>
}<br>
}<br>
<br>
//Servlet:TServlet,调用JavaBean，并将结果集打印：<br>
package Demo;<br>
<br>
import java.io.*;<br>
import java.sql.*;<br>
import javax.servlet.*;<br>
import javax.servlet.http.*;<br>
/**<br>
* 在此处插入类型说明。<br>
* 创建日期：(00-7-10 8:37:57)<br>
* @author：Administrator<br>
*/<br>
public class TServlet extends HttpServlet implements Serializable {<br>
/**<br>
* TServlet 构造子注解。<br>
*/<br>
public TServlet() {<br>
super();<br>
}<br>
/**<br>
* service 方法注解。<br>
*/<br>
public void service(HttpServletRequest req, HttpServletResponse res) throws ServletException, IOException {<br>
try {<br>
Demo.TBean javabean = new Demo.TBean();<br>
javabean.execute();<br>
ResultSet rs1 = javabean.getResult();<br>
PrintWriter out = res.getWriter();<br>
res.setContentType("text/html");<br>
out.println("＜table border=1>");<br>
out.println("＜H1>Hello World＜/H1>");<br>
out.println("＜td>ID＜/td>＜td>NAME＜/td>＜td>DEPT＜/td>＜td>JOB＜/td>＜td>YEARS＜/td>＜td>SALARY＜/td>＜td>COMM＜/td>");<br>
while (rs1.next()) {<br>
out.println("＜tr>");<br>
for (int i = 1; i ＜= 7; i++)<br>
out.println("＜td>" + rs1.getString(i) + "＜/td>");<br>
out.println("＜/tr>");<br>
}<br>
out.println("＜/table>");<br>
javabean.Sqlclose();<br>
} catch (SQLException e) {<br>
}<br>
}<br>
}<br>
//运行：在VisualAge for Java 的IBM Websphere Test Environment的环境下：<br>
//http://localhost:8080/servlet/Demo.TServlet<br>
<br>
<br>
Hello Print ID NAME DEPT JOB YEARS SALARY COMM <br>
10 Sanders 20 Mgr 7 18357.50 null <br>
20 Pernal 20 Sales 8 18171.25 612.45 <br>
80 James 20 Clerk null 13504.60 128.20 <br>
190 Sneider 20 Clerk 8 14252.75 126.50
</table>
<p align="center"><script src="../../2.js"></script></a>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -