[JSP] 예약하기 페이지 구현

jsp 회원등록,수정,삭제,리스트(CRUD) 로직 구현하기 예약페이지 예약

  
    
    protected void process(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        
        
        
        
        request.setCharacterEncoding("UTF-8");
        response.setContentType("text/html;charset=utf-8");
        
        
        String uri = request.getRequestURI();
        System.out.println("uri:"+uri);
    
        String pj = request.getContextPath();
        System.out.println(pj);
        String command = uri.substring(pj.length());
        System.out.println("command:"+command);
        
        
        
        if(command.equals("/res/rescontent.do")) {
            
            
            RequestDispatcher rd = request.getRequestDispatcher("/res/rescontent.jsp");
            rd.forward(request, response);
        
        }else if(command.equals("/res/rescontentAction.do")) {
            
            
            System.out.println("예약 페이지 입성");
            
            String Name = request.getParameter("Name");
            
            System.out.println("Name =" +Name);
            
            String respeople = request.getParameter("respeople");
            
            int Respeople = Integer.parseInt(respeople);
            
            System.out.println("Respeople =" + Respeople);
            
            
            //금액
            
            String rvprice1 = request.getParameter("sell_price");
            int rvprice = Integer.parseInt(rvprice1);
            
            
            String rvpricesum1 = request.getParameter("sum");
            
            int rvpricesum = Integer.parseInt(rvpricesum1);
            
            
            //예약일
            
            String dataA = request.getParameter("dataA");            
            
            
            System.out.println("dataA ="+ dataA);
            
            String data = request.getParameter("data");
            
            
            System.out.println("data =" +data);
            
            HttpSession session = request.getSession();
            
            int midx = (int) session.getAttribute("midx");
            
            System.out.println("midx ="+midx);
            
            String membername = (String)session.getAttribute("membername");
            
            System.out.println("membername ="+membername);
            
            
            
            
            ResDao rd  = new ResDao();
            
            int value = rd.insertRes(Name, Respeople,dataA, data, midx, membername,rvprice,rvpricesum);
            
            System.out.println("value =" +value);
            
        
            
            
            if(value==1) {
                session.setAttribute("Name", Name);
                session.setAttribute("sum", rvpricesum);
                response.sendRedirect(request.getContextPath()+"/res/pay.do");
            }else {
                response.sendRedirect(request.getContextPath()+"/res/rescontent.do");
            }
            
            

public int insertRes(String rvname,int Respeople,String dataA,String data,int midx,String membername,int rvprice,int rvpricesum) {
 
        int value=0;
        PreparedStatement pstmt = null;
        
        
        String sql = "insert into reservation(ridx,rvname,rvpeople,writedayA,writeday,midx,membername,rvprice,rvpricesum)"
                +"values(ridx_b_seq.NEXTVAL,?,?,?,?,?,?,?,?)";
                
        
        try {
            pstmt = conn.prepareStatement(sql);
            pstmt.setString(1, rvname);
            pstmt.setInt(2, Respeople);
            pstmt.setString(3, dataA);
            pstmt.setString(4, data);
            pstmt.setInt(5, midx);
            pstmt.setString(6, membername);
            pstmt.setInt(7, rvprice);
            pstmt.setInt(8, rvpricesum);
            value=pstmt.executeUpdate();
            
            
            
        } catch (Exception e) {
            e.printStackTrace();
        }
        System.out.println("value =" +value);
        
        return value;
        
        
    }