按条件模糊查询及分页查询

1、查询助手

package cn.buaa.core.util;



import java.util.ArrayList;

import java.util.List;





public class QueryHelper {

    

    //from子句

    private String fromClause = "";

    //where子句

    private String whereClause = "";

    //orderBy子句

    private String orderByClause = "";

    

    private List<Object> parameters;

    

    //排序常量

    public static String ORDER_BY_DESC = "DESC"; //降序

    public static String ORDER_BY_ASC = "ASC"; //升序

    /**

     * 构造from子句(有别名)

     * @param clazz 实体类

     * @param alias 实体类对应的别名

     */

    public QueryHelper(Class clazz,String alias){

        fromClause = "From " + clazz.getSimpleName() + " " +alias ;

        System.out.println(fromClause);

    }

    /**
     * 构造from子句（无别名）

     * @param clazz 实体类

     */

    public QueryHelper(Class clazz){

        fromClause = "From " + clazz.getSimpleName() ;

    }

    

    /**

     * 构造where子句

     * @param condition 查询条件语句：例如：i.title like ?

     * @param params 查询条件语句中？对应的查询条件的值： 例如：%标题%

     */

    public void  addCondition(String condition , Object... params ){

        if(whereClause.length()>1){//非第一个查询条件

            whereClause += " AND " + condition;

        }else{//第一个查询条件

            whereClause += " WHERE " + condition;

        }

        

        //设置查询条件值到查询条件集合中

        if(parameters == null){

            parameters = new ArrayList<Object>();

        }

        if(params != null){

            for(Object param : params){

                parameters.add(param);

            }

        }

        

    }

    

    /**

     * 构造order by子句

     * @param property 排序属性：如：i.createTime

     * @param order 排序顺序，如：DESC 或 ASC

     */

    public void addOrderByProperty(String property,String order){

        if(orderByClause.length()>1){//非第一个排序属性

            orderByClause += " ," + property + " " + order;

        }else{//第一个排序属性

            orderByClause += " ORDER BY " + property + " " + order;

        }

    }

    //查询hql语句

    public String getQueryListHql(){

        

        return  fromClause + whereClause + orderByClause ;

    }

    

    //查询统计数的hql语句

    public String getQueryCountHql(){

        

        return "SELECT COUNT( * )  " +  fromClause + whereClause;

    }

    

    //查询hql语句中？对应的查询条件值集合

    public List<Object> getParameters(){

        

        return parameters;

    }

}

2、dao逻辑处理代码

@Override

    public PageResult getPageResult(QueryHelper queryHelper, int pageNo, int pageSize) {

        Query query = getSession().createQuery(queryHelper.getQueryListHql());

        List<Object> parameters = queryHelper.getParameters();

        if(parameters != null){

            for(int i= 0;i<parameters.size();i++){

                query.setParameter(i, parameters.get(i));

            }

        }

        if(pageNo<1) pageNo =1;

        query.setFirstResult((pageNo-1)*pageSize);

        query.setMaxResults(pageSize);

        List items =  query.list();

    </span><span style="color: #008000;">//</span><span style="color: #008000;">获取总记录数</span></br>
    Query queryCount =<span style="color: #000000;"> getSession().createQuery(queryHelper.getQueryCountHql());</br>
    </span><span style="color: #0000ff;">if</span>(parameters != <span style="color: #0000ff;">null</span><span style="color: #000000;">){</br>
        </span><span style="color: #0000ff;">for</span>(<span style="color: #0000ff;">int</span> i= 0;i&lt;parameters.size();i++<span style="color: #000000;">){</br>
            queryCount.setParameter(i, parameters.get(i));</br>
        }</br>
    }</br>
    </span><span style="color: #0000ff;">long</span> totalCount = (<span style="color: #0000ff;">long</span><span style="color: #000000;">) queryCount.uniqueResult();</br>
    </span><span style="color: #0000ff;">return</span> <span style="color: #0000ff;">new</span><span style="color: #000000;"> PageResult(totalCount, pageNo, pageSize, items);</br>
}
</span></pre>

