isNull判断property字段是否是null,用isEmpty更方便,包含了null和空字符串
例子一:
isEqual相当于equals,数字用得多些,一般都是判断状态值
<isEqual property="state" compareValue="0">
< /isEqual>
或
<isEqual property="state" compareProperty="nextState">
< /isEqual>
例子一:
传入的map或者类的属性name等于"1"吗,是就附加and和vvvv = '哈哈'
<isEqual property="name" compareValue="1" prepend="and">
vvvv = '哈哈'
< /isEqual>
传入的map或者类的属性name是null吗,是就附加and和vvvv = null
< isNull property="name" prepend="and">
vvvv = null
< /isNull>
我的应用:
###说明
1.
功能描述
用户可自行设置部分非重要弹出公告的设置。
2.
功能需求
1)
允许用户自行屏蔽“返销公告”,“银行存款通知”,“在线存款通知”三种类型公告。
2)
可在以上三种公告弹出页面上使用复选框设置不再通知此类公告。
3.
界面需求
1)
弹出公告页:
在“返销公告”(
25
),“银行存款通知”(
63
)及“在线存款通知”(
64
)三种类型公告页面上增加复选框“不再弹出此类公告”。
2)
公告提示设置:
可直接对以上三种公告进行屏蔽设置(开启
10|
关闭11)。
4.
业务流程
5.
逻辑需求
用户存储屏蔽状态存储于
t_bussiness_set
中的“返销公告屏蔽”(
sale_back
),“银行存款通知”(
remittance_bank
),“在线存款通知”(
remittance_online
)字段。
6.
性能需求
7.
相关模块
8.
数据库相关表
1)
T_bussiness_set
商户设置表
2)
T_notice
公告表
1.sqlMap
<select id="querySingleModelByOut" parameterClass="com.hanpeng.base.phone.model.TBussinessNotice"
resultClass="com.hanpeng.base.phone.model.TBussinessNotice">
select * from (select row_.*, rownum rownum_ from (
SELECT
i.NOTICE_NUM as noticeNum ,
i.BUSSINESS_ID as bussinessId ,
i.STATE as state ,
i.READ_DATE as readDate ,
n.NOTICE_TITLE as noticeTitle ,
n.NOTICE_INFO as noticeInfo ,
n.CREATE_DATE as createDate ,
n.EMPLOYEE_ID as employeeId ,
n.NOTICE_TYPE as noticeType ,
n.NOTICE_SHOW_TYPE as noticeShowType ,
n.FINISH_DATE as finishDate ,
n.PUBLISH_DATE as publishDate
FROM T_BUSSINESS_NOTICE i left join T_NOTICE n on n.NOTICE_NUM = i.NOTICE_NUM
WHERE
n.PUBLISH_DATE <= sysdate AND n.FINISH_DATE >= sysdate
<isNotEmpty prepend=" AND " property="bussinessId">
i.BUSSINESS_ID = #bussinessId# </isNotEmpty>
<isNotEmpty prepend=" AND " property="state">
i.STATE = #state# </isNotEmpty>
<isNotEmpty prepend=" AND " property="noticeShowType">
n.NOTICE_SHOW_TYPE = #noticeShowType# </isNotEmpty>
<isEqual property="saleBack" compareValue="10" prepend=" AND ">
n.NOTICE_TYPE!='25'</isEqual>
<isEqual property="remittanceBank" compareValue="10" prepend=" AND ">
n.NOTICE_TYPE!='63'</isEqual>
<isEqual property="remittanceOnline" compareValue="10" prepend=" AND ">
n.NOTICE_TYPE!='64'</isEqual>
)row_ where rownum <=1 ) where rownum_>=0
</select>
2.Action
/**
* 查询公告弹出
* @return
* @author wwy
* @date 2011-10-13 下午13:35:11
*/
public void queryByOut(){
try {
PrintWriter out = this.getResponse().getWriter();
if(getUserId() != null){
bussinessNotice = noticeService.selectSingleModelByOut("26",getUserId());
if(bussinessNotice==null){
out.print("");
}
else{
out.print("{\"noticeNum\":\""+bussinessNotice.getNoticeNum()+"\"}");
}
}else{
out.print("");
}
} catch (Exception e) {
log.error("弹出式公告查询失败" + e.fillInStackTrace());
}
}
3.serviceImpl
public TBussinessNotice selectSingleModelByOut(String state,
String bussinessId) {
TBussinessNotice tbn = new TBussinessNotice();
tbn.setBussinessId(bussinessId);
tbn.setState("17");
tbn.setNoticeShowType(state);
TBussinessSet bussinessSet = BussinessSetService.queryById(bussinessId);//设置状态,sqlMap根据状态isEqual判断
tbn.setSaleBack(bussinessSet.getSaleBack());
tbn.setRemittanceBank(bussinessSet.getRemittanceBank());
tbn.setRemittanceOnline(bussinessSet.getRemittanceOnline());
return bussinessNoticeDao.selectSingleModelByOut(tbn);
}
4.frameTop.jsp
<script type="text/javascript">
//弹出公告查询
var autoNotice = setInterval(getNotice,1000*60);
function getNotice(){
clearInterval(autoNotice);
$.ajax({
type:'post',
url:'Notice_queryByOut',
dataType:'json',
success:function(data){
if(data!=null){
$.hpDialog.open('Notice_detailByNotice?initLoadMethod=c&id='+data.noticeNum);
}else{
autoNotice = setInterval(getNotice,1000*60);
}
}
});
}
function noticeCallback(){
getNotice();
}
</script>
5.noticeDetail.jsp
<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title>公告明细</title>
<meta http-equiv="X-UA-Compatible" content="IE=7" />
<%@ include file="/cssBasePage.jsp"%>
<script type="text/javascript" src="<%=path %>/jsp/phone/interaction/notice/noticeDetail.js"></script>
</head>
<body>
<form id="form1">
<div class="jf_tanchu">
<div class="jf_tanchutit">${ bussinessNotice.noticeTitle}</div>
<div class="jf_tanchubox">
<div class="jf_tanchubox_right">
公告类型:<v:dcolor code="${ bussinessNotice.noticeType}"/>
发布时间:<fmt:formatDate value="${ bussinessNotice.createDate}" pattern="yyyy-MM-dd"/>
</div>
${bussinessNotice.noticeInfo}
</div>
</div>
<s:if test="bussinessNotice.noticeType=='25'||bussinessNotice.noticeType=='63'||bussinessNotice.noticeType=='64'">
<div>
<input type="hidden" name="noticeType" value="${bussinessNotice.noticeType}"/>
<input type="checkbox" id="isSelect" name="isSelect" value="${bussinessNotice.noticeType}" onclick="javascript:noTips();"/>
<label for="isSelect">不再通知此类公告</label>
</div>
</s:if>
</form>
<div class="jf_tanchubot">
<s:if test="initLoadMethod == \"c\" ">
<hp:HpButton TJsClick="var win = $.dialog.open.origin;win.noticeCallback();$.dialog.close();" TValue="confirmed" id=""></hp:HpButton>
</s:if>
<s:else>
<hp:HpButton TJsClick="$.dialog.close();" TValue="close" id=""></hp:HpButton>
</s:else>
</div>
</body>
</html>
6.noticeDetail.js
function noTips(){
var formParam = $("#form1").serialize();
$.ajax({
type:'post',
url:'Notice_noTipsNotice',
data:formParam,
cache:false,
dataType:'json',
success:function(data){
}
});
}
分享到:
相关推荐
ELEMENT dynamic (#PCDATA | include | iterate | isParameterPresent | isNotParameterPresent | isEmpty | isNotEmpty | isNotNull | isNull | isNotEqual | isEqual | isGreaterThan | isGreaterEqual | ...
ibatis使用指南
ibatis学习 ibatis总结 ibatis ibatis ibatis
学会ibatis 中sqlMap配置
通过Ibatis3xml文件配置+Mysql实现数据批量插入,原先在网上找很多,都是关于批量更新,批量插入的很少,而且其写法又完全不同,所以自己研究了一下。可供参考。另外插入时如出现内容报错,请参照my.cnf修改书库配置...
ibatis官方中文文档.rar包含ibatis官方中文文档及使用说明
ibatis 拼接字符串
ibatis资料ibatis资料ibatis资料ibatis资料ibatis资料ibatis资料ibatis资料ibatis资料ibatis资料
ibatis2.0中文API ibatis2.0中文API ibatis2.0中文API 一对多 多对一详解,属性设置详解,解决方案详解,ibatis2.0核心API
ibatis3.0中in的用法ibatis3.0中in的用法ibatis3.0中in的用法ibatis3.0中in的用法
ibatis 乱码解决 ibatis乱码 gbk iso_8859_1 乱码
ibatis demo,ibatis例子,ibatis示例
iBATIS 级联iBATIS 级联iBATIS 级联
iBatis工程的简单例子,在eclipse上实现的,数据库是mysql数据库,里面的字段为CREATE DATABASE MYDB; use MYDB; Drop TABLE IF EXISTS `MYDB`.`student`; Create TABLE `MYDB`.`student` ( `name` varchar(40) NOT...
ibatis 中文手册,介绍了ibatis map sql的重要特性
ibatis的原码 ibatis源码 ibatis源码 ibatis源码
ibatis
ibatis中文api,很详细。
iBatis中文教程 iBatis中文教程 iBatis中文教程 iBatis中文教程 iBatis中文教程
ibatis中使用安全的拼接语句,动态查询,大于、小于、等于.doc