newsbean.java~15~

c++通信编程学习1

package com.j2ee.func.news;
import java.util.Vector;
import com.j2ee.database.J2eedatabase;
import java.sql.SQLException;

/**
 * <p>Title: </p>
 *
 * <p>Description: </p>
 *
 * <p>Copyright: Copyright (c) 2006</p>
 *
 * <p>Company: </p>
 *
 * @author not attributable
 * @version 1.0
 */
public class NewsBean {
    public NewsBean() {
    }
    public Vector selectNews(String select_sql) throws SQLException {
        J2eedatabase j2db=new J2eedatabase();
        j2db.selectDB(select_sql);
        Vector vct=new Vector();
        while(j2db.rs.next()){
            NewsInfo ni=new NewsInfo();
            ni.setId(j2db.rs.getInt("id"));
            ni.setNewsdate(j2db.rs.getString("newsdate"));
            ni.setSeecount(j2db.rs.getInt("seecount"));
            ni.setTitle(j2db.rs.getString("title"));
            ni.setType(j2db.rs.getString("type"));
            ni.setAuthor(j2db.rs.getString("author"));
            ni.setComefrom(j2db.rs.getString("comefrom"));
            ni.setContent(j2db.rs.getString("content"));
            vct.addElement(ni);
        }
        j2db.closeDB();
        return vct;
    }
    public Vector selectTjnews(String select_tjsql) throws SQLException {
        J2eedatabase j2db=new J2eedatabase();
        j2db.selectDB(select_tjsql);
        Vector vct=new Vector();
            while (j2db.rs.next()) {
                TjnewsInfo tjni = new TjnewsInfo();
                tjni.setId(j2db.rs.getInt("tjnews.id"));
                tjni.setNewsid(j2db.rs.getInt("news.id"));
                tjni.setNewstitle(j2db.rs.getString("news.title"));
                tjni.setNewsdate(j2db.rs.getString("news.newsdate"));
                vct.addElement(tjni);
            }
      j2db.closeDB();
      return vct;
    }
    public int selectCount(String sql) throws SQLException {
        J2eedatabase j2db=new J2eedatabase();
        j2db.selectDB(sql);
        j2db.rs.next();
        int count=j2db.rs.getInt("count(*)");
        return count;
    }
    public boolean updateSeecount(String sql){
        J2eedatabase j2db=new J2eedatabase();
        boolean bl=j2db.updateDB(sql);
        j2db.closeDB();
        return bl;
    }
    public boolean insertNews(String sql){
        J2eedatabase j2db=new J2eedatabase();
       boolean bl=j2db.insertDB(sql);
       j2db.closeDB();
       return bl;

    }

}