zlxzbean.java~7~

c++通信编程学习1

package com.j2ee.func.zlxz;
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 ZlxzBean {

    public ZlxzBean() {
    }
    public Vector selectZlxzInfo(String select_sql) throws SQLException {
        J2eedatabase j2db=new J2eedatabase();
        j2db.selectDB(select_sql);
        Vector vct=new Vector();
        while(j2db.rs.next()){
            ZlxzInfo ni=new ZlxzInfo();
            ni.setId(j2db.rs.getInt("id"));
            ni.setSentdate(j2db.rs.getString("sentdate"));
            ni.setSeecount(j2db.rs.getInt("seecount"));
            ni.setTitle(j2db.rs.getString("title"));
            ni.setType(j2db.rs.getString("type"));
            ni.setDowncount(j2db.rs.getInt("downcount"));
            ni.setLink(j2db.rs.getString("link"));
            ni.setLoadman(j2db.rs.getString("loadman"));
            ni.setShortbrief(j2db.rs.getString("shortbrief"));

            vct.addElement(ni);
        }
        j2db.closeDB();
        return vct;
    }
    //**********************
   public Vector selectTjxz(String select_tjsql) throws SQLException {
        J2eedatabase j2db=new J2eedatabase();
        j2db.selectDB(select_tjsql);
        Vector vct=new Vector();
            while (j2db.rs.next()) {
                TjxzInfo tjni = new TjxzInfo();
                tjni.setId(j2db.rs.getInt("id"));
                tjni.setXzid(j2db.rs.getInt("zlxz.id"));
                tjni.setXztitle(j2db.rs.getString("zlxz.title"));
                tjni.setSentdate(j2db.rs.getString("zlxz.sentdate"));
                tjni.setType(j2db.rs.getString("zlxz.type"));
                tjni.setSeecount(j2db.rs.getString("zlxz.seecount"));
                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 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 boolean insertXz(String sql){
    J2eedatabase j2db=new J2eedatabase();
   boolean bl=j2db.insertDB(sql);
   return bl;
}
    public boolean deleteZl(String sql){
        J2eedatabase j2db=new J2eedatabase();
        boolean bl=j2db.deleteDB(sql);
        j2db.closeDB();
        return bl;
    }
    public boolean updateSeecount(String sql){
        J2eedatabase j2db=new J2eedatabase();
        boolean bl=j2db.updateDB(sql);
        j2db.closeDB();
        return bl;
    }
}