public void parsingNDAData(String recordNum, String recordData) { String[] recordNumSplit = recordNum.split(" "); String[] recordDataSplit = recordData.split(","); for (int i = 0; i < recordNumSplit.length; i++) { recordNumSplit[i] = trimSpaceAndQuotes(recordNumSplit[i]); } for (int i = 0; i < recordDataSplit.length; i++) { recordDataSplit[i] = trimSpaceAndQuotes(recordDataSplit[i]); } recordID.add(Integer.valueOf(recordDataSplit[0])); UFID.add(recordDataSplit[1]); }
@Override public void exportDataToFile(PrintWriter ngiWriter, PrintWriter ndaWriter) { // TODO Auto-generated method stub super.exportDataToFile(ngiWriter, ndaWriter); // NDA export ndaWriter.println("<DATA>"); for (int i = 0; i < recordID.size(); i++) { ndaWriter.println("$RECORD " + recordID.get(i)); ndaWriter.println(recordID.get(i) + ", " + UFID.get(i)); } ndaWriter.println("<END>"); ndaWriter.println("<LAYER_END>"); }
@Override public String[] getInsertQuery(String fileName) { // TODO Auto-generated method stub String[] _querys = super.getInsertQuery(fileName); String[] querys = new String[_querys.length + recordID.size()]; String query; int index = 0; for (index = 0; index < _querys.length; index++) { querys[index] = _querys[index]; } for (int i = 0; i < recordID.size(); i++) { query = "insert into " + dataTableName + " values('" + fileName + "', " + layerID + ", " + recordID.get(i) + ", '" + form.get(i) + "', '" + managementAgency.get(i) + "', '" + UFID.get(i) + "', " + wkts.get(i) + ", '" + gattrs.get(i) + "')"; querys[index++] = query; } return querys; }