package Servlets;


import Klasy.KolekcjaDanych;
import Klasy.User;
import java.io.IOException;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import javax.annotation.Resource;
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 javax.sql.DataSource;



public class LoginServlet extends HttpServlet {

    @Resource(name = "jdbc/bazaSQLData")
    private DataSource jdbcBazaSQLData;
    @Resource(name = "jdbc/bazaSQL")
    private DataSource jdbcBazaSQL;

    KolekcjaDanych listaDanych = new KolekcjaDanych();

    @Override
    protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        String username = request.getParameter("username");
        String password = request.getParameter("password");
        String login = "";
        String pass = "";

        try{
            if(!(username.equals("") || password.equals(""))){


                Connection con = jdbcBazaSQL.getConnection();
                String sql = "select * from users where user_name='"+ username +"' and user_pass='"+ password +"'";
                Statement st = con.createStatement();
                ResultSet rs = st.executeQuery(sql);

                while(rs.next()){
                    login = rs.getString("user_name");
                    pass = rs.getString("user_pass");
                }

                if(username.equals(login) && password.equals(pass)){
                    User user = new User(login, pass);
                    HttpSession session = request.getSession(true);
                    session.setAttribute("user", user);



                    Connection con2 = jdbcBazaSQLData.getConnection();
                    sql = "select * from t_dane";
                    st = con2.createStatement();
                    rs = st.executeQuery(sql);

                    while(rs.next()){
                        String id =  rs.getString(1);
                        String data = rs.getString(2);
                        String typ = rs.getString(3);
                        String opis = rs.getString(4);
                        String cena = rs.getString(5);

                       listaDanych.addData(id, data, typ, opis, cena);

                    }
                    getServletContext().setAttribute("kolekcjaDanych", listaDanych);

                    response.sendRedirect("JSPs/main.jsp");
                }
                else
                    response.sendRedirect("JSPs/error.jsp");
            }
            else
                response.sendRedirect("JSPs/error.jsp");
        }
        catch(IOException | SQLException ex){ }

    }
}