\u4e00\u3001MySQL\u7684\u5b89\u88c5
\n\u6ce8\u610f\u9009\u62e9\u201c\u5b8c\u5168\u5b89\u88c5\u201d\uff08\u53ea\u6709\u8fd9\u6837\u624d\u4f1a\u5b89\u88c5VC\u7f16\u8bd1\u65f6\u9700\u8981\u7684\u5934\u6587\u4ef6\u7b49\uff09\u3002\u5b89\u88c5\u540e\u671f\u4f1a\u8fdb\u884c\u670d\u52a1\u5668\u914d\u7f6e\uff0c\u4f60\u53ef\u4ee5\u8bbe\u7f6e\u4f60\u7684\u670d\u52a1\u5668\u767b\u9646\u5bc6\u7801\uff0c\u4e5f\u53ef\u4ee5\u4e0d\u8bbe\u7f6e\u5bc6\u7801\u3002<\/p>\n
\u4e8c\u3001VC6.0\u7684\u8bbe\u7f6e<\/p>\n
\uff081\uff09\u6253\u5f00VC6.0 \u5de5\u5177\u680fTools\u83dc\u5355\u4e0b\u7684Options\u9009\u9879\uff0c\u5728Directories\u7684\u6807\u7b7e\u9875\u4e2d\u53f3\u8fb9\u7684\u201cShow directories for:\u201d\u4e0b\u62c9\u5217\u8868\u4e2d\u9009\u4e2d\u201cIncludefiles\u201d\uff0c\u7136\u540e\u5728\u4e2d\u95f4\u5217\u8868\u6846\u4e2d\u6dfb\u52a0\u4f60\u672c\u5730\u5b89\u88c5MySQL\u7684include\u76ee\u5f55\u8def\u5f84\u3002\uff08\u6211\u7684\u662fD:\\Program Files\\MySQL\\MySQL Server 5.0\\include\uff09\u3002<\/p>\n
\uff082\uff09\u5728\u4e0a\u9762\u8bf4\u5230\u7684\u201cShow directories for:\u201d\u4e0b\u62c9\u5217\u8868\u4e2d\u9009\u4e2d\u201cLibrary files\u201d\uff0c\u7136\u540e\u6dfb\u52a0\u4f60\u672c\u5730\u5b89\u88c5MySQL\u7684Lib\u76ee\u5f55\u8def\u5f84\u3002Lib\u76ee\u5f55\u4e0b\u8fd8\u6709debug\u548copt\u4e24\u4e2a\u76ee\u5f55\uff0c\u5efa\u8bae\u9009debug\u3002\uff08\u6211\u7684\u662fD:\\Program Files\\MySQL\\MySQL Server 5.0\\lib\\debug\uff09\u3002<\/p>\n
\uff083\uff09\u5728\u201cProject settings->Link:Object\/library modules\u201d\u91cc\u9762\u6dfb\u52a0\u201clibmysql.lib\u201d\u3002<\/p>\n
\uff084\uff09\u5728stdafx.h\u91cc\u9762\u6dfb\u52a0\u5982\u4e0b\u7684\u5185\u5bb9\uff1a<\/p>\n
#include \"mysql.h\"
\n#include \"winsock.h\" \/\/ \u5982\u679c\u7f16\u8bd1\u51fa\u9519,\u5219\u628a\u8be5\u884c\u653e\u5230#include \"mysql.h\"\u4e4b\u524d
\n#pragma comment(lib,\"libmySQL.lib\") \/\/ \u5982\u679c\u5728\u9644\u52a0\u4f9d\u8d56\u9879\u91cc\u5df2\u589e\u52a0,\u5219\u5c31\u4e0d\u8981\u6dfb\u52a0\u4e86
\n\uff085\uff09\u5efa\u8bae\u5c06\u201clibmySQL.lib\u3001libmySQL.dll\u201d\u62f7\u5230\u4f60\u6240\u5efa\u7684\u5de5\u7a0b\u7684\u76ee\u5f55\u4e0b\u3002<\/p>\n
\u4e09\u3001\u6570\u636e\u5e93\u3001\u8868\u7684\u521b\u5efa
\n\u6253\u5f00\u201c\u5f00\u59cb->\u6240\u6709\u7a0b\u5e8f->MySQL->MySQL Server 5.0->MySQL Command Line Client.exe\u201d\uff0c\u5982\u679c\u6ca1\u6709\u8bbe\u7f6e\u5bc6\u7801\u5c31\u76f4\u63a5\u6309\u56de\u8f66\uff0c\u4f1a\u63d0\u793a\u670d\u52a1\u5668\u542f\u52a8\u6210\u529f\u3002<\/p>\n
mysql> SHOW DATABASES;\/\/\u663e\u793a\u6240\u6709\u7684\u6570\u636e\u5e93\uff0c\u6ce8\u610f\u4e00\u5b9a\u8981 \u6572\u201c;\u201d\u540e\u518d\u6309\u56de\u8f66
\nmysql> CREATE DATABASE mydb;\/\/\u521b\u5efa\u6570\u636e\u5e93mydb
\nmysql> USE mydb;\/\/\u9009\u62e9\u4f60\u6240\u521b\u5efa\u7684\u6570\u636e\u5e93mydb
\nmysql> SHOW TABLES; \/\/\u663e\u793a\u6570\u636e\u5e93\u4e2d\u7684\u8868
\nmysql> CREATE TABLE mytable (username VARCHAR(100), visitelist VARCHAR(200), remark VARCHAR(200));\/\/\u521b\u5efa\u4e00\u4e2a\u8868mytable: \u7528\u6237\u540d\uff1b\u8bbf\u95ee\u5217\u8868\uff1b\u5907\u6ce8
\nmysql> DESCRIBE mytable;\/\/\u663e\u793a\u8868\u7684\u7ed3\u6784
\n\u56db\u3001VC\u7f16\u7a0b<\/p>\n
MYSQL mysql; \/\/\u6570\u636e\u5e93\u8fde\u63a5\u53e5\u67c4
\nmysql_init (&mysql);
\nif(!mysql_real_connect(&mysql,\"localhost\",\"root\",NULL,\"mydb\",3306,NULL,0)) {\/\/mydb\u4e3a\u4f60\u6240\u521b\u5efa\u7684\u6570\u636e\u5e93\uff0c3306\u4e3a\u7aef\u53e3\u53f7\uff0c\u53ef\u81ea\u884c\u8bbe\u5b9a
\nAfxMessageBox(\"\u6570\u636e\u5e93\u8fde\u63a5\u5931\u8d25\");
\nreturn FALSE;
\n}
\n\uff081\uff09\u5b9e\u73b0\u6dfb\u52a0 \u529f\u80fd<\/p>\n
CString strUsername,strList,strRemark,strSQL;
\nstrSQL.Format(\"insert into mytable(username,visitelist,remark) values(\\'%s\\',\\'%s\\',\\'%s\\')\", strUsername,strList,strRemark);\/\/\u6ce8\u610f\u4e00\u5b9a\u8981\u5199\u5728\u4e00\u884c\uff0c\u800c\u4e14\u5fc5\u987b\u8981\u6709\\'\\'
\nif(mysql_real_query(&mysql,(char*)(LPCTSTR)strSQL,(UINT)strSQL.GetLength())!=0){
\nAfxMessageBox(\"\u589e\u6dfb\u5931\u8d25\");
\n}<\/p>\n
\uff082\uff09\u5b9e\u73b0\u4fee\u6539\u529f\u80fd
\nCString strUsername,strList,strRemark,strSQL,str_PreName;\/\/str_PreName\u7528\u4e8e\u8bb0\u5f55\u60f3\u8981\u4fee\u6539\u7684\u884c\uff0c\u8be6\u60c5\u8bf7\u770b\u6e90\u4ee3\u7801
\nstrSQL.Format(\"update mytable set username=\\'%s\\',visitelist=\\'%s\\', remark=\\'%s\\' where username=\\'%s\\'\",strUsername,strList,strRemark,str_PreName);
\nif(mysql_real_query(&mysql,(char*)(LPCTSTR)strSQL,(UINT)strSQL.GetLength())!=0){
\nAfxMessageBox(\"\u4fee\u6539\u5931\u8d25\");
\n}
\n\uff083\uff09\u5b9e\u73b0\u5220\u9664\u529f\u80fd<\/p>\n
CString strSQL;
\nstrSQL.Format(\"delete from mytable where username=\\'%s\\'\",str_PreName);\/\/\u5fc5\u987b\u8981\u6709\\'\\'
\nif(mysql_real_query(&mysql,(char*)(LPCTSTR)strSQL,(UINT)strSQL.GetLength())!=0){
\nAfxMessageBox(\"\u5220\u9664\u5931\u8d25\");
\n}
\n\uff084\uff09\u8bfb\u53d6\u8868\u683c\u5185\u5bb9\u5230CListCtrl\u63a7\u4ef6m_list<\/p>\n
m_list.DeleteAllItems();
\nchar *ch_query;
\nch_query=\"select * from mytable\";
\nif(mysql_real_query(&mysql,ch_query,(UINT)strlen(ch_query))!=0){
\nAfxMessageBox(\"\u6570\u636e\u5e93\u4e2d\u8868\u683c\u51fa\u9519\");
\n}
\nCString str;
\nMYSQL_RES *result;
\nMYSQL_ROW row;
\nif(!(result=mysql_use_result(&mysql))){
\nAfxMessageBox(\"\u8bfb\u53d6\u6570\u636e\u96c6\u5931\u8d25\");
\n}
\nint i=0;
\nwhile(row=mysql_fetch_row(result)){
\nstr.Format(\"%s\",row[0]);
\nm_list.InsertItem(i,str);
\nstr.Format(\"%s\",row[1]);
\nm_list.SetItemText(i,1,str);
\nstr.Format(\"%s\",row[2]);
\nm_list.SetItemText(i,2,str);
\ni++;
\n}
\nmysql_free_result(result);
\n\uff085\uff09\u5173\u95ed\u6570\u636e\u5e93<\/p>\n
mysql_close(&mysql);\/\/\u6700\u597d\u5199\u5230OnDestroy()\u51fd\u6570\u4e2d<\/p>\n","protected":false},"excerpt":{"rendered":"
\u4e00\u3001MySQL\u7684\u5b89\u88c5 \u6ce8\u610f\u9009\u62e9\u201c\u5b8c\u5168\u5b89\u88c5\u201d\uff08\u53ea\u6709\u8fd9\u6837\u624d\u4f1a\u5b89\u88c5VC\u7f16\u8bd1\u65f6\u9700\u8981\u7684\u5934\u6587\u4ef6\u7b49\uff09\u3002\u5b89\u88c5\u540e\u671f\u4f1a\u8fdb\u884c\u670d\u52a1\u5668\u914d […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[35,131],"class_list":["post-86","post","type-post","status-publish","format-standard","hentry","category-Technical_literature","tag-mysql","tag-131"],"views":1376,"_links":{"self":[{"href":"https:\/\/www.datarelab.com\/blog\/wp-json\/wp\/v2\/posts\/86","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.datarelab.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.datarelab.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.datarelab.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.datarelab.com\/blog\/wp-json\/wp\/v2\/comments?post=86"}],"version-history":[{"count":0,"href":"https:\/\/www.datarelab.com\/blog\/wp-json\/wp\/v2\/posts\/86\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.datarelab.com\/blog\/wp-json\/wp\/v2\/media?parent=86"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.datarelab.com\/blog\/wp-json\/wp\/v2\/categories?post=86"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.datarelab.com\/blog\/wp-json\/wp\/v2\/tags?post=86"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}