글쓴이 :정희철 1998년 12월 08일 20:08:25
jdbc 부분은 어플리케이션에서 테스트했습니다
별문제 없이 연결되더군요.
서블릿으로 할려니 잘안됐니다.
import java.io.*;
import java.util.*;
import javax.servlet.http.*;
import javax.servlet.*;
import java.sql.*;
public class Person extends HttpServlet
{
Connection conn;
Statement stmt;
ResultSet rs = null;
PrintWriter out;
public void service(HttpServletRequest req, HttpServletResponse res) throws ServletException, IOException
{
String query="select * from person";
res.setContentType("text/html; charset=euc-kr");
out=res.getWriter();
out.println("한글");
try{
Class.forName("oracle.jdbc.driver.OracleDriver");
}catch(ClassNotFoundException e){
out.println("오류 class not found" + e.getMessage());
}
try{
conn = DriverManager.getConnection ("jdbc:oracle:thin:@MyIP:1521:ORA","ID", "PWD");
stmt = conn.createStatement ();
}catch(SQLException e){
out.println("jdbc드라이버 로딩실패" + e.getMessage());
}
try{
rs=stmt.executeQuery(query);
}catch(SQLException e){
out.println("실행에러"+ e.getMessage());
}
try{
while(rs.next()){
out.println(rs.getString(1)+"<br>");
}
rs.close();
}catch(SQLException e){
out.println("select 에러" + e.getMessage());
}
out.flush();
out.close();
try{
stmt.close();
conn.close();
}catch(SQLException e){
}
}
}