发表于 2009-1-5 19:48
| 
Servlet涓璲dbc搴旂敤楂樼骇绡囷紙浜旓級
鍙戝竷: 2008-12-03 23:02 | 浣滆: 缃戠粶杞浇 | 鏉ユ簮: 缃戠粶杞浇 | 鏌ョ湅: 11娆
銆銆涓銆侀鍏堢畝鍗曚粙缁嶄竴涓婼ervlet鐨勭敓鍛藉懆鏈燂細
銆銆Servlet API瀹氫箟鐨剆ervlet鐢熷懡鍛ㄦ湡濡備笅锛
1銆 Servlet 琚垱寤虹劧鍚庡垵濮嬪寲锛坕nit()鏂规硶锛夈
2銆 涓0涓垨澶氫釜瀹㈡埛璋冪敤鎻愪緵鏈嶅姟锛坰ervice()鏂规硶锛夈
3銆 Servlet琚攢姣侊紝鍐呭瓨琚洖鏀讹紙destroy()鏂规硶锛夈
銆銆浜屻乻ervlet涓娇鐢ㄨ繛鎺ユ睜鐨勫疄渚
銆銆浣跨敤杩炴帴姹犵殑servlet鏈変笁涓樁娈电殑鍏稿瀷琛ㄧ幇鏄細
1锛 鍦╥nit()涓紝璋冪敤DBConnectionManager.getInstance()鐒跺悗灏嗚繑鍥炵殑寮曠敤淇濆瓨鍦ㄥ疄渚嬪彉閲忎腑銆
2锛 鍦╯evice()涓紝璋冪敤getConnection()锛屾墽琛屼竴绯诲垪鏁版嵁搴撴搷浣滐紝鐒跺悗璋冪敤freeConnection()褰掕繕杩炴帴銆
3锛 鍦╠estroy()涓紝璋冪敤release()鏉ラ噴鏀炬墍鏈夌殑璧勬簮锛屽苟鍏抽棴鎵鏈夌殑杩炴帴銆
銆銆涓嬮潰鐨勪緥瀛愭紨绀哄浣曚娇鐢ㄨ繛鎺ユ睜銆
import java.io.*;
import java.sql.*;
import javax.servlet.*;
import javax.servlet.http.*;
public class TestServlet extends HttpServlet {
private DBConnectionManager connMgr;
public void init(ServletConfig conf) throws ServletException {
super.init(conf);
connMgr = DBConnectionManager.getInstance();
}
public void service(HttpServletRequest req, HttpServletResponse res)
throws IOException {
res.setContentType("text/html");
PrintWriter out = res.getWriter();
Connection con = connMgr.getConnection("idb");
if (con == null) {
out.println("Cant get connection");
return;
}
ResultSet rs = null;
ResultSetMetaData md = null;
Statement stmt = null;
try {
stmt = con.createStatement();
rs = stmt.executeQuery("SELECT * FROM EMPLOYEE");
md = rs.getMetaData();
out.println("
Employee data
");
while (rs.next()) {
out.println("
");
for (int i = 1; i < md.getColumnCount(); i++) {
out.print(rs.getString(i) + ", ");
}
}
stmt.close();
rs.close();
}
catch (SQLException e) {
e.printStackTrace(out);
}
connMgr.freeConnection("idb", con);
}
public void destroy() {
connMgr.release();
super.destroy();
}
}
