import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

public class LoginDAO {

    public static boolean validate(String user, String password) {
        Connection con = null;
        PreparedStatement ps = null;
        DatabaseClass db = new DatabaseClass();

        try {
            con = db.getConn();
            ps = con.prepareStatement("SELECT username, password from users WHERE username = ? and password = ?");
            ps.setString(1, user);
            ps.setString(2, password);

            ResultSet rs = ps.executeQuery();

            if (rs.next()) {
                //result found, means valid inputs
                return true;
            }
        } catch (SQLException ex) {
            System.out.println("Login error -->" + ex.getMessage());
            return false;
        }
        return false;
    }

    public static boolean validateStatus(String user, String status){
        Connection con = null;
        PreparedStatement ps = null;
        DatabaseClass db = new DatabaseClass();

        try {
            con = db.getConn();
            ps = con.prepareStatement("Select username, status from users where username = ? and status = ?");
            ps.setString(1, user);
            ps.setString(2, status);

            ResultSet rs = ps.executeQuery();

            if (rs.next()) {
                //result found, means valid inputs
                return true;
            }
        } catch (SQLException ex) {
            return false;
        }
        return false;
    }
}