assetscfdqueryaction.java

来自「功能是公安和学校的管理系统,用struts+hibernate+spring等匡」· Java 代码 · 共 155 行

package com.comingnet.action;

import java.util.ArrayList;

import com.comingnet.bean.ResourceType;
import com.comingnet.bean.ResourceTypeDAO;
import com.comingnet.bean.StoreInfor;
import com.comingnet.bean.StoreInforDAO;
import com.comingnet.bean.UserInfor;
import com.comingnet.intercepter.UserSessionAware;
import com.db.page;
import com.opensymphony.xwork2.ActionSupport;

public class AssetsCFDQueryAction extends ActionSupport implements
		UserSessionAware {
	
	private ArrayList<StoreInfor> StoreList ;
	private String pageStr;                         //分页字符串
	private String pageno="1";                     //当前页
	private int pagecount=0;                      //总记录数
	private int rownum=10;                       //每页记录数
	private int pagerow = 10;                   //显示多少页
	private UserInfor userSession=null;
	//private String auid;
	private String auid_test ="11";
	
	private String cxz;   //查询值
	private String cxtj; //查询条件
	private String urlflag;//判断是表单提交的,还是页面提交的 
	
	private String cond="";//表单提交生成的查询条件
	
	@Override
	public String execute() throws Exception {
		// TODO Auto-generated method stub
		////
		 if(getCxtj()!=null)
		    {
		    	cxz=getCxz();
		     
		    	setCxz(cxz);
		   	
		    	if(getCxtj().equals("cfdmc"))
		    	{
		    		cond=cond+"  cfdmc like '%"+cxz+"%' ";
		    	}
		    	if(getCxtj().equals("cfddz"))
		    	{
		    		cond=cond+"  cfddz like '%"+cxz+"%' ";
		    	}
		    	if(getCxtj().equals("cfdzrr"))
		    	{
		    		cond=cond+"  cfdzrr like '%"+cxz+"%' ";
		    	}
		    }else
		    {
		    	cond=" 1=1 "; 
		    }
		////
		page page1 = new page() ;
		String pageno1=getPageno(); //得到当前页
		StoreInforDAO dao = new StoreInforDAO() ;
		
		pagecount = dao.getCountsOfAll() ;
//		System.out.println("pagecount---------------->"+pagecount) ;
		
//		pagecount = dao.getCountsOfSql(this.sqlStr) ;//得到 页数
		
		page1.setPageString(pagecount, rownum, Integer.parseInt(pageno1),
				pagerow, "auid=" + getAuid_test());
		String pageStr = page1.getPageString();
		setPageStr(pageStr); //设置分页的字符串
		
		this.setStoreList(dao.queryAll(Integer.parseInt(pageno), rownum,cond)) ;
//		System.out.println("size--------->"+StoreList.size()) ;
//		this.setStoreList(dao.queryBy(Integer.parseInt(pageno),rownum,sqlStr));
		
		return SUCCESS ;
		 
	}	
 
	public String getAuid_test() {
		return auid_test;
	}
	public void setAuid_test(String auid_test) {
		this.auid_test = auid_test;
	}
	public String getCxtj() {
		return cxtj;
	}
	public void setCxtj(String cxtj) {
		this.cxtj = cxtj;
	}
	public String getCxz() {
		return cxz;
	}
	public void setCxz(String cxz) {
		this.cxz = cxz;
	}
	public int getPagecount() {
		return pagecount;
	}
	public void setPagecount(int pagecount) {
		this.pagecount = pagecount;
	}
	public String getPageno() {
		return pageno;
	}
	public void setPageno(String pageno) {
		this.pageno = pageno;
	}
	public int getPagerow() {
		return pagerow;
	}
	public void setPagerow(int pagerow) {
		this.pagerow = pagerow;
	}
	public String getPageStr() {
		return pageStr;
	}
	public void setPageStr(String pageStr) {
		this.pageStr = pageStr;
	}
	public int getRownum() {
		return rownum;
	}
	public void setRownum(int rownum) {
		this.rownum = rownum;
	}
	public ArrayList<StoreInfor> getStoreList() {
		return StoreList;
	}
	public void setStoreList(ArrayList<StoreInfor> storeList) {
		StoreList = storeList;
	}
	 
	public UserInfor getUserSession() {
		return userSession;
	}
	public void setUserSession(UserInfor userSession) {
		this.userSession = userSession;
	}


	public String getUrlflag() {
		return urlflag;
	}

	public void setUrlflag(String urlflag) {
		this.urlflag = urlflag;
	}
    
	
}