• <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   管理


            国产精品久久久久久久久| 亚洲精品乱码久久久久久按摩| 97久久香蕉国产线看观看| 国产精品久久成人影院| 国产农村妇女毛片精品久久| 一级做a爰片久久毛片16| 精品久久久久久国产免费了| 久久青青国产| 国产99精品久久| 亚洲伊人久久综合影院| 久久99热国产这有精品| 伊人色综合久久天天人守人婷| 精品久久久久中文字幕日本| 国产精品无码久久久久| 久久无码人妻一区二区三区午夜 | 国产精品va久久久久久久| 亚洲欧洲精品成人久久奇米网| 77777亚洲午夜久久多人| 国产叼嘿久久精品久久| 久久久久亚洲av无码专区喷水| 久久久久久国产精品美女| 97久久国产综合精品女不卡| 国产精品成人久久久久三级午夜电影 | 久久婷婷五月综合97色直播| 国产∨亚洲V天堂无码久久久 | 伊人久久综在合线亚洲2019| 亚洲精品久久久www| 99久久er这里只有精品18| 久久婷婷色综合一区二区| 国内精品久久国产大陆| 久久人人爽人人爽人人片av高请| 久久一本综合| 一本大道久久东京热无码AV| 久久er国产精品免费观看8| 97久久精品人人做人人爽| 久久综合狠狠色综合伊人| 久久99热精品| 88久久精品无码一区二区毛片 | 久久久久久亚洲精品影院| 久久99精品免费一区二区| 国产精品激情综合久久|