getarticleclasses.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.ArticleClass;

/**
 * @author Meng Yang
 * @version 1.1
 */
public class GetArticleClasses
{
    private Collection coll = new ArrayList();
		
		public Collection getColl()
		{
		    return this.coll;
		}
		
		public GetArticleClasses()
		{
		    try
				{
		        Connection conn = DBConnection.getConnection();
						if(conn != null)
						{
					      Statement stmt = conn.createStatement();
								ResultSet rs = stmt.executeQuery("SELECT * FROM `com_tiandinet_jsp_struts_article_class` ORDER BY `id`");
								while(rs.next())
								{
								    ArticleClass ac = new ArticleClass();
										 ac.setId(rs.getInt("id"));
										 ac.setClassId(rs.getString("class"));
										 ac.setClassName(rs.getString("name"));
										this.coll.add(ac);
								}
								rs.close();
								conn.close();
						}
						else
						{
						    this.coll = null;
						}
				}
				catch(Exception e)
				{
				    this.coll = null;
				}
		}
}