import java.sql.*;

public class MySQL {
	// jdbc:<datenbanktyp[?]>://<host>:<port>/<datenbankname>
	String url;
	Connection con;
	Statement stmt;
	
	public MySQL() {
		this("localhost:3306", "root", "", "habbo");
	}
	public MySQL(String host, String username, String password, String database) {
		try {
			// JDBC-Treiber registrieren
			Class.forName("com.mysql.jdbc.Driver");
			
			url = "jdbc:mysql://" 
				+ host + "/"
				+ database;
			con = DriverManager.getConnection(
					url,
					username,	// MySQL-Username
					password 	// MySQL-Passwort
				);
			stmt = con.createStatement();
		}
		catch (ClassNotFoundException cnfe) {
			System.out.println("Der JDBC-Treiber konnte nicht gefunden werden.");
		}
		catch (SQLException sqle) {
			System.out.println("Fehler beim Verbinden mit der Datenbank!");
		}
	}
	
	public String dbFirstResult(String field, String query) {
		ResultSet result;
		try {
			result = stmt.executeQuery(query);
			result.first();
			return result.getString(field);
		}
		catch (SQLException sqle) {
			System.out.println("Datenbankfehler!");
			System.out.println("Feld: " + field + "\n"
					+ "Query: " + query
					);
			System.out.println("Fehler:");
			System.err.println(sqle);
		}
		return "";
	}
	public void dbRunQuery(String query) {
		try {
			stmt.execute(query);
		}
		catch (SQLException sqle) {
			System.out.println("Datenbankfehler!");
			System.out.println("Query: " + query);
			System.out.println("Fehler:");
			System.err.println(sqle);
		}
	}
	public boolean dbExists(String query) {
		ResultSet result;
		try {
			result = stmt.executeQuery(query);
			return result.next();
		}
		catch (SQLException sqle) {
			System.out.println("Datenbankfehler!");
			System.out.println("Query: " + query);
			System.out.println("Fehler:");
			System.err.println(sqle);
		}
		return false;
	}
}