package com.softgraf.vendas.model.dao;

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

/*
	CREATE TABLE LoginSistema (
		usuario VARCHAR(45) NOT NULL UNIQUE,
	    senha VARCHAR(45) NOT NULL,
	);
*/
public class LoginSistema {

	public static boolean logar(Conexao conexao, String usuario, String senha) {
		boolean logado = false;
		String sql = "SELECT COUNT(*) AS quant FROM LoginSistema WHERE upper(usuario)=? AND senha=?";

		try {
			PreparedStatement cmd = conexao.getConexao().prepareStatement(sql);
			cmd.setString(1, usuario);
			cmd.setString(2, senha);
			ResultSet rs = cmd.executeQuery();

			if (rs.next() &&  rs.getInt("quant") > 0) {
				logado = true;
			}
			
			cmd.close();

		} catch (SQLException e) {
			e.printStackTrace();
		}
		
		return logado;
	}

}