Untitled

<%@page contentType="text/html" pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
    <head>
        <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
        <title>JSP Page</title>
    </head>
    <body>
        <h4> ${(poruka!=null) ? poruka: "Welcome!"} </h4> <br><br>
        <form action="Login" method="post">
            Korisnicko ime: <input type="text" name="username" value="${korisnik.username}"><br>
            Sifra: <input type="password" name="password" value="${korisnik.password}"><br>
            <select name="tip">
                <option value="kupac">kupac</option>
                <option value="prodavac">prodavac</option>
            </select><br><br>

            <input type="submit" value="Prijava">
            <input type="reset" value="Reset">


        </form>

        <h1 style="color: red">${greska}</h1>


    </body>
</html>

package servlets;

import beans.Korisnik;
import java.io.IOException;
import java.io.PrintWriter;
import javax.servlet.RequestDispatcher;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;

import java.sql.*;
import java.util.logging.Level;
import java.util.logging.Logger;

public class Login extends HttpServlet {

    protected void doPost(HttpServletRequest request, HttpServletResponse response)
            throws ServletException, IOException {

        HttpSession session = request.getSession();
        response.setContentType("text/html;charset=UTF-8");
        PrintWriter out = response.getWriter();

        String poruka = "";
        String adresa = "/index.jsp";
        String username = (String) request.getParameter("username");
        String password = (String) request.getParameter("password");
        String vrstaKorisnika = request.getParameter("tip");

        Korisnik korisnik = new Korisnik();
        korisnik.setUsername(username);
        korisnik.setPassword(password);

        session.setAttribute("korisnik", korisnik);
        if (username.equals("") || password.equals("")) {

            poruka = "Unesite korisnicko ime i sifru!";
            request.setAttribute("poruka", poruka);
            RequestDispatcher reqDisp = request.getRequestDispatcher("index.jsp");
            reqDisp.forward(request, response);
        }

        String myDriver = "com.mysql.jdbc.Driver";
        String myUrl = "jdbc:mysql://localhost/eprodavnica2017";
        String mySQLuserNameString = "root";
        String mySQLPasswordString = "root";

        try {
            Class.forName(myDriver);
        } catch (ClassNotFoundException ex) {
            Logger.getLogger(Login.class.getName()).log(Level.SEVERE, null, ex);
        }

        Connection connection;
        String query = "";
        Statement st;
        ResultSet rs;

        try {
            connection = DriverManager.getConnection(myUrl, mySQLuserNameString, mySQLPasswordString);
            query = "select * from korisnik where username='" + username + "' and password='" + password + "';";
            st = connection.createStatement();
            rs = st.executeQuery(query);

            if (rs.next() && vrstaKorisnika.equals("kupac")) {

                String tip = rs.getString("type");
                if (tip.equals("kupac")) {
                    adresa = "/kupac.jsp";
                    st.close();

                    RequestDispatcher rd = request.getRequestDispatcher(adresa);
                    rd.forward(request, response);
                }

            }

            connection = DriverManager.getConnection(myUrl, mySQLuserNameString, mySQLPasswordString);
            query = "select * from korisnik where username='" + username + "' and password='" + password + "';";
            st = connection.createStatement();
            rs = st.executeQuery(query);

            if (rs.next() && vrstaKorisnika.equals("prodavac") && !vrstaKorisnika.equals("kupac")) {

                String tip;
                try {
                    tip = rs.getString("type");
                    if (tip.equals("prodavac")) {
                        adresa = "/prodavac.jsp";
                    }
                } catch (SQLException ex) {
                    Logger.getLogger(Login.class.getName()).log(Level.SEVERE, null, ex);
                }

            } else {

                poruka = "Neispravno korisnicko ime i lozinka! Pokusajte ponovo.";
                request.setAttribute("poruka", poruka);
                korisnik.setPassword("");
                adresa = "/index.jsp";
                //st.close();
            }

        } catch (SQLException ex) {
            Logger.getLogger(Login.class.getName()).log(Level.SEVERE, null, ex);
        }

        RequestDispatcher rd = request.getRequestDispatcher(adresa);
        rd.forward(request, response);

    }

    // <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 {
        try {
            processRequest(request, response);
        } catch (ClassNotFoundException ex) {
            Logger.getLogger(Login.class.getName()).log(Level.SEVERE, null, ex);
        } catch (SQLException ex) {
            Logger.getLogger(Login.class.getName()).log(Level.SEVERE, null, ex);
        }
    }*/
    /**
     * 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 {
        try {
            processRequest(request, response);
        } catch (ClassNotFoundException ex) {
            Logger.getLogger(Login.class.getName()).log(Level.SEVERE, null, ex);
        } catch (SQLException ex) {
            Logger.getLogger(Login.class.getName()).log(Level.SEVERE, null, ex);
        }
    }*/
    /**
     * Returns a short description of the servlet.
     *
     * @return a String containing servlet description
     */
    @Override
    public String getServletInfo() {
        return "Short description";
    }// </editor-fold>

}


<%@page import="java.util.ArrayList"%>
<%@page import="java.sql.*"%>
<%@page import="java.util.logging.Logger"%>
<%@page import="beans.Artikli"%>
<%@page import="util.DB"%>
<%@page contentType="text/html" pageEncoding="UTF-8"%>


<!DOCTYPE html>


<%

    ArrayList<Artikli> listaArtikala=new ArrayList<Artikli>();

    String nazivProdavnice=request.getParameter("pretraga");

    String query="";

    query="select * from artikli;";
    if(request.getParameter("pretraga")!="")
       query="select * from artikli where naziv_prodavnice='" + nazivProdavnice + "';";

    listaArtikala=DB.listaArtikala(query);


%>


<html>
    <head>
        <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
        <title>Kupac</title>
    </head>
    <body>


        <table border="1">
            <tr>
                <td>Naziv</td>
                <td>Boja</td>
                <td>Kolicina</td>
                <td>Cena</td>
            </tr>

            <%  for(int i=0; i<listaArtikala.size(); i++) {
            %>
            <tr>
                <td><% out.println(listaArtikala.get(i).getNaziv()); %></td>
                <td><% out.println(listaArtikala.get(i).getBoja()); %></td>
                <td><% out.println(listaArtikala.get(i).getKolicina_na_lageru()); %></td>
                <td><% out.println(listaArtikala.get(i).getCena()); %></td>

            </tr>

            <% } %>
        </table>


         <h4> ${(poruka!=null) ? poruka: "Stranica kupca!"} </h4> <br><br>
        <form action="kupac.jsp" method="post">
            Pretraga artikla: <input type="text" name="pretraga" value="${artikli.naziv_prodavnice}">
            <input type="submit" value="Submit">

        </form>
        <br>
            <form action="Logout">
                <input type="submit" value="Logout">

            </form>

    </body>
</html>


<%@page import="util.DB"%>
<%@page import="java.util.ArrayList"%>
<%@page import="beans.Artikli"%>
<%@page contentType="text/html" pageEncoding="UTF-8"%>
<!DOCTYPE html>

<%

    ArrayList<Artikli> listaArtikala = new ArrayList<Artikli>();

    String idArtikla = request.getParameter("pretraga");
    String kolLager = request.getParameter("kolicina");

    int id=0;
    int kolicina=0;

    if(idArtikla!=null && kolLager!=null){

        id=Integer.parseInt(idArtikla);
        kolicina=Integer.parseInt(kolLager);

        DB.izmeniKolicinuArtikala(id, kolicina);


    }

    String query = "";
    query = "select * from artikli;";

    listaArtikala = DB.listaArtikala(query);


%>

<html>
    <head>
        <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
        <title>JSP Page</title>
    </head>
    <body>
        <table border="1">
            <tr>
                <td>ID</td>
                <td>Naziv</td>
                <td>Boja</td>
                <td>Kolicina</td>
                <td>Cena</td>
            </tr>

            <%  for (int i = 0; i < listaArtikala.size(); i++) {
            %>
            <tr>

                <td><% out.println(listaArtikala.get(i).getId_artikal()); %></td>
                <td><% out.println(listaArtikala.get(i).getNaziv()); %></td>
                <td><% out.println(listaArtikala.get(i).getBoja()); %></td>
                <td><% out.println(listaArtikala.get(i).getKolicina_na_lageru()); %></td>
                <td><% out.println(listaArtikala.get(i).getCena()); %></td>

            </tr>

            <% }%>
        </table>

<br><br>

        <form action="prodavac.jsp" method="post">
            ID artikla: <input type="text" name="pretraga" value="${artikli.id_artikal}">
            Kolicina: <input type="text" name="kolicina" value="${artikli.kolicina_na_lageru}">
            <input type="submit" value="Izmeni kolicinu">

        </form>

    </body>
</html>


package util;

import beans.Artikli;
import java.util.ArrayList;
import java.sql.*;


public class DB {


    public static ArrayList<Artikli> listaArtikala(String query){

        ArrayList<Artikli> listaArtikala = new ArrayList<Artikli>();

         String myDriver="com.mysql.jdbc.Driver";
        String myUrl = "jdbc:mysql://localhost/eprodavnica2017";
        String mySQLuserNameString="root";
        String mySQLPasswordString="root";


        Connection connection;

        Statement st;
        ResultSet rs;

        try {
            connection = DriverManager.getConnection(myUrl, mySQLuserNameString, mySQLPasswordString);

            st=connection.createStatement();
            rs=st.executeQuery(query);

            while(rs.next()){

                    int id_artikal=rs.getInt("id_artikal");
                    String naziv=rs.getString("naziv");
                    String boja=rs.getString("boja");
                    int kolicina_na_lageru=rs.getInt("kolicina_na_lageru");
                    int cena=rs.getInt("cena");
                    String naziv_prodavnice=rs.getString("naziv_prodavnice");

                    listaArtikala.add(new Artikli(id_artikal, naziv, boja, kolicina_na_lageru, cena, naziv_prodavnice));

            }


        } catch (SQLException ex) {

        }

        return listaArtikala;

    }

    public static void izmeniKolicinuArtikala(int idArtikla, int kolLager) {

        String myDriver="com.mysql.jdbc.Driver";
        String myUrl = "jdbc:mysql://localhost/eprodavnica2017";
        String mySQLuserNameString="root";
        String mySQLPasswordString="root";


        Connection connection;
         Statement st;
        ResultSet rs;

        try {
            connection = DriverManager.getConnection(myUrl, mySQLuserNameString, mySQLPasswordString);

            st=connection.createStatement();
            rs=st.executeQuery("select * from artikli where id_artikal= '" + idArtikla + "';");

            while(rs.next()){

                    //int id_artikal=rs.getInt("id_artikal");

                    String sql="update artikli set kolicina_na_lageru=? where id_artikal='" + idArtikla+ "';";
                    PreparedStatement ps=connection.prepareStatement(sql);
                    ps.setInt(1, kolLager);
                    ps.executeUpdate();


            }


        } catch (SQLException ex) {}
    }

}