comnewslist.java

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

package until;

import java.sql.*;
import java.util.Vector;
import database.conn;
import until.comNews;


public class comNewslist 
{
	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 comNewslist() 
    {
    	pagesize = 1;
    }
    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 Total()
	{
		try
		{
			    String strsql = "select Count(*) AS total from C_comNews";
				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="select top "+pagesize+" * from C_comNews where id not in(select top "+pagesize*(pageno-1)+" id from C_comNews order by id desc) order by id desc";
			ResultSet rs = cn.executeQuery(strsql);
			list = new Vector();
			while (rs.next())
			{
				comNews cns = new comNews();
				cns.setId(rs.getInt("id"));
				cns.setTitle(rs.getString("title"));
				cns.setDatatimes(rs.getString("datatimes"));
				
                list.addElement(cns);
                flag = true;
			}
			cn.closestmt();
			cn.closeconn();
			
			
		}
		catch(Exception e)
		{
			e.printStackTrace();
		}
		return flag;
		
	}
    
    
}