Untitled

<@page contentType="text/html" pageEncoding="UTF-8"%>
<%@ page import ="java.sql.*" %>
<% Class.forName("com.mysql.jdbc.Driver"); %>
<% String idprod = request.getParameter("idprod");%>
<!DOCTYPE html>
<html>
    <head>
        <title>JSP Page</title>
    </head>
    <body>
        <%!
            public class Actor{
            String URL = "jdbc:mysql://localhost:3306/mysql";
             String USERNAME = "root";
            String PASSWD = "";
            String em="";
            String pr="";
            String tempid="";
            Connection connection = null;
            PreparedStatement select= null;
            PreparedStatement select2= null;
            ResultSet resultSet = null;
             int a = 0;
            public Actor(String b){
            try{
            tempid=b;
            connection = DriverManager.getConnection(URL, USERNAME,PASSWD );
            select = connection.prepareStatement("SELECT quantity FROM products where id="+tempid );
            select2 = connection.prepareStatement("SELECT price FROM products where id="+tempid );
            }
            catch (SQLException e){
                 e.printStackTrace();
            }
        }
         public int check(){
            try{
                resultSet = select.executeQuery();

            }
            catch (SQLException e){
                 e.printStackTrace();
            }
            return a;
            }
        public String getActors(){

            try{
                resultSet = select.executeQuery();
            while (resultSet.next()) {
            em = resultSet.getString("quantity");
            }
            } catch (SQLException e){
            e.printStackTrace();
        }
          return em;
    }
public String getPrice(){

            try{
                resultSet = select2.executeQuery();
            while (resultSet.next()) {
            pr = resultSet.getString("price");
            }
            } catch (SQLException e){
            e.printStackTrace();
        }
          return pr;
    }

}
%>
        <%

            Actor actor = new Actor(idprod);
            String actors = actor.getActors();

         int iloscsztuk= Integer.parseInt(actors);
         int ilosckupionych =Integer.parseInt(request.getParameter("howmany"));
         int wynik=iloscsztuk-ilosckupionych;
         actors = actor.getPrice();
         double cenajednostkowa=Double.parseDouble(actors);
         double cenalaczna=cenajednostkowa*Double.parseDouble(request.getParameter("howmany"));


     Class.forName("com.mysql.jdbc.Driver");
    Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/mysql",
            "root", "");
    Statement st = con.createStatement();
    //ResultSet rs;
    int i = st.executeUpdate("Update products set quantity="+wynik+" where id="+idprod);
    if (i > 0) {
        //session.setAttribute("userid", user);
        out.println("Kupiono "+ilosckupionych+" sztuk produktu za cene ");
        %>
        <form method="POST" action="index.jsp">
        <input  type = "submit" value = "Kupuje i place" />
        </form>

     <%
    } else {
        response.sendRedirect("index.jsp");
    }

  %>

    </body>
</html>