📄 0190.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>jdbc-odbc连接的bean代码</strong></big></p>
<div align="right">---摘自互联网</div>

<br>//&nbsp; substitute&nbsp; your&nbsp; own&nbsp; class&nbsp; path<br>
package&nbsp; com.jspcafe.db;<br>
<br>
//&nbsp; standard&nbsp; classes&nbsp; to&nbsp; import&nbsp; when&nbsp; using&nbsp; jdbc<br>
import&nbsp; java.sql.*;<br>
import&nbsp; java.io.*;<br>
<br>
public&nbsp; class&nbsp; odbcBean&nbsp; {<br>
<br>
//&nbsp; db&nbsp; is&nbsp; our&nbsp; connection&nbsp; object<br>
Connection&nbsp; db&nbsp; =&nbsp; null;<br>
<br>
//&nbsp; stmt&nbsp; will&nbsp; hold&nbsp; our&nbsp; jdbc&nbsp; statements<br>
//&nbsp; i.e.&nbsp; sql&nbsp; and&nbsp; stored&nbsp; procedures<br>
Statement&nbsp; stmt&nbsp; =&nbsp; null;<br>
<br>
//&nbsp; result&nbsp; will&nbsp; hold&nbsp; the&nbsp; recordset<br>
ResultSet&nbsp; result&nbsp; =&nbsp; null;<br>
<br>
//&nbsp; default&nbsp; constructor<br>
public&nbsp; odbcBean()&nbsp; {<br>
}<br>
<br>
/*********************************************<br>
*&nbsp; @dsn&nbsp; String&nbsp; for&nbsp; ODBC&nbsp; Datasource&nbsp; name<br>
*&nbsp; @uid&nbsp; String&nbsp; for&nbsp; ODBC&nbsp; Datasource&nbsp; user&nbsp; name<br>
*&nbsp; @pwn&nbsp; String&nbsp; for&nbsp; ODBC&nbsp; Datasource&nbsp; password<br>
*/<br>
public&nbsp; void&nbsp; OpenConn(<br>
String&nbsp; dsn,&nbsp; <br>
String&nbsp; uid,&nbsp; <br>
String&nbsp; pwd)&nbsp; throws&nbsp; Exception&nbsp; {<br>
<br>
try&nbsp; {<br>
dsn&nbsp; =&nbsp; "jdbc:odbc:"&nbsp; +&nbsp; dsn;<br>
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");<br>
db&nbsp; =&nbsp; DriverManager.getConnection(dsn,&nbsp; uid,&nbsp; pwd);<br>
}&nbsp; catch&nbsp; (Exception&nbsp; e)&nbsp; {<br>
e.printStackTrace();<br>
}<br>
}<br>
<br>
<br>
/*********************************************<br>
*&nbsp; @sproc&nbsp; String&nbsp; for&nbsp; sql&nbsp; statement&nbsp; or&nbsp; stored<br>
*&nbsp; procedure<br>
*/<br>
public&nbsp; ResultSet&nbsp; getResults(String&nbsp; sproc)&nbsp; <br>
throws&nbsp; Exception&nbsp; {<br>
<br>
stmt&nbsp; =&nbsp; db.createStatement();<br>
result&nbsp; =&nbsp; stmt.executeQuery(sproc);<br>
return&nbsp; result;<br>
}<br>
<br>
/*********************************************<br>
*&nbsp; @sproc&nbsp; String&nbsp; for&nbsp; sql&nbsp; statement&nbsp; or&nbsp; stored<br>
*&nbsp; procedure<br>
*/<br>
public&nbsp; void&nbsp; execute(String&nbsp; sproc)&nbsp; <br>
throws&nbsp; Exception&nbsp; {<br>
<br>
stmt&nbsp; =&nbsp; db.createStatement();<br>
stmt.execute(sproc);<br>
}<br>
<br>
//&nbsp; Don't&nbsp; forget&nbsp; to&nbsp; clean&nbsp; up!<br>
public&nbsp; void&nbsp; CloseStmt()&nbsp; <br>
throws&nbsp; Exception&nbsp; {<br>
<br>
stmt.close();<br>
stmt&nbsp; =&nbsp; null;<br>
}<br>
<br>
//&nbsp; Don't&nbsp; forget&nbsp; to&nbsp; clean&nbsp; up!<br>
public&nbsp; void&nbsp; CloseConn()&nbsp; <br>
throws&nbsp; Exception&nbsp; {<br>
<br>
db.close();<br>
db&nbsp; =&nbsp; null;<br>
}<br>
<br>
}<br>
<br>
OK,&nbsp; that's&nbsp; great,&nbsp; now&nbsp; what&nbsp; do&nbsp; I&nbsp; do&nbsp; with&nbsp; it?&nbsp; How&nbsp; the&nbsp; heck&nbsp; do&nbsp; I&nbsp; use&nbsp; this&nbsp; stupid&nbsp; bean&nbsp; in&nbsp; my&nbsp; JSP&nbsp; page?&nbsp; Like&nbsp; this:&nbsp; <br>
<br>
<br>
&lt;%@&nbsp; page&nbsp; import="java.sql.*"&nbsp; %><br>
<br>
&lt;html><br>
&lt;body><br>
<br>
&lt;jsp:useBean&nbsp; id="db"&nbsp; <br>
class="com.jspcafe.db.OdbcBean"&nbsp; <br>
scope="request"&nbsp; /><br>
<br>
&lt;%<br>
//&nbsp; Open&nbsp; your&nbsp; database&nbsp; connection<br>
db.OpenConn("myDsn",&nbsp; "myUsername",&nbsp; "myPassword");<br>
<br>
//&nbsp; Create&nbsp; your&nbsp; sql&nbsp; statement<br>
String&nbsp; sql&nbsp; =&nbsp; "MY&nbsp; SQL&nbsp; STATEMENT";<br>
<br>
//&nbsp; Get&nbsp; your&nbsp; recordset<br>
ResultSet&nbsp; rs&nbsp; =&nbsp; db.getResults(sql);<br>
<br>
/*******************************************<br>
*&nbsp; Do&nbsp; whatever&nbsp; you&nbsp; need&nbsp; to&nbsp; do&nbsp; with&nbsp; your<br>
*&nbsp; recordset.<br>
*/<br>
<br>
//&nbsp; Clean&nbsp; up!<br>
rs&nbsp; =&nbsp; null;<br>
db.CloseStmt();<br>
db.CloseConn();<br>
%><br>
<br>
&lt;/body><br>
&lt;/html>

  </table>
<p align="center"><script src="../../2.js"></script></a>
</body>
</html>
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -