DBBeanBase (onecode-database 1.0.5 API)

java.lang.Object
- com.ds.common.database.DBBeanBase

```
public class DBBeanBase
extends Object
```
不建议再使用，除非修改基础包

作者:

wenzhang

字段概要

字段
限定符和类型	字段和说明
`protected Connection`	`con`
`protected String`	`dataSourceName`
`protected DBResult`	`dbResult`
`protected boolean`	`isTransaction`
`protected static com.ds.common.logging.Log`	`log` Commons Logging instance.
`protected static int`	`nConCount`
`PreparedStatement`	`prestatm`
`protected int`	`resultcolumns`
`protected int`	`resultrows`
`protected ResultSet`	`resultset`
`Statement`	`statm`
`protected String`	`strSql`
`protected long`	`tm`

构造器概要

构造器
构造器和说明
`DBBeanBase(Connection con, boolean value)`
`DBBeanBase(String configKey)` 默认构造方法,不进行事务处理
`DBBeanBase(String configKey, boolean value)` 构造方法参数——value 值 true——表示要进行事务处理 false——表示不进行事务处理

方法概要

所有方法静态方法实例方法具体方法
限定符和类型	方法和说明
`protected static void`	`changeCount(int nChange)` 纪录连接的数量
`void`	`close()` Close the result set and release resources
`boolean`	`commit()` Insert the method's description here.
`protected void`	`createDBResult()`
`int`	`executePreparedQuery()` 执行准备好的SQL
`int`	`executePreparedUpdate()` 执行准备好的SQL
`int`	`executeQuery(String strSql)` Execute query.
`int`	`executeUpdate(String strSql)` Execute update.
`Connection`	`getConn()` 取得DBBean内的连接，可能是null
`protected Connection`	`getConnection(String configKey)` 从连接池中得到数据库的连接
`DBResult`	`getSelectDBResult()`
`boolean`	`isClosed()`
`boolean`	`prepareSql(String strPreSql)` 准备SQL
`boolean`	`rollback()` Insert the method's description here.
`void`	`setCharacterStream(int parameterIndex, Reader reader, int length)`
`void`	`setDate(int index, Date value)`
`void`	`setFloat(int index, float value)`
`void`	`setInt(int index, int value)`
`void`	`setLong(int index, long value)`
`void`	`setNull(int index, int sqlType)`
`void`	`setSelectDBResult(DBResult rs)`
`void`	`setString(int index, String value)`
`void`	`setTime(int index, Timestamp value)`
`protected Object`	`valueAtColumnRow(int column, int row)` Utility method to get the value at a specific row and column index

从类继承的方法 java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

字段详细资料

log

protected static com.ds.common.logging.Log log

Commons Logging instance.

nConCount
```
protected static int nConCount
```

dataSourceName
```
protected String dataSourceName
```

con
```
protected Connection con
```

statm
```
public Statement statm
```

prestatm
```
public PreparedStatement prestatm
```

resultset
```
protected ResultSet resultset
```

tm
```
protected long tm
```

isTransaction
```
protected boolean isTransaction
```

resultrows
```
protected int resultrows
```

resultcolumns
```
protected int resultcolumns
```

dbResult
```
protected DBResult dbResult
```

strSql
```
protected String strSql
```

构造器详细资料
- DBBeanBase
```
public DBBeanBase(String configKey)
```
  默认构造方法,不进行事务处理
- DBBeanBase
```
public DBBeanBase(String configKey,
                  boolean value)
```
  构造方法参数——value 值 true——表示要进行事务处理 false——表示不进行事务处理
- DBBeanBase
```
public DBBeanBase(Connection con,
                  boolean value)
```

方法详细资料

changeCount

protected static void changeCount(int nChange)

纪录连接的数量

getConnection

protected Connection getConnection(String configKey)

从连接池中得到数据库的连接

executeQuery
```
public int executeQuery(String strSql)
```
Execute query. Creation date: (2001-7-6 16:25:27)

返回:

int 0 - failed 1 - successful 2 - user define 3 - user define ....

executeUpdate
```
public int executeUpdate(String strSql)
```
Execute update. Creation date: (2001-7-6 16:25:27)

返回:

int -1 - failed >=0 - affected rows ....

createDBResult
```
protected void createDBResult()
```

getSelectDBResult
```
public DBResult getSelectDBResult()
```

setSelectDBResult

public void setSelectDBResult(DBResult rs)

valueAtColumnRow
```
protected Object valueAtColumnRow(int column,
                                  int row)
                           throws ArrayIndexOutOfBoundsException
```
Utility method to get the value at a specific row and column index

参数:

column - the column containing the desired data

row - the row containing the desired data

返回:

the value of the column at the specified row

抛出:

ArrayIndexOutOfBoundsException - thrown when there is no data at the specified row

close
```
public void close()
```
Close the result set and release resources

commit
```
public boolean commit()
```
Insert the method's description here. Creation date: (01-9-25 15:13:54)

返回:

boolean

rollback
```
public boolean rollback()
```
Insert the method's description here. Creation date: (01-9-25 15:16:23)

返回:

boolean

prepareSql

public boolean prepareSql(String strPreSql)

准备SQL

executePreparedQuery
```
public int executePreparedQuery()
```
执行准备好的SQL

executePreparedUpdate
```
public int executePreparedUpdate()
```
执行准备好的SQL

setInt

public void setInt(int index,
                   int value)

setString

public void setString(int index,
                      String value)

setDate

public void setDate(int index,
                    Date value)

setFloat

public void setFloat(int index,
                     float value)

setTime

public void setTime(int index,
                    Timestamp value)

setLong

public void setLong(int index,
                    long value)

setNull

public void setNull(int index,
                    int sqlType)

setCharacterStream

public void setCharacterStream(int parameterIndex,
                               Reader reader,
                               int length)

isClosed
```
public boolean isClosed()
```

getConn
```
public Connection getConn()
```
取得DBBean内的连接，可能是null

返回:

类 DBBeanBase

字段概要

构造器概要

方法概要

从类继承的方法 java.lang.Object

字段详细资料

log

nConCount

dataSourceName

con

statm

prestatm

resultset

tm

isTransaction

resultrows

resultcolumns

dbResult

strSql

构造器详细资料

DBBeanBase

DBBeanBase

DBBeanBase

方法详细资料

changeCount

getConnection

executeQuery

executeUpdate

createDBResult

getSelectDBResult

setSelectDBResult

valueAtColumnRow

close

commit

rollback

prepareSql

executePreparedQuery

executePreparedUpdate

setInt

setString

setDate

setFloat

setTime

setLong

setNull

setCharacterStream

isClosed

getConn