DatabasServer- java - hur du komunicerar med DB

ppackage musicdb;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.logging.Level;
import java.util.logging.Logger;

/**
*
* @author gustafsp
*/
public class DatabasServer {

final static String server = "localhost";
final static int port = 3306;
final static String login = "root";
final static String password = "mysql";
final static String databas = "music";
private static Connection con;

public static Connection connect() {
try {
Class.forName("com.mysql.jdbc.Driver");
} catch (ClassNotFoundException ex) {
System.out.println("MYSQL driver missing?");
}
//Define URL of database server for
// database named JunkDB on the localhost
// with the default port number 3306.
String url = "jdbc:mysql://" + DatabasServer.server + ":" + DatabasServer.port;
try {
//Get a connection to the database for a
// user named auser with the password
// drowssap, which is password spelled
// backwards.
con = DriverManager.getConnection(
url, DatabasServer.login, DatabasServer.password);
return con;
} catch (SQLException ex) {
System.out.println("Login Fail: password ok?");
}
return null;
}

public static ResultSet query(String sql) {
try {
if (con == null) {
con = DatabasServer.connect();
}
Statement stmt = con.createStatement();
if (stmt.execute(sql)) {
return stmt.getResultSet();
}
} catch (SQLException ex) {
Logger.getLogger(DatabasServer.class.getName()).log(Level.SEVERE, null, ex);
}
return null;
}

public static String[] fetchArray(ResultSet result) {
try {
String[] array = new String[result.getMetaData().getColumnCount()];
if (result.next()) {
for (int i = 1; i <= result.getMetaData().getColumnCount(); i++) {
                    array[i - 1] = result.getString(i);
                }
                return array;
            }
            
        } catch (SQLException ex) {
            Logger.getLogger(DatabasServer.class.getName()).log(Level.SEVERE, null, ex);
        }

    
    return null; //om fel eller inget värde
    }



}