public Member selectOne(int no) throws Exception {
Connection con = null;
PreparedStatement stmt = null;
ResultSet rs = null;
try {
con = dataSource.getConnection();
stmt = con.prepareStatement("select * from MEMBERS where MNO=?");
stmt.setInt(1, no);
rs = stmt.executeQuery();
if (rs.next()) {
Member member = new Member();
member.setNo(rs.getInt("MNO"));
member.setName(rs.getString("MNAME"));
member.setEmail(rs.getString("EMAIL"));
member.setPassword(rs.getString("PWD"));
member.setTel(rs.getString("TEL"));
return member;
}
return null;
} finally {
try {
rs.close();
} catch (Exception e) {
}
try {
stmt.close();
} catch (Exception e) {
}
dataSource.returnConnection(con);
}
}
public List<Member> selectList() throws Exception {
ArrayList<Member> list = new ArrayList<>();
Connection con = null;
Statement stmt = null;
ResultSet rs = null;
try {
con = dataSource.getConnection();
stmt = con.createStatement();
rs = stmt.executeQuery("select * from MEMBERS");
Member member = null;
while (rs.next()) {
member = new Member();
member.setNo(rs.getInt("MNO"));
member.setName(rs.getString("MNAME"));
member.setEmail(rs.getString("EMAIL"));
member.setPassword(rs.getString("PWD"));
member.setTel(rs.getString("TEL"));
list.add(member);
}
return list;
} finally {
try {
rs.close();
} catch (Exception e) {
}
try {
stmt.close();
} catch (Exception e) {
}
dataSource.returnConnection(con);
}
}