- 博客(17)
- 收藏
- 关注
原创 Sort
while( number != -1 ) { a[i++]=number; ++num; if( i scanf("%d",&number); else break; } for( i=0; i { j=i+1; for( k=0; k if( a[j] { m= a[j]; while( j != k) { a
2010-02-27 15:20:00 194
原创 16
SQLFreeStmt(stmt,SQL_DROP); (void)SQLFreeHandle(SQL_HANDLE_STMT, stmt); (void)SQLDisconnect(hdbc); (void)SQLFreeHandle(SQL_HANDLE_DBC, hdbc); /*if(0 == ret) printf("Disconnect succ
2010-02-23 10:00:00 203
原创 14
if(SQL_SUCCESS != ret) { SQLGetDiagRec(nHandleType, hdbc, 1, cSQLState, &iNativeErr, cMsg, nMsgLen,&nTextLen); printf("connect failed FAILED REASON:/n%s/n",cMsg); return -1; } else
2010-02-23 09:59:00 190
原创 15
ret=SQLPrepare(stmt,(SQLCHAR*)CreateTable[SignTb],SQL_NTS); ret=SQLExecute(stmt); if(0 == ret) { printf("Exec succeed/n"); } else { SQLGetDiagRec(nHandleType, stmt, 1, cSQLState, &iNati
2010-02-23 09:59:00 468
原创 12
char* ComplexSelect[]={"select * from ucbasetab where ucnumber = ?;","select * from ucbasetab where UserIdentifier = ?;"};char* SimpleUpdate[] = { "UPDATE simpletable set batch = changed, sequence =
2010-02-23 09:58:00 295
原创 13
int createtable(int SignTb,void *p){ SQLCHAR pSqlState[MAXARRAY]; SQLSMALLINT nHandleType = SQL_HANDLE_STMT; char cMsg[512]= {/0}; int iNativeErr; char cSQLState[128] = {/0}; SQLSMALLINT nM
2010-02-23 09:58:00 176
原创 11
char* ComplexUpdate[] = { "update ucbasetab set batch =changed, sequence = ?, entid = 96385," "softPhoneNum=changed,deltimeStamp=20100118,SmsGroupLimit=456789 where ucnumber = ?;", "update ucb
2010-02-23 09:57:00 201
原创 9
char* insert_stmnt2 = "insert into hhong values(""12,?);";char* ComplexInsert="";char* InsertVal[]= { "INSERT INTO simpletable VALUES(" "?,?,?,?,1234,789,123,12345,123," "123,456,123456789,ab
2010-02-23 09:56:00 376
原创 10
"2343, 0, 121, p1, p2,p3, p4, p5, p6, p7," "p8,p9, p10, p11, p12, p13,p14, p15, p16, p17," "p18,p19, p20, 12121, 12121, wqwqwqw,sdsdsd, char5,
2010-02-23 09:56:00 200
原创 8
"WebAccessNum CHAR(6));","create table simpletable(""UserIdentifier int PRIMARY KEY,""batch CHAR(10),""sequence int,""UCNumber CHAR(20),""IMRegisted int DEFAULT 0,""localNumber int,""countryCode char(
2010-02-23 09:55:00 243
原创 6
"bwFlag int DEFAULT 3,""currentAccessNum int DEFAULT 0,""outPrivilege int DEFAULT 0,""inPrivilege int DEFAULT 2,""subscribeFuncID CHAR(6),""displayType int DEFAULT 1,""entId int ,""timeStamp CHAR(14)
2010-02-23 09:54:00 342
原创 7
"deltimeStamp CHAR(14) DEFAULT 00000000000000,""callTimeStamp CHAR(14) DEFAULT 00000000000000,""delCallTimeStamp CHAR(14) DEFAULT 00000000000000,""confTimeStamp CHAR(14) DEFAULT 00000000000000
2010-02-23 09:54:00 178
原创 5
"lastUseDateTime CHAR(14) DEFAULT 00000000000000,""IVRLastDateTime CHAR(14) DEFAULT 00000000000000,""blackCount int DEFAULT 0,""blackDateTime CHAR(14) DEFAULT 00000000000000,""webBlackCount int
2010-02-23 09:53:00 277
原创 4
char *ComplexTable="";char *SmallTable="";char *CreateTable[] ={"create table UCBaseTab(" "UserIdentifier int,""batch CHAR(10),""sequence int,""UCNumber CHAR(20) PRIMARY KEY,""IMRegiste
2010-02-23 09:52:00 321
原创 AUTOODBC_3
thread_infomation thread_info[MAXARRAY]={0};char* ComplexIndex[]={};char* TableIndex[] = { "CREATE UNIQUE INDEX user_batch_index ON UCBaseTab (batch,sequence);", "CREATE INDEX user_softNum_index ON U
2010-02-23 09:51:00 171
原创 DB_AUTOODBC_2
int Cscount = 0;int iCount =0, iThreadNum=0; //File *fp=NULL;int iComCount=0,iSimCount=0;int iComThreadNum=0,iSimThreadNum=0;int flag=0;#define DSNNAME "CSODBCDSN"#define USERNAME "root"#define P
2010-02-23 09:50:00 190
原创 DB_AUTOODBC
//gcc odbc.c readfile.c -lodbc -lodbcinst -lgmdbcsodbc -lpthread -lm -I /home/liuheng/DBODBC/#include #include #include #include #include #include #include "sql.h" #include "sqlext.h"#include "s
2010-02-23 09:48:00 279
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人