Package au.com.bytecode.opencsv

Examples of au.com.bytecode.opencsv.CSVReader


    System.out.println("-----Original response body------");
    System.out.println(httpResponse.body);
   
    System.out.println("-------Parsing with CSVReader------");
    CSVReader reader = new CSVReader(new StringReader(httpResponse.body));
      String[] line;
      while ((line = reader.readNext()) != null) {
        for (String col : line) {
          System.out.println("\t" + col);
        }
        System.out.println();
      }   
View Full Code Here


    public void replaceContent( InputStream in, Long length ) {
        log.debug( "replaceContent");
        try {
            vehicleDao.deleteAll();
            InputStreamReader r = new InputStreamReader( in );
            CSVReader reader = new CSVReader( r );
            String[] line;
            int cnt = 0;
            while( ( line = reader.readNext() ) != null ) {
                if( line.length > 0 ) {
                    Vehicle v = new Vehicle();
                    log.debug( "make: " + line[0]);
                    v.setVehicleMake( line[0]);
                    v.setVehicleModel( line[1]);
View Full Code Here

   * @throws IOException if there was an exception reading the file
   */
  public static List<String[]> getCsvDataArray(Reader csvReader, boolean headerPresent)
      throws IOException {
    final List<String[]> result = new ArrayList<String[]>();
    new CsvReader(new CSVReader(csvReader), headerPresent).processReader(
        new CsvReader.CsvWorker() {
          public void processLine(String[] headers, String[] line, int lineNumber) {
            result.add(line);
          }
        });
View Full Code Here

     * @throws IOException if the CSV file cannot be read
     */
    private void createCsvReader() throws IOException {
      lineNumber = 1;
      if (reader == null) {
        reader = new CSVReader(new FileReader(fileName));
      }
      if (headerPresent) {
        header = reader.readNext();
        lineNumber++;
      }
View Full Code Here

     *
     * @param inputStreamReader the reader to read the file
     * @throws ImportException if an error occurs
     */
    private void readCSVFile(final InputStreamReader inputStreamReader) throws ImportException {
        CSVReader reader = null;
        List<String[]> content;
        try {
            reader = new CSVReader(inputStreamReader);
            // read all content from CSV file
            content = reader.readAll();
            if (content.isEmpty()) {
                // nothing to import
                throw new ImportException(ResourceLoader.getMessage(MessageId.E003.getMessageKey()));
            }
            fileContent.addAll(content);
        } catch (final IOException ioe) {
            throw new ImportException(ResourceLoader.getMessage(MessageId.E004.getMessageKey()), ioe);
        } finally {
            if (reader != null) {
                try {
                    reader.close();
                } catch (final IOException e) {
                    // do nothing
                }
            }
        }
View Full Code Here

  }

  private void loadSystemMessages() {
    systemMessages = new HashMap<Integer, String>(2500,0.9f);
    try {
      CSVReader reader = new CSVReader(new InputStreamReader(
          CSVDatastoreDAO.class.getResourceAsStream("/db/systemmessages.csv")), 1/*skip header*/, new CSVParser('\t','"','\\'));
     
      String[] line = reader.readNext();
     
      while (line != null) {
        if (line.length > 1) {
          systemMessages.put(Integer.valueOf(line[0]), line[1]);
        }
        line = reader.readNext();
      }
    } catch (Exception e) {
      logger.log(Level.SEVERE, "Failed to load /db/systemmessages.csv", e);
   
  }
View Full Code Here

 
  @Override
  public BaseUsable[] loadAllActions(){
    BaseUsable[] ret = new BaseUsable[0];
    try {
      CSVReader reader = new CSVReader(new InputStreamReader(
          CSVDatastoreDAO.class.getResourceAsStream("/db/actions.csv")), 1/*skip header*/, new CSVParser('\t','"','\\'));
      ret = ActionResultBuilder.buildActions(reader);
    } catch (Exception e) {
      logger.log(Level.SEVERE, "Failed to load /db/actions.csv", e);
    }
View Full Code Here

   * Load npc configuration from csv file npc.csv
   */
  private void loadNPCs() {
    npcCache = new HashMap<Integer, CSVDatastoreDAO.CSVNpc>();
    try {
      CSVReader reader = new CSVReader(new InputStreamReader(
          CSVDatastoreDAO.class.getResourceAsStream("/db/npc.csv")), 1/*skip header*/, new CSVParser('\t','"','\\'));
     
      String[] line = reader.readNext();
      while (line != null) {
        if (line.length > 2) {
          CSVNpc n = new CSVNpc();
          n.id = Integer.valueOf(line[0]);
          n.idTemplate = Integer.valueOf(line[1]);
          n.name = line[2];
          if (line.length > 3)
            n.gamemodel = line[3];

          npcCache.put(n.idTemplate, n);
        }
        line = reader.readNext();
      }
    } catch (Exception e) {
      logger.log(Level.SEVERE, "Failed to load /db/npc.csv", e);
    }   
  }
View Full Code Here

   * Load item configuration from csv file items.csv
   */
  private void loadItems() {
    itemCache = new HashMap<Integer, CSVDatastoreDAO.CSVItem>();
    try {
      CSVReader reader = new CSVReader(new InputStreamReader(
          CSVDatastoreDAO.class.getResourceAsStream("/db/items.csv")), 1/*skip header*/, new CSVParser('\t','"','\\'));
     
      String[] line = reader.readNext();
      while (line != null) {
        if (line.length > 2) {
          CSVItem n = new CSVItem();
          n.id = Integer.valueOf(line[0]);
          n.type = line[1];
          n.descriptionShort = line[2];

          itemCache.put(n.id, n);
        }
        line = reader.readNext();
      }
    } catch (Exception e) {
      logger.log(Level.SEVERE, "Failed to load /db/items.csv", e);
    }   
  }
View Full Code Here

    return dataBean;
  }

  public static List<ComputerBean> queryComputerBean() throws IOException {
    File csv = new File(Executions.getCurrent().getDesktop().getWebApp().getRealPath("/WEB-INF/xls/demo/data.csv"));
    CSVReader reader = new CSVReader(new FileReader(csv));
    List<ComputerBean> data = new ArrayList<ComputerBean>();
    String[] nextLine;
      while ((nextLine = reader.readNext()) != null) {
        ComputerBean computerBean = new ComputerBean();
        computerBean.setId(nextLine[0]);
        computerBean.setProduct(nextLine[1]);
        computerBean.setBrand(nextLine[2]);
        computerBean.setModel(nextLine[3]);
View Full Code Here

TOP

Related Classes of au.com.bytecode.opencsv.CSVReader

Copyright © 2018 www.massapicom. All rights reserved.
All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.