package com.catalyst.Modules;

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

public class Login
{
    private boolean isAuthed; // Default to false

    Connection hConnection;
    Statement insertStatement, selectStatement;

    String strDBuserName    = "root";                                       // DB Username
    String strDBuserPass    = "root";                                       // DB Password
    String strDBHost        = "jdbc:derby://localhost:1527/prjVet";         // DB Location
    String strMyDriver      = "com.mysql.jdbc.Driver";                      // DB Driver (Not used)

    public String QueryTheDatabase(String pQuery)
    {
        String strSQLQuery;
        StringBuilder strOutput = new StringBuilder();

        strSQLQuery = pQuery;

        // We are preparing the Statement
        try {
            Connection hDBCon       = DriverManager.getConnection(strDBHost, strDBuserName, strDBuserPass);
            Statement hStatement    = hDBCon.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_UPDATABLE);
            ResultSet hResultSet    = hStatement.executeQuery(strSQLQuery); // Passing in the Query and getting a ResultSet

            // Iterates Each Row Of Data and Appends it
            while(hResultSet.next())
            {
                strOutput.append(hResultSet.getString("Username")); // Appending
                strOutput.append("->");
                strOutput.append(hResultSet.getString("Password")); // Appending
                strOutput.append("<br>");
            }
        }
        catch(Exception E) {
            System.out.println("[Error]: " + E);
        }

        return(strOutput.toString());
    }
}