阅读下列代码:

<select id="selectByIdAndName"   resultType="Book"

阅读下列代码:

<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