Linux下通過C語言操作SqlLite數(shù)據(jù)庫
下面的代碼用于寫入數(shù)據(jù)到sqlite數(shù)據(jù)庫和遍歷數(shù)據(jù)

#include <stdio.h>
#include <sqlite3.h>
 
//查詢的回調(diào)函數(shù)聲明
int select_callback(void * data, int col_count, char ** col_values, char ** col_Name);
 
int main(int argc, char * argv[])
{
  const char * sSQL1 = "create table users(userid varchar(20) PRIMARY KEY, age int, birthday datetime);";
  char * pErrMsg = 0;
  int result = 0;
  // 連接數(shù)據(jù)庫
  sqlite3 * db = 0;
  int ret = sqlite3_open("./test.db", &db);
  if( ret != SQLITE_OK ) {
    fprintf(stderr, "無法打開數(shù)據(jù)庫: %s", sqlite3_errmsg(db));
    return(1);
  }
  printf("數(shù)據(jù)庫連接成功!\n");
 
  // 執(zhí)行建表SQL
  sqlite3_exec( db, sSQL1, 0, 0, &pErrMsg );
  if( ret != SQLITE_OK ){
    fprintf(stderr, "SQL error: %s\n", pErrMsg);
    sqlite3_free(pErrMsg);
  }
 
  // 執(zhí)行插入記錄SQL
  result = sqlite3_exec( db, "insert into users values('張三',20,'2011-7-23');", 0, 0, &pErrMsg);
  if(result == SQLITE_OK){
    printf("插入數(shù)據(jù)成功\n");
  }
  result = sqlite3_exec( db, "insert into users values('李四',20,'2012-9-20');", 0, 0, &pErrMsg);
  if(result == SQLITE_OK){
    printf("插入數(shù)據(jù)成功\n");
  }
 
  // 查詢數(shù)據(jù)表
  printf("查詢數(shù)據(jù)庫內(nèi)容\n");
  sqlite3_exec( db, "select * from users;", select_callback, 0, &pErrMsg);
 
  // 關(guān)閉數(shù)據(jù)庫
  sqlite3_close(db);
  db = 0;
  printf("數(shù)據(jù)庫關(guān)閉成功!\n");
 
  return 0;
}
 
int select_callback(void * data, int col_count, char ** col_values, char ** col_Name)
{
  // 每條記錄回調(diào)一次該函數(shù),有多少條就回調(diào)多少次
  int i;
  for( i=0; i < col_count; i++){
    printf( "%s = %s\n", col_Name[i], col_values[i] == 0 ? "NULL" : col_values[i] );
  }
 
  return 0;
}

標(biāo)簽： linux 代碼 數(shù)據(jù)庫

版權(quán)申明：本站文章部分自網(wǎng)絡(luò)，如有侵權(quán)，請聯(lián)系：west999com@outlook.com
特別注意：本站所有轉(zhuǎn)載文章言論不代表本站觀點(diǎn)！
本站所提供的圖片等素材，版權(quán)歸原作者所有，如需使用，請與原作者聯(lián)系。