sql_createtable.c

教学资源管理系统教室分配子系统,也是一个毕业设计.minigui下的!

#include <stdio.h>
#include "sqlite3.h" /* orignal is <sqlite3.h> */
int sql_createtable( char arr[][20] )
{
	sqlite3 *db=NULL;
	char *zErrMsg = 0;
	int rc,nrow,ncolumn,i;
	char sql_cmd[200];
	char test[10];
	char **azResult;

	sqlite3_open("zieckey.db", &db); //打开指定的数据库文件,如果不存在将创建一个同名的数据库文件
	//建立表js
	sprintf(sql_cmd,"CREATE TABLE js(number NVARCHAR PRIMARY KEY,jiaoshi char(24))");
	rc = sqlite3_exec(db,sql_cmd,  NULL, NULL, &zErrMsg);
	if(rc==SQLITE_OK)
		printf("create table1 successful\n");
	else
		printf("%s\n",zErrMsg);
	sprintf(sql_cmd,"INSERT INTO js (number,jiaoshi) VALUES(1,'新校102')");
	rc = sqlite3_exec(db, sql_cmd, NULL, NULL, &zErrMsg);
	if(rc==SQLITE_OK)
		printf("inster js successful\n");
	else
		printf("%s\n",zErrMsg);
/*查询*/
	sprintf(sql_cmd,"SELECT * FROM js ");
	rc = sqlite3_get_table(db,sql_cmd,&azResult,&nrow,&ncolumn,&zErrMsg);
		if(rc == SQLITE_OK)
			printf(" sqlite3_get_table\n");
		else
			printf("%s\n",zErrMsg);
		for( i=0 ; i<( nrow + 1 ) * ncolumn ; i++ )
		{
			printf( "azResult[%d] = %s\n", i , azResult[i] );
			sprintf(test,azResult[i]);
		//	strcpy(arr[i] , test);
		//	printf("%s\n",arr[i]);
		}

/**/


	//建立表sq
	sprintf(sql_cmd,"CREATE TABLE sq(number NVARCHAR PRIMARY KEY,riqi DATE,xingqi char(12),kebie char(24),jiaoshi char(32),beizhu char(50))");
	rc = sqlite3_exec(db,sql_cmd,  NULL, NULL, &zErrMsg);
	if(rc==SQLITE_OK)
		printf("create table3 successful\n");
	else
		printf("%s\n",zErrMsg);

	
//	sqlite3_free(errmsg);
	sqlite3_close(db); //关闭数据库

	
}