SQLiteTutorial

提供: やる気向上作戦

SQLite

---

目次 1 データベースを開く 2 テーブルを作ってみる 3 行を挿入してみる 4 行を選択してみる

データベースを開く

#include "sqlitepp.h"
 
using namespace sqlitepp;
 
int main(int argc, char** argv)
{
  SqliteConnection con("test.db");
  return 0;
}

テーブルを作ってみる

#include "sqlitepp.h"
 
using namespace sqlitepp;
 
int main(int argc, char** argv)
{
  SqliteConnection con("test.db");
  SqliteStatement* stmt = con.createStatement(
	"CREATE TABLE testTable ("
	  "id INTEGER PRIMARY KEY,"
	  "value TEXT NOT NULL"
	  ");");
  stmt->execute();
  delete stmt;
 
  return 0;
}

行を挿入してみる

#include "sqlitepp.h"
 
using namespace sqlitepp;
 
int main(int argc, char** argv)
{
  SqliteConnection con("test.db");
  SqliteStatement* stmt = con.createStatement(
	"INSERT INTO testTable VALUES(?, ?);");
  stmt->setInt(0, 1);
  stmt->setString(1, "ABC");
  stmt->execute();
  delete stmt;
 
  return 0;
}

行を選択してみる

#include "sqlitepp.h"
#include <iostream>
 
using namespace sqlitepp;
 
int main(int argc, char** argv)
{
  SqliteConnection con("test.db");
  SqliteStatement* stmt = con.createStatement(
	"SELECT * FROM testTable WEHRE id=1;");
  SqliteCursor* cur = stmt->executeQuery();
 
  while (cur->next()) {
	std::cout << "id=" << cur->getInt(0) << " value=" << cur->getString(1) << std::endl;
  }
 
  delete cur;
  delete stmt;
 
  return 0;
}