?? pool_connection.jsp
字號(hào):
<%@ page language="java" contentType="text/html; charset=GBK"%>
<%@ page import="java.sql.*,javax.naming.*,javax.sql.*" %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title>通過數(shù)據(jù)庫連接池建立連接</title>
</head>
<body>
<%
Connection con = null;
try {
Context initContext = new InitialContext();
Context envContext = (Context)initContext.lookup("java:/comp/env");
DataSource ds = (DataSource)envContext.lookup("jdbc/sqlserver");
con = ds.getConnection();
out.println("<H1>");
out.println("第一次通過數(shù)據(jù)庫連接池連接數(shù)據(jù)庫成功!<br> con="+con);
out.println("</H1>");
//con.close();
con = ds.getConnection();
out.println("<H1>");
out.println("第二次通過數(shù)據(jù)庫連接池連接數(shù)據(jù)庫成功!<br> con="+con);
out.println("</H1>");
con.close();
} catch (Exception e) {// 如果出現(xiàn)異常,會(huì)打印堆棧里異常的信息
e.printStackTrace();
}
%>
</body>
</html>
?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號(hào)
Ctrl + =
減小字號(hào)
Ctrl + -