─────────────────────────────────────────────
★ 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(); }
}
%>
lib.zip
