jdni 접속 테스트(JSP)
작성자 관리자 작성시간 2004-06-02 13:20:27
 

<%@ page import="java.sql.*, javax.naming.*, javax.sql.*"%>
<%
Context initCtx = new InitialContext();
Context envCtx = (Context) initCtx.lookup("java:comp/env");
DataSource ds = (DataSource) envCtx.lookup("jdbc/soriDB");
Connection conn = ds.getConnection();
Statement stmt = conn.createStatement();
String query = "select  sysdate from dual";
ResultSet rs = stmt.executeQuery(query);
if(rs.next())
{  out.println(rs.getTimestamp(1));}
  rs.close();
  stmt.close();
  conn.close();
  %>


목록 | 입력 | 수정 | 답변 | 삭제