sqlite3.cpp

/*
 * =====================================================================================
 *
 *       Filename:  sqlite3.cpp
 *
 *    Description:
 *
 *        Version:  1.0
 *        Created:  09/13/2017 03:07:51 PM
 *  Last Modified:  09/13/2017 03:07:51 PM
 *       Revision:  none
 *       Compiler:  gcc
 *
 *         Author:  zt (),
 *   Organization:
 *
 * =====================================================================================
 */

#include <stdio.h>
#include <stdlib.h>
#include <sqlite3.h>

static int callback ( void* NotUsed, int argc, char** argv, char** azColName )
{
  int i = 0;

  for ( i = 0; i < argc; ++i )
  {
    printf ( "%s=%s\n", azColName[i], argv[i] ? argv[i] : "NULL" );
  }

  printf ( "\n" );

  return 0;
}


int main ( int argc, char* argv[] )
{
  sqlite3* db = NULL;
  char* zErrMsg = 0;
  int rc;

  rc = sqlite3_open ( "test.db", &db );

  if ( rc )
  {
    fprintf ( stderr, "cant't open database: %s\n", sqlite3_errmsg ( db ) );
    exit ( 0 );
  }
  else
  {
    fprintf ( stdout, "open ok\n" );
  }

  char sql[] = "CREATE TABLE COMPANY("\
               "ID INT PRIMARY KEY NOT NULL,"\
               "NAME TEXT NOT NULL,"\
               "AGE INT NOT NULL,"\
               "ADDRESS CHAR(50),"\
               "SALARY REAL);";

  rc = sqlite3_exec ( db, sql, callback, 0, &zErrMsg );

  if ( rc != SQLITE_OK )
  {
    fprintf ( stderr, "SQL error:%s\n", zErrMsg );
    sqlite3_free ( zErrMsg );
  }
  else
  {
    fprintf ( stdout, "ok!!!\n" );
  }

  sqlite3_close ( db );

  return 0;
}