3、action调用处理代码

        protected PageResult pageResult;

    private int pageNo;

    private int pageSize;

        。。。。


// 列表页面

    public String listUI() throws Exception {

        // 加载分类集合

        ActionContext.getContext().getContextMap().put("infoTypeMap", Info.INFO_TYPE_MAP);

        QueryHelper queryHelper = new QueryHelper(Info.class,"i");

        try {

            if(info != null){

                if(StringUtils.isNotBlank(info.getTitle())){

                    //搜索框乱码问题解决

                    info.setTitle(URLDecoder.decode(info.getTitle(),"utf-8"));

                    queryHelper.addCondition("i.title like ? ", "%" + info.getTitle() + "%");

                }

                queryHelper.addCondition("i.state = ?", "1");

            }

            //根据创建时间降序排序

            queryHelper.addOrderByProperty(" i.createTime ", QueryHelper.ORDER_BY_DESC);
            //infoList = infoService.findObjects(queryHelper);

            pageResult = infoService.getPageResult(queryHelper,getPageNo(),getPageSize());

        } catch (Exception e) {

            throw new ActionException("action出现异常：" + e.getMessage());

        }

        return "listUI";

    }    

4、struts配置文件

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE struts PUBLIC
    "-//Apache Software Foundation//DTD Struts Configuration 2.3//EN"
    "http://struts.apache.org/dtds/struts-2.3.dtd">


<struts>


<package name="info-action" namespace="/nsfw" extends="base-default">


<action name="info_*" class="cn.buaa.nsfw.info.action.InfoAction"


method="{1}">


<result name="{1}">/WEB-INF/jsp/nsfw/info/{1}.jsp</result>


<result name="list" type="redirectAction">


<param name="actionName">info_listUI</param>


<!-- 搜索框搜索值回显 -->


<param name="info.title">${strTitle}</param>


<param name="pageNo">${pageNo}</param>


<!-- 解决搜索框框乱码 -->


<param name="encode">true</param>


</result>


</action>


</package>


</struts>

5、jsp显示页面

<%@ page contentType="text/html;charset=UTF-8" language="java" %>

<html>

<head>

    <%@include file="/common/header.jsp"%>
    <title>信息发布管理</title>

    <script type="text/javascript">

  //全选、全反选

    function doSelectAll() {

        // jquery 1.6 前

        //$("input[name=selectedRow]").attr("checked", $("#selAll").is(":checked"));

        //prop jquery 1.6+建议使用

        $("input[name=selectedRow]").prop("checked",
                $("#selAll").is(":checked"));

    }


</span><span style="background-color: #f5f5f5; color: #008000;">//</span><span style="background-color: #f5f5f5; color: #008000;">添加</span></br>
  <span style="background-color: #f5f5f5; color: #0000ff;">function</span><span style="background-color: #f5f5f5; color: #000000;"> doAdd(){</br>
      document.forms[</span><span style="background-color: #f5f5f5; color: #000000;">0</span><span style="background-color: #f5f5f5; color: #000000;">].action</span><span style="background-color: #f5f5f5; color: #000000;">=</span><span style="background-color: #f5f5f5; color: #000000;">"</span><span style="background-color: #f5f5f5; color: #000000;">${basePath}nsfw/info_addUI.action</span><span style="background-color: #f5f5f5; color: #000000;">"</span><span style="background-color: #f5f5f5; color: #000000;">;
      document.forms[</span><span style="background-color: #f5f5f5; color: #000000;">0</span><span style="background-color: #f5f5f5; color: #000000;">].submit();</br>
  }</br>
  </span><span style="background-color: #f5f5f5; color: #008000;">//</span><span style="background-color: #f5f5f5; color: #008000;">编辑</span></br>
  <span style="background-color: #f5f5f5; color: #0000ff;">function</span><span style="background-color: #f5f5f5; color: #000000;"> doEdit(id){</br>
      document.forms[</span><span style="background-color: #f5f5f5; color: #000000;">0</span><span style="background-color: #f5f5f5; color: #000000;">].action</span><span style="background-color: #f5f5f5; color: #000000;">=</span><span style="background-color: #f5f5f5; color: #000000;">"</span><span style="background-color: #f5f5f5; color: #000000;">${basePath}nsfw/info_editUI.action?info.infoId=</span><span style="background-color: #f5f5f5; color: #000000;">"</span> <span style="background-color: #f5f5f5; color: #000000;">+</span><span style="background-color: #f5f5f5; color: #000000;"> id;</br>
      document.forms[</span><span style="background-color: #f5f5f5; color: #000000;">0</span><span style="background-color: #f5f5f5; color: #000000;">].submit();</br>
  }</br>
