1.拷贝
libmysql.lib
libmysqld.dll
libmysql.dll
mysql.h(整个文件夹)
2.到根目录,引入。
#include "includemysql/mysql.h"
#pragma comment(lib,"libmysql.lib")
3.连接
int mysqclint( CString &outdata){ //连接mysql数据库,
mysql_library_init(NULL,0,0);
MYSQL mysql;
mysql_init(&mysql);
if(0==mysql_options(&mysql,MYSQL_SET_CHARSET_NAME,"utf8"))//设置字符集
{
cout << "设置字符集成功\n\n" <<endl;
}
if(!mysql_real_connect(&mysql,"localhost","root","","stock",0,NULL,CLIENT_MULTI_STATEMENTS))//连接数据库
{
cout << "not connect mysql" << endl;
}else
{
cout << "welcome to mysql\n\n\n";
}
mysql_query(&mysql,"SELECT operway,COUNT(operway)as a FROM sk_yh_fundinfo_copy WHERE operway not in (SELECT pwd1 FROM sk_dispwd_copy WHERE id>150) GROUP BY operway ORDER BY a desc"); // LIMIT 10000执行SQL语句
MYSQL_RES *result=mysql_store_result(&mysql); //获取资源
int rowcount=mysql_num_rows(result); //获取记录数
unsigned int fieldcount=mysql_num_fields(result); //获取字段数
//cout << rowcount << endl;
MYSQL_FIELD *field=NULL; //字段
MYSQL_ROW row=NULL; //记录
HWND ie_edit=::FindWindow(NULL,_T("中国银河 - Internet Explorer"));
CString sql;
CString sql1=_T("INSERT INTO sk_dispwd_copy(pwd1) VALUES('");
CString sql2=_T("');");
get_hwnd(ie_edit);
while(row=mysql_fetch_row(result))
{
int rowcount=0;
do{
Sleep(1000);
mysql_query(&mysql,"SELECT * FROM sk_dispwd_copy WHERE id>1700 AND pwd2='' AND pwd1 !='';"); //执行SQL语句
MYSQL_RES *num=mysql_store_result(&mysql); //获取资源
rowcount=mysql_num_rows(num); //获取记录数
if (0<rowcount)//如果更新没成功,那就再点一次。
{
dianj(ie_edit,0,70,1);
}
// Sleep(100);
}while (rowcount>0);
for(unsigned int i=0;i<fieldcount-1;i++)
{
field=mysql_fetch_field_direct(result,i);
cout<<field->name<<":"<<row[i] <<"\n";
outdata = row[i];
sql=sql1+outdata+sql2;
char csql[255];
strcpy_s(csql,sql);//将csting转换位
SendMessage(ie_edit, WM_SETTEXT, NULL,(LPARAM)(LPCTSTR)outdata );//(LPARAM)_T("12345621") //SendMessage(ie_edit, BM_CLICK,0,MAKELPARAM(70,0));
if(mysql_query(&mysql,csql) != 0)
{
outdata ="Insert Data Error";// _T("801024");//
return 1;
}
Sleep(300);
dianj(ie_edit,0,70,10);
//
Sleep(500);
}
}
mysql_free_result(result);
mysql_close(&mysql);
mysql_server_end();
mysql_library_end();
return 0;
}