📄 0130.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连接池的例子</strong></big></p>
<div align="right">---摘自互联网</div>
<br>import javax.servlet.* ;<br>
import javax.servlet.http.* ;<br>
import java.io.* ;<br>
import java.sql.* ;<br>
import java.util.Vector;<br>
import oracle.jdbc.driver.*;<br>
import java.util.Enumeration;<br>
import java.util.Properties;<br>
import com.unitech.connectionpool.* ; <br>
<br>
<br>
public class dbTest extends HttpServlet {<br>
//Initialize global variables<br>
public void init(ServletConfig config) throws ServletException {<br>
super.init(config); <br>
<br>
}<br>
// 数据库连接：Connetcion conn = null ;<br>
Connection conn = null ;<br>
//数据库查询内容执行：Statement stment = null ;<br>
Statement stment = null ;<br>
// 数据库连接池的初始化<br>
DBConnectionManager connMgr = DBConnectionManager.getInstance(); <br>
<br>
//初始化数据库连接池，并且获取数据库连接<br>
private void initDatabaseDriver () {<br>
conn = connMgr.getConnection("oracle");<br>
if (conn == null) {<br>
System.out.println("数据库连接失败。");<br>
return;<br>
}<br>
try {<br>
stment = conn.createStatement();<br>
}<br>
catch (SQLException e) {<br>
e.printStackTrace() ;<br>
}<br>
} <br>
<br>
//释放数据库连接<br>
private void freeConnectionPool() {<br>
connMgr.freeConnection("oracle", conn) ;<br>
} <br>
<br>
//获取记录集，并返回给VERTOR V<br>
public Vector getForumList() {<br>
String[] s = {"","","","",""} ;//与选取的列数相等。<br>
Vector v = new Vector() ;<br>
this.initDatabaseDriver();<br>
try{<br>
String queryStr = null ;<br>
queryStr = "SELECT BBS_ID,BBS_NAME,DESCRIPTION,MANAGER_ID, CREATE_DATE FROM BBS WHERE IS_SYSTEM='0' ORDER BY CREATE_DATE DESC" ;<br>
ResultSet rSet = stment.executeQuery(queryStr) ;<br>
while (rSet.next()) {<br>
s[0] = Integer.toString(rSet.getInt("BBS_ID")) ;<br>
s[1] = rSet.getString("BBS_NAME") ;<br>
s[2] = rSet.getString("DESCRIPTION") ;<br>
s[3] = rSet.getString("MANAGER_ID") ;<br>
Timestamp createdate = rSet.getTimestamp("CREATE_DATE") ;<br>
String tmp = createdate.toString() ;<br>
s[4] = tmp.substring(0,(tmp.length()-2)) ;<br>
v.addElement(s.clone());<br>
}<br>
rSet.close();<br>
stment.close();<br>
this.freeConnectionPool();<br>
}<br>
catch(Exception e) {<br>
try {<br>
stment.close();<br>
this.freeConnectionPool();<br>
}<br>
catch(SQLException ee) {<br>
ee.printStackTrace();<br>
}<br>
e.printStackTrace() ;<br>
}<br>
return v ;<br>
} <br>
<br>
//Process the HTTP Get request<br>
public void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { <br>
<br>
PrintWriter out = new PrintWriter (response.getOutputStream());<br>
response.setContentType("text/html");<br>
out.println("");<br>
out.println("The servlet has received a GET. This is the reply.");<br>
out.println("");<br>
out.println(""); <br>
<br>
// 将记录集循环输出到页面。<br>
Vector v = new Vector() ;<br>
v = this.getForumList() ;<br>
for (int i=0; i"<br>
+ ""+s[0]+""<br>
+ ""+s[1]+""<br>
+ ""+s[2]+""<br>
+ ""+s[3]+""<br>
+ ""+s[4]+"");<br>
}<br>
out.println("");<br>
out.close();<br>
}<br>
}
</table>
<p align="center"><script src="../../2.js"></script></a>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -