Java datenbank

package wowgmtool;

/**
 *
 * @author Cybertronnix
 */
import abiturklassen.listenklassen.List;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.Statement;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;

public class Connect {
  Connection conn = null;
  String query;//SQL-Abfrage
  int attributAnzahl;//Anzahl der Spalten
  int datensatzAnzahl;//Anzahl der Zeilen
  List attributNamen;//Liste der Spaltenueberschriften
  List attributWerte;//Achtung: Liste von Listen, die die Attributwerte
                       //         fuer jeweils einen Datensatz enthalten.
    public static void main(String[] args) {
        // TODO code application logic here
        try {
            // The newInstance() call is a work around for some
            // broken Java implementations

            Class.forName("com.mysql.jdbc.Driver").newInstance();
        } 
        catch (Exception ex) {
            // handle the error
        }
    }
    public void connect(){
      try {
        conn =DriverManager.getConnection("jdbc:mysql://localhost/test?" +
                                   "user=root" + "password=");


        attributAnzahl=0;
        datensatzAnzahl=0;
        attributNamen=new List();
        attributWerte=new List();
        query = "SELECT * FROM world;";
        } 
      catch (SQLException ex) {

            System.out.println("SQLException: " + ex.getMessage());
            System.out.println("SQLState: " + ex.getSQLState());
            System.out.println("VendorError: " + ex.getErrorCode());
        }
    
    } 
    public void setzeSQLAbfrage(String sql)
    {
        query=sql;
    }

    public ResultSet ausfuehren(){
    // assume that conn is an already created JDBC connection (see previous examples)

        Statement stmt = null;
        ResultSet rs = null;

        try {
            stmt = conn.createStatement();
            rs = stmt.executeQuery("SELECT* FROM world");

            // or alternatively, if you don't know ahead of time that
            // the query will be a SELECT...

            if (stmt.execute("SELECT* FROM world")) {
                rs = stmt.getResultSet();
            }

            // Now do something with the ResultSet ....
        }
        catch (SQLException ex){
            // handle any errors
            System.out.println("SQLException: " + ex.getMessage());
            System.out.println("SQLState: " + ex.getSQLState());
            System.out.println("VendorError: " + ex.getErrorCode());
        }
        finally {
            // it is a good idea to release
            // resources in a finally{} block
            // in reverse-order of their creation
            // if they are no-longer needed

            if (rs != null) {
                try {
                    rs.close();
            } 
                catch (SQLException sqlEx) { } // ignore

                    rs = null;
                }

            if (stmt != null) {
                try {
                    stmt.close();
            } 
                catch (SQLException sqlEx) { } // ignore

                stmt = null;
            }
    }    
    return rs;
    }
    public void einfuegen(){
        
    }
    public void loeschen(){
        
    }  
}

String dbase = "world";
String dbuser = "root";
String dbpass = "";
    public static void main(String[] args) {
        // TODO code application logic here
        try {
            // The newInstance() call is a work around for some
            // broken Java implementations

            Class.forName("com.mysql.jdbc.Driver").newInstance();
        } 
        catch (Exception ex) {
            // handle the error
        }
    }
    public void connect(){
      try {
        //conn =DriverManager.getConnection("jdbc:mysql://127.0.0.1:3308/test?" + "user=root&password=pserver");
        String ConnString;
        ConnString = "jdbc:mysql://localhost:3308/"+dbase+"?user="+dbuser+"&password="+dbpass;
        conn = DriverManager.getConnection(ConnString);
                System.out.println("Connection to database successful!");