컴퓨터/JSP

[JavaSpring] Bean과 DBConnectionPool을 이용한 ORACLE연동 실습문제

peridott 2024. 7. 17. 18:10 
package ch06;

public class EmpBean {
	private String emp_id;
	private String emp_name;
	private String email;
	private String phone;
	private String job_name;
	
	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 getEmail() {
		return email;
	}
	public void setEmail(String email) {
		this.email = email;
	}
	public String getPhone() {
		return phone;
	}
	public void setPhone(String phone) {
		this.phone = phone;
	}
	public String getJob_name() {
		return job_name;
	}
	public void setJob_name(String job_name) {
		this.job_name = job_name;
	}

}
package ch06;

import java.sql.*;
import java.util.ArrayList;

public class EmpBeanDBPool7 {
	private DBConnectionMgr pool = null;
	
	public EmpBeanDBPool7() {
		pool = DBConnectionMgr.getInstance(); 
	}
	
	public ArrayList<EmpBean> getList() {
		ArrayList<EmpBean> alist = new ArrayList<EmpBean>();
		Connection con = null;
		Statement st = null;
		ResultSet rs = null;
		
		try {
			con = pool.getConnection();
			st = con.createStatement();
			rs = st.executeQuery("select emp_id,emp_name,email,phone,job_name"
								+ " from employee, job"
								+ " where employee.job_code = job.job_code");
			while(rs.next()) {
				EmpBean bean = new EmpBean();
				bean.setEmp_id(rs.getString("emp_id"));
				bean.setEmp_name(rs.getString("emp_name"));
				bean.setEmail(rs.getString("email"));
				bean.setPhone(rs.getString("phone"));
				bean.setJob_name(rs.getString("job_name"));
				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.EmpBeanDBPool7" />
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Insert title here</title>
</head>
<body>
	<table border="1">
		<tr>
			<th>사번</th>
			<th>이름</th>
			<th>이메일</th>
			<th>전화번호</th>
			<th>직급명</th>
		</tr>
	<%
	ArrayList<EmpBean> alist = pool.getList();
	for(int i=0; i<alist.size(); i++) {
		EmpBean bean = alist.get(i);
	%>
		<tr>
			<td><%=bean.getEmp_id() %></td>
			<td><%=bean.getEmp_name() %></td>
			<td><%=bean.getEmail() %></td>
			<td><%=bean.getPhone() %></td>
			<td><%=bean.getJob_name() %></td>
		</tr>
	<%
	}
	%>
	</table>
</body>
</html>
저작자표시 비영리 변경금지