Click here to Skip to main content
Click here to Skip to main content

Another Embedded Database For C++

, 14 Jan 2007 BSD
Rate this:
Please Sign up or sign in to vote.
A C++ wrapper to SQLite database

Introduction

Here is another wrapper for the famous SQLite database engine. Yes, I know about CppSQLite. It is an excellent wrapper for SQLite. I do not claim my code is superior to CppSQLite in some way. But if you already know the JDBC API, then you will find my library really easy and straightforward to use.

Using the code

Let us jump right into some example snippets that will help you start using the classes right away. To create or open a database, use the Connection class' open() function.

Connection conn;
conn.open("mydb"); // the argument is the database name.

To execute SQL commands, get a handle to the Statement object. Call the execute() function to execute all SQL commands except SELECT. The execute() function will return the number of rows affected by the query.

Statement* stmt = conn.createStatement();
stmt->execute("create table albums(title,artist)"); // creates a table
stmt->execute(
 "insert into albums values('Brothers in Arms','Dire Straits')");
    // insert some data
stmt->execute("insert into albums values('Unplugged','Eric Clapton')");

To execute a SELECT statement, use the executeQuery() function. This function returns a handle to a ResultSet. use the next() function to navigate through the ResultSet. The ResultSet class has a number of getXXX() functions that take the number of the column as it's argument and return that column's value as the specified type. The different getXXX() functions are:

  • std::string getString(int colNum)
  • int getInt(int colNum)
  • long getLong(int colNum)
  • unsigned int getUInt(int colNum)
  • unsigned long getULong(int colNum)
  • float getFloat(int colNum)
  • double getDouble(int colNum)
  • bool getBoolean(int colNum)

The ResultSet has an object of ResultSetMetaData embedded with in it. We can get a handle to this object with a call to getMetaData(). The ResultSetMetaData contains information like the number of columns in the ResultSet, their names and data types.

ResultSet* rslt = stmt->executeQuery("select * from albums");
ResultSetMetaData* r_mtdt = rslt->getMetaData();
int cols = r_mtdt->getColumnCount();
while(rslt->next()) {
  for(int i=0;i<cols;i++) {
    printf("%s (%s): %s  ",r_mtdt->getColumnName(i+1).c_str(),
    r_mtdt->getColumnType(i+1).c_str(),rslt->getString(i+1).c_str());
  }
  printf("\n");
}

The DatabaseMetaData class contains the meta data of the entire database. We can obtain a DatabaseMetaData handle by calling the getDatabaseMetaData() function of the Connection class.

Call the refreshMetaData() function first, if you want the latest database meta data.

conn.refreshMetaData();
if(conn.getDatabaseMetaData()->doesObjectExist("albums","table")) 
    // check to see if a table exists
  stmt->execute("drop table albums");// delete it if it exists

The DatabaseMetaData contains the following information:

  • Number of objects in the database.
  • Name of each object
  • Type of each object (table,index)

We can use the doesObjectExist() function to check if an object exists in the database. The first argument of this function is the name of the object and the second argument is it's type. This can be either "table" or "index".

Points of Interest

  1. To use this library, include the header file dsqlxprez_2.h and link your project with sqlite3.lib
  2. Always enclose database calls in a try - catch block that catches a SQLException
  3. All the classes in the library falls in a namespace called dsqlxprez. (DSQL stands for DarkSide SQL. Just a name, that's' it !!)
  4. You do not have to call the close() function on the Connection object explicitly. All resources are automatically deleted by the library when the Connection object's destructor is executed.

History

  • Created July 26, 2004.
  • Updated downloads Jan 14, 2007

License

This article, along with any associated source code and files, is licensed under The BSD License

Share

About the Author

No Biography provided

