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

/**
 * @author Meng Yang
 * @version 1.1
 */
public class GetArticleContent
{
    private Connection conn    = null;
		private Article    article = new Article();
		
		public GetArticleContent()
		{
		    try
				{
            this.conn = DBConnection.getConnection();
				}
				catch(Exception e){}
		}
		
		public Article getArticle()
		{
				return this.article;
		}
		
		public void getArticleContent(int articleId)
		{
				if(articleId <= 0)
				{
				    this.article = null;
				    return;
				}
				
				String query = "SELECT `Article`.`title`,`Article`.`author`,`Article`.`time`,`Article`.`from`,`Article`.`class`,`Article`.`content`,`Article`.`read`,`Class`.`name` FROM `com_tiandinet_jsp_struts_article_content` AS `Article`,`com_tiandinet_jsp_struts_article_class` AS `Class` WHERE `Article`.`id`="+articleId+" AND `Article`.`show`=1 AND `Class`.`class`=`Article`.`class`";
				
				TimeMaker tMaker     = new TimeMaker();
		    try
				{
				    Statement stmt = this.conn.createStatement();
						ResultSet rs   = stmt.executeQuery(query);
						while(rs.next())
						{
						    this.article.setId(articleId);
								this.article.setTitle(rs.getString(1));
								this.article.setAuthor(rs.getString(2));
								 
								//设置时间
								tMaker.makeTime(rs.getLong(3));
								this.article.setTime(tMaker.getFormatTime());
								
								this.article.setFrom(rs.getString(4));
								this.article.setClassId(rs.getString(5));
								this.article.setContent(rs.getString(6));
								this.article.setRead(rs.getInt(7));
								this.article.setClassName(rs.getString(8));
						}

						rs.close();
				}
				catch(Exception e)
				{
				}
				
				//文章阅读数加一
				this.readAdd(articleId);
				
				try
				{
		        this.conn.close();
				}
				catch(Exception e)
				{}
				
				return;
		}
		
		//文章阅读数加1
		public void readAdd(int articleId)
		{
		    String update = "UPDATE `com_tiandinet_jsp_struts_article_content` SET `read`=`read`+1 WHERE `id`="+articleId;
				try
				{
				    Statement stmt = this.conn.createStatement();
						stmt.executeUpdate(update);
				}
				catch(SQLException sqle)
				{
				}
		}
}