Java Utililty Methods JDBC MySQL Connection

return getMySQLConnection(hostname, MYSQL_PORT, databaseName, dbuser, dbpasswort);

Class.forName("com.mysql.jdbc.Driver");
String connectionURL = "jdbc:mysql://localhost:3306/test1";
Connection conn = DriverManager.getConnection(connectionURL, userName, password);
return conn;

HashMap<String, HashSet<String>> result = new HashMap<String, HashSet<String>>();
Connection conn;
conn = DriverManager.getConnection(conString);
DatabaseMetaData meta = conn.getMetaData();
ResultSet tables = meta.getTables(null, null, null, null);
while (tables.next()) {
    ResultSet rs;
    String tableName = tables.getString(3);
...

lookupDriver();
return connectAndUseDatabase(dbUser, dbPassword);

Connection con = DriverManager.getConnection(JDBC_URL, "feng", "");
return con;

if (searchReaderConnection == null || searchReaderConnection.isClosed()) {
    searchReaderConnection = DriverManager.getConnection("jdbc:mysql://localhost:3306/ycppquiz", "ycppquiz",
            "ycppquiz");
return searchReaderConnection;

try {
    Class.forName("com.mysql.jdbc.Driver");
    mConn = DriverManager.getConnection("jdbc:mysql://localhost:3306/source_products", "root", "123");
    mStmt = mConn.createStatement();
} catch (Exception e) {
    e.printStackTrace();

Connection con = null;
PreparedStatement preparedStatement = null;
try {
    Class.forName("com.mysql.jdbc.Driver");
    con = DriverManager.getConnection(dbUrl, user, password);
    preparedStatement = con.prepareStatement(addDataQ);
    preparedStatement.setInt(1, tID);
    preparedStatement.setString(2, toolID);
...

try {
    if (mStmt == null || mStmt.isClosed()) {
        openConnection();
    return mStmt.executeQuery(sql);
} catch (SQLException e) {
    e.printStackTrace();
return null;