commentbean.java

在系统开发过程中用到了javabean和jsp技术

/**********************************************************
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.text.*;
import java.util.*;
import java.lang.*;
import java.io.*;
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);
		
	}	

	public static void main(String args[]) 
	{
		CommentBean mb = new CommentBean();		
		Hashtable ht = new Hashtable();
			ht.put("ARTICLEID","2");
			ht.put("CONTENT","炼钢厂ffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffff");
			ht.put("CRITIC","1");
		System.out.println("begin\r\n\r\n");
		System.out.println(ht+"\r\n\r\n");
		System.out.println(mb.addCom(ht));
		System.out.println(mb.getData());
		System.out.println(mb.getData("1","1"));
		System.out.println(mb.getData("1","2"));
		mb.closeConn();
		System.out.println("\r\n\r\nend");
	}
}