/**
* #号
* @param username1
* @return
*/
User queryUserListByName1(@Param("username1") String username1);
/**
* $号
* @param username2
* @return
*/
User queryUserListByName2(@Param("username2") String username2);
<select id="queryUserListByName1" resultType="com.zpc.mybatis.pojo.User">
select * from tb_user WHERE user_name=#{username1}
</select>
<select id="queryUserListByName2" resultType="com.zpc.mybatis.pojo.User">
select * from tb_user WHERE user_name='${username2}'//手动加了引号
</select>
<resultMap id="result" type="com.sang.entity.User">
<result property="name" column="name"></result>
<result property="password" column="password"></result>
<result property="number" column="number"></result>
</resultMap>
<!--
<resultMap id="给ID名" type="实体类" >
<result property="实体类属性" column="数据库字段名" jdbcType="数据库字段类型" />
</resultMap>
-->
<!--查询所有语句-->
<!--id
在MyBatis中,mapper接口中的抽象方法名,必须和*mapper.xml文件配置中的select标签的ID属性名相同
-->
<select id="ListUser" resultMap="result">
SELECT * from user
</select>
<!-- 3. resultType (resultType 与 resultMap 二选一配置)
resultType用以指定返回类型,指定的类型可以是基本类型,可以是java容器,也可以是javabean -->
<select id="findUserByName" resultMap="result">
select * from user where name=#{name}
</select>