MyBatis Bind标签
来源:互联网 发布:seo常用工具 编辑:程序博客网 时间:2024/04/27 20:05
<select id="countByParams" parameterType="map" resultType="int">
<bind name="item_endStatus" value="@com.mediacross.iforce.common.consts.ItemStatus@ITEM_END.value"/>
<bind name="item_overStatus" value="@com.mediacross.iforce.common.consts.ItemStatus@ITEM_OVER.value"/>
select count(1)
from
rv_client c,
(
select f.can_audit_contactname,i.itemid,i.clientid,i.userid,i.itemname,
i.workno,i.starttime,i.endtime,i.totalbudget,i.created ,
i.updated,i.status,i.step,i.nextstep FROM
(
where f.itemid = i.itemid and f.step = i.step
) p
where c.clientid = p.clientid
<bind name="item_endStatus" value="@com.mediacross.iforce.common.consts.ItemStatus@ITEM_END.value"/>
<bind name="item_overStatus" value="@com.mediacross.iforce.common.consts.ItemStatus@ITEM_OVER.value"/>
select count(1)
from
rv_client c,
(
select f.can_audit_contactname,i.itemid,i.clientid,i.userid,i.itemname,
i.workno,i.starttime,i.endtime,i.totalbudget,i.created ,
i.updated,i.status,i.step,i.nextstep FROM
(
select r.itemid ,r.step,us.contact_name as can_audit_contactname from erp_item r ,erp_users us where r.userid= us.user_id and r.status in (
#{item_endStatus},#{item_overStatus})
) f,rv_item iwhere f.itemid = i.itemid and f.step = i.step
) p
where c.clientid = p.clientid
</select>
0 1
- MyBatis Bind标签
- mybatis bind 标签
- MyBatis中Like语句中使用bind标签
- MyBatis中使用bind标签构造模糊查询失败的解决方法
- MyBatis标签
- MyBatis标签
- MyBatis标签
- mybatis标签
- mybatis bind 插入不同表
- 使用bind标签创建变量
- v-bind 绑定标签属性
- bind 绑定标签的用法
- 使用<spring:bind>标签绑定验证数据
- 使用ng-bind-html标签 注意事项
- mybatis <foreach>标签
- mybatis 标签详解
- mybatis 标签详解2
- Mybatis常用标签
- OJ 66之日期计算
- Documentation-Date and Time Programming Guide:About Dates and Times
- oracle 存储过程异常处理
- 架构师面试题参考
- IOS应用程序生命周期(前后台切换,应用的各种状态)详解
- MyBatis Bind标签
- 重做日志文件
- ASP.NET 的模态窗体的处理
- memcache的原理和命中率的总结
- python-用random简单生成大乐透和双色球彩票
- winform下使用Log4net(精简版)
- Java 接口和抽象类区别
- ognl概念和原理详解
- gcc -l参数和-L参数