|
.#include <sqlrelay/sqlrclientwrapper.h>
#include <stdio.h>
main() {
int i,j;
sqlrcon con=sqlrcon_alloc("host",9000,"","user","password",0,1);
sqlrcur cur=sqlrcur_alloc(con);
sqlrcur_prepareQuery(cur,"begin :curs:=sp_mytable; end;");
sqlrcur_defineOutputBindCursor(cur,"curs");
sqlrcur_executeQuery(cur);
sqlrcur bindcur=sqlrcur_getOutputBindCursor(cur,"curs");
sqlrcur_fetchFromBindCursor(bindcur);
// print fields from table
for (i=0; i<sqlrcur_rowCount(bindcur); i++) {
for (j=0; j<sqlrcur_colCount(bindcur); j++) {
printf("%s,",sqlrcur_getFieldByIndex(bindcur,i,j));
}
printf("\n");
}
sqlrcur_free(bindcur);
sqlrcur_free(cur);
sqlrcon_free(con);
}
The number of cursors simultaneously available per-connection is set at compile time and defaults to 5. Getting Column Information
For each column, the API supports getting the name, type and length of each field. All databases support these attributes. The API also supports getting the precision, scale, length of the longest field, and whether the column is nullable, the primary key, unique, part of a key, unsigned, zero-filled, binary, or an auto-incrementing field. However, not all databases support these attributes. If a database doesn''''t support an attribute, it is always returned as false. #include <sqlrelay/sqlrclientwrapper.h>
#include <stdio.h>
main() {
int i;
sqlrcon con=sqlrcon_alloc("host",9000,"","user","password",0,1);
sqlrcur cur=sqlrcur_alloc(con);
sqlrcur_sendQuery(cur,"select * from my_table");
sqlrcon_endSession(con);
for (i=0; i<sqlrcur_colCount(cur); i++) {
printf("Name: %s\n",sqlrcur_getColumnName(cur,i));
printf("Type: %s\n",sqlrcur_getColumnType(cur,i));
printf("Length: %d\n",sqlrcur_getColumnLength(cur,i));
printf("Precision: %d\n",sqlrcur_getColumnPrecision(cur,i));
printf("Scale: %d\n",sqlrcur_getColumnScale(cur,i));
printf("Longest Field: %d\n",sqlrcur_getLongest(cur,i));
printf("Nullable: %d\n",sqlrcur_getColumnIsNullable(cur,i));
printf("Primary Key: %d\n",sqlrcur_getColumnIsPrimaryKey(cur,i));
printf("Unique: %d\n",sqlrcur_getColumnIsUnique(cur,i));
printf("Part of Key: %d\n",sqlrcur_getColumnIsPartOfKey(cur,i));
printf("Unsigned: %d\n",sqlrcur_getColumnIsUnsigned(cur,i));
printf("Zero Filled: %d\n",sqlrcur_getColumnIsZeroFilled(cur,i));
printf("Binary: %d\n",sqlrcur_getColumnIsBinary(cur,i));
printf("Auth Increment:%d\n",sqlrcur_getColumnIsAutoIncrement(cur,i));
printf("\n");
}
sqlrcur_free(cur);
sqlrcon_free(con);
}
Some databases force column names to upper case, others force column names to lower case, and others still support mixed-case column names. Sometimes, when migrating between databases, you can run into trouble. You can use upperCaseColumnNames() and lowerCaseColumnNames() to cause column names to be converted to upper or lower case, or you can use mixedCaseColumnNames() to cause column names to be returned in the same case as they are defined in the database. #include <sqlrelay/sqlrclientwrapper.h>
#include <stdio.h>
main() {
int i;
sqlrcon con=sqlrcon_alloc("host",9000,"","user","password",0,1);
sqlrcur cur=sqlrcur_alloc(con);
// column names will be forced to upper case
sqlrcur_upperCaseColumnNames(cur);
sqlrcur_endQuery(cur,"select * from my_table");
sqlrcon_endSession(con);
for (i=0; i<sqlrcur_colCount(c上一页 [1] [2] [3] [4] [5] [6] [7] [8] [9] [10] ... 下一页 >>
[Access]sql随机抽取记录 [Access]ASP&SQL让select查询结果随机排序的实现方法
[办公软件]在sybase中插入图片、PDF、文本文件 [办公软件]安装Sybase ASE
[办公软件]linux指令大全(完整篇) [办公软件]Linux新手入门常用命令大全
[办公软件]在RedHat Linux 9里安装gaim0.80 [办公软件]浅谈Linux 下Java 1.5 汉字方块问题解决方法
[办公软件]Linux程序员必读：中文化与GB18030标准 [办公软件]linux指令大全
|
注：本站部分文章源于互联网，版权归原作者所有！如有侵权，请原作者与本站联系，本站将立即删除！ 本站文章除特别注明外均可转载，但需注明出处！ [MinTao学以致用网] 
