커넥션풀, 빈(Bean), ArrayList, For Each 연습
package ch09.update;
import java.sql.Timestamp;
public class UpdateDataBean {
private String id;
private String pw;
private String name;
private String tel;
private String address;
private Timestamp rDate;
public String getId() {
return id;
}
public void setId(String id) {
this.id = id;
}
public String getPw() {
return pw;
}
public void setPw(String pw) {
this.pw = pw;
}
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
public String getTel() {
return tel;
}
public void setTel(String tel) {
this.tel = tel;
}
public String getAddress() {
return address;
}
public void setAddress(String address) {
this.address = address;
}
public Timestamp getrDate() {
return rDate;
}
public void setrDate(Timestamp rDate) {
this.rDate = rDate;
}
}
package ch09.dao;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;
import javax.naming.Context;
import javax.naming.InitialContext;
import javax.sql.DataSource;
import ch09.update.UpdateDataBean;
public class TestList {
private Connection getConnection() throws Exception{
Context ctx = new InitialContext();
DataSource ds = (DataSource)ctx.lookup("java:comp/env/jdbc/Oracle11g");
return ds.getConnection();
}
private static TestList instance = new TestList();
private TestList(){}
public static TestList getInstance(){
return instance;
}
public String getToto(){
String toto = "toto에요";
return toto;
}
public List<UpdateDataBean> getSelect() throws SQLException{
List<UpdateDataBean> udbs = new ArrayList<UpdateDataBean>();
Connection conn=null;
PreparedStatement pstmt=null;
ResultSet rs=null;
try {
conn = getConnection();
String sql="select * from memberBook";
pstmt=conn.prepareStatement(sql);
rs=pstmt.executeQuery();
while(rs.next()){
UpdateDataBean udb = new UpdateDataBean();
udb.setId(rs.getString("id"));
udb.setPw(rs.getString("pw"));
udb.setName(rs.getString("name"));
udb.setTel(rs.getString("tel"));
udb.setAddress(rs.getString("address"));
udb.setrDate(rs.getTimestamp("rDate"));
udbs.add(udb);
}
} catch (Exception e) {
e.printStackTrace();
}finally{
if(rs!=null) rs.close();
if(pstmt!=null) rs.close();
if(conn!=null) rs.close();
}
return udbs;
}
}
------------------------------------------------------------------------
<%@page import="ch09.update.UpdateDataBean"%>v
<%@page import="ch09.dao.TestList"%>
<%@ page import="java.util.List" %>
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Insert title here</title>
</head>
<body>
<%
TestList tl = TestList.getInstance();
String toto = tl.getToto();
out.println("toto: "+toto);
List<UpdateDataBean> mList = null;
mList = tl.getSelect();
%>
<table>
<tr>
<td>아이디
<td>비번
<td>이름
<td>날짜
<td>주소
<td>전화
</tr>
<%
for(UpdateDataBean str: mList){
%>
<tr>
<td><%=str.getId() %>
<td><%=str.getPw()%>
<td><%=str.getName()%>
<td><%=str.getrDate()%>
<td><%=str.getAddress()%>
<td><%=str.getTel()%>
</tr>
<%
}
%>
</table>
</body>
</html>