userslist.java

是一个JSP与数据库应用系统

package until;

import java.sql.*;
import database.*;
import java.util.Vector;
import User.User;

public class userSlist
{
	
	private String LockUser;
	private String keyword;
	private int pagesize;
	private int pageno=1;
	private int Total = 0;
	private int TPages = 0;
	private int n = 1;       //此变量是设定分页时，
	private int pagers = 5; //此变量是设定分页时，页码的个数
	
	private Vector list;
	
	conn cn = new conn();
	
	public userSlist()
	{
		
		LockUser = "";
		pagesize = 1;
		pageno = 1;
		keyword = "";
	}
	
	public void setKeyword(String keyword)
	{
		try
		{
			if((keyword!=null)||(!keyword.equals("")))
			{
				this.keyword = new String(keyword.getBytes("ISO8859_1"),"gb2312");
			}
			else
			{
				this.keyword = null;
			}
	    }
	    catch(Exception e)
	    {
	    	e.printStackTrace();
	    }
	}
	
	public void setPagesize(int pagesize)
	{
		this.pagesize = pagesize;
	}
	
	
	public void setPageno(int pageno)
	{
		this.pageno = pageno;
		
	}
	
	public int getTotal()
	{
		return Total;
	}
	public int getTPages()
	{
		return TPages;
	}
	
	public Vector getList()
	{
		return list;
	}
	
	public void setLockUser(String LockUser)
	{
		this.LockUser = LockUser;
	}
	
	
	public void Total()
	{
		try
		{
			    String strsql = "";
			    if((keyword!=null)||(!keyword.equals("")))
			    {
			    	strsql = "select Count(*) AS total from C_User where UserName like '%"+keyword+"%'";
			    }
			    else if ((LockUser.equals("all"))||(LockUser==null)||(LockUser.equals("")))
			    {
			    	strsql = "select Count(*) AS total from C_User";
			    }
			    else
			    {
			    	strsql = "select Count(*) AS total from C_User where LockUser='"+LockUser+"'";
			    }
				ResultSet rs = cn.executeQuery(strsql);
				if (rs.next())
				{
					 Total = rs.getInt(1);     
		             // 设置当前页数和总页数
		             TPages = (int)Math.ceil((double)Total/pagesize); 
				}
		}
		catch(Exception e)
		{
			e.printStackTrace();
		}
	
	}
	
	public boolean pagelist()
	{
		boolean flag = false;
		try
		{
			String strsql = "";
			if((keyword!=null)||(!keyword.equals("")))
			{
				strsql = "select * from C_User where UserName like '%"+keyword+"%' order by id desc";
			}
			else if ((LockUser.equals("all"))||(LockUser==null)||(LockUser.equals("")))
			{
				strsql = "select * from C_User order by id desc";
			}
			else
			{
				strsql = "select * from C_User where LockUser='"+LockUser+"' order by id desc";
			}
			ResultSet rs = cn.executeQuery(strsql);
			list= new Vector();
			while(rs.next())
			{
				User us = new User();
				us.setId(rs.getInt("id"));
				us.setUsername(rs.getString("UserName"));
				us.setSex(rs.getString("Sex"));
				us.setPhone(rs.getString("Phone"));
				us.setLockUser(rs.getString("LockUser"));
				us.setRegDate(rs.getString("RegDate"));
				
				list.addElement(us);
				flag = true;
			}
		}
		catch(Exception e)
		{
			e.printStackTrace();
		}
		
		return flag;
	}
}