JSP Oracle(오라클) DB 접속

<%@ page contentType="text/html;charset=euc-kr" %>

<%@ page import="java.util.*" %>

<%@ page import="java.sql.*" %>

<%

try {

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

String url = "jdbc:oracle:thin:@61.250.92.69:1521:ORCL";

String id = "test";

String pass = "test";

Connection conn = DriverManager.getConnection(url, id, pass);

Statement stmt=conn.createStatement();

StringBuffer sql = new StringBuffer();

sql.append("SELECT * FROM TEST \n");

ResultSet rs=stmt.executeQuery(sql.toString());

String name = "";

while(rs.next()){

name = rs.getString("NAME");

out.print(name);

}

conn.close();

} catch(SQLException e) {

out.println("데이버베이스연결 실패");

}

%>