Comments and Discussions

 
GeneralThank you ! PinmemberMemocs24-Jun-07 17:46 
QuestionSQLITE3.DLL Pinmemberusf_azi9-Feb-07 9:03 
GeneralI prefer Rob Groves version... PinmemberAaron Planell16-Jan-07 22:40 
GeneralRe: I prefer Rob Groves version... Pinmembershiftedbitmonkey5-Jan-09 14:43 
GeneralSlow insert fast select PinmemberGVR197912-Jan-07 5:03 
GeneralRe: Slow insert fast select Pinmemberislobodan14-Jan-07 9:54 
Generallast_insert_rowid PinmemberGVR197910-Jan-07 7:55 
GeneralRe: last_insert_rowid PinmemberVijay Mathew Pandyalakal11-Jan-07 1:41 
GeneralRe: last_insert_rowid PinmemberGVR197912-Jan-07 5:54 
GeneralRe: last_insert_rowid PinmemberVijay Mathew Pandyalakal15-Jan-07 17:57 
Generalsqlite3.dll and sqlite3.lib for vc++ 6.0 PinmemberThai Duong Nguyen3-Jan-07 18:54 
GeneralRe: sqlite3.dll and sqlite3.lib for vc++ 6.0 PinmemberVijay Mathew Pandyalakal4-Jan-07 18:18 
GeneralRe: sqlite3.dll and sqlite3.lib for vc++ 6.0 PinmemberAaron Planell16-Jan-07 22:43 
Generalwww.sqlite.org, Please PinsitebuilderUwe Keim2-Jan-07 22:58 
GeneralRe: www.sqlite.org, Please PinmemberVijay Mathew Pandyalakal3-Jan-07 18:19 
QuestionWhat has changed ... PinmemberHans Dietrich2-Jan-07 19:29 
AnswerRe: What has changed ... PinmemberVijay Mathew Pandyalakal3-Jan-07 18:13 
GeneralMemory Leak Pinmemberjbay10130-Dec-06 19:52 
GeneralRe: Memory Leak PinmemberVijay Mathew Pandyalakal1-Jan-07 20:33 
Generalwindows mobile PinmemberGVR197929-Nov-06 12:08 
GeneralRe: windows mobile PinmemberVijay Mathew Pandyalakal29-Nov-06 17:53 
GeneralRe: windows mobile PinmemberGVR197930-Nov-06 4:43 
GeneralRe: windows mobile PinmemberVijay Mathew Pandyalakal30-Nov-06 18:11 
QuestionLicense? PinmemberSceptic Mole14-Nov-06 11:42 
AnswerRe: License? PinmemberVijay Mathew Pandyalakal14-Nov-06 18:45 
Generalerror in sqlite - ISO C++ forbids declaration of `open' with no type Pinmembersultan_sk13-Nov-06 4:07 
GeneralRe: error in sqlite - ISO C++ forbids declaration of `open' with no type PinmemberVijay Mathew Pandyalakal13-Nov-06 19:36 
GeneralUnicode Pinmembergillnrb19-May-06 5:17 
GeneralRe: Unicode PinmemberAaron Planell16-Jan-07 22:43 
GeneralVery good Job! PinmemberILikeThisSite16-Mar-06 3:52 
GeneralRe: Very good Job! PinmemberVijay Mathew Pandyalakal16-Mar-06 16:49 
QuestionError compiling in devcpp? Pinmemberthe12be24-Jul-05 12:19 
AnswerRe: Error compiling in devcpp? PinmemberVijay Mathew Pandyalakal24-Jul-05 19:49 
GeneralCompiling using Devcpp Pinmembermdr216-May-05 16:05 
GeneralRe: Compiling using Devcpp PinmemberVijay Mathew Pandyalakal16-May-05 18:46 
GeneralExcellent Work PinsussCleve Blakemore24-Feb-05 16:02 
Generalusing in C# Pinmemberkadnan15-Jan-05 7:01 
GeneralRe: using in C# PinmemberVijay Mathew Pandyalakal26-Jan-05 19:32 
AnswerRe: using in C# PinmemberSteffen Lange5-Jan-07 0:40 
Questionhow to insert a variable Pinmemberaqndyggg15-Nov-04 13:01 
AnswerRe: how to insert a variable PinmemberVijay Mathew Pandyalakal15-Nov-04 17:51 
GeneralRe: how to insert a variable Pinmemberaqndyggg16-Nov-04 3:00 
GeneralWhich SQLite paltform 2.8.15 or 3.0.8 PinmemberSharad Kelkar6-Nov-04 19:34 
GeneralRe: Which SQLite paltform 2.8.15 or 3.0.8 PinmemberVijay Mathew Pandyalakal7-Nov-04 17:47 
GeneralRe: Which SQLite paltform 2.8.15 or 3.0.8 PinmemberSharad Kelkar7-Nov-04 19:39 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.

| Advertise | Privacy | Terms of Use | Mobile
Web04 | 2.8.141220.1 | Last Updated 14 Jan 2007
Article Copyright 2004 by AnOldGreenHorn
Everything else Copyright © CodeProject, 1999-2014
Layout: fixed | fluid