* server.xml
< Context docBase="web-study-10" path="/web-study-10"
reloadable="true"
source="org.eclipse.jst.jee.server:web-study-10">
</Context>
* Context태그 내 아래내용 삽입
< Resource name="jdbc/myoracle" auth="Container"
type="javax.sql.DataSource" driverClassName="oracle.jdbc.OracleDriver"
url="jdbc:oracle:thin:@127.0.0.1:1521:xe"
username="ezen" password="1234" maxTotal="20" maxIdle="10"
maxWaitMillis="-1"/ >
- username="DB사용자명" 수정
- password="DB비밀번호" 수정
* 완료 상태
< Context docBase="web-study-10" path="/web-study-10"
reloadable="true"
source="org.eclipse.jst.jee.server:web-study-10">
<Resource name="jdbc/myoracle" auth="Container"
type="javax.sql.DataSource" driverClassName="oracle.jdbc.OracleDriver"
url="jdbc:oracle:thin:@127.0.0.1:1521:xe"
username="ezen" password="1234" maxTotal="20" maxIdle="10"
maxWaitMillis="-1"/>
</Context >
* DBCP 연동
<%@page import="java.sql.Connection"%>
<%@page import="javax.sql.DataSource"%>
<%@page import="javax.naming.InitialContext"%>
<%@page import="javax.naming.Context"%>
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Insert title here</title>
</head>
<body>
<h1>DB 연동</h1>
<%
Context initContext = new InitialContext();
Context envContext = (Context)initContext.lookup("java:/comp/env");
DataSource ds = (DataSource)envContext.lookup("jdbc/myoracle");
Connection conn = ds.getConnection();
out.print("DB연동 성공");
%>
</body>
</html>
