1.如果数据库和pojo的属性名都是一样的话可用如下方式
<select id ="getUser" resultType="org.guarx.domain.User" parameterType="java.lang.String">
select * from users where id=#{value}]]>
</select>
<select id="getUsers" resultType="org.guarx.domain.User">
select * from users]]>
</select>
大多数情况下属性名称都不一样
有如下2种方式
1)<select id="getUsers" resultType="org.guarx.domain.User">
<![CDATA[
select t_id as id,t_username as name,t_desc as description from users
]]>
</select>
2)<resultMap type="org.guarx.domain.User" id="userMapper">
<result column="t_id" property="id"/>
<result column="t_username" property="username"/>
<result column="t_desc" property="description"/>
</resultMap>
<select id="getAll" resultMap="userMapper">
<![CDATA[
select id,username,description from users
]]>
</select>