package dao;

import utils.DataBaseUtil;
import java.sql.*;

public class UserDao {

    public boolean isUserExist(String userName,String passWord) {
        //create a connection
        Connection connection = DataBaseUtil.getConnection();

        String sql ="select * from tb_user WHERE username=? and password=?";
        try{
            PreparedStatement ps = connection.prepareStatement(sql);
            ps.setString(1,userName);
            ps.setString(2,passWord);
            ResultSet resultSet = ps.executeQuery();
            if( resultSet.next() ) {
                return true;
            }
        }catch(SQLException e) {
            System.out.println(e.toString());
            e.printStackTrace();
        }catch(NullPointerException f){
            f.printStackTrace();
        }finally {
            DataBaseUtil.closeConnection(connection);
        }
        return false;
    }
}