★

─────────────────────────────────────────────

★ JDBC Connection

─────────────────────────────────────────────

dbconnection.jsp

<%@ page language="java" contentType="text/html; charset=EUC-KR"
    pageEncoding="EUC-KR"%>
<%@ page import="java.sql.*"%>
<%@ page import="javax.naming.*" %>
<%@ page import="javax.sql.DataSource" %>

<%!
 Connection con = null;
 DataSource ds = null;
%>

<%
 try
 {
  Context ctx = new InitialContext();
  ds=(DataSource)ctx.lookup("java:comp/env/jdbc/oracle");
  con=ds.getConnection();
  System.out.println("Connection Ok");
 }
 catch(NamingException ne) { ne.printStackTrace(); }
 catch(SQLException se) { se.printStackTrace(); }
 finally
 {
  try
  {
   if(con!=null) con.close();
   System.out.println("Connection Close");
  }
  catch(Exception e) { e.printStackTrace(); }
 }
%>