• <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久久人妻无码精品系列| 老司机国内精品久久久久| 久久久久无码精品| 亚洲中文字幕无码久久2020| 国产亚洲欧美精品久久久| 久久综合一区二区无码| 久久精品国产亚洲AV电影| 久久久久国产日韩精品网站| 精品久久久噜噜噜久久久| 久久精品免费大片国产大片| 久久亚洲精精品中文字幕| 国产午夜精品理论片久久| 久久亚洲精精品中文字幕| 久久婷婷午色综合夜啪| 久久这里只精品国产99热| 无码人妻精品一区二区三区久久 | 久久夜色精品国产www| 久久丫精品国产亚洲av不卡| 一本综合久久国产二区| 99热成人精品免费久久| 久久久噜噜噜www成人网| 久久天天躁狠狠躁夜夜不卡| 国产成人综合久久精品尤物| 精品综合久久久久久97超人| 久久天天躁狠狠躁夜夜avapp| 久久亚洲国产成人影院| 九九精品久久久久久噜噜| 久久精品国产欧美日韩| 精品久久久久久无码中文野结衣| AV无码久久久久不卡蜜桃| 久久亚洲春色中文字幕久久久| 国产偷久久久精品专区| 亚洲国产成人精品久久久国产成人一区二区三区综 | 久久综合九色综合97_久久久| 久久久久久久久久久久久久| 久久亚洲天堂| 伊人色综合九久久天天蜜桃|