- 在esql中使用的变量声明
这些变量在使用时前面要加上: - exec sql begin declare section;
- char _id[10];
- char _name[20];
- char _password[18];
- char _branchid[9];
- char _roleid[2];
- char db_name[128+1];
- char _sql[] = "update userinfo set password=? where userid=?";
- exec sql end declare section;
- 简单的esql操作
动态SQL操作例1
- EXEC SQL DECLARE cursor1 CURSOR FOR /
- select userid from userinfo;
- EXEC SQL OPEN cursor1;
- do
- {
- EXEC SQL FETCH cursor1 INTO :_id;
- if(sqlca.sqlcode == 100) break;
- printf("%10s/n", _id);
- } while(1);
动态SQL操作例2
- exec sql begin declare section;
- char _id[10];
- char _name[20];
- char _password[18];
- char _sql[] = "update userinfo set password=? where userid=?";
- exec sql end declare section;
- memset(_id, 0x00, sizeof(_id));
- memset(_password, 0x00, sizeof(_password));
- sprintf(_id, "%s", "001");
- sprintf(_password, "%s", "haha");
- EXEC SQL PREPARE prep_stat FROM :_sql;
- EXEC SQL EXECUTE prep_stat USING :_password, :_id;
esql中声明变量和使用动态游标
最新推荐文章于 2022-03-23 08:52:48 发布