[DB]JDBC코딩 순서

2014년 4월 16일 수요일

예

<%@ page LANGUAGE="java" contentType="text/html; charset=EUC-KR" pageEncoding="EUC-KR"%>
<%@ page import = "java.sql.*" %>
<!DOCTYPE html>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=EUC-KR">
<title>INSERT title here</title>
</head>
<body>
<%
Connection conn = NULL;
PreparedStatement pstmt = NULL;
ResultSet rs = NULL;
try{
//2.Driver loading
Class.forName("oracle.jdbc.driver.OracleDriver");
//Driver loading 성공여부 출력
OUT.println("OracleDriver드라이버 로딩 성공<br>");
//DB URL,ID, PW값 변수로 지정
String url = "jdbc:oracle:thin:@127.0.0.1:1521:xe";
String dbId = "hr";
String dbPw = "java1234";
//3.DB connection
conn = DriverManager.getConnection(url,dbId,dbPw);
//DB connection 성공여부 출력
OUT.println("oracle dbms 연결 성공<br>");
String SQL = "select employee_id, first_name from employees";
//4.SQL 준비
pstmt = conn.prepareStatement(SQL);
//5.SQL 화면 실행
rs = pstmt.executeQuery();
//6.결과 받기 및 출력
while(rs.NEXT()){
OUT.print(rs.getInt("employee_id"));
OUT.print(rs.getString("first_name"));
OUT.print("<br>");
}
}catch(ClassNotFoundException e){
OUT.println("OracleDriver드라이버 로딩 실패");
e.printStackTrace();
}catch(SQLException e){
OUT.println("SQL 예외발생 실패");
e.printStackTrace();
}finally{
//7.close(); 종료
rs.close();
pstmt.close();
conn.close();
}
%>
</body>
</html>

[solution gear]solutiongear - Jamo