MySQL-Tester

/*
 * Web: http://www.cyberdos.de
 * Mail: info@cyberdos.de
 */
package mysqltester;

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

/**
 *
 * @author tim.koch@cyberdos.de
 */
public class MysqlTester {

    public static final String MainDB_Hostname = "jdbc:mysql://10.100.3.5/sql13";
    public static final String MainDB_Username = "sql13";
    public static final String MainDB_Password = "9JMYXzrus1";

    /**
     * @param args the command line arguments
     */
    public static void main(String[] args) {
        loadDrivers();

        Connection admin_conn = Connect(MainDB_Hostname, MainDB_Username, MainDB_Password);
        if(admin_conn == null) {
            System.out.println("Verbindung zur Datenbank *Main_DB* konnte nicht hergestellt werden!");
        } else {
            System.out.println("Verbindung zur Datenbank *Main_DB* wurde hergestellt!");
        }
    }

    private static void loadDrivers() {
        try {
	    System.out.println("* SQL Treiber laden");
      	    Class.forName("org.gjt.mm.mysql.Driver").newInstance();
            System.out.println(Class.forName("org.gjt.mm.mysql.Driver").toString());
            System.out.println(Class.forName("org.gjt.mm.mysql.Driver").newInstance().toString());
        }
        catch (ClassNotFoundException | InstantiationException | IllegalAccessException e) {
            System.err.println("Unable to load driver.");
        }
    }

    /**
     * @param hostname Hostname of MySQL-Server.
     * @param user Username to login to the MysSQL-Server.
     * @param password Password to login to the MysSQL-Server.
     */
    private static Connection Connect(String hostname, String user, String password) {
        Connection conn = null;

        try {
	    conn = DriverManager.getConnection(hostname, user, password);
	    return conn;
        }
        catch (SQLException sqle) {
            System.out.println("SQLException: " + sqle.getMessage());
            System.out.println("SQLState: " + sqle.getSQLState());
            System.out.println("VendorError: " + sqle.getErrorCode());
        }
        return null;
    }

}