SQL SERVER

#include <QtGui/QApplication>


#include<QtSql>
#include<QDebug>


int main(int argc, char *argv[])
{
    QApplication a(argc, argv);




    QString serverName="PC-20140620SGJT\\SQLEXPRESS";
    QString dbName="data2";


    QSqlDatabase  db=QSqlDatabase::addDatabase("QODBC");
    QString dsn=QString("Driver={SQL Server};Server=%1;Database=%2;Trusted_Connection=yes").arg(serverName).arg(dbName);
    db.setDatabaseName(dsn);
    if(db.open())
        qDebug()<<"connect to server successfully";
    else
        qDebug()<<"connect to server failed";


    QSqlQuery query;




    //新建表
    QString create_sql="create table table_4 (id int primary key,name varchar(30),age(int))";
    query.exec(create_sql);








    //查询最大num
    int max_id=0;
    QString select_max_sql="select max(num) from Table_2";
    query.exec(select_max_sql);
    while(query.next())
    {
        max_id = query.value(0).toInt();
        qDebug()<<QString("max id:%1").arg(max_id);


    }




    //插入数据


    QString insert_sql="insert into Table_1 values(?,?)";
    query.prepare(insert_sql);
    query.addBindValue("Qt");
    query.addBindValue(1);
    if(!query.exec())
        qDebug()<<query.lastError();
    else
        qDebug()<<"inserted";




    //更新数据
    QString update_sql="update Table_2 set name= :name where num= :num";
    query.prepare(update_sql);
    query.bindValue(":name","qt");
    query.bindValue(":num",15);
    query.exec();






    //查询部分数据
    QString select_sql="select name from Table_2";
    query.exec(select_sql);
    while(query.next())
    {
        QString name=query.value(0).toString().simplified();
        qDebug()<<name;


    }


    //查询所有数据
    QString select_all_sql="select * from Table_2";
    query.exec(select_all_sql);
    while(query.next())
    {
       int num=query.value(0).toInt();
       QString name=query.value(1).toString().simplified();
        qDebug()<<name<<"\t"<<num;


    }


    //删除数据
    QString delete_sql="delete from Table_2 where num=5";
    query.exec(delete_sql);




    //清空表
    QString clear_sql="delete from Table_4";
    query.exec(clear_sql);








    return a.exec();
}