getarticlelistindex.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.FormBeans.Article;
import com.tiandinet.StrutsArticle.Utils.Tools;
import com.tiandinet.StrutsArticle.Utils.TimeMaker;

/**
 * @author Meng Yang
 * @version 1.1
 */
public class GetArticleListIndex
{
    private Collection coll  = new ArrayList();
		private Connection conn  = null;
		private int        total = 0;
		
		public GetArticleListIndex()
		{
		    try
				{
            this.conn = DBConnection.getConnection();
				}
				catch(Exception e){}

				int    cPP   = 20;                              //每页显示数
				this.total = this.getArticleTotal();   //文章总数

		    String where = "`Article`.`show`=1 AND `Class`.`class`=`Article`.`class`";

				String limit = "LIMIT "+cPP;
				
				String titleTemp = "";
				long longTime  = 0L;
				TimeMaker tMaker = new TimeMaker();
		    try
				{
				    Statement stmt = this.conn.createStatement();
						ResultSet rs   = stmt.executeQuery("SELECT `Article`.`id`,`Article`.`title`,`Article`.`author`,`Article`.`time`,`Article`.`class`,`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);
						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.setClassName(rs.getString(6));
								this.coll.add(art);
						}
						rs.close();
				}
				catch(Exception e)
				{
				}
				
				try
				{
		        this.conn.close();
				}
				catch(Exception e)
				{}
				
				return;
		}
		
		public int getArticleTotal()
		{
		    String where = "`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)
				{
				}
				
				return total;
		}
		
		public Collection getColl()
		{
		    return this.coll;
		}
		
		public int getTotal()
		{
		    return this.total;
		}
}