@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);
ColumnPositionMappingStrategy<T> ms = new ColumnPositionMappingStrategy<>(); ms.setErrorLocale(errorLocale); ms.setType(type); mappingStrategy = ms;
fieldMap.setColumnOrderOnWrite(writeOrder); for (Field field : loadFields(getType())) { String fieldLocale, capture, format; .getAnnotation(CsvCustomBindByPosition.class); Class<? extends AbstractBeanField> converter = annotation.converter(); BeanField<T> bean = instantiateCustomConverter(converter); bean.setField(field); required = annotation.required(); format = annotation.format(); CsvConverter converter = determineConverter(field, elementType, fieldLocale, splitConverter); fieldMap.put(annotation.position(), new BeanFieldSplit<T>( field, required, errorLocale, converter, splitOn, format = annotation.format(); CsvConverter converter = determineConverter(field, elementType, fieldLocale, joinConverter); fieldMap.putComplex(annotation.position(), new BeanFieldJoinIntegerIndex<T>( field, required, errorLocale, converter, mapType, capture, format)); capture = annotation.capture(); format = annotation.format(); CsvConverter converter = determineConverter(field, field.getType(), fieldLocale, null);
@Override public void verifyLineLength(int numberOfFields) throws CsvRequiredFieldEmptyException { if (!headerIndex.isEmpty()) { BeanField f; StringBuilder sb = null; for (int i = numberOfFields; i <= headerIndex.findMaxIndex(); i++) { f = findField(i); if (f != null && f.isRequired()) { if (sb == null) { sb = new StringBuilder(ResourceBundle.getBundle(ICSVParser.DEFAULT_BUNDLE_NAME, errorLocale).getString("multiple.required.field.empty")); } sb.append(' '); sb.append(f.getField().getName()); } } if (sb != null) { throw new CsvRequiredFieldEmptyException(type, sb.toString()); } } }
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; }
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);
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
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"; }
new ColumnPositionMappingStrategy(); mappingStrategy.setType(Employee.class); mappingStrategy.setColumnMapping(columns);