<selectid="selectUser"resultType="com.zwei.domain.User">
--SELECT 列名称 FROM 表名称
--SELECT 列名称 FROM 表名称 WHERE 列 运算符 值
select * from user where user_id = #{id}
</select>
<selectid="selectAll"resultType="com.zwei.domain.User">
select * from user;
</select><selectid="selectAll"resultType="com.zwei.domain.User">
select * from user;
</select>
联合查询(需要手动的指定存储的规则)
一对一(一个对象中包含另一个对象)
<resultMapid="selectEvent"type="com.zwei.domain.Event"><!--指定column列的值赋值给property属性--><idproperty="event_id"column="event_id"></id><resultproperty="event_title"column="event_title"></result><resultproperty="event_desc"column="event_desc"></result><!--用指定的column列的值给select二次查询,得到的结果以javaType指定的类型存储赋值给property指定的属性--><associationproperty="user"javaType="com.zwei.domain.User"select="com.zwei.user.selectUser"column="event_id"></association></resultMap><selectid="selectOne"resultMap="selectEvent">
select * from event where event_id = #{event_id};
</select>
<resultMapid="selectUserOne"type="com.zwei.domain.User"><idproperty="user_id"column="user_id"></id><resultproperty="user_account"column="user_account"></result><resultproperty="user_password"column="user_password"></result><!--底层循环查询,每一次查一条,查完一条就组合成一个对象存到集合里,再查询下一条--><collectionproperty="eventList"javaType="java.util.List"ofType="com.zwei.domain.Event"select="com.zwei.event.selectALLByUserID"column="user_id"></collection></resultMap><selectid="selectUser"resultMap="selectUserOne">
select * from user where user_id = #{user_id}
</select>