mfc插入mysql记录_MFC 向数据库添加记录要怎么编写呢?

voidCtestDlg::OnBnClickedButton1(){CDatabasedb;CStringconnect="DRIVER={MicrosoftAccessDriver(*.mdb)};uid=;pwd=xxx123456;DBQ=my.mdb;";if(!db.Open(NULL,0,0,connect)){Messag...

void CtestDlg::OnBnClickedButton1()

{

CDatabase db;

CString connect = "DRIVER={Microsoft Access Driver (*.mdb)};uid=;pwd=xxx123456;DBQ=my.mdb;";

if(!db.Open(NULL,0,0,connect))

{

MessageBox("打开数据库失败");

return ;

}

//db.BindParameters(

CRecordset db_set(&db);

CString sSql;

sSql = "SELECT * FROM 学生成绩";

db_set.Open(CRecordset::forwardOnly,sSql,CRecordset::none);

// loop read

while( !db_set.IsEOF() )

{

// Copy each column into a variable

CString str1,str2,str3,str4,str5;

//CString sTemp;

db_set.GetFieldValue("姓名",str1);

db_set.GetFieldValue("性别",str2);

db_set.GetFieldValue("数学成绩",str3);

db_set.GetFieldValue("语文成绩",str4);

db_set.GetFieldValue("英语成绩",str5);

DebugString("%s %s %s %s %s",

(LPCTSTR)str1,(LPCTSTR)str2,(LPCTSTR)str3,(LPCTSTR)str4,(LPCTSTR)str5);

// goto next record

db_set.MoveNext();

}

// 想数据库里面增加数据要怎么编写啊!

// db_set.AddNew() 这个函数后面,要怎么写啊???

db_set.Close();

db.Close();

}

// db_set.AddNew() 是添加函数,,,可是后面要怎么写呢??

求高手解答啊!!

展开