java读取文件内容,解析Json格式数据方式

• java读取文件内容,解析json格式数据
• 一、读取txt文件内容(json格式数据)
• 二、解析处理json格式数据

java读取文件内容,解析json格式数据

一、读取txt文件内容(json格式数据)

    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格式数据

    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);
        }
    }

三、结果存入数据库

    private static void insert(list<map<string, object>> list) {
        for (map<string, object> map : list) {
            //遍历数据，写存储方法
        }
    }

四、测试

    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文件中的内容如下

以下代码可直接运行

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;
    }
}

以上为个人经验，希望能给大家一个参考，也希望大家多多支持。