studentlistaction.java

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

package com.comingnet.action;
import java.util.*;
import com.opensymphony.xwork2.ActionSupport;
import com.comingnet.bean.UserInfor;
import com.comingnet.intercepter.UserSessionAware;
import com.db.ProxoolAction;
import java.sql.*;
import com.db.page;

public class StudentListAction extends ActionSupport implements UserSessionAware{

List studentlist=null;
private String pageStr;                           //分页字符串
private String pageno;                            //当前页
private int pagecount=0;                          //总记录数
private int rownum=10;                            //每页记录数
private int pagerow=10;                           //显示多少页
private UserInfor userSession=null;
private String auid_test="5";
private String bjbh="";
private String bjmc;
private String cxtj;
private String cxz;
private String urlflag;




public String getUrlflag() {
	return urlflag;
}
public void setUrlflag(String urlflag) {
	this.urlflag = urlflag;
}
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 String getBjmc() throws Exception{
	return bjmc;
}
public void setBjmc(String bjmc) {
	this.bjmc = bjmc;
}
public String getBjbh() {
	return bjbh;
}
public void setBjbh(String bjbh) {
	this.bjbh = bjbh;
}
public String getAuid_test()
{
   return auid_test;
}
public UserInfor getUserSession() {
	return userSession;
}
public void setUserSession(UserInfor userSession) {
	this.userSession = userSession;
}
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 getStudentlist() {
	return studentlist;
}
public void setStudentlist(List studentlist) {
	this.studentlist = studentlist;
}
public String execute()
{
	String pageno1=getPageno(); //得到当前页
	if(pageno1==null)
		 pageno1="1";
	
	String flag;
	List newlist=new ArrayList();
	Connection conn=null;
	ResultSet rs=null;
	PreparedStatement stmt=null;
	
	String cxz="";
	
	String sql0="";
    if(bjbh.equals("0")) 
    	sql0=" and xsbjbh=0";
    else if(bjbh.equals(""))
    	sql0=" and 1=1";
    else	
    	sql0=" and xsbjbh="+getBjbh();
    if(getCxtj()!=null)
    {
    	cxz=getCxz();
    	try
    	{
    	    if(getUrlflag()==null)
    	    {
    	    	//cxz=new String(cxz.getBytes("ISO-8859-1"),"UTF-8");
    	    	System.out.println("---------------->"+cxz);
    	    	setCxz(cxz);
    	    	setCxtj(getCxtj());
    	    }
    	    
    	}catch(Exception e){
    		System.out.println(e);
    	}
   	
    	if(getCxtj().equals("xsxm"))
    	{
    		sql0=sql0+" and xsxm like '%"+cxz+"%'";
    	}
    	if(getCxtj().equals("bjmc"))
    	{
    		sql0=sql0+" and b.bjmc like '%"+cxz+"%'";
    	}
    	if(getCxtj().equals("xsxh"))
    	{
    		sql0=sql0+" and xsxh like '%"+cxz+"%'";
    	}
    }else
    {
    	 
    }
    
    
	  try
	  {
		conn=ProxoolAction.getConnection();
		stmt=conn.prepareStatement("select count(*) from m_student a,m_class b where a.xsbjbh=b.bjid  "+sql0);
		
		rs=stmt.executeQuery();
		if(rs.next())
		{
			pagecount=rs.getInt(1);
		}
		setPagecount(pagecount);                    //向前台传回总记录数
		ProxoolAction.closeResultSet(rs);
		ProxoolAction.closeStatement(stmt);
		
		page page1=new page();
		page1.setPageString(pagecount,rownum,Integer.parseInt(pageno1),pagerow,"auid="+auid_test+"&cxtj="+getCxtj()+"&cxz="+java.net.URLEncoder.encode(cxz,"UTF-8"));
		String pageStr=page1.getPageString();
	    setPageStr(pageStr);                         //设置分页的字符串	
		
	    int cupage=Integer.parseInt(pageno1)-1;
	    String sqlStr="select top  "+rownum+" *  from m_student a,m_class b  where  a.xsbjbh=b.bjid and (xsid not in (select top "+cupage*rownum+" xsid  from  m_student a,m_class b   where a.xsbjbh=b.bjid "+sql0+" order by  xsid DESC))  "+sql0+" order by  xsid DESC";
		System.out.println("studentList:"+sqlStr);
	    stmt=conn.prepareStatement(sqlStr);
		rs=stmt.executeQuery();
		String name="";
		String nameStr="user_xh";
		int j=0;
		
		HashMap row=null;
		ResultSetMetaData rsmd=rs.getMetaData();
        int columnCount=rsmd.getColumnCount();	
        while(rs.next())
   	     {
              j++;
        	  row=new HashMap();
          	  for(int i=1;i<=columnCount;i++)
          	   {
                   name=rsmd.getColumnName(i);
                   row.put(nameStr,""+j);
                   row.put(name.toLowerCase(),rs.getString(i));
                }
          	newlist.add(row);
         }
       
        setStudentlist(newlist);   //此处不能利用getList1(),get方法是获取从页面传过来的值
        if(bjbh.equals("0"))
      	{
      	}else
      	{
       	  //setBjmc(new String(getBjmc().getBytes("ISO-8859-1"), "GBK"));
      		
      	  setBjbh(getBjbh());
       	  setBjmc(getBjmc()); 
      	}
        flag=SUCCESS;
	  }catch(Exception e)
	  {
		  flag=ERROR;
      }finally
	  {
    	  ProxoolAction.closeResultSet(rs);
    	  ProxoolAction.closeStatement(stmt);
    	  ProxoolAction.closeConnection(conn);
	  }
   return flag;
 }
}