package beans;
import java.sql.*;
public class connDB{
Connection conn=null;
Statement stmt=null;
ResultSet rs=null;
public connDB(){
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}catch(java.lang.ClassNotFoundException e){
System.err.println(e.getMessage());
}
}
/***************************************************
*method name: executeQuery()
*功能:执行查询操作
*return value: ResultSet
*2007-03-05
****************************************************/
public ResultSet executeQuery(String sql){
try{
conn=DriverManager.getConnection("jdbc:odbc:db_bookmanage");
stmt=conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
rs=stmt.executeQuery(sql);
}catch(SQLException ex){
System.err.println(ex.getMessage());
}
return rs;
}
/***************************************************
*method name: executeUpdate()
*功能:执行更新操作
*return value: int
*2007-03-05
****************************************************/
public int executeUpdate(String sql){
int result=0;
try{
conn=DriverManager.getConnection("jdbc:odbc:db_bookmanage");
stmt=conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
result=stmt.executeUpdate(sql);
}catch(SQLException ex){
result=0;
}
return result;
}
/***************************************************
*method name:executeUpdate_id()
*功能:执行更新操作并返回自动编号的值
*return value: int
*2007-03-05
****************************************************/
public int executeUpdate_id(String sql) {
int result = 0;
try{
conn=DriverManager.getConnection("jdbc:odbc:db_bookmanage");
stmt=conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
result = stmt.executeUpdate(sql);
String ID = "select @@IDENTITY as id";
rs = stmt.executeQuery(ID);
if (rs.next()) {
int autoID = rs.getInt("id");
result = autoID;
}
}
catch (SQLException ex) {
result = 0;
}
return result;
}
/***************************************************
*method name: close()
*功能:关闭数据库链接
*return value: void
*2007-03-05
****************************************************/
public void close() {
try {
if (rs != null) {
rs.close(); //关闭ResultSet结果集
}
}
catch (Exception e) {
e.printStackTrace(System.err);
}
try {
if (stmt != null) {
stmt.close(); //关闭Statement
}
}
catch (Exception e) {
e.printStackTrace(System.err);
}
try {
if (conn != null) {
conn.close(); //关闭Connection
}
}
catch (Exception e) {
e.printStackTrace(System.err);
}
}
}
基于Java的在线购物系统 （315个子文件） 
BaseDatabaseMetaData.class 37KB BaseEscapeParsingLexTable.class 29KB BaseDatabaseMetaDataWrapper.class 25KB BaseResultSet.class 23KB BaseEscapeParsingYaccTable_RowData1.class 22KB BaseEscapeParsingYaccTable_RowData2.class 21KB BaseResultSetWrapper.class 20KB BaseEscapeParsingYacc.class 19KB BaseData.class 19KB BaseStatement.class 19KB BaseImplDatabaseMetaData.class 17KB BasePreparedStatement.class 11KB BaseEscapeParsingLex.class 11KB BaseConnection.class 11KB BaseLocalMessages.class 10KB BaseSQLParser_Full.class 9KB BaseSQL.class 8KB BaseImplStaticCursorResultSet.class 8KB BaseDataSource.class 8KB BaseImplUpdatableResultSet.class 8KB BaseClob.class 7KB BaseCallableStatement.class 7KB BasePreparedStatementWrapper.class 7KB SSYacc.class 7KB BaseConnectionWrapper.class 7KB BaseStatementWrapper.class 6KB BaseSQLScanner_Full.class 6KB BaseCallableStatementWrapper.class 5KB BaseBlob.class 5KB BaseEscapeTranslator.class 5KB BasePooledConnection.class 5KB BaseSQLScanner_ParametersAndEscapes.class 5KB BaseImplSortCursorResultSet.class 4KB BaseEscapeParsingYaccTable.class 4KB SSLexTable.class 4KB BaseSQLEscapeProcessor.class 4KB BaseExceptions.class 4KB BaseResultSetMetaData.class 3KB BaseFunctionEscape.class 3KB BaseDriver.class 3KB BaseImplStatement.class 3KB BaseParseInfoTree.class 3KB BaseInputStreamWrapper.class 3KB BaseJoinEscape.class 3KB BaseXAResource.class 3KB BaseCharacterStreamWrapper.class 3KB BaseXAConnection.class 3KB BaseSQLTreeNode.class 3KB BaseImplConnection.class 3KB BaseDataSourceFactory.class 2KB SSLex.class 2KB BaseImplServiceResultSet.class 2KB BaseLicenseUtility.class 2KB BaseColumn.class 2KB BaseXADataSource.class 2KB BaseImplResultSet.class 2KB BaseWarnings.class 2KB BaseClobOutputStream.class 2KB SSLexConsumer.class 2KB BaseColumns.class 2KB BaseImplCachedClob.class 2KB BaseURLParser.class 2KB BaseSQLTreeTraverser.class 2KB BaseImplFilterCursorResultSet.class 2KB BaseClobInputStream.class 2KB BaseMessages.class 2KB connDB.class 2KB BaseImplCachedBlob.class 2KB SSYaccTable.class 2KB SSYaccTableRow.class 2KB BaseParseInfoTreeCursor.class 2KB BaseSQLParser_ParametersAndEscapes.class 2KB BaseTypeInfoImplResultSet.class 2KB BaseImplSearchableClob.class 2KB BaseSQLParameterProcessor.class 2KB BaseTimestampEscape.class 2KB BaseSQLStringGenerator.class 2KB BaseSQLListManipulator.class 2KB SSLexLexeme.class 2KB BaseSQLFromSpecificationGenerator.class 2KB BasePooledConnectionWrapper.class 2KB BaseLog.class 2KB BaseImplClob.class 2KB BaseBlobOutputStream.class 2KB BaseClassUtility.class 2KB BaseConnectionPool.class 2KB BaseDependents.class 2KB BaseEscapeParameterList.class 2KB BaseResultSetFilterDescriptor.class 2KB BaseSQLListPartManipulator.class 1KB BaseBlobInputStream.class 1KB BaseParameter.class 1KB BaseDriverPropertyInfos.class 1KB BaseSQLParenExpListManipulator.class 1KB BaseImplSearchableBlob.class 1KB SSYaccTableRowEntry.class 1KB BaseConnectionProperties.class 1KB SSLexFinalState.class 1KB BaseImplClobService.class 1KB BaseParameters.class 1KB共 315 条
- 1
- 2
- 3
- 4
资源评论
