81,092
社区成员
发帖
与我相关
我的任务
分享
<sqlMap namespace="logger">
<!-- bean配置 -->
<typeAlias alias="LoginQueryLogger" type="com.cs.web.bean.LoginQueryLogger"/>
<typeAlias alias="LoginLogger" type="com.cs.web.bean.LoginLogger"/>
<typeAlias alias="TasksLogger" type="com.cs.web.bean.TasksLogger"/>
<!-- 任务申请日志 -->
<resultMap class="TasksLogger" id="TasksLoggerList" groupBy="loginId">
<result property="loginId" column="login_id" />
<result property="taskNo" column="task_no" />
<result property="taskName" column="task_name" />
<result property="doType" column="type" />
<result property="resNo" column="res_no" />
<result property="applyTime" column="apply_time" />
<result property="startTime" column="start_time" />
<result property="endTime" column="end_time" />
<result property="letupTime" column="letup_time" />
</resultMap>
<!-- 用户登陆日志 -->
<resultMap class="LoginLogger" id="LoginLoggerList" groupBy="loginId">
<result property="loginId" column="login_id" />
<result property="userName" column="user_name" />
<result property="ip" column="ip" />
<result property="loginState" column="login_state" />
<result property="date" column="date" />
<result property="tasksLogger" resultMap="logger.TasksLoggerList"/>
</resultMap>
<!-- 查询所有的日志记录 -->
<select id="findAllLogger" resultMap="logger.LoginLoggerList">
SELECT a.login_id as loginId,
a.user_name as userName,
a.ip as ip,
a.login_state as loginState,
a.date as date,
b.task_no as taskNo,
b.task_name as taskName,
b.type as doType,
b.res_no as resNo,
b.apply_time as applyTime,
b.submit_time as submitTime,
b.start_time as startTime,
b.end_time as endTime,
b.letup_time as letupTime
FROM T_LOGIN_LOGGER a
LEFT OUTER JOIN T_TASKS_LOGGER b ON a.login_id = b.login_id
</select>