连接池实例

来源：互联网发布：webshell黑客seobaidu 编辑：程序博客网时间：2024/06/05 21:32

<%@ page language="java" contentType="text/html; charset=GB18030"
pageEncoding="GB18030"%>
<%@ page import="java.sql.*" %>
<%@ page import="javax.naming.*" %>
<%@ page import="javax.sql.DataSource" %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=GB18030">
<title>Insert title here</title>
</head>
<body>

<%
try {

    // コンテキスト初期化
    InitialContext initContext = new InitialContext();
    Context envContext = (Context)initContext.lookup("java:/comp/env");
    DataSource ds = (DataSource)envContext.lookup("jdbc/orcl");

// データベース接続
Connection connection = ds.getConnection();

DatabaseMetaData data = connection.getMetaData();

System.out.println("HHHH ::: " + data.getUserName());

connection.close();

ds = null;

}
//-----------------------------------------------------------------------------
//エラー処理
//-----------------------------------------------------------------------------
catch (NamingException namingEx) {
    namingEx.printStackTrace();
}
catch (SQLException sqlExcp) {                                          // SQL例外
    sqlExcp.printStackTrace();
}
%>

</body>
</html>