pemesananServlet

/*
 * To change this license header, choose License Headers in Project Properties.
 * To change this template file, choose Tools | Templates
 * and open the template in the editor.
 */
package control;

import java.io.IOException;
import java.io.PrintWriter;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.logging.Level;
import java.util.logging.Logger;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

/**
 *
 * @author Arthur
 */
public class pemesanannServlet extends HttpServlet {

    /**
     * Processes requests for both HTTP <code>GET</code> and <code>POST</code>
     * methods.
     *
     * @param request servlet request
     * @param response servlet response
     * @throws ServletException if a servlet-specific error occurs
     * @throws IOException if an I/O error occurs
     */
    protected void processRequest(HttpServletRequest request, HttpServletResponse response)
            throws ServletException, IOException {
        response.setContentType("text/html;charset=UTF-8");
        try (PrintWriter out = response.getWriter()) {
            /* TODO output your page here. You may use following sample code. */
            String nopesan = request.getParameter("nopesan");
            String tglpesan = request.getParameter("tglpesan");
            String kdsupplier = request.getParameter("kdsupplier");
            String kdbarang = request.getParameter("kdbarang");
            String qty = request.getParameter("qty");
            String subtotal = request.getParameter("subtotal");
            String total = request.getParameter("total");
            String aksi = request.getParameter("aksi");
            String sql = "";
            String sql2 = "";
            switch(aksi){
                case "Tambah":
                    sql = "INSERT INTO sementara VALUES('"
                            + nopesan + "','"
                            + kdbarang + "',"
                            + qty + ","
                            + subtotal + ")";
                    break;
                case "Delete":
                    sql = "DELETE FROM sementara WHERE kode='"
                            + kdbarang + "'";
                    break;
                case "Simpan":
                    sql = "INSERT INTO pemesanan VALUES('"
                            + nopesan + "','"
                            + tglpesan + "',"
                            + total + ",'"
                            + kdsupplier + "')";
                    break;
                case "Batal":
                    sql = "TRUNCATE TABLE sementara";
                    break;

            }
            boolean eror = false;
            Koneksi kon = new Koneksi();
            Koneksi kon2 = new Koneksi();
            if(!aksi.equals("Simpan")){
            try {
                kon.stmt.executeUpdate(sql);
            } catch (Exception ex) {
                eror = true;
            }
            } else {
                sql2 = "SELECT * FROM sementara";
                ResultSet rs = kon.ambilData(sql2);
                while(rs.next()){
                    sql2 = "INSERT INTO detail_pesan VALUES('"
                            + rs.getString(1) + "','"
                            + rs.getString(2) + "',"
                            + rs.getString(3) + ","
                            + rs.getString(4) + ")";
                    try {
                        kon2.stmt.executeUpdate(sql2);
                    } catch (Exception ex) {
                        eror = true;
                    }
                }
                sql2 = "TRUNCATE TABLE sementara";
                if(!eror){
                    try {
                        kon.stmt.executeUpdate(sql);
                        kon2.stmt.executeUpdate(sql2);
                    } catch (Exception ex) {
                        eror = true;
                    }
                }
            }
            if(!eror)
                out.print("<script>"
                        + "alert('Data Berhasil di " + aksi + "');"
                        + "window.location='pemesanan.jsp';"
                        + "</script>");
            else
                out.print(sql+" "+sql2+"<script>"
                        + "alert('Data Gagal di " + aksi + "');"
                        + "</script>");
        } catch (ClassNotFoundException ex) {
            Logger.getLogger(pemesanannServlet.class.getName()).log(Level.SEVERE, null, ex);
        } catch (SQLException ex) {
            Logger.getLogger(pemesanannServlet.class.getName()).log(Level.SEVERE, null, ex);
        }
    }

    // <editor-fold defaultstate="collapsed" desc="HttpServlet methods. Click on the + sign on the left to edit the code.">
    /**
     * Handles the HTTP <code>GET</code> method.
     *
     * @param request servlet request
     * @param response servlet response
     * @throws ServletException if a servlet-specific error occurs
     * @throws IOException if an I/O error occurs
     */
    @Override
    protected void doGet(HttpServletRequest request, HttpServletResponse response)
            throws ServletException, IOException {
        processRequest(request, response);
    }

    /**
     * Handles the HTTP <code>POST</code> method.
     *
     * @param request servlet request
     * @param response servlet response
     * @throws ServletException if a servlet-specific error occurs
     * @throws IOException if an I/O error occurs
     */
    @Override
    protected void doPost(HttpServletRequest request, HttpServletResponse response)
            throws ServletException, IOException {
        processRequest(request, response);
    }

    /**
     * Returns a short description of the servlet.
     *
     * @return a String containing servlet description
     */
    @Override
    public String getServletInfo() {
        return "Short description";
    }// </editor-fold>

}