package com.ararbtuerkat_db.aratuerk.db;

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

public class SqlAccess {

public static Connection con = null;
public static ResultSet resultSet = null;
private final String LoginServerAddress = "<address>/<databaseName>?user=
<sqlUser>&password=<SqlUserPW>";
private final String tag = "SQL";

/**
 * isLoginCorrect() Checks validity.
 * @param username Username like it's stored in the Database.
 * @param password Password like it's stored in the Database.
 * @return Validity
 */
public boolean isLoginCorrect(String username,String password){
    if(!setConnection(LoginServerAddress)){
        refuseConnection();
        return false;
    }

    if(!executeStatemant("SELECT * FROM <tableName>")){
        refuseConnection();
        return false;
    }

    try{
        while(resultSet.next()){
            if(resultSet.getString(1) == username && resultSet.getString(2) == password){
                refuseConnection();
                return true;
            }
        }
        refuseConnection();
        return false;
    }catch(SQLException e){
        Log.e(tag,e);
        refuseConnection();
        return false;
    }

    refuseConnection();
    return false;

}
private boolean setConnection(String ServerAddress){
    try{
        SqlAccess.con = DriverManager.getConnection(ServerAddress);
    }
    catch(SQLException e){
        Log.e(tag,e);
        return false;
    }
    return true;
}
private boolean executeStatemant(String statement){
    try{
        SqlAccess.resultSet = con.createStatement().executeQuery(statement);
    }catch(SQLException e){
        Log.e(tag,e);
        return false;
    }
    return true;
}
private void refuseConnection(){
    con = null;
    resultSet = null;
}
}