SELECT pwd.id,pwd.rules_details, pwd.choose_type,pwd.priority_level, pwd.'status',( SELECT GROUP_CONCAT(t.package_name) FROM ( SELECT CASE package_structure WHEN 0 THEN '单品单件' WHEN 1 THEN '单品多件' WHEN 2 THEN '多品多件' WHEN 3 THEN '多品多件' ELSE '其他' END package_name FROM product_wavetime_detail_packagestructure WHERE wavetime_detail_id=pwd.id )t )package_structure FROM product_wavetime_detail pwd WHERE pwd.wavetime_id=#{id} ORDER BY pwd.id DESC;
BUG:idea编码没改【utf-8】会报各种错误
总结:对简单业务中的增删改查有了一定的了解,但是对一些有一点复杂的业务自己还是写不出想不到,彦斌哥和静姐对我都特别好,知道我是培训出来的,谢谢静姐和彦斌哥,彦斌哥解决问题的时候是真的帅我好喜欢,你随时可以走,别浪费时间金钱,需要不断的学习,谢谢hongcangyida