JDBC 연습1
▼ 코드 예시 보기 (더보기 클릭) ▼
더보기
더보기
class JDBCTemplate
import java.io.FileNotFoundException;
import java.io.FileReader;
import java.io.IOException;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Properties;
public class JDBCTemplate {
public static Connection getConnection() {
Connection con = null;
Properties prop = new Properties();
try {
prop.load(new FileReader("config/connection-info.properties"));
String driver = prop.getProperty("driver");
String url = prop.getProperty("url");
Class.forName(driver);
con = DriverManager.getConnection(url, prop);
/* Application1에서 getAutoCommit()의 결과 true - 기본 값
* 프로그램 내에서 commit과 rollback을 판단하여 수행하고자 하므로 setAutoCommit(false) 설정
* */
con.setAutoCommit(false);
} catch (FileNotFoundException e) {
e.printStackTrace();
} catch (IOException e) {
e.printStackTrace();
} catch (ClassNotFoundException e) {
e.printStackTrace();
} catch (SQLException e) {
e.printStackTrace();
}
return con;
}
public static void close(Connection con) {
try {
if(con != null && !con.isClosed()) {
con.close();
}
} catch (SQLException e) {
e.printStackTrace();
}
}
public static void close(Statement stmt) {
try {
if(stmt != null && !stmt.isClosed()) {
stmt.close();
}
} catch (SQLException e) {
e.printStackTrace();
}
}
public static void close(ResultSet rset) {
try {
if(rset != null && !rset.isClosed()) {
rset.close();
}
} catch (SQLException e) {
e.printStackTrace();
}
}
/* 자동 commit에서 수동 commit으로 설정 변경 후 코드 추가 */
public static void commit(Connection con) {
try {
if(con != null && !con.isClosed()) {
con.commit();
}
} catch (SQLException e) {
e.printStackTrace();
}
}
public static void rollback(Connection con) {
try {
if(con != null && !con.isClosed()) {
con.rollback();
}
} catch (SQLException e) {
e.printStackTrace();
}
}
}
Application1
package com.greedy.section01.transaction;
import static com.greedy.common.JDBCTemplate.*;
import java.io.FileInputStream;
import java.io.IOException;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.SQLException;
import java.util.Properties;
public class Application1 {
public static void main(String[] args) {
Connection con = getConnection();
try {
System.out.println("autoCommit의 현재 설정 값 : " + con.getAutoCommit());
} catch (SQLException e) {
e.printStackTrace();
}
PreparedStatement pstmt = null;
int result = 0;
Properties prop = new Properties();
try {
prop.loadFromXML(new FileInputStream("mapper/menu-query.xml"));
String query = prop.getProperty("insertMenu");
pstmt = con.prepareStatement(query);
pstmt.setString(1, "정어리비빔밥");
pstmt.setInt(2, 50000);
pstmt.setInt(3, 4);
pstmt.setString(4, "Y");
result = pstmt.executeUpdate();
} catch (IOException e) {
e.printStackTrace();
} catch (SQLException e) {
e.printStackTrace();
} finally {
close(pstmt);
close(con);
}
if(result > 0) {
System.out.println("메뉴 등록 성공!");
} else {
System.out.println("메뉴 등록 실패!");
}
}
}
Application2
package com.greedy.section01.transaction;
import static com.greedy.common.JDBCTemplate.*;
import java.io.FileInputStream;
import java.io.IOException;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.SQLException;
import java.util.Properties;
public class Application2 {
public static void main(String[] args) {
Connection con = getConnection();
try {
System.out.println("autoCommit의 현재 설정 값 : " + con.getAutoCommit());
} catch (SQLException e) {
e.printStackTrace();
}
PreparedStatement pstmt1 = null;
PreparedStatement pstmt2 = null;
int result1 = 0;
int result2 = 0;
Properties prop = new Properties();
try {
prop.loadFromXML(new FileInputStream("mapper/menu-query.xml"));
String query1 = prop.getProperty("insertCategory");
String query2 = prop.getProperty("insertMenu");
pstmt1 = con.prepareStatement(query1);
pstmt1.setString(1, "기타");
pstmt1.setInt(2, 1);
result1 = pstmt1.executeUpdate();
System.out.println("result1 : " + result1);
pstmt2 = con.prepareStatement(query2);
pstmt2.setString(1, "정어리비빔밥");
pstmt2.setInt(2, 50000);
/* TBL_CATEGORY 에 존재하지 않는 CATEGORY_CODE를 TBL_MENU 테이블의 CATEGORY_CODE 값으로 삽입하려고 하면
* 부모 키를 찾지 못하는 외래키 제약조건 위반 오류가 발생한다.
* */
pstmt2.setInt(3, 0);
pstmt2.setString(4, "Y");
result2 = pstmt2.executeUpdate();
System.out.println("result2 : " + result2);
} catch (IOException e) {
e.printStackTrace();
} catch (SQLException e) {
e.printStackTrace();
} finally {
close(pstmt1);
close(pstmt2);
/* 트랜잭션(논리적인 기능 수행 단위) 관리를 위해 2개의 insert가 모두 잘 동작했는지 판단하여
* 잘 동작했을 경우 commit, 둘 중 하나라도 잘 동작하지 않았을 경우 rollback을 수행한다.
* */
if(result1 > 0 && result2 > 0) {
System.out.println("신규 카테고리와 메뉴 등록 성공!");
commit(con);
} else {
System.out.println("신규 카테고리와 메뉴 등록 실패!");
rollback(con);
}
close(con);
}
}
}
JDBC 연습2
▼ 코드 예시 보기 (더보기 클릭) ▼
더보기
더보기
class MenuDAO
import static com.greedy.common.JDBCTemplate.close;
import java.io.FileInputStream;
import java.io.IOException;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.Properties;
import com.greedy.section02.service.model.dto.CategoryDTO;
import com.greedy.section02.service.model.dto.MenuDTO;
public class MenuDAO {
private Properties prop = new Properties();
public MenuDAO() {
try {
prop.loadFromXML(new FileInputStream("mapper/menu-query.xml"));
} catch (IOException e) {
e.printStackTrace();
}
}
/* 신규 카테고리 등록용 메소드 */
public int insertNewCategory(Connection con, CategoryDTO newCategory) {
PreparedStatement pstmt = null;
int result = 0;
String query = prop.getProperty("insertCategory");
try {
pstmt = con.prepareStatement(query);
pstmt.setString(1, newCategory.getName());
pstmt.setObject(2, newCategory.getRefCategoryCode());
result = pstmt.executeUpdate();
} catch (SQLException e) {
e.printStackTrace();
} finally {
close(pstmt);
}
return result;
}
/* 현재 카테고리 코드 조회 */
public int selectLastCategoryCode(Connection con) {
PreparedStatement pstmt = null;
ResultSet rset = null;
int newCategoryCode = 0;
String query = prop.getProperty("getCurrentSequence");
try {
pstmt = con.prepareStatement(query);
rset = pstmt.executeQuery();
if(rset.next()) {
newCategoryCode = rset.getInt("CURRVAL");
}
} catch (SQLException e) {
e.printStackTrace();
} finally {
close(rset);
close(pstmt);
}
return newCategoryCode;
}
/* 신규 메뉴 등록용 메소드 */
public int insertNewMenu(Connection con, MenuDTO newMenu) {
PreparedStatement pstmt = null;
int result = 0;
String query = prop.getProperty("insertMenu");
try {
pstmt = con.prepareStatement(query);
pstmt.setString(1, newMenu.getName());
pstmt.setInt(2, newMenu.getPrice());
pstmt.setInt(3, newMenu.getCategoryCode());
pstmt.setString(4, newMenu.getOrderableStatus());
result = pstmt.executeUpdate();
} catch (SQLException e) {
e.printStackTrace();
} finally {
close(pstmt);
}
return result;
}
}
CategoryDTO
public class CategoryDTO {
private int code;
private String name;
private Integer refCategoryCode;
public CategoryDTO() {}
public CategoryDTO(int code, String name, Integer refCategoryCode) {
super();
this.code = code;
this.name = name;
this.refCategoryCode = refCategoryCode;
}
public int getCode() {
return code;
}
public void setCode(int code) {
this.code = code;
}
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
public Integer getRefCategoryCode() {
return refCategoryCode;
}
public void setRefCategoryCode(Integer refCategoryCode) {
this.refCategoryCode = refCategoryCode;
}
@Override
public String toString() {
return "CategoryDTO [code=" + code + ", name=" + name + ", refCategoryCode=" + refCategoryCode + "]";
}
}
class MenuDTO
/* DTO(Data Transfer Object) */
public class MenuDTO {
private int code;
private String name;
private int price;
private int categoryCode;
private String orderableStatus;
public MenuDTO() {}
public MenuDTO(int code, String name, int price, int categoryCode, String orderableStatus) {
super();
this.code = code;
this.name = name;
this.price = price;
this.categoryCode = categoryCode;
this.orderableStatus = orderableStatus;
}
public int getCode() {
return code;
}
public void setCode(int code) {
this.code = code;
}
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
public int getPrice() {
return price;
}
public void setPrice(int price) {
this.price = price;
}
public int getCategoryCode() {
return categoryCode;
}
public void setCategoryCode(int categoryCode) {
this.categoryCode = categoryCode;
}
public String getOrderableStatus() {
return orderableStatus;
}
public void setOrderableStatus(String orderableStatus) {
this.orderableStatus = orderableStatus;
}
@Override
public String toString() {
return "MenuDTO [code=" + code + ", name=" + name + ", price=" + price + ", categoryCode=" + categoryCode
+ ", orderableStatus=" + orderableStatus + "]";
}
}
class MenuService
import java.sql.Connection;
import com.greedy.section02.service.model.dao.MenuDAO;
import com.greedy.section02.service.model.dto.CategoryDTO;
import com.greedy.section02.service.model.dto.MenuDTO;
import static com.greedy.common.JDBCTemplate.*;
/* Service의 역할
* 1. Connection 생성
* 2. DAO의 메소드 호출
* 3. 트랜잭션의 제어
* 4. Connection 닫기
* */
public class MenuService {
/* 신규 메뉴 등록용 서비스 메소드 */
public void registNewMenu() {
/* 1. Connection 생성 */
Connection con = getConnection();
/* 2. DAO 메소드 호출 */
MenuDAO menuDAO = new MenuDAO();
/* 2-1. 카테고리 등록 */
CategoryDTO newCategory = new CategoryDTO();
newCategory.setName("기타");
newCategory.setRefCategoryCode(null);
int result1 = menuDAO.insertNewCategory(con, newCategory);
/* 방금 입력한 마지막 카테고리 번호 조회 */
int newCategoryCode = menuDAO.selectLastCategoryCode(con);
/* 2-2. 메뉴 등록 */
MenuDTO newMenu = new MenuDTO();
newMenu.setName("메롱메롱스튜");
newMenu.setPrice(40000);
newMenu.setCategoryCode(newCategoryCode);
newMenu.setOrderableStatus("Y");
int result2 = menuDAO.insertNewMenu(con, newMenu);
/* 3. 트랜잭션 제어 */
if(result1 > 0 && result2 > 0) {
System.out.println("신규 카테고리와 메뉴를 추가하였습니다.");
commit(con);
} else {
System.out.println("신규 카테고리와 메뉴를 추가하지 못했습니다.");
rollback(con);
}
/* 4. Connection 반납 */
close(con);
}
}
Application
import com.greedy.section02.service.model.service.MenuService;
public class Application {
public static void main(String[] args) {
new MenuService().registNewMenu();
}
}
JDBC 연습3
▼ 코드 예시 보기 (더보기 클릭) ▼
더보기
더보기
order-query
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE properties SYSTEM "http://java.sun.com/dtd/properties.dtd">
<properties>
<entry key="selectAllCategory">
SELECT
A.CATEGORY_CODE
, A.CATEGORY_NAME
FROM TBL_CATEGORY A
</entry>
<entry key="selectMenuByCategory">
SELECT
A.MENU_CODE
, A.MENU_NAME
, A.MENU_PRICE
, A.CATEGORY_CODE
, A.ORDERABLE_STATUS
FROM TBL_MENU A
WHERE A.ORDERABLE_STATUS = 'Y'
AND A.CATEGORY_CODE = ?
</entry>
</properties>
class JDBCTemplate
import java.io.FileNotFoundException;
import java.io.FileReader;
import java.io.IOException;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Properties;
public class JDBCTemplate {
public static Connection getConnection() {
Connection con = null;
Properties prop = new Properties();
try {
prop.load(new FileReader("config/connection-info.properties"));
String driver = prop.getProperty("driver");
String url = prop.getProperty("url");
Class.forName(driver);
con = DriverManager.getConnection(url, prop);
/* Application1에서 getAutoCommit()의 결과 true - 기본 값
* 프로그램 내에서 commit과 rollback을 판단하여 수행하고자 하므로 setAutoCommit(false) 설정
* */
con.setAutoCommit(false);
} catch (FileNotFoundException e) {
e.printStackTrace();
} catch (IOException e) {
e.printStackTrace();
} catch (ClassNotFoundException e) {
e.printStackTrace();
} catch (SQLException e) {
e.printStackTrace();
}
return con;
}
public static void close(Connection con) {
try {
if(con != null && !con.isClosed()) {
con.close();
}
} catch (SQLException e) {
e.printStackTrace();
}
}
public static void close(Statement stmt) {
try {
if(stmt != null && !stmt.isClosed()) {
stmt.close();
}
} catch (SQLException e) {
e.printStackTrace();
}
}
public static void close(ResultSet rset) {
try {
if(rset != null && !rset.isClosed()) {
rset.close();
}
} catch (SQLException e) {
e.printStackTrace();
}
}
/* 자동 commit에서 수동 commit으로 설정 변경 후 코드 추가 */
public static void commit(Connection con) {
try {
if(con != null && !con.isClosed()) {
con.commit();
}
} catch (SQLException e) {
e.printStackTrace();
}
}
public static void rollback(Connection con) {
try {
if(con != null && !con.isClosed()) {
con.rollback();
}
} catch (SQLException e) {
e.printStackTrace();
}
}
}
class OrderDAO
import java.io.FileInputStream;
import java.io.IOException;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;
import java.util.Properties;
import static com.greedy.common.JDBCTemplate.close;
import com.greedy.section01.model.dto.CategoryDTO;
import com.greedy.section01.model.dto.MenuDTO;
import com.greedy.section01.model.dto.OrderDTO;
import com.greedy.section01.model.dto.OrderMenuDTO;
public class OrderDAO {
private Properties prop = new Properties();
public OrderDAO() {
try {
prop.loadFromXML(new FileInputStream("mapper/order-query.xml"));
} catch (IOException e) {
e.printStackTrace();
}
}
/* 모든 카테고리 조회용 메소드 */
public List<CategoryDTO> selectAllCategory(Connection con) {
PreparedStatement pstmt = null;
ResultSet rset = null;
List<CategoryDTO> categoryList = null;
String query = prop.getProperty("selectAllCategory");
try {
pstmt = con.prepareStatement(query);
rset = pstmt.executeQuery();
categoryList = new ArrayList<>();
while(rset.next()) {
CategoryDTO category = new CategoryDTO();
category.setCode(rset.getInt("CATEGORY_CODE"));
category.setName(rset.getString("CATEGORY_NAME"));
categoryList.add(category);
}
} catch (SQLException e) {
e.printStackTrace();
} finally {
close(rset);
close(pstmt);
}
return categoryList;
}
/* 카테고리별 메뉴 조회용 메소드 */
public List<MenuDTO> selectMenuByCategory(Connection con, int categoryCode){
PreparedStatement pstmt = null;
ResultSet rset = null;
List<MenuDTO> menuList = null;
String query = prop.getProperty("selectMenuByCategory");
try {
pstmt = con.prepareStatement(query);
pstmt.setInt(1, categoryCode);
rset = pstmt.executeQuery();
menuList = new ArrayList<>();
while(rset.next()) {
MenuDTO menu = new MenuDTO();
menu.setCode(rset.getInt("MENU_CODE"));
menu.setName(rset.getString("MENU_NAME"));
menu.setPrice(rset.getInt("MENU_PRICE"));
menu.setCategoryCode(rset.getInt("CATEGORY_CODE"));
menu.setOrderableStatus(rset.getString("ORDERABLE_STATUS"));
menuList.add(menu);
}
} catch (SQLException e) {
e.printStackTrace();
} finally {
close(rset);
close(pstmt);
}
return menuList;
}
/* 주문 정보 입력용 메소드 */
public int insertOrder(Connection con, OrderDTO order) {
PreparedStatement pstmt = null;
int result = 0;
String query = prop.getProperty("insertOrder");
try {
pstmt = con.prepareStatement(query);
pstmt.setString(1, order.getDate());
pstmt.setString(2, order.getTime());
pstmt.setInt(3, order.getTotalOrderPrice());
result = pstmt.executeUpdate();
} catch (SQLException e) {
e.printStackTrace();
} finally {
close(pstmt);
}
return result;
}
/* 주문 메뉴별 입력용 메소드 */
public int insertOrderMenu(Connection con, OrderMenuDTO orderMenu) {
PreparedStatement pstmt = null;
int result = 0;
String query = prop.getProperty("insertOrderMenu");
try {
pstmt = con.prepareStatement(query);
pstmt.setInt(1, orderMenu.getMenuCode());
pstmt.setInt(2, orderMenu.getOrderAmount());
result = pstmt.executeUpdate();
} catch (SQLException e) {
e.printStackTrace();
} finally {
close(pstmt);
}
return result;
}
}
class CategoryDTO
public class CategoryDTO {
private int code;
private String name;
private Integer refCategoryCode;
public CategoryDTO() {}
public CategoryDTO(int code, String name, Integer refCategoryCode) {
super();
this.code = code;
this.name = name;
this.refCategoryCode = refCategoryCode;
}
public int getCode() {
return code;
}
public void setCode(int code) {
this.code = code;
}
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
public Integer getRefCategoryCode() {
return refCategoryCode;
}
public void setRefCategoryCode(Integer refCategoryCode) {
this.refCategoryCode = refCategoryCode;
}
@Override
public String toString() {
return "CategoryDTO [code=" + code + ", name=" + name + ", refCategoryCode=" + refCategoryCode + "]";
}
}
class MenuDTO
/* DTO(Data Transfer Object) */
public class MenuDTO {
private int code;
private String name;
private int price;
private int categoryCode;
private String orderableStatus;
public MenuDTO() {}
public MenuDTO(int code, String name, int price, int categoryCode, String orderableStatus) {
super();
this.code = code;
this.name = name;
this.price = price;
this.categoryCode = categoryCode;
this.orderableStatus = orderableStatus;
}
public int getCode() {
return code;
}
public void setCode(int code) {
this.code = code;
}
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
public int getPrice() {
return price;
}
public void setPrice(int price) {
this.price = price;
}
public int getCategoryCode() {
return categoryCode;
}
public void setCategoryCode(int categoryCode) {
this.categoryCode = categoryCode;
}
public String getOrderableStatus() {
return orderableStatus;
}
public void setOrderableStatus(String orderableStatus) {
this.orderableStatus = orderableStatus;
}
@Override
public String toString() {
return "MenuDTO [code=" + code + ", name=" + name + ", price=" + price + ", categoryCode=" + categoryCode
+ ", orderableStatus=" + orderableStatus + "]";
}
}
class OrderService
import java.sql.Connection;
import java.util.List;
import com.greedy.section01.model.dao.OrderDAO;
import com.greedy.section01.model.dto.CategoryDTO;
import com.greedy.section01.model.dto.MenuDTO;
import com.greedy.section01.model.dto.OrderDTO;
import com.greedy.section01.model.dto.OrderMenuDTO;
import static com.greedy.common.JDBCTemplate.*;
public class OrderService {
private OrderDAO orderDAO = new OrderDAO();
/* 카테고리 전체 조회용 메소드 */
public List<CategoryDTO> selectAllCategory() {
/* 1. Connection 생성 */
Connection con = getConnection();
/* 2. DAO의 모든 카테고리 조회용 메소드를 호출하여 결과 리턴 받기 */
List<CategoryDTO> categoryList = orderDAO.selectAllCategory(con);
/* 3. 커넥션 닫기 (select는 commit, rollback X) */
close(con);
/* 4. 반환 받은 값 리턴하기 */
return categoryList;
}
/* 카테고리별 메뉴 조회용 메소드 */
public List<MenuDTO> selectMenuByCategory(int categoryCode) {
/* 1. Connection 생성 */
Connection con = getConnection();
/* 2. DAO의 해당 카테고리 메뉴를 조회하는 메소드로 categoryCode 전달하며 조회 */
List<MenuDTO> menuList = orderDAO.selectMenuByCategory(con, categoryCode);
/* 3. Connection 닫기 */
close(con);
/* 4. 반환받은 값 리턴하기 */
return menuList;
}
/* 주문 정보 등록용 메소드 */
public int registOrder(OrderDTO order) {
/* 1. Connection 생성 */
Connection con = getConnection();
/* 2. 리턴할 값 초기화 */
int result = 0;
/* 3. DAO 메소드로 전달 받은 값 넘겨서 insert */
/* 3-1. Order table insert */
int orderResult = orderDAO.insertOrder(con, order);
/* 3-2. Order Menu table insert */
List<OrderMenuDTO> orderMenuList = order.getOrderMenuList();
int orderMenuResult = 0;
for(OrderMenuDTO orderMenu : orderMenuList) {
orderMenuResult += orderDAO.insertOrderMenu(con, orderMenu);
}
/* 4. 성공 여부 판단 후 트랜잭션 처리 */
if(orderResult > 0 && orderMenuResult == orderMenuList.size()) {
commit(con);
result = 1;
} else {
rollback(con);
}
/* 5. Connection 닫기 */
close(con);
/* 6. 결과 값 반환 */
return result;
}
}
class Application
import com.greedy.section01.view.OrderMenu;
public class Application {
public static void main(String[] args) {
new OrderMenu().displayMenu();
}
}
class OrderMenu
import java.text.SimpleDateFormat;
import java.util.ArrayList;
import java.util.List;
import java.util.Scanner;
import com.greedy.section01.model.dto.CategoryDTO;
import com.greedy.section01.model.dto.MenuDTO;
import com.greedy.section01.model.dto.OrderDTO;
import com.greedy.section01.model.dto.OrderMenuDTO;
import com.greedy.section01.model.service.OrderService;
public class OrderMenu {
private OrderService orderService = new OrderService();
public void displayMenu() {
/* 반복
* ------------------------
* 1. 카테고리 조회
* 2. 해당 카테고리의 메뉴 조회
* 3. 사용자에게 어떤 메뉴를 주문 받을 것인지 입력
* 4. 주문할 수량 입력
* ------------------------
* 5. 주문
* */
Scanner sc = new Scanner(System.in);
List<OrderMenuDTO> orderMenuList = new ArrayList<>();
int totalOrderPrice = 0;
do {
System.out.println("=============== 음식 주문 프로그램 ==================");
List<CategoryDTO> categoryList = orderService.selectAllCategory();
for(CategoryDTO category : categoryList) {
System.out.println(category.getName());
}
System.out.println("=================================================");
System.out.print("주문하실 카테고리를 선택해주세요 : ");
String inputCategory = sc.nextLine();
int categoryCode = 0;
for(CategoryDTO category : categoryList) {
if(category.getName().equals(inputCategory)) {
categoryCode = category.getCode();
}
}
System.out.println("================ 주문 가능 메뉴 ====================");
List<MenuDTO> menuList = orderService.selectMenuByCategory(categoryCode);
for(MenuDTO menu : menuList) {
System.out.println(menu);
}
System.out.print("주문하실 메뉴를 선택해주세요 : ");
String inputMenu = sc.nextLine();
int menuCode = 0;
int menuPrice = 0;
for(int i = 0; i < menuList.size(); i++) {
MenuDTO menu = menuList.get(i);
if(menu.getName().equals(inputMenu)) {
menuCode = menu.getCode();
menuPrice = menu.getPrice();
}
}
System.out.print("주문하실 수량을 입력하세요 : ");
int orderAmount = sc.nextInt();
OrderMenuDTO orderMenu = new OrderMenuDTO();
orderMenu.setMenuCode(menuCode);
orderMenu.setOrderAmount(orderAmount);
orderMenuList.add(orderMenu);
totalOrderPrice += (menuPrice * orderAmount);
System.out.print("계속 주문하시겠습니까?(예/아니오) : ");
sc.nextLine();
boolean isContinue = sc.nextLine().equals("예") ? true : false;
if(!isContinue) break;
} while(true);
for(OrderMenuDTO orderMenu : orderMenuList) {
System.out.println(orderMenu);
}
java.util.Date orderTime = new java.util.Date();
SimpleDateFormat dateFormat = new SimpleDateFormat("yy/MM/dd");
SimpleDateFormat timeFormat = new SimpleDateFormat("HH:mm:ss");
String date = dateFormat.format(orderTime);
String time = timeFormat.format(orderTime);
OrderDTO order = new OrderDTO();
order.setDate(date);
order.setTime(time);
order.setTotalOrderPrice(totalOrderPrice);
order.setOrderMenuList(orderMenuList);
int result = orderService.registOrder(order);
if(result > 0) {
System.out.println("주문에 성공하셨습니다.");
} else {
System.out.println("주문에 실패하셨습니다.");
}
}
}
'Programming > JDBC' 카테고리의 다른 글
| JDBC 응용 연습(2) (0) | 2022.02.07 |
|---|---|
| JDBC 개요 (0) | 2022.01.28 |
