import java.io.*;
import java.text.*;
import java.util.*;
import javax.servlet.*;
import javax.servlet.http.*;
import java.sql.*;
import BookStoreBeans.*;

public class LoginTry extends HttpServlet
{
    public void doPost(HttpServletRequest req, HttpServletResponse res)
    throws IOException, ServletException
    {
        String email = null;
        String password = null;

        PrintWriter out = res.getWriter();
        HttpSession session = req.getSession();


        email = req.getParameter("email");
        password = req.getParameter("password");

        cust member = new cust();


        String SQLSearch = "Select * from customer where customer.custEmail = '" + email;
        SQLSearch += "'and customer.custPassword = '" + password + "';'";

        String URL = "jdbc:postgresql:Rosenberg";

        try
        {
            Class.forName("org.postgresql.Driver");
            Connection con = DriverManager.getConnection(URL, "webuser", "webuser");
            Statement stmt = con.createStatement();
            ResultSet rs = stmt.executeQuery(SQLSearch);

            if (rs.next())
            {
                member.setUserID(rs.getInt("custNum"));
                member.setName(rs.getString("custName"));
                member.setEmail(rs.getString("custEmail"));
                member.setPassword(rs.getString("custPassword"));

                session.setAttribute("member", member);
                res.sendRedirect("/Rosenberg/jsp/accountInfo.jsp");
            }
            else
            {
                rs.close();
            }
        }
        catch(Exception sqle)
        {
            out.println("error occured: " + sqle);
        }
    }
}