mybatis 查询select语句

还是以用户模块为例

首先要配置一个返回的结果集

 <resultMap  type="com.deppon.myDeppon.module.user.shared.domain.User" id="userMap">
  <id property="id" column="FID" />
  <result property="userName" column="FUSERNAME" />
  <result property="password" column="FPASSWORD" />
  <result property="email" column="FEMAIL" />
  <result property="realName" column="FREALNAME" />
  <result property="gender" column="FSEX" />
  <result property="telephone" column="FMOBILE" />
  <result property="fixedPhone" column="FTELEPHONE" />
  <result property="deptId" column="FSERVDEPTID" />
  <result property="status" column="FAUDITSTATUS" />
  <result property="lastLoginTime" column="FLASTLOGINTIME" />
  <result property="regiterTime" column="FCREATETIME" />
  <result property="city" column="FCITY"/>
  <result property="address" column="FADDRESS"/>
  <result property="lastUpdateTime" column="FLASTUPDATETIME"/>
  <result property="procity" column="FCITY"/>

  <result property="cusCode" column="FCUSCODE"/>
  <result property="custSourceId" column="FCUSTSOURCEID"/>

 </resultMap>

其次编写sql

 <!-- 根据用户名和密码查找用户（登录） -->
 <select id="findUserByName" parameterType="com.deppon.myDeppon.module.user.shared.domain.User" resultMap="userMap">
  SELECT cus.FID,cus.FUSERNAME,cus.FPASSWORD,cus.FEMAIL,cus.FREALNAME,
      cus.FSEX,cus.FMOBILE,cus.FTELEPHONE,cus.FSERVDEPTID,FCUSCODE,
      cus.FAUDITSTATUS,cus.FLASTLOGINTIME,cus.FCREATETIME,
      cus.FCITY,cus.FADDRESS,cus.FLASTUPDATETIME
     FROM t_web_customerinfo cus
     Where cus.FUSERNAME = #{userName} and upper(cus.FPASSWORD) = #{password} 

 </select>

注意：结束语句没有分号或句号等。