【Java开源代码栏目提醒】:以下是网学会员为您推荐的Java开源代码-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.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();