Arrays to DB

[Racoon]

Hi! I´m trying to get an array into a db and later on retrieving it.
I´m not sure if serialization is the way to go since I dont know how to do the first one.

************************************************** *****************************************

public void storeMemDB(String state, String cEmail, String cSms) {
try {
Class.forName("com.mysql.jdbc.Driver"); // använder denna databas anslutning
Connection con = DriverManager.getConnection(
"jdbc:mysql://localhost:3306/blabla",
"root", "blabla");
Statement s = con.createStatement();
String sql = "INSERT INTO member (memFname,memSname,memUname,memPass," +
"memEmail,memLocality,memGym,memCell,memWeight,mem Pulse,memFysic,wayOfContact)" +
"VALUES ('" +
this.fnamn + "','" +
this.enamn + "','" +
this.anamn + "','" +
this.losen + "','" +
this.email + "','" +
this.ort + "','" +
this.gym + "','" +
this.nummer + "','" +
this.vikt.add(getWeight()) + "','" +
this.puls.add(getHeartrate()) + "','" +
state + "','" +
this.contact.add(cEmail + cSms) + "')" ;
s.executeUpdate(sql);

}catch (ClassNotFoundException e1) {
System.out.println(e1.toString());
} catch (SQLException e2) {

System.out.println(e2.toString());
} catch (Exception e3) {
// Andra avbrott
System.out.println(e3.toString());
}

}
************************************************** ************************************
How should the db look like? Is it a blob , a varchar...? what?

I´m new to this and would preciate any help what so ever.
TANX a lot.
/Racoon.

[mharrison]

Hi,

you can use serialization. This post on java's forum might be useful:

http://forum.java.sun.com/thread.jspa?threadID=721459&tstart=210

 
import java.io.ByteArrayInputStream;
import java.io.ByteArrayOutputStream;
import java.io.IOException;
import java.io.ObjectInputStream;
import java.io.ObjectOutputStream;
import java.util.Arrays;
 
public class ForumQuestion {
    public static void main( String[] args ) throws ClassNotFoundException, IOException {
        // knock up an array for testing
        int[] array = new int[25];
 
        for( int i = 0; i < array.length; i++ ) {
            array[i] = i;
        }
 
        // SERIALIZING
 
        // convert array something you can use as a BLOB
        ByteArrayOutputStream os = new ByteArrayOutputStream();
        ObjectOutputStream out = new ObjectOutputStream( os );
        out.writeObject( array );
 
        byte[] blob = os.toByteArray();
 
        // store 'blob' in your database
        writeBlob( blob );
 
        // DESERIALIZING
 
        // read the serialized array
        byte[] serialized = readBlob();
 
        ObjectInputStream in = new ObjectInputStream( new ByteArrayInputStream( serialized ) );
 
        int[] myArray = (int[])in.readObject();
 
        System.out.println( Arrays.toString( myArray ) );
    }
 
    // my 'database' here is just a variable, you'll store it in MySQL or whatever
    private static byte[] blob;
 
    private static void writeBlob( byte[] serialized ) {
        blob = serialized;
    }
 
    private static byte[] readBlob() {
        return blob;
    }
}
 
 

[Racoon]

Ok tanx I´ll try that.