导出数据

Jinquan_Ou

2023-03-18 c8aea93bb0abfa8b118b631c1edf74c031386b7e

 ruoyi-admin/src/test/java/com/ruoyi/generatorTest.java

@@ -20,8 +20,8 @@
    @Test
    public void test01() {
        //创建一个代码生成器
        FastAutoGenerator.create("jdbc:mysql://localhost:3306/ruoyi?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8",
                        "root", "123456")
        FastAutoGenerator.create("jdbc:mysql://192.168.88.68:3306/mall_sms?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8",
                        "root", "root")
                //全局配置(GlobalConfig)
                .globalConfig(builder -> {
                    builder.author("ojq") // 设置作者，可以写自己名字
@@ -29,40 +29,33 @@
                            .fileOverride() // 覆盖已生成文件
                            .dateType(DateType.TIME_PACK) //时间策略
                            .commentDate("yyyy-MM-dd") //注释日期
                            .outputDir("F:\\IDEAWorkSpace\\src\\main\\java"); // 指定输出目录，一般指定到java目录
                            .outputDir("F:\\JavaProject\\mail-service\\mall-generator\\src\\main\\java"); // 指定输出目录，一般指定到java目录
                })
                //包配置(PackageConfig)
                .packageConfig(builder -> {
                    builder.parent("com.ojq") // 设置父包名
                            .moduleName("") // 设置父包模块名，这里一般不设置
                            .pathInfo(Collections.singletonMap(OutputFile.mapperXml, "F:\\IDEAWorkSpace\\src\\main\\resources\\com\\ojq\\mapper")); // 设置mapperXml生成路径，这里是Mapper配置文件的路径，建议使用绝对路径
                            .pathInfo(Collections.singletonMap(OutputFile.mapperXml, "F:\\JavaProject\\mail-service\\mall-generator\\src\\main\\resources\\com\\ojq\\mapper")); // 设置mapperXml生成路径，这里是Mapper配置文件的路径，建议使用绝对路径
                })
                //策略配置(StrategyConfig)
                .strategyConfig(builder -> {
//                    builder.addInclude("zf_clean") // 设置需要生成的表名
//                            .addInclude("zf_collection") // 设置需要生成的表名
                            builder.addInclude("z_abroad") // 设置需要生成的表名
                            .addInclude("z_autobiography") // 设置需要生成的表名
                            .addInclude("z_certificate") // 设置需要生成的表名
                            .addInclude("z_child") // 设置需要生成的表名
                            .addInclude("z_dict") // 设置需要生成的表名
                            .addInclude("z_experience") // 设置需要生成的表名
                            .addInclude("z_health_base") // 设置需要生成的表名
                            .addInclude("z_health_habit") // 设置需要生成的表名
                            .addInclude("z_health_info") // 设置需要生成的表名
                            .addInclude("z_honor") // 设置需要生成的表名
                            .addInclude("z_idea") // 设置需要生成的表名
                            .addInclude("z_info_user") // 设置需要生成的表名
                            .addInclude("z_login_user") // 设置需要生成的表名
                            .addInclude("z_marry") // 设置需要生成的表名
                            .addInclude("z_property") // 设置需要生成的表名
                            .addInclude("z_secret") // 设置需要生成的表名
                            .addInclude("z_self_note") // 设置需要生成的表名
                            .addInclude("z_stay_out") // 设置需要生成的表名
                            .addInclude("z_travel_base") // 设置需要生成的表名
                            .addInclude("z_travel_price") // 设置需要生成的表名
                            .addInclude("z_year_health") // 设置需要生成的表名
                            .addInclude("z_year_info"); // 设置需要生成的表名
                    builder.addInclude("sms_coupon") // 设置需要生成的表名
                            .addInclude("sms_coupon_history") // 设置需要生成的表名
                            .addInclude("sms_coupon_spu_category_relation") // 设置需要生成的表名
                            .addInclude("sms_coupon_spu_relation") // 设置需要生成的表名
                            .addInclude("sms_home_adv") // 设置需要生成的表名
                            .addInclude("sms_home_subject") // 设置需要生成的表名
                            .addInclude("sms_home_subject_spu") // 设置需要生成的表名
                            .addInclude("sms_member_price") // 设置需要生成的表名
                            .addInclude("sms_seckill_promotion") // 设置需要生成的表名
                            .addInclude("sms_seckill_session") // 设置需要生成的表名
                            .addInclude("sms_seckill_sku_notice") // 设置需要生成的表名
                            .addInclude("sms_seckill_sku_relation") // 设置需要生成的表名
                            .addInclude("sms_sku_full_reduction") // 设置需要生成的表名
                            .addInclude("sms_sku_ladder") // 设置需要生成的表名
                            .addInclude("sms_spu_bounds"); // 设置需要生成的表名


                    builder.serviceBuilder()
@@ -71,7 +64,7 @@
                    builder.controllerBuilder()
                            .enableRestStyle(); // 开启生成@RestController 控制器，不配置这个默认是Controller注解，RestController是返回Json字符串的，多用于前后端分离项目。
                    builder.mapperBuilder()
                            .enableMapperAnnotation() ;//开启 @Mapper 注解，也就是在dao接口上添加一个@Mapper注解，这个注解的作用是开启注解模式，就可以在接口的抽象方法上面直接使用@Select和@Insert和@Update和@Delete注解。
                            .enableMapperAnnotation();//开启 @Mapper 注解，也就是在dao接口上添加一个@Mapper注解，这个注解的作用是开启注解模式，就可以在接口的抽象方法上面直接使用@Select和@Insert和@Update和@Delete注解。
                })
//                .templateEngine(new FreemarkerTemplateEngine()) // 使用Freemarker引擎模板，默认的是Velocity引擎模板
                .templateEngine(new VelocityTemplateEngine())