Thread: 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.petrella@gmail.com
] <licencié en math, info>
] dea S.I.G. (2005-2006)
\**/"""""""\**/"""""""\**/"""""""\**/"""""""\**/
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.petrella@gmail.com
] <licencié en math, info>
] dea S.I.G. (2005-2006)
\**/"""""""\**/"""""""\**/"""""""\**/"""""""\**/
It seems ok to me. The idea with JDBC is that you don't have to deal
with implementation specific classes, such as PGConnection,
Jdbc3Connection, etc. It's all done on the background. If you are
doing client side prepared statements, your code looks OK. Prepared
Statements are a JDBC feature, common to all JDBC implementations, so
you don't need any PG specific code. If you are trying to do Server
side prepared statements, that's something else. But if you're new to
this, stick to JDBC prepared statements, and keep your code portable
that way.
On 10/18/05, andy petrella <andy.petrella@gmail.com> wrote:
> 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.petrella@gmail.com
> ] <licencié en math, info>
> ] dea S.I.G. (2005-2006)
> \**/"""""""\**/"""""""\**/"""""""\**/"""""""\**/