거니의 velog

package firstproject.dao; import java.util.ArrayList; import java.util.List; import java.util.Map; import firstproject.util.JDBCUtil; public class MemberDAO { private static MemberDAO instance = null; private MemberDAO() {} public static MemberDAO getInstance() { if (instance == null) instance = new MemberDAO(); return instance; } JDBCUtil jdbc = JDBCUtil.getInstance(); StringBuilder sb = null; ..

package firstproject.dao; import java.util.List; import java.util.Map; import firstproject.util.JDBCUtil; public class AdminDeleteDAO { private static AdminDeleteDAO instance = null; private AdminDeleteDAO() {} public static AdminDeleteDAO getInstance() { if (instance == null) instance = new AdminDeleteDAO(); return instance; } JDBCUtil jdbc = JDBCUtil.getInstance(); StringBuilder sb = null; Str..

package firstproject.dao; import java.sql.Connection; import java.sql.DriverManager; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; import java.util.List; public class AdminUpdateDAO { private static AdminUpdateDAO instance = null; private AdminUpdateDAO() {} public static AdminUpdateDAO getInstance() { if (instance == null)..

package firstproject.dao; import java.util.List; import java.util.Map; import firstproject.util.JDBCUtil; public class AdminReadDAO { private static AdminReadDAO instance = null; private AdminReadDAO() {} public static AdminReadDAO getInstance() { if (instance == null) instance = new AdminReadDAO(); return instance; } JDBCUtil jdbc = JDBCUtil.getInstance(); StringBuilder sb = null; String sql = ..

package firstproject.dao; import java.util.List; import java.util.Map; import firstproject.util.JDBCUtil; public class AdminCreateDAO { private static AdminCreateDAO instance = null; private AdminCreateDAO() {} public static AdminCreateDAO getInstance() { if (instance == null) instance = new AdminCreateDAO(); return instance; } JDBCUtil jdbc = JDBCUtil.getInstance(); StringBuilder sb = null; Str..

public int riderCreate() { String riderCode = ""; // 라이더코드 String AbseYN = ""; // 부재유무 long deliCost = 0; // 배달비 String stoCode = ""; // 업체코드 String createRider = ""; // 라이더 생성 System.out.println(" ───────────────────────────────────────────────────"); System.out.println("어느 가게에 라이더로 등록하십니까?"); System.out.println("1. 업체코드로 입력"); System.out.println("2. 업체명 검색"); System.out.println(" ─────────────..

public int menuCreate() { String menuCode = ""; // 메뉴코드 String menuNm = ""; // 메뉴명 long menuPrice = 0; // 메뉴가격 int remainQty = 0; // 잔여수량 String stoCode = ""; // 업체코드 String createMenu = ""; // 메뉴 생성 System.out.println(" ───────────────────────────────────────────────────"); System.out.println("어느 가게에서 메뉴를 등록하십니까?"); System.out.println("1. 업체코드로 등록"); System.out.println("2. 업체명으로 업체코드 검색"); Syst..

public int orderhistoRead() { List orderhistoALL = adminReadDAO.orderhistoALL(); if(NullCheckUtil.isEmpty(orderhistoALL)) { System.out.println("등록된 주문내역이 없습니다!"); }else { int maxOrderNoLen = gapUtil.gapFullCnt(orderhistoALL, "ORDERNO"); int maxOrderCodeLen = gapUtil.gapFullCnt(orderhistoALL, "ORDERCODE"); int maxMenuNmLen = gapUtil.gapFullCnt(orderhistoALL, "MENUNM"); int maxOrderQtyLen = gapUti..

public int storeCreate() { String CodeStr = ""; // 업체코드 String StoNm = ""; // 업체명 String StoAdd = ""; // 실제업체주소 : daejeonRandGu long MinOrder = 0; // 최소주문금액 String DeliYn = ""; // 배달가능유무 String PackYn = ""; // 포장가능유무 String CloseYn = ""; // 매장오픈유무 String CateCode = ""; // 카테고리코드 String createStore = ""; // 가게 생성 while(true) { System.out.println(" ─────────────────────────────────────────────────..

public int memRead() { List memALL = adminReadDAO.memALL(); if(NullCheckUtil.isEmpty(memALL)) { System.out.println(" ───────────────────────────────────────────────────"); System.out.println("등록된 회원이 없습니다!"); System.out.println(" ───────────────────────────────────────────────────"); }else { int maxIdLen = gapUtil.gapFullCnt(memALL, "MEMID"); int maxNmLen = gapUtil.gapFullCnt(memALL, "MEMNM"); i..