usermanager.java

jsp编程的源代码

package com.mybean;

import com.myopdb.*;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;

public class Usermanager {

	private Connection con = null;

	private Statement stmt = null;

	private ResultSet rs = null;

	DBCon dbc = new DBCon();

	private int userid;

	private String usertype;

	private String loginname;

	private String limittext;

	public String getLimittext() {
		return limittext;
	}

	public void setLimittext(String limittext) {
		this.limittext = limittext;
	}

	public String getLoginname() {
		return loginname;
	}

	public void setLoginname(String loginname) {
		this.loginname = loginname;
	}

	public int getUserid() {
		return userid;
	}

	public void setUserid(int userid) {
		this.userid = userid;
	}

	public String getUsertype() {
		return usertype;
	}

	public void setUsertype(String usertype) {
		this.usertype = usertype;
	}

	int intRowCount;// 数据的总记录数

	int intPageCount;// 总页数

	int intPageSize = 10;// 每页行数

	int intPage;// 当前第几页

	public ArrayList getAllUser(int curpage,String content,String search) {

		Usermanager userm;
		ArrayList<Object> lst = new ArrayList<Object>();
		String sql = "select * from usermanager_view";
		if(search.equals("用户名"))
		{
			
			sql="select * from usermanager_view where logionname='"+content+"'";
		}
		if(search.equals("注册时间"))
		{
			sql="select * from usermanager_view where regiondate between '"+content+"' and  getDate()";
		}
		
		if(search.equals("用户类型"))
		{
			sql="select * from usermanager_view where usertype='"+content+"'";
		}
		if (this.con == null) {
			this.con = dbc.getCon();
		}

		try {
			stmt = con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,
					ResultSet.CONCUR_UPDATABLE);
			rs = stmt.executeQuery(sql);
			rs.last();
			intRowCount = rs.getRow();
			if(intRowCount ==0 )
			{
				return null;
			}
			if(search.equals("用户名")||search.equals("注册时段")||search.equals("用户类型"))
			{
				intPageSize=intRowCount;
			}
			if (intRowCount % intPageSize == 0) {
				intPageCount = intRowCount / intPageSize;
			} else {
				intPageCount = intRowCount / intPageSize + 1;
			}
			if (curpage == 0) {
				intPage = 1;
			} else {
				intPage = curpage;
				if (intPage < 1 || intPage > intPageCount) {
					intPage = 1;
				}
			}

			// 将对记录集进行操作，以显示数据,
			// 首先要将记录集的指针移到要显示页面的第一条记录上面
			rs.absolute((intPage - 1) * intPageSize + 1);
			// 循环显示当前指定页面的数据
			int i = 0;
			while (i < intPageSize && !rs.isAfterLast()) {
				userm = new Usermanager();
				userm.setUserid(rs.getInt(1));
				userm.setUsertype(rs.getString(2));
				userm.setLoginname(rs.getString(3));
				userm.setLimittext(rs.getString(4));
				lst.add(userm);
				rs.next();
				i++;
			}

			System.out.println(i);
		} catch (SQLException e) {
			// TODO 自动生成 catch 块
			e.printStackTrace();
			return null;
		}

		lst.add(this.intPage);
		lst.add(this.intPageCount);
		return lst;

	}
}