导出文件csv格式

最新推荐文章于 2023-10-26 18:30:12 发布

那时秋风正爽

最新推荐文章于 2023-10-26 18:30:12 发布

阅读量1.1k

点赞数 1

分类专栏： java

本文链接：https://blog.csdn.net/qq_37334428/article/details/81056692

版权

java 专栏收录该内容

5 篇文章 0 订阅

订阅专栏

public class JsonToExcel {

    // 服务器文件路径
    public static String saveUrl ="D:\\hnqp\\GMManager\\excal\\";

    /**
     * 导出玩家基本信息
     * @param data
     * @param name
     */
    public static void  excelToLoad_player(JSONArray data,String name) {
        String textName =name+".csv";
        FileWriter fw = null;
        try {
            fw = new FileWriter(saveUrl+textName);
            fw.write("玩家id");
            fw.write(",");
            fw.write("openId");
            fw.write(",");
            fw.write("昵称");
            fw.write(",");
            fw.write("平台");
            fw.write(",");
            fw.write("注册时间");
            fw.write(",");
            fw.write("是否禁用");
            fw.write(",");
            fw.write("是否机器人");
            fw.write("\n");
            fw.flush();
            Iterator<Object> it = data.iterator();
            while (it.hasNext()) {
                JSONObject ob = (JSONObject) it.next();
                if (ob.getString("playerId")!=null && ob.getString("playerId")!="" && !"".equals(ob.getString("playerId"))) {
                    fw.write(ob.getString("playerId"));  
                }
                else {
                    fw.write("null");
                }                                  
                fw.write(",");
                if (ob.getString("openId")!=null && ob.getString("openId")!="" &&!"".equals(ob.getString("openId"))) {
                    fw.write(ob.getString("openId"));  
                }
                else {
                    fw.write("null");
                }                                  
                fw.write(",");
                if (ob.getString("name")!=null && ob.getString("name")!="" && !"".equals(ob.getString("name"))) {
                    fw.write(ob.getString("name"));  
                }
                else {
                    fw.write("null");
                }                                  
                fw.write(",");
                if (ob.getString("phoneOS")!=null && ob.getString("phoneOS")!="" && !"".equals(ob.getString("phoneOS"))) {
                    fw.write(ob.getString("phoneOS"));  
                }
                else {
                    fw.write("null");
                }                                  
                fw.write(",");
                if (ob.getString("createTime")!=null && ob.getString("createTime")!="" && !"".equals(ob.getString("createTime"))) {
                    fw.write(ob.getString("createTime"));  
                }
                else {
                    fw.write("null");
                }                                  
                fw.write(",");
                if (ob.getString("forbidden")!=null && ob.getString("forbidden")!="" && !"".equals(ob.getString("forbidden"))) {
                    fw.write(ob.getString("forbidden"));  
                }
                else {
                    fw.write("null");
                }                                  
                fw.write(",");
                if (ob.getString("iRobotFlag")!=null && ob.getString("iRobotFlag")!="" && !"".equals(ob.getString("iRobotFlag"))) {
                    fw.write(ob.getString("iRobotFlag"));  
                }
                else {
                    fw.write("null");
                }                                    
                fw.write(",");
                fw.write("\n");
                fw.flush();
                }

        } catch (Exception e) {
            e.printStackTrace();
        }
    }
}