資源簡介
將在SQL2000下建立schooldata數(shù)據(jù)庫
導(dǎo)入數(shù)據(jù)文件
導(dǎo)入數(shù)據(jù):
data目錄下有school_back數(shù)據(jù)庫備分文件
操作:用SQL企業(yè)管理器還原數(shù)據(jù)庫來導(dǎo)入數(shù)據(jù)
訪問本地數(shù)據(jù)庫服務(wù)器,密碼是自己設(shè)置的那個,操作schooldata數(shù)據(jù)庫的用戶名和密碼相同

代碼片段和文件信息
/****************************************/
/* ADO封裝類設(shè)計AdoConnection ????*/
/*設(shè)計者:全佳營 */
/*時間:2004.5.9-2004.5.18 */
/*Email:ghostman@tzc.edu.cn */
/*本ADO封裝類是參考網(wǎng)友提供的設(shè)計的 */
/****************************************/
#include?“StdAfx.h“
#include?“.\adoconnection.h“
#include?
//類型轉(zhuǎn)換函數(shù)
COleDateTime?vartodate(const?_variant_t&?var)
{
COleDateTime?value;
switch?(var.vt)?
{
case?VT_DATE:
{
value?=?var.date;
}
break;
case?VT_EMPTY:
case?VT_NULL:
value.SetStatus(COleDateTime::null);
break;
default:
value.SetStatus(COleDateTime::null);
TRACE(_T(“Warning:?未處理的?_variant_t?類型值;?文件:?%s;?行:?%d\n“)?__FILE__?__LINE__);
}
return?value;
}
COleCurrency?vartocy(const?_variant_t&?var)
{
COleCurrency?value;
switch?(var.vt)?
{
case?VT_CY:
value?=?(CURRENCY)var.cyVal;
break;
case?VT_EMPTY:
case?VT_NULL:
value.m_status?=?COleCurrency::null;
break;
default:
value.m_status?=?COleCurrency::null;
TRACE(_T(“Warning:?未處理的?_variant_t?類型值;?文件:?%s;?行:?%d\n“)?__FILE__?__LINE__);
}
return?value;
}
bool?vartobool(const?_variant_t&?var)
{
bool?value?=?false;
switch?(var.vt)
{
case?VT_BOOL:
value?=?var.boolVal???true?:?false;
case?VT_EMPTY:
case?VT_NULL:
break;
default:
TRACE(_T(“Warning:?未處理的?_variant_t?類型值;?文件:?%s;?行:?%d\n“)?__FILE__?__LINE__);
}
return?value;
}
BYTE?vartoby(const?_variant_t&?var)
{
BYTE?value?=?0;
switch?(var.vt)
{
case?VT_I1:
case?VT_UI1:
value?=?var.bVal;
break;
case?VT_NULL:
case?VT_EMPTY:
value?=?0;
break;
default:
TRACE(_T(“Warning:?未處理的?_variant_t?類型值;?文件:?%s;?行:?%d\n“)?__FILE__?__LINE__);
}
return?value;
}
short?vartoi(const?_variant_t&?var)
{
short?value?=?0;
switch?(var.vt)
{
case?VT_BOOL:
value?=?var.boolVal;
break;
case?VT_UI1:
case?VT_I1:
value?=?var.bVal;
break;
case?VT_I2:
case?VT_UI2:
value?=?var.iVal;
break;
case?VT_NULL:
case?VT_EMPTY:
value?=?0;
break;
default:
TRACE(_T(“Warning:?未處理的?_variant_t?類型值;?文件:?%s;?行:?%d\n“)?__FILE__?__LINE__);
}
return?value;
}
long?vartol(const?_variant_t&?var)
{
long?value?=?0;
switch?(var.vt)
{
case?VT_BOOL:
value?=?var.boolVal;
break;
case?VT_UI1:
case?VT_I1:
value?=?var.bVal;
break;
case?VT_UI2:
case?VT_I2:
value?=?var.iVal;
break;
case?VT_I4:
case?VT_UI4:
value?=?var.lVal;
break;
case?VT_INT:
value?=?var.intVal;
break;
case?VT_R4:
value?=?(long)(var.fltVal?+?0.5);
break;
case?VT_R8:
value?=?(long)(var.dblVal?+?0.5);
break;
case?VT_DECIMAL:
value?=?(long)var;
break;
case?VT_CY:
value?=?(long)var;
break;
case?VT_BSTR://字符串
case?VT_LPSTR://字符串
case?VT_LPWSTR://字符串
value?=?atol((LPCTSTR)(_bstr_t)var);
break;
case?VT_NULL:
case?VT_EMPTY:
value?=?0;
break;
default:
TRACE(_T(“Warning:?未處理的?_variant_t?類型值;?文件:?%s;?行:?%d\n“)?__FILE__?__LINE__);
}
retur
?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????文件????????905??2004-05-19?12:20??schoolmanagesys_2\readme1.txt
?????文件??????20621??2004-05-18?21:56??schoolmanagesys_2\SchoolManageSys_2\AdoConnection.cpp
?????文件???????2213??2004-05-18?21:56??schoolmanagesys_2\SchoolManageSys_2\AdoConnection.h
?????文件????????757??2004-05-18?21:56??schoolmanagesys_2\SchoolManageSys_2\adodc1.cpp
?????文件??????11923??2004-05-18?21:56??schoolmanagesys_2\SchoolManageSys_2\adodc1.h
?????文件??????78233??2004-05-18?22:22??schoolmanagesys_2\SchoolManageSys_2\AdoRecordSet.cpp
?????文件???????7962??2004-05-18?22:22??schoolmanagesys_2\SchoolManageSys_2\AdoRecordSet.h
?????文件?????445957??2002-11-18?18:47??schoolmanagesys_2\SchoolManageSys_2\B-Studio.skn
?????文件????1074623??2002-11-19?21:33??schoolmanagesys_2\SchoolManageSys_2\chizh.skn
?????文件??????10384??2004-05-14?15:53??schoolmanagesys_2\SchoolManageSys_2\data\schooldata.sql
?????文件????2592256??2004-05-16?18:38??schoolmanagesys_2\SchoolManageSys_2\data\school_back
?????文件???????3171??2004-05-18?21:56??schoolmanagesys_2\SchoolManageSys_2\DataGridShow.cpp
?????文件????????869??2004-05-18?21:56??schoolmanagesys_2\SchoolManageSys_2\DataGridShow.h
?????文件????????792??2004-05-18?21:56??schoolmanagesys_2\SchoolManageSys_2\datagrid_info.cpp
?????文件??????20339??2004-05-18?21:56??schoolmanagesys_2\SchoolManageSys_2\datagrid_info.h
?????文件?????445957??2002-11-18?18:47??schoolmanagesys_2\SchoolManageSys_2\Debug\B-Studio.skn
?????文件???????2823??2004-05-18?22:26??schoolmanagesys_2\SchoolManageSys_2\Debug\BuildLog.htm
?????文件????1074623??2002-11-19?21:33??schoolmanagesys_2\SchoolManageSys_2\Debug\chizh.skn
?????文件?????270361??2002-11-18?18:48??schoolmanagesys_2\SchoolManageSys_2\Debug\galaxy.skn
?????文件?????370939??2002-11-18?18:49??schoolmanagesys_2\SchoolManageSys_2\Debug\green.skn
?????文件??????96827??2002-11-19?21:41??schoolmanagesys_2\SchoolManageSys_2\Debug\Mac.skn
?????文件?????284965??2002-11-18?18:53??schoolmanagesys_2\SchoolManageSys_2\Debug\Media.skn
?????文件?????310759??2002-11-18?18:55??schoolmanagesys_2\SchoolManageSys_2\Debug\me
?????文件?????343605??2002-11-19?21:43??schoolmanagesys_2\SchoolManageSys_2\Debug\Paper.skn
?????文件??????10790??2001-10-03?15:03??schoolmanagesys_2\SchoolManageSys_2\Debug\plasmoid.skn
?????文件?????635983??2002-11-19?21:44??schoolmanagesys_2\SchoolManageSys_2\Debug\TopSecret.skn
?????文件?????252681??2002-11-19?21:49??schoolmanagesys_2\SchoolManageSys_2\Debug\Web-II.skn
?????文件?????193093??2003-04-30?19:21??schoolmanagesys_2\SchoolManageSys_2\Debug\winaqua.skn
?????文件?????308461??2002-11-19?21:50??schoolmanagesys_2\SchoolManageSys_2\Debug\Zhelezo.skn
?????文件????????911??2004-05-18?21:56??schoolmanagesys_2\SchoolManageSys_2\DialogAboutMe.cpp
............此處省略79個文件信息
評論
共有 條評論