public static String currencyName1(String ccCode){
        Connection conn = DBase.dbConnection();
        PreparedStatement dbpst;
        String curName ="";
        try{
           String query = "Select CurrencyName FROM "+ccCode+ " where CountryCode = ?";
           dbpst=conn.prepareStatement(query);
           dbpst.setString(1, ccCode);
          
            
            ResultSet rs = dbpst.executeQuery();
            
             while(rs.next()){
                 curName=rs.getString(1);
         
             } 
             dbpst.close();
             conn.close();
        }catch(SQLException e){System.err.println(e);}
        
        return curName;
        
    }