classlistaction.java

功能是公安和学校的管理系统,用struts+hibernate+spring等匡架组成,在eclepse就能编译

package com.comingnet.action;

import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpSession;

import org.apache.struts2.ServletActionContext;

import com.db.DBOperator;
import com.db.page;
import com.opensymphony.xwork2.ActionSupport;

public class ClassListAction extends ActionSupport {

	private static final long serialVersionUID = 5661804230328246591L;
	List classlist = null;
	private String pageStr; // 分页字符串
	private String pageno; // 当前页
	private int pagecount = 0; // 总记录数
	private int rownum = 15; // 每页记录数
	private int pagerow = 10; // 显示多少页
	private int xxbh = 0;
	

	private int alter = 0;
	private String checked = "";

	public int getAlter() {
		return alter;
	}

	public void setAlter(int alter) {
		this.alter = alter;
	}

	public String getChecked() {
		return checked;
	}

	public void setChecked(String checked) {
		this.checked = checked;
	}

	public int getXxbh() {
		return xxbh;
	}

	public void setXxbh(int xxbh) {
		this.xxbh = xxbh;
	}

	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 String getPageStr() {
		return pageStr;
	}

	public void setPageStr(String pageStr) {
		this.pageStr = pageStr;
	}

	public List getClasslist() {
		return classlist;
	}

	public void setClasslist(List classlist) {
		this.classlist = classlist;
	}

	public String execute() {
		
		String flag;
		HttpServletRequest request = ServletActionContext.getRequest();
		HttpSession session = request.getSession();
		if (session.getAttribute("xxbh") == null) {
			flag = ERROR;
		} else {
			setXxbh(Integer.parseInt(session.getAttribute("xxbh").toString()));
		}

		String pageno1 = getPageno(); // 得到当前页
		if (pageno1 == null)
			pageno1 = "1";
		ArrayList list = null;
		ArrayList list0 = null;
		ArrayList list1 = null;
		ArrayList list2 = null;

		List newlist = new ArrayList();
		DBOperator dbop = new DBOperator();
		try {
			System.out.println("开始执行班级列表查询");
			System.out.println("select count(*) from m_class  where xxbh="
					+ getXxbh());
			if (alter == 0)
				list0 = dbop.ExecuteSelect(false,
						"select count(*) from m_class  where bjby=0 and xxbh="
								+ getXxbh());
			else if (alter == 1)
				list0 = dbop.ExecuteSelect(false,
						"select count(*) from m_class  where xxbh="
								+ getXxbh());

			if (list0.size() > 0) {
				System.out
						.println(((ArrayList) list0.get(0)).get(0).toString());
				pagecount = Integer.parseInt(((ArrayList) list0.get(0)).get(0)
						.toString());
			}
			setPagecount(pagecount); // 向前台传回总记录数
			// System.out.println("xxbh-->"+xxbh);

			page page1 = new page();
			page1.setPageString(pagecount, rownum, Integer.parseInt(pageno1),
					pagerow, "");
			String pageStr = page1.getPageString();
			setPageStr(pageStr); // 设置分页的字符串

			int cupage = Integer.parseInt(pageno1) - 1;
			String sqlStr = "";
			if (alter == 0)
				sqlStr = "select top "
						+ rownum
						+ " a.bjid,a.bjmc,a.bjnj,a.bjrs,a.bjbzr,b.njmc,a.bjrxnf,b.njid from m_class a,m_nianji b  where  b.njid=a.bjnj and  a.xxbh="
						+ getXxbh()
						+ " and a.bjby=0 and a.bjid not in (select top "
						+ cupage
						* 15
						+ " bjid  from  m_class where bjby=0 order by  bjid DESC) order by a.bjnj,a.bjmc";
			else if (alter == 1)
				sqlStr = "select top "
						+ rownum
						+ " a.bjid,a.bjmc,a.bjnj,a.bjrs,a.bjbzr,b.njmc,a.bjrxnf,b.njid from m_class a,m_nianji b where  b.njid=a.bjnj and  a.xxbh="
						+ getXxbh()
						+ " and bjid not in (select top "
						+ cupage
						* 15
						+ " bjid  from  m_class order by  bjid DESC) order by a.bjnj,a.bjmc";
			System.out.println("sqlStr-->" + sqlStr+"asdasdfffffffffffffffffffffffff alter"+alter);

			list1 = dbop.ExecuteSelect(true, sqlStr);
			String name = "";
			String nameStr = "bj_bh";
			int j = 0;
			HashMap row = null;
			list2 = (ArrayList) list1.get(0);
			for (int i = 1; i < list1.size(); i++) {

				list = (ArrayList) list1.get(i);
				j++;
				row = new HashMap();
				for (int k = 0; k < list2.size(); k++) {
					name = list2.get(k).toString();
					row.put(nameStr, "" + j);
					row.put(name.toLowerCase(), list.get(k).toString());
				}
				newlist.add(row);
				System.out.println(i+"i的值i的值i的值i的值i的值");
			}
			
			setClasslist(newlist); // 此处不能利用getList1(),get方法是获取从页面传过来的值

			flag = SUCCESS;

		} catch (Exception e) {
			System.out.println("错误一场"+e.getLocalizedMessage());
			flag = ERROR;
		}
		
		if (alter == 0)
			checked = "";
		else
			checked = "checked=\"checked\"";
		
		return flag;
	}

	
}