VC++Á¬½ÓSQLServer
VC++Á¬½ÓSQLServer
/*
*Á¬½ÓSQL
*/
void CMFCSQLDlg::OnButton3()
{
// TODO: Add your control notification handler code here
_ConnectionPtr m_pConnection;
// ÔÚÓ¦ÓóÌÐòµÄInitInstanceº¯ÊýÀï¼ÓÈë
if(S_OK!=CoInitialize(NULL))
{
AfxMessageBox("³õʼ»¯COM¿â´íÎó!");
}else
{
AfxMessageBox("³õʼ»¯COM¿â³É¹¦!");
}
// Á¬½ÓÊý¾Ý¿â£º
HRESULT hr; //·µ»Ø½á¹û±äÁ¿
try
{
hr=m_pConnection.CreateInstance("ADODB.Connection"); //´´½¨Connection¶ÔÏó
if(SUCCEEDED(hr))
{
//hr=m_pConnection->Open("Provider=SQLOLEDB;Server=808644DA83B446C\SQLEXPRESS;Database=ChinabaseSQLServer;UserID=sa;pwd=123","","",adModeUnknown); //;Integrated Security=SSPI
m_pConnection->Open("Provider=SQLOLEDB.1;Server=808644DA83B446C\\SQLEXPRESS;DATABASE=ChinabaseSQLServer;UID=sa;PWD=123;","","",adModeUnknown);
MessageBox("Á¬½ÓSQLÔËÐгɹ¦!","³É¹¦",MB_OK);
_CommandPtr m_pCommand;
_RecordsetPtr m_pRecordset;
m_pCommand.CreateInstance("ADODB.Command");
_variant_t vNULL;
vNULL.vt = VT_ERROR;
Ïà¹ØÎĵµ£º
3.3 ¸ßЧÂÊ¿ª·¢
ÕâÒ»½Ú½éÉÜÀûÓõ¥Ôª²âÊÔʵÏÖ¸ßЧÂÊ¿ª·¢¡£µ¥Ôª²âÊÔ¿ÉÒÔÔÚ¼¸¸ö·½ÃæÌá¸ß¿ª·¢Ð§ÂÊ£º²âÊÔÇý¶¯¿ª·¢¡¢¿ÉÊÓ±à³Ì¡¢¿ìËÙÅÅ´í¡¢ºÍÌá¸ßµ÷ÊÔЧÂÊ¡£
²âÊÔÇý¶¯¿ª·¢
Ö¸Ïȱàд²âÊÔ´úÂ룬ȻºóÔÙ±àд²úÆ·´úÂëʹ²âÊÔͨ¹ý£¬ÓкܶàÏà¹ØÎÄÕºÍÊé¼®½éÉÜÕâ·½ÃæÖªÊ¶£¬ÏÞÓÚ±à·ù£¬ÕâÀï¾Í²»½²ÁË ......
д±¾ÎĵÄÄ¿µÄÊÇΪÁË·½±ã´ó¼ÒÁ˽âC++ MSXML²Ù×÷·½·¨¡£
µ±È»£¬C++ÖжÔMSXMLµÄµ÷ÓÃÓжàÖÖ£¬±¾ÎIJÉÓõķ½·¨ÊÇÍêÈ«²ÎÕÕMSXML SDKÌṩµÄÎĵµ½øÐвÙ×÷¡£
Èç¹ûÓÐʲô´íÎ󣬻¶ÓÖ¸Õý¡£
´úÂë¿ò¼ÜÊÇ»ùÓÚvs2008 MFC ¶Ô»°¿ò³ÌÐò£¨UNICODE£©¡£¶Ô»°¿ò³ÌÐòÐèÒª¶ÁÕß×Ô¼º´´½¨¡£
#include <msxml6.h>
#include <comutil.h>
# ......
EBCDIC (Extended Binary Coded Decimal Interchange Code) À©Ôö¶þ½øÊ½Ê®½ø½»»»Â룬ΪIBMÓÚ1963Äê£1964Äê¼äÍÆ³öµÄ×Ö·û±àÂë±í£¬¸ù¾ÝÔçÆÚ´ò¿×»úʽµÄ¶þ½ø»¯Ê®½øÊý(BCD, Bindary Coded Decimal)ÅÅÁжø³É¡£ÊÇIBMÃÔ¶û¼¶ÒÔÉϵçÄԵıê×¼Âë¡£
ASCII£¨American Standard Code for Information Interchange£¬ÃÀ¹úÐÅÏ¢»¥»»±ê×¼´úÂë£©Ê ......
ÔÚCÓëC++ÓïÑÔÖж¼´æÔڹؼü×Öconst,ºÜ¶àÈ˶¼¶Ô´Ë¹Ø¼ü×Ö´æÔÚÒ»¸ö´íÎóµÄÈÏʶ£¬ÈÏΪÔÚCÓïÑÔÖйؼü×ÖconstÊÇʹ±äÁ¿×÷Ϊһ¸ö³£Á¿£¬¼´½«±äÁ¿³£Á¿»¯£¬¾ÍÏñºê¶¨ÒåÒ»Ñù¡£¶øÔÚCÓïÑÔÖеĹؼü×ÖconstËùÆðµÄ×÷Óò¢²»ÊÇʹ±äÁ¿³£Á¿»°£¬¶øÊÇÏÞÖÆ±äÁ¿£¬Ê¹±äÁ¿³ýÁ˱»¸³³õÖµÍ⣬ÎÞ·¨±»ÖØÐ¸³Öµ¡£
¶øÔÚC++Öйؼü×Öconst²»½öʹ ......
1.·ÖÀà
ÄÚ²¿ÀàÐÍ ºÍÓû§¶¨ÒåÀàÐÍ
2.
ÕûÐΣºbool ,×Ö·ûÐÍ£¬ÕûÐÎ
true 1 flase 0
·ÇÁã true & ......