java讀取文件內容,解析Json格式數據
一、讀取txt文件內容(Json格式數據)
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
|
public static String reader(String filePath) { try { File file = new File(filePath); if (file.isFile() && file.exists()) { InputStreamReader read = new InputStreamReader(new FileInputStream(file), "UTF-8"); BufferedReader bufferedReader = new BufferedReader(read); String lineTxt = bufferedReader.readLine(); while (lineTxt != null) { return lineTxt; } } } catch (UnsupportedEncodingException | FileNotFoundException e) { System.out.println("Cannot find the file specified!"); e.printStackTrace(); } catch (IOException e) { System.out.println("Error reading file content!"); e.printStackTrace(); } return null;} |
二、解析處理Json格式數據
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
|
private static void process(String txtStr) { JSONObject json = JSONObject.fromObject(txtStr); JSONArray datas = json.getJSONObject("data").getJSONArray("rows"); List<Map<String, Object>> list = new ArrayList<>(); for (int i = 0; i < datas.length(); i++) { Map<String, Object> map = new HashMap<>(); JSONObject obj = datas.getJSONObject(i).getJSONObject("cells"); String name = obj.getString("weibo_name"); String code = obj.getString("weibo_id"); String url = BASE_URL + obj.getString("url"); map.put("name", name); map.put("code", code); map.put("url", url); list.add(map); } if (!list.isEmpty()) { insert(list); }} |
三、結果存入數據庫
|
1
2
3
4
5
|
private static void insert(List<Map<String, Object>> list) { for (Map<String, Object> map : list) { //遍歷數據，寫存儲方法 }} |
四、測試
|
1
2
3
4
5
6
7
8
9
10
|
public static void main(String[] args) { String filePath = "E:\\wugang\\data\\weiboyi\\wechat.txt"; String txtStr = reader(filePath); if (txtStr != null) { process(txtStr); } else { System.out.println("Read the content is empty!"); } System.out.println("--- end ---");} |
java 讀取txt文件中的json數據，進行導出
txt文件中的內容如下
以下代碼可直接運行
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
|
package com.hwt.count.test;import java.io.BufferedReader;import java.io.File;import java.io.FileInputStream;import java.io.FileOutputStream;import java.io.InputStreamReader;import java.util.ArrayList;import java.util.List;import org.apache.poi.hssf.usermodel.HSSFCell;import org.apache.poi.hssf.usermodel.HSSFCellStyle;import org.apache.poi.hssf.usermodel.HSSFFont;import org.apache.poi.hssf.usermodel.HSSFRow;import org.apache.poi.hssf.usermodel.HSSFSheet;import org.apache.poi.hssf.usermodel.HSSFWorkbook;import org.apache.poi.hssf.util.CellRangeAddress;import org.apache.poi.hssf.util.HSSFColor;import net.sf.json.JSONObject;public class Testaa { public static void main(String[] args) { try { String path = "C:/Users/dell/Desktop/test.txt"; File file = new File(path); InputStreamReader isr = new InputStreamReader(new FileInputStream(file),"GBK"); BufferedReader br = new BufferedReader(isr); String content = br.readLine() ; br.close(); isr.close(); content = content.substring(2, content.length()-2); content = content.replace("},{", ";"); String[] arrContent = content.split(";"); //設置列頭名稱和表體數據 String[] rowsName = new String[]{"code_type","code","name"}; List<Object[]> dataList = new ArrayList<Object[]>(); for(String arrc : arrContent){ JSONObject jsonObj = JSONObject.fromObject("{"+arrc+"}"); String code = jsonObj.getString("code"); String name = jsonObj.getString("name"); Object[] obj = new Object[rowsName.length]; obj[0] = "TYPE"; obj[1] = code; obj[2] = name; dataList.add(obj); } //設置列頭名稱和表體數據 HSSFWorkbook workbook = setWorkBookDate(dataList,rowsName); try { // 將workbook對象輸出到文件test.xls FileOutputStream fos = new FileOutputStream("C:/Users/dell/Desktop/test.xls"); workbook.write(fos); fos.flush(); // 緩沖 fos.close(); // 關閉流 }catch (Exception e1) { e1.printStackTrace(); } } catch (Exception e) { e.printStackTrace(); } } private static HSSFWorkbook setWorkBookDate(List<Object[]> dataList,String[] rowsName){ //創建工作簿對象 HSSFWorkbook workbook = new HSSFWorkbook(); //創建工作表，設置當前頁名稱 HSSFSheet sheet = workbook.createSheet("測試"); //設置默認行高 sheet.setDefaultRowHeight((short)350); //合并表頭表尾的單元格 /*sheet.addMergedRegion(new CellRangeAddress(0, 2, 0, 3)); sheet.addMergedRegion(new CellRangeAddress(3, 3, 0, 3)); //凍結行 workbook.getSheetAt(0).createFreezePane(0, 4); RegionUtil.setBorderBottom(1, new CellRangeAddress(3, 3, 0, 3), workbook.getSheetAt(0), workbook);//設置邊框*/ // 獲取表頭樣式對象 // 獲取表體樣式對象 HSSFCellStyle style = getCommonStyle(workbook); // 定義所需列數 int columnNum = rowsName.length; //創建列頭 HSSFRow rowHead = sheet.createRow(0); for(int n = 0;n < columnNum;n++){ HSSFCell cellRow = rowHead.createCell(n,HSSFCell.CELL_TYPE_STRING);//創建列頭對應個數的單元格 cellRow.setCellValue(rowsName[n]);//設置列頭單元格的值 cellRow.setCellStyle(style);//設置列頭單元格樣式 } //將查詢出的數據設置到sheet對應的單元格中 for(int i=0;i<dataList.size();i++){ Object[] obj =new Object[dataList.get(i).length]; obj[0] = dataList.get(i)[0]; obj[1] = dataList.get(i)[1]; obj[2] = dataList.get(i)[2]; HSSFRow row = sheet.createRow(i+1);//創建所需的行數 for(int j = 0; j < obj.length; j++){ HSSFCell cell = row.createCell(j,HSSFCell.CELL_TYPE_STRING);//設置單元格的數據類型 if(!"".equals(obj[j]) && obj[j] != null){ cell.setCellValue(obj[j].toString());//設置單元格的值 }else{ cell.setCellValue("");//設置單元格的值為空字符串 } cell.setCellStyle(style);//設置單元格樣式 } } //讓列寬隨著導出的列長自動適應 for (int colNum = 0; colNum < columnNum; colNum++) { int columnWidth = sheet.getColumnWidth(colNum) / 256; for (int rowNum = 0; rowNum < sheet.getLastRowNum(); rowNum++) { HSSFRow currentRow; //當前行未被使用過 if (sheet.getRow(rowNum) == null) { currentRow = sheet.createRow(rowNum); } else { currentRow = sheet.getRow(rowNum); } if (currentRow.getCell(colNum) != null) { HSSFCell currentCell = currentRow.getCell(colNum); if(currentCell != null && !"".equals(currentCell)){ if (currentCell.getCellType() == HSSFCell.CELL_TYPE_STRING) { int length = currentCell.getStringCellValue().getBytes().length; if (columnWidth < length) { columnWidth = length; } } } } } if(colNum == 0){ //設置表體第一列的寬度 sheet.setColumnWidth(colNum, (columnWidth+4) * 400); }else{ //設置表體其他列的寬度 sheet.setColumnWidth(colNum, (columnWidth+4) * 400); } } return workbook; } public static HSSFCellStyle getCommonStyle(HSSFWorkbook workbook) { // 設置字體 HSSFFont font = workbook.createFont(); //設置字體大小 font.setFontHeightInPoints((short)11); //字體加粗 //font.setBoldweight(HSSFFont.BOLDWEIGHT_BOLD); //設置字體名字 font.setFontName("Courier New"); //設置樣式; HSSFCellStyle style = workbook.createCellStyle(); //設置底邊框; style.setBorderBottom(HSSFCellStyle.BORDER_THIN); //設置底邊框顏色; style.setBottomBorderColor(HSSFColor.BLACK.index); //設置左邊框; style.setBorderLeft(HSSFCellStyle.BORDER_THIN); //設置左邊框顏色; style.setLeftBorderColor(HSSFColor.BLACK.index); //設置右邊框; style.setBorderRight(HSSFCellStyle.BORDER_THIN); //設置右邊框顏色; style.setRightBorderColor(HSSFColor.BLACK.index); //設置頂邊框; style.setBorderTop(HSSFCellStyle.BORDER_THIN); //設置頂邊框顏色; style.setTopBorderColor(HSSFColor.BLACK.index); //在樣式用應用設置的字體; style.setFont(font); //設置自動換行; style.setWrapText(false); //設置水平對齊的樣式為居中對齊; style.setAlignment(HSSFCellStyle.ALIGN_CENTER); //設置垂直對齊的樣式為居中對齊; style.setVerticalAlignment(HSSFCellStyle.VERTICAL_CENTER); return style; }} |
以上為個人經驗，希望能給大家一個參考，也希望大家多多支持服務器之家。
原文鏈接：https://blog.csdn.net/u011389474/article/details/52700443
