国产成人精品亚洲777人妖,欧美日韩精品一区视频,最新亚洲国产,国产乱码精品一区二区亚洲

您的位置:首頁(yè)技術(shù)文章
文章詳情頁(yè)

mybatis and,or復(fù)合查詢操作

瀏覽:168日期:2023-10-21 11:17:12

要查詢的sql:

select * from user where name = ? and (age=? or city=?);

方法1:不使用Example查詢

直接在usermapper.xml中修改sql

方法2:使用Example查詢

sql可轉(zhuǎn)換成

select * from user where (name = ? and age=?) or (name=? and city=?);

然后使用Example查詢

UserExample example=new UserExample();example.or().orAgeLike('%'+searchParam+'%').andNameEqualTo(userName);example.or().orCityLike('%'+searchParam+'%').andNameEqualTo(userName);

補(bǔ)充知識(shí):MySQL/Mybatis多個(gè)AND和OR混用注意事項(xiàng)

mysql中AND的優(yōu)先級(jí)高于OR,所以在查詢時(shí),會(huì)優(yōu)先執(zhí)行AND條件,除非使用()來(lái)將一個(gè)AND和OR括起來(lái),這樣才能使得OR得以按照語(yǔ)句的順序執(zhí)行。

如下圖所示:

mybatis and,or復(fù)合查詢操作

java測(cè)試代碼

mybatis and,or復(fù)合查詢操作

@Test public void TestMutil(){ Species species = new Species(); ArrayList<String> arrayList = new ArrayList<String>(); arrayList.add('長(zhǎng)喙蚤'); arrayList.add('尤氏'); List<Species> querySpeciesesListByMutilCondition = this.speciesMapper.querySpeciesesListByMutilCondition(arrayList, species.getEnglishName(), species.getHost(), species.getPosition(), species.getLocation(), species.getPhylum(), species.getClassName(), species.getOrder(), species.getFamily(), species.getJenus()); for (Species s : querySpeciesesListByMutilCondition) { System.out.println(s); } System.out.println(querySpeciesesListByMutilCondition.size()); }

Mapper文件中沒(méi)有使用()放在語(yǔ)句中執(zhí)行情況

mybatis and,or復(fù)合查詢操作

<select resultType='Species'> SELECT * FROM t_json_species <where> <if test='englisName != null and englisName != ’’'>AND englishName like CONCAT(’%’,#{englishName},’%’) OR sameName like CONCAT(’%’,#{englishName},’%’)</if> <if test='host != null and host != ’’'>AND host like CONCAT(’%’,#{host},’%’)</if> <if test='position != null and position != ’’'>AND position like CONCAT(’%’,#{position},’%’)</if> <if test='location != null and location != ’’'>AND location like CONCAT(’%’,#{location},’%’)</if> <if test='phylumName != null and phylumName != ’’'>AND phylumName = #{phylumName}</if> <if test='className != null and className != ’’'>AND className = #{className}</if> <if test='orderName != null and orderName != ’’'>AND orderName = #{orderName}</if> <if test='familyName != null and familyName != ’’'>AND familyName = #{familyName}</if> <if test='jenusName != null and jenusName != ’’'>AND jenusName = #{jenusName}</if> <if test='nameList != null and nameList != ’’'> <foreach collection='nameList' item='name' >AND name like CONCAT(’%’,#{name},’%’) OR sameName like CONCAT(’%’,#{name},’%’)</foreach> </if> </where> </select>

Mapper文件中使用()放在語(yǔ)句中執(zhí)行情況

mybatis and,or復(fù)合查詢操作

<select resultType='Species'> SELECT * FROM t_json_species <where> <if test='englisName != null and englisName != ’’'>AND englishName like CONCAT(’%’,#{englishName},’%’) OR sameName like CONCAT(’%’,#{englishName},’%’)</if> <if test='host != null and host != ’’'>AND host like CONCAT(’%’,#{host},’%’)</if> <if test='position != null and position != ’’'>AND position like CONCAT(’%’,#{position},’%’)</if> <if test='location != null and location != ’’'>AND location like CONCAT(’%’,#{location},’%’)</if> <if test='phylumName != null and phylumName != ’’'>AND phylumName = #{phylumName}</if> <if test='className != null and className != ’’'>AND className = #{className}</if> <if test='orderName != null and orderName != ’’'>AND orderName = #{orderName}</if> <if test='familyName != null and familyName != ’’'>AND familyName = #{familyName}</if> <if test='jenusName != null and jenusName != ’’'>AND jenusName = #{jenusName}</if> <if test='nameList != null and nameList != ’’'> <foreach collection='nameList' item='name' >AND (name like CONCAT(’%’,#{name},’%’) OR sameName like CONCAT(’%’,#{name},’%’))</foreach> </if> </where> </select>

補(bǔ)充:

如果這里使用多個(gè)%來(lái)解決上述的含有多個(gè)OR和AND情況,那么所實(shí)現(xiàn)功能會(huì)有問(wèn)題,因?yàn)槎鄠€(gè)關(guān)鍵詞有%來(lái)連接,會(huì)有一個(gè)次序問(wèn)題。具體效果見(jiàn)下圖

mybatis and,or復(fù)合查詢操作

以上這篇mybatis and,or復(fù)合查詢操作就是小編分享給大家的全部?jī)?nèi)容了,希望能給大家一個(gè)參考,也希望大家多多支持好吧啦網(wǎng)。

主站蜘蛛池模板: 中超| 扎兰屯市| 独山县| 漳浦县| 神农架林区| 雷山县| 荣成市| 和田县| 巴林左旗| 金门县| 南乐县| 阳谷县| 肥城市| 巫山县| 长兴县| 深泽县| 汝城县| 赤城县| 巴青县| 海淀区| 连城县| 手机| 和平区| 砀山县| 普定县| 千阳县| 磴口县| 土默特左旗| 惠州市| 米易县| 攀枝花市| 韶山市| 全南县| 报价| 合山市| 昆山市| 富民县| 彝良县| 威海市| 鄂托克旗| 南澳县|