j2eedbbean.java~1~

c++通信编程学习1

package com.j2ee.database;
/**
 * <p>Title: </p>
 * <p>Description: </p>
 * <p>Copyright: Copyright (c) 2004</p>
 * <p>Company:天津城市建设学院计算机系 </p>
 * @author 杨帆
 * @version 1.0
 *
*/

import java.sql.*;
//所有访问数据库的父类，该类完成基本的数据库访问
public class DBBean extends DataBase{

    public DBBean() {
    }
    /**
     * 获取记录数
     *
     * @return int
     * @param sqlstr String
     */
    public int getRowcount(String sqlstr) {
            DBBean db = new DBBean();
            int rowcount=0;
            try {
                db.researchDB(sqlstr);
                if(db.rs.next()) {
                    rowcount=db.rs.getInt(1);
                }
            } catch (SQLException ex) {
                //日志处理
                this.dex = ex;
                db.closeDB();
                return -1;
            }
            this.dex = db.dex;
            db.closeDB();
            return rowcount;
        }
    /**
     * 删除
     *
     * @param sqlstr String
     * @return boolean
     */
    public boolean delete(String sqlstr) {
                DBBean db = new DBBean();
                if (!db.deleteDB(sqlstr)) {
                    this.dex = db.dex;
                    db.closeDB();
                    return false;
                }
                db.closeDB();
                return true;
            }
    /**
     * 插入
     *
     * @param sqlstr String
     * @return boolean
     */
    public boolean insert(String sqlstr) {
                    boolean bsuc = false;
                    DBBean db = new DBBean();
                    bsuc = db.insertDB(sqlstr);
                    if (bsuc == false) {
                        this.dex = db.dex;
                        return false;
                    }
                    return true;
                }
    /**
     * 修改
     *
     * @param sqlstr String
     * @return boolean
     */
    public boolean update(String sqlstr) {
                boolean bsuc = false;
                DBBean db = new DBBean();
                bsuc = db.updateDB(sqlstr);
                if (bsuc == false) {
                    this.dex = db.dex;
                    return false;
                }
                return true;
            }

}