1. MySQL 存储过程, 这是个复杂查询加上了判断, 比较复杂
Procedure SearchAllList (TradingAreaid varchar (50), CategoryName Varchar (100), Intelligencesort tinyint insigniint, pricebegin double, priceend double, commodityName varchar (200), flag tinyint unsigned) startectb.user_business_id BusinessID, B.Shop_name, B.Total_Score, B.Shop_logo, B.average_consume, d.category_name, b.shop_addressfromuser_business_commodity aleft us user_business b on b.user_business_id = a.user_business_idleft ancation_business on concation CON C. b.user_business_idleft join service_category d on d.category_id = c.category_one_idwhere1 = 1andif (categoryName은 nulland 길이 (trim (categoryName))> 0, d.category_name = CategoryName, 1 = 1) 및 F (PriceBegin! = 0) 및 gricebegen (b.average_consmume)이 아닙니다. 0, b.average_consume <= priceend, 1 = 1) andif (상품 이름은 nulland 길이가 아니다 0group bya.user_business_idorder bycase intelligencessort when when way 1 BusinessID, B.Shop_name, B.Total_Score, B.Shop_logo, B.average_consume, d.category_name, b.shop_addressfromuser_business_commodity aleft us user_business b on b.user_business_id = a.user_business_idleft ancation_business on concation CON C. b.user_business_idleft join service_category d on d.category_id = c.category_two_idwhere1 = 1andif (categoryName은 nulland 길이 (trim (categoryName))> 0, d.category_name = categoryName, 1 = 1) 및 IF (pricebegin! = 0, 1 = 1) and vegin, 1 1) 및 IF (pricebegin, 1) 및 IF 0, b.average_consume <= priceend, 1 = 1) andif (상품 이름은 nulland 길이가 아니다 0group bya.user_business_idorder bycase intelligencessort when when when when when when
2. 查看存储过程是否创建成功 ： ：
절차 상태 표시;
3.sqlmapper ： ：
<select id = "searchAllList1"ParametErmap = "searchAllListMap"stateType = "Callable"resultType = "com.dongjia168.platform.vo.erp.crm.businessshopresp"> call searchAllList (#{tradingAreaid},#{CategoryName},#{intelligencessort},#{priceBegin},#{priceend},#{CommodityName},#{flag}); </선택><parameterMap id = "searchAllListMap"유형 = "com.dongjia168.platform.vo.erp.crm.businessShopReq"> <parameter property = "tradingAreaid"jdbctype = "varchar"mode = "in"/> <parameter property = "categoryname" 속성 = "IntelligenceSt"JDBCTYPE = "Integer"Mode = "in"/> <parameter property = "pricebegin"jdbctype = "double"mode = "in"/> <parameter property = "priceend"jdbctype = "double"mode = "in"/> <parameter property = "jdbctype =" ""jdbctype = ""jdbctype = ""jdbctype = ""jdbctype = ""jdbctype = "" "" "jdbctype =" "jdbctype =" "" "jdbctype =" "/> <parameter propertype =" "in"/> 속성 = "플래그"jdbctype = "Integer"mode = "in"/> </parametermap>
sql l
MyBatis b MySQL 存储过程查询数据实例就是小编分享给大家的全部内容了 存储过程查询数据实例就是小编分享给大家的全部内容了, 希望能给大家一个参考, 也希望大家多多支持武林网。