⭐ 欢迎来到虫虫下载站！ | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站
📤 上传资源

📄 0062.htm

📁 JspServlet教程专栏 对javaservlet讲述的非常详细
💻 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>
&lt;html&gt;<br>
&lt;head&gt;<br>
&lt;title&gt;Select everything from a database&lt;/title&gt;<br>
&lt;/head&gt;<br>
&lt;body&gt;<br>
<br>
&lt;jsp:useBean id=&quot;select&quot; class=&quot;DataBaseSelect&quot; scope=&quot;request&quot;&gt;<br>
&lt;/bean&gt;<br>
<br>
&lt;% out.print(select.connect()); %&gt;<br>
&lt;br&gt;<br>
&lt;% out.print(select.select()); %&gt;<br>
<br>
&lt;p&gt;Format results<br>
<br>
&lt;br&gt;<br>
&lt;%@ page import=&quot;java.util.Vector&quot; %&gt;<br>
&lt;% Vector aResult = select.getResult(); %&gt;<br>
<br>
&lt;table&gt;<br>
&lt;% for (int i=0; i &lt; aResult.size(); i++) { %&gt;<br>
&nbsp;&nbsp;&nbsp;&lt;tr&gt;<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;td&gt;<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;% out.print(aResult.elementAt(i)); %&gt;<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;/td&gt;<br>
&nbsp;&nbsp;&nbsp;&lt;/tr&gt;<br>
&lt;% } %&gt;<br>
&lt;/table&gt;<br>
<br>
&lt;/body&gt;<br>
&lt;/html&gt;<br>
<br>
DataBaseSelect.java<br>
import java.sql.*;<br>
import java.util.Vector;<br>
<br>
/**<br>
 * DataBaseSelect.java<br>
 * Written by Morgan Catlin<br>
 *&nbsp;&nbsp;&nbsp;August 19, 1999<br>
 * <br>
 * Variables:<br>
 *&nbsp;&nbsp;&nbsp;Vector result = where I put the results of a select query<br>
 * <br>
 * Methods:<br>
 *&nbsp;&nbsp;&nbsp;Vector getResult() = returns result<br>
 *&nbsp;&nbsp;&nbsp;void setResult() = sets result<br>
 *&nbsp;&nbsp;&nbsp;String connect() = connects to a database<br>
 *&nbsp;&nbsp;&nbsp;String select() = selects information from a database<br>
 */<br>
<br>
public class DataBaseSelect {<br>
&nbsp;&nbsp;&nbsp;<br>
&nbsp;&nbsp;&nbsp;private Vector result;<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<br>
&nbsp;&nbsp;&nbsp;public DataBaseSelect() {<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;result = new Vector();<br>
&nbsp;&nbsp;&nbsp;} // constructor DataBaseSelect<br>
&nbsp;&nbsp;&nbsp;<br>
&nbsp;&nbsp;&nbsp;public String connect() {<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;try {<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Class.forName(&quot;a jdbc driver&quot;).newInstance();<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;return &quot;Driver Loaded!&quot;;<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;} catch (Exception E) {<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;return &quot;Unable to load driver.&quot;;<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}<br>
&nbsp;&nbsp;&nbsp;}<br>
&nbsp;&nbsp;&nbsp;<br>
&nbsp;&nbsp;&nbsp;public String select() {<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;try {<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Connection C = DriverManager.getConnection(&quot;database connection string&quot;);<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Statement Stmt = C.createStatement();<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;ResultSet myResult = Stmt.executeQuery(&quot;SELECT acolumn from atable&quot;);<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;while (myResult.next()) {<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;result.addElement(myResult.getString(1));<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;// Clean up<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;myResult.close();<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Stmt.close();<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;C.close();<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;return &quot;Connection Success!&quot;;<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;} catch (SQLException E) {<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;return &quot;SQLException: &quot; + E.getMessage();<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}<br>
&nbsp;&nbsp;&nbsp;}<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<br>
&nbsp;&nbsp;&nbsp;/**<br>
&nbsp;&nbsp;&nbsp;&nbsp;* Accessor for result<br>
&nbsp;&nbsp;&nbsp;&nbsp;**/<br>
&nbsp;&nbsp;&nbsp;public Vector getResult() {<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;return result;<br>
&nbsp;&nbsp;&nbsp;}<br>
&nbsp;&nbsp;&nbsp;<br>
&nbsp;&nbsp;&nbsp;/**<br>
&nbsp;&nbsp;&nbsp;&nbsp;* Mutator for result<br>
&nbsp;&nbsp;&nbsp;&nbsp;**/<br>
&nbsp;&nbsp;&nbsp;public void setResult(Vector avector) {<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;result = avector;<br>
&nbsp;&nbsp;&nbsp;}&nbsp;&nbsp;<br>
&nbsp;&nbsp;&nbsp;<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 + -