1.比如:我現(xiàn)在有一個(gè)需求,獲取學(xué)生數(shù)據(jù),根據(jù)學(xué)生主鍵和學(xué)生狀態(tài)查詢數(shù)據(jù)和根據(jù)學(xué)生主鍵和學(xué)生名稱查詢數(shù)據(jù)
我是將這兩個(gè)寫在一個(gè)SQL里去處理,還是寫兩個(gè)SQL分開去處理
表:user 有這些字段id,status,name,age....
根據(jù)需求我是寫兩個(gè)DAO接口,還是寫一個(gè)接口根據(jù)條件篩選查詢數(shù)據(jù)
方法一:
getUser(id, status); select * from user where id ={#id} and status = {#status};
getUser(id, name); select * from user where id ={#id} and name ={#name};

方法二:
getUser(id, status, name);

select * from user where id ={#id}
<if status != null>
and status ={#status}
</if>
<if name != null>

and name = {#name}

</if>