Bonjour tt le monde
j'ai etabli une connection base de donné avec java et j'ai importer les donné, mais je mtn utiliser un tableau ou un arraylist pour les manupiler ajouter suprimer...

je suis debutant en java et je c pas comment remplir une arraylist a partir d'une base de donné!!!
merci de votre aide voici mon code java avec bdd firebird sous eclipse:


public class FBConnect {

public static void main(String[] args) throws SQLException {

String databaseURL = "jdbc:firebirdsql:localhost/3050:C:/Database/ressource.FDB";
String user = "sysdba";
String password = "masterkey";
String driverName = "org.firebirdsql.jdbc.FBDriver";
java.sql.Driver d = null;
java.sql.Connection c = null;
java.sql.Statement s = null;
java.sql.ResultSet rs = null;

try {
Class.forName ("org.firebirdsql.jdbc.FBDriver");
}
catch (java.lang.ClassNotFoundException e) {
System.out.println ("Firebird JCA-JDBC driver not found in class path");
System.out.println (e.getMessage ());
return;
}

try {
d = java.sql.DriverManager.getDriver (databaseURL);
System.out.println ("Firebird JCA-JDBC driver version " +
d.getMajorVersion () +
"." +
d.getMinorVersion () +
" registered with driver manager.");
}
catch (java.sql.SQLException e) {
System.out.println ("Unable to find Firebird JCA-JDBC driver among the registered drivers.");
return;
}

try {
c = java.sql.DriverManager.getConnection (databaseURL, user, password);
System.out.println ("Connection established.");
}
catch (java.sql.SQLException e) {
e.printStackTrace();
System.out.println ("Unable to establish a connection through the driver manager.");
}

s = c.createStatement();
if(s.execute("select * from capacite")) {
printResultSet(System.out, s.getResultSet(), "Query Result");
} else {
System.out.println(" executed successfully");
}
}

private static void printResultSet(PrintStream p, ResultSet rs,String title)throws SQLException {
if(rs != null) {
ResultSetMetaData metaData = rs.getMetaData();
int cols = metaData.getColumnCount();
p.println("\n--------------\n" + title + "\n--------------------------------"); for(int i = 1;i <= cols;i++) {
p.print(metaData.getColumnLabel(i) + "\t");
}
p.println("\n--------------------------------------------------------------------------------------");
int count = 0;
while(rs.next()) {
for(int i = 1;i <= cols;i++) {
p.print(rs.getString(i) + "\t");
}
p.println("\n-----------------------------------------------------------------------------------");
count++;
}
p.println("----------\n Rows:" + count );

/*ArrayList []List = new ArrayList[count];
for(int i=0;i<count;i++){
List[i]=new ArrayList();
List[0].add("" );
System.out.println("la valeur est :"+List[i].get()); }*/
}

}
}

Configuration: Windows XP
Internet Explorer 7.0