• <ins id="pjuwb"></ins>
    <blockquote id="pjuwb"><pre id="pjuwb"></pre></blockquote>
    <noscript id="pjuwb"></noscript>
          <sup id="pjuwb"><pre id="pjuwb"></pre></sup>
            <dd id="pjuwb"></dd>
            <abbr id="pjuwb"></abbr>

            eryar

            PipeCAD - Plant Piping Design Software.
            RvmTranslator - Translate AVEVA RVM to OBJ, glTF, etc.
            posts - 603, comments - 590, trackbacks - 0, articles - 0

            SQLite Hello Code

            Posted on 2012-10-27 23:21 eryar 閱讀(1527) 評論(0)  編輯 收藏 引用
              1: //------------------------------------------------------------------------------
            
              2: //	Copyright (c) 2012 eryar All Rights Reserved.
            
              3: //
            
              4: //		File    : Main.cpp
            
              5: //		Author  : eryar@163.com
            
              6: //		Date    : 2012-10-27 23:01
            
              7: //		Version : 0.1v
            
              8: //
            
              9: //	Description : Test SQLite program.
            
             10: //
            
             11: //==============================================================================
            
             12: 
            
             13: #include <stdio.h>
            
             14: #include "sqlite3.h"
            
             15: 
            
             16: // Query callback function.
            
             17: int QueryCallback(void* data, int colCount, char** colValues, char** colName);
            
             18: 
            
             19: int main(int argc, char* argv[])
            
             20: {
            
             21:     int iResultCode = 0;
            
             22:     char*   szErrorMsg  = NULL;
            
             23:     const char* szCreateTableSQL = "create table users(name varchar(20) primary key, age int, birthday datetime);";
            
             24:     
            
             25:     // Connect to the database.
            
             26:     sqlite3*    pDB = NULL;
            
             27: 
            
             28:     iResultCode = sqlite3_open("test.db", &pDB);
            
             29: 
            
             30:     if (iResultCode != SQLITE_OK)
            
             31:     {
            
             32:         fprintf(stderr, "Cann't open database: %s\n", sqlite3_errmsg(pDB));
            
             33:         return 1;
            
             34:     }
            
             35: 
            
             36:     printf("Connected to the database successfully!\n");
            
             37: 
            
             38: 
            
             39:     // Execute the create table command.
            
             40:     iResultCode = sqlite3_exec(pDB, szCreateTableSQL, 0, 0, &szErrorMsg);
            
             41:     if (iResultCode != SQLITE_OK)
            
             42:     {
            
             43:         fprintf(stderr, "SQL error: %s! \n", szErrorMsg);
            
             44: 
            
             45:         sqlite3_free(szErrorMsg);
            
             46:     }
            
             47: 
            
             48:     // Insert records to the database.
            
             49:     iResultCode = sqlite3_exec(pDB, "insert into users values('張三', 20, '2012-10-27');", 0, 0, &szErrorMsg);
            
             50:     if (iResultCode)
            
             51:     {
            
             52:         printf("Insert a record to the database.\n");
            
             53:     }
            
             54: 
            
             55:     // Query the database.
            
             56:     iResultCode = sqlite3_exec(pDB, "select * from users;", QueryCallback, 0, &szErrorMsg);
            
             57: 
            
             58:     sqlite3_close(pDB);
            
             59: 
            
             60:     return 0;
            
             61: }
            
             62: 
            
             63: // For every record will call the callback function.
            
             64: // N records will call the callback function N times.
            
             65: int QueryCallback( void* data, int colCount, char** colValues, char** colName )
            
             66: {
            
             67:     for (int i = 0; i < colCount; i++)
            
             68:     {
            
             69:         printf("%s = %s\n", colName[i], colValues[i] == 0 ? "NULL":colValues[i]);
            
             70:     }
            
             71: 
            
             72:     return 0;
            
             73: }
            
             74: 

             

            輸出結(jié)果:

              1: Connected to the database successfully!
            
              2: name = 張三
            
              3: age = 20
            
              4: birthday = 2012-10-27
            
              5: Press any key to continue

            只有注冊用戶登錄后才能發(fā)表評論。
            網(wǎng)站導(dǎo)航: 博客園   IT新聞   BlogJava   博問   Chat2DB   管理


            日本福利片国产午夜久久| 欧美色综合久久久久久| 亚洲欧美精品一区久久中文字幕| 久久99精品久久久久婷婷| 色综合合久久天天给综看| 久久se这里只有精品| 精品国产青草久久久久福利 | 久久久久亚洲精品天堂久久久久久 | 思思久久99热只有频精品66| 久久久久这里只有精品| 久久夜色撩人精品国产| 一极黄色视频久久网站| 久久精品免费一区二区| 蜜臀av性久久久久蜜臀aⅴ麻豆| 日本久久久久亚洲中字幕| 国产午夜久久影院| 国产日韩久久久精品影院首页| 久久久久久久久久久免费精品| 久久久久久国产精品无码下载| 久久精品国产男包| 72种姿势欧美久久久久大黄蕉| 久久综合丁香激情久久| 久久久无码精品午夜| 无码人妻精品一区二区三区久久久| 久久综合88熟人妻| 精品无码久久久久久久久久| 偷窥少妇久久久久久久久| 99久久久精品| 一本久道久久综合狠狠躁AV| 人妻少妇久久中文字幕| 久久精品成人免费观看97| 亚洲国产美女精品久久久久∴| 四虎国产精品免费久久久| 国产精品狼人久久久久影院| 国产精品久久久久久五月尺| 狠狠干狠狠久久| 亚洲日本va中文字幕久久| 91性高湖久久久久| 国产精品美女久久久m| 一本色道久久综合| 国产99久久久久久免费看|