10 2018 档案
摘要:@Query(value="SELECT c.byname as byname, c.cart as cart,c.phone as phone,c.surname as surname, c.id as id,c.update_time as updateTime,c.head_img as he
阅读全文
摘要:以Mysql数据库为例。在存储过程中使用判断一个参数,例参数为vtitleSelect a.*from trn_res_courseware awhere 1 = 1 andIF (vtitle is NULL, 0 = 0, a.title like CONCAT('%'+vtitle+'%'))
阅读全文