friendlist.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.comingnet.bean.UserInfor;
import com.comingnet.intercepter.UserSessionAware;

public class friendList extends BaseAction implements UserSessionAware {

	private static final long serialVersionUID = 2710677945036736L;
	List<HashMap<String, String>> friendList;
	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<HashMap<String, String>> getFriendList() {
		return friendList;
	}

	public void setFriendList(List<HashMap<String, String>> friendList) {
		this.friendList = friendList;
	}

	public String execute() {
		String pageno1 = getPageno(); // 得到当前页
		if (pageno1 == null)
			pageno1 = "1";

		String flag;
		Connection conn = null;
		ResultSet rs = null;
		PreparedStatement stmt = null;

		try {
			conn = ProxoolAction.getConnection();
			stmt = conn.prepareStatement("select count(*) from frlist");
			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 frlist  where  (frid not in (select top "
					+ cupage
					* 15
					+ " frid  from  frlist   order by  frid DESC)) order by  frid DESC";
			stmt = conn.prepareStatement(sqlStr);
			rs = stmt.executeQuery();
			
			String name = "";
			String nameStr = "user_xh";

			int j = 0;

			HashMap<String,String> row = null;
			ResultSetMetaData rsmd = rs.getMetaData();
			int columnCount = rsmd.getColumnCount();
			friendList=new ArrayList<HashMap<String,String>>();
			
			while (rs.next()) {
				j++;
				row = new HashMap<String,String>();
				for (int i = 1; i <= columnCount; i++) {
					name = rsmd.getColumnName(i);
					row.put(nameStr, "" + j);
					row.put(name.toLowerCase(), rs.getString(i));
				}
				friendList.add(row);
			}
			
			System.out.println(friendList+"friendList");
			setFriendList(friendList);
			flag = SUCCESS;
		} catch (Exception e) {
			System.out.println(e.getLocalizedMessage()+"错误");
			flag = ERROR;
		} finally {
			ProxoolAction.closeResultSet(rs);
			ProxoolAction.closeStatement(stmt);
			ProxoolAction.closeConnection(conn);
		}
		return flag;
	}
}