📄 vc连接mysql及开发详细指南 - 诗轩.htm
字号:
<!--STATUS OK-->
<meta http-equiv="Content-Type" content="text/html;charset=gb2312">
<base href="http://www.conginfo.com/Blog/article.asp?id=502">
<style>
body{margin:4px 0}
#bd_sn_h{text-align:left;background-color:#ffffff;color:#000000}
#bd_sn_h #p1{clear:both;font:14px Arial;margin:0 0 0 2px;padding:4px 0 0 0}
#bd_sn_h a{color:#0000ff;text-decoration:underline}
#bd_sn_h #p1 a{font-weight:bold}
#baidu div{position:static}
</style>
<table id="baidu" width="100%" cellpadding="0" cellspacing="0" border="0">
<tr><td>
<div style="text-align:left;background-color:#ffffff;color:#000000">
<div style="margin:6px 18px 0 10px;float:left"><a href="http://www.baidu.com"><img style="border:0px" alt="到百度首页" src="http://img.baidu.com/img/logo-kz.gif"></a></div>
<div style="margin:27px 0 0 0;float:left">
<form style="margin:0;padding:0" action="http://www.baidu.com/s">
<input name="wd" size="35" style="font:16px Arial"> <input type="submit" value="百度一下">
<input name="cl" type="hidden" value="3">
</form>
</div>
<p style="clear:both;font:14px Arial;margin:0 0 0 2px;padding:4px 0 0 0;width:100%;text-align:left;background-color:#ffffff;color:#000000">您查询的关键词是：<B style='color:black;background-color:#ffff66'><a href=http://cache.baidu.com/c?word=vc%3B%C1%AC%BD%D3%3Bmysql&url=http%3A//www%2Econginfo%2Ecom/Blog/article%2Easp%3Fid%3D502&p=8757c64ad7c106fa08e29378115098&user=baidu#baidusnap0>vc连接mysql</a> </B> 。如果打开速度慢，可以尝试<a style="color:#0000ff;text-decoration:underline;font-weight:bold" href="http://cache.baidu.com/c?word=vc%3B%C1%AC%BD%D3%3Bmysql&url=http%3A//www%2Econginfo%2Ecom/Blog/article%2Easp%3Fid%3D502&p=8757c64ad7c106fa08e29378115098&user=baidu&fast=y">快速版</a>；如果想保存快照，可以<a style="color:#0000ff;text-decoration:underline;font-weight:bold" onclick="window.open('http://cang.baidu.com/do/add?it='+encodeURIComponent(document.title)+'&iu='+encodeURIComponent(location.href)+'&fr=ps#nw=1','_s','scrollbars=no,width=600,height=450,right=75,top=20,status=no,resizable=yes'); return false;" href="http://cang.baidu.com/do/add" target="_blank">添加到搜藏</a>。</p>
<p style="font:12px Arial;color:gray;margin:0 2px;width:100%text-align:left;background-color:#ffffff">(百度和网页<a style="color:#0000ff;text-decoration:underline" href="http://www.conginfo.com/Blog/article.asp?id=502">http://www.conginfo.com/Blog/article.asp?id=502</a>的作者无关，不对其内容负责。百度快照谨为网络故障时之索引，不代表被搜索网站的即时页面。)</p>
<hr style="margin:8px 0;width:100%">
</div>
</td></tr>
</table>
<div style="position:relative">
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>VC连接Mysql及开发详细指南 - 诗轩</title>
<meta name="robots" content="follow,index" />
<link rel="stylesheet" type="text/css" href="styles/Jpapers/styles.css" />
<link rel="alternate" type="application/rss+xml" title="诗轩" href="http://www.conginfo.com/blog/lbs/feed.asp" />
</head>
<body>
<div id="wrapper">
<div id="innerWrapper">
<div id="header">
<div id="innerHeader">
<div id="blogLogo"><img src="styles/Jpapers/images/logo.gif" id="logo" alt="Logo" /></div>
<div class="blog-header">
<h1 class="blog-title"><a href="http://www.conginfo.com/blog/lbs/">诗轩</a></h1>
<div class="blog-desc">专注于IT技术</div>
</div>
<div id="menu">
<ul>
<li><a href="default.asp">首页</a></li>
<li><a href="default.asp?selected=true">推荐</a></li>
<li><a href="gbook.asp">留言</a></li>
<li><a href="javascript:showHideSidebar()">框架</a></li>
<li><a href="javascript:showLogin()">登录</a></li>
</ul>
</div>
</div>
</div>
<div id="mainWrapper">
<div id="content" class="content">
<div id="innerContent">
<div class="article-top">
<div class="prev-article"><a href="?id=501" title="自动填写WEB表格资料">« 自动填写WEB表格资料</a></div>
<div class="next-article"><a href="?id=503" title="自动填充基于IE的WEB表单">自动填充基于IE的WEB... »</a></div>
<div class="category-label"><a href="default.asp?cat=1">日志分类: C/C++/C#</a></div>
</div>
<div class="textbox">
<div class="textbox-title">
<h4><a name=baidusnap0></a><B style='color:black;background-color:#ffff66'>VC连接Mysql</B>及开发详细指南</h4>
<div class="textbox-label">
[ 2008-02-15 09:25:58 | 作者: <a href='user.asp?act=view&id=4'>Edward_Sim</a> ]
</div>
</div>
<div class="textbox-fontsize">
字号:
<a href="javascript:setFontSize(14)" title="字号: 大">大</a> |
<a href="javascript:setFontSize(11)" title="字号: 中">中</a> |
<a href="javascript:setFontSize(9)" title="字号: 小">小</a>
</div>
<div id="textboxContent" class="textbox-content">
VC与MYSQL连接<br /><br />最近要用VC连接WEB上的MYSQL,在网上找了很多资料.都不是非常的详细。<br /><br /> 所以今天,我就把我自已怎样一步步连接MYSQL的步骤,以及语句等的写法一起写出来。<br /><br /> 一是为了自已备忘，同时也希望能对需要的朋友有帮助.<br /><br />准备工作：<br /><br /><span style="color:Red"> 建议：以下最好都用方法1，简单易用，也可以防止以后使用麻烦。</span><br /><br />一、mysql.h头文件问题。<br /><br />因为新在VC工程,在里面要包含这样的头文件<br />#include "winsock.h"<br />#include "mysql.h"<br /><br />所以：<br />要把mysql.h复制到vc的安装目录的include目录下<br />方法1：<br />mysql.h在你mysql的安装目录下的include里面如:mysql\include<br /><br />方法2：<br />把这个头文件添加到你的目录里面,或者在VC(我用的是Visual c++6.0)的菜单栏<br />点击progect-->setting-->在出现的对话框里面选择c/c++属性页-->选择preprocessor<br />--->在下面的additional include directories文本框里面填入你的mysql.h目录如:<br />D:\DataBase\mysql\include<br /><br />建议：<br /><br />把mysql.h和其他在mysql\include的所以.h的文件都复制到VS6的安装目录里，如我的是:<br />我visula studio是安装在D:\Program Files\下<br />下面是详细的目录地址：<br /><br />D:\Program Files\Microsoft Visual Studio\VC98\Include<br /><br />二、libmysql.lib链接库问题：<br /><br />方法1：<br />把libmysql.lib(在mysql的安装目录下，搜索下就能找到）也复制到这个目录下（D:\Program Files\Microsoft Visual Studio\VC98\Include），要不连接会出错。<br /><br />如果编译连接时还是出错。就把libmysql.lib复制到你源程序的目录中<br /><br />方法2：<br /><br />libmysql.lib 在安装目录下的lib\debug目录下<br /><br />点击progect-->setting-->在出现的对话框里面选择link属性页-->选择input选项<br />-->在Object/library modules下面添加libmysql.lib<br />-->在下面的additional include directories文本框里面输入你的lib的目录<br />如:\DataBase\mysql\lib\debug<br /><br />建议使用方法1<br /><br />下面是做示例工程。<br /><br />一、新建一个VC-MFC(exe)工程,如取名为:odbc,<br /><br />第一步选对话框，<br />第二第三步及以下选默认的选项一直到结束。<br /><br />二、在ODBCDlg.h中加入头文件。<br /><div class="code">#include "winsock.h"<br />#include "mysql.h"</div><br />三、新建一个按钮button1。添加成员变量，及单击的消息。<br /><br />在ODBCDlg.cpp如下代码：<br />void CODBCDlg::OnButton1() <br />{<div class="code"> // TODO: Add your control notification handler code here<br /> char *query;<br /> int t,r; <br /> MYSQL_RES *res; <br /> MYSQL_ROW row; <br /><br /> m_mysql = mysql_init(NULL);<br /> if (!mysql_real_connect(m_mysql,"localhost","databasename",<br /> "yourdatabase-password","yourtable",0,NULL,0))<br /> {<br /> CString errors =mysql_error(m_mysql);<br /> MessageBox(errors,"′í?ó");<br /><br /> }<br /> <br /> query="select text from yourtable"; <br /><br /> t=mysql_real_query(m_mysql,query,(unsigned int) strlen(query)); <br /> if(t) <br /> { <br /> <br /> MessageBox(mysql_error(m_mysql)); <br /> } <br /> <br /> res=mysql_use_result(m_mysql); <br /><br /> row=mysql_fetch_row(res);<br /> CString sumstr;<br /> for(r=0;r<=mysql_field_count(m_mysql);r++)<br /> {<br /> if(row<0) <br /> {<br /> MessageBox("error");<br /> }<br /> for(t=0;t<mysql_num_fields(res);t++)<br /> { <br /> CString Query = row[t];<br /> sumstr+=Query+" ";<br /><br /> } <br /><br /> <br /> }<br /> MessageBox(sumstr);<br /> mysql_close(m_mysql);<br /> <br />}<br /></div><br />编译运行。<br /><br />以下是网上找的另一段连接代码，没有测试过是否可用。<br /><br />挺久的了,随便写的测试 <div class="code"> #include "winsock.h" <br /> #include "mysql.h" <br /> <br /> int main(int argc, char* argv[]) <br /> { <br /> <br /> MYSQL * con = mysql_init((MYSQL*) 0); <br /> LPSTR host = "***"; <br /> LPSTR user,psw,dbname,; <br /> if ( con !=NULL <br /> && mysql_real_connect(con,host,user,psw,dbname,3306,NULL,0) ) <br /> { <br /> if (!mysql_select_db(con,dbname)) <br /> { <br /> printf("Select successfully the database!\n"); <br /> con ->reconnect = 1; <br /> if (!mysql_query(con,"select * from table_name")) <br /> { <br /> printf("Show table---orders:\n"); <br /> MYSQL_RES * recordSet = mysql_store_result(con); <br /> long j = mysql_num_fields(recordSet); <br /> long i = (long)mysql_num_rows(recordSet); <br /> //get RecordSet of fields <br /> MYSQL_FIELD * field = mysql_fetch_fields(recordSet); <br /> for(int l=0;l<j;l++) <br /> { <br /> printf("%s ",field[l].name); <br /> } <br /> printf("\n"); <br /> <br /> // get all the row of table---boothinfo <br /> MYSQL_ROW row; <br /> while( row = mysql_fetch_row(recordSet)) <br /> { <br /> //get the number of fields <br /> <br /> for(int l=0 ; l< j;l++) <br /> { <br /> if(row[l]==NULL || !strlen(row[l])) <br /> printf("NULL "); <br /> else <br /> printf("%s ",row[l]); <br /> } <br /> printf("\n"); <br /> } <br /> } <br /> } <br /> else <br /> { <br /> printf("Unable to select the databas!\n"); <br /> return 0; <br /> } <br /> return 1; <br /> } <br /> else <br /> { <br /> printf("can't connect to the mysql server!\n"); <br /> printf("Errors: %s",mysql_error(con)); <br /> return -1; <br /> } <br /> mysql_close(con); <br /> }</div>
<div class="editmark">[最后修改由 Edward_Sim， 于 2008-02-15 10:11:22]</div>
<div class="textbox-urls">
<img src="styles/Jpapers/images/rss_comment.png" class="meta-button" alt="评论Feed" />
<b>评论Feed:</b> http://www.conginfo.com/blog/lbs/feed.asp?q=comment&id=502
<br />
<img src="styles/Jpapers/images/utf8.png" class="meta-button" alt="UTF-8 Encoding" /> <b>引用链接:</b> http://www.conginfo.com/blog/lbs/trackback.asp?id=502
</div>
</div>
</div>
<br />
<a name="comments"></a>
<div id="commentWrapper" class="comment-wrapper">
<div class="no-comment-box">这篇日志没有评论。</div>
</div>
<br />
<a name="commentbox"></a>
<div class="no-comment-box">此日志不可发表评论。</div>
</div>
</div>
<div id="sidebar" class="sidebar">
<div id="innerSidebar">
<div id="panelUser" class="panel" style="display: none">
<h5>用户面板</h5>
<div class="panel-content">
<div id="loginForm">
<form name="login" method="post" action="login.asp?act=login">
<table cellpadding="0" cellspacing="2" width="100%">
<tr>
<td align="right">用户名:</td>
<td><input name="username" type="text" size="12" maxlength="24" class="text" />
</td>
</tr>
<tr>
<td align="right">密码:</td>
<td><input name="password" type="password" size="12" maxlength="16" class="text" /></td>
</tr>
<tr>
<td align="right">验证码:</td>
<td><input name="scode" size="4" maxlength="4" type="text" class="text" />
<img src="scode.asp" alt="验证码" />
</td>
</tr>
<tr>
<td align="center">
</td>
<td>
<input name="Login" type="submit" value=" 登录 " class="button" />
</td>
</tr>
</table>
</form>
</div>
</div>
</div>
<div id="panelCategory" class="panel">
<h5>日志分类</h5>
<div class="panel-content">
<ul>
<li><a href="default.asp"><b>首页</b></a></li>
<li><a href="default.asp?cat=11">生活</a> [13] <a href="feed.asp?cat=11" title="生活 RSS Feed" target="_blank"><img src="styles/Jpapers/images/rss.png" class="meta-button" alt="生活 RSS Feed" /></a>
</li>
<li><a href="default.asp?cat=2">WEB编程</a> [39] <a href="feed.asp?cat=2" title="WEB编程 RSS Feed" target="_blank"><img src="styles/Jpapers/images/rss.png" class="meta-button" alt="WEB编程 RSS Feed" /></a>
</li>
<li><a href="default.asp?cat=3">UNIX</a> [4] <a href="feed.asp?cat=3" title="UNIX RSS Feed" target="_blank"><img src="styles/Jpapers/images/rss.png" class="meta-button" alt="UNIX RSS Feed" /></a>
</li>
<li><a href="default.asp?cat=4">外语</a> [5] <a href="feed.asp?cat=4" title="外语 RSS Feed" target="_blank"><img src="styles/Jpapers/images/rss.png" class="meta-button" alt="外语 RSS Feed" /></a>
</li>
<li><a href="default.asp?cat=5">数据库编程</a> [51] <a href="feed.asp?cat=5" title="数据库编程 RSS Feed" target="_blank"><img src="styles/Jpapers/images/rss.png" class="meta-button" alt="数据库编程 RSS Feed" /></a>
</li>
<li><a href="default.asp?cat=6">数据结构+算法</a> [2] <a href="feed.asp?cat=6" title="数据结构+算法 RSS Feed" target="_blank"><img src="styles/Jpapers/images/rss.png" class="meta-button" alt="数据结构+算法 RSS Feed" /></a>
</li>
<li><a href="default.asp?cat=7">维护</a> [48] <a href="feed.asp?cat=7" title="维护 RSS Feed" target="_blank"><img src="styles/Jpapers/images/rss.png" class="meta-button" alt="维护 RSS Feed" /></a>
</li>
<li><a href="default.asp?cat=8">网络安全</a> [7] <a href="feed.asp?cat=8" title="网络安全 RSS Feed" target="_blank"><img src="styles/Jpapers/images/rss.png" class="meta-button" alt="网络安全 RSS Feed" /></a>
</li>
<li><a href="default.asp?cat=1">C/C++/C#</a> [45] <a href="feed.asp?cat=1" title="C/C++/C# RSS Feed" target="_blank"><img src="styles/Jpapers/images/rss.png" class="meta-button" alt="C/C++/C# RSS Feed" /></a>
</li>
<li><a href="default.asp?cat=10">SEO</a> [43] <a href="feed.asp?cat=10" title="SEO RSS Feed" target="_blank"><img src="styles/Jpapers/images/rss.png" class="meta-button" alt="SEO RSS Feed" /></a>
</li>
<li><a href="default.asp?cat=19">joomla</a> [59] <a href="feed.asp?cat=19" title="joomla RSS Feed" target="_blank"><img src="styles/Jpapers/images/rss.png" class="meta-button" alt="joomla RSS Feed" /></a>
</li>
<li><a href="default.asp?cat=12">carve-out</a> [15] <a href="feed.asp?cat=12" title="carve-out RSS Feed" target="_blank"><img src="styles/Jpapers/images/rss.png" class="meta-button" alt="carve-out RSS Feed" /></a>
</li>
<li><a href="default.asp?cat=13">ASP编程</a> [1] <a href="feed.asp?cat=13" title="ASP编程 RSS Feed" target="_blank"><img src="styles/Jpapers/images/rss.png" class="meta-button" alt="ASP编程 RSS Feed" /></a>
</li>
<li><a href="default.asp?cat=14">杂谈</a> [4] <a href="feed.asp?cat=14" title="杂谈 RSS Feed" target="_blank"><img src="styles/Jpapers/images/rss.png" class="meta-button" alt="杂谈 RSS Feed" /></a>
</li>
<li><a href="default.asp?cat=15">电影</a> [3] <a href="feed.asp?cat=15" title="电影 RSS Feed" target="_blank"><img src="styles/Jpapers/images/rss.png" class="meta-button" alt="电影 RSS Feed" /></a>
</li>
<li><a href="default.asp?cat=16">JAVA编程</a> [35] <a href="feed.asp?cat=16" title="JAVA编程 RSS Feed" target="_blank"><img src="styles/Jpapers/images/rss.png" class="meta-button" alt="JAVA编程 RSS Feed" /></a>
</li>
<li><a href="default.asp?cat=17">嵌入式</a> [8] <a href="feed.asp?cat=17" title="嵌入式 RSS Feed" target="_blank"><img src="styles/Jpapers/images/rss.png" class="meta-button" alt="嵌入式 RSS Feed" /></a>
</li>
<li><a href="default.asp?cat=18">外贸</a> [37] <a href="feed.asp?cat=18" title="外贸 RSS Feed" target="_blank"><img src="styles/Jpapers/images/rss.png" class="meta-button" alt="外贸 RSS Feed" /></a>
</li>
<li><a href="default.asp?cat=9">PHP</a> [77] <a href="feed.asp?cat=9" title="PHP RSS Feed" target="_blank"><img src="styles/Jpapers/images/rss.png" class="meta-button" alt="PHP RSS Feed" /></a>
</li>
</ul>
</div>
</div>
<div id="panelCalendar" class="panel">
<h5>站内日历</h5>
<table cellspacing="1" width="100%" id="calendar"><tr><td colspan="7" class="calendar-top"> <a href="default.asp?date=2007-2">«</a> <a href="default.asp?date=2008-2"><span class="calendar-year">2008</span></a> <a href="default.asp?date=2009-2">»</a> <a href="default.asp?date=2008-1">«</a>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -