classcurlistaction.java

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

package com.comingnet.action;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;

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

import org.apache.struts2.ServletActionContext;

import com.db.*;
import com.opensymphony.xwork2.ActionSupport;


public class ClassCurListAction extends ActionSupport{
	List classcurlist=null;
	private String pageStr;                           //分页字符串
	private String pageno;                            //当前页
	private int pagecount=0;        //总记录数
	private int rownum=15;          //每页记录数
	private int pagerow=10;         //显示多少页
	private int xxbh=0;
	private String mark="8";
	public String getMark() {
		return mark;
	}
	public void setMark(String mark) {
		this.mark = mark;
	}
	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 getClasscurlist() {
		return classcurlist;
	}
	public void setClasscurlist(List classcurlist) {
		this.classcurlist = classcurlist;
	}
	public String execute()
	{
		
		
		String pageno1=getPageno(); //得到当前页
		if(pageno1==null)
			 pageno1="1";
		ArrayList list=null;
		ArrayList list0=null;
		ArrayList list1=null;
		ArrayList list2=null;
		String flag;
		List newlist=new ArrayList();
		DBOperator   dbop=new DBOperator();
		  try
		  {
			 
			  HttpServletRequest request = ServletActionContext.getRequest(); 
	          HttpSession session = request.getSession();
		    if(session.getAttribute("xxbh")==null){
		    	flag=ERROR;	
		    	
		    }else{
	          setXxbh(Integer.parseInt(session.getAttribute("xxbh").toString()));
		    }			  
			  
			  System.out.println( "select count(*) from m_class_cur  where xxbh="+getXxbh());
			list0=dbop.ExecuteSelect(false, "select count(*) from m_class_cur  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="select top "+rownum+" b.bkid,b.bjbh,c.jsxm,b.kcmc,b.kcjc,b.kclrr,a.bjmc from m_class a,m_class_cur b ,m_teacher c  where b.jsbh=c.jsid  and  b.bjbh=a.bjid and b.xxbh="+getXxbh()+" and ( b.bkid not in (select top "+cupage*15+" bkid  from  m_class_cur order by  bkid DESC)) order by b.bjbh, b.bkid DESC";
		    System.out.println("sqlStr-->"+sqlStr);

		    list1=dbop.ExecuteSelect(true, sqlStr);
			String name="";
			String nameStr="bjkc_xh";
			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);
	         }
		     setClasscurlist(newlist);   //此处不能利用getList1(),get方法是获取从页面传过来的值
		     System.out.println("mark-->"+mark);
		     
		     if(!mark.equals("8")){	
	        flag=LOGIN; }else{
	        	
	        	 flag=SUCCESS; 	
	        	
	        } 
		  
		  }catch(Exception e)
		  {
	       flag=ERROR;
	      }
		  System.out.println("flag-->"+flag);
	return flag ;
	 }
	}