Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

QtÊý¾Ý¿â£¨Èý£©ÀûÓÃQSqlQueryÀàÖ´ÐÐSQLÓï¾ä£¨Ò»£©


±¾ÎÄÕÂÔ­´´ÓÚwww.yafeilinux.com ×ªÔØÇë×¢Ã÷³ö´¦¡£
SQL¼´½á¹¹»¯²éѯÓïÑÔ£¬ÊǹØÏµÊý¾Ý¿âµÄ±ê×¼ÓïÑÔ¡£Ç°ÃæÒѾ­Ìáµ½£¬ÔÚQtÖÐÀûÓÃQSqlQueryÀàʵÏÖÁËÖ´ÐÐSQLÓï¾ä¡£ÐèҪ˵Ã÷£¬ÎÒÃÇÕâÀïÖ»ÊÇQt½Ì³Ì£¬¶ø·ÇרҵµÄÊý¾Ý¿â½Ì³Ì£¬ËùÒÔÎÒÃDz»»á¶ÔÊý¾Ý¿âÖеÄһЩ֪ʶ½øÐÐÉîÈë½²½â£¬ÏÂÃæÖ»ÊǶÔ×î³£Óõö֪ʶµã½øÐн²½â¡£
ÎÒÃÇÏÂÃæÏȽ¨Á¢Ò»¸ö¹¤³Ì£¬È»ºó½²½âËĸö֪ʶµã£¬·Ö±ðÊÇ£º
Ò»£¬²Ù×÷SQLÓï¾ä·µ»ØµÄ½á¹û¼¯¡£
¶þ£¬ÔÚSQLÓï¾äÖÐʹÓñäÁ¿¡£
Èý£¬Åú´¦Àí²Ù×÷¡£
ËÄ£¬ÊÂÎñ²Ù×÷¡£
ÎÒÃÇн¨Qt4 Gui Application¹¤³Ì£¬ÎÒÕâÀ﹤³ÌÃûΪquery £¬È»ºóÑ¡ÖÐQtSqlÄ£¿é£¬Base classÑ¡QWidget¡£¹¤³Ì½¨ºÃºó£¬Ìí¼ÓC++ Header File £¬ÃüÃûΪconnection.h £¬¸ü¸ÄÆäÄÚÈÝÈçÏ£º
#ifndef CONNECTION_H
#define CONNECTION_H
#include <QMessageBox>
#include <QSqlDatabase>
#include <QSqlQuery>
static bool createConnection()
{
    QSqlDatabase db = QSqlDatabase::addDatabase(“QSQLITE”);
    db.setDatabaseName(“:memory:”);
    if (!db.open()) {
        QMessageBox::critical(0, qApp->tr(“Cannot open database”),
            qApp->tr(“Unable to establish a database connection.”
                     ), QMessageBox::Cancel);
        return false;
    }
    QSqlQuery query;
    query.exec(“create table student (id int primary key, ”
               “name varchar(20))”);
    query.exec(“insert into student values(0, ‘first’)”);
    query.exec(“insert into student values(1, ’second’)”);
    query.exec(“insert into student values(2, ‘third’)”);
  &


Ïà¹ØÎĵµ£º

SqlÓï¾äѧϰ±Ê¼Ç(7) ³£ÓÃÈÕÆÚº¯Êý

/*****************************
³£ÓÃÈÕÆÚº¯Êý
*****************************/
use studentInfo
--ÏòÊý¾Ý¿âÖвåÈëÈÕÆÚµÄ³£¼û¸ñʽ£ºÈç²åÈë2010Äê10ÔÂ3ÈÕÕâ¸öÈÕÆÚ
--ÆäÖÐtb_dateΪһ¸ö²âÊÔÓÃµÄ±í£¬ÀïÃæ¾ÍÒ»¸ö×Ö¶Îtime£¬ÎªdatetimeÀàÐÍ
insert tb_date values('2010.10.3')
insert tb_date values('2010-10-3 12:14:35 ......

SQL Default Ô¼Êø£¡

´´½¨Ò»ÕÅ±í£¬Ö±½ÓÔÚ±íÁÐÉϰó¶¨Ä¬ÈÏÖµ
CREATE TABLE hello
(
Id_P int PRIMARY KEY,
Firstname varchar(50) DEFAULT 'Bush',
Lastname varchar(50) DEFAULT 'Green',
Address varchar(50) DEFAULT 'China',
City varchar(50) DEFAULT 'beijing'
)
²åÈëÒ»ÌõÐÅÏ¢
INSERT INTO hello(Id_P) values(01)
½á¹ûÊÇ
×ܽ ......

sql loader ʹÓÃ


sql loader¿ÉÒÔ°ÑһЩÒÔÎı¾¸ñʽ´æ·ÅµÄÊý¾Ý˳ÀûµÄµ¼Èëµ½oracleÊý¾Ý¿âÖУ¬ÊÇÒ»ÖÖÔÚ²»Í¬Êý¾Ý¿âÖ®¼ä½øÐÐÊý¾ÝÇ¨ÒÆµÄ·Ç³£·½±ã¶øÇÒͨÓõŤ¾ß¡£                            &n ......

SQL SERVER 2008 ±Ê¼ÇÖ®ÐÐѹËõºÍҳѹËõ

 
/*
    2008 ѹËõ
 
 
    ÐÐѹËõ
   
    SQL SERVER 2008 Òý½øÁËÐÐѹËõÕâ¸öÐÂÌØÐÔ,Ö»ÓÐÆóÒµ°æ¾ßÓиÃÐÂÌØÐÔ.ÐÐѹËõÖ»ÐèÒª×îµÍµÄ¿Õ¼ä¶ÔÐÐÊý¾Ý½øÐÐѹËõ.ÐÐѹËõ¿ÉÒÔÔÚCREATEÒ»¸ö±í,Ë÷Òý»òÕßALTERÒ»¸ö±í,Ë÷ÒýµÄʱºò½øÐд´½¨.ѹËõ¿ÉÒÔÔÚ ......

SQL SERVER 2008 ѹËõ±¸·Ý

/*
    SQL SERVER 2008 ѹËõ±¸·Ý
 
 
 
    SQL SERVER 2008 ÔÚÆóÒµ°æºÍ¿ª·¢°æÖÐÒýÈëÁ˱¸·ÝѹËõ.ʹÓÃÕ߸ö¹¦ÄÜ¿ÉÒÔ¸ü¿ìËٵı¸·ÝÊý¾Ý¿â²¢ÇÒ
    ÏûºÄ¸üÉٵĴÅÅ̿ռä.ѹËõÁ¿ÒÀÀµÓÚÊý¾Ý¿âÖд洢µÄÊý¾Ý.ÀýÈç,º¬ÓÐÖØ¸´Öµ×Ö·ûÊý¾ÝµÄÊý¾Ý¿â¿ÉÒÔÓÐ
   ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