阅读下列代码:
<select id="selectByIdAndName" resultType="Book" >
SELECT * FROM book WHERE 1=1
<choose>
<when test ="bId != null and bId > 0 "> and bid= #{bId}</when >
<when test ="bName != null and bName !='' ">
and bName = #{bName}
</when>
<otherwise>and 1 = 2</otherwise>
</choose>
</select>
如果bId为2,bName为“童年”,则最终SQL语句为()?
A.
SELECT * FROM book WHERE 1=1
B.
SELECT * FROM book WHERE 1=1 and bId=2
C.
SELECT * FROM book WHERE 1=1 and bId=2 and bName=’童年’
D.
SELECT * FROM book WHERE 1=1 and bName=’童年’
正确答案是B