1. 创建 mysql 存储过程 这是个复杂查询加上了判断 这是个复杂查询加上了判断 ， 比较复杂
Создать процедуру SearchAllList (в TradingAreAd Varchar (50), в категории varchar (100), в Intelligencesort tinyint unsigned, в Pricebegin Double, в Priceend Double, в CommodityName varchar (200), в флаге Tinyint Unsigned) flag = 0 thenselectb.user_business_id BusinessId, B.Shop_Name, B.Total_Score, B.Shop_Logo, B.Aguer_Consume, D.Category_Name, B.Shop_AddressFromuser_business_commodity aleft join user_business b on b.user_business_id = a.user_business_idleft join_business_cagyness_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 (категория))> 0, d.category_name = CategoryName, 1 = 1) andif (цена! 0, b.average_consume <= цена, 1 = 1) andif (CommodityName не является длиной Nulland (Trim (CommodityName))> 0, A. Имя как compat ('%', CommodityName, '%'), 1 = 1) и B.is_delete = 0 и B.shop_setup_State = 1 и A.IsE_DELETE = 0ANTETE = 0DISIS_DISE_DIS_DIS_DIS_DIS_DIS_DIS_DIS_DIS_DIS_DIS_DIS_DIS_STELEP_STATE 0group bya.user_business_idorder bycase intelligencesorthen 1 Then'b.total_ord BusinessId, B.Shop_Name, B.Total_Score, B.Shop_Logo, B.Aguer_Consume, D.Category_Name, B.Shop_AddressFromuser_business_commodity aleft join user_business b on b.user_business_id = a.user_business_idleft join_business_cagyness_business_id = a.user_business_idleft B.USER_BUSINESS_IDLEFT JOIN SERVICE_CATEGORY D ON D.Category_ID = C.Category_TWO_IDWHERE1 = 1ANDIF (CategoryName не является nulland длина (trim (категория))> 0, d.category_name = categoryname, 1 = 1) и иф (цена! 0, b.average_consume <= цена, 1 = 1) andif (CommodityName не является длиной Nulland (Trim (CommodityName))> 0, A. Имя как compat ('%', CommodityName, '%'), 1 = 1) и B.is_delete = 0 и B.shop_setup_State = 1 и A.IsE_DELETE = 0ANTETE = 0DISIS_DISE_DIS_DIS_DIS_DIS_DIS_DIS_DIS_DIS_DIS_DIS_DIS_DIS_STELEP_STATE 0group bya.user_business_idorder bycase intelligencesorthen 1 then'b.total_order desc'hen 2 then'b.total_score desc'hen 3 then'b.create_time desc'else'b.create_time asc'end; end if; end;2. 查看存储过程是否创建成功 ：
Показать статус процедуры;
3.sqlmapper 文件 ：
<select id = "searchalllist1" parametermap = "searchalllistmap" atportiontype = "callable" outdettype = "com.dongjia168.platform.vo.erp.crm.businessshopresp"> Call SearchAllList (#{TradingAReaID},#{CategoryName},#{Intelligencesort},#{PriceBegin},#{Priceend},#{CommoDityName},#{flag}); </select><parametermap id = "searchalllistmap" type = "com.dongjia168.platform.vo.erp.crm.businessshopreq"> <parameter property = "tradingareAid" jdbctype = "varcharch" mode = "in"/> <parameter property = "categorynam property="intelligenceSort" jdbcType="INTEGER" mode="IN"/> <parameter property="priceBegin" jdbcType="DOUBLE" mode="IN"/> <parameter property="priceEnd" jdbcType="DOUBLE" mode="IN"/> <parameter property="commodityName" jdbcType="VARCHAR" mode="IN"/> <parameter свойство = "flag" jdbctype = "integer" mode = "in"/> </parametermap>
其他和直接调用 SQL 语句一样了
以上这篇 mybatis 应用 mysql 存储过程查询数据实例就是小编分享给大家的全部内容了 ， 希望能给大家一个参考 也希望大家多多支持武林网。 也希望大家多多支持武林网。