LogIn.class
----------------------------------------------

package adventure;

import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Scanner;


public class LogIn {

	static int userid;
	static int userLocation;
	private static boolean spielstart=false;
	static boolean logIn=false;
	static String query;

	public static void main(String args[]){
		System.out.println("----------------------------------------\n  Welcome to the -Adventure- game\n----------------------------------------\n\n  1 Log in an existing adventurer\n  2 Create a new adventurer\n  3 See who is online\n  4 Exit\n");
		while (spielstart == false){
			System.out.println("\nPlease Select an option:");
			Scanner s = new Scanner(System.in);
			int eingabe = s.nextInt();
				if (eingabe == 1){
					spielstart = true;
					logInProcess();
				}
				else if (eingabe == 2){
					spielstart = true;
					newGame();
				}
				else if (eingabe == 3){
					spielstart = true;
					currentlyOnline();
				}
				else if (eingabe == 4){
					System.out.println("Exiting game");
					System.exit(0);
				}
				else {
					System.out.println("Unknown Option Selected!");
				}
		}
	}

	static void logInProcess(){
		Statement stmt;
		String name;


		System.out.println("\nYou selected \"Log in an exitsting adventurer\"");

		Database.getConnection();

		Scanner s = new Scanner(System.in);
		String eingabe = s.nextLine();



		    try{
		    	stmt = Database.connection.createStatement();
			      ResultSet rs = stmt.executeQuery("SELECT name, userid, location FROM user");
			      while (rs.next()){
			    	  name = rs.getString("name");
			    	  userid = rs.getInt("userid");
			    	  userLocation = rs.getInt("location");
				    	  if (name.equals(eingabe)){
					  			System.out.println("User " + eingabe + " Selected");
					  			getCurrentRoom();
					  	}
			    }
			}
		    catch (Exception e){
		    	System.err.println(e.getClass().getName() + ": " + e.getMessage());
		    	System.exit(0);
		    }
	}

	static void getCurrentRoom(){

    	try{
			Statement stmt = Database.connection.createStatement();
		      ResultSet rs = stmt.executeQuery("SELECT roomname, roomdesc FROM rooms WHERE " + userLocation + "= roomid");

		     while (rs.next()){
		      String roomname = rs.getString("roomname");
	    	  String roomdesc = rs.getString("roomdesc");

	    	  System.out.println("\n" + roomname);
  			  Thread.sleep(1000);
  		  	  System.out.println("\n" + roomdesc);
			  Thread.sleep(1000);
		     }

		     ResultSet rsRoute = stmt.executeQuery("SELECT route_desc FROM route WHERE from_id = " + userLocation);

		     while (rsRoute.next()){
		    	 String route_desc = rsRoute.getString("route_desc");
		    	 System.out.println("\n" + route_desc);
				Thread.sleep(1000);

		     }

		     ResultSet rsNPC = stmt.executeQuery("SELECT npcshortdesc FROM npc WHERE npcroom = " + userLocation);

		     while (rsNPC.next()){
		    	 String npcshortdesc = rsNPC.getString("npcshortdesc");
		    	 System.out.println("\n" + npcshortdesc);
				Thread.sleep(1000);
		     }

		     ResultSet rsItem = stmt.executeQuery("SELECT itemdesc_short FROM item WHERE currentroom = " + userLocation);

		     while (rsItem.next()){
		    	 String itemdesc_short = rsNPC.getString("itemdesc_short");
		    	 System.out.println("\n" + itemdesc_short);
				Thread.sleep(1000);
		     }

		    	move();

    	}catch (Exception e){
		  	System.err.println(e.getClass().getName() + ": " + e.getMessage());
		   	System.exit(0);
    	}

}

	static void move(){

		Statement stmt;

		try {
			stmt = Database.connection.createStatement();
			ResultSet rsDirection = stmt.executeQuery("SELECT direction, to_id FROM route, user WHERE from_id= " + userLocation);

			Scanner s1 = new Scanner(System.in);
			String directionInput = s1.next();

			do{
				int to_id = rsDirection.getInt("to_id");
				String direction = rsDirection.getString("direction");


				if(directionInput.equals(direction)){
					userLocation = to_id;

					getCurrentRoom();
				}

			}while (rsDirection.next());


		} catch (SQLException e) {
		  	System.err.println(e.getClass().getName() + ": " + e.getMessage());
		   	System.exit(0);
		}

	}

	static void newGame(){

		System.out.println("\nYou selected \"Create a new adventurer\"");
	}

	static void currentlyOnline(){

		System.out.println("\nYou selected \"See who is online\"");
	}

}