?? 0062.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>jsp+beans實現讀取數據庫的例子</strong></big></p>
<div align="right">摘自互聯網</div>
<p><span class=smallFont>
jsp+beans實現讀取數據庫的例子<br>
Select.jsp<br>
<br>
<html><br>
<head><br>
<title>Select everything from a database</title><br>
</head><br>
<body><br>
<br>
<jsp:useBean id="select" class="DataBaseSelect" scope="request"><br>
</bean><br>
<br>
<% out.print(select.connect()); %><br>
<br><br>
<% out.print(select.select()); %><br>
<br>
<p>Format results<br>
<br>
<br><br>
<%@ page import="java.util.Vector" %><br>
<% Vector aResult = select.getResult(); %><br>
<br>
<table><br>
<% for (int i=0; i < aResult.size(); i++) { %><br>
<tr><br>
<td><br>
<% out.print(aResult.elementAt(i)); %><br>
</td><br>
</tr><br>
<% } %><br>
</table><br>
<br>
</body><br>
</html><br>
<br>
DataBaseSelect.java<br>
import java.sql.*;<br>
import java.util.Vector;<br>
<br>
/**<br>
* DataBaseSelect.java<br>
* Written by Morgan Catlin<br>
* August 19, 1999<br>
* <br>
* Variables:<br>
* Vector result = where I put the results of a select query<br>
* <br>
* Methods:<br>
* Vector getResult() = returns result<br>
* void setResult() = sets result<br>
* String connect() = connects to a database<br>
* String select() = selects information from a database<br>
*/<br>
<br>
public class DataBaseSelect {<br>
<br>
private Vector result;<br>
<br>
public DataBaseSelect() {<br>
result = new Vector();<br>
} // constructor DataBaseSelect<br>
<br>
public String connect() {<br>
try {<br>
Class.forName("a jdbc driver").newInstance();<br>
return "Driver Loaded!";<br>
} catch (Exception E) {<br>
return "Unable to load driver.";<br>
}<br>
}<br>
<br>
public String select() {<br>
try {<br>
Connection C = DriverManager.getConnection("database connection string");<br>
<br>
Statement Stmt = C.createStatement();<br>
<br>
ResultSet myResult = Stmt.executeQuery("SELECT acolumn from atable");<br>
<br>
while (myResult.next()) {<br>
result.addElement(myResult.getString(1));<br>
}<br>
<br>
// Clean up<br>
myResult.close();<br>
Stmt.close();<br>
C.close();<br>
return "Connection Success!";<br>
} catch (SQLException E) {<br>
return "SQLException: " + E.getMessage();<br>
}<br>
}<br>
<br>
/**<br>
* Accessor for result<br>
**/<br>
public Vector getResult() {<br>
return result;<br>
}<br>
<br>
/**<br>
* Mutator for result<br>
**/<br>
public void setResult(Vector avector) {<br>
result = avector;<br>
} <br>
<br>
} // class DataBaseSelect<br>
</table>
<p align="center"><script src="../../2.js"></script></a>
</body>
</html>
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -