package?com.DBConnectionManager;

import?java.sql.*;


public?class?DBConnect?{
??private?Connection?conn?=?null;
??private?Statement?stmt?=?null;
??private?PreparedStatement?prepstmt?=?null;
??private?DBConnectionManager?dcm?=?null;

??void?init（）?{?
????
????dcm?=?DBConnectionManager.getInstance（）;
????conn?=?dcm.getConnection（“OracleDB“）;
????
??}

??/**
???*?構(gòu)造數(shù)據(jù)庫的連接和訪問類
???*/
??public?DBConnect（）?throws?Exception?{
????init（）;
????stmt?=?conn.createStatement（）;
??}

??public?DBConnect（int?resultSetType?int?resultSetConcurrency）
?????????throws?Exception?{
????init（）;
????stmt?=?conn.createStatement（resultSetType?resultSetConcurrency）;
??}

??/**
???*?構(gòu)造數(shù)據(jù)庫的連接和訪問類
???*?預(yù)編譯SQL語句
???*?@param?sql?
???*/
??public?DBConnect（String?sql）?throws?Exception?{
????init（）;
????this.prepareStatement（sql）;
??}

???public?DBConnect（String?sql?int?resultSetType?int?resultSetConcurrency）
??????????throws?Exception?{
?????init（）;
?????this.prepareStatement（sql?resultSetType?resultSetConcurrency）;
???}

???/**
????*?返回連接
????*?@return?Connection?連接
????*/
???public?Connection?getConnection（）?{
?????return?conn;
???}

???/**
????*?PreparedStatement
????*?@return?sql?預(yù)設(shè)SQL語句
????*/
???public?void?prepareStatement（String?sql）?throws?SQLException?{
?????prepstmt?=?conn.prepareStatement（sql）;
???}

???public?void?prepareStatement（String?sql?int?resultSetType?int?resultSetConcurrency）
??????????throws?SQLException?{
?????prepstmt?=?conn.prepareStatement（sql?resultSetType?resultSetConcurrency）;
???}

???/**
????*?設(shè)置對應(yīng)值
????*
????*?@param?index?
????*?@param?value?
????*/
???public?void?setString（int?indexString?value）?throws?SQLException?{
?????prepstmt.setString（index?value）;
???}

???public?void?setInt（int?indexint?value）?throws?SQLException?{
?????prepstmt.setInt（indexvalue）;
???}

???public?void?setBoolean（int?indexboolean?value）?throws?SQLException?{
?????prepstmt.setBoolean（indexvalue）;
???}

???public?void?setDate（int?indexDate?value）?throws?SQLException?{
?????prepstmt.setDate（indexvalue）;
???}

???public?void?setLong（int?indexlong?value）?throws?SQLException?{
?????prepstmt.setLong（indexvalue）;
???}

???public?void?setFloat（int?indexfloat?value）?throws?SQLException?{
?????prepstmt.setFloat（indexvalue）;
???}

???public?void?setBytes（int?indexbyte[]?value）?throws?SQLException{
?????prepstmt.setBytes（indexvalue）;
???}

???public?void?clearParameters（）?throws?SQLException?{
?????prepstmt.clearParameters（）;
?????prepstmt=null;
???}

???/**
????*?返回預(yù)設(shè)狀態(tài)
????*/
???public?PreparedStatement?getPreparedStatement（）?{
?????return?prepstmt;
???}

???/**
????*?返回狀態(tài)
????*?@return?Statement?狀態(tài)
????*/
???public?Statement?getStatement（）?{
?????return?stmt;
???}

???/**
????*?執(zhí)行SQL語句返回字段集
????*?@param?sql?SQL語句
????*?@return?ResultSet?字段集
????*/
???public?ResultSet?executeQuery（String?sql）?throws?SQLException?{
?????if?（stmt?!=?

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----

?????文件????????833??2013-09-23?09:53??文檔管理\DocuManager\.classpath

?????文件???????1044??2013-09-23?09:53??文檔管理\DocuManager\.project

?????文件????????503??2013-09-23?09:53??文檔管理\DocuManager\.settings\.jsdtscope

?????文件????????149??2013-09-23?16:16??文檔管理\DocuManager\.settings\org.eclipse.core.resources.prefs

?????文件????????395??2013-09-23?09:53??文檔管理\DocuManager\.settings\org.eclipse.jdt.core.prefs

?????文件????????463??2013-09-23?09:53??文檔管理\DocuManager\.settings\org.eclipse.wst.common.component

?????文件????????345??2013-09-23?09:53??文檔管理\DocuManager\.settings\org.eclipse.wst.common.project.facet.core.xml

?????文件?????????49??2013-09-23?09:53??文檔管理\DocuManager\.settings\org.eclipse.wst.jsdt.ui.superType.container

?????文件??????????6??2013-09-23?09:53??文檔管理\DocuManager\.settings\org.eclipse.wst.jsdt.ui.superType.name

?????目錄??????????0??2013-09-30?16:19??文檔管理\DocuManager\.settings

?????文件????????316??2013-09-23?11:01??文檔管理\DocuManager\build\classes\com\DBConnectionManager\DB.properties

?????文件???????4313??2013-09-30?16:15??文檔管理\DocuManager\build\classes\com\DBConnectionManager\DBConnect.class

?????文件???????4145??2013-09-30?16:15??文檔管理\DocuManager\build\classes\com\DBConnectionManager\DBConnectionManager$DBConnectionPool.class

?????文件???????6795??2013-09-30?16:15??文檔管理\DocuManager\build\classes\com\DBConnectionManager\DBConnectionManager.class

?????目錄??????????0??2013-09-30?16:19??文檔管理\DocuManager\build\classes\com\DBConnectionManager

?????文件???????1019??2013-09-30?16:15??文檔管理\DocuManager\build\classes\com\unit\ChineseConversion\ChineseConversion.class

?????目錄??????????0??2013-09-30?16:19??文檔管理\DocuManager\build\classes\com\unit\ChineseConversion

?????文件??????12264??2013-09-30?16:15??文檔管理\DocuManager\build\classes\com\unit\DateConversion\DateConversion.class

?????目錄??????????0??2013-09-30?16:19??文檔管理\DocuManager\build\classes\com\unit\DateConversion

?????文件???????1411??2013-09-30?16:15??文檔管理\DocuManager\build\classes\com\unit\ValidateNum\ValidateNum.class

?????目錄??????????0??2013-09-30?16:19??文檔管理\DocuManager\build\classes\com\unit\ValidateNum

?????目錄??????????0??2013-09-30?16:19??文檔管理\DocuManager\build\classes\com\unit

?????目錄??????????0??2013-09-30?16:19??文檔管理\DocuManager\build\classes\com

?????文件????????503??2013-09-30?16:16??文檔管理\DocuManager\build\classes\edu\cqu\common\Constants.class

?????文件???????1660??2013-09-30?16:16??文檔管理\DocuManager\build\classes\edu\cqu\common\DateUtil.class

?????文件???????3757??2013-09-30?16:16??文檔管理\DocuManager\build\classes\edu\cqu\common\DownloadFile.class

?????文件????????354??2013-09-30?16:16??文檔管理\DocuManager\build\classes\edu\cqu\common\Entity.class

?????文件??????10957??2013-09-30?16:16??文檔管理\DocuManager\build\classes\edu\cqu\common\MultipartRequest.class

?????目錄??????????0??2013-09-30?16:19??文檔管理\DocuManager\build\classes\edu\cqu\common

?????文件???????5089??2013-09-30?16:16??文檔管理\DocuManager\build\classes\edu\cqu\filemanager\dao\FileDAOImpl.class

............此處省略76個文件信息