java讀取文件內(nèi)容,解析Json格式數(shù)據(jù)方式

第java讀取文件內(nèi)容,解析Json格式數(shù)據(jù)方式目錄java讀取文件內(nèi)容,解析Json格式數(shù)據(jù)一、讀取txt文件內(nèi)容(Json格式數(shù)據(jù))二、解析處理Json格式數(shù)據(jù)三、結(jié)果存入數(shù)據(jù)庫四、測試java讀取txt文件中的json數(shù)據(jù)，進(jìn)行導(dǎo)出以下代碼可直接運行

java讀取文件內(nèi)容,解析Json格式數(shù)據(jù)

一、讀取txt文件內(nèi)容(Json格式數(shù)據(jù))

publicstaticStringreader(StringfilePath){

try{

Filefile=newFile(filePath);

if(file.isFile()file.exists()){

InputStreamReaderread=newInputStreamReader(newFileInputStream(file),"UTF-8");

BufferedReaderbufferedReader=newBufferedReader(read);

StringlineTxt=bufferedReader.readLine();

while(lineTxt!=null){

returnlineTxt;

}catch(UnsupportedEncodingException|FileNotFoundExceptione){

System.out.println("Cannotfindthefilespecified!");

e.printStackTrace();

}catch(IOExceptione){

System.out.println("Errorreadingfilecontent!");

e.printStackTrace();

returnnull;

}

二、解析處理Json格式數(shù)據(jù)

privatestaticvoidprocess(StringtxtStr){

JSONObjectjson=JSONObject.fromObject(txtStr);

JSONArraydatas=json.getJSONObject("data").getJSONArray("rows");

ListMapString,Objectlist=newArrayList();

for(inti=0;idatas.length();i++){

MapString,Objectmap=newHashMap();

JSONObjectobj=datas.getJSONObject(i).getJSONObject("cells");

Stringname=obj.getString("weibo_name");

Stringcode=obj.getString("weibo_id");

Stringurl=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);

三、結(jié)果存入數(shù)據(jù)庫

privatestaticvoidinsert(ListMapString,Objectlist){

for(MapString,Objectmap:list){

//遍歷數(shù)據(jù)，寫存儲方法

}

四、測試

publicstaticvoidmain(String[]args){

StringfilePath="E:\\wugang\\data\\weiboyi\\wechat.txt";

StringtxtStr=reader(filePath);

if(txtStr!=null){

process(txtStr);

}else{

System.out.println("Readthecontentisempty!");

System.out.println("---end---");

java讀取txt文件中的json數(shù)據(jù)，進(jìn)行導(dǎo)出

txt文件中的內(nèi)容如下

以下代碼可直接運行

packagecom.hwt.count.test;

importjava.io.BufferedReader;

importjava.io.File;

importjava.io.FileInputStream;

importjava.io.FileOutputStream;

importjava.io.InputStreamReader;

importjava.util.ArrayList;

importjava.util.List;

importorg.apache.poi.hssf.usermodel.HSSFCell;

importorg.apache.poi.hssf.usermodel.HSSFCellStyle;

importorg.apache.poi.hssf.usermodel.HSSFFont;

importorg.apache.poi.hssf.usermodel.HSSFRow;

importorg.apache.poi.hssf.usermodel.HSSFSheet;

importorg.apache.poi.hssf.usermodel.HSSFWorkbook;

importorg.apache.poi.hssf.util.CellRangeAddress;

importorg.apache.poi.hssf.util.HSSFColor;

importnet.sf.json.JSONObject;

publicclassTestaa{

publicstaticvoidmain(String[]args){

try{

Stringpath="C:/Users/dell/Desktop/test.txt";

Filefile=newFile(path);

InputStreamReaderisr=newInputStreamReader(newFileInputStream(file),"GBK");

BufferedReaderbr=newBufferedReader(isr);

Stringcontent=br.readLine();

br.close();

isr.close();

content=content.substring(2,content.length()-2);

content=content.replace("},{",";");

String[]arrContent=content.split(";");

//設(shè)置列頭名稱和表體數(shù)據(jù)

String[]rowsName=newString[]{"code_type","code","name"};

ListObject[]dataList=newArrayListObject[]

for(Stringarrc:arrContent){

JSONObjectjsonObj=JSONObject.fromObject("{"+arrc+"}");

Stringcode=jsonObj.getString("code");

Stringname=jsonObj.getString("name");

Object[]obj=newObject[rowsName.length];

obj[0]="TYPE";

obj[1]=code;

obj[2]=name;

dataList.add(obj);

//設(shè)置列頭名稱和表體數(shù)據(jù)

HSSFWorkbookworkbook=setWorkBookDate(dataList,rowsName);

try{

//將workbook對象輸出到文件test.xls

FileOutputStreamfos=newFileOutputStream("C:/Users/dell/Desktop/test.xls");

workbook.write(fos);

fos.flush();//緩沖

fos.close();//關(guān)閉流

}catch(Exceptione1){

e1.printStackTrace();

}catch(Exceptione){

e.printStackTrace();

privatestaticHSSFWorkbooksetWorkBookDate(ListObject[]dataList,String[]rowsName){

//創(chuàng)建工作簿對象

HSSFWorkbookworkbook=newHSSFWorkbook();

//創(chuàng)建工作表，設(shè)置當(dāng)前頁名稱

HSSFSheetsheet=workbook.createSheet("測試");

//設(shè)置默認(rèn)行高

sheet.setDefaultRowHeight((short)350);

//合并表頭表尾的單元格

/*sheet.addMergedRegion(newCellRangeAddress(0,2,0,3));

sheet.addMergedRegion(newCellRangeAddress(3,3,0,3));

//凍結(jié)行

workbook.getSheetAt(0).createFreezePane(0,4);

RegionUtil.setBorderBottom(1,newCellRangeAddress(3,3,0,3),workbook.getSheetAt(0),workbook);//設(shè)置邊框

*///獲取表頭樣式對象

//獲取表體樣式對象

HSSFCellStylestyle=getCommonStyle(workbook);

//定義所需列數(shù)

intcolumnNum=rowsName.length;

//創(chuàng)建列頭

HSSFRowrowHead=sheet.createRow(0);

for(intn=0;ncolumnNum;n++){

HSSFCellcellRow=rowHead.createCell(n,HSSFCell.CELL_TYPE_STRING);//創(chuàng)建列頭對應(yīng)個數(shù)的單元格

cellRow.setCellValue(rowsName[n]);//設(shè)置列頭單元格的值

cellRow.setCellStyle(style);//設(shè)置列頭單元格樣式

//將查詢出的數(shù)據(jù)設(shè)置到sheet對應(yīng)的單元格中

for(inti=0;idataList.size();i++){

Object[]obj=newObject[dataList.get(i).length];

obj[0]=dataList.get(i)[0];

obj[1]=dataList.get(i)[1];

obj[2]=dataList.get(i)[2];

HSSFRowrow=sheet.createRow(i+1);//創(chuàng)建所需的行數(shù)

for(intj=0;jobj.length;j++){

HSSFCellcell=row.createCell(j,HSSFCell.CELL_TYPE_STRING);//設(shè)置單元格的數(shù)據(jù)類型

if(!"".equals(obj[j])obj[j]!=null){

cell.setCellValue(obj[j].toString());//設(shè)置單元格的值

}else{

cell.setCellValue("");//設(shè)置單元格的值為空字符串

cell.setCellStyle(style);//設(shè)置單元格樣式

//讓列寬隨著導(dǎo)出的列長自動適應(yīng)

for(intcolNum=0;colNumcolumnNum;colNum++){

intcolumnWidth=sheet.getColumnWidth(colNum)/256;

for(introwNum=0;rowNumsheet.getLastRowNum();rowNum++){

HSSFRowcurrentRow;

//當(dāng)前行未被使用過

if(sheet.getRow(rowNum)==null){

currentRow=sheet.createRow(rowNum);

}else{

currentRow=sheet.getRow(rowNum);

if(currentRow.getCell(colNum)!=null){

HSSFCellcurrentCell=currentRow.getCell(colNum);

if(currentCell!=null!"".equals(currentCell)){

if(currentCell.getCellType()==HSSFCell.CELL_TYPE_STRING){

intlength=currentCell.getStringCellValue().getBytes().length;

if(columnWidthlength){

columnWidth=length;

if(colNum==0){

//設(shè)置表體第一列的寬度

sheet.setColumnWidth(colNum,(columnWidth+4)*400);

}else{

//設(shè)置表體其他列的寬度

sheet.setColumnWidth(colNum,(columnWidth+4)*400);

returnworkbook;

publicstaticHSSFCellStylegetCommonStyle(HSSFWorkbookworkbook){

//設(shè)置字體

HSSFFontfont=workbook.createFont();

//設(shè)置字體大小

font.setFontHeightInPoints((short)11);

//字體加粗

//font.setBoldweight(HSSFFont.BOLDWEIGHT_BOLD);

//設(shè)置字體名字

font.setFontName("CourierNew");

//設(shè)置樣式;

HSSFCellStylestyle=workbook.createCellStyle();

//設(shè)置底邊框;

style.setBorderBottom(HSSFCellStyle.BORDER_THIN);