4,011
社区成员
发帖
与我相关
我的任务
分享
sprintf(sql , "select FUser from t_user where FUser='%s'" , inputUser);
result = SQLAllocHandle(SQL_HANDLE_STMT, hdbc, &hstmt);
result = SQLPrepare(hstmt,(SQLCHAR*)sql,SQL_NTS);
CHECKDBSTMTERROR(hwnd,result,hstmt);//检查错误
result = SQLExecute(hstmt);//执行sql语句
CHECKDBSTMTERROR(hwnd,result,hstmt);
sprintf(sql , "insert into t_uer(FUser,FPassword) values('%s','%s')" , inputUser , inputPassword);
result = SQLAllocHandle(SQL_HANDLE_STMT, hdbc, &hstmt);
result = SQLPrepare(hstmt,(SQLCHAR*)sql,SQL_NTS);
CHECKDBSTMTERROR(hwnd,result,hstmt);
result = SQLExecute(hstmt);//执行sql语句,这一句出错
CHECKDBSTMTERROR(hwnd,result,hstmt);
SQLFreeStmt(hstmt,SQL_CLOSE);
SQLDisconnect(hdbc);
SQLFreeHandle(SQL_HANDLE_DBC,hdbc);
SQLFreeHandle(SQL_HANDLE_ENV,henv);
henv = NULL;
hdbc = NULL;
hstmt = NULL;
result = NULL;
DataInit(hwnd , henv , hdbc , hstmt , result);