public class PostgresConnect { String url; String user; String pass; Connection con; Statement stmt; ResultSet res; public PostgresConnect(String u, String util, String mot) { url=u; user=util; pass=mot; } public boolean connect() { try { Class.forName("org.postgresql.Driver"); System.out.println("Drivers charges"); this.con = DriverManager.getConnection(url,user,pass); System.out.println("Connection etablie: "+con); return true; } catch(ClassNotFoundException e){System.err.println("Chargement drivers echoue\n"+e);return false;} catch(SQLException evt) { System.err.println("==>SQL Exception :\n"); while(evt!=null) { System.out.println("Message: "+ evt.getMessage()); System.out.println("SQLState: "+ evt.getSQLState()); System.out.println("ErrorCode: "+ evt.getErrorCode()); evt = evt.getNextException(); System.out.println(""); } return false; } } public void close() { try { con.close(); System.out.println("Connection fermee"); } catch(SQLException evt){System.err.println("Url de connection non valide\n"+evt);} } public boolean reqSend(String req) { try { this.stmt = con.createStatement(); this.res = stmt.executeQuery(req); return true; } catch(SQLException evt){System.err.println("Url de connection non valide\n"+evt);return false;} } }
public class DataConnect { public String entete = "jdbc:postgresql:"; public String user; public String pass; public String serveur; public String base; public String url; public void setParam(String a,String b,String c,String d) { this.user=a; this.pass=b; this.serveur=c; this.base=d; } public void fabUrl() { String inter = entete.concat(serveur); this.url = inter.concat(base); } public void setEntete(String a) { entete=a; }