c++操作mysql坎坷的旅程

1，windows下安装mysql，用mysql-installer，https://dev.mysql.com/downloads/windows/installer/5.6.html

2，安装

3，启动停止,打开管理员身份命令行

net start mysql
net stop mysql

4，进入mysql

mysql -h localhost -u root -p
提示输入
fk....(自己的密码)

5，新建一个Qt工程，Pro里面添加库：

INCLUDEPATH += "C:\Program Files\MySQL\MySQL Server 5.6\include" \
               "C:\Program Files\MySQL/MySQL Connector C++ 1.1.8\include"

LIBS+= -LE:/CameraGimbal/PCAppQT/Mysql/ -llibmysql

注意，斜杠还是反斜杠，只是用双引号加起来。-L后面没有空格，-l也没有，把libmysql.lib拷贝到工程目录下，把libmysql.dll拷贝到输出目录下

弹出报错：`SOCKET’ does not name a type error ，原因：http://webcache.googleusercontent.com/search?q=cache:http://www.technowise.in/2009/08/fixing-socket-does-not-name-type-error.html
解决：进入MySQL安装目录找到mysql.h，按照改host的方法修改他的权限，然后把64行的SOCKET改为int

报错：undefined reference to `_imp__get_driver_instance’
https://dev.mysql.com/doc/connector-cpp/en/connector-cpp-apps-windows-visual-studio.html这里官方对他做了处理。是在VS里，但是Qt怎么办？

估计是库没加对，处理了下，报错成了undefined reference to `get_driver_instance’
先放弃这种方案。

看到youtube上一个视频，Qt自带了sql的数据库例程，在qt安装路径下的example目录下，下面在MacBook pro上面运行qt的例子。
1，打开sql.pro报错：Project ERROR: Xcode not set up properly.
Google：http://stackoverflow.com/questions/33728905/qt-creator-project-error-xcode-not-set-up-properly-you-may-need-to-confirm-t

2，又报错：Could not resolve SDK path for ‘macosx10.8’
Google：http://stackoverflow.com/questions/26320677/error-could-not-resolve-sdk-path-for-macosx10-8
改为10.12

3,编译成功

4，实现本地化读写：
http://stackoverflow.com/questions/9259117/qt-and-databases-save-and-open-them

QT       += core sql widgets

QT       -= gui

TARGET = MyQtSqlDemo
CONFIG   += console
CONFIG   -= app_bundle

TEMPLATE = app


SOURCES += main.cpp

#include <QCoreApplication>
#include <QApplication>
#include <QMessageBox>
#include <QSqlDatabase>
#include <QSqlError>
#include <QSqlQuery>
#include <QtWidgets>
#include <QtSql>
#include <QDialog>
#include <QObject>
#include <QDebug>

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

    //QCoreApplication a(argc, argv);
    QApplication app(argc, argv);
    QWidget *window = new QWidget;
    QString fileName = "1.sqlite";
    //QString fileName = QFileDialog::getOpenFileName(window,QObject::tr("Open Database"), "/Users/kylefan/program", QObject::tr("SQLite Database Files (*.sqlite)"));

    QSqlDatabase db = QSqlDatabase::addDatabase("QSQLITE");
    db.setHostName("localhost");
    db.setDatabaseName(fileName);
    if (!db.open()) {
        QMessageBox::critical(0, qApp->tr("Cannot open database"),
            qApp->tr("Unable to establish a database connection.\n"
                     "This example needs SQLite support. Please read "
                     "the Qt SQL driver documentation for information how "
                     "to build it.\n\n"
                     "Click Cancel to exit."), QMessageBox::Cancel);
        return false;
    }
    qDebug()<<"connect ok!";

    QSqlQuery query;
    query.exec("create table person (id int primary key, firstname varchar(20), lastname varchar(20))");

//    query.exec("insert into person values(101, 'Danny', 'Young')");
//    query.exec("insert into person values(102, 'Christine', 'Holand')");
//    query.exec("insert into person values(103, 'Lars', 'Gordon')");
//    query.exec("insert into person values(104, 'Roberto', 'Robitaille')");
    query.exec("insert into person values(107, 'MMmm', 'DDdd')");

    QSqlTableModel *model;
    model = new QSqlTableModel();
    model->setTable("Person");
    model->setEditStrategy(QSqlTableModel::OnManualSubmit);
    model->select();

    model->setHeaderData(0, Qt::Horizontal, QObject::tr("ID"));
    model->setHeaderData(1, Qt::Horizontal, QObject::tr("First name"));
    model->setHeaderData(2, Qt::Horizontal, QObject::tr("Last name"));

    QTableView *view = new QTableView;
    view->setModel(model);
    view->resizeColumnsToContents();


    QHBoxLayout *mainLayout = new QHBoxLayout;
    mainLayout->addWidget(view);
    window->setLayout(mainLayout);
    window->show();

    return app.exec();
}

至此，实现C++操作mysql