package  project1;

 import  java.sql.Connection;
 import  java.sql.DriverManager;
 import  java.sql.SQLException;


 public   class  Connect {
     final  String DRIVER = "sun.jdbc.odbc.JdbcOdbcDriver";
     final  String DBURL = "jdbc:odbc:db2";
     private   static  Connect instance =  new  Connect();

     private  Connect() {
    }

     public   static  Connect getInstance() {
         return  instance;
    }

     public  Connection getConn() {
         try  {
             Class .forName(DRIVER);
        }  catch  (ClassNotFoundException e) {
            e.printStackTrace();
        }
        Connection con= null ;
         try  {
            con = DriverManager.getConnection(DBURL);
        }  catch  (SQLException e) {
            e.printStackTrace();
        }
         return  con; 
            
                 
        }

    }

 public   class  Connect {
     final  String DRIVER = "sun.jdbc.odbc.JdbcOdbcDriver";
     final  String DBURL = "jdbc:odbc:db2";
     final  String SQLSTMNT = "SELECT employes.НазваниеОтдела, employes.Имя FROM employes;";
     private   static  Connect instance =  new  Connect();

     private  Connect() {
    }

     public   static  Connect getInstance() {
         return  instance;
    }

     public  Connection getConn() {
         try  {
             Class .forName(DRIVER);
        }  catch  (ClassNotFoundException e) {
            e.printStackTrace();
        }
        Connection conn= null ;
         try  {
            conn = DriverManager.getConnection(DBURL);
            Statement stmt = conn.createStatement();
 
            ResultSet rs =  null ;
            rs = stmt.executeQuery(SQLSTMNT);

        }  catch  (SQLException e) {
            e.printStackTrace();
        }
         return  conn; 
            
                 
        }

    }