quanxianlistaction.java

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

package com.comingnet.action;
import java.util.*;
import com.opensymphony.xwork2.ActionSupport;
import com.db.ProxoolAction;
import java.sql.*;
import com.db.page;
import com.comingnet.bean.UserInfor;
import com.comingnet.intercepter.UserSessionAware;
public class QuanXianListAction extends BaseAction implements UserSessionAware{

List quanxianList=null; 
private String pageStr;                           //分页字符串
private String pageno;                            //当前页
private int pagecount=0;                          //总记录数
private int rownum=15;                            //每页记录数
private int pagerow=10;                           //显示多少页
private UserInfor userSession=null;
private String auid_test="2";

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 getQuanxianList() {
	return quanxianList;
}
public void setQuanxianList(List quanxianList) {
	this.quanxianList = quanxianList;
}
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;

	  try
	  {
		conn=ProxoolAction.getConnection();
		stmt=conn.prepareStatement("select count(*) from systemauth");
		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,"");
		String pageStr=page1.getPageString();
	    setPageStr(pageStr);                         //设置分页的字符串	
		
	    int cupage=Integer.parseInt(pageno1)-1;
	    String sqlStr="select top  "+rownum+" *  from systemauth  where  (qxid not in (select top "+cupage*15+" qxid  from  systemauth   order by  qxid DESC)) order by  qxid DESC";
		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);
         }
        setQuanxianList(newlist);   //此处不能利用getList1(),get方法是获取从页面传过来的值
		flag=SUCCESS;
	  }catch(Exception e)
	  {
		  flag=ERROR;
      }finally
	  {
    	  ProxoolAction.closeResultSet(rs);
    	  ProxoolAction.closeStatement(stmt);
    	  ProxoolAction.closeConnection(conn);
	  }
   return flag;
 }
}