81,092
社区成员
发帖
与我相关
我的任务
分享
public <E> List<E> selectList(String statement, Object parameter, RowBounds rowBounds) {
try {
MappedStatement ms = configuration.getMappedStatement(statement);
List<E> result = executor.<E>query(ms, wrapCollection(parameter), rowBounds, Executor.NO_RESULT_HANDLER);
return result;
} catch (Exception e) {
throw ExceptionFactory.wrapException("Error querying database. Cause: " + e, e);
} finally {
ErrorContext.instance().reset();
}
}
<!-- 根据用户名查找对应的用户 -->
<select id="selectAllUser" parameterClass="com.wmxny.systemwork.entity.StartIndexEntity" resultClass="com.wmxny.systemwork.entity.StartIndexEntity">
<isNotNull property="userName">
<![CDATA[
select 'select ID,User_No as userNo,User_Name as userName from bas_users AND USER_NAME =' + #{userName}# as sqlSyntax
]]>
</isNotNull>
</select>