tgyd2006
- 浏览: 331284 次
- 性别:
- 来自: 北京
-
文章分类
最新评论
-
y_715：
document.getElementById("e ...
JSTL EC TABLE extremeTable 学习 -
wangyj0898：
学习了。。。
display table 标签用法 -
hejiajie2008：
没有图啊
图解myeclipse把maven普通java项目变成web项目的全程操作 -
zhangyu_2100：
[align=center][/align][color=br ...
request.getRealPath()的替代方法 -
senhui19：
LZ写的真不错呀，现在开发中都经常是用DetachedCrit ...
Hibernate的Criteria用法总结
public List getAllList(String xm, String cjrzh, String area, String hszt,String isydk,
int startnum, int endnum) {
log.debug("finding JdhdTemp instance by example");
String conditionone_temp = "and u.jd_id='" + area + "'";
String conditiontwo_temp = "and u.yxzt='" + hszt + "'";
String conditionthree_temp = "and u.ydk='" + isydk + "'";
String conditionone = (area.equals("")) ? "" : conditionone_temp;
String conditiontwo = (hszt.equals("")) ? "" : conditiontwo_temp;
String conditionthree = (isydk.equals("")) ? "" : conditionthree_temp;
String hql = "SELECT * FROM ( SELECT A. * , ROWNUM RN FROM ( "
+ "select u.xm,u.cjrz_id,u.sfz,u.jd,u.sq,u.yxzt from jdhd_temp u Where u.xm like '%'||'"
+ xm + "'||'%' and u.cjrz_id like '%'||'" + cjrzh + "'||'%' "
+ conditionone + " " + conditiontwo+ " "+conditionthree
+ " order by u.cjrz_id desc" + " ) A WHERE ROWNUM <= "
+ endnum + " ) WHERE RN >= " + startnum;
JdbcTemplate jdbc = new JdbcTemplate(dataSource);
List catList = new ArrayList();
catList = jdbc.queryForList(hql);
log.debug("find by example successful, result size: " + catList.size());
return catList;
}
2.
1.ValueListHandlerHelper vlHandlerHelper = (ValueListHandlerHelper) getBean("vlUnsubmitJdhdHelper");
ValueListInfo info = vlHandlerHelper.getValueListInfo(request);
info.getFilters().putAll(
ValueListRequestUtil.getRequestParameterMap(request));
if (cjrzh != null && !cjrzh.trim().equals("")) {
info.getFilters().remove("cjrzh");
} else {
info.getFilters().remove("cjrzh");
}
conditionHelper(info, "xm", xm);
conditionHelper(info, "cjrzh", cjrzh);
conditionHelper(info, "area", area);
conditionHelper(info, "hszt", hszt);
conditionHelper(info, "isydk", isydk);
ValueList valueList = vlHandlerHelper.getValueList("data", info);
request.setAttribute("dataList", valueList);
private void conditionHelper(ValueListInfo valueListInfo, String key,
String value) {
if (notEmpty(nullToEmpty(value))) {
valueListInfo.getFilters().put(key, value);
} else {
valueListInfo.getFilters().remove(key);
}
}
3.
<%@ taglib uri="http://valuelist.sourceforge.net/tags-valuelist" prefix="vlh"%>
<%@ page import="net.mlw.vlh.ValueList" %>
<vlh:root value="dataList" url="?" includeParameters="*">
<TABLE width="100%" height="20" border="0" cellpadding="0" cellspacing="0">
<TR>
<TD valign="bottom">
共<c:out value="${dataList.valueListInfo.totalNumberOfEntries}" />条记录
(第<c:out value="${dataList.valueListInfo.pagingPage}" />页
共<c:out value="${dataList.valueListInfo.totalNumberOfPages}" />页)
</TD>
<TD align="right">
<vlh:paging pages="5"><c:out value="${page}" /></vlh:paging>
</TD>
<TD align="right" width="90" noWrap><c:if test="${dataList.valueListInfo.totalNumberOfPages>1}">
转到<input text='text' value='<c:out value="${dataList.valueListInfo.pagingPage}" />' size='3' onKeyup='gotoPage(<c:out value="${dataList.valueListInfo.totalNumberOfPages}" />,"<%=basePath%>")'>页</c:if>
</TD>
</TR>
</TABLE>
<TABLE border="0" width="100%" align="center" cellpadding="0" class="tablebg" cellspacing="1">
<tr bgcolor="#66CCFF" height="20">
<td align="center" width="5%"><B>序号</B></td>
<td align="center" width="5%"><B>姓名</B></td>
<td align="center" width="10%"><B>残疾人证号</B></td>
<td align="center" width="20%"><B>家庭住址</B></td>
<td align="center" width="16%"><B>身份证号</B></td>
<td align="center" width="18%"><B>街道</B></td>
<td align="center" width="12%"><B>社区</B></td>
<td align="center" width="8%"><B>核实状态</B></td>
<td align="center" width="5%"><B>操作</B></td>
</tr>
<FORM name="HandicappedInformationForm" METHOD="POST" ACTION="">
<INPUT TYPE="hidden" name="xm" value="">
<INPUT TYPE="hidden" name="area" value="">
<INPUT TYPE="hidden" name="cjrzh" value="">
<INPUT TYPE="hidden" name="hszt" value="">
<INPUT TYPE="hidden" name="JD_ID" value="">
<INPUT TYPE="hidden" name="areaname" value="">
<INPUT TYPE="hidden" name="isydk" value="">
<INPUT TYPE="hidden" name="pagingPage" value="">
<c:forEach items="${dataList}" var="rowData" varStatus="rowNumber">
<TR>
<c:if test="${(rowNumber.count%2)==1}"><TR class="even"></c:if>
<c:if test="${(rowNumber.count%2)==0}"><TR class="odd"></c:if>
<TD align="center"><c:out value="${rowNumber.count}" /></TD>
<TD align="left"><c:out value="${rowData.xm}" /></TD>
<TD align="left"><c:out value="${rowData.cjrz_id}" /></TD>
<TD align="left"><c:out value="${rowData.jtxxzz}" /> </TD>
<TD align="center"><c:out value="${rowData.sfz}" /> </TD>
<TD align="center">
<c:if test="${rowData.jd_id=='000000000'||rowData.jd_id=='000000001'||rowData.jd_id=='000000002'||rowData.jd_id=='000000003'}"><c:out value="${rowData.yjd}" /><c:out value="${rowData.jd}" /></c:if>
<c:if test="${rowData.jd_id!='000000000'&&rowData.jd_id!='000000001'&&rowData.jd_id!='000000002'&&rowData.jd_id!='000000003'}"><c:out value="${rowData.jd}" /></c:if>
</TD>
<TD align="center"><c:out value="${rowData.sq}" /></TD>
<TD align="center">
<c:if test="${(rowData.yxzt)==0}"><font color="green">齐全</font></c:if>
<c:if test="${(rowData.yxzt)==1}"><font color="#FF00FF">不齐全</font></c:if>
<c:if test="${(rowData.yxzt)==2}"><font color="blue">退卡</font></c:if>
<c:if test="${(rowData.yxzt)==3}"><font color="#8B008B">补卡</font></c:if>
<c:if test="${(rowData.yxzt)==4}">死亡确认</c:if>
<c:if test="${(rowData.yxzt)==5}">走失确认</c:if>
<c:if test="${(rowData.yxzt)==6}">迁出确认</c:if>
<c:if test="${(rowData.yxzt)==9}"><font color="red">未审核</font></c:if>
</TD>
<TD align="center">
<a href='#' onclick='modifyHI("<c:out value="${rowData.id}"/>");return false' title="修改" target='_parentblank'><img src="../../images/copy1.gif" border="0"></a>
</TD>
</TR>
</c:forEach>
<IFRAME NAME="VoteMessageFrame" id="VoteMessage" width="100%" height="100%" style="display:none;"
frameBorder="0" marginWidth="0" marginHeight="0" scrolling="auto"
src=""> </IFRAME>
</FORM>
</TABLE>
</vlh:root>
function gotoInputPageNo(inputPageNo, contextPath) {
var frm = document.HandicappedInformationForm;
frm.pagingPage.value=inputPageNo;
frm.target="_self";
var parentForm = window.parent.document.HandicappedInformationForm;
frm.xm.value= parentForm.xm.value;
frm.area.value= parentForm.area.value;
frm.cjrzh.value= parentForm.cjrzh.value;
frm.hszt.value= parentForm.hszt.value;
frm.isydk.value= parentForm.isydk.value;
frm.action= contextPath + '/jdhdTempAction.do?method=areaListInfo';
frm.submit();
}
function gotoPage(totalPage, contextPath) {
if(event.keyCode!=13) {// not press enter-key
return false;
}
if(totalPage==null) {
alert("提示：未提供参数（totalPage ： 总页数），因此使用默认值 1。");
totalPage = 1;
}
if(contextPath==null) {
contextPath = "";
}
var inputPage = event.srcElement.value;
if(inputPage==""){
return false;
}
if(inputPage<1) {
inputPage = totalPage;
}
if(inputPage>totalPage) {
alert("您输入的页数不存在！");
event.srcElement.select();
return false;
}
gotoInputPageNo(inputPage, contextPath);
}
4.<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE beans PUBLIC "-//SPRING//DTD BEAN//EN"
"http://www.springframework.org/dtd/spring-beans.dtd">
<!-- Globle Search Configuration -->
<beans>
<!--½ֵ:˶¨ -->
<bean id="JdhdTempDAO"
class="com.itsv.information.dao.hibernate.JdhdTempDAOHibernate">
<property name="dataSource"><ref bean="dataSource"/></property>
<property name="sessionFactory">
<ref bean="sessionFactory" />
</property>
</bean>
<bean id="jdhdTempManager" parent="txProxyTemplate">
<property name="target">
<bean
class="com.itsv.information.service.impl.JdhdTempManagerImpl">
<property name="jdhdTempDAO">
<ref bean="JdhdTempDAO" />
</property>
</bean>
</property>
</bean>
<bean id="vl_UnsubmitJdhdHandler" singleton="true"
class="net.mlw.vlh.DefaultValueListHandlerImpl">
<property name="config.adapters">
<map>
<entry key="data">
<bean
class="net.mlw.vlh.adapter.jdbc.dynclass.DefaultDynclassAdapter">
<!-- <bean class="net.mlw.vlh.adapter.jdbc.dynabean.DefaultDynaBeanAdapter"> -->
<property name="dataSource">
<ref bean="dataSource" />
</property>
<property name="lowerCase">
<value>true</value>
</property>
<property name="useName">
<value>false</value>
</property>
<property name="defaultNumberPerPage">
<value>25</value>
</property>
<!-- <property name="defaultSortColumn"><value>apply_date</value></property> -->
<!-- <property name="defaultSortDirection"><value>desc</value></property> -->
<property name="sql">
<value>
select
h.ID,h.XM,h.CJRZ_ID,h.SFZ,h.JD,h.JD_ID,h.SQ,h.SQ_ID,h.YXZT,h.YJD,h.YJD_ID,i.jtxxzz
from JDHD_TEMP h ,handicapped_information i where i.info_id = h.id /~xm: and
h.XM like '%'||{xm}||'%' ~/ /~cjrzh: and
h.CJRZ_ID like '%'||{cjrzh}||'%' ~/
/~area: and (h.jd_id={area} or
((h.jd_id = '000000000' or h.jd_id = '000000001'
or h.jd_id = '000000002' or h.jd_id = '000000003') and h.yjd_id={area})) ~/ /~hszt:
and h.yxzt = {hszt}~/ /~isydk:
and h.ydk = {isydk}~/ /~yjdId:
and h.yjd_id = {yjdId}~/ order by h.YXZT desc , h.CJRZ_ID
desc /~sortColumn: ,[sortColumn]
[sortDirection]~/
</value>
</property>
</bean>
</entry>
<entry key="persondata">
<bean
class="net.mlw.vlh.adapter.jdbc.dynclass.DefaultDynclassAdapter">
<!-- <bean class="net.mlw.vlh.adapter.jdbc.dynabean.DefaultDynaBeanAdapter"> -->
<property name="dataSource">
<ref bean="dataSource" />
</property>
<property name="lowerCase">
<value>true</value>
</property>
<property name="useName">
<value>false</value>
</property>
<property name="defaultNumberPerPage">
<value>25</value>
</property>
<!-- <property name="defaultSortColumn"><value>apply_date</value></property> -->
<!-- <property name="defaultSortDirection"><value>desc</value></property> -->
<property name="sql">
<value>
select
h.ID,h.XM,h.CJRZ_ID,h.SFZ,h.JD,h.JD_ID,h.SQ,h.SQ_ID,h.YXZT,h.YJD,h.YJD_ID,i.jtxxzz
from JDHD_TEMP h,handicapped_information i where i.info_id = h.id /~xm: and
h.XM like '%'||{xm}||'%' ~/ /~sfz: and
h.SFZ like '%'||{sfz}||'%' ~/ /~cjrzh: and
h.CJRZ_ID like '%'||{cjrzh}||'%' ~/ order by h.YXZT desc ,h.CJRZ_ID
desc /~sortColumn: ,[sortColumn]
[sortDirection]~/
</value>
</property>
</bean>
</entry>
<entry key="returnedData">
<bean
class="net.mlw.vlh.adapter.jdbc.dynclass.DefaultDynclassAdapter">
<!-- <bean class="net.mlw.vlh.adapter.jdbc.dynabean.DefaultDynaBeanAdapter"> -->
<property name="dataSource">
<ref bean="dataSource" />
</property>
<property name="lowerCase">
<value>true</value>
</property>
<property name="useName">
<value>false</value>
</property>
<property name="defaultNumberPerPage">
<value>25</value>
</property>
<!-- <property name="defaultSortColumn"><value>apply_date</value></property> -->
<!-- <property name="defaultSortDirection"><value>desc</value></property> -->
<property name="sql">
<value>
select
h.ID,h.XM,h.CJRZ_ID,h.SFZ,h.JD,h.JD_ID,h.SQ,h.SQ_ID,h.YXZT,h.YJD,h.YJD_ID,i.jtxxzz
from JDHD_TEMP h ,handicapped_information i where i.info_id = h.id
/~area: and h.yjd_id={area} ~/
and h.jd_id = '000000000'
order by h.YXZT desc ,h.CJRZ_ID desc
/~sortColumn: ,[sortColumn] [sortDirection]~/
</value>
</property>
</bean>
</entry>
<entry key="rstj">
<bean
class="net.mlw.vlh.adapter.jdbc.dynclass.DefaultDynclassAdapter">
<!-- <bean class="net.mlw.vlh.adapter.jdbc.dynabean.DefaultDynaBeanAdapter"> -->
<property name="dataSource">
<ref bean="dataSource" />
</property>
<property name="lowerCase">
<value>true</value>
</property>
<property name="useName">
<value>false</value>
</property>
<property name="defaultNumberPerPage">
<value>100</value>
</property>
<!-- <property name="defaultSortColumn"><value>apply_date</value></property> -->
<!-- <property name="defaultSortDirection"><value>desc</value></property> -->
<property name="sql">
<value>
select d.dict_name jdname,
(select count(*) from jdhd_temp t where (t.jd_id=d.dict_no or t.yjd_id=d.dict_no) and t.yxzt=0) qq,
(select count(*) from jdhd_temp t where (t.jd_id=d.dict_no or t.yjd_id=d.dict_no) and t.yxzt=1) bqq,
(select count(*) from jdhd_temp t where (t.jd_id=d.dict_no or t.yjd_id=d.dict_no) and t.yxzt=2) tk,
(select count(*) from jdhd_temp t where (t.jd_id=d.dict_no or t.yjd_id=d.dict_no) and t.yxzt=3) bk,
(select count(*) from jdhd_temp t where (t.jd_id=d.dict_no or t.yjd_id=d.dict_no) and t.yxzt=4) swqr,
(select count(*) from jdhd_temp t where (t.jd_id=d.dict_no or t.yjd_id=d.dict_no) and t.yxzt=5) zsqr,
(select count(*) from jdhd_temp t where (t.jd_id=d.dict_no or t.yjd_id=d.dict_no) and t.yxzt=6) qcqr,
(select count(*) from jdhd_temp t where (t.jd_id=d.dict_no or t.yjd_id=d.dict_no) and t.yxzt=9) wsh,
(select count(*) from jdhd_temp t where t.yjd_id=d.dict_no or t.jd_id=d.dict_no) zs
from dictionary d where d.parent_id='34721db084d14bc297cdd9fb69691506' order by d.description
</value>
</property>
</bean>
</entry>
</map>
</property>
</bean>
<bean id="vlUnsubmitJdhdHelper" singleton="true"
class="net.mlw.vlh.web.mvc.ValueListHandlerHelper">
<property name="valueListHandler">
<ref bean="vl_UnsubmitJdhdHandler" />
</property>
</bean>
</beans>
int startnum, int endnum) {
log.debug("finding JdhdTemp instance by example");
String conditionone_temp = "and u.jd_id='" + area + "'";
String conditiontwo_temp = "and u.yxzt='" + hszt + "'";
String conditionthree_temp = "and u.ydk='" + isydk + "'";
String conditionone = (area.equals("")) ? "" : conditionone_temp;
String conditiontwo = (hszt.equals("")) ? "" : conditiontwo_temp;
String conditionthree = (isydk.equals("")) ? "" : conditionthree_temp;
String hql = "SELECT * FROM ( SELECT A. * , ROWNUM RN FROM ( "
+ "select u.xm,u.cjrz_id,u.sfz,u.jd,u.sq,u.yxzt from jdhd_temp u Where u.xm like '%'||'"
+ xm + "'||'%' and u.cjrz_id like '%'||'" + cjrzh + "'||'%' "
+ conditionone + " " + conditiontwo+ " "+conditionthree
+ " order by u.cjrz_id desc" + " ) A WHERE ROWNUM <= "
+ endnum + " ) WHERE RN >= " + startnum;
JdbcTemplate jdbc = new JdbcTemplate(dataSource);
List catList = new ArrayList();
catList = jdbc.queryForList(hql);
log.debug("find by example successful, result size: " + catList.size());
return catList;
}
2.
1.ValueListHandlerHelper vlHandlerHelper = (ValueListHandlerHelper) getBean("vlUnsubmitJdhdHelper");
ValueListInfo info = vlHandlerHelper.getValueListInfo(request);
info.getFilters().putAll(
ValueListRequestUtil.getRequestParameterMap(request));
if (cjrzh != null && !cjrzh.trim().equals("")) {
info.getFilters().remove("cjrzh");
} else {
info.getFilters().remove("cjrzh");
}
conditionHelper(info, "xm", xm);
conditionHelper(info, "cjrzh", cjrzh);
conditionHelper(info, "area", area);
conditionHelper(info, "hszt", hszt);
conditionHelper(info, "isydk", isydk);
ValueList valueList = vlHandlerHelper.getValueList("data", info);
request.setAttribute("dataList", valueList);
private void conditionHelper(ValueListInfo valueListInfo, String key,
String value) {
if (notEmpty(nullToEmpty(value))) {
valueListInfo.getFilters().put(key, value);
} else {
valueListInfo.getFilters().remove(key);
}
}
3.
<%@ taglib uri="http://valuelist.sourceforge.net/tags-valuelist" prefix="vlh"%>
<%@ page import="net.mlw.vlh.ValueList" %>
<vlh:root value="dataList" url="?" includeParameters="*">
<TABLE width="100%" height="20" border="0" cellpadding="0" cellspacing="0">
<TR>
<TD valign="bottom">
共<c:out value="${dataList.valueListInfo.totalNumberOfEntries}" />条记录
(第<c:out value="${dataList.valueListInfo.pagingPage}" />页
共<c:out value="${dataList.valueListInfo.totalNumberOfPages}" />页)
</TD>
<TD align="right">
<vlh:paging pages="5"><c:out value="${page}" /></vlh:paging>
</TD>
<TD align="right" width="90" noWrap><c:if test="${dataList.valueListInfo.totalNumberOfPages>1}">
转到<input text='text' value='<c:out value="${dataList.valueListInfo.pagingPage}" />' size='3' onKeyup='gotoPage(<c:out value="${dataList.valueListInfo.totalNumberOfPages}" />,"<%=basePath%>")'>页</c:if>
</TD>
</TR>
</TABLE>
<TABLE border="0" width="100%" align="center" cellpadding="0" class="tablebg" cellspacing="1">
<tr bgcolor="#66CCFF" height="20">
<td align="center" width="5%"><B>序号</B></td>
<td align="center" width="5%"><B>姓名</B></td>
<td align="center" width="10%"><B>残疾人证号</B></td>
<td align="center" width="20%"><B>家庭住址</B></td>
<td align="center" width="16%"><B>身份证号</B></td>
<td align="center" width="18%"><B>街道</B></td>
<td align="center" width="12%"><B>社区</B></td>
<td align="center" width="8%"><B>核实状态</B></td>
<td align="center" width="5%"><B>操作</B></td>
</tr>
<FORM name="HandicappedInformationForm" METHOD="POST" ACTION="">
<INPUT TYPE="hidden" name="xm" value="">
<INPUT TYPE="hidden" name="area" value="">
<INPUT TYPE="hidden" name="cjrzh" value="">
<INPUT TYPE="hidden" name="hszt" value="">
<INPUT TYPE="hidden" name="JD_ID" value="">
<INPUT TYPE="hidden" name="areaname" value="">
<INPUT TYPE="hidden" name="isydk" value="">
<INPUT TYPE="hidden" name="pagingPage" value="">
<c:forEach items="${dataList}" var="rowData" varStatus="rowNumber">
<TR>
<c:if test="${(rowNumber.count%2)==1}"><TR class="even"></c:if>
<c:if test="${(rowNumber.count%2)==0}"><TR class="odd"></c:if>
<TD align="center"><c:out value="${rowNumber.count}" /></TD>
<TD align="left"><c:out value="${rowData.xm}" /></TD>
<TD align="left"><c:out value="${rowData.cjrz_id}" /></TD>
<TD align="left"><c:out value="${rowData.jtxxzz}" /> </TD>
<TD align="center"><c:out value="${rowData.sfz}" /> </TD>
<TD align="center">
<c:if test="${rowData.jd_id=='000000000'||rowData.jd_id=='000000001'||rowData.jd_id=='000000002'||rowData.jd_id=='000000003'}"><c:out value="${rowData.yjd}" /><c:out value="${rowData.jd}" /></c:if>
<c:if test="${rowData.jd_id!='000000000'&&rowData.jd_id!='000000001'&&rowData.jd_id!='000000002'&&rowData.jd_id!='000000003'}"><c:out value="${rowData.jd}" /></c:if>
</TD>
<TD align="center"><c:out value="${rowData.sq}" /></TD>
<TD align="center">
<c:if test="${(rowData.yxzt)==0}"><font color="green">齐全</font></c:if>
<c:if test="${(rowData.yxzt)==1}"><font color="#FF00FF">不齐全</font></c:if>
<c:if test="${(rowData.yxzt)==2}"><font color="blue">退卡</font></c:if>
<c:if test="${(rowData.yxzt)==3}"><font color="#8B008B">补卡</font></c:if>
<c:if test="${(rowData.yxzt)==4}">死亡确认</c:if>
<c:if test="${(rowData.yxzt)==5}">走失确认</c:if>
<c:if test="${(rowData.yxzt)==6}">迁出确认</c:if>
<c:if test="${(rowData.yxzt)==9}"><font color="red">未审核</font></c:if>
</TD>
<TD align="center">
<a href='#' onclick='modifyHI("<c:out value="${rowData.id}"/>");return false' title="修改" target='_parentblank'><img src="../../images/copy1.gif" border="0"></a>
</TD>
</TR>
</c:forEach>
<IFRAME NAME="VoteMessageFrame" id="VoteMessage" width="100%" height="100%" style="display:none;"
frameBorder="0" marginWidth="0" marginHeight="0" scrolling="auto"
src=""> </IFRAME>
</FORM>
</TABLE>
</vlh:root>
function gotoInputPageNo(inputPageNo, contextPath) {
var frm = document.HandicappedInformationForm;
frm.pagingPage.value=inputPageNo;
frm.target="_self";
var parentForm = window.parent.document.HandicappedInformationForm;
frm.xm.value= parentForm.xm.value;
frm.area.value= parentForm.area.value;
frm.cjrzh.value= parentForm.cjrzh.value;
frm.hszt.value= parentForm.hszt.value;
frm.isydk.value= parentForm.isydk.value;
frm.action= contextPath + '/jdhdTempAction.do?method=areaListInfo';
frm.submit();
}
function gotoPage(totalPage, contextPath) {
if(event.keyCode!=13) {// not press enter-key
return false;
}
if(totalPage==null) {
alert("提示：未提供参数（totalPage ： 总页数），因此使用默认值 1。");
totalPage = 1;
}
if(contextPath==null) {
contextPath = "";
}
var inputPage = event.srcElement.value;
if(inputPage==""){
return false;
}
if(inputPage<1) {
inputPage = totalPage;
}
if(inputPage>totalPage) {
alert("您输入的页数不存在！");
event.srcElement.select();
return false;
}
gotoInputPageNo(inputPage, contextPath);
}
4.<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE beans PUBLIC "-//SPRING//DTD BEAN//EN"
"http://www.springframework.org/dtd/spring-beans.dtd">
<!-- Globle Search Configuration -->
<beans>
<!--½ֵ:˶¨ -->
<bean id="JdhdTempDAO"
class="com.itsv.information.dao.hibernate.JdhdTempDAOHibernate">
<property name="dataSource"><ref bean="dataSource"/></property>
<property name="sessionFactory">
<ref bean="sessionFactory" />
</property>
</bean>
<bean id="jdhdTempManager" parent="txProxyTemplate">
<property name="target">
<bean
class="com.itsv.information.service.impl.JdhdTempManagerImpl">
<property name="jdhdTempDAO">
<ref bean="JdhdTempDAO" />
</property>
</bean>
</property>
</bean>
<bean id="vl_UnsubmitJdhdHandler" singleton="true"
class="net.mlw.vlh.DefaultValueListHandlerImpl">
<property name="config.adapters">
<map>
<entry key="data">
<bean
class="net.mlw.vlh.adapter.jdbc.dynclass.DefaultDynclassAdapter">
<!-- <bean class="net.mlw.vlh.adapter.jdbc.dynabean.DefaultDynaBeanAdapter"> -->
<property name="dataSource">
<ref bean="dataSource" />
</property>
<property name="lowerCase">
<value>true</value>
</property>
<property name="useName">
<value>false</value>
</property>
<property name="defaultNumberPerPage">
<value>25</value>
</property>
<!-- <property name="defaultSortColumn"><value>apply_date</value></property> -->
<!-- <property name="defaultSortDirection"><value>desc</value></property> -->
<property name="sql">
<value>
select
h.ID,h.XM,h.CJRZ_ID,h.SFZ,h.JD,h.JD_ID,h.SQ,h.SQ_ID,h.YXZT,h.YJD,h.YJD_ID,i.jtxxzz
from JDHD_TEMP h ,handicapped_information i where i.info_id = h.id /~xm: and
h.XM like '%'||{xm}||'%' ~/ /~cjrzh: and
h.CJRZ_ID like '%'||{cjrzh}||'%' ~/
/~area: and (h.jd_id={area} or
((h.jd_id = '000000000' or h.jd_id = '000000001'
or h.jd_id = '000000002' or h.jd_id = '000000003') and h.yjd_id={area})) ~/ /~hszt:
and h.yxzt = {hszt}~/ /~isydk:
and h.ydk = {isydk}~/ /~yjdId:
and h.yjd_id = {yjdId}~/ order by h.YXZT desc , h.CJRZ_ID
desc /~sortColumn: ,[sortColumn]
[sortDirection]~/
</value>
</property>
</bean>
</entry>
<entry key="persondata">
<bean
class="net.mlw.vlh.adapter.jdbc.dynclass.DefaultDynclassAdapter">
<!-- <bean class="net.mlw.vlh.adapter.jdbc.dynabean.DefaultDynaBeanAdapter"> -->
<property name="dataSource">
<ref bean="dataSource" />
</property>
<property name="lowerCase">
<value>true</value>
</property>
<property name="useName">
<value>false</value>
</property>
<property name="defaultNumberPerPage">
<value>25</value>
</property>
<!-- <property name="defaultSortColumn"><value>apply_date</value></property> -->
<!-- <property name="defaultSortDirection"><value>desc</value></property> -->
<property name="sql">
<value>
select
h.ID,h.XM,h.CJRZ_ID,h.SFZ,h.JD,h.JD_ID,h.SQ,h.SQ_ID,h.YXZT,h.YJD,h.YJD_ID,i.jtxxzz
from JDHD_TEMP h,handicapped_information i where i.info_id = h.id /~xm: and
h.XM like '%'||{xm}||'%' ~/ /~sfz: and
h.SFZ like '%'||{sfz}||'%' ~/ /~cjrzh: and
h.CJRZ_ID like '%'||{cjrzh}||'%' ~/ order by h.YXZT desc ,h.CJRZ_ID
desc /~sortColumn: ,[sortColumn]
[sortDirection]~/
</value>
</property>
</bean>
</entry>
<entry key="returnedData">
<bean
class="net.mlw.vlh.adapter.jdbc.dynclass.DefaultDynclassAdapter">
<!-- <bean class="net.mlw.vlh.adapter.jdbc.dynabean.DefaultDynaBeanAdapter"> -->
<property name="dataSource">
<ref bean="dataSource" />
</property>
<property name="lowerCase">
<value>true</value>
</property>
<property name="useName">
<value>false</value>
</property>
<property name="defaultNumberPerPage">
<value>25</value>
</property>
<!-- <property name="defaultSortColumn"><value>apply_date</value></property> -->
<!-- <property name="defaultSortDirection"><value>desc</value></property> -->
<property name="sql">
<value>
select
h.ID,h.XM,h.CJRZ_ID,h.SFZ,h.JD,h.JD_ID,h.SQ,h.SQ_ID,h.YXZT,h.YJD,h.YJD_ID,i.jtxxzz
from JDHD_TEMP h ,handicapped_information i where i.info_id = h.id
/~area: and h.yjd_id={area} ~/
and h.jd_id = '000000000'
order by h.YXZT desc ,h.CJRZ_ID desc
/~sortColumn: ,[sortColumn] [sortDirection]~/
</value>
</property>
</bean>
</entry>
<entry key="rstj">
<bean
class="net.mlw.vlh.adapter.jdbc.dynclass.DefaultDynclassAdapter">
<!-- <bean class="net.mlw.vlh.adapter.jdbc.dynabean.DefaultDynaBeanAdapter"> -->
<property name="dataSource">
<ref bean="dataSource" />
</property>
<property name="lowerCase">
<value>true</value>
</property>
<property name="useName">
<value>false</value>
</property>
<property name="defaultNumberPerPage">
<value>100</value>
</property>
<!-- <property name="defaultSortColumn"><value>apply_date</value></property> -->
<!-- <property name="defaultSortDirection"><value>desc</value></property> -->
<property name="sql">
<value>
select d.dict_name jdname,
(select count(*) from jdhd_temp t where (t.jd_id=d.dict_no or t.yjd_id=d.dict_no) and t.yxzt=0) qq,
(select count(*) from jdhd_temp t where (t.jd_id=d.dict_no or t.yjd_id=d.dict_no) and t.yxzt=1) bqq,
(select count(*) from jdhd_temp t where (t.jd_id=d.dict_no or t.yjd_id=d.dict_no) and t.yxzt=2) tk,
(select count(*) from jdhd_temp t where (t.jd_id=d.dict_no or t.yjd_id=d.dict_no) and t.yxzt=3) bk,
(select count(*) from jdhd_temp t where (t.jd_id=d.dict_no or t.yjd_id=d.dict_no) and t.yxzt=4) swqr,
(select count(*) from jdhd_temp t where (t.jd_id=d.dict_no or t.yjd_id=d.dict_no) and t.yxzt=5) zsqr,
(select count(*) from jdhd_temp t where (t.jd_id=d.dict_no or t.yjd_id=d.dict_no) and t.yxzt=6) qcqr,
(select count(*) from jdhd_temp t where (t.jd_id=d.dict_no or t.yjd_id=d.dict_no) and t.yxzt=9) wsh,
(select count(*) from jdhd_temp t where t.yjd_id=d.dict_no or t.jd_id=d.dict_no) zs
from dictionary d where d.parent_id='34721db084d14bc297cdd9fb69691506' order by d.description
</value>
</property>
</bean>
</entry>
</map>
</property>
</bean>
<bean id="vlUnsubmitJdhdHelper" singleton="true"
class="net.mlw.vlh.web.mvc.ValueListHandlerHelper">
<property name="valueListHandler">
<ref bean="vl_UnsubmitJdhdHandler" />
</property>
</bean>
</beans>
分享到：
发表评论
-
java.lang.NoClassDefFoundError: javax/el/ELException
2010-09-06 01:07 2594在maven中配置以下依赖： <depe ... -
配置过滤器
2009-12-28 12:04 1106配置过滤器，通过mapping ... -
关于div的隐藏
2009-12-28 12:01 1062div的visibility可以控制div的显示和隐藏，但是隐 ... -
request.getRealPath()的替代方法
2009-08-25 15:26 2864替代方法是: 写道 request.getSession( ... -
JSP注释详解(新手必看)
2009-07-03 14:14 1428在客户端显示一个注释. JSP 语法<!-- comme ... -
把JSP放到WEB-INF后以保护JSP源代码
2008-12-15 10:58 1597本人在看《J2EE核心模式》（“Core J2ee Patte ... -
struts配置文件中<forward>标签的redirect属性
2008-12-02 20:47 2379struts-config.xml中有这样 ... -
STRUTS中ec标签的用法
2008-11-25 16:41 25031.<ec:table items="pres ... -
JSP生成彩色验证码
2008-06-28 09:47 1241程序代码image.jsp<%@ page conten ... -
对表单输入的数据做校验
2008-05-23 20:11 1213对表单输入的数据做校验 在struts中带有了Jakarta ... -
活学活用 Struts (转)
2008-04-11 16:02 15131.概述 Struts大家都很熟悉，不再详细介绍，另 ... -
web开发设计displaytag应用指南
2008-03-10 15:26 1496DisplayTag是一个非常好用的表格显示标签，适合MVC模 ... -
display table 标签用法
2008-03-10 15:25 5655在web.xml下添加一个filter <filte ... -
jstl之foreach循环
2008-03-10 15:04 1564<%@ page contentType="t ... -
JSTL1.1函数标签库(functions)如fn:length
2008-03-10 15:02 14395在jstl中的fn标签也是我 ... -
JSP Struts之HTML标签库详解
2008-03-10 15:00 1877Struts提供了五个标签库，即：HTML、Bean、Logi ... -
web.xml详解
2008-03-10 14:51 5512web.xml元素介绍 每一个站的WEB-INF下都有一个we ... -
Struts配置文件详解(3)
2008-03-10 14:50 1259<?xml version="1.0" ... -
Struts配置文件详解(2)
2008-03-10 14:49 1796关于 Struts中 struts-config.xml文件的 ... -
Struts配置文件详解(1)
2008-03-10 14:49 1285Struts应用采用两个基于X ...
相关推荐
immediate设为true后，则监听的这个对象会立即输出，也就是说一刷新页面就会在控制台输出，当然此时页面上的数据我们还没来得及手动让其发生变化，所以在控制台输出的newValue为我们在代码中默认设置的值，oldValue...
主要给大家介绍了关于vue.js中$watch的oldvalue与newValue的相关资料，文中通过示例代码介绍的非常详细，并且介绍了关于watch的其他测试，对大家学习或者使用vue.js具有一定的参考学习价值，需要的朋友们下面跟着小...
newvalue-v2-frontend 构建设置 # install dependencies $ yarn install # serve with hot reload at localhost:3000 $ yarn dev # build for production and launch server $ yarn build $ yarn start # generate ...
vm.items[indexOfItem] = newValue vue不能检测数组的变动 想要实现可以使用vue的set方法 this.$set(this.items,indexOfItem,newValue); 补充知识：vue中利用索引直接设置一个数组项，不能触发视图更新的问题 ...
### LINQ to SQL语法及实例大全 #### 一、LINQ to SQL简介 **LINQ to SQL** 是 Microsoft .NET Framework 提供的一种用于在数据库和应用程序之间进行数据操作的技术。它提供了一种声明式的编程方式来处理数据，...
`${varName-NewValue}`在`varName`为空时返回`NewValue`，而`${varName+NewValue}`在`varName`未定义时返回`NewValue`。 - 验证3和验证4分别展示了`${varName:=NewValue}`和`${varName=NewValue}`在变量为空和未定义...
前言 创建 Vue 实例时，Vue 将遍历 data 的属性，通过 ES5 的 Object.defineProperty 将它们转为 getter/setter，在其内部 Vue 可以追踪依赖、通知变化。...vm.$watch('foo', function (newValue, ol
<s:append var="myList" value="newValue" /> ``` 6. **<s:autocompleter> 自动完成内容** - **用途**：配合`s:combobox`标签使用，提供自动完成功能。 - **示例**： ```xml ``` 7. **<s:bean> 显示...
assign pn_out=pn_newvalue[0][0]^pn_newvalue[0][2]^pn_newvalue[0][4]^pn_newvalue[0][5]; ``` 计算输出序列值，通过多个位的异或得到最终输出。 ##### 2. 时序逻辑设计 - **always块**：用于定义时序逻辑，...
let newValue = slider.value + translation.x / slider.frame.width // 检查边界并限制滑块值 if newValue newValue = slider.minimumValue } else if newValue > slider.maximumValue { newValue = ...
1: NewValue := G * Factor div 255; // 绿色通道 2: NewValue := B * Factor div 255; // 蓝色通道 end; // 更新颜色通道值并保持在0-255范围内 if NewValue NewValue := 0; if NewValue > 255 then ...
newValue.then(resolveNext, rejectNext); } else { resolveNext(newValue); } } catch (error) { rejectNext(error); } } else if (status === 'rejected' && typeof onRejected === 'function') { try { ...
if (((NewValue - Value) > A) || ((Value - NewValue) > A)) { ReturnValue = Value; // 如果超出阈值，则返回上一次有效值 } else { ReturnValue = NewValue; // 否则返回新采样值 } Value = ReturnValue; ...
public delegate void ControlValueChangedEventHandler(string newValue); ``` 2. **创建事件**：接着，在UserControl类中声明一个基于上述委托的事件。这样，任何订阅此事件的类（如主窗体）都可以接收到User...
其中，beg和end是源容器的起始和结束迭代器，oldvalue是要被替换的旧元素，newvalue是要替换的新元素。该算法将源容器中的所有旧元素替换成新元素。 5.4.3 replace_if算法 replace_if算法是C++标准库中的条件替换...
void limitFilter(int newValue, int *lastValue, int A) { if (abs(newValue - *lastValue) ) { *lastValue = newValue; } } ``` #### 2. 中位值滤波法 - **方法**：连续采集多个数据，将这些数据排序后取...
①数组：Vue.set(data,index,newvalue); ②对象：vm.$set(data,index,newvalue); 4.会触发v-for更新的方法： - push() - pop() - shift() - unshift() - splice() - sort() - reverse() 5.不会触发v-for...
string query = "UPDATE TableName SET Column1=@NewValue1, Column2=@NewValue2 WHERE Condition=@Condition"; SqlCommand command = new SqlCommand(query, connection); command.Parameters.AddWithValue("@...