package org.db.veiksmai;

import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;

@WebServlet(
        name = "prekesIvedimoServlet",
        urlPatterns = "/PrekesIvedimas"   )
public class PrekesIvedimoServlet extends HttpServlet
{
    @Override
    protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException
    {
        /*------------------------Gauname duomenis is HTML formos*----------------------------*/
        String prekesPavadinimas = req.getParameter("pav");
        double prekesKaina = Double.parseDouble(req.getParameter("kaina"));
        String prekesAprasas = req.getParameter("aprasas");
        System.out.println(prekesPavadinimas);
        System.out.println(prekesKaina + 1);
        System.out.println(prekesAprasas);

        /*------------------------Veiksmai su Duomenu baze prasideda*----------------------*/

        try {
            Connection jungtis = DuombazesSukurimas.sukurtiDuomenuBaze();

            String sqlUzklausa = "INSERT INTO prekes (pav, kaina, aprasas) VALUES (?, ?, ?)";
            PreparedStatement prepSt = jungtis.prepareStatement(sqlUzklausa);

            prepSt.setString(1, prekesPavadinimas);
            prepSt.setDouble(2, prekesKaina);
            prepSt.setString(3, prekesAprasas);

            prepSt.executeUpdate();

            prepSt.close();
            jungtis.close();

            PrintWriter out = resp.getWriter();
            out.println("Idejome duomenu baze");
        }
        catch (Exception e)
        {
            e.printStackTrace();
        }
    }
}