【SSH小Demo】个人信息展示页面——XML配置方式（下）

ゝ一纸荒年。 2022-04-05 06:51 313阅读 0赞

本篇记录这个Demo的搜索和分页功能，看看完成后的效果

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MTg2Njk2MA_size_16_color_FFFFFF_t_70][]

首先做分页功能，我们得新建一个Page对象，作为分页工具；创建com.zdxh.util包，在包里创建Page对象

start：数据的开始

count：默认是显示5条数据

total：一共有多少条数据

getTotalPage方法：算出一共有多少页数据

getLast():算出最后一页的开始，比如一共有54条数据，每页显示5条，那么这里就是算出最后一页是从第50条数据库开始的，用于按钮跳转到末日

package com.zdxh.util;
    
    public class Page {
    	int start;
    	int count=5;
    	int total;
    	
    	private static final int defalutcount=5;
    	
    	public Page(){
    		count=defalutcount;
    	}
    	
    	public Page(int start, int count) {
            super();
            this.start = start;
            this.count = count;
        }
    	
    	
    	public int getTotalPage(){
    		int totalPage;
    		if(total%count==0)
    			totalPage=total/count;
    		else
    			totalPage=total/count+1;
    		if(totalPage==0)
    			totalPage=1;
    		return totalPage;
    	}
    
        public int getLast(){
    		int last;
    		if(total%count==0)
    			last=total-count;
    		else
    			last=total-total%count;
    		last = last<0?0:last;
    		return last;
    	}
    
    	/***setter and getter***/
    
    }

给PeopleDAO和它的实现类增加分页查询方法，listByPage（Page page），还有getTotal（）用于计算数据总数

![20181211133509291.png][]

public List<People> listByPage(Page page){
    		DetachedCriteria dc = DetachedCriteria.forClass(People.class);
            dc.addOrder(Order.desc("id"));
            return findByCriteria(dc,page.getStart(),page.getCount());
    	}
    	
    	public int getTotal(){
    		String hql = "select count(*) from People";
            List<Long> l= find(hql);
            if(l.isEmpty())
                return 0;
            Long result= l.get(0);
            return result.intValue();
    	}

在service层也增加listByPage（Page page）

![20181211133658555.png][]

public List<People> listByPage(Page page){
    		return peopleDAO.listByPage(page);
    	}
    	
    	public int getTotal(){
    		return peopleDAO.getTotal();
    	}

重写action中的list（）方法，并且加入对象Page到action中

package com.zdxh.action;
    
    import java.util.List;
    
    import com.zdxh.pojo.People;
    import com.zdxh.service.PeopleService;
    import com.zdxh.util.Page;
    
    public class PeopleAction {
    	List<People> ps;
    	PeopleService peopleService;
    	People people;
    	Page page;
    	
    	public String list(){
    		if(page==null)
    			page=new Page();
    		int total=peopleService.getTotal();
    		page.setTotal(total);
    		ps=peopleService.listByPage(page);
    		return "listPeople";
    	}
    	
    	public String add(){
    		peopleService.add(people);
    		return "listPeopleAction";
    	}
    	
    	public String delete(){
    		peopleService.delete(people);
    		return "listPeopleAction";
    	}
    
        /***setter and getter***/
    
    }

然后我们再修改一下JSP页面，增加分页的按钮，主要代码如下

<div style="text-align:center">
            <a href="?page.start=0">首  页</a>
     
            <a href="?page.start=${page.start-page.count}"> 上一页 </a>
    	
    	    <c:forEach begin="0" end="${page.totalPage-1}" varStatus="status">
         
            	<c:if test="${status.count*page.count-page.start<=20 && status.count*page.count-page.start>=-10}">  	
                   	 <a href="?page.start=${status.index*page.count}">${status.count}   </a>
            	</c:if>
        	</c:forEach>
    	     
            <a href="?page.start=${page.start+page.count}"> 下一页  </a>
        
            <a href="?page.start=${page.last}">末  页</a>
         
    </div>

打开tomcat访问[http://localhost:8080/SSH\_Demo1A/listPeople][http_localhost_8080_SSH_Demo1A_listPeople]，效果就可以看到了

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MTg2Njk2MA_size_16_color_FFFFFF_t_70 1][]

接下来是搜索功能，第一步还是给DAO层增加方法

![20181211135126333.png][]

public List<People> search(String keyword){
    		DetachedCriteria dc = DetachedCriteria.forClass(People.class);
            dc.add(Restrictions.like("name", "%"+keyword+"%"));
            return findByCriteria(dc);
    	}

给sevice层增加方法，调用DAO层

