1. 创建 mysql 存储过程 ， 这是个复杂查询加上了判断 ， 比较复杂
إنشاء إجراءات SearchAlllist (في Tradingareaid varchar (50) ، في فئة Varchar (100) ، في الذكاء TinyInt غير موقعة ، في PriceBegin double ، في Priceend Double ، في commodityname varchar (200) ، في العلم tinyint غير مُوقّع). BusinessId ، B.Shop_Name ، B.Total_Score ، B.Shop_Logo ، B.Average_Consume ، D.Category_Name ، B.Shop_AddressFromuser_Business_Commodity aleft aleft user_business b on b.user_business_id = a.user_business_idleft b.user_business_idleft join service_category d on d.category_id = c.category_One_idwhere1 = 1andif (الفئة ليست nulland طول (trim (categoryname))> 0 ، d.category_name = categoryname ، 1 = 1) andif (pricebegin! = 0 ، b.average_consue> 0. 0group bya.user_business_idorder bycase Intellignesortwhen 1 then'b.total_order desc'when 2 then'b.total_score desc'when 3 then'b.create_time desc'else'b.create_time asc'end ؛ elseselectb.user_bus. BusinessId ، B.Shop_Name ، B.Total_Score ، B.Shop_Logo ، B.Average_Consume ، D.Category_Name ، B.Shop_AddressFromuser_Business_Commodity aleft aleft user_business b on b.user_business_id = a.user_business_idleft b.user_business_idleft join service_category d on d.category_id = c.category_two_idwhere1 = 1andif (فئة غير Nulland (trim (categoryname))> 0 ، d.category_name = categoryname ، 1 = 1) و pricebegin! = 0 ، b. 0. 0group bya.user_business_idorder bycase knomencesortwhen 1 then'b.total_order desc'when 2 then'b.total_score desc'when 3 then'b.create_time desc'else'b.create_time asc'end ؛ end ؛ end ؛
2. ： ：
إظهار حالة الإجراء ؛
3.SQLMAPPER ：
<حدد ID = "SearchAllList1" parametermap = "searchAllListMap" stateTyType = "callable" resultType = "com.dongjia168.platform.vo.erp.crm.businessshopresp"> call SearchAllList (#{tradingareaid} ،#{categoryName} ،#{knowencesort} ،#{priceBegin} ،#{priceend} ،#{commodityname} ،#{flag}) ؛ </select><parameTermap id = "searchAllListMap" type = "com.dongjia168.platform.vo.erp.crm.businessshopreq"> <parameter property = "tradingareaid" property = "intelligencesort" jdbctype = "integer" mode = "in"/> <parameter property = "priceBegin" jdbctype = "double" mode = "in"/> <parameter property = "priceend" jdbctype = "double" mode = in property = "flag" jdbctype = "integer" mode = "in"/> </parmetermap>
其他和直接调用 SQL 语句一样了
mybatis 应用 mysql 存储过程查询数据实例就是小编分享给大家的全部内容了 ， 希望能给大家一个参考 ， 也希望大家多多支持武林网。