<%@ page contentType="text/html;charset=euc-kr" import="java.sql.*" %>
<html>
<body>
<center>
<%
// 데이터베이스 연결관련 변수 선언
Connection conn = null;
Statement stmt = null;
// 데이터베이스 연결관련정보를 문자열로 선언
String jdbc_driver = "oracle.jdbc.OracleDriver";
String db_url = "jdbc:oracle:thin:@localhost:1521:ORA9I";
try{
// JDBC 드라이버 로드하여 DriverManager에 등록함
Class.forName(jdbc_driver);
// 로드된 드라이버를 이용하여 DB와 연결하고 Connection 인스턴스 구함
conn = DriverManager.getConnection(db_url,"scott","tiger");
java.sql.Date dt1 = java.sql.Date.valueOf("1980-01-01");
java.sql.Date dt2 = java.sql.Date.valueOf("1982-12-31");
PreparedStatement pstmt = conn.prepareStatement("select * from emp where hiredate between ? and ?");
pstmt.setDate(1, dt1);
pstmt.setDate(2, dt2);
ResultSet rs = pstmt.executeQuery();%>
<table border="1" cellspacing="0">
<th>EMPNO</th><th>ENAME</th><th>JOB</th><th>MGR</th><th>HIREDATE</th>
<%
int i = 0;
String bgColor=null;
while(rs.next()) {
i++;
if(i%2!=0) bgColor="#CCFFFF";
else bgColor="#FFFFFF";
%>
<tr bgcolor="<%=bgColor %>">
<td><%=rs.getString(1)%></td><td><%=rs.getString(2)%></td><td><%=rs.getString(3)%></td>
<td><%=rs.getInt(4)%></td><td><%=rs.getString(5)%><br>
</tr>
<% }%>
</table>
<%
rs.close();
conn.close();
}
catch(Exception e) {
out.println(e);
}
%>
</center>
</body>
</html>