JSP로 맹글어본 커넥션

급할때는 역시 날코딩이 쵝오!!!
<%@ page contentType="text/html;charset=euc-kr" pageEncoding="euc-kr" %> <%@ page import="java.sql.*" %> <%! Connection con = null; PreparedStatement pstmt = null; ResultSet rs = null; String url = "jdbc:oracle:thin:@128.0.0.1:1521:WWW"; String user = "scott"; String password = "tiger"; StringBuffer sql = null; %> <% try { Class.forName("oracle.jdbc.driver.OracleDriver"); con = DriverManager.getConnection(url, user, password); sql = new StringBuffer(); sql.append("select sysdate from dual"); pstmt = con.prepareStatement(sql.toString()); rs = pstmt.executeQuery(); if (rs.next()) { out.println(rs.getString(1)); } } catch (Exception e) { e.printStackTrace(); } finally { try { if (rs != null) { rs.close(); } if (pstmt != null) { pstmt.close(); } if (con != null) { con.close(); } } catch (Exception e2) { e2.printStackTrace(); } } %>