package mms.member.dao;
import static mms.member.db.JdbcUtil.*;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import mms.member.vo.Member;
public class MemberDAO {
Connection con;
public MemberDAO(Connection con) {
// TODO Auto-generated constructor stub
this.con = con;
}
public int insertNewMember(Member newMember) {
// TODO Auto-generated method stub
int insertCount = 0;
PreparedStatement pstmt = null;
String sql = "INSERT INTO member VALUES(member_id_seq.nextval,?,?,?,?,?)";
try{
pstmt = con.prepareStatement(sql);
pstmt.setString(1, newMember.getName());
pstmt.setString(2, newMember.getAddr());
pstmt.setString(3, newMember.getNation());
pstmt.setString(4, newMember.getEmail());
pstmt.setInt(5, newMember.getAge());
insertCount = pstmt.executeUpdate();
}
catch(SQLException e){
e.printStackTrace();
}
finally{
try{
close(pstmt);
}
catch(Exception e){
e.printStackTrace();
}
}
return insertCount;
}
public ArrayList<Member> selectMemberList() {
// TODO Auto-generated method stub
ArrayList<Member> memberList = null;
PreparedStatement pstmt = null;
ResultSet rs = null;
String sql = "SELECT * FROM member";
try{
pstmt = con.prepareStatement(sql);
rs = pstmt.executeQuery();
memberList = new ArrayList<Member>();
Member member = null;
while(rs.next()){
member = new Member(rs.getString("name"), rs.getString("addr"),
rs.getString("nation"), rs.getString("email"), rs.getInt("age"));
//레코드 하나 당 Member 객체 하나 씩 생성
memberList.add(member);
}
}
catch(SQLException e){
e.printStackTrace();
}
finally{
try{
close(rs);
close(pstmt);
}
catch(Exception e){
e.printStackTrace();
}
}
return memberList;
}
public Member selectOldMember(String name) {
// TODO Auto-generated method stub
Member oldMember=null;
PreparedStatement pstmt = null;
ResultSet rs = null;
String sql = "SELECT * FROM member WHERE name = ?";
try{
pstmt = con.prepareStatement(sql);
pstmt.setString(1, name);
rs = pstmt.executeQuery();
if(rs.next()){
oldMember = new Member(rs.getString("name"), rs.getString("addr"),
rs.getString("nation"), rs.getString("email"), rs.getInt("age"));
}
}
catch(SQLException e){
e.printStackTrace();
}
finally{
try{
close(rs);
close(pstmt);
}
catch(Exception e){
e.printStackTrace();
}
}
return oldMember;
}
public int updateMember(Member updateMember) {
// TODO Auto-generated method stub
int updateCount = 0;
PreparedStatement pstmt = null;
String sql = "UPDATE member SET addr = ?, nation = ?, email = ?, age = ?" +
" WHERE name = ?";
try{
pstmt = con.prepareStatement(sql);
pstmt.setString(1, updateMember.getAddr());
pstmt.setString(2, updateMember.getNation());
pstmt.setString(3, updateMember.getEmail());
pstmt.setInt(4, updateMember.getAge());
pstmt.setString(5, updateMember.getName());
updateCount = pstmt.executeUpdate();
}
catch(SQLException e){
e.printStackTrace();
}
finally{
try{
close(pstmt);
}
catch(Exception e){
e.printStackTrace();
}
}
return updateCount;
}
public int deleteMember(String name) {
// TODO Auto-generated method stub
int deleteCount = 0;
PreparedStatement pstmt = null;
String sql = "DELETE member" +
" WHERE name = ?";
try{
pstmt = con.prepareStatement(sql);
pstmt.setString(1, name);
deleteCount = pstmt.executeUpdate();
}
catch(SQLException e){
e.printStackTrace();
}
finally{
try{
close(pstmt);
}
catch(Exception e){
e.printStackTrace();
}
}
return deleteCount;
}
}
1. 회원등록
2.회원목록보기
3.회원정보 수정
4. 회원정보 삭제
댓글 0