sys_sql.c

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

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

	sqlite3_open("zieckey.db", &db); //打开指定的数据库文件,如果不存在将创建一个同名的数据库文件
	sprintf(sql_cmd,"CREATE TABLE js(number INTEGER 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 (jiaoshi) VALUES('新校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(sql_cmd,"CREATE TABLE sq(number INTEGER 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 table2 successful\n");
	else
		printf("%s\n",zErrMsg);

	
	sqlite3_free_table( azResult );
	sqlite3_close(db); //关闭数据库

	return 0;
}