package ch06;
public class Bean {
private String emp_id;
private String emp_name;
private String dept_code;
public String getEmp_id() {
return emp_id;
}
public void setEmp_id(String emp_id) {
this.emp_id = emp_id;
}
public String getEmp_name() {
return emp_name;
}
public void setEmp_name(String emp_name) {
this.emp_name = emp_name;
}
public String getDept_code() {
return dept_code;
}
public void setDept_code(String dept_code) {
this.dept_code = dept_code;
}
}
package ch06;
import java.sql.*;
import java.util.ArrayList;
public class UseBeanDBPool6 {
private DBConnectionMgr pool = null;
public UseBeanDBPool6() {
pool = DBConnectionMgr.getInstance();
}
public ArrayList<Bean> getList() {
ArrayList<Bean> alist = new ArrayList<Bean>();
Connection con = null;
Statement st = null;
ResultSet rs = null;
try {
con = pool.getConnection();
st = con.createStatement();
rs = st.executeQuery("select * from emp_01");
while(rs.next()) {
Bean bean = new Bean();
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 (Exception e) {
e.printStackTrace();
} finally {
pool.freeConnection(con);
}
return alist;
}
}
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<%@ page import="java.util.*, ch06.*" %>
<jsp:useBean id="pool" class="ch06.UseBeanDBPool6" />
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Bean과 DBConnectionPool</title>
</head>
<body>
<h1>Bean과 DBConnectionPool을 이용한 ORACLE연동</h1>
<table border="1">
<tr>
<th>사번</th>
<th>사원명</th>
<th>부서명</th>
</tr>
<%
ArrayList<Bean> alist = pool.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>