【C017001】程序中有一User 对象, 拥有两个字段id,name。下面查询错误的是()。
A.<select id="getUserByID" resultType="com.bean.User" >
Select * from User where id =#{id}
</select>
B.<resultMap class=" com.bean.User" id="User">
<result property="id" column="ID" />
<result property="name" column="NAME" />
</resultMap>
<select id="getUserByID" resultMap=" User" >
Select id,name from User where id =#{id}
</select>
C.<select id="getUserNameByID" resultType="java.lang.String">
Select name from User where id =#id#
</select>
D.<select id="getUserByID" resultType="com.bean.User">
Select name from User where id =#{id}
</select>