JAVA + DB7 JAVA + DB 실습(1-2) > 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); } } > .. 2022. 8. 6. JAVA + DB 실습(1-1) > package practice; import java.util.Scanner; public class Main { public static void main(String[] args) { Scanner sc = new Scanner(System.in); MemberDTO member = new MemberDTO(); String sel, id, pw, fixPw, name, phoneNumber; while (true) { System.out.print("1. Insert\n2. Select\n3. Update\n4. Delete\n5. Exit\n: "); sel = sc.next(); switch (sel) { case "1": member = new MemberDTO(); System.out.p.. 2022. 8. 6. DB와 JAVA 연동 및 Query실행 package jdbc_concept1; import java.sql.Connection; import java.sql.DriverManager; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; import java.util.Scanner; public class ConnectionTest { public static void main(String[] args) { // DB Connection // 1. Driver 실행 try { // OracleDrive 대소문자 정확히 입력해야 한다. Class.forName("oracle.jdbc.OracleDriver"); } catch (Cla.. 2022. 8. 4. 이전 1 2 다음