</span><span style="background-color: #f5f5f5; color: #008000;">//</span><span style="background-color: #f5f5f5; color: #008000;">删除</span></br>
  <span style="background-color: #f5f5f5; color: #0000ff;">function</span><span style="background-color: #f5f5f5; color: #000000;"> doDelete(id){</br>
      document.forms[</span><span style="background-color: #f5f5f5; color: #000000;">0</span><span style="background-color: #f5f5f5; color: #000000;">].action</span><span style="background-color: #f5f5f5; color: #000000;">=</span><span style="background-color: #f5f5f5; color: #000000;">"</span><span style="background-color: #f5f5f5; color: #000000;">${basePath}nsfw/info_delete.action?info.infoId=</span><span style="background-color: #f5f5f5; color: #000000;">"</span> <span style="background-color: #f5f5f5; color: #000000;">+</span><span style="background-color: #f5f5f5; color: #000000;"> id;</br>
      document.forms[</span><span style="background-color: #f5f5f5; color: #000000;">0</span><span style="background-color: #f5f5f5; color: #000000;">].submit();</br>
  }</br>

//多选删除


function doDeleteAll(){


document.forms[0].action="${basePath}nsfw/info_deleteSelected.action";


document.forms[0].submit();


}


//异步发布信息，信息的id及将要改成的信息状态

function doPublic(infoId,state){


//1、更新信息状态


      $.ajax({


url:"${basePath}nsfw/info_publicInfo.action",


data:{"info.infoId":infoId,"info.state":state},


type:"post",


success:function(msg){


//2、更新状态栏，操作栏的显示值


if("更新状态成功"  msg){

if(state  1){//说明信息状态已被改成发布，状态栏显示发布，操作栏显示停用


                        $("#show_"+infoId).html("发布");


$("#oper_"+infoId).html('<a href="javascript:doPublic(''+infoId+'',0)">停用</a>');


}else{


$("#show_"+infoId).html("停用");


$("#oper_"+infoId).html('<a href="javascript:doPublic(''+infoId+'',1)">发布</a>');


}


}else{


alert("更新信息状态失败！");


}


},


error:function(){


alert("更新信息状态失败！");


}


});


}


var list_url = "${basePath}nsfw/info_listUI.action";

function doSearch(){


//重置页号


          $("#pageNo").val(1);


document.forms[0].action= list_url ;


document.forms[0].submit();



}

</script>


</head>


<body class="rightBody">


<form name="form1" action="" method="post">


<div class="p_d_1">


<div class="p_d_1_1">


<div class="content_info">


<div class="c_crumbs"><div><b></b><strong>信息发布管理</strong></div> </div>


<div class="search_art">

<li>


信息标题：<s:textfield name="info.title" cssClass="s_text" id="infoTitle"  cssStyle="160px;"/>


</li>


<li><input type="button" class="s_button" value="搜 索" onclick="doSearch()"/></li>


<li style="float:right;">


