두 개의 Java 파일에 대한 항아리를 만들었습니다.
package com.json;
import java.io.BufferedWriter;
import java.io.File;
import java.io.FileInputStream;
import java.io.FileWriter;
import java.util.Iterator;
import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.ss.usermodel.Row;
import org.json.simple.JSONArray;
import org.json.simple.JSONObject;
public class SecondLevelJsonCreator {
private static final String CATEGORY_ID2 = "category_id";
private static final String CHILD_CATEGORY_TAGS = "child_category_tags";
private static final String PARENT_CATEGORY_TAGS = "parent_category_tags";
private static final String CATEGORY_NAME = "categoryName";
private static final String CATEGORY_ID = "categoryId";
@SuppressWarnings("unchecked")
public static void main(String[] args)
{
try
{
File fileWI = new File("C://Users//intradhakr//Desktop//LEAF//LEAF_2Level.txt");
// if file doesnt exists, then create it
if (!fileWI.exists()) {
fileWI.createNewFile();
}
FileWriter fw = new FileWriter(fileWI.getAbsoluteFile());
BufferedWriter bw = new BufferedWriter(fw);
FileInputStream file = new FileInputStream(new File("C://Users//intradhakr//Desktop//SMTC.xls"));
//Create Workbook instance holding reference to .xlsx file
HSSFWorkbook workbook = new HSSFWorkbook(file);
//Get first/desired sheet from the workbook
HSSFSheet sheet = workbook.getSheetAt(3);
//Iterate through each rows one by one
Iterator<Row> rowIterator = sheet.iterator();
String EMPTY ="";
JSONArray childCategory = new JSONArray();
// JSONArray parentCategory = new JSONArray();
JSONObject json = new JSONObject();
rowIterator.hasNext();
int i=0;
do
{
i++;
Row row = rowIterator.next();
if(EMPTY.equals(row.getCell(2).getStringCellValue())) {
JSONArray childJsonArr = (JSONArray) json.get(CHILD_CATEGORY_TAGS);
JSONObject jso =new JSONObject();
jso.put(CATEGORY_ID2, row.getCell(4).getStringCellValue());
if(!childJsonArr.contains(jso))
{
childJsonArr.add(jso);
}
json.put(CHILD_CATEGORY_TAGS, childJsonArr);
}
else {
if(i!=1)
{bw.write(json.toString());
bw.newLine();}
json = new JSONObject();
childCategory = new JSONArray();
EMPTY = row.getCell(2).getStringCellValue();
json.put(CATEGORY_ID , row.getCell(2).getStringCellValue());
json.put(CATEGORY_NAME, row.getCell(3).getStringCellValue());
JSONArray parentCategory = new JSONArray();
JSONObject cat0 = new JSONObject();
cat0.put(CATEGORY_ID, row.getCell(0).getStringCellValue());
cat0.put("category_order_id", 0);
parentCategory.add(cat0);
JSONObject jsO =new JSONObject();
jsO.put(CATEGORY_ID2, row.getCell(4).getStringCellValue());
childCategory.add(jsO);
json.put(PARENT_CATEGORY_TAGS, parentCategory);
json.put(CHILD_CATEGORY_TAGS, childCategory);
}
} while (rowIterator.hasNext());
bw.write(json.toString());
file.close();
bw.close();
}
catch (Exception e)
{
e.printStackTrace();
}
}
}
그리고 아래에 또 다른 Java 클래스가 있습니다. 이 파일을 사용하여 명령 프롬프트에서 인수를 전달하여이 파일을 실행할 수 있습니다 .class. 하지만 이제 두 클래스를 하나의 항아리로 만들어야하고이 두 클래스를 항아리에서 실행해야합니다.
public class SecondLevelJsonCreator {
private static final String CATEGORY_ID2 = "category_id";
private static final String CHILD_CATEGORY_TAGS = "child_category_tags";
private static final String PARENT_CATEGORY_TAGS = "parent_category_tags";
private static final String CATEGORY_NAME = "categoryName";
private static final String CATEGORY_ID = "categoryId";
@SuppressWarnings("unchecked")
public static void main(String[] args)
{
try
{
File fileWI = new File("C://Users//intradhakr//Desktop//LEAF//LEAF_2Level.txt");
// if file doesnt exists, then create it
if (!fileWI.exists()) {
fileWI.createNewFile();
}
FileWriter fw = new FileWriter(fileWI.getAbsoluteFile());
BufferedWriter bw = new BufferedWriter(fw);
FileInputStream file = new FileInputStream(new File("C://Users//intradhakr//Desktop//SMTC.xls"));
//Create Workbook instance holding reference to .xlsx file
HSSFWorkbook workbook = new HSSFWorkbook(file);
//Get first/desired sheet from the workbook
HSSFSheet sheet = workbook.getSheetAt(3);
//Iterate through each rows one by one
Iterator<Row> rowIterator = sheet.iterator();
String EMPTY ="";
JSONArray childCategory = new JSONArray();
// JSONArray parentCategory = new JSONArray();
JSONObject json = new JSONObject();
rowIterator.hasNext();
int i=0;
do
{
i++;
Row row = rowIterator.next();
if(EMPTY.equals(row.getCell(2).getStringCellValue())) {
JSONArray childJsonArr = (JSONArray) json.get(CHILD_CATEGORY_TAGS);
JSONObject jso =new JSONObject();
jso.put(CATEGORY_ID2, row.getCell(4).getStringCellValue());
if(!childJsonArr.contains(jso))
{
childJsonArr.add(jso);
}
json.put(CHILD_CATEGORY_TAGS, childJsonArr);
}
else {
if(i!=1)
{bw.write(json.toString());
bw.newLine();}
json = new JSONObject();
childCategory = new JSONArray();
EMPTY = row.getCell(2).getStringCellValue();
json.put(CATEGORY_ID , row.getCell(2).getStringCellValue());
json.put(CATEGORY_NAME, row.getCell(3).getStringCellValue());
JSONArray parentCategory = new JSONArray();
JSONObject cat0 = new JSONObject();
cat0.put(CATEGORY_ID, row.getCell(0).getStringCellValue());
cat0.put("category_order_id", 0);
parentCategory.add(cat0);
JSONObject jsO =new JSONObject();
jsO.put(CATEGORY_ID2, row.getCell(4).getStringCellValue());
childCategory.add(jsO);
json.put(PARENT_CATEGORY_TAGS, parentCategory);
json.put(CHILD_CATEGORY_TAGS, childCategory);
}
} while (rowIterator.hasNext());
bw.write(json.toString());
file.close();
bw.close();
}
catch (Exception e)
{
e.printStackTrace();
}
}
}
이 두 클래스에서는 데이터가 포함 된 파일 경로와 시트 번호 3을 하드 코딩했습니다. 이제 명령 프롬프트에서이 매개 변수를 전달하고 단일 jar에서이 두 클래스를 실행해야합니다.
예를 들면 : java SecondLevelJsonCreator 3 "C:/path/filename.xls"
당신은 이렇게 할 수 있습니다
java -cp jarName.jar packageName.ClassName argumentsIfAny
이 기사는 인터넷에서 수집됩니다. 재 인쇄 할 때 출처를 알려주십시오.
침해가 발생한 경우 연락 주시기 바랍니다[email protected] 삭제
몇 마디 만하겠습니다