Le portail francophone de la géomatique

import java.sql.*;
import javax.swing.*;
import javax.swing.JOptionPane;



public  class ConnPG {

private static Statement stmt;
private static Connection connexion;
private static ResultSet rs;

public ConnPG(String db,int port)
{
Connect(db, port);
}

private static void Connect(String datab,int _port){
      try
      {
           Class.forName("org.postgresql.Driver");
           String url = "jdbc:postgresql://localhost:"+_port+"/"+datab;
           connexion = DriverManager.getConnection(url, "postgres", "141209");
           ((org.postgresql.PGConnection)connexion).addDataType("geometry", "org.postgresql.PGConnection");
           ((org.postgresql.PGConnection)connexion).addDataType("box3d","org.postgis.PGbox3d");
         
      }catch ( SQLException E)
         {
          JOptionPane.showMessageDialog(new JFrame(), E.getMessage() );
          JOptionPane.showMessageDialog(new JFrame(), E.getSQLState() );
          System.out.println("VendorError:  " + E.getErrorCode());
         }
      catch ( ClassNotFoundException E)
         {
            E.printStackTrace();
         }
      catch ( NullPointerException E)
         {
          JOptionPane.showMessageDialog(new JFrame(),E.toString());
         }
                          }//fin connect()

public static void setQuery(String query){
    
try {
/*Statement*/     stmt = connexion.createStatement();
         rs = stmt.executeQuery(query);
    }catch (SQLException E){
        JOptionPane.showMessageDialog(new JFrame(),  E.getMessage());
        JOptionPane.showMessageDialog(new JFrame(), E.getSQLState());
System.out.println("VendorError:  " + E.getErrorCode());
                           }//end catch
                                         }
public static void setBolQuery(String query){
    
    try {
         stmt = connexion.createStatement();
         boolean    isexe = stmt.execute(query);
         if(!isexe) JOptionPane.showMessageDialog(new JFrame(),"Données enregistrées!");
         else JOptionPane.showMessageDialog(new JFrame(),"Données non enregistrées!","Erreure",JOptionPane.ERROR_MESSAGE); 
        }catch (SQLException E){
            JOptionPane.showMessageDialog(new JFrame(),  E.getMessage());
            JOptionPane.showMessageDialog(new JFrame(), E.getSQLState());
    System.out.println("VendorError:  " + E.getErrorCode());
                               }//end catch
                                             }

public static ResultSet getResultSet(){
                   
    return rs;
                                      }//fin de la classe getResultSet()
public static void disConnectDB(){
    try{stmt.close();
     try {
            connexion.close();
         }
        catch(SQLException e)      {
            JOptionPane.showMessageDialog(new JFrame(),"Impossible de fermer la connexion");
                                   }
    
         }catch(SQLException sqle){JOptionPane.showMessageDialog(new JFrame(),"Erreur liée au base de données(fermeture de Statement)!");}
    
                
                            }//fin de la methode de disConnectDB()
}