<?xml version="1.0" encoding="utf-8"?>

<!-- Copyright (c) 2007-2010 Nokia Corporation and/or its subsidiary(-ies) All rights reserved. -->

<!-- This component and the accompanying materials are made available under the terms of the License 

"Eclipse Public License v1.0" which accompanies this distribution, 

and is available at the URL "http://www.eclipse.org/legal/epl-v10.html". -->

<!-- Initial Contributors:

    Nokia Corporation - initial contribution.

Contributors: 

-->

<!DOCTYPE concept

  PUBLIC "-//OASIS//DTD DITA Concept//EN" "concept.dtd">

<concept xml:lang="en" id="GUID-5FB2141F-8B2F-5DAE-8FDF-58D7351C5848"><title> Basic SQL Example: basicsqlexample.h </title><prolog><metadata><keywords/></metadata></prolog><conbody><p>A copy of the basicsqlexample.h file for the basic SQL example application. </p> <section><title>Introduction</title> <p>The program class and functions are declared in this file. </p> </section> <section><title>Code</title> <p>Declares the program structure. </p> <codeblock id="GUID-7022074F-62E3-5E4D-B776-C2287F4BAD08" xml:space="preserve">// basicsqlexample.h

//

// Copyright (c) Nokia Ltd 2009. All rights reserved.

//

/**

@file

Contains the CBasicSqlExample class.

*/

#ifndef __BASICSQLEXAMPLE_H__

#define __BASICSQLEXAMPLE_H__

#include <e32base.h> 

/**

Demonstrates some uses of Symbian OS SQL component.

The class demonstrates how to 

- Create a database

- Populate a database

- Query a database

*/

class CBasicSqlExample: public CBase

    {

public:

    static CBasicSqlExample* NewLC();

    ~CBasicSqlExample();

    void ExampleL();

private:    // Utility/Basic Methods

    void DoExampleL();

    CBasicSqlExample();

    void ConstructL();

    void Prompt();

    void Prompt(const TDesC& aText);

private:    // Example Methods

    void OpenDatabaseL();

    void SqlQueryL(const TDesC& aStatement);

    void CloseDatabase();

    void DeleteDatabase();

    void CreateDatabaseL();

    void PopulateDatabaseL();

private:

    RSqlDatabase iPetDb;

    /** Pointer to the console interface */

    CConsoleBase* iConsole;

    };