public class Connec {
    static  String a;
    private static final String URL = "jdbc:oracle:thin:@localhost:1521:xe";
    private static final String LOGIN = "system";
    private static final String PASSWORD = "mahmoud";
    private static final String DBNAME = "societe";
    public static Connection getConenction(){
        Connection c = null;
        try {
            Class.forName("oracle.jdbc.driver.OracleDriver");
        } catch (ClassNotFoundException e) {
            e.printStackTrace();
        }
        try {
            c = (Connection) DriverManager.getConnection(URL, LOGIN, PASSWORD);
            //c = DriverManager.getConnection(URL+DBNAME); // connexion sans utilisateur et mot de passe
        } catch (SQLException e) {
            e.printStackTrace();
        }
        System.out.println("!connection successful");
        return c;
    }
}

@Override
            public void onClick(View v) {
                // TODO Auto-generated method stub


                 Connection con=(Connection) Connec.getConenction();
                    Statement statement=null;
                    String req="select * from PFE.EMPLOYE WHERE ID_EMPLOYE=3";
                    try {
                        statement=con.createStatement();
                        ResultSet res=statement.executeQuery(req);
                        while(res.next()){
                        a=res.getString("TEL");
                        Toast.makeText(MainActivity.this,
                                a, Toast.LENGTH_SHORT).show();
                        //INSERT INTO EMPLOYE (TEL,ADRESSE,SITUATION_FAM) VALUES ('19658574','uhuve cuebu','Marie');


                        }

                    }catch(SQLException e1){
                            e1.printStackTrace();
                    }


            }


        });
}