問(wèn)題描述

有如下兩張表

tb_test_paper

字段：test_time , applicant_id

tb_applicant

字段id , id_card(不唯一) , check_status , data_3

其中上表applicant_id與下表id關(guān)聯(lián)

問(wèn)題:兩表關(guān)聯(lián)查詢(xún)，idCard為傳入?yún)?shù)，查詢(xún)出滿(mǎn)足下面三種條件的信息，sql該怎么寫(xiě)？在mybatis中怎么寫(xiě)？

1.id_card=idCard check_status=0

2.id_card=idCard check_status=1 data_3=0

3.id_card=idCard check_status=1 data_3=1 test_time>系統(tǒng)當(dāng)前時(shí)間

問(wèn)題解答

<select parameterType='map'> select * from tb_test_paper tp, tb_applicant ta <where>tp.applicant_id = ta.id<if test='check_status != null and check_status !=’’ '> and ta.check_status = #{check_status }</if><if test='data_3 != null and data_3 !=’’'> and ta.data_3= #{data_3}</if><if test='test_time != null and test_time !=’’'> and tp.test_time= #{test_time}</if> </where></select>