List of usage examples for org.apache.commons.csv CSVRecord get
public String get(final String name)
From source file:org.zaproxy.zap.extension.multiFuzz.impl.http.HttpFuzzerContentPanel.java
@Override public void loadRecords(File f) { try (CSVParser parser = new CSVParser(new FileReader(f), CSVFormat.DEFAULT);) { boolean header = true; for (CSVRecord rec : parser) { if (!header) { String name = rec.get(0); String custom = rec.get(1); HttpFuzzRequestRecord.State s; if (rec.get(2).equals(STATE_SUCCESSFUL_LABEL)) { s = HttpFuzzRequestRecord.State.SUCCESSFUL; } else if (rec.get(2).equals(STATE_REFLECTED_LABEL)) { s = HttpFuzzRequestRecord.State.REFLECTED; } else if (rec.get(2).equals(STATE_ANTI_CSRF_TOKEN_REQUEST_LABEL)) { s = HttpFuzzRequestRecord.State.ANTI_CRSF_TOKEN; } else if (rec.get(2).equals(STATE_ERROR_LABEL)) { s = HttpFuzzRequestRecord.State.ERROR; } else { s = HttpFuzzRequestRecord.State.CUSTOM; }/*from w w w . j a v a 2 s.c o m*/ int l = Integer.parseInt(rec.get(3)); ArrayList<String> pay = new ArrayList<>(); if (l == 0) { l++; } else { for (int i = 4; i < l + 4; i++) { pay.add(rec.get(i).substring(1, rec.get(i).length() - 1)); } } HttpMessage m = new HttpMessage(); m.setRequestHeader(rec.get(l + 4)); m.setRequestBody(rec.get(l + 5)); m.setResponseHeader(rec.get(l + 6)); m.setResponseBody(rec.get(l + 7)); m.setTimeElapsedMillis(Integer.parseInt(rec.get(l + 8))); addFuzzResult(name, custom, s, pay, m); } else { header = false; } } } catch (IOException e) { logger.debug(e.getMessage()); JOptionPane.showMessageDialog(View.getSingleton().getMainFrame(), Constant.messages.getString("fuzz.http.csv.readError")); } }
From source file:otn.mobile.bl.TrackServicesHandler.java
public OtnServiceTrackResponse addTracks(OtnServiceTrackRequest request) { //*********************** Variables *************************** OtnServiceTrackResponse response = new OtnServiceTrackResponse(); User users;/*from ww w . j a v a2s . c o m*/ TransportType transport_type = null; Weather weather; WeatherType weather_type; Apps app = null; Source source = null; Track track = new Track(); Track subTracks; TrackRating track_rating; TrackRatingType track_rating_type; ArrayList<OtnServiceSubTracksResponse> trackList = new ArrayList<OtnServiceSubTracksResponse>(); ArrayList<OtnServiceWeatherRatings> weatherListparams = null; ArrayList<OtnServiceGeometryPoints> geometryPointsListparams = null; byte[] trackFileCsv = null; //************************* Action **************************** System.out.println("------------Start---------------"); try { //**********************find user***************************** users = em.find(User.class, request.getUserId()); if (users != null) { System.out.println("====================================="); System.out.println("user id " + users.getUserId()); } else { System.out.println("====================================="); System.out.println("user not found"); em.getTransaction().begin(); users = new User(); users.setUserId(request.getUserId()); em.persist(users); em.flush(); em.getTransaction().commit(); em.clear(); System.out.println("user created"); } //***********************find transportID****************************** if (request.getTransportId() != 0) { transport_type = em.find(TransportType.class, request.getTransportId()); if (transport_type != null) { System.out.println("====================================="); System.out.println("transport id " + transport_type.getTransportTypeId()); track.setTransportTypeId(transport_type); } else { response.setMessage("transport type id does not exist"); response.setResponseCode(1); return response; } } //***********************find weatherID****************************** // if (request.getWeatherId() != 0) { // weather = em.find(WeatherType.class, request.getWeatherId()); // // if (weather != null) { // System.out.println("====================================="); // System.out.println("weather id " + weather.getWeatherId()); // // } else { // response.setMessage("weather condition id does not exist"); // response.setResponseCode(1); // return response; // } // } //***********************find app name****************************** if (request.getAppId() != 0) { app = em.find(Apps.class, request.getAppId()); if (app != null) { System.out.println("====================================="); System.out.println("app id " + app.getName()); track.setAppId(app); } else { response.setMessage("application does not exist"); response.setResponseCode(1); return response; } } //***********************find sourceId****************************** if (request.getSourceId() != 0) { source = em.find(Source.class, request.getSourceId()); if (source != null) { System.out.println("====================================="); System.out.println("source id " + source.getName()); track.setRouteSourceId(source); } else { response.setMessage("source type id does not exist"); response.setResponseCode(1); return response; } } //***************Create track record**************************** em.getTransaction().begin(); if (request.getName() != null) { track.setName(request.getName()); } else { track.setName(""); } track.setDescription(request.getDescription()); if (request.getPicture() != null) { track.setPicture(request.getPicture()); } track.setDistance(request.getDistance()); track.setDuration(request.getDuration()); track.setSpeed(request.getSpeed()); track.setElevation(request.getElevation()); if (request.getTrackFileCsv() != null) { // String csvFile = new String(request.getTrackFileCsv()); trackFileCsv = Base64.encodeBase64(request.getTrackFileCsv()); track.setTrackFileCsv(trackFileCsv); } track.setRouteKlm(request.getRoute_kml()); track.setLatStart(request.getLat_start()); track.setLongStart(request.getLon_start()); track.setLatEnd(request.getLat_end()); track.setLongEnd(request.getLon_end()); track.setCreationDate(new Date()); track.setDatetimeStart(request.getDatetime_start()); track.setDatetimeEnd(request.getDatetime_end()); track.setUserId(users); track.setIsPublic(request.isIs_public()); track.setStartAddress(request.getStart_address()); track.setEndAddress(request.getEnd_address()); if (request.getTrackRatings().size() > 0) { OtnServiceTrackResponse rate_response = checkTrackRateAndType(request.getTrackRatings()); if (rate_response.getResponseCode() == 0) { em.persist(track); em.flush(); em.getTransaction().commit(); em.clear(); for (OtnServicePoiRatings trackRatingList : request.getTrackRatings()) { em.getTransaction().begin(); track_rating = new TrackRating(); track_rating_type = em.find(TrackRatingType.class, trackRatingList.getRatingTypeId()); track_rating.setTrackId(track); track_rating.setTrackRatingTypeId(track_rating_type); track_rating.setRate(trackRatingList.getRate()); track_rating.setUserId(users); em.persist(track_rating); em.flush(); em.getTransaction().commit(); em.clear(); response.setMessage("success"); response.setResponseCode(0); } } else { response.setMessage(rate_response.getMessage()); response.setResponseCode(rate_response.getResponseCode()); return response; } } else { em.persist(track); em.flush(); em.getTransaction().commit(); em.clear(); response.setMessage("success"); response.setResponseCode(0); } //***********************find weatherID****************************** if (request.getWeatherList().size() > 0) { if (track.getTrackId() == 0) { em.persist(track); em.flush(); em.getTransaction().commit(); em.clear(); } weatherListparams = new ArrayList<OtnServiceWeatherRatings>(); for (OtnServiceWeatherRatings weatherList : request.getWeatherList()) { em.getTransaction().begin(); weather = new Weather(); weather_type = em.find(WeatherType.class, weatherList.getWeatherTypeId()); if (weather_type == null) { response.setMessage("weather id does not exist"); response.setResponseCode(1); return response; } weather.setTrackId(track); weather.setWeatherTypeId(weather_type); em.persist(weather); em.flush(); em.getTransaction().commit(); em.clear(); response.setMessage("success"); response.setResponseCode(0); weatherListparams.add(new OtnServiceWeatherRatings(weather_type.getWeatherId())); } response.setWeatherList(weatherListparams); } //***********************insert geometry points****************************** // insert startPoint List<OtnServiceGeometryPoints> startPointsList = new ArrayList<OtnServiceGeometryPoints>(); OtnServiceGeometryPoints startPoints = new OtnServiceGeometryPoints(); startPoints.setLatitude(request.getLat_start()); startPoints.setLongitude(request.getLon_start()); startPointsList.add(startPoints); // insert endPoint List<OtnServiceGeometryPoints> endPointsList = new ArrayList<OtnServiceGeometryPoints>(); OtnServiceGeometryPoints endPoints = new OtnServiceGeometryPoints(); endPoints.setLatitude(request.getLat_end()); endPoints.setLongitude(request.getLon_end()); endPointsList.add(endPoints); /** * decode csv String */ if (request.getTrackFileCsv() != null) { String trackFilecsvDecode = new String(request.getTrackFileCsv()); /** * write file to folder */ String urlfile = Base_url + System.currentTimeMillis() + ".csv"; BufferedWriter writer = new BufferedWriter(new FileWriter(urlfile)); writer.append(trackFilecsvDecode); writer.close(); // System.out.println("csv " + trackFilecsvDecode); // set delimeter CSVFormat format = CSVFormat.newFormat(';').withHeader(); //parse csv format String // log.info("1 "); CSVParser parser = new CSVParser(new StringReader(trackFilecsvDecode), format); List<OtnServiceGeometryPoints> geomPoints = new ArrayList<OtnServiceGeometryPoints>(); //parse records (in the example 2 records) List timestamp = new ArrayList<String>(); for (CSVRecord record : parser) { timestamp.add(record.get("Timestamp")); // System.out.println("latitude " + record.get("Latitude")); // System.out.println("Longitude " + record.get("Longitude")); // System.out.println("Timestamp " + record.get("Timestamp")); // log.info("2"); geomPoints.add(new OtnServiceGeometryPoints(Double.parseDouble(record.get("Latitude")), Double.parseDouble(record.get("Longitude")))); } // System.out.println("number " + total_records); // System.out.println("first time" + timestamp.get(0)); // System.out.println("end time" + timestamp.get(timestamp.size() - 1)); String start_date = timestamp.get(0).toString(); String end_date = timestamp.get(timestamp.size() - 1).toString(); parser.close(); // log.info("3"); // if (request.getGeometryPoints() != null) { // geomPoints = request.getGeometryPoints(); // // } insertGeometryPoints(track.getTrackId(), geomPoints, startPointsList, endPointsList, start_date, end_date, urlfile); } response.setName(track.getName()); response.setTrackId(track.getTrackId()); response.setDescription(track.getDescription()); response.setDistance(track.getDistance()); response.setDuration(track.getDuration()); if (transport_type != null) { response.setTransportName(transport_type.getName()); } response.setSpeed(track.getSpeed()); response.setElevation(track.getElevation()); response.setLat_start(track.getLatStart()); response.setLon_start(track.getLongStart()); response.setLat_end(track.getLatEnd()); response.setLon_end(track.getLongEnd()); response.setDatetime_start(track.getDatetimeStart()); response.setDatetime_end(track.getDatetimeEnd()); response.setUserId(users.getUserId()); response.setIs_public(track.getIsPublic()); response.setRoute_kml(track.getRouteKlm()); response.setTrackFileCsv(Base64.decodeBase64(track.getTrackFileCsv())); if (app != null) { response.setAppName(app.getName()); } response.setStart_address(track.getStartAddress()); response.setEnd_address(track.getEndAddress()); // if (weather != null) { // response.setWeatherCondition(weather.getCondition()); // } if (source != null) { response.setSourceName(source.getName()); } return response; // } } catch (Exception e) { e.printStackTrace(); response.setMessage("failure"); response.setResponseCode(2); } finally { return response; } }
From source file:parser_owl.ParserOwl.java
public static void startParisWithData(String inputData) { try {//from w w w . j av a2s . c o m File csvData = new File("/Users/gautier/Documents/web_sem/sources/paris_tournages2.csv"); CSVParser parser = CSVParser.parse(csvData, Charset.defaultCharset(), CSVFormat.EXCEL.withHeader()); System.out.println("Starting Paris (input file: " + csvData.getAbsolutePath() + ")..."); for (CSVRecord csvRecord : parser) { Film film = new Film(csvRecord.get("titre"), csvRecord.get("realisateur"), csvRecord.get("date_debut_evenement"), csvRecord.get("date_fin_evenement"), csvRecord.get("cadre"), csvRecord.get("lieu"), csvRecord.get("adresse"), csvRecord.get("arrondissement"), csvRecord.get("adresse_complete"), csvRecord.get("geo_coordinates"), OMDB_PROXY.getMovieInfos(csvRecord.get("titre")).get("imdbRating"), OMDB_PROXY.getMovieInfos(csvRecord.get("titre")).get("Runtime"), OMDB_PROXY.getMovieInfos(csvRecord.get("titre")).get("Country"), OMDB_PROXY.getMovieInfos(csvRecord.get("titre")).get("Actors"), OMDB_PROXY.getMovieInfos(csvRecord.get("titre")).get("Year")); MANAGER.store(film); } System.out.println("Ending Paris."); } catch (IOException e) { System.out.println("error: " + e); } }
From source file:parser_owl.ParserOwl.java
public static void startMontpellierWithData(String inputData) { try {// w w w . ja va2 s . c om System.out.println("Starting Montpellier (input file: " + inputData + ")..."); File csvData = new File(inputData); CSVParser parser = CSVParser.parse(csvData, Charset.defaultCharset(), CSVFormat.EXCEL.withHeader()); for (CSVRecord csvRecord : parser) { Film film = new Film(csvRecord.get("titre"), OMDB_PROXY.getMovieInfos(csvRecord.get("titre")).get("Director"), csvRecord.get("date_debut_evenement"), csvRecord.get("date_fin_evenement"), "", csvRecord.get("lieu"), csvRecord.get("lieu"), "", csvRecord.get("lieu"), "", OMDB_PROXY.getMovieInfos(csvRecord.get("titre")).get("imdbRating"), OMDB_PROXY.getMovieInfos(csvRecord.get("titre")).get("Runtime"), OMDB_PROXY.getMovieInfos(csvRecord.get("titre")).get("Country"), OMDB_PROXY.getMovieInfos(csvRecord.get("titre")).get("Actors"), OMDB_PROXY.getMovieInfos(csvRecord.get("titre")).get("Year")); MANAGER.store(film); } System.out.println("Ending Montpellier."); } catch (IOException e) { System.out.println("error: " + e); } }
From source file:password.pwm.util.localdb.LocalDBUtility.java
private void importLocalDB(final InputStream inputStream, final Appendable out, final long totalBytes) throws PwmOperationalException, IOException { this.prepareForImport(); importLineCounter = 0;//from w w w. ja va2 s . c om if (totalBytes > 0) { writeStringToOut(out, "total bytes in localdb import source: " + totalBytes); } writeStringToOut(out, "beginning localdb import..."); final Instant startTime = Instant.now(); final TransactionSizeCalculator transactionCalculator = new TransactionSizeCalculator( new TransactionSizeCalculator.SettingsBuilder() .setDurationGoal(new TimeDuration(100, TimeUnit.MILLISECONDS)).setMinTransactions(50) .setMaxTransactions(5 * 1000).createSettings()); final Map<LocalDB.DB, Map<String, String>> transactionMap = new HashMap<>(); for (final LocalDB.DB loopDB : LocalDB.DB.values()) { transactionMap.put(loopDB, new TreeMap<>()); } final CountingInputStream countingInputStream = new CountingInputStream(inputStream); final EventRateMeter eventRateMeter = new EventRateMeter(TimeDuration.MINUTE); final Timer statTimer = new Timer(true); statTimer.scheduleAtFixedRate(new TimerTask() { @Override public void run() { String output = ""; if (totalBytes > 0) { final ProgressInfo progressInfo = new ProgressInfo(startTime, totalBytes, countingInputStream.getByteCount()); output += progressInfo.debugOutput(); } else { output += "recordsImported=" + importLineCounter; } output += ", avgTransactionSize=" + transactionCalculator.getTransactionSize() + ", recordsPerMinute=" + eventRateMeter.readEventRate().setScale(2, BigDecimal.ROUND_DOWN); writeStringToOut(out, output); } }, 30 * 1000, 30 * 1000); Reader csvReader = null; try { csvReader = new InputStreamReader(new GZIPInputStream(countingInputStream, GZIP_BUFFER_SIZE), PwmConstants.DEFAULT_CHARSET); for (final CSVRecord record : PwmConstants.DEFAULT_CSV_FORMAT.parse(csvReader)) { importLineCounter++; eventRateMeter.markEvents(1); final String dbName_recordStr = record.get(0); final LocalDB.DB db = JavaHelper.readEnumFromString(LocalDB.DB.class, null, dbName_recordStr); final String key = record.get(1); final String value = record.get(2); if (db == null) { writeStringToOut(out, "ignoring localdb import record #" + importLineCounter + ", invalid DB name '" + dbName_recordStr + "'"); } else { transactionMap.get(db).put(key, value); int cachedTransactions = 0; for (final LocalDB.DB loopDB : LocalDB.DB.values()) { cachedTransactions += transactionMap.get(loopDB).size(); } if (cachedTransactions >= transactionCalculator.getTransactionSize()) { final long startTxnTime = System.currentTimeMillis(); for (final LocalDB.DB loopDB : LocalDB.DB.values()) { localDB.putAll(loopDB, transactionMap.get(loopDB)); transactionMap.get(loopDB).clear(); } transactionCalculator.recordLastTransactionDuration(TimeDuration.fromCurrent(startTxnTime)); } } } } finally { LOGGER.trace("import process completed"); statTimer.cancel(); IOUtils.closeQuietly(csvReader); IOUtils.closeQuietly(countingInputStream); } for (final LocalDB.DB loopDB : LocalDB.DB.values()) { localDB.putAll(loopDB, transactionMap.get(loopDB)); transactionMap.get(loopDB).clear(); } this.markImportComplete(); writeStringToOut(out, "restore complete, restored " + importLineCounter + " records in " + TimeDuration.fromCurrent(startTime).asLongString()); statTimer.cancel(); }
From source file:permafrost.tundra.data.IDataCSVParser.java
/** * Returns an IData representation of the CSV data in the given input stream. * * @param inputStream The input stream to be decoded. * @param charset The character set to use. * @return An IData representation of the given input stream data. * @throws IOException If there is a problem reading from the stream. *//* w w w .j a v a 2 s . c o m*/ @Override public IData decode(InputStream inputStream, Charset charset) throws IOException { if (inputStream == null) return null; Reader reader = new InputStreamReader(inputStream, CharsetHelper.normalize(charset)); CSVFormat format = CSVFormat.DEFAULT.withHeader().withDelimiter(delimiter).withNullString(""); CSVParser parser = format.parse(reader); Set<String> keys = parser.getHeaderMap().keySet(); List<IData> list = new ArrayList<IData>(); for (CSVRecord record : parser) { IData document = IDataFactory.create(); IDataCursor cursor = document.getCursor(); for (String key : keys) { if (record.isSet(key)) { String value = record.get(key); if (value != null) IDataUtil.put(cursor, key, value); } } cursor.destroy(); list.add(document); } IData output = IDataFactory.create(); IDataCursor cursor = output.getCursor(); IDataUtil.put(cursor, "recordWithNoID", list.toArray(new IData[list.size()])); return output; }
From source file:phonedirectory.PhoneDirectoryModel.java
public void csvToDatabase(String csv, String column[]) { try {/*from w w w . ja va2s .c om*/ Connection con = DriverManager.getConnection(url, user, password); stmt1 = con.createStatement(); int i; CSVParser parser = new CSVParser(new FileReader(csv), format); for (CSVRecord record : parser) { stmt = con.prepareStatement("insert into person(name,address) values(?,?)"); stmt.setString(1, record.get(0)); stmt.setString(2, record.get(1)); stmt.executeUpdate(); stmt.close(); rs = stmt1.executeQuery("select person_id from person"); rs.last(); int person_id = rs.getInt(1); stmt = con.prepareStatement("insert into phone values(?,?,?)"); for (i = 2; i < record.size(); i++) { stmt.setString(1, record.get(i)); stmt.setString(2, column[i]); stmt.setInt(3, person_id); stmt.executeUpdate(); } stmt.close(); } parser.close(); con.close(); } catch (Exception e) { e.printStackTrace(); } }
From source file:pl.hycom.pip.messanger.service.GreetingService.java
@Override public void afterPropertiesSet() throws Exception { try (Reader in = new InputStreamReader(getClass().getResourceAsStream("/messenger-locale.csv"))) { Iterable<CSVRecord> records = CSVFormat.EXCEL.parse(in); for (CSVRecord record : records) { availableLocale.put(record.get(0), record.get(1)); }/* w w w. ja v a 2 s . com*/ } log.info("Locale loaded: " + availableLocale); }
From source file:proci.gui.Importa.java
private void doImport() { jepData.setText(""); text = new StringBuilder("<html><body>"); try {//from w w w . j ava 2s . com conn = DBHandler.getInstance().getConnection(); stmt = conn.createStatement(); conn.setAutoCommit(false); int delRec = 0; delRec = stmt.executeUpdate("delete from SOCIO"); text.append("Cancellati: ").append(delRec).append(" soci!<br>"); delRec = stmt.executeUpdate("delete from DOTAZIONE"); text.append("Cancellate: ").append(delRec).append(" dotazioni!<br>"); delRec = stmt.executeUpdate("delete from INTERVENTO"); text.append("Cancellati: ").append(delRec).append(" interventi!<br>"); delRec = stmt.executeUpdate("delete from ESERCITAZIONE"); text.append("Cancellate: ").append(delRec).append(" esercitazioni!<br>"); delRec = stmt.executeUpdate("delete from SPECIALIZZAZIONE"); text.append("Cancellate: ").append(delRec).append(" specializzazioni!<br>"); delRec = stmt.executeUpdate("delete from SODO"); delRec = stmt.executeUpdate("delete from SOIN"); delRec = stmt.executeUpdate("delete from SOES"); delRec = stmt.executeUpdate("delete from SOSP"); // elimina foto dei soci File imagedir = new File(app.getAppPath(EDirectories.IMAGES_PHOTOS)); File[] images = imagedir.listFiles(); for (File f : images) { f.delete(); } text.append("Eliminate: ").append(images.length).append(" immagini<br>"); // elimina miniature imagedir = new File(app.getAppPath(EDirectories.IMAGES_THUMBS)); images = imagedir.listFiles(); for (File f : images) { f.delete(); } text.append("Eliminate: ").append(images.length).append(" miniature<br>"); // psSocio = conn .prepareStatement("insert into SOCIO values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)"); psDot = conn.prepareStatement("insert into DOTAZIONE values (?,?,?)"); psInt = conn.prepareStatement("insert into INTERVENTO values (?,?)"); psEse = conn.prepareStatement("insert into ESERCITAZIONE values (?,?)"); psSpe = conn.prepareStatement("insert into SPECIALIZZAZIONE values (?,?)"); psSodo = conn.prepareStatement("insert into SODO values (?,?,?)"); psSoin = conn.prepareStatement("insert into SOIN values (?,?)"); psSoes = conn.prepareStatement("insert into SOES values (?,?)"); psSosp = conn.prepareStatement("insert into SOSP values (?,?)"); // File csvData = new File(filename); CSVParser parser = CSVParser.parse(csvData, Charset.forName("UTF-8"), CSVFormat.RFC4180); for (CSVRecord csvRecord : parser) { // trappola intestazione if (csvRecord.get(0).equalsIgnoreCase("IDSocio")) { continue; } logger.info("Insert Socio: {}", csvRecord); insertSocio(csvRecord); // break; // case 2: // insertDot(line); // break; // case 3: // insertInt(line); // break; // case 4: // insertEse(line); // break; // case 5: // insertSpe(line); // break; // case 6: // insertSodo(line); // break; // case 7: // insertSoin(line); // break; // case 8: // insertSoes(line); // break; // case 9: // insertSosp(line); // break; // } } } catch (Exception e) { JOptionPane.showMessageDialog(this, "<html><font color='red'>ERRORE!</font>" + e, "ERRORE", JOptionPane.ERROR_MESSAGE); text.append("ERRORE: " + e); jepData.setText(text.toString()); return; } try { conn.commit(); } catch (SQLException e) { } jepData.setText(text.toString()); }
From source file:proci.gui.Importa.java
private void insertSocio(CSVRecord line) throws Exception { text.append("Elaboro socio:").append(line.get(0)).append("<br>"); psSocio.setInt(1, Integer.parseInt(line.get(0))); psSocio.setString(2, line.get(1));//from w w w . j av a 2s.c om psSocio.setString(3, line.get(2)); psSocio.setString(4, line.get(3)); psSocio.setString(5, line.get(4)); psSocio.setDate(6, SwingUtils.formatStringToDate(line.get(5))); psSocio.setString(7, line.get(6)); psSocio.setString(8, line.get(7)); psSocio.setString(9, line.get(8)); psSocio.setString(10, line.get(9)); psSocio.setString(11, line.get(10)); psSocio.setString(12, line.get(11)); psSocio.setString(13, line.get(12)); psSocio.setInt(14, Integer.parseInt(line.get(13))); psSocio.setInt(15, Integer.parseInt(line.get(14))); psSocio.setString(16, line.get(15)); psSocio.setString(17, line.get(16)); if (line.get(17).length() > 0) { File imageFile = new File(line.get(17)); if (!imageFile.isAbsolute()) { imageFile = new File(app.getAppPath() + "/" + line.get(17)); } if (!imageFile.exists()) { throw new Exception( "ERRORE: Attenzione: il file immagine " + imageFile.getAbsolutePath() + " non esiste!! "); } ProciUtils.copiaFotoSoci(imageFile); ProciUtils.creaMiniatura(imageFile); psSocio.setString(18, imageFile.getName()); } else { psSocio.setString(18, null); } String tipoSocio = "O"; if (line.get(18).equals("ONORARIO")) { tipoSocio = "X"; } if (line.get(18).equals("NON OPERATIVO")) { tipoSocio = "N"; } psSocio.setString(19, tipoSocio); psSocio.setString(20, line.get(19)); psSocio.setString(21, line.get(20)); psSocio.setString(22, line.get(21)); psSocio.setString(23, line.get(22)); psSocio.execute(); }