<%@ 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>