JAVA + DB 실습(1-2)

<< INSERT >>

 

package practice;

public class Insert {

	private MemberDTO member = new MemberDTO();
	private MemberDAO memberDao = new MemberDAO();

	public Insert(MemberDTO member) {
		this.member = member;
	}

	public void regist(MemberDTO member) {
		int verify = memberDao.dataCount(member.getId());
		if (verify != 0) {
			System.out.println(member.getId() + "는 이미 등록된 아이디입니다.");
			return;
		}
		memberDao.regist(member);
	}
}

 

<< SELECT >>

package practice;

import java.sql.ResultSet;
import java.sql.SQLException;

public class Select {

	private MemberDAO memberDao = new MemberDAO();
	private ResultSet rs = null;
	
	public void someSearch(String id) {
		rs = memberDao.someSearch(id);
		try {
			if (rs.next()) {
				System.out.println("아이디 : " + rs.getString("id"));
				System.out.println("비밀번호 : " + rs.getString("pw"));
				System.out.println("이름 : " + rs.getString("name"));
				System.out.println("전화번호 : " + rs.getString("phonenumber") + "\n");
				return;
			}
			
			System.out.println(id + "는 없는 정보입니다.");
		} catch (SQLException e) {
			e.printStackTrace();
		}
		
	}
	
	public void searchAll() {
		rs = memberDao.searchAll();
		try {
			while (rs.next()) {
				System.out.println("아이디 : " + rs.getString("id"));
				System.out.println("비밀번호 : " + rs.getString("pw"));
				System.out.println("이름 : " + rs.getString("name"));
				System.out.println("전화번호 : " + rs.getString("phonenumber"));
				System.out.println("");
			}
		} catch (SQLException e) {
			e.printStackTrace();
		}
	}
	
}

<< UPDATE >>

package practice;

import java.sql.ResultSet;
import java.sql.SQLException;

public class Update {

	private MemberDAO memberDao = new MemberDAO();
	private ResultSet rs = null;
	
	public void fixInfo(MemberDTO member, String fixId) {
		rs = memberDao.someSearch(member.getId());
		try {
			if (rs.next()) {
				if (!rs.getString("pw").equals(member.getPw())) {
					System.out.println("비밀번호가 일치하지 않습니다.");
					return;
				}
			}
		} catch (SQLException e) {
			e.printStackTrace();
		}
		
		int verify = memberDao.dataCount(member.getId());
		if (verify != 1) {
			System.out.println(member.getId() + "는 없는 정보입니다.");
			return;
		}
		
		memberDao.fixInfo(member);
		System.out.println("수정이 완료되었습니다.");
	}
	
	
	
	
}

<< DELETE >>

package practice;

import java.sql.ResultSet;
import java.sql.SQLException;

public class Delete {

	private MemberDAO memberDao = new MemberDAO();
	private ResultSet rs = null;
	
	public void delete(String id, String pw) {
		rs = memberDao.someSearch(id);
		try {
			if (rs.next()) {
				if (!rs.getString("pw").equals(pw)) {
					System.out.println("비밀번호가 일치하지 않습니다.");
					return;
				}
			}
		} catch (SQLException e) {
			e.printStackTrace();
		}
		
		int verify = memberDao.dataCount(id);
		if (verify != 1) {
			System.out.println(id + "는 없는 정보입니다.");
			return;
		}
		
		memberDao.delete(id);
		System.out.println("삭제가 완료되었습니다.");
	}
	
}

<< EXIT >>

package practice;

public class Exit {

	private MemberDAO memberDao = new MemberDAO();
	
	public void exit() {
		memberDao.exit();
	}
}