<input type="button" value="新增" class="s_button" onclick="doAdd()"/>&nbsp;


<input type="button" value="删除" class="s_button" onclick="doDeleteAll()"/>&nbsp;


</li>


</div>


            <span style="color: #0000ff;">&lt;</span><span style="color: #800000;">div </span><span style="color: #ff0000;">class</span><span style="color: #0000ff;">="t_list"</span><span style="color: #ff0000;"> style</span><span style="color: #0000ff;">="margin:0px; border:0px none;"</span><span style="color: #0000ff;">&gt;</span></br>
                <span style="color: #0000ff;">&lt;</span><span style="color: #800000;">table </span><span style="color: #ff0000;">width</span><span style="color: #0000ff;">="100%"</span><span style="color: #ff0000;"> border</span><span style="color: #0000ff;">="0"</span><span style="color: #0000ff;">&gt;</span></br>
                    <span style="color: #0000ff;">&lt;</span><span style="color: #800000;">tr </span><span style="color: #ff0000;">class</span><span style="color: #0000ff;">="t_tit"</span><span style="color: #0000ff;">&gt;</span></br>
                        <span style="color: #0000ff;">&lt;</span><span style="color: #800000;">td </span><span style="color: #ff0000;">width</span><span style="color: #0000ff;">="30"</span><span style="color: #ff0000;"> align</span><span style="color: #0000ff;">="center"</span><span style="color: #0000ff;">&gt;&lt;</span><span style="color: #800000;">input </span><span style="color: #ff0000;">type</span><span style="color: #0000ff;">="checkbox"</span><span style="color: #ff0000;"> id</span><span style="color: #0000ff;">="selAll"</span><span style="color: #ff0000;"> onclick</span><span style="color: #0000ff;">="doSelectAll()"</span> <span style="color: #0000ff;">/&gt;&lt;/</span><span style="color: #800000;">td</span><span style="color: #0000ff;">&gt;</span></br>
                        <span style="color: #0000ff;">&lt;</span><span style="color: #800000;">td </span><span style="color: #ff0000;">align</span><span style="color: #0000ff;">="center"</span><span style="color: #0000ff;">&gt;</span>信息标题<span style="color: #0000ff;">&lt;/</span><span style="color: #800000;">td</span><span style="color: #0000ff;">&gt;</span></br>
                        <span style="color: #0000ff;">&lt;</span><span style="color: #800000;">td </span><span style="color: #ff0000;">width</span><span style="color: #0000ff;">="120"</span><span style="color: #ff0000;"> align</span><span style="color: #0000ff;">="center"</span><span style="color: #0000ff;">&gt;</span>信息分类<span style="color: #0000ff;">&lt;/</span><span style="color: #800000;">td</span><span style="color: #0000ff;">&gt;</span></br>
                        <span style="color: #0000ff;">&lt;</span><span style="color: #800000;">td </span><span style="color: #ff0000;">width</span><span style="color: #0000ff;">="120"</span><span style="color: #ff0000;"> align</span><span style="color: #0000ff;">="center"</span><span style="color: #0000ff;">&gt;</span>创建人<span style="color: #0000ff;">&lt;/</span><span style="color: #800000;">td</span><span style="color: #0000ff;">&gt;</span></br>
                        <span style="color: #0000ff;">&lt;</span><span style="color: #800000;">td </span><span style="color: #ff0000;">width</span><span style="color: #0000ff;">="140"</span><span style="color: #ff0000;"> align</span><span style="color: #0000ff;">="center"</span><span style="color: #0000ff;">&gt;</span>创建时间<span style="color: #0000ff;">&lt;/</span><span style="color: #800000;">td</span><span style="color: #0000ff;">&gt;</span></br>
                        <span style="color: #0000ff;">&lt;</span><span style="color: #800000;">td </span><span style="color: #ff0000;">width</span><span style="color: #0000ff;">="80"</span><span style="color: #ff0000;"> align</span><span style="color: #0000ff;">="center"</span><span style="color: #0000ff;">&gt;</span>状态<span style="color: #0000ff;">&lt;/</span><span style="color: #800000;">td</span><span style="color: #0000ff;">&gt;</span></br>
                        <span style="color: #0000ff;">&lt;</span><span style="color: #800000;">td </span><span style="color: #ff0000;">width</span><span style="color: #0000ff;">="120"</span><span style="color: #ff0000;"> align</span><span style="color: #0000ff;">="center"</span><span style="color: #0000ff;">&gt;</span>操作<span style="color: #0000ff;">&lt;/</span><span style="color: #800000;">td</span><span style="color: #0000ff;">&gt;</span></br>
                    <span style="color: #0000ff;">&lt;/</span><span style="color: #800000;">tr</span><span style="color: #0000ff;">&gt;</span></br>
                    <span style="color: #0000ff;">&lt;</span><span style="color: #800000;">s:iterator </span><span style="color: #ff0000;">value</span><span style="color: #0000ff;">="pageResult.items"</span><span style="color: #ff0000;"> status</span><span style="color: #0000ff;">="st"</span><span style="color: #0000ff;">&gt;</span></br>
                        <span style="color: #0000ff;">&lt;</span><span style="color: #800000;">tr </span><span style="color: #ff0000;">&lt;s:if test</span><span style="color: #0000ff;">="#st.odd"</span><span style="color: #0000ff;">&gt;</span> bgcolor="f8f8f8" <span style="color: #0000ff;">&lt;/</span><span style="color: #800000;">s:if</span><span style="color: #0000ff;">&gt;</span><span style="color: #000000;"> &gt;</br>
                            </span><span style="color: #0000ff;">&lt;</span><span style="color: #800000;">td </span><span style="color: #ff0000;">align</span><span style="color: #0000ff;">="center"</span><span style="color: #0000ff;">&gt;&lt;</span><span style="color: #800000;">input </span><span style="color: #ff0000;">type</span><span style="color: #0000ff;">="checkbox"</span><span style="color: #ff0000;"> name</span><span style="color: #0000ff;">="selectedRow"</span><span style="color: #ff0000;"> value</span><span style="color: #0000ff;">="&lt;s:property value='infoId'/&gt;"</span><span style="color: #0000ff;">/&gt;&lt;/</span><span style="color: #800000;">td</span><span style="color: #0000ff;">&gt;</span></br>
                            <span style="color: #0000ff;">&lt;</span><span style="color: #800000;">td </span><span style="color: #ff0000;">align</span><span style="color: #0000ff;">="center"</span><span style="color: #0000ff;">&gt;&lt;</span><span style="color: #800000;">s:property </span><span style="color: #ff0000;">value</span><span style="color: #0000ff;">="title"</span><span style="color: #0000ff;">/&gt;&lt;/</span><span style="color: #800000;">td</span><span style="color: #0000ff;">&gt;</span></br>
                            <span style="color: #0000ff;">&lt;</span><span style="color: #800000;">td </span><span style="color: #ff0000;">align</span><span style="color: #0000ff;">="center"</span><span style="color: #0000ff;">&gt;</span></br>
                                <span style="color: #0000ff;">&lt;</span><span style="color: #800000;">s:property </span><span style="color: #ff0000;">value</span><span style="color: #0000ff;">="#infoTypeMap[type]"</span><span style="color: #0000ff;">/&gt;</span>    
                            <span style="color: #0000ff;">&lt;/</span><span style="color: #800000;">td</span><span style="color: #0000ff;">&gt;</span></br>
                            <span style="color: #0000ff;">&lt;</span><span style="color: #800000;">td </span><span style="color: #ff0000;">align</span><span style="color: #0000ff;">="center"</span><span style="color: #0000ff;">&gt;&lt;</span><span style="color: #800000;">s:property </span><span style="color: #ff0000;">value</span><span style="color: #0000ff;">="creator"</span><span style="color: #0000ff;">/&gt;&lt;/</span><span style="color: #800000;">td</span><span style="color: #0000ff;">&gt;</span></br>
                            <span style="color: #0000ff;">&lt;</span><span style="color: #800000;">td </span><span style="color: #ff0000;">align</span><span style="color: #0000ff;">="center"</span><span style="color: #0000ff;">&gt;&lt;</span><span style="color: #800000;">s:date </span><span style="color: #ff0000;">name</span><span style="color: #0000ff;">="createTime"</span><span style="color: #ff0000;"> format</span><span style="color: #0000ff;">="yyyy-MM-dd HH:mm"</span><span style="color: #0000ff;">/&gt;&lt;/</span><span style="color: #800000;">td</span><span style="color: #0000ff;">&gt;</span></br>
                            <span style="color: #0000ff;">&lt;</span><span style="color: #800000;">td </span><span style="color: #ff0000;">id</span><span style="color: #0000ff;">="show_&lt;s:property value='infoId'/&gt;"</span><span style="color: #ff0000;"> align</span><span style="color: #0000ff;">="center"</span><span style="color: #0000ff;">&gt;&lt;</span><span style="color: #800000;">s:property </span><span style="color: #ff0000;">value</span><span style="color: #0000ff;">="state==1?'发布':'停用'"</span><span style="color: #0000ff;">/&gt;&lt;/</span><span style="color: #800000;">td</span><span style="color: #0000ff;">&gt;</span></br>
                            <span style="color: #0000ff;">&lt;</span><span style="color: #800000;">td </span><span style="color: #ff0000;">align</span><span style="color: #0000ff;">="center"</span><span style="color: #0000ff;">&gt;</span></br>
                                <span style="color: #0000ff;">&lt;</span><span style="color: #800000;">span </span><span style="color: #ff0000;">id</span><span style="color: #0000ff;">="oper_&lt;s:property value='infoId'/&gt;"</span><span style="color: #0000ff;">&gt;</span></br>
                                <span style="color: #0000ff;">&lt;</span><span style="color: #800000;">s:if </span><span style="color: #ff0000;">test</span><span style="color: #0000ff;">="state==1"</span><span style="color: #0000ff;">&gt;</span></br>
                                    <span style="color: #0000ff;">&lt;</span><span style="color: #800000;">a </span><span style="color: #ff0000;">href</span><span style="color: #0000ff;">="javascript:doPublic('&lt;s:property value='infoId'/&gt;',0)"</span><span style="color: #0000ff;">&gt;</span>停用<span style="color: #0000ff;">&lt;/</span><span style="color: #800000;">a</span><span style="color: #0000ff;">&gt;</span></br>
                                <span style="color: #0000ff;">&lt;/</span><span style="color: #800000;">s:if</span><span style="color: #0000ff;">&gt;</span></br>
                                <span style="color: #0000ff;">&lt;</span><span style="color: #800000;">s:else</span><span style="color: #0000ff;">&gt;</span></br>
                                    <span style="color: #0000ff;">&lt;</span><span style="color: #800000;">a </span><span style="color: #ff0000;">href</span><span style="color: #0000ff;">="javascript:doPublic('&lt;s:property value='infoId'/&gt;',1)"</span><span style="color: #0000ff;">&gt;</span>发布<span style="color: #0000ff;">&lt;/</span><span style="color: #800000;">a</span><span style="color: #0000ff;">&gt;</span></br>
                                <span style="color: #0000ff;">&lt;/</span><span style="color: #800000;">s:else</span><span style="color: #0000ff;">&gt;</span></br></br>
                                    
                                
                                <span style="color: #0000ff;">&lt;/</span><span style="color: #800000;">span</span><span style="color: #0000ff;">&gt;</span></br>
                                <span style="color: #0000ff;">&lt;</span><span style="color: #800000;">a </span><span style="color: #ff0000;">href</span><span style="color: #0000ff;">="javascript:doEdit('&lt;s:property value='infoId'/&gt;')"</span><span style="color: #0000ff;">&gt;</span>编辑<span style="color: #0000ff;">&lt;/</span><span style="color: #800000;">a</span><span style="color: #0000ff;">&gt;</span></br>
                                <span style="color: #0000ff;">&lt;</span><span style="color: #800000;">a </span><span style="color: #ff0000;">href</span><span style="color: #0000ff;">="javascript:doDelete('&lt;s:property value='infoId'/&gt;')"</span><span style="color: #0000ff;">&gt;</span>删除<span style="color: #0000ff;">&lt;/</span><span style="color: #800000;">a</span><span style="color: #0000ff;">&gt;</span></br>
                            <span style="color: #0000ff;">&lt;/</span><span style="color: #800000;">td</span><span style="color: #0000ff;">&gt;</span></br>
                        <span style="color: #0000ff;">&lt;/</span><span style="color: #800000;">tr</span><span style="color: #0000ff;">&gt;</span></br>
                    <span style="color: #0000ff;">&lt;/</span><span style="color: #800000;">s:iterator</span><span style="color: #0000ff;">&gt;</span></br>
                <span style="color: #0000ff;">&lt;/</span><span style="color: #800000;">table</span><span style="color: #0000ff;">&gt;</span></br>
            <span style="color: #0000ff;">&lt;/</span><span style="color: #800000;">div</span><span style="color: #0000ff;">&gt;</span></br>
        <span style="color: #0000ff;">&lt;/</span><span style="color: #800000;">div</span><span style="color: #0000ff;">&gt;</span></br>
    <span style="color: #0000ff;">&lt;</span><span style="color: #800000;">jsp:include </span><span style="color: #ff0000;">page</span><span style="color: #0000ff;">="/common/pageNavigator.jsp"</span><span style="color: #0000ff;">/&gt;</span></br>
<span style="color: #0000ff;">&lt;/</span><span style="color: #800000;">div</span><span style="color: #0000ff;">&gt;</span></br>

</form>


</body>


</html>

6、分页代码jsp

<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>

<%@ taglib prefix="s"  uri="/struts-tags"%>

<div class="c_pate" style="margin-top: 5px;">

        <s:if test="pageResult.totalCount > 0">
        <table width="100%" class="pageDown" border="0" cellspacing="0"
            cellpadding="0">

            <tr>

                <td align="right">
                     总共<s:property value="pageResult.totalCount"/><条记录，当前第<s:property value="pageResult.pageNo"/>页，
                     共 <s:property value="pageResult.totalPageCount"/> 页 
                    <s:if test="pageResult.pageNo > 1">

                                 &nbsp;&nbsp;  <a href="javascript:doGoPage(<s:property value="pageResult.pageNo-1"/>)">上一页</a>

                    </s:if>            
     
                    <s:if test="pageResult.pageNo < pageResult.totalPageCount">
                                 &nbsp;&nbsp;<a href="javascript:doGoPage(<s:property value="pageResult.pageNo+1"/>)">下一页</a>

                       </s:if>              
                    到&nbsp;<input id="pageNo" name="pageNo" type="text" style=" 30px;" onkeypress="if(event.keyCode == 13){doGoPage(this.value);}" min="1"
                    max="" value="<s:property value="pageResult.pageNo"/>" /> &nbsp;&nbsp;

                </td>

            </tr>

        </table>    

        </s:if><s:else>
            暂无数据！
        </s:else>

        </div>

        <script type="text/javascript">
            //翻页

            function doGoPage(pageNo){

                document.getElementById("pageNo").value = pageNo;
                document.forms[0].action =list_url;

                document.forms[0].submit();

            }

        </script>

        </div>

7、特别注意搜索框的回显问题以及会先后乱码的处理，还有struts配置文件的传值问题