jdbc 연동 테스트
작성자 관리자 작성시간 2004-09-09 16:48:24
 

<%@ page language="java" import="java.sql.*" contentType="text/html;charset=KSC5601" %>


<%

Class.forName("oracle.jdbc.driver.OracleDriver");

Connection Conn =
DriverManager.getConnection("jdbc:oracle:thin:@61.36.190.132:1521:btob
db","system","manager");

Statement stmt = Conn.createStatement();

ResultSet rs = stmt.executeQuery("select * from tab");

if (rs==null)
{
out.println("zzz");
}
else {
out.println("hoho");
}

stmt.close();
Conn.close();
%>


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