1. 첨부한 zip 파일 압축을 푼 후 jar파일을 라이브러리에 추가

================================

2. web.xml

================================

<resource-ref>
<description>Oraclejava DB Connection</description>

<res-ref-name>jdbc/oraclejava</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
</resource-ref>

=================================

3. Context XML파일의 설정예(Tomcat의 경우 Topmcat_Home/conf/catalina/localhost 아래에 컨텍스트이름.xml)

=================================

Context명이 web이라고 할때

<Context path="/web" reloadable="true" docBase="C:\java2\project\web" workDir="C:\java2\project\web\work">

<Resource name="jdbc/oraclejava"
auth="Container"
type="javax.sql.DataSource"
username="scott"
password="tiger"
driverClassName="oracle.jdbc.driver.OracleDriver"
url="jdbc:oracle:thin:@192.168.1.131:1521:ORCL"/>

</Context>

==================

4. datasource.jsp

==================

<%@ page language="java" contentType="text/html; charset=EUC-KR"
pageEncoding="EUC-KR"%>
<%@ page import="javax.naming.*" %>
<%@ page import="java.sql.*" %>
<%@ page import="javax.sql.*" %>
<%!
public String nvl(String param) {
return param != null? param:"";
}
%>
<html>
<head>
<title></title>
<meta http-equiv="content-type" content="text/html; charset=euc-kr">
</head>
<body>
<%
// 데이터베이스 접속
InitialContext ctx = null;
DataSource ds = null;
Connection con = null;
PreparedStatement pstmt = null;
ResultSet rs = null;
String sql="SELECT * FROM TAB ";

try {
ctx = new InitialContext();
ds = (DataSource) ctx.lookup("java:comp/env/jdbc/oraclejava");
con = (Connection) ds.getConnection();

pstmt = con.prepareStatement(sql);
rs = pstmt.executeQuery();

out.println("<table>");
while(rs.next()) {
out.println("<tr>\n");
for (int i = 1; i < 3; i++)
out.println("<td>" + nvl(rs.getString(i)) + "</td>");
out.println("</tr>\n");
}
out.println("</table>");
} catch (NamingException e) {
e.printStackTrace();
} catch (NullPointerException e) {
e.printStackTrace();
} catch (SQLException e) {
e.printStackTrace();
} catch (Exception e) {
e.printStackTrace();
} finally {
if (rs != null)
try {
rs.close();
} catch (Exception e) {
// quit;
}

if (pstmt != null)
try {
pstmt.close();
} catch (Exception e) {
// quit
}

if (con != null)
try {
con.close();
} catch (Exception e) {
// quit
}
}
%>
</body>
</html>