在项目中使用Mybatis

public List<RecordVo> queryList(String workerId, Integer topNum);

<select id="queryList" resultType="com.demo.RecordVo">
    SELECT ID id, WORKER_ID workerId, UPDATE_DATE updateDate
    FROM USER_RECORDS t
    WHERE t.WORKER_ID = #{0}
    LIMIT #{1}
</select>

public Integer queryCountByWorkerId(Map queryParam);

<select id="queryCountByWorkerId" parameterType="java.util.Map"
    resultType="java.lang.Integer">
    SELECT COUNT(1)
    FROM tableName F
    WHERE F.WORKER_ID = #{workerId}
</select>

public Integer queryCountByWorkerId(@param(“workerId”)String workerId);

<select id="queryCountByWorkerId" parameterType="java.util.Map"
    resultType="java.lang.Integer">
    SELECT COUNT(1)
    FROM tableName F
    WHERE F.WORKER_ID = #{workerId}
</select>

<resultMap type="com.demo.DataModule" id="dataModule">
    <result column="ID" property="id" />
    <result column="CREATE_DATE" property="createDate" />
    <result column="WORKERID" property="workerId" />
    <result column="UPDATE_DATE" property="updateDate" />
    <result column="STATUS" property="status" />
</resultMap>

<select id="queryAll" resultType="dataModule">
    select ID,CREATE_DATE,WORKERID from tableName
</select>

<select id="queryAll" resultType="com.demo.DataModule">
    select ID id,CREATE_DATE createDate,WORKERID workerId from tableName
</select>

public class ParamVo {
    private String sql;
    //getter setter 省略
}

/**
* @功能描述: 创建
* @param vo
* @return
*/
public int excuteCreateSql(ParamVo vo);

/**
* @功能描述: 查询
* @param vo
* @return
*/
public List<Map<String, Object>> excuteSelectSql(ParamVo vo);

<update id="excuteCreateSql">
    ${sql}
</update>

<select id="excuteSelectSql" resultType="java.util.Map">
    ${sql}
</select>

<sql id="queryChild">
    FROM tableName1 F
    RIGHT JOIN tableName2 C ON F.WORKER_ID = C.WORKER_ID
    WHERE F.STATUS = 1 AND F.WORKER_ID = #{workerId}
    ORDER BY C.CREATE_DATE DESC
</sql>

<select id="queryCountByWorkerId" parameterType="java.util.Map" resultType="java.lang.Integer">
    SELECT COUNT(1)
    <include refid="queryChild"/>
</select>

<select id="queryListByWorkerId" parameterType="java.util.Map" resultType="com.demo.RecordVo">
    SELECT ID id, WORKER_ID workerId, UPDATE_DATE updateDate,......
    <include refid="queryChild"/>
</select>