hello.cpp

Qtopia链接Sqlite3数据库 Qtopia 2.2.0 Sqlite3

/**********************************************************************
** Copyright (C) 2000-2005 Trolltech AS.  All rights reserved.
**
** This file is part of the Qtopia Environment.
** 
** This program is free software; you can redistribute it and/or modify it
** under the terms of the GNU General Public License as published by the
** Free Software Foundation; either version 2 of the License, or (at your
** option) any later version.
** 
** A copy of the GNU GPL license version 2 is included in this package as 
** LICENSE.GPL.
**
** This program is distributed in the hope that it will be useful, but
** WITHOUT ANY WARRANTY; without even the implied warranty of
** MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. 
** See the GNU General Public License for more details.
**
** In addition, as a special exception Trolltech gives permission to link
** the code of this program with Qtopia applications copyrighted, developed
** and distributed by Trolltech under the terms of the Qtopia Personal Use
** License Agreement. You must comply with the GNU General Public License
** in all respects for all of the code used other than the applications
** licensed under the Qtopia Personal Use License Agreement. If you modify
** this file, you may extend this exception to your version of the file,
** but you are not obligated to do so. If you do not wish to do so, delete
** this exception statement from your version.
** 
** See http://www.trolltech.com/gpl/ for GPL licensing information.
**
** Contact [e-mail] if any conditions of this licensing are
** not clear to you.
**
**********************************************************************/

#include "hello.h"
#include <qpushbutton.h>
#include <qcombobox.h>
#include <qlineedit.h>
#include <stdio.h>
extern "C"
{
#include </usr/local/include/sqlite3.h>
};
#include <qmessagebox.h>
/* 
 *  Constructs a Example which is a child of 'parent', with the 
 *  name 'name' and widget flags set to 'f' 
 */

Hello::Hello( QWidget* parent,  const char* name, WFlags fl )
    : HelloBase( parent, name, fl )
{
    connect(ok, SIGNAL(clicked()), this, SLOT(CreateJbxxForm()));
}

/*  
 *  Destroys the object and frees any allocated resources
 */
Hello::~Hello()
{
    // no need to delete child widgets, Qt does it all for us
}

/*
 *  A simple slot... not very interesting.
 */
void Hello::CreateJbxxForm()
{
//close();
	sqlite3 *db;
  	int rc;
  	char * errMsg = NULL;
  	rc = sqlite3_open("/home/guo/test.db", &db);
  	if( rc ){
    		QMessageBox::critical(0,tr("open database"),tr("ok"),QMessageBox::Cancel,QMessageBox::NoButton);
    		sqlite3_close(db);    		
  	}
	rc = sqlite3_exec(db, "CREATE TABLE chn_to_eng(chinese QString, english QString)", 0, 0, &errMsg);
	
	if(rc == SQLITE_OK)
	{
    		QMessageBox::critical(0,tr("Create table successful!"),tr("ok"),QMessageBox::Cancel,QMessageBox::NoButton);
    		 		
  	}
sqlite3_close(db);   

/*	QSqlDatabase *db=QSqlDatabase::addDatabase("QSQLITE");
	db->setDatabaseName("/home/guo/test.db");
	if(db->open())
	{
		QMessageBox::critical(0,tr("open database"),tr("ok"),QMessageBox::Cancel,QMessageBox::NoButton);
	}

   Jbxx* xx = new Jbxx(this,0,0);
   QSize s;
   s.setWidth(240);
   s.setHeight(320);
   xx->resize(s);
   xx->le_Jjss->setText(ComboBox1->currentText());
   xx->show();*/
}