newbie jdbc3 tiny example

hi everyboy,

I'm newbie with the jdbc and I wish to know how must be driven the
connection to a first preparedstatement using jdbc3 (an pg 8.0.3).

My first throw (suspicious) was

[...]

private Connection db;
private Statement sql;
private DatabaseMetaData dbmd;

private PreparedStatement addDVD = null;

[...]
String hostname = "localhost:5432";
String database = "XXX";
String user ="abcdefg";
String psswd ="_______";

try {
Class.forName("org.postgresql.Driver"); //load the driver
db = DriverManager.getConnection("jdbc:postgresql://"+hostname+"/"+database+"?"+"user="+username+"&password="+password);
//connect to the db
dbmd = db.getMetaData(); //get MetaData to confirm connection
}catch (ClassNotFoundException e){
JOptionPane.showMessageDialog(null, e.getMessage(), "Error Driver pas
trouvé", JOptionPane.ERROR_MESSAGE);
}catch (SQLException e){
JOptionPane.showMessageDialog(null, e.getMessage(), "Error initialisation
connection", JOptionPane.ERROR_MESSAGE);
}

[...]

public PreparedStatement preparedAddDVD(){
try{
String insertion =
"INSERT INTO FICHES.DVD" +
"id," +
"titre_o," +
"titre_f," +
"affiche," +
"duree," +
"genre," +
"resume," +
"visites," +
"cote," +
"imdb," +
"directeurs," +
"scenaristes," +
"acteurs," +
"possession_id," +
"possesseur," +
"acquis," +
"achete," +
"classement" +
"VALUES" +
"(" +
"default," +
"?," + //titreo 1
"?," + //sortie 2
"?," + //fr 3
"?," + //affiche 4
"?," + //duree 5
"?," + //genre 6
"resume," + //TODO null => allocine
"1," + //1 visites a faire après
"0," + //0 cote
"?," + //imdb 7
"?," + //dir 8
"?," + //sce 9
"?," + //act 10
"default," +
"current_user," +
"current_timestamp," +
"?," + //acheté 11
"?," + //classement 12
")" +
";";
addDVD = db.prepareStatement(insertion);
return addDVD;
}catch (SQLException e){
JOptionPane.showMessageDialog(null, e.getMessage(), "Error prepare addDVD",
JOptionPane.ERROR_MESSAGE);
return null;
}

[...]

And, what about the org.postgresql.jdbc3.Jdbc3Connection, ...
the org.postgresql.PGConnection ...

If it's little too long to explain someone can give me some links ?

tks.

--
/**\_____/**\_____/**\_____/**\_____/**\
] Signature :
] Andy Petrella
] Rue dessous l'église, 17
] 4450 Slins
] mail: andy(dot)petrella(at)gmail(dot)com
] <licencié en math, info>
] dea S.I.G. (2005-2006)
\**/"""""""\**/"""""""\**/"""""""\**/"""""""\**/