schoollistaction.java

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

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

public class schoolListAction extends ActionSupport implements UserSessionAware{

List schoollist=null;
private String pageStr;                           //分页字符串
private String pageno="1";                            //当前页
private int pagecount=0;        //总记录数
private int rownum=15;          //每页记录数
private int pagerow=10;         //显示多少页
private UserInfor userSession=null;
//private String auid;
public static String auid_test="3";
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 getSchoollist() {
	return schoollist;
}
public void setSchoollist(List schoollist) {
	this.schoollist = schoollist;
}

public String execute()
{
	UserInfor userinfor=getUserSession();
	System.out.println("在ListAction中得到登录用户名:"+userinfor.getUserxm());
	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 ms_school");
		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);
		String pageStr=page1.getPageString();
	    setPageStr(pageStr);                         //设置分页的字符串	
		
	    int cupage=Integer.parseInt(pageno1)-1;
	    String sqlStr="select top  "+rownum+" *  from ms_school  where  (ms_xxid not in (select top "+cupage*15+" ms_xxid  from  ms_school   order by  ms_xxid DESC)) order by  ms_xxid DESC";
		System.out.println(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);
         }
        setSchoollist(newlist);   //此处不能利用getList1(),get方法是获取从页面传过来的值
		flag=SUCCESS;
	  }catch(Exception e)
	  {
		  System.out.println(e);
		  flag=ERROR;
      }finally
	  {
    	  ProxoolAction.closeResultSet(rs);
    	  ProxoolAction.closeStatement(stmt);
    	  ProxoolAction.closeConnection(conn);
	  }
   return flag;
 }
}