前幾天隨便做的一個範例,以提供某天用到的時候作參考。
環境Cygwin+sqlite3
#ifdef SQLITE_ENABLE_ICU
#udefine SQLITE_ENABLE_ICU
#endif
/*
#ifndef SQLITE_CORE
#define SQLITE_CORE
#endif
*/
#include < stdio.h >
#include " sqlite3.h "
#include < iostream >
using namespace std;
const char * sqlCreate = " CREATE TABLE items(id integer primary key, stocknum float, name varchar(30), price float, status varchar(12) ) " ;
const char * sqlSelect = " SELECT stocknum,name,price FROM items ORDER BY stocknum " ;
const char * sqlInsert0 = " INSERT INTO items VALUES(NULL, 323.123, 'Product01', 565.456, 'IN') " ;
const char * sqlInsert1 = " INSERT INTO items VALUES(NULL, 423.123, '莉', 665.456, 'IN') " ;
環境Cygwin+sqlite3
#ifdef SQLITE_ENABLE_ICU
#udefine SQLITE_ENABLE_ICU
#endif
/*
#ifndef SQLITE_CORE
#define SQLITE_CORE
#endif
*/
#include < stdio.h >
#include " sqlite3.h "
#include < iostream >
using namespace std;
const char * sqlCreate = " CREATE TABLE items(id integer primary key, stocknum float, name varchar(30), price float, status varchar(12) ) " ;
const char * sqlSelect = " SELECT stocknum,name,price FROM items ORDER BY stocknum " ;
const char * sqlInsert0 = " INSERT INTO items VALUES(NULL, 323.123, 'Product01', 565.456, 'IN') " ;
const char * sqlInsert1 = " INSERT INTO items VALUES(NULL, 423.123, '莉', 665.456, 'IN') " ;