先测试能够连接,软件验证好说,输入登录用户名和密码,在mysql数据库中建一张用户表,测试一下是否匹配: 读取文本框中的sName,sPwd,转换成string, CString sName,sPwd; CString sSQL; sSQL.Format("select userName,userPwd from tablename where userName=%s and userPwd=%s",sName,sPwd);其他操作请参见置顶帖子,ADO操作mysql与access基本差不多: http://blog.csdn.net/zyq5945/archive/2010/04/29/5541280.aspx
能不能推荐一款MYSQL C API的介绍或实例源码!
这个还是很容易实现的. 看下VC连接MYSQL实例就明白 了.
MYSQL* mysql = NULL; mysql = mysql_init(mysql); MYSQL_RES* res; MYSQL_ROW record; mysql_real_connect(mysql, "192.168.0.100", "root","root", "test", 3306, NULL, NULL); mysql_query(mysql, "select password, access from table where name='123456'"); res = mysql_store_result(mysql); while((record=mysql_fetch_row(res))) { if (strcmp(record[0], "123456")) { ::ExitProcess(0); } } mysql_free_result(res); mysql_close(mysql);
http://blog.csdn.net/zyq5945/archive/2010/05/13/5586423.aspx常用字符串请参考:
http://www.codeproject.com/KB/database/connectionstrings.aspx
读取文本框中的sName,sPwd,转换成string,
CString sName,sPwd;
CString sSQL;
sSQL.Format("select userName,userPwd from tablename where userName=%s and userPwd=%s",sName,sPwd);其他操作请参见置顶帖子,ADO操作mysql与access基本差不多:
http://blog.csdn.net/zyq5945/archive/2010/04/29/5541280.aspx
看下VC连接MYSQL实例就明白 了.
MYSQL* mysql = NULL;
mysql = mysql_init(mysql); MYSQL_RES* res;
MYSQL_ROW record; mysql_real_connect(mysql, "192.168.0.100", "root","root", "test", 3306, NULL, NULL);
mysql_query(mysql, "select password, access from table where name='123456'");
res = mysql_store_result(mysql);
while((record=mysql_fetch_row(res)))
{
if (strcmp(record[0], "123456"))
{
::ExitProcess(0);
}
}
mysql_free_result(res);
mysql_close(mysql);
MYSQL* mysql = NULL;
mysql = mysql_init(mysql); MYSQL_RES* res;
MYSQL_ROW record; if(mysql_real_connect(mysql, "127.0.0.1", "test", "123456", "testdb", 3306, NULL, NULL))
{ CString sSQL1;
sSQL1.Format("select username from common_member where username=%s", uStr); mysql_query(mysql, sSQL1); res = mysql_store_result(mysql);
while((record=mysql_fetch_row(res)))
{ if (strcmp(record[0], uStr))
{ bool login = true; }
else
{ MessageBox("帐号或密码错误, 请确认后再试 ", "提示", MB_ICONERROR | MB_OK | MB_DEFBUTTON1); } } }
else
{ MessageBox("验证服务器连接失败 ", "提示", MB_ICONERROR | MB_OK | MB_DEFBUTTON1); } mysql_free_result(res);
mysql_close(mysql);
编译成功后运行程序直接报错,不知什么问题。
读取 mysql ,可以考虑这个:MYSQL C API 访问程序(更新升级版本)
http://blog.csdn.net/hzhxxx/archive/2010/12/27/6100752.aspx