PrekesPaieskaServlet

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.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

@WebServlet(
        name = "prekesPaieskaServlet",
        urlPatterns = "/PrekesPaieska"
)
public class PrekesPaieskaServlet extends HttpServlet
{
    @Override
    protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException
    {
        PrintWriter out = resp.getWriter();

        String ieskomaPreke = req.getParameter("ieskoma-preke");

        try
        {
            Connection jungtis = DuombazesSukurimas.sukurtiDuomenuBaze();

           // String sqlUzklausa = "SELECT * FROM prekes";            // testine uzklausa, su kuria isvesime viska

            String sqlUzklausa = "SELECT * FROM prekes WHERE pav=?";

            PreparedStatement prepSt = jungtis.prepareStatement(sqlUzklausa);
            prepSt.setString(1, ieskomaPreke);

            ResultSet rezultatai = prepSt.executeQuery();

            while (rezultatai.next())
            {
                String pav = rezultatai.getString("pav");
                double kaina = rezultatai.getDouble("kaina");
                String aprasas = rezultatai.getString("aprasas");

                out.println(pav);
                out.println(kaina);
                out.println(aprasas);
            }

            // Testas - isvesti visus lenteles irasus bei taip pat NEOPTIMALUS paieskos metodas - parsiunciant visus lenteles duomenis ir juose ieksant per Java
          /*  while (rezultatai.next())
            {
                String pav = rezultatai.getString("pav");
                double kaina = rezultatai.getDouble("kaina");
                String aprasas = rezultatai.getString("aprasas");

                if (ieskomaPreke.equals(pav))
                {
                    out.println(pav);
                    out.println(kaina);
                    out.println(aprasas);
                }
            }*/
        }
        catch (SQLException e)
        {
            e.printStackTrace();
        }

        out.println(ieskomaPreke);



    }
}