wzbean.java~14~

c++通信编程学习1

package com.j2ee.func.jswz;
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>
 *         public Vector selectWzInfo(String select_sql) throws SQLException {

 *
 * <p>Company: </p>
 *
 * @author not attributable
 * @version 1.0
 */
public class WzBean{
    public WzBean() {
    }
    public Vector selectWzInfo(String select_sql) throws SQLException {
        J2eedatabase j2db=new J2eedatabase();
        j2db.selectDB(select_sql);
        Vector vct=new Vector();
        while(j2db.rs.next()){
            WzInfo ni=new WzInfo();
            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.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 selectTjwz(String select_tjsql) throws SQLException {
        J2eedatabase j2db=new J2eedatabase();
        j2db.selectDB(select_tjsql);
        Vector vct=new Vector();
            while (j2db.rs.next()) {
                TjwzInfo tjni = new TjwzInfo();
                tjni.setId(j2db.rs.getInt("tjwz.id"));
                tjni.setWzid(j2db.rs.getInt("jswzinfo.id"));
                tjni.setWztitle(j2db.rs.getString("jswzinfo.title"));
                tjni.setWzdate(j2db.rs.getString("jswzinfo.wzdate"));
                tjni.setType(j2db.rs.getString("jswzinfo.type"));
                tjni.setSeecount(j2db.rs.getString("jswzinfo.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 boolean updateSeecount(String sql){
        J2eedatabase j2db=new J2eedatabase();
        boolean bl=j2db.updateDB(sql);
        j2db.closeDB();
        return bl;
    }
//*********************
     public boolean insertWz(String sql){
         J2eedatabase j2db=new J2eedatabase();
        boolean bl=j2db.insertDB(sql);
        return bl;
    }
//****************************
    public boolean deleteWz(String sql){
        J2eedatabase j2db=new J2eedatabase();
        boolean bl=j2db.deleteDB(sql);
        j2db.closeDB();
        return bl;
    }

}