package ch06;
import java.sql.*;
import java.util.ArrayList;
public class UseBeanDB4 {
private final String JDBC_DRIVER = "oracle.jdbc.OracleDriver";
private final String JDBC_URL = "jdbc:oracle:thin:@localhost:1521:xe";
private final String USER = "tjoeun";
private final String PASS = "1234";
public UseBeanDB4() {
try {
Class.forName(JDBC_DRIVER);
} catch (ClassNotFoundException e) {
e.printStackTrace();
}
}
public ArrayList<Bean> getList() {
ArrayList<Bean> alist = new ArrayList<Bean>();
try {
Connection con = DriverManager.getConnection(JDBC_URL, USER, PASS);
Statement st = con.createStatement();
String query = "select * from emp_01";
ResultSet rs = st.executeQuery(query);
while(rs.next()) {
Bean bean = new Bean();
// bean.setEmp_id(rs.getString(1));
bean.setEmp_id(rs.getString("emp_id"));
bean.setEmp_name(rs.getString("emp_name"));
bean.setDept_code(rs.getString("dept_code"));
alist.add(bean);
}
} catch (SQLException e) {
e.printStackTrace();
}
return alist;
}
}
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<%@ page import="java.util.*, ch06.*" %>
<jsp:useBean id="uBean" class="ch06.UseBeanDB4" />
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Insert title here</title>
</head>
<body>
<h1>Bean을 사용한 ORACLE연동</h1>
<table border="1">
<tr>
<th>사번</th>
<th>사원명</th>
<th>부서명</th>
</tr>
<%
ArrayList<Bean> alist = uBean.getList();
for(int i=0; i<alist.size(); i++) {
Bean bean = alist.get(i);
%>
<tr>
<td><%=bean.getEmp_id() %></td>
<td><%=bean.getEmp_name() %></td>
<td><%=bean.getDept_code() %></td>
</tr>
<%
}
%>
</table>
</body>
</html>