1 第一个例子 select a.*,b.name as repayment_type_value,c.name as status_value, d.product_name, CONCAT(a.duration ,(case a.duration_type when 1 then '天' when 2 then '周' when 3 then '月' when 4 then '年' end)) as jkqx from loan_borrow a , (select * from SYS_DICTIONARIES where P_BM = 'repayment_type') b, (select * from SYS_DICTIONARIES where P_BM = 'status_s') c, loan_product d where b.BIANMA = a.repayment_type and c.BIANMA = a.status and a.product_id=d.product_id and a.id = #{id}select a.*,b.name as repayment_type_val 你的当前访问异常,请进行认证后继续阅读剩余内容。 提交
