Форум программистов [Powered by Invision Power Board]

Код


import java.io.BufferedReader;
import java.io.File;
 
 
import java.io.FileInputStream;
import java.io.FileNotFoundException;
import java.io.FileOutputStream;
import java.io.FileReader;
import java.io.IOException;
import java.io.InputStream;
import java.io.InputStreamReader;
import java.net.URL;
import java.util.ArrayList;
import java.util.Iterator;
import java.util.List;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.ss.usermodel.Cell;
import org.apache.poi.ss.usermodel.Row;
import org.apache.poi.ss.usermodel.Sheet;
import org.apache.poi.ss.usermodel.Workbook;
 
import java.io.FileOutputStream;
import java.io.IOException;
 
import java.io.RandomAccessFile;
 
 
 
public class App12 {
    
public static void main(String[] args) throws FileNotFoundException, IOException   {
    
        String line; 
        String opisanieOFF = "</div>";//
        String opisanie = "\"b-content__body b-user-content\"";//
        String price1 = "\"b-product__price\"";//
        String roa1;
        String roa2;
        String stroka_kateg = "pix123 ";
        String price_start = "price\">";
        String price_stop = "</p>";
        String foto_ON = "b-centered-image b-product__image";
        String foto_start = "href=\"";
        String foto_stop = "jpg\"";
        String jpg = "jpg";
 
        int ZapOpisanie = 0;//
        int ind = 0;
        int whil = 0;//
        int result = 0;
        int ss = 0;
        int row1 = 0;
        int cell1 = 0;
        int start = 0;
        int stop = 0;
 
        
        ArrayList<String> opisArrai = new ArrayList<String>();            
        StringBuilder builder = new StringBuilder();
        
       
        Workbook wb = new  HSSFWorkbook();
        Sheet sheet0 = wb.createSheet("Лист_1");        
        FileOutputStream fos = new FileOutputStream("C:/spisok.XLS ");
        //Row row = sheet0.createRow(row1);
 
        BufferedReader reader1 = new BufferedReader(new FileReader("C:\\Users\\Nout\\Desktop\\xxx.txt"));
        String line1;
        List<String> lines = new ArrayList<String>();
while ((line1 = reader1.readLine()) != null) {
            lines.add(line1);
            Row row = sheet0.createRow(row1);
           // System.out.println(line);
          boolean isContain4 = line1.contains(stroka_kateg);
                if (isContain4 == true){
                  System.out.println(line1);
                  cell1 = 0;                    
                    Cell cell = row.createCell(cell1);
                    cell.setCellValue(line1); 
                    row1++;
                }
                else
                {
          BufferedReader reader = null;
       // try {
            URL site = new URL(line1);
            reader = new BufferedReader(new InputStreamReader(site.openStream()));
            while ((line = reader.readLine()) != null) {
        
        
 
            
 
        
                boolean isContain3 = line.contains(opisanieOFF);
                if (isContain3 == true){
                  ZapOpisanie = 0;
                 // System.out.println(line);
                }
                  
                if (ZapOpisanie == 1){                   
                    
                    opisArrai.add(line);
                    ind++;                
 
                }
                boolean isContain5 = line.contains(opisanie);
                if (isContain5 == true){
                  ZapOpisanie = 1;
                 // System.out.println(line);
                }
                if(ind != 0 & line.contains(opisanieOFF )){
                    
                    builder.append(opisArrai);
                    roa1 = String.valueOf(builder);
                   // System.out.println(roa1);               
                    
                    cell1 = 2;                    
                    Cell cell = row.createCell(cell1);
                    cell.setCellValue(roa1);
                    roa1 = null;                    
                    row1++;
                    ind = 0;
                    
                   
                }
 
 
             boolean isContain1 = line.contains(price1);
                if (isContain1 == true){ 
                    start = line.indexOf( price_start);                    
                    stop = line.indexOf( price_stop,start);                  
                    roa1 = String.valueOf(line.substring(start, stop));
                   // System.out.println(roa1 );
                    
                    cell1 = 1;                    
                    Cell cell = row.createCell(cell1);
                    cell.setCellValue(roa1);
                    roa1 = null;
                    
                    //row1++;
                   
                } 
 
  
              boolean isContain2 = line.contains(foto_ON);
                if (isContain2 == true){
                    start = line.indexOf( foto_start);                    
                    stop = line.indexOf( foto_stop,start);                  
                    roa1 = String.valueOf(line.substring(start, stop));
                    //System.out.println(line );
                     roa1 = roa1.concat(jpg);
                    // System.out.println(roa1 );
                    cell1 = 5;                    
                    Cell cell = row.createCell(cell1);
                    cell.setCellValue(roa1);
                    roa1 = null;
                    
                }    
                
 
                
                
               
                  
                  
                
                
        
                
            
}reader.close();

whil++;
System.out.println(whil);
}
                
}reader1.close();
             
               wb.write(fos);
               fos.close();
 
}
 
}

Код


http://top-store.in.ua/p78484634-schetka-metla-fanatuk.html
http://top-store.in.ua/p78484635-sch...a-fanatik.html
http://top-store.in.ua/p78484636-sch...a-fanatik.html
http://top-store.in.ua/p78484638-sch...a-fanatik.html
http://top-store.in.ua/p78484639-sch...a-fanatik.html
http://top-store.in.ua/p78484641-sch...etla-push.html
http://top-store.in.ua/p78484642-sch...a-fanatik.html
http://top-store.in.ua/p78484644-sch...a-fanatik.html
http://top-store.in.ua/p78484645-sch...-uglovaya.html
http://top-store.in.ua/p78484647-sch...a-fanatik.html
http://top-store.in.ua/p78484648-sch...-uglovaya.html
http://top-store.in.ua/p78484649-met...ka-angled.html