4,011
社区成员
发帖
与我相关
我的任务
分享
sql = "insert into student values(";
for (int i=0; i<5; i++)
{
sql += str_vec[i].val_number +"," + str_vec[i].val_name+","+str_vec[i].val_class+")";
/*分配语句句柄*/
retcode = SQLAllocHandle(SQL_HANDLE_STMT,hdbc,&hstmt);
if(retcode == SQL_SUCCESS || retcode == SQL_SUCCESS_WITH_INFO)
{
retcode = SQLPrepare(hstmt, (SQLCHAR*)sql.c_str(), SQL_NTS);
retcode = SQLExecute(hstmt);
if (retcode == SQL_SUCCESS || retcode == SQL_SUCCESS_WITH_INFO)
{
cout<<"insert Success !!!"<<endl;
}
SQLFreeStmt(hstmt,SQL_DROP);
}
cout<<retcode<<endl;
}