`
- 浏览:
355478 次
- 性别:
- 来自:
苏州
-
-
-
-
-
#ifndefSAIOSQLCE_DLL_FILE
-
#defineSAIOSQLCE_DLL_FILE
-
#endif
-
#include"stdafx.h"
-
#include"SAIOSQLCEDBManage.h"
-
#include"SaioSqlce.h"
-
#ifdef_DEBUG
-
#undefTHIS_FILE
-
staticcharTHIS_FILE[]=__FILE__;
-
#definenewDEBUG_NEW
-
#endif
-
-
#defineCUP_DB_FILE_T("\\Saio\\UserPrograms\\WIC\\WICDB.sdf")
-
#defineCUP_DB_TEMP_T("\\Saio\\UserPrograms\\WIC\\WICDB.sd2")
-
-
-
- CDBManage::CDBManage()
- {
- }
- CDBManage::~CDBManage()
- {
- }
-
-
BOOLCDBManage::OpenDB()
- {
-
InitConnectvariable(_T("\\Saio\\UserPrograms\\WIC\\WICDB.sdf"));
-
returnOpenConnection();
- }
-
-
BOOLCDBManage::CloseDB()
- {
-
BOOLbRet=TRUE;
- bRet=CloseRecordset();
- bRet&=CloseConnection();
-
returnbRet;
- }
-
-
BOOLCDBManage::ShrinkDB()
- {
- CloseDB();
-
TCHARszDbPwd[]=_T("");
-
BOOLbRet=TRUE,bDelRet=FALSE;
-
DWORDdwErr=0;
-
HRESULThr=NOERROR;
- DBPROPSETdbpropset[2];
- DBPROPdbprop[2];
- IDBProperties*pIDBProperties=NULL;
- IDBCreateSession*pIDBCreateSession=NULL;
- ISSCECompact*pISSCECompact=NULL;
- IDBSchemaRowset*pIDBSchemaRowset=NULL;
- VariantInit(&dbprop[0].vValue);
-
hr=CoCreateInstance(CLSID_SQLSERVERCE_2_0,0,CLSCTX_INPROC_SERVER,IID_IDBProperties,(void**)&pIDBProperties);
-
if(FAILED(hr))
- {
- dwErr=GetLastError();
- bRet=FALSE;
-
gotoExit;
- }
- dbprop[0].dwPropertyID=DBPROP_INIT_DATASOURCE;
- dbprop[0].dwOptions=DBPROPOPTIONS_REQUIRED;
- dbprop[0].vValue.vt=VT_BSTR;
- dbprop[0].vValue.bstrVal=SysAllocString(CUP_DB_FILE);
-
if(NULL==dbprop[0].vValue.bstrVal)
- {
- hr=E_OUTOFMEMORY;
- dwErr=GetLastError();
- bRet=FALSE;
-
gotoExit;
- }
- dbprop[1].dwPropertyID=DBPROP_SSCE_DBPASSWORD;
- dbprop[1].dwOptions=DBPROPOPTIONS_REQUIRED;
- dbprop[1].vValue.vt=VT_BSTR;
- dbprop[1].vValue.bstrVal=SysAllocString(szDbPwd);
- dbpropset[0].guidPropertySet=DBPROPSET_DBINIT;
- dbpropset[0].rgProperties=dbprop;
- dbpropset[0].cProperties=1;
- ;
- dbpropset[1].guidPropertySet=DBPROPSET_SSCE_DBINIT;
- dbpropset[1].rgProperties=&dbprop[1];
- dbpropset[1].cProperties=1;
- hr=pIDBProperties->SetProperties(2,dbpropset);
-
if(FAILED(hr))
- {
- dwErr=GetLastError();
- bRet=FALSE;
-
gotoExit;
- }
-
hr=pIDBProperties->QueryInterface(IID_ISSCECompact,(void**)&pISSCECompact);
-
if(FAILED(hr))
- {
- dwErr=GetLastError();
- bRet=FALSE;
-
gotoExit;
- }
- bDelRet=DeleteFile(CUP_DB_TEMP);
- SysFreeString(dbprop[0].vValue.bstrVal);
- dbprop[0].vValue.bstrVal=SysAllocString(CUP_DB_TEMP);
-
if(NULL==dbprop[0].vValue.bstrVal)
- {
- hr=E_OUTOFMEMORY;
- dwErr=GetLastError();
- bRet=FALSE;
-
gotoExit;
- }
- hr=pISSCECompact->Compact(1,dbpropset);
-
if(FAILED(hr))
- {
- dwErr=GetLastError();
- bRet=FALSE;
-
gotoExit;
- }
- bDelRet=CopyFile(CUP_DB_TEMP,CUP_DB_FILE,FALSE);
-
if(bDelRet)
- {
- bDelRet=DeleteFile(CUP_DB_TEMP);
- }
- Exit:
- VariantClear(&dbprop[0].vValue);
-
if(NULL!=pISSCECompact)
- {
- pISSCECompact->Release();
- }
-
if(NULL!=pIDBSchemaRowset)
- {
- pIDBSchemaRowset->Release();
- }
-
if(NULL!=pIDBCreateSession)
- {
- pIDBCreateSession->Release();
- }
-
if(NULL!=pIDBProperties)
- {
- pIDBProperties->Release();
- }
-
returnbRet;
- }
-
-
BOOLCDBManage::InitDB()
- {
-
BOOLbRet=TRUE;
-
- CloseRecordset();
-
- bRet&=InitUserTable();
-
- bRet&=InitParamTable();
-
- bRet&=InitAPLTable();
-
- bRet&=InitPriceTable();
-
- bRet&=InitTransTable();
-
- bRet&=InitUpdateTable();
-
returnbRet;
- }
-
-
BOOLCDBManage::InitUserTable()
- {
-
BOOLbRet=TRUE;
-
-
CStringcsSql=_T("DROPTableUserTb");
- ExecuteSQL(csSql);
-
-
csSql=_T("CREATETABLEUserTb(uidnvarchar(6)PRIMARYKEY,pwdnvarchar(6)NOTNULL,privilegenchar(1)NOTNULL);");
- bRet&=ExecuteSQL(csSql);
-
-
-
-
-
csSql=_T("INSERTINTOUserTb(uid,pwd,privilege)VALUES('1234','1234','1');");
- bRet&=ExecuteSQL(csSql);
-
-
-
-
-
csSql=_T("INSERTINTOUserTb(uid,pwd,privilege)VALUES('123456','123456','2');");
- bRet&=ExecuteSQL(csSql);
-
returnbRet;
- }
-
BOOLCDBManage::InitParamTable()
- {
-
BOOLbRet=TRUE;
-
-
CStringcsSql=_T("DROPTableParamTb");
- ExecuteSQL(csSql);
-
-
csSql=_T("CREATETABLEParamTb(pidsmallintPRIMARYKEY,pnamenvarchar(30),pvaluenvarchar(40));");
- bRet&=ExecuteSQL(csSql);
-
returnbRet;
- }
-
BOOLCDBManage::InitAPLTable()
- {
-
BOOLbRet=TRUE;
-
-
CStringcsSql=_T("DROPTableAPLTb");
- ExecuteSQL(csSql);
-
-
csSql=_T("CREATETABLEAPLTb(upcnvarchar(17)PRIMARYKEY,descriptionnvarchar(50),categorynchar(2),subcategorynchar(3),punitnvarchar(10),maxpricenchar(6),ptypenchar(2));");
- bRet&=ExecuteSQL(csSql);
-
-
csSql=_T("INSERTINTOAPLTbVALUES('TestUPC1','JustForTest1','1','1-1','Unit1','40.25','1');");
- bRet&=ExecuteSQL(csSql);
-
csSql=_T("INSERTINTOAPLTbVALUES('TestUPC2','JustForTest2','2','2-1','Unit2','2.01','2');");
- bRet&=ExecuteSQL(csSql);
-
csSql=_T("INSERTINTOAPLTbVALUES('TestUPC3','JustForTest3','3','3-1','Unit3','1.2','1');");
- bRet&=ExecuteSQL(csSql);
-
-
returnbRet;
- }
-
BOOLCDBManage::InitPriceTable()
- {
-
BOOLbRet=TRUE;
-
-
CStringcsSql=_T("DROPTablePriceTb");
- ExecuteSQL(csSql);
-
-
csSql=_T("CREATETABLEPriceTb(upcnchar(17)PRIMARYKEY,pricenchar(6));");
- bRet&=ExecuteSQL(csSql);
-
-
-
csSql=_T("INSERTINTOPriceTbVALUES('a1b2c3d4','12.34');");
- bRet&=ExecuteSQL(csSql);
-
csSql=_T("INSERTINTOPriceTbVALUES('TestUPC1','34.45');");
- bRet&=ExecuteSQL(csSql);
-
csSql=_T("INSERTINTOPriceTbVALUES('TestUPC2','0.45');");
- bRet&=ExecuteSQL(csSql);
-
-
returnbRet;
- }
-
BOOLCDBManage::InitTransTable()
- {
-
BOOLbRet=TRUE;
-
-
CStringcsSql=_T("DROPTableTransTb");
- ExecuteSQL(csSql);
-
-
csSql=_T("CREATETABLETransTb(traceidnchar(6)PRIMARYKEY,msgtypenchar(4),amountnchar(12),uidnchar(4),transdatenchar(6),transtimenchar(6),aiicodenvarchar(12));");
- bRet&=ExecuteSQL(csSql);
-
-
csSql=_T("INSERTINTOTransTbVALUES('001','1','10','1234','081018','143302','0810181433');");
- bRet&=ExecuteSQL(csSql);
-
csSql=_T("INSERTINTOTransTbVALUES('002','2','20','1234','061018','143366','0610181433');");
- bRet&=ExecuteSQL(csSql);
-
csSql=_T("INSERTINTOTransTbVALUES('003','3','30','1234','081018','143100','0810181431');");
- bRet&=ExecuteSQL(csSql);
-
-
returnbRet;
- }
-
BOOLCDBManage::InitUpdateTable()
- {
-
BOOLbRet=TRUE;
-
-
CStringcsSql=_T("DROPTableUpdateTb");
- ExecuteSQL(csSql);
-
-
csSql=_T("CREATETABLEUpdateTb(tidnchar(2)PRIMARYKEY,tnamenvarchar(20),lupdatenchar(6),luptimenchar(6));");
- bRet&=ExecuteSQL(csSql);
-
returnbRet;
- }
-
BOOLCDBManage::AnalyzeBalance(BIItembiInput,Balance*balOutput)
- {
-
-
-
- CStringcsSQL;
-
WCHARwcCategory[2];
-
WCHARwcSubCategory[3];
- VARIANTvarUPC;
- VARIANTvarUnit;
- VARIANTvarDescription;
- VariantInit(&varUPC);
- VariantInit(&varUnit);
- VariantInit(&varDescription);
-
BOOLbRet=TRUE;
-
DWORDdwNum;
-
charTempArray[50];
-
if(balOutput==NULL)
-
returnFALSE;
-
memcpy(TempArray,biInput.byCategory,sizeof(biInput.byCategory));
- dwNum=MultiByteToWideChar(CP_ACP,0,TempArray,-1,NULL,0);
- MultiByteToWideChar(CP_ACP,0,TempArray,-1,wcCategory,dwNum);
-
memcpy(TempArray,biInput.bySubCategory,sizeof(biInput.bySubCategory));
- dwNum=MultiByteToWideChar(CP_ACP,0,TempArray,-1,NULL,0);
- MultiByteToWideChar(CP_ACP,0,TempArray,-1,wcSubCategory,dwNum);
-
csSQL.Format(_T("SELECT*FROMAPLTbWHEREcategory='%s'ANDsubcategory='%s';"),wcCategory,wcSubCategory);
-
MessageBox(NULL,csSQL,_T("OpenRecordset"),MB_OK);
-
- bRet&=OpenRecordset(csSQL);
-
if(GetRecordCount(csSQL)==0)
- {
-
return(bRet&=FALSE);
- }
-
else
- {
- MoveFirst();
-
varUPC=GetCollect(_T("upc"));
- dwNum=WideCharToMultiByte(CP_OEMCP,NULL,varUPC.bstrVal,-1,NULL,0,NULL,FALSE);
- WideCharToMultiByte(CP_OEMCP,NULL,varUPC.bstrVal,-1,TempArray,dwNum,NULL,FALSE);
-
-
-
- memcpy(balOutput->szItemUPC,TempArray,dwNum);
-
-
-
-
-
MessageBox(NULL,varUPC.bstrVal,_T("OpenRecordset"),MB_OK);
-
varUnit=GetCollect(_T("punit"));
- dwNum=WideCharToMultiByte(CP_OEMCP,NULL,varUnit.bstrVal,-1,NULL,0,NULL,FALSE);
- WideCharToMultiByte(CP_OEMCP,NULL,varUnit.bstrVal,-1,TempArray,dwNum,NULL,FALSE);
-
-
-
MessageBox(NULL,varUnit.bstrVal,_T("OpenRecordset"),MB_OK);
-
varDescription=GetCollect(_T("description"));
- dwNum=WideCharToMultiByte(CP_OEMCP,NULL,varDescription.bstrVal,-1,NULL,0,NULL,FALSE);
- WideCharToMultiByte(CP_OEMCP,NULL,varDescription.bstrVal,-1,TempArray,dwNum,NULL,FALSE);
-
-
-
MessageBox(NULL,varDescription.bstrVal,_T("OpenRecordset"),MB_OK);
-
-
-
-
-
- }
-
returnbRet;
- }
-
BOOLCDBManage::GetItemFromUPC(CStringcsUPC,ItemList*ilOutput)
- {
- CStringcsSql;
-
BOOLbRet=TRUE;
-
if(csUPC.GetLength()>=17)
- {
-
returnFALSE;
- }
-
csSql.Format(_T("SELECT*FROMAPLTb,PriceTbWHEREAPLTB.upc=PriceTb.upcANDAPLTB.upc='%s';"),csUPC);
- bRet&=OpenRecordset(csSql);
-
if(GetRecordCount(csSql)==0)
- {
-
returnFALSE;
- }
-
else
- {
-
- }
-
returnbRet;
- }
-
BOOLCDBManage::GetItemFromCategory(CStringcsCategory,CStringcsSubcategory,Balance*balOutput,EndBalance*ebalOutput)
- {
-
BOOLbRet=TRUE;
-
returnbRet;
- }
-
BOOLCDBManage::SetItemPrice(CStringcsUpc,CStringcsPrice)
- {
-
BOOLbRet=TRUE;
- CStringcsSQL;
-
if((csUpc.GetLength()>17)||(csPrice.GetLength()>6))
- {
-
returnFALSE;
- }
-
-
-
-
-
csSQL.Format(_T("UPDATEPriceTbSETprice='%s'WHEREupc='%s';"),csPrice,csUpc);
- bRet&=ExecuteSQL(csSQL);
-
-
csSQL.Format(_T("SELECT*FROMPriceTbWHEREupc='%s'ANDprice='%s';"),csUpc,csPrice);
-
if(GetRecordCount(csSQL)==0)
- {
- bRet&=FALSE;
- }
-
returnbRet;
- }
-
BOOLCDBManage::CheckPwdData(CStringcsUid,CStringcsPwd)
- {
-
BOOLbRet=TRUE;
- CStringcsSql;
-
if((csUid.GetLength()>6)||(csPwd.GetLength()>6))
- {
-
returnFALSE;
- }
-
csSql.Format(_T("SELECTuidFROMUserTbWHEREuid='%s'ANDpwd='%s';"),csUid,csPwd);
-
-
if(GetRecordCount(csSql)==0)
- {
- bRet&=FALSE;
- }
-
returnbRet;
- }
-
BOOLCDBManage::CheckParamData(){BOOLbRet=TRUE;returnbRet;}
-
BOOLCDBManage::CheckCardData(){BOOLbRet=TRUE;returnbRet;}
-
BOOLCDBManage::CheckResponseCode(){BOOLbRet=TRUE;returnbRet;}
-
BOOLCDBManage::CheckUPC(){BOOLbRet=TRUE;returnbRet;}
-
BOOLCDBManage::CheckNSF(){BOOLbRet=TRUE;returnbRet;}
-
BOOLCDBManage::CheckAmountData(){BOOLbRet=TRUE;returnbRet;}
-
BOOLCDBManage::CheckCountData(){BOOLbRet=TRUE;returnbRet;}
-
BOOLCDBManage::GetLastTransData(LastTransaction*ltGet)
- {
- VARIANTvTraceid;
- VARIANTvMsgtype;
- VARIANTvAmount;
- VARIANTvUid;
- VARIANTvTransdate;
- VARIANTvTranstime;
- VARIANTvAiicode;
- VariantInit(&vTraceid);
- VariantInit(&vMsgtype);
- VariantInit(&vAmount);
- VariantInit(&vUid);
- VariantInit(&vTransdate);
- VariantInit(&vTranstime);
- VariantInit(&vAiicode);
-
BOOLbRet=TRUE;
-
charTempArray[20];
-
LONGlRcdSize;
-
CStringcsSql=_T("SELECT*FROMTransTb;");
-
DWORDdwNum;
-
if(ltGet==NULL)
-
returnFALSE;
-
-
-
- bRet&=OpenRecordset(csSql);
-
if((lRcdSize=GetRecordCount(csSql))==0)
- {
-
return(bRet&=FALSE);
- }
-
else
- {
- MoveFirst();
-
for(longi=0;i<lRcdSize-1;i++)
-
- {
- MoveNext();
- }
-
-
-
vTraceid=GetCollect(_T("traceid"));
-
dwNum=WideCharToMultiByte(CP_OEMCP,NULL,vTraceid.bstrVal,-1,NULL,0,NULL,FALSE);
- WideCharToMultiByte(CP_OEMCP,NULL,vTraceid.bstrVal,-1,TempArray,dwNum,NULL,FALSE);
- memcpy(ltGet->TraceNum,TempArray,dwNum);
-
vMsgtype=GetCollect(_T("msgtype"));
- dwNum=WideCharToMultiByte(CP_OEMCP,NULL,vMsgtype.bstrVal,-1,NULL,0,NULL,FALSE);
- WideCharToMultiByte(CP_OEMCP,NULL,vMsgtype.bstrVal,-1,TempArray,dwNum,NULL,FALSE);
- memcpy(ltGet->byMsgType,TempArray,dwNum);
-
vAmount=GetCollect(_T("amount"));
- dwNum=WideCharToMultiByte(CP_OEMCP,NULL,vAmount.bstrVal,-1,NULL,0,NULL,FALSE);
- WideCharToMultiByte(CP_OEMCP,NULL,vAmount.bstrVal,-1,TempArray,dwNum,NULL,FALSE);
- memcpy(ltGet->byTransAmount,TempArray,dwNum);
-
vUid=GetCollect(_T("uid"));
- dwNum=WideCharToMultiByte(CP_OEMCP,NULL,vUid.bstrVal,-1,NULL,0,NULL,FALSE);
- WideCharToMultiByte(CP_OEMCP,NULL,vUid.bstrVal,-1,TempArray,dwNum,NULL,FALSE);
- memcpy(ltGet->byCashierID,TempArray,dwNum);
-
vTransdate=GetCollect(_T("transdate"));
- dwNum=WideCharToMultiByte(CP_OEMCP,NULL,vTransdate.bstrVal,-1,NULL,0,NULL,FALSE);
- WideCharToMultiByte(CP_OEMCP,NULL,vTransdate.bstrVal,-1,TempArray,dwNum,NULL,FALSE);
- memcpy(ltGet->byLocalTransDate,TempArray,dwNum);
-
vTranstime=GetCollect(_T("transtime"));
- dwNum=WideCharToMultiByte(CP_OEMCP,NULL,vTranstime.bstrVal,-1,NULL,0,NULL,FALSE);
- WideCharToMultiByte(CP_OEMCP,NULL,vTranstime.bstrVal,-1,TempArray,dwNum,NULL,FALSE);
- memcpy(ltGet->byLocalTransTime,TempArray,dwNum);
-
vAiicode=GetCollect(_T("aiicode"));
- dwNum=WideCharToMultiByte(CP_OEMCP,NULL,vAiicode.bstrVal,-1,NULL,0,NULL,FALSE);
- WideCharToMultiByte(CP_OEMCP,NULL,vAiicode.bstrVal,-1,TempArray,dwNum,NULL,FALSE);
- memcpy(ltGet->byAcquirerCode,TempArray,dwNum);
- }
-
returnbRet;
- }
-
-
-
BOOLCDBManage::SetLastTransData(LastTransactionltSet)
- {
-
WCHARwcTraceNum[6];
-
WCHARwcMsgType[4];
-
WCHARwcTransAmount[12];
-
WCHARwcCashierID[4];
-
WCHARwcLTDate[6];
-
WCHARwcLTTime[6];
-
WCHARwcAcquirerCode[12];
-
-
-
-
-
-
-
-
charTempArray[20];
-
BOOLbRet=TRUE;
- CStringcsSQL;
-
DWORDdwNum;
-
memcpy(TempArray,ltSet.TraceNum,sizeof(ltSet.TraceNum));
- dwNum=MultiByteToWideChar(CP_ACP,0,TempArray,-1,NULL,0);
- MultiByteToWideChar(CP_ACP,0,TempArray,-1,wcTraceNum,dwNum);
-
memcpy(TempArray,ltSet.byMsgType,sizeof(ltSet.byMsgType));
- dwNum=MultiByteToWideChar(CP_ACP,0,TempArray,-1,NULL,0);
- MultiByteToWideChar(CP_ACP,0,TempArray,-1,wcMsgType,dwNum);
-
memcpy(TempArray,ltSet.byTransAmount,sizeof(ltSet.byTransAmount));
- dwNum=MultiByteToWideChar(CP_ACP,0,TempArray,-1,NULL,0);
- MultiByteToWideChar(CP_ACP,0,TempArray,-1,wcTransAmount,dwNum);
-
memcpy(TempArray,ltSet.byCashierID,sizeof(ltSet.byCashierID));
- dwNum=MultiByteToWideChar(CP_ACP,0,TempArray,-1,NULL,0);
- MultiByteToWideChar(CP_ACP,0,TempArray,-1,wcCashierID,dwNum);
-
memcpy(TempArray,ltSet.byLocalTransDate,sizeof(ltSet.byLocalTransDate));
- dwNum=MultiByteToWideChar(CP_ACP,0,TempArray,-1,NULL,0);
- MultiByteToWideChar(CP_ACP,0,TempArray,-1,wcLTDate,dwNum);
-
memcpy(TempArray,ltSet.byLocalTransTime,sizeof(ltSet.byLocalTransTime));
- dwNum=MultiByteToWideChar(CP_ACP,0,TempArray,-1,NULL,0);
- MultiByteToWideChar(CP_ACP,0,TempArray,-1,wcLTTime,dwNum);
-
memcpy(TempArray,ltSet.byAcquirerCode,sizeof(ltSet.byAcquirerCode));
- dwNum=MultiByteToWideChar(CP_ACP,0,TempArray,-1,NULL,0);
- MultiByteToWideChar(CP_ACP,0,TempArray,-1,wcAcquirerCode,dwNum);
-
csSQL.Format(_T("INSERTINTOTransTbVALUES('%s','%s','%s','%s','%s','%s','%s');"),
- wcTraceNum,
- wcMsgType,
- wcTransAmount,
- wcCashierID,
- wcLTDate,
- wcLTTime,
- wcAcquirerCode);
- bRet&=ExecuteSQL(csSQL);
-
-
csSQL.Format(_T("SELECT*FROMTransTbWHEREtraceid='%s';"),wcTraceNum);
-
if(GetRecordCount(csSQL)==0)
- {
- bRet&=FALSE;
- }
-
returnbRet;
- }
分享到:
Global site tag (gtag.js) - Google Analytics
相关推荐
DBManager.java
数据库操作工具,针对多种弄数据库进行操作。查看各种数据。
{ //创建指向具体处理函数的代表实例(新建一个代表,让它指向具体的处理函数) DBManager.EmnuConnectionCallback myCallback = new DBManager.EmnuConnectionCallback(ActiveConncetionCallback);...
QT项目测试 作者:阿里·尤塞菲安 在此项目中,我们使用2个表(用户和角色) 特征 登录系统 用户表上的CRUD 搜索系统 CRUD上的数据验证 Md5加密 安装 ...vim dbmanager.cpp change pathreal= < to>
DbManager.class mysql-connector-java-5.1.18-bin.jar db mysql_bank.sql sqlserver_bank.sql lib mysql-connector-java-5.1.18-bin.jar MANIFEST.MF pics a11.jpg a12.jpg a13.jpg a16.jpg a18.jpg ...
sqlite数据库操作工具类(含jsqlite.jar包),DBManager.java工具类可复制到项目中直接使用
java语言编写的简单模拟ATM机功能案例,有美观的UI界面,和比较完善的功能模块,业务分层,编码格式规范。可供初学者参考。 另在db文件夹中附带两种数据库(mysql、sqlserver)表结构。... DbManager.java Thumbs.db
数衡电子秤传称软件主程序:DBManager.exe本软件采用“多线程技术”实现与数衡电子秤通讯,够实现对数衡全系列联网电子秤的集中管理,提供商品管理、网络测试、预设键、标设计、店名及文本、用户及权限等一系列管理...
android write some code about android some tools about android 1 DBManager.java help you to manage the SQLiteDatabase of sqlLite , support multithreaded access.
WP-DBManager2.50 简体中文包插件 插件使用方法: 1.上传到插件目录,在WordPress控制面板激活插件。 2.插件激活之后,会在wp-content目录生成一个backup-db的目录,目录的默认需要的权限是:777。 ...
环境:myeclipse,sqlserver 2005,tomcat,里面附带的jar包是08数据库所用,可以换掉,DBManager.jar中可以修改数据库密码
是用myEclipse开发的,tomcat服务器,sqlServer2005数据库,里面jar包是08数据库的,可以换掉,DBManager.java中可以修改数据库密码
java dbmanager
C3P0 数据库连接池 管理类 驱动包 只要在DBManager.java内加上自己的oracle地址和用户名密码即可,如果是用别的数据库,则把相应的数据库连接地址改改就成
WP-DBManager插件介绍: WP-DBManager是wordpress的数据备份插件,目前最新版本为2.40,其主要用途是对WordPress 的数据库进行管理,从而省去了用户必须使用类似PhpMyadmin登录数据库进行备份、修复、导入等操作,...
飘云论坛系统功能比较简单,实现了用户注册...适合初学者使用。注意:开发环境为Visual Studio 2008,数据库为SQL Server 2008用户名密码是:admin数据库连接文件:master.master.cs、login.aspx、App_Code/DbManager.cs
该软件实现了一个数据库内容管理器系统,该系统适用于使用ORM框架系统FRESHHH https://sourceforge.net/p/hierarnodesys/的mysql数据库。... 演示:https://freshhh-dbmanager.sourceforge.io/sample/
源于Eclipse+SWTJFace核心应用光盘内容\源代码\...环境已经验证,导入eclipse 修改链接数据库(执行mysql.sql) 修改jdbc配置(/SuperCRM/src/superCRM/dao/DbManager.java) 运行即可。 仅此献给刚刚入门rcp的 童鞋们