tgyd2006
- 浏览: 327154 次
- 性别:
- 来自: 北京
-
文章分类
最新评论
-
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 2563在maven中配置以下依赖： <depe ... -
配置过滤器
2009-12-28 12:04 1085配置过滤器，通过mapping ... -
关于div的隐藏
2009-12-28 12:01 1027div的visibility可以控制div的显示和隐藏，但是隐 ... -
request.getRealPath()的替代方法
2009-08-25 15:26 2831替代方法是: 写道 request.getSession( ... -
JSP注释详解(新手必看)
2009-07-03 14:14 1402在客户端显示一个注释. JSP 语法<!-- comme ... -
把JSP放到WEB-INF后以保护JSP源代码
2008-12-15 10:58 1572本人在看《J2EE核心模式》（“Core J2ee Patte ... -
struts配置文件中<forward>标签的redirect属性
2008-12-02 20:47 2356struts-config.xml中有这样 ... -
STRUTS中ec标签的用法
2008-11-25 16:41 24791.<ec:table items="pres ... -
JSP生成彩色验证码
2008-06-28 09:47 1214程序代码image.jsp<%@ page conten ... -
对表单输入的数据做校验
2008-05-23 20:11 1190对表单输入的数据做校验 在struts中带有了Jakarta ... -
活学活用 Struts (转)
2008-04-11 16:02 14881.概述 Struts大家都很熟悉，不再详细介绍，另 ... -
web开发设计displaytag应用指南
2008-03-10 15:26 1461DisplayTag是一个非常好用的表格显示标签，适合MVC模 ... -
display table 标签用法
2008-03-10 15:25 5636在web.xml下添加一个filter <filte ... -
jstl之foreach循环
2008-03-10 15:04 1532<%@ page contentType="t ... -
JSTL1.1函数标签库(functions)如fn:length
2008-03-10 15:02 14365在jstl中的fn标签也是我 ... -
JSP Struts之HTML标签库详解
2008-03-10 15:00 1852Struts提供了五个标签库，即：HTML、Bean、Logi ... -
web.xml详解
2008-03-10 14:51 5484web.xml元素介绍 每一个站的WEB-INF下都有一个we ... -
Struts配置文件详解(3)
2008-03-10 14:50 1238<?xml version="1.0" ... -
Struts配置文件详解(2)
2008-03-10 14:49 1778关于 Struts中 struts-config.xml文件的 ... -
Struts配置文件详解(1)
2008-03-10 14:49 1260Struts应用采用两个基于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 ...
前言 创建 Vue 实例时，Vue 将遍历 data 的属性，通过 ES5 的 Object.defineProperty 将它们转为 getter/setter，在其内部 Vue 可以追踪依赖、通知变化。...vm.$watch('foo', function (newValue, ol
watch:侦听数据变化 （某个值的change事件） vue2.x data（）{ return{ num:10 } }， watch:{ num:{ /* * newValue:当前值 * oldValue:修改上一刻的值 */ handler(newValue,oldValue){ // ...
parent和opener的区别 parent和opener的区别
1. 只需要包含头文件. 2. 支持无SECTION的 Key-value 读写. ... ini.SetValue("section", "key", "newvalue"); pv = ini.GetValue("section", "key", "default"); ASSERT_STREQ(pv, "newvalue");
public void onChanged(WheelView wheel, int oldValue, int newValue) { // TODO Auto-generated method stub strSltDay = curDayAdapter.getItem(newValue); android.util.Log.i("",String.format...
This command will change the value of field1 to 'newvalue'. The commands SELECT, UPDATE, INSERT, DELETE, ADD, and INSERT are supported. This tool is useful for running automated queries against a ...
mongodb 数据库基本...db.mycollection.updateOne({key: "value"}, {$set: {newkey: "newvalue"}}) ``` ### 删除文档 ```bash db.mycollection.deleteOne({key: "value"}) ``` ### 创建索引 ```bash db.mycollecti
Constructions on the pattern Sheet.Cells[x,y].Value := NewValue are quite a rarity in XL Report sources. The algorithms use only native data types and early binding to the Excel Type Library. We ...
setProperty(target, { name: name, newValue: extend(deep, clone, copy) }); // Don't bring in undefined values } else if (typeof copy !== 'undefined') { setProperty(target, { name...
wordDoc.Tables.Item(1).Cell(y,i).Range.InsertAfter(DbGrid1.Fields[i-1].NewValue); DBGrid1.DataSource.DataSet.Next; //下一行 end; end else showmessage('TDBGrid表中无数据，不能向Word中插入...
newValue = command.ExecuteScalar().ToString(); continue; } command.ExecuteNonQuery(); } transaction.Commit();//提交数据库事务 } catch (Exception exception) { transaction.Rollback();//回滚...
set columnname = newvalue [, nextcolumn = newvalue2...] where columnname OPERATOR value [and|or column OPERATOR value]; 例如： update employee set age = age+1 where first_name= ‘Mary’and last_...
private static object AddElement(IDictionary collection, object key, object newValue) { object element=collection[key]; collection[key]=newValue; return element; } private int ...
1. Java工具概述 很多人初学程序时，总是在想，那么多的算法该怎么写呀？那么多的数据结构都不熟悉，该怎么实现呀？总是担心英语不好程序学不精通，数学不好写程序无法达到巅峰。学的程序越多，不懂的知识越多。...
没法下载，到这里折腾一把试试。 本文由abc2253130贡献 doc文档可能在WAP端浏览体验不佳。建议您优先选择TXT，或下载源文件到本机查看。 C#（WINFORM）学习 一、 C#基础 基础 类型和变量 类型和变量 类型 C# 支持两...
(varEmpty) value to TField.NewValue in the TDataSetProvider.BeforeUpdateRecord event handler does not work (Quality Central 3660). * TClientDataset InternalCalc fields are reset to null after calling...