getarticlelist.java

sample struct article, ... ...

/**
 * Copyright (C) 2003-2006 TiandiNet.com
 * 
 * Struts 文章系统 1.1
 * 
 * release-date: 2006-02-25
 */

package com.tiandinet.StrutsArticle.FunctionBeans;

import java.sql.*;
import java.util.*;
import com.tiandinet.StrutsArticle.Utils.DBConnection;
import com.tiandinet.StrutsArticle.Utils.TimeMaker;
import com.tiandinet.StrutsArticle.Utils.Tools;
import com.tiandinet.StrutsArticle.FormBeans.Article;

/**
 * @author Meng Yang
 * @version 1.1
 */
public class GetArticleList
{
    private Collection coll         = new ArrayList();
		private Connection conn         = null;
		private int        articleTotal = 0;
		private int        pageTotal    = 0;
		private String     className    = "";
		private int        page         = 1;
		
		
		public GetArticleList()
		{
		    try
				{
            this.conn = DBConnection.getConnection();
				}
				catch(Exception e){}
		}
		
		public Collection getColl()
		{
		    return this.coll;
		}
		
		public int getArticleTotal()
		{
		    return this.articleTotal;
		}
		
		public int getPageTotal()
		{
		    return this.pageTotal;
		}
		
		public String getClassName()
		{
		    return this.className;
		}
		
		public int getPage()
		{
		    return this.page;
		}
		
		//计算文章总数
		public void countArticleTotal(String classId)
		{
		    String where = "";
				if(classId == null || classId.equals("") || classId.equals("*"))
				{
				    where = "`show`=1";
				}
				else
				{
				    where = "`class`='"+classId+"' AND `show`=1";
				}
				
				String query = "SELECT COUNT(*) FROM `com_tiandinet_jsp_struts_article_content` WHERE " + where;
				
				int    total = 0;
				try
				{
				    Statement stmt = this.conn.createStatement();
						ResultSet rs   = stmt.executeQuery(query);
						while(rs.next())
						{
						    total = rs.getInt(1);
						}
						rs.close();
				}
				catch(Exception e)
				{
				}
				
				this.articleTotal = total;
		}
		
		public void countPageTotal(int total,int cPP)
		{
		    int pTotal = 0;
				
				if(total%cPP == 0)
				    pTotal = total/cPP;
				else
				    pTotal = total/cPP + 1;
				
				this.pageTotal = pTotal;
		}
		
		//查询序号、标题、作者、时间和类别
		public void getList(String classId,int countPerPage,int page)
		{
		    String where = "";
				String limit = "";
				int    cPP   = 20;                              //每页显示数
				this.countArticleTotal(classId);                //计算文章总数
				int    total = this.articleTotal;
				
		    if(classId == null || classId.equals("") || classId.equals("*"))
				{
				    where = "`Article`.`show`=1 AND `Class`.`name`=`Article`.`class`";
				}
				else
				{
				    where = "`Article`.`class`='"+classId+"' AND `Article`.`show`=1 AND `Class`.`class`=`Article`.`class`";
				}
				
				if(countPerPage > 0)
				{
				   cPP = countPerPage;
				}
				
				//页面总数
				this.countPageTotal(total,cPP);
				int pageTotal = this.pageTotal;
				
				if(page <= 0)
				  page = 1;
				if(page > pageTotal)
				  page = pageTotal;
				
				this.page = page;
						
				int offset = (page - 1)*cPP;

				limit = "LIMIT "+offset+","+cPP;
				
				String titleTemp     = "";
				long longTime        = 0L;
				TimeMaker tMaker     = new TimeMaker();
				String classNameTemp = "";
				
				String query = "SELECT `Article`.`id`,`Article`.`title`,`Article`.`author`,`Article`.`time`,`Article`.`class`,`Article`.`read`,`Class`.`name` FROM `com_tiandinet_jsp_struts_article_content` AS `Article`,`com_tiandinet_jsp_struts_article_class` AS `Class` WHERE " + where + " ORDER BY `Article`.`time` DESC "+limit;
				
		    try
				{
				    Statement stmt = this.conn.createStatement();
						ResultSet rs   = stmt.executeQuery(query);
						while(rs.next())
						{
						    Article art = new Article();
								 art.setId(rs.getInt(1));
								 titleTemp = rs.getString(2);
								 art.setTitle(Tools.getCNSubString(titleTemp,40));
								 art.setAuthor(rs.getString(3));
								 
								 //设置时间
								 longTime = rs.getLong(4);
								 tMaker.makeTime(longTime);
								 
								 art.setTime(tMaker.getFormatTime());
								 
								 art.setClassId(rs.getString(5));
								 art.setRead(rs.getInt(6));
								 
								 classNameTemp = rs.getString(7);
								 art.setClassName(classNameTemp);
								 
								this.coll.add(art);
						}
						
		        if(classId == null || classId.equals("") || classId.equals("*"))
				    {
				        this.className = " ";
				    }
				    else
				    {
				        this.className = classNameTemp;
				    }

						rs.close();
				}
				catch(Exception e)
				{
				}
				
				try
				{
		        this.conn.close();
				}
				catch(Exception e)
				{}
				
				return;
		}
}