articlelist.java

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

package until;

import java.sql.*;
import database.*;
import java.util.Vector;
import admin.article;
import admin.smallclass;

public class articlelist
{
	private int pagesize;
	private int pageno=1;
	private int Total = 0;
	private int TPages = 0;
	private int n = 1;       //此变量是设定分页时，
	private int pagers = 5; //此变量是设定分页时，页码的个数
	private String bigclass;
	private String smallclass;
	
	private Vector atlist;
	private Vector scview;
	
	conn cn = new conn();
	
	public articlelist()
	{
		pagesize = 1;
		bigclass = "";
		smallclass = "";
	}
	
	public void setBigclass(String bigclass)
	{
		try
		{
			this.bigclass = new String(bigclass.getBytes("ISO8859_1"),"gb2312");
		}
		catch(Exception e)
		{
			e.printStackTrace();
		}
	}
	public void setSmallclass(String smallclass)
	{
		try
		{
			this.smallclass = new String(smallclass.getBytes("ISO8859_1"),"gb2312");
		}
		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 atlist;
	}
	public Vector getScview()
	{
		return scview;
	}
	
	
	public boolean smalllist()
	{
		boolean flag1 = false;
		try
		{
			String strsql = "select * from C_SmallClass where BigClass='"+bigclass+"'";
			ResultSet rs = cn.executeQuery(strsql);
			scview = new Vector();
			while (rs.next())
			{
				smallclass sc = new smallclass();
				sc.setInt(rs.getInt("id"));
				sc.setSmallClass(rs.getString("SmallClass"));
				
                scview.addElement(sc);
                flag1 = true;
			}
			cn.closestmt();
			cn.closeconn();

		}
		catch(Exception e)
		{
			e.printStackTrace();
		}
		
		return flag1;
	}
	
	
	
	
	
	public void Total()
	{
		try
		{
			    String strsql = "";
			    if ((smallclass==null)||(smallclass.equals(""))||(smallclass.equals("all")))
			    {
			    	strsql = "select Count(*) AS total from C_Article where BigClass='"+bigclass+"'";
			    }
			    else
			    {
			    	strsql = "select Count(*) AS total from C_Article where SmallClass='"+smallclass+"'";
			    }
			    
				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 flag2 = false;
		try
		{
			String strsql = "";
			if ((smallclass==null)||(smallclass.equals(""))||(smallclass.equals("all")))
			{
				strsql = "select top "+pagesize+" * from C_Article where id not in(select top "+pagesize*(pageno-1)+" id from C_Article where BigClass='"+bigclass+"' order by id desc) and BigClass='"+bigclass+"' order by id desc";
			}
			else
			{
				strsql = "select top "+pagesize+" * from C_Article where id not in(select top "+pagesize*(pageno-1)+" id from C_Article where smallclass='"+smallclass+"' order by id desc) and SmallClass='"+smallclass+"' order by id desc";
			}
			ResultSet rs = cn.executeQuery(strsql);
			atlist = new Vector();
			while (rs.next())
			{
				article at = new article();
				at.setId(rs.getInt("id"));
				at.setBigClass(rs.getString("BigClass"));
				at.setSmallClass(rs.getString("SmallClass"));
				at.setTitle(rs.getString("title"));
				at.setAuthor(rs.getString("author"));
				at.setPropert_r(rs.getString("propert_r"));
				at.setPropert_t(rs.getString("propert_t"));
				at.setDatetimes(rs.getString("datetimes"));
				at.setIsno(rs.getString("isno"));
				at.setHit(rs.getInt("hit"));
				
                atlist.addElement(at);
                flag2 = true;
			}
			cn.closestmt();
			cn.closeconn();
		}
		catch(Exception e)
		{
			e.printStackTrace();
		}
		
		return flag2;
	}
}