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 int delete(int no) throws Exception {
Connection con = null;
PreparedStatement stmt = null;
try {
con = dataSource.getConnection();
stmt = con.prepareStatement("delete from MEMBERS where MNO=?");
stmt.setInt(1, no);
return stmt.executeUpdate();
} finally {
try {
stmt.close();
} catch (Exception e) {
}
dataSource.returnConnection(con);
}
}
public int insert(Member member) throws Exception {
Connection con = null;
PreparedStatement stmt = null;
try {
con = dataSource.getConnection();
stmt = con.prepareStatement("insert into MEMBERS(MNAME,EMAIL,PWD,TEL)" + " values(?,?,?,?)");
stmt.setString(1, member.getName());
stmt.setString(2, member.getEmail());
stmt.setString(3, member.getPassword());
stmt.setString(4, member.getTel());
return stmt.executeUpdate();
} finally {
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);
}
}
public int update(Member member) throws Exception {
Connection con = null;
PreparedStatement stmt = null;
try {
con = dataSource.getConnection();
stmt = con.prepareStatement("update MEMBERS set MNAME=?, EMAIL=?, PWD=?, TEL=? where MNO=?");
stmt.setString(1, member.getName());
stmt.setString(2, member.getEmail());
stmt.setString(3, member.getPassword());
stmt.setString(4, member.getTel());
stmt.setInt(5, member.getNo());
return stmt.executeUpdate();
} finally {
try {
stmt.close();
} catch (Exception e) {
}
dataSource.returnConnection(con);
}
}