MySQL - question: "How to save and load (Tree)Maps?"

Question in the thread title ...
How can I do that? Can someone give me an example? I read somewhere that it goes beyond the "BLOB" datatype. But how?
MySQL.java:

Code:java

public class MySQL extends Database {
    String user = "";
    String database = "";
    String password = "";
    String port = "";
    String hostname = "";
    Connection c = null;
 
    public MySQL(String hostname, String portnmbr, String database,
            String username, String password) {
        this.hostname = hostname;
        this.port = portnmbr;
        this.database = database;
        this.user = username;
        this.password = password;
    }
 
    public Connection open() {
        try {
            Class.forName("com.mysql.jdbc.Driver");
            this.c = DriverManager.getConnection("jdbc:mysql://"
                    + this.hostname + ":" + this.port + "/" + this.database,
                    this.user, this.password);
            return c;
        } catch (SQLException e) {
            System.out.println("Could not connect to MySQL server! because: "
                    + e.getMessage());
        } catch (ClassNotFoundException e) {
            System.out.println("JDBC Driver not found!");
        }
        return this.c;
    }
 
    public boolean checkConnection() {
        if (this.c != null) {
            return true;
        }
        return false;
    }
 
    public Connection getConn() {
        return this.c;
    }
 
    public void closeConnection(Connection c) {
        c = null;
    }
}

Database.java:

Code:java

public abstract class Database {
    protected boolean connected;
    protected Connection connection;
    public int lastUpdate;
 
    public Database() {
        this.connected = false;
        this.connection = null;
    }
 
    protected Statements getStatement(String query) {
        String trimmedQuery = query.trim();
        if (trimmedQuery.substring(0, 6).equalsIgnoreCase("SELECT"))
            return Statements.SELECT;
        if (trimmedQuery.substring(0, 6).equalsIgnoreCase("INSERT"))
            return Statements.INSERT;
        if (trimmedQuery.substring(0, 6).equalsIgnoreCase("UPDATE"))
            return Statements.UPDATE;
        if (trimmedQuery.substring(0, 6).equalsIgnoreCase("DELETE"))
            return Statements.DELETE;
        if (trimmedQuery.substring(0, 6).equalsIgnoreCase("CREATE"))
            return Statements.CREATE;
        if (trimmedQuery.substring(0, 5).equalsIgnoreCase("ALTER"))
            return Statements.ALTER;
        if (trimmedQuery.substring(0, 4).equalsIgnoreCase("DROP"))
            return Statements.DROP;
        if (trimmedQuery.substring(0, 8).equalsIgnoreCase("TRUNCATE"))
            return Statements.TRUNCATE;
        if (trimmedQuery.substring(0, 6).equalsIgnoreCase("RENAME"))
            return Statements.RENAME;
        if (trimmedQuery.substring(0, 2).equalsIgnoreCase("DO"))
            return Statements.DO;
        if (trimmedQuery.substring(0, 7).equalsIgnoreCase("REPLACE"))
            return Statements.REPLACE;
        if (trimmedQuery.substring(0, 4).equalsIgnoreCase("LOAD"))
            return Statements.LOAD;
        if (trimmedQuery.substring(0, 7).equalsIgnoreCase("HANDLER"))
            return Statements.HANDLER;
        if (trimmedQuery.substring(0, 4).equalsIgnoreCase("CALL")) {
            return Statements.CALL;
        }
        return Statements.SELECT;
    }
 
    protected static enum Statements {
        SELECT, INSERT, UPDATE, DELETE, DO, REPLACE, LOAD, HANDLER, CALL, CREATE, ALTER, DROP, TRUNCATE, RENAME, START, COMMIT, ROLLBACK, SAVEPOINT, LOCK, UNLOCK, PREPARE, EXECUTE, DEALLOCATE, SET, SHOW, DESCRIBE, EXPLAIN, HELP, USE, ANALYZE, ATTACH, BEGIN, DETACH, END, INDEXED, ON, PRAGMA, REINDEX, RELEASE, VACUUM;
    }
}
 

KingNyuels

 

You should have a method that allows you to perform queries...

 

chris4315
... And how would save a hole TreeMap-Object (huge! Over 1000 entrys with treemaps as values).

KingNyuels

 

*Bumb*