Last Modified : 2007.05.19
DataSource
지금까지 개발자가 구현한 커넥션 풀링 관리 클래스를 이용한 JDBC 프로그래밍을 하였습니다.
JDBC 2.0 부터 javax.sql.DataSource 인터페이스를 제공하여 컨테이너가 관리하는 커넥션 풀링 클래스를 이용할 수 있게 되었습니다.
지금부터는 DataSource 를 사용하기 위한 설정과 프로그래밍 예를 설명합니다.
톰캣에서 DataSource 설정
우선 우리의 웹 애플리케이션이 Use Naming 설정이 True 이어야 합니다.
확인한 후 톰캣 admin 툴을 이용해서 아래 그림에 제시한 대로 작업을 진행합니다.
위 그림처럼 설정 후 server.xml 파일을 열어 admin 툴이 변경을 가한 아래 부분을 복사합니다.
<Resource name="jdbc/orcl" type="javax.sql.DataSource" maxActive="4" maxIdle="2" username="scott" maxWait="5000" driverClassName="oracle.jdbc.driver.OracleDriver" password="tiger" url="jdbc:oracle:thin:@127.0.0.1:1521:orcl"/>
복사한 위의 내용을 웹 애플리케이션의 xml 파일에 복사합니다. ( 만일 ROOT 애플리케이셔이라면 ROOT.xml )
예를 위해 ROOT.xml 파일은 아래와 같습니다.
ROOT.xml
<?xml version="1.0" encoding="UTF-8"?>
<Context
docBase="C:/www/jsp/project"
reloadable="true">
<Resource
name="jdbc/orcl"
type="javax.sql.DataSource"
maxActive="4"
maxIdle="2"
username="scott"
maxWait="5000"
driverClassName="oracle.jdbc.driver.OracleDriver"
password="tiger"
url="jdbc:oracle:thin:@127.0.0.1:1521:orcl"/>
</Context>
마지막으로 web.xml 파일에 아래 코드를 추가합니다.
web.xml
... <resource-ref> <description>Oracle Datasource example</description> <res-ref-name>jdbc/orcl</res-ref-name> <res-type>javax.sql.DataSource</res-type> <res-auth>Container</res-auth> </resource-ref> ...
지금까지 만든 게시판에서 이용한 커넥션 풀링 기법은 어느 개발자가 만든 커넥션 풀링을 관리하는 클래스를 이용한 것이었습니다.
이제 기존의
게시판을 DataSource 를 이용한 게시판으로 수정한 파일을 제공하겠습니다.
JSP파일 & 서블릿
위 파일을 다운로드 받아서
JSP파일은 /board1/ 디렉토리에 복사합니다.
서블릿은 컴파일하고 web.xml 파일에서 서블릿 매핑을 추가합니다.
컴파일할 때 톰캣홈 디렉토리/common/lib/naming-factory-dbcp.jar 파일을 클래스 패스에 추가해 주어야 에러가 나지 않게 컴파일 할 수 있습니다.
모든 과정이 끝났으면 /board1/list.jsp 를 방문하여 테스트합니다.
list.jsp
<%@ page contentType="text/html;charset=euc-kr" %>
<%@ page import="java.sql.*,javax.sql.*,javax.naming.*,net.java_school.util.Log" %>
<html>
<head>
<script language="javascript">
function goView(num) {
var form = document.frmView;
form.num.value = num;
form.submit();
}
function goList( cpage ) {
var form = document.frmList;
form.cur_page.value = cpage;
form.submit();
}
function goWrite() {
var form = document.frmWrite;
form.submit();
}
</script>
</head>
<body>
<%
Log log = new Log();
request.setCharacterEncoding("euc-kr");
// 파라미터를 받는다.
int cur_page = (request.getParameter("cur_page") == null) ? 1 :
Integer.parseInt(request.getParameter("cur_page"));
String keyfield = request.getParameter("keyfield");
if ( keyfield == null ) keyfield="";
String key = request.getParameter("key");
if ( key == null ) key = "";
DataSource ds = null;
Context ic = null;
Connection conn = null;
PreparedStatement prepare = null;
ResultSet rs = null;
String query = null;
try {
ic = new InitialContext();
ds = (DataSource)ic.lookup("java:comp/env/jdbc/orcl");
} catch ( NamingException ne ) {
log.debug( ne.getMessage() );
}
int total_record = 0; //총 데이터 개수를 저장할 변수
try {
conn = ds.getConnection();
if ( keyfield.equals("") || key.equals("") ) {
query = "select count(*) from board";
} else {
query = "select count(*) from board where " + keyfield + " like '%" + key + "%'";
}
prepare = conn.prepareStatement( query );
rs = prepare.executeQuery();
rs.next();
total_record = rs.getInt(1);
} catch ( SQLException e ) {
} finally {
try {
if ( rs != null ) rs.close();
if ( prepare != null) prepare.close();
conn.close();
//log.close();로그파일의 파일 출력 스트림을 반환하지 않는다.
} catch ( SQLException e ) {}
}
// 출력리스트 시작 레코드 계산
int start = (cur_page - 1) * 10 + 1;
// 출력리스트 마지막 레코드 계산
int end = start + 10 -1;
// 해당 페이지의 레코드 셋을 구한 후 출력합니다.
try {
conn = ds.getConnection();
if ( keyfield.equals("") || key.equals("") ) {
query = "SELECT num,subject,wdate " +
"FROM(SELECT ROWNUM R, A.* FROM(" +
"SELECT num,subject,wdate FROM board ORDER BY num DESC) A)" +
"WHERE R BETWEEN " + start + " and " + end;
} else {
query = "SELECT num,subject,wdate " +
"FROM(SELECT ROWNUM R, A.* FROM(" +
"SELECT num,subject,wdate FROM board " +
"WHERE " + keyfield + " LIKE '%" + key + "%' ORDER BY num DESC) A)" +
"WHERE R BETWEEN " + start + " and " + end;
}
prepare = conn.prepareStatement( query );
rs = prepare.executeQuery();
while( rs.next() ) {
int num = rs.getInt( "num" );
String subject = rs.getString( "subject" );
Date wdate = rs.getDate( "wdate" );
%>
<a href="javascript:goView('<%=num%>')"><%=subject%></a><%=wdate.toString()%><br>
<%
} // while statment end
} catch( SQLException e ) {
log.debug( "Error Source:board1/list.jsp : SQLException" );
log.debug( "SQLState : " + e.getSQLState() );
log.debug( "Message : " + e.getMessage() );
log.debug( "Oracle Error Code : " + e.getErrorCode() );
log.debug( "Query : " + query );
} finally {
try {
if ( rs != null ) rs.close();
if ( prepare != null) prepare.close();
conn.close();
log.close(); // 더이상 사용자 정의 로그를 사용하지 않아도 되기 때문에
} catch ( SQLException e ){}
}
%>
<br>
<%
// 전체 페이지(total_page)를 구한다.
int total_page = 1;
if ( total_record != 0 ) {
if ( ( total_record % 10 ) == 0 ) {
total_page = ( total_record / 10 );
} else {
total_page = ( total_record / 10 + 1);
}
}
// 블록당 페이지 수를 정한다.
int page_per_block = 7;
// 현재 페이지가 속한 블록(block)을 계산한다.
int block = 1;
if ( ( cur_page % page_per_block ) == 0 ) {
block = cur_page / page_per_block;
} else {
block = cur_page / page_per_block + 1;
}
// 블록에서 링크할 첫번째 페이지와 마지막 페이지를 계산한다.
int first_page = ( block - 1 ) * page_per_block + 1;
int last_page = block * page_per_block;
// 총 블록수를 계산한다.
int total_block = 1;
if ( (total_page % page_per_block ) == 0 ) {
total_block = total_page / page_per_block;
} else {
total_block = total_page / page_per_block + 1;
}
// 쓸데없는 페이지 링크를 만들지 않기 위해서
if ( block >= total_block ) {
last_page = total_page;
}
// 현재 block > 1 면 [이전]링크를 만들고 first_page - 1 페이지번호로 링크
int my_page = 0;
if ( block > 1 ) {
my_page = first_page -1;
%>
<a href="javascript:goList( '<%=my_page%>' )">[이전]</a>
<%
} // if statment end
// 루프문을 이용해서 첫번째 페이지부터 마지막 페이지까지 링크를 만든다.
for ( int i = first_page; i <= last_page; i++ ) {
%>
<a href="javascript:goList( '<%=i%>' )">[<%=i%>]</a>
<%
} // for statment end
// block < total_block 면 [다음]링크를 만들고 last_page + 1 를 페이지번호로 링크
if (block < total_block ) {
my_page = last_page + 1;
%>
<a href="javascript:goList( '<%=my_page%>' )">[다음]</a>
<%
} // if statement end
%>
<br>
<form name="frmSearch" action="list.jsp" method="post">
<select name="keyfield">
<option value="subject" selected>제목</option>
<option value="content">내용</option>
</select>
<input type="text" size="10" maxlength="30" name="key" />
<input type="submit" value="search" />
</form>
<a href="javascript:goWrite()">새글 쓰기</a>
<form name="frmView" action="view.jsp" method="post">
<input type="hidden" name="num" />
<input type="hidden" name="cur_page" value="<%=cur_page%>" />
<input type="hidden" name="keyfield" value="<%=keyfield%>" />
<input type="hidden" name="key" value="<%=key%>" />
</form>
<form name="frmList" action="list.jsp" method="post">
<input type="hidden" name="cur_page" />
<input type="hidden" name="keyfield" value="<%=keyfield%>" />
<input type="hidden" name="key" value="<%=key%>" />
</form>
<form name="frmWrite" action="write_form.jsp" method="post">
<input type="hidden" name="cur_page" value="<%=cur_page%>" />
<input type="hidden" name="keyfield" value="<%=keyfield%>" />
<input type="hidden" name="key" value="<%=key%>" />
</form>
</body>
</html>
write_form.jsp
<%@ page contentType="text/html;charset=euc-kr" %>
<%
request.setCharacterEncoding("euc-kr");
String cur_page = request.getParameter( "cur_page" );
String keyfield = request.getParameter( "keyfield" );
String key = request.getParameter( "key" );
%>
<html>
<head>
<script language="javascript">
function goList() {
var form = document.frmList;
form.submit();
}
</script>
</head>
<body>
<h1>새글 쓰기</h1>
<hr>
<form name="frmWrite" method="post" action="../servlet/BoardWriter1">
제목 : <input type="text" name="subject" size="45" /><br />
본문 : <textarea name="content" rows="10" cols="60"></textarea><br />
<input type="submit" value="전송" />
<input type="reset" value="취소" /><br />
</form>
<input type="button" value="목록" onClick="javascript:goList()">
<form name="frmList" method="post" action="list.jsp">
<input type="hidden" name="cur_page" value="<%=cur_page%>" />
<input type="hidden" name="keyfield" value="<%=keyfield%>" />
<input type="hidden" name="key" value="<%=key%>" />
</form>
</body>
</html>
BoardWriter1.java
package net.java_school.board;
import java.io.*;
import javax.servlet.*;
import javax.servlet.http.*;
import java.sql.*;
import javax.sql.*;
import javax.naming.*;
import net.java_school.util.*;
public class BoardWriter1 extends HttpServlet {
PreparedStatement prepare = null;
DataSource ds = null;
// 입력 순서 : 시퀀스 , 제목, 소개글, 본문
String query = "insert into board values ( seq_board_num.nextval, ?, ?, sysdate )";
public void init() throws ServletException {
try {
Context ic = new InitialContext();
ds = (DataSource)ic.lookup("java:comp/env/jdbc/orcl");
} catch ( NamingException ne ) {}
}
public void doPost( HttpServletRequest req, HttpServletResponse res )
throws ServletException, IOException {
req.setCharacterEncoding( "euc-kr" );
Log log = new Log();
String subject = req.getParameter( "subject" );
String content = req.getParameter( "content" );
Connection con = null;
try {
con = ds.getConnection();
prepare = con.prepareStatement( query );
prepare.setString( 1, subject ); //제목 부분
prepare.setString( 2, content ); // 본분 부분
prepare.executeUpdate(); // 쿼리 실행
} catch ( SQLException e ) {
log.debug( "Error Source:BoardWriter.java : SQLException" );
log.debug( "SQLState : " + e.getSQLState() );
log.debug( "Message : " + e.getMessage() );
log.debug( "Oracle Error Code : " + e.getErrorCode() );
log.debug( "Query : " + query );
} finally {
try {
prepare.close();
con.close();
log.close();
} catch ( SQLException e ){}
String path = req.getContextPath();
res.sendRedirect( path + "/board1/list.jsp" );
}
}
}
view.jsp
<%@ page contentType="text/html;charset=euc-kr" %>
<%@ page import="java.sql.*,javax.sql.*,javax.naming.*,net.java_school.util.Log" %>
<html>
<head>
<script language="javascript">
function goList() {
var form = document.frmList;
form.submit();
}
function goModify() {
var form = document.frmModify;
form.submit();
}
function goDelete() {
var form = document.frmDelete;
form.submit();
}
</script>
</head>
<body>
<%
request.setCharacterEncoding( "euc-kr" );
// 파라미터를 받는다.
int num = Integer.parseInt( request.getParameter( "num" ) );
String cur_page = request.getParameter( "cur_page" );
String keyfield = request.getParameter( "keyfield" );
String key = request.getParameter( "key" );
Log log = new Log();
DataSource ds = null;
Context ic = null;
Connection conn = null;
PreparedStatement prepare = null;
ResultSet rs = null;
String query = null;
// 커넥션을 얻는다.
try {
ic = new InitialContext();
ds = (DataSource)ic.lookup("java:comp/env/jdbc/orcl");
} catch ( NamingException ne ) {
log.debug( ne.getMessage() );
}
query = "select num,subject,content,wdate from board where num = " + num;
try {
conn = ds.getConnection();
prepare = conn.prepareStatement( query );
rs = prepare.executeQuery();
while ( rs.next() ) {
String subject = rs.getString( "subject" );
String content = rs.getString( "content" );
Date wdate = rs.getDate( "wdate" );
%>
<%=subject%></a><br>
<hr>
<%=content%><br>
<hr>
<%=wdate.toString()%><br>
<%
} // while statement end
} catch ( SQLException e ) {
log.debug( "Error Source:board1/view.jsp : SQLException" );
log.debug( "SQLState : " + e.getSQLState() );
log.debug( "Message : " + e.getMessage() );
log.debug( "Oracle Error Code : " + e.getErrorCode() );
log.debug( "Query : " + query );
} finally {
try {
if ( rs != null ) rs.close();
if ( prepare != null ) prepare.close();
conn.close();
log.close(); // 더이상 사용자 정의 로그 파일을 이용하지 않으므로
} catch ( SQLException e ){}
}
%>
<form name="frmModify" method="post" action="modify_form.jsp">
<input type="hidden" name="num" value="<%=num%>" />
<input type="hidden" name="cur_page" value="<%=cur_page%>" />
<input type="hidden" name="keyfield" value="<%=keyfield%>" />
<input type="hidden" name="key" value="<%=key%>" />
</form>
<form name="frmDelete" method="post" action="delete_confirm.jsp">
<input type="hidden" name="num" value="<%=num%>" />
<input type="hidden" name="cur_page" value="<%=cur_page%>" />
<input type="hidden" name="keyfield" value="<%=keyfield%>" />
<input type="hidden" name="key" value="<%=key%>" />
</form>
<form name="frmList" method="post" action="list.jsp">
<input type="hidden" name="cur_page" value="<%=cur_page%>" />
<input type="hidden" name="keyfield" value="<%=keyfield%>" />
<input type="hidden" name="key" value="<%=key%>" />
</form>
<br />
<input type="button" value="목록" onClick="javascript:goList()" />
<input type="button" value="수정" onClick="javascript:goModify()" />
<input type="button" value="삭제" onClick="javascript:goDelete()" />
</body>
</html>
modify_form.jsp
<%@ page contentType="text/html;charset=euc-kr" %>
<%@ page import="java.sql.*,javax.sql.*,javax.naming.*,net.java_school.util.Log" %>
<%
request.setCharacterEncoding( "euc-kr" );
// 파라미터를 받는다.
int num = Integer.parseInt( request.getParameter( "num" ) );
String cur_page = request.getParameter( "cur_page" );
String keyfield = request.getParameter( "keyfield" );
String key = request.getParameter( "key" );
Log log = new Log();
DataSource ds = null;
Context ic = null;
Connection conn = null;
PreparedStatement prepare = null;
ResultSet rs = null;
String subject = null;
String content = null;
String query = "select subject,content from board where num =" + num;
// 커넥션을 얻는다.
try {
ic = new InitialContext();
ds = (DataSource)ic.lookup("java:comp/env/jdbc/orcl");
} catch ( NamingException ne ) {
log.debug( ne.getMessage() );
}
try {
conn = ds.getConnection();
prepare = conn.prepareStatement( query );
rs = prepare.executeQuery();
while( rs.next() ) {
subject = rs.getString( "subject" );
content = rs.getString( "content" );
}
} catch ( SQLException e ) {
log.debug( "Error Source:board1/modify_form.jsp : SQLException" );
log.debug( "SQLState : " + e.getSQLState() );
log.debug( "Message : " + e.getMessage() );
log.debug( "Oracle Error Code : " + e.getErrorCode() );
log.debug( "Query : " + query );
} finally {
try {
if ( rs != null ) rs.close();
if ( prepare != null) prepare.close();
conn.close();
log.close();
} catch ( SQLException e ){}
}
%>
<html>
<head>
<script language="javascript">
function goView() {
var form = document.frmView;
form.submit();
}
</script>
</head>
<body>
<h1>글 수정</h1>
<hr>
<form name="frm" method="POST" action="../servlet/BoardModifier1">
<input type="hidden" name="num" value="<%=num%>" />
<input type="hidden" name="cur_page" value="<%=cur_page%>" />
<input type="hidden" name="keyfield" value="<%=keyfield%>" />
<input type="hidden" name="key" value="<%=key%>" />
제목 : <input type="text" name="subject" value="<%=subject%>" /><br />
본분 : <textarea name="content" rows="10" cols="60"><%=content%></textarea><br />
<input type="submit" value="전송" />
<input type="reset" value="취소" />
</form>
<form name="frmView" method="post" action="view.jsp">
<input type="hidden" name="num" value="<%=num%>" />
<input type="hidden" name="cur_page" value="<%=cur_page%>" />
<input type="hidden" name="keyfield" value="<%=keyfield%>" />
<input type="hidden" name="key" value="<%=key%>" />
</form>
<br>
<input type="button" value="내용보기" onClick="javascript:goView()" />
</body>
</html>
BoardModifier1.java
package net.java_school.board;
import java.io.*;
import javax.servlet.*;
import javax.servlet.http.*;
import java.sql.*;
import javax.sql.*;
import javax.naming.*;
import net.java_school.util.Log;
public class BoardModifier1 extends HttpServlet {
DataSource ds = null;
PreparedStatement prepare = null;
String query = "UPDATE board SET subject = ?, content = ? WHERE num = ?";
public void init() throws ServletException {
try {
Context ic = new InitialContext();
ds = (DataSource)ic.lookup("java:comp/env/jdbc/orcl");
} catch ( NamingException ne ) {}
}
public void doPost( HttpServletRequest req, HttpServletResponse res )
throws ServletException, IOException {
req.setCharacterEncoding("euc-kr");
res.setContentType("text/html;charset=euc-kr");
PrintWriter out=res.getWriter();
Log log = new Log();
int num = Integer.parseInt( req.getParameter( "num" ) );
String cur_page = req.getParameter( "cur_page" );
String keyfield = req.getParameter( "keyfield" );
String key = req.getParameter( "key" );
String subject = req.getParameter( "subject" );
String content = req.getParameter( "content" );
Connection con = null;
try {
con = ds.getConnection();
prepare = con.prepareStatement( query );
prepare.setString( 1, subject ); //제목 부분
prepare.setString( 2, content ); // 본분 부분
prepare.setInt( 3, num ); // 시퀀스 primary key
prepare.executeUpdate(); // 쿼리 실행
} catch ( SQLException e ) {
log.debug( "Error Source:BoardModifier1.java : SQLException" );
log.debug( "SQLState : " + e.getSQLState() );
log.debug( "Message : " + e.getMessage() );
log.debug( "Oracle Error Code : " + e.getErrorCode() );
log.debug( "Query : " + query );
} finally {
try {
if ( prepare != null ) prepare.close();
con.close();
log.close();
} catch ( SQLException e ){}
String path = req.getContextPath();
String formstr = "";
formstr = "<form name=frmView method=post action="+path+"/board1/view.jsp>";
formstr += "<input type=hidden name=num value='"+num+"' />";
formstr += "<input type=hidden name=cur_page value='"+cur_page+"' />";
formstr += "<input type=hidden name=keyfield value='"+keyfield+"' />";
formstr += "<input type=hidden name=key value='"+key+"' />";
formstr += "</form>";
out.println(formstr);
String scriptstr = "";
scriptstr += "<script language=javascript>";
scriptstr += "function goView() {";
scriptstr += " document.frmView.submit(); }";
scriptstr += "</script>";
scriptstr += "<script>goView();</script>";
log.debug(scriptstr);
out.println(scriptstr);
}
}
}
delete_confirm.jsp
<%@ page contentType="text/html;charset=euc-kr" %>
<%@ page import="java.sql.*,javax.sql.*,javax.naming.*,net.java_school.util.Log" %>
<%
Log log = new Log();
// 파라미터를 받는다.
int num = Integer.parseInt( request.getParameter( "num" ) );
String cur_page = request.getParameter( "cur_page" );
String keyfield = request.getParameter( "keyfield" );
String key = request.getParameter( "key" );
DataSource ds = null;
Context ic = null;
Connection conn = null;
PreparedStatement prepare = null;
ResultSet rs = null;
String subject = null;
String content = null;
String query = "select subject,content from board where num = " + num;
// 커넥션을 얻는다.
try {
ic = new InitialContext();
ds = (DataSource)ic.lookup("java:comp/env/jdbc/orcl");
} catch ( NamingException ne ) {
log.debug( ne.getMessage() );
}
try {
conn = ds.getConnection();
prepare = conn.prepareStatement( query );
rs = prepare.executeQuery();
while ( rs.next() ) {
subject = rs.getString( "subject" );
content = rs.getString( "content" );
}
} catch ( SQLException e ) {
log.debug( "Error Source:delete_confirm.jsp : SQLException" );
log.debug( "SQLState : " + e.getSQLState() );
log.debug( "Message : " + e.getMessage() );
log.debug( "Oracle Error Code : " + e.getErrorCode() );
log.debug( "Query : " + query );
} finally {
try {
if ( rs != null ) rs.close();
if ( prepare != null ) prepare.close();
conn.close();
log.close();
} catch ( SQLException e ){}
}
%>
<html>
<head>
<script language="javascript">
function goDelete() {
var form = document.frmDelete;
form.submit();
}
</script>
</head>
<body>
<h1>삭 제 확 인</h1>
<hr>
제목 : <%=subject%><br />
본문 : <%=content%><br />
위 글을 정말로 삭제하겠습니까?<br />
<input type="button" value="삭제" onClick="javascript:goDelete()" />
<input type="button" value="취소" onClick="javascript:history.go(-1)" /></td>
<form name="frmDelete" method="post" action="../servlet/BoardDeleter1">
<input type="hidden" name="num" value="<%=num%>" />
<input type="hidden" name="cur_page" value="<%=cur_page%>" />
<input type="hidden" name="keyfield" value="<%=keyfield%>" />
<input type="hidden" name="key" value="<%=key%>" />
</form>
</body>
</html>
BoardDeleter1.java
package net.java_school.board;
import java.io.*;
import javax.servlet.*;
import javax.servlet.http.*;
import java.sql.*;
import javax.sql.*;
import javax.naming.*;
import net.java_school.util.Log;
public class BoardDeleter1 extends HttpServlet {
DataSource ds = null;
PreparedStatement prepare = null;
String query = "DELETE board WHERE num = ?";
public void init() throws ServletException {
try {
Context ic = new InitialContext();
ds = (DataSource)ic.lookup("java:comp/env/jdbc/orcl");
} catch ( NamingException ne ) {}
}
public void doPost( HttpServletRequest req, HttpServletResponse res )
throws ServletException, IOException {
req.setCharacterEncoding("euc-kr");
res.setContentType("text/html;charset=euc-kr");
PrintWriter out=res.getWriter();
Log log = new Log();
int num = Integer.parseInt( req.getParameter( "num" ) );
String cur_page = req.getParameter( "cur_page" );
String keyfield = req.getParameter( "keyfield" );
String key = req.getParameter( "key" );
Connection con = null;
try {
con = ds.getConnection();
prepare = con.prepareStatement( query );
prepare.setInt( 1, num );
prepare.executeUpdate(); // 쿼리 실행
} catch ( SQLException e ) {
log.debug( "Error Source:BoardDeleter.java : SQLException" );
log.debug( "SQLState : " + e.getSQLState() );
log.debug( "Message : " + e.getMessage() );
log.debug( "Oracle Error Code : " + e.getErrorCode() );
log.debug( "Query : " + query );
} finally {
try {
if ( prepare != null ) prepare.close();
con.close();
log.close();
} catch ( SQLException e ){}
String path = req.getContextPath();
String formstr = "";
formstr = "<form name=frmList method=post action="+path+"/board1/list.jsp>";
formstr += "<input type=hidden name=cur_page value='"+cur_page+"' />";
formstr += "<input type=hidden name=keyfield value='"+keyfield+"' />";
formstr += "<input type=hidden name=key value='"+key+"' />";
formstr += "</form>";
out.println(formstr);
String scriptstr = "";
scriptstr += "<script language=javascript>";
scriptstr += "function goList() {";
scriptstr += " document.frmList.submit(); }";
scriptstr += "</script>";
scriptstr += "<script>goList();</script>";
out.println(scriptstr);
}
}
}