1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46
| public static Vector Renvoie(String requete)
{
Connection conn;
Statement stmt;
ResultSet rs;
String driver = "org.postgresql.Driver";
String url = "jdbc:postgresql://127.0.0.1:2000/oniria";
String envoie;
String erreur = "erreur";
Vector resultat = new Vector();
try
{
envoie=requete;
Class.forName (driver);
conn = DriverManager.getConnection(url,"oniria","artefact");
stmt = conn.createStatement();
rs = stmt.executeQuery(envoie);
while (rs.next())
{
try
{
resultat.addElement(rs.getString(1));
}
catch (NullPointerException e)
{
resultat.addElement(erreur);
}
}
rs.close();
stmt.close();
conn.close();
}
catch (SQLException e)
{
System.out.println("SQLException: " + e.getMessage());
System.out.println("SQLState: " + e.getSQLState());
System.out.println("VendorError: " + e.getErrorCode());
}
catch (ClassNotFoundException e)
{
e.printStackTrace ();
}
return resultat;
} |
Partager