编辑代码

//JSRUN引擎2.0,支持多达30种语言在线运行,全仿真在线交互输入输出。
println("Hello world!     -  groovy.jsrun.net")

def info = [
    [
        "adverse_item": null,
        "device_code": null,
        "device_type": null,
        "examine_proj": "达因",
        "factory": "电池箔分厂",
        "inspection_date": "2023-11-29 00:00:00",
        "lot_no": "301423112708-4-2-2",
        "lot_status": null,
        "material_code": "13",
        "material_type": "1060",
        "peculiarity": null,
        "process": "一次合格",
        "production_line": "倒卷机41#",
        "quality_status": "合格",
        "quantity": 36,
        "shipment": null,
        "sort_no": null,
        "updated_time": null,
        "weight": 0.41,
        "workshop": "D2"
    ]
]

def catl_module_fac = new StringBuilder()

// 检查info是否为空
if (info) {
    // 如果info不为空,则对数据库字段进行拼接
    info.eachWithIndex { item, index ->
        // 使用StringBuilder拼接字段
        def concatenatedFields = "('${item.adverse_item ?: ''}','${item.device_code ?: ''}','${item.device_type ?: ''}','${item.examine_proj ?: ''}'," +
                                 "'${item.factory ?: ''}','${item.inspection_date ?: ''}','${item.lot_no ?: ''}'," +
                                 "'${item.lot_status ?: ''}','${item.material_code ?: ''}','${item.material_type ?: ''}','${item.peculiarity ?: ''}'," +
                                 "'${item.process ?: ''}','${item.production_line ?: ''}','${item.quality_status ?: ''}',${item.quantity ?: 0},'${item.shipment ?: ''}','${item.sort_no ?: ''}'," +
                                 "'${item.updated_time ?: ''}',${item.weight ?: 0},'${item.workshop ?: ''}')"
                                
        // 判断是否是第一个元素,如果是则不添加逗号
        if (index != 0) {
            catl_module_fac.append(",")
        }
        
        // 将拼接后的字段添加到catl_module_fac中
        catl_module_fac.append(concatenatedFields)
    }
} else {
    // 如果info为空,则在catl_module_fac中添加一个空拼接
    catl_module_fac.append("('','','','','','','','','','','','','','','','',0,'')")
}

def result = catl_module_fac.toString()

println(result)