From: | andy petrella <andy(dot)petrella(at)gmail(dot)com> |
---|---|
To: | pgsql-jdbc(at)postgresql(dot)org |
Subject: | newbie jdbc3 tiny example |
Date: | 2005-10-18 19:57:48 |
Message-ID: | 7159e12c0510181257v7e4bb7fex@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc |
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)
\**/"""""""\**/"""""""\**/"""""""\**/"""""""\**/
From | Date | Subject | |
---|---|---|---|
Next Message | Kevin Grittner | 2005-10-18 22:12:09 | Re: How to bulk load a schema using JDBC multiple |
Previous Message | Dave Cramer | 2005-10-18 15:31:59 | implementing setObject(n, java array[]) |