列表/分頁查詢 ~~~ @Resource(name = "sqlSessionDao") private Dao dao; //查詢列表，實體類方式 TfNList cond = new TfNList(); cond.setListType("10").asCondition(); List<TfNList> list = dao.selectList(cond); //查詢列表，寫sql方式 List<TfNList> list = dao.selectList("NameListSQL.queryNameList", param); //查詢分頁對象 Pagination pagination = new Pagination(); pagination.setRange(start, pageSize); pagination.setCurrPage(currPage); PageData<TfNList> pageData = dao.selectList("NameListSQL.queryNameList", param, pagination); //獲取分頁列表 List<TfNList> list = pageData.getRows(); //獲取記錄總數 long total = pageData.getTotal(); //對應sql文件 src/main/resources/sql/oracle/namelist/NameListSQL.xml <?xml version="1.0" encoding="UTF-8" ?> <!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd" > <mapper namespace="NameListSQL"> <select id="queryNameList" resultType="com.walk.example.mvc.entity.TfNList"> SELECT A.* FROM TF_N_LIST A <where> <if test="listId != null and listId != ''"> AND A.LIST_ID = #{listId} </if> <if test="listName != null and listName != ''"> AND A.LIST_NAME LIKE #{listName} || '%' </if> <if test="custType != null and custType != ''"> AND A.CUST_TYPE = #{custType} </if> <if test="subCustType != null and subCustType != ''"> AND A.SUB_CUST_TYPE = #{subCustType} </if> </where> </select> </mapper> ~~~