//方式一
//java
System.out.println("------ selectUserByParamIndex ------");
user = userMapper.selectUserByParamIndex(31, "ConstXiong1");
System.out.println(user);
//xml
<select id="selectUserByParamIndex" resultType="constxiong.po.User">
select * from user where id = #{arg0} and name = #{arg1}
</select>
//方式二
//java
System.out.println("------ selectUserByAnnotation ------");
user = userMapper.selectUserByAnnotation(31, "ConstXiong1");
System.out.println(user);
//xml
<select id="selectUserByAnnotation" resultType="constxiong.po.User">
select * from user where id = #{id} and name = #{name}
</select>
//方式三
//java
System.out.println("------ selectUserByPo ------");
user = userMapper.selectUserByPo(new User(31, "ConstXiong1"));
System.out.println(user);
//xml
<select id="selectUserByPo" resultType="constxiong.po.User" parameterType="constxiong.po.User">
select * from user where id = #{id} and name = #{name}
</select>
//方式四
//java
System.out.println("------ selectUserByMap ------");
Map<String, Object> param = new HashMap<>();
param.put("id", 31);
param.put("name", "ConstXiong1");
user = userMapper.selectUserByMap(param);
System.out.println(user);
//xml
<select id="selectUserByMap" resultType="constxiong.po.User">
select * from user where id = #{id} and name = #{name}
</select>
打印结果
------ selectUserByParamIndex ------
User{id=31, name='ConstXiong1', mc='null'}
------ selectUserByAnnotation ------
User{id=31, name='ConstXiong1', mc='null'}
------ selectUserByPo ------
User{id=31, name='ConstXiong1', mc='null'}
------ selectUserByMap ------
User{id=31, name='ConstXiong1', mc='null'}