@Override public String[] generateHeader(T bean) throws CsvRequiredFieldEmptyException { super.setColumnMapping(new String[FieldUtils.getAllFields(bean.getClass()).length]); final int numColumns = findMaxFieldIndex(); if (!isAnnotationDriven() || numColumns == -1) { return super.generateHeader(bean); } String[] header = new String[numColumns + 1]; BeanField<T> beanField; for (int i = 0; i <= numColumns; i++) { beanField = findField(i); String columnHeaderName = extractHeaderName(beanField); header[i] = columnHeaderName; } return header; }
ColumnPositionMappingStrategy strat = new ColumnPositionMappingStrategy(); strat.setType(YourOrderBean.class); String[] columns = new String[] {"name", "orderNumber", "id"}; // the fields to bind do in your JavaBean strat.setColumnMapping(columns); CsvToBean csv = new CsvToBean(); List list = csv.parse(strat, yourReader);
public String importCSV(@RequestParam("file") MultipartFile file, HttpServletRequest req) throws IOException { CsvToBean csv = new CsvToBean(); CSVReader reader = new CSVReader(new InputStreamReader( file.getInputStream()), ',', '\"', 1); ColumnPositionMappingStrategy maping = new ColumnPositionMappingStrategy(); maping.setType(tbBank.class); String[] column = { "bankid", "bankname", "bankbranch" }; maping.setColumnMapping(column); List banklist = csv.parse(maping, reader); for (Object obj : banklist) { tbBank bank = (tbBank) obj; projectservice.insertBank(bank); } return "redirect:/bankview"; }
ColumnPositionMappingStrategy strat = new ColumnPositionMappingStrategy(); strat.setType(YourOrderBean.class); String[] columns = new String[] {"name", "orderNumber", "id"}; // the fields to bind do in your JavaBean strat.setColumnMapping(columns); CsvToBean csv = new CsvToBean(); List list = csv.parse(strat, yourReader);
CSVReader reader = new CSVReader(new FileReader("C:/COSC210/Assignment#7/parts.txt")); ColumnPositionMappingStrategy strat = new ColumnPositionMappingStrategy(); strat.setType(MyNewBean.class); String[] columns = new String[] {"numParts", "partNumber", "description", "price", "quantity", "city"}; // the fields to bind do in your JavaBean strat.setColumnMapping(columns); CsvToBean csv = new CsvToBean(); List list = csv.parse(strat, yourReader);
CSVReader reader = new CSVReader(new FileReader("yourfile.csv")); ColumnPositionMappingStrategy strat = new ColumnPositionMappingStrategy(); strat.setType(Person.class); // the fields to bind do in your JavaBean String[] columns = new String[] {"name", "age"}; strat.setColumnMapping(columns); CsvToBean csv = new CsvToBean(); List list = csv.parse(strat, reader); // the people
ColumnPositionMappingStrategy strat = new ColumnPositionMappingStrategy(); strat.setType(YourOrderBean.class); String[] columns = new String[] {"name", "orderNumber", "id"}; // the fields to bind do in your JavaBean strat.setColumnMapping(columns); CsvToBean csv = new CsvToBean(); List list = csv.parse(strat, yourReader);
ColumnPositionMappingStrategy strat = new ColumnPositionMappingStrategy(); strat.setType(YourOrderBean.class); String[] columns = new String[] {"name", "orderNumber", "id"}; // the fields to bind do in your JavaBean strat.setColumnMapping(columns); CsvToBean csv = new CsvToBean(); List list = csv.parse(strat, yourReader);
ColumnPositionMappingStrategy strat = new ColumnPositionMappingStrategy(); strat.setType(YourOrderBean.class); String[] columns = new String[] {"name", "orderNumber", "id"}; // the fields to bind do in your JavaBean strat.setColumnMapping(columns); CsvToBean csv = new CsvToBean(); List list = csv.parse(strat, yourReader);
@Override public String[] generateHeader(T bean) throws CsvRequiredFieldEmptyException { super.setColumnMapping(new String[FieldUtils.getAllFields(bean.getClass()).length]); final int numColumns = findMaxFieldIndex(); if (!isAnnotationDriven() || numColumns == -1) { return super.generateHeader(bean); } String[] header = new String[numColumns + 1]; BeanField<T> beanField; for (int i = 0; i <= numColumns; i++) { beanField = findField(i); String columnHeaderName = extractHeaderName(beanField); header[i] = columnHeaderName; } return header; }
mappingStrategy.setColumnMapping(columns);