commentbean.java

这是一个很好用的软件

/*******************************************************************************
 * Version 1.0 Date:2003-10-21 Description:新闻评论表:列表查询、单条信息查询、增加记录、修改记录、删除记录
 * Other: Variable List: 1.int strID //唯一编号
 * 
 * Function List: 1.public void setID(String o)//设置评论编号
 * 
 * 2.public Vector getData()//取得新闻评论表所有记录 3.public Vector getData(String
 * str,String id)//取得某一条新闻或某人的所有评论记录
 * 
 * 4.public void addCom(Hashtable hash)//增加新闻评论表数据记录 History:
 *  
 ******************************************************************************/
package oa.bean;

import java.util.*;
import java.sql.*;
import oa.main.*;

public class CommentBean extends ParentBean {
	int strID = -1; //唯一编号

	public void setID(String o)//设置评论编号
	{
		strID = Integer.parseInt(o);
	}

	public Vector getData()//取得新闻评论表所有记录
	{
		Vector vect = new Vector();
		String sql = "";

		sql = " select * from news.commentb order by articleid,id ";

		ResultSet rs = selectRecord(sql);
		Statement stmt = null;

		try {
			//取得列数和列名
			ResultSetMetaData rsmd = rs.getMetaData();
			int cols = rsmd.getColumnCount();
			while (rs.next()) {
				Hashtable hash = new Hashtable();
				for (int i = 1; i <= cols; i++) {
					String field = ds.toString(rsmd.getColumnName(i));
					String value = ds.toString(rs.getString(i));
					hash.put(field, value);
				}
				vect.add(hash);
			}
		} catch (Exception e) {
			System.out.println("CommentBean.getData()运行时出错：" + e);
		} finally {
			if (rs != null)
				try {
					stmt = rs.getStatement();
					rs.close();
				} catch (Exception e) {
					System.out.println("CommentBean.getData()关闭记录集rs时出错" + e);
				}
			if (stmt != null)
				try {
					stmt.close();
				} catch (Exception e) {
					System.out.println("CommentBean.getData()关闭声明时statement出错"
							+ e);
				}
		}
		return vect;
	}

	public Vector getData(String str, String id)//取得某一条新闻或某人的所有评论记录
	{
		Vector vect = new Vector();
		String sql = "";

		if (id.equals("1")) //取得某一条新闻的所有评论记录
			sql = " select * from news.commentb where articleid=" + str
					+ " order by id ";
		if (id.equals("2")) //取得某人的所有评论记录
			sql = " select * from news.commentb where Critic=" + str
					+ " order by articleid,id ";

		ResultSet rs = selectRecord(sql);
		Statement stmt = null;
		try {

			//取得列数和列名
			ResultSetMetaData rsmd = rs.getMetaData();
			int cols = rsmd.getColumnCount();
			while (rs.next()) {
				Hashtable hash = new Hashtable();
				for (int i = 1; i <= cols; i++) {
					String field = ds.toString(rsmd.getColumnName(i));
					String value = ds.toString(rs.getString(i));
					hash.put(field, value);
				}
				vect.add(hash);
			}

		} catch (Exception e) {
			System.out.println("CommentBean.getData(String,String)运行时出错：" + e);
		} finally {
			if (rs != null)
				try {
					stmt = rs.getStatement();
					rs.close();
				} catch (Exception e) {
					System.out
							.println("CommentBean.getData(String,String)关闭记录集rs时出错"
									+ e);
				}
			if (stmt != null)
				try {
					stmt.close();
				} catch (Exception e) {
					System.out
							.println("CommentBean.getData(String,String)关闭声明时statement出错"
									+ e);
				}
		}
		return vect;
	}

	public void delete(String cid) {
		deleteRecord("delete from news.commentb where id=" + cid);
	}

	public int addCom(Hashtable hash)//增加新闻评论表数据记录
	{
		int intMax = db.makeID("COMMENTB", "ID", "", "", true);
		String strArticleid = ds.toString((String) hash.get("ARTICLEID"));
		String strComment = ds.toString((String) hash.get("CONTENT"));
		String strTime = ds.getDateTime();
		String strCritic = ds.toString((String) hash.get("CRITIC"));

		Vector vect = new Vector();
		vect.add("COMMENTB");
		vect.add(addVector("ID", String.valueOf(intMax), "NUM"));
		vect.add(addVector("ARTICLEID", strArticleid, "NUM"));
		vect.add(addVector("CONTENT", strComment, "CHAR"));
		vect.add(addVector("TIME", strTime, "CHAR"));
		vect.add(addVector("CRITIC", strCritic, "CHAR"));

		return insertRecord(vect);

	}

}