20210826-java文件流批量生成兑换码sql

package com.bbk.utils;

import java.io.BufferedWriter;
import java.io.File;
import java.io.FileWriter;
import java.util.Random;

public class RedeemCodeUtils {
    private static int base = 1106;

    private static int toNum = 50;
    public static void main(String[] args) throws Exception {
        productRedeemCode2();
    }

    public static void productRedeemCode() throws Exception {
        File f = new File("D:\\recode.txt");
        if(f.exists()) {
            f.delete();
        }






        File f3 = new File("D:\\redeemCode.txt");
        if(f3.exists()) {
            f3.delete();
        }
        f.createNewFile();
        BufferedWriter bufferedWriter = new BufferedWriter(new FileWriter(f));
        BufferedWriter bufferedWriter3 = new BufferedWriter(new FileWriter(f3));
        StringBuilder sBuilder = new StringBuilder();
        sBuilder.append("insert into t_user_redeem_code (id,redeem_code,redeem_time,redeem_status,create_time,update_time,redeem_activity_id,redeem_activity_name,remain_redeem_time,free_day,redeem_code_type) values ");
        for (int i = base; i < base+toNum; i++) {
            sBuilder.append("(");
            sBuilder.append(i);
            sBuilder.append(",");
            sBuilder.append("'");
            String randomChar = getRandomChar(i);
            bufferedWriter3.write(randomChar);
            bufferedWriter3.write("\r\n");
            sBuilder.append(randomChar);
            sBuilder.append("'");
            sBuilder.append(",24000,0,now(),now(),27,'月度套餐',24000,90,1),");
        }
        bufferedWriter.write(sBuilder.substring(0,sBuilder.length()-1));
        bufferedWriter.close();
        bufferedWriter3.close();
    }

    public static void productRedeemCode2() throws Exception {
        File f = new File("D:\\recode.txt");
        if(f.exists()) {
            f.delete();
        }

        File f3 = new File("D:\\redeemCode.txt");
        if(f3.exists()) {
            f3.delete();
        }
        f.createNewFile();
        BufferedWriter bufferedWriter = new BufferedWriter(new FileWriter(f));
        BufferedWriter bufferedWriter3 = new BufferedWriter(new FileWriter(f3));
        StringBuilder sBuilder = new StringBuilder();
        sBuilder.append("insert into t_user_redeem_code (id,redeem_code,redeem_time,redeem_status,create_time,update_time,redeem_activity_id,redeem_activity_name,remain_redeem_time,free_day,redeem_code_type) values ");
        for (int i = base; i < base+toNum; i++) {
            sBuilder.append("(");
            sBuilder.append(i);
            sBuilder.append(",");
            sBuilder.append("'");
            String randomChar = getRandomChar(i);
            bufferedWriter3.write(randomChar);
            bufferedWriter3.write("\r\n");
            sBuilder.append(randomChar);
            sBuilder.append("'");
            sBuilder.append(",72000,0,now(),now(),23,'1200分钟兑换码',72000,365,0),");
        }
        bufferedWriter.write(sBuilder.substring(0,sBuilder.length()-1));
        bufferedWriter.close();
        bufferedWriter3.close();
    }


    private static String getRandomChar(int index) {
        //char startChar = 'a';
        String startChar = "wdnmd";

        Random random = new Random();
        StringBuilder sBuilder = new StringBuilder();
/*        for (int i = 0; i < 6; i++) {
            sBuilder.append((char)(startChar+random.nextInt(26)));
        }*/
        sBuilder.append((String)(startChar));
        sBuilder.append(index);
        return sBuilder.toString();
    }
}