/********************************************************************
Method: OperatorTest
Parameter:
Returns:
Purpose: 测试函数
*********************************************************************/
bool OperationTest()
{
LinkList L;
CreateListByHeadTest(L); // 头插法测试
InsertTest(L); // 插入测试
DeleteTest(L); // 删除测试
ClearListTest(L);
LinkList L2;
CreateListByTailTest(L2); // 尾插法测试
ClearList(L2);
DestroyList(L); // 销毁
return true;
}
int main()
{
SQLHENV env;
SQLHDBC dbc;
SQLHSTMT stmt;
SQLRETURN ret;
SQLCHAR outstr[1024];
SQLSMALLINT outstrlen;
// Aloocate an environment handle
ret=SQLAllocHandle(SQL_HANDLE_ENV,SQL_NULL_HANDLE,&env);
checkrc(ret,__LINE__);
//we need odbc3 support
SQLSetEnvAttr(env,SQL_ATTR_ODBC_VERSION,(void*)SQL_OV_ODBC3,0);
//ALLOCATE A Connection handle
ret = SQLAllocHandle(SQL_HANDLE_DBC,env,&dbc);
checkrc(ret,__LINE__);
// connect to the DSN mydsn
ret = SQLConnect (dbc,
(SQLCHAR *) "test", (SQLSMALLINT) strlen ("test"),
(SQLCHAR *) "root",
(SQLSMALLINT) strlen ("root"),
(SQLCHAR *) "manager",
(SQLSMALLINT) strlen (""));
if(SQL_SUCCEEDED(ret))
{
printf("\nConnected to the Data Source..\n");
}
else
{
printf("error in connection\n");
ret = SQLFreeHandle(SQL_HANDLE_DBC,dbc);
checkrc(ret,__LINE__);
ret = SQLFreeHandle(SQL_HANDLE_ENV,env);
checkrc(ret,__LINE__);
return 1;
}
//******************************************************************
// TABLE CREATED
ret = SQLAllocHandle(SQL_HANDLE_STMT,dbc,&stmt);
checkrc(ret,__LINE__);
SQLCHAR table[200]=
"CREATE TABLE T1(F1 INT,F2 SMALLINT,F3 CHAR(30),F4 FLOAT,F5 FLOAT,F6 DATE,F7 TIME,F8 TIMESTAMP,F9 TINYINT,F10 BIGINT)";
ret = SQLPrepare(stmt,table,SQL_NTS);
checkrc(ret,__LINE__);
ret = SQLExecute(stmt);
checkrc(ret,__LINE__);
printf("\nTABLE CREATED\n");
//*****************************
InsertTest(env,dbc,stmt);
DeleteTest(env,dbc,stmt);
//****************************************************************
SQLCHAR drop[100]="DROP TABLE T1";
ret = SQLPrepare(stmt,drop,SQL_NTS);
checkrc(ret,__LINE__);
ret = SQLExecute(stmt);
if(ret!=SQL_SUCCESS && ret !=SQL_SUCCESS_WITH_INFO)
printf("Statement failed\n");
else
printf("Table 'T1' dropped successfully\n");
ret = SQLFreeHandle(SQL_HANDLE_STMT,stmt);
checkrc(ret,__LINE__);
ret = SQLDisconnect(dbc);
checkrc(ret,__LINE__);
ret = SQLFreeHandle(SQL_HANDLE_DBC,dbc);
checkrc(ret,__LINE__);
ret = SQLFreeHandle(SQL_HANDLE_ENV,env);
checkrc(ret,__LINE__);
return 0;
}
//*************************************************************************
// Method: onKeyDown
// Description: called on key press event
//
// Parameters:
// sender - event originator
// e - event arguments
//
// Return Value: None
//*************************************************************************
void ScheduledTestPane::onKeyDown(Object* sender, KeyEventArgs *e)
{
if ((e->KeyData == Keys::Delete) || (e->KeyData == Keys::Back))
DeleteTest(NULL, NULL);
}
