본문 바로가기

JAVA + DB7

JAVA + DB 실습 (3)(Class.Service) > package jdbc_concept5.service; import jdbc_concept5.run.MemberDAO; import jdbc_concept5.run.MemberDTO; public class Insert { private MemberDAO memberDao = new MemberDAO(); public void insertMember(MemberDTO member) { MemberDTO tmp = memberDao.selectId(member.getId()); if (tmp != null) { System.out.println(member.getId() + "는 사용중입니다."); return; } int verify = memberDao.insertMember(member); if .. 2022. 8. 9.
JAVA + DB 실습 (3)(Class.View) > package jdbc_concept5.view; public interface IView { public void mainMenu() ; public void deleteMember(); public void updateMember(); public void insertMember(); public void selectId(); public void selectAll(); } > package jdbc_concept5.view; import java.util.Scanner; import jdbc_concept5.run.MemberDTO; import jdbc_concept5.service.Delete; import jdbc_concept5.service.Exit; import jdbc_concept.. 2022. 8. 9.
JAVA + DB 실습 (3)(Class.run) > package jdbc_concept5.run; import jdbc_concept5.view.MemberView; public class Main { public static void main(String[] args) { MemberView mv = new MemberView(); mv.mainMenu(); } } > package jdbc_concept5.run; public interface IDTO { public int getNum(); public void setNum(int num) ; public String getId(); public void setId(String id); public String getPw() ; public void setPw(String pw) ; publi.. 2022. 8. 9.
JAVA + DB 실습(2) > package jdbc_concept4; import java.sql.ResultSet; import java.sql.SQLException; import java.util.Scanner; public class Main { private static Scanner sc = new Scanner(System.in); private static MemberServiceImpl ms = new MemberServiceImpl(); public static void main(String[] args) { while (true) { System.out.println("1. 회원 등록"); System.out.println("2. 회원 검색"); System.out.println("3. 회원 삭제"); Sys.. 2022. 8. 8.