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>

注意：結束語句沒有分號或句號等。