![20181211140120815.png][]

public List<People> search(String keyword){
    		return peopleDAO.search(keyword);
    	}

在Action层上调用service，action层上要新增属性keyord，用来接收传递过来的搜索关键字

package com.zdxh.action;
    
    import java.util.List;
    
    import com.zdxh.pojo.People;
    import com.zdxh.service.PeopleService;
    import com.zdxh.util.Page;
    
    public class PeopleAction {
    	List<People> ps;
    	PeopleService peopleService;
    	People people;
    	Page page;
    	String keyword;
    	
    	public String list(){
    		if(page==null)
    			page=new Page();
    		int total=peopleService.getTotal();
    		page.setTotal(total);
    		ps=peopleService.listByPage(page);
    		return "listPeople";
    	}
    	
    	public String add(){
    		peopleService.add(people);
    		return "listPeopleAction";
    	}
    	
    	public String delete(){
    		peopleService.delete(people);
    		return "listPeopleAction";
    	}
    	
    	
    	public String search(){
    		ps=peopleService.search(keyword);
    		return "listPeople";
    	}
    
    
       /*** setter and getter***/
    }

JSP中新增搜索栏和返回的按钮

打开tomcat运行访问，通过关键字 小 搜索一下

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MTg2Njk2MA_size_16_color_FFFFFF_t_70 2][]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MTg2Njk2MA_size_16_color_FFFFFF_t_70 3][]

搜索功能就完成了

然后再简单记录一下编辑功能

DAO层新增一个get方法和update方法

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MTg2Njk2MA_size_16_color_FFFFFF_t_70 4][]

public People get(int id){
    		return (People)get(People.class,id);
    	}
    	
    	public void update(People p){
    		super.update(p);
    	}

同样，sevice也做差不多的工作~只是调用了DAO层

![20181211141703961.png][]

public void update(People p){
    		peopleDAO.update(p);
    	}
    	
    	public People get(int id){
    		return peopleDAO.get(id);
    	}

Action层新增edit（）和update（）的方法

edit的作用是根据id找数据信息，并跳转到editPeople.jsp中

public String edit(){
    	people=peopleService.get(people.getId());
    	return "editPeople";
    }

对struts文件进行跳转配置，新增<result name="editPeople">WEB-INF/jsp/editPeople.jsp</result>

![20181211142313517.png][]

编写editPeople.jsp

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MTg2Njk2MA_size_16_color_FFFFFF_t_70 5][]

update方法

public String update(){
        peopleService.update(people);
    	return "listPeopleAction";
    }

运行测试一下

![20181211143212801.png][]

![20181211143226788.png][]

提交成功，完成了编辑修改

这个Demo到这里就完成了

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MTg2Njk2MA_size_16_color_FFFFFF_t_70]: /images/20220405/3c623b0b464449d8b649d2dd070107f1.png
[20181211133509291.png]: /images/20220405/6b619917ddac4075a5ce5b89815ea405.png
[20181211133658555.png]: /images/20220405/7547232282214c9d8dd8696466c2f502.png
[http_localhost_8080_SSH_Demo1A_listPeople]: http://localhost:8080/SSH_Demo1A/listPeople
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MTg2Njk2MA_size_16_color_FFFFFF_t_70 1]: /images/20220405/ed1da3981a1e48b0847ae0c38b82b17c.png
[20181211135126333.png]: /images/20220405/2ca9c08b1cdf48cf98522057ae8741d5.png
[20181211140120815.png]: /images/20220405/5472b2ef66f64262817a4041a116210d.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MTg2Njk2MA_size_16_color_FFFFFF_t_70 2]: /images/20220405/5263c2d3977845c5b188aeaef367e5fc.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MTg2Njk2MA_size_16_color_FFFFFF_t_70 3]: /images/20220405/6c5b3f05930841ceaaff662aa3ae1075.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MTg2Njk2MA_size_16_color_FFFFFF_t_70 4]: /images/20220405/35d8da35c2e34ffba2a51bcb9f7f934c.png
[20181211141703961.png]: /images/20220405/cc6b5b6b01d7422b8bc0478e76a9f205.png
[20181211142313517.png]: /images/20220405/4a9cb9980ac44239866856cefe123b8b.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MTg2Njk2MA_size_16_color_FFFFFF_t_70 5]: /images/20220405/0f50526774384f69b7b3bbe8097f53d3.png
[20181211143212801.png]: /images/20220405/99f7159315dc455c9b14b22d8c018129.png
[20181211143226788.png]: /images/20220405/9cb25ee9788040649eda0a4702838dd5.png