package FitnessMafia.Stromba;

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

public class DBcheck {
public static void main(String[] args) throws SQLException {
	BackToSelenium dbverify = new BackToSelenium();
		System.out.println("-------- Oracle JDBC Connection Testing ------");

		try {

			Class.forName("oracle.jdbc.driver.OracleDriver");

		} catch (ClassNotFoundException e) {

			System.out.println("Where is your Oracle JDBC Driver?");
			e.printStackTrace();
			return;

		}

		System.out.println("Oracle JDBC Driver Registered!");

		Connection connection = null;

		try {
			connection = DriverManager.getConnection(
					"jdbc:oracle:thin:@//10.145.40.65:1521/poker.world", "*****",
					"*****");

		} catch (SQLException e) {

			System.out.println("Connection Failed! Check output console");
			e.printStackTrace();
			return;

		}

		if (connection != null) {
			System.out.println("You made it, take control your database now!");
		} else {
			System.out.println("Failed to make connection!");
		}
		System.out.println("" );
		Statement sqlStatement = connection.createStatement();
        String readRecordSQL = "SELECT name,status from CASINO.POKERTOURNAMENTS WHERE NAME = " + "'" + dbverify.tournamentName + "'" + " AND STATUS='Register'";
        ResultSet myResultSet = sqlStatement.executeQuery(readRecordSQL);
        while (myResultSet.next()) {
        	String name=myResultSet.getString("name");
        	String status =myResultSet.getString("status");
        	System.out.println("Tournament name is : " + name);
        	System.out.println("Tournament status is : " + status);
        	if(dbverify.tournamentName.equals(name)){
        		System.out.println("MASHINA");
        	}else{
        		System.out.println("k0r");
        	}
}


}
}