| jsp+beans实现读取数据库的例子 |
|
作者：皮蛋 文章来源：网络整理 点击数： 更新时间：2004-7-21 13:46:29  |
|
(转载请注明来源)
From: http://aspfans.yeah.net
需要用到两个程序，jsp文件和数据库操作的java bean
Select.jsp
<html>
<head>
<title>Select everything from a database</title>
</head>
<body>
<jsp:useBean id="select" class="DataBaseSelect" scope="request">
</bean>
<% out.print(select.connect()); %>
<% out.print(select.select()); %>
<p>Format results
<%@ page import="java.util.Vector" %>
<% Vector aResult = select.getResult(); %>
<table>
<% for (int i=0; i < aResult.size(); i++) { %>
<tr>
<td>
<% out.print(aResult.elementAt(i)); %>
</td>
</tr>
<% } %>
</table>
</body>
</html>
DataBaseSelect.java
import java.sql.*;
import java.util.Vector;
public class DataBaseSelect {
private Vector result;
public DataBaseSelect() {
result = new Vector();
} // constructor DataBaseSelect
public String connect() {
try {
Class.forName("a jdbc driver").newInstance();
return "Driver Loaded!";
} catch (Exception E) {
return "Unable to load driver.";
}
}
public String select() {
try {
Connection C = DriverManager.getConnection("database connection string");
Statement Stmt = C.createStatement();
ResultSet myResult = Stmt.executeQuery("SELECT acolumn from atable");
while (myResult.next()) {
result.addElement(myResult.getString(1));
}
// Clean up
myResult.close();
Stmt.close();
C.close();
return "Connection Success!";
} catch (SQLException E) {
return "SQLException: " + E.getMessage();
}
}
/**
* Accessor for result
**/
public Vector getResult() {
return result;
}
/**
* Mutator for result
**/
public void setResult(Vector avector) {
result = avector;
}
} // class DataBaseSelect
(转载请注明来源)
From: http://aspfans.yeah.net
|
| 文章录入：admin 责任编辑：admin |
|
上一篇文章： 建立连接
下一篇文章： jsp留言板源代码 |
| 【字体：小 大】【发表评论】【加入收藏】【告诉好友】【打印此文】【关闭窗口】 |
用户登录 
新用户注册 
网友评论：（只显示最新10条。评论内容只代表网友观点，与本站立场无关！）
