编译操作MySQL的程序时碰到 undefined reference to问题，该如何解决？

[weixin_38053856]

我用的是qt4.7.4，我是在WIN7下编译的静态的QT，之前MySQL驱动也编译好了，在静态编译前程序都能正常执行，但是静态编译总是弄不好，还在研究中。以下是qmake时碰到的问题。    是不是因为找不到lib和include？ pro文件的内容如下：TEMPLATE = appTARGET = DEPENDPATH += .INCLUDEPATH += .QT += sqlCONFIG += staticCONFIG(static) {       CONFIG += static       QTPLUGIN += qcncodecs     QTPLUGIN += qsqlmysql      DEFINES += STATIC     message("Static build.")}LIBS += D:\Qt\4.7.4\plugins\sqldrivers\libqsqlmysql.a# InputHEADERS += productviewerdialog.hFORMS += productviewer.uiSOURCES += main.cpp productviewerdialog.cpp d:\bookmis>qmake -projectd:\bookmis>qmake bookmis.proProject MESSAGE: Static build.WARNING: d:\bookmis\bookmis.pro:18: Unescaped backslashes are deprecated.Project MESSAGE: Static build.WARNING: d:\bookmis\bookmis.pro:18: Unescaped backslashes are deprecated.Project MESSAGE: Static build.WARNING: d:\bookmis\bookmis.pro:18: Unescaped backslashes are deprecated. d:\bookmis>makemingw32-make -f Makefile.Debugmingw32-make[1]: Entering directory `d:/bookmis'g++ -static -static-libgcc -enable-stdcall-fixup -Wl,-enable-auto-import -Wl,-enable-runtime-pseudo-reloc -mthreads -Wl,-subsystem,windows -o debug\bookmis.exedebug/main.o debug/productviewerdialog.o debug/moc_productviewerdialog.o  -L"d:\Qt\4.7.4\lib" -lmingw32 -lqtmaind D:\Qt\4.7.4\plugins\sqldrivers\libqsqlmysql.a-LD:/Qt/4.7.4/plugins/codecs -lqcncodecsd -LD:/Qt/4.7.4/plugins/sqldrivers -lqsqlmysqld -lQtSqld -lQtGuid -lgdi32 -lcomdlg32 -loleaut32 -limm32 -lwinmm -lwinspool -lmsimg32 -lQtCored -lole32 -luuid -lws2_32 -ladvapi32 -lshell32 -luser32 -lkernel32D:\Qt\4.7.4\plugins\sqldrivers\libqsqlmysql.a(qsql_mysql.o):qsql_mysql.cpp:(.text+0x463): undefined reference to `mysql_thread_end@0'D:\Qt\4.7.4\plugins\sqldrivers\libqsqlmysql.a(qsql_mysql.o):qsql_mysql.cpp:(.text+0x470): undefined reference to `mysql_close@4'D:\Qt\4.7.4\plugins\sqldrivers\libqsqlmysql.a(qsql_mysql.o):qsql_mysql.cpp:(.text+0x721): undefined reference to `mysql_stmt_insert_id@4'D:\Qt\4.7.4\plugins\sqldrivers\libqsqlmysql.a(qsql_mysql.o):qsql_mysql.cpp:(.text+0x759): undefined reference to `mysql_insert_id@4'D:\Qt\4.7.4\plugins\sqldrivers\libqsqlmysql.a(qsql_mysql.o):qsql_mysql.cpp:(.text+0x7b0): undefined reference to `mysql_num_rows@4'D:\Qt\4.7.4\plugins\sqldrivers\libqsqlmysql.a(qsql_mysql.o):qsql_mysql.cpp:(.text+0x7cf): undefined reference to `mysql_stmt_num_rows@4'D:\Qt\4.7.4\plugins\sqldrivers\libqsqlmysql.a(qsql_mysql.o):qsql_mysql.cpp:(.text+0x876): undefined reference to `mysql_num_rows@4'D:\Qt\4.7.4\plugins\sqldrivers\libqsqlmysql.a(qsql_mysql.o):qsql_mysql.cpp:(.text+0x8a3): undefined reference to `mysql_stmt_num_rows@4'D:\Qt\4.7.4\plugins\sqldrivers\libqsqlmysql.a(qsql_mysql.o):qsql_mysql.cpp:(.text+0xa5b): undefined reference to `mysql_num_fields@4'D:\Qt\4.7.4\plugins\sqldrivers\libqsqlmysql.a(qsql_mysql.o):qsql_mysql.cpp:(.text+0xb5a): undefined reference to `mysql_fetch_field@4'D:\Qt\4.7.4\plugins\sqldrivers\libqsqlmysql.a(qsql_mysql.o):qsql_mysql.cpp:(.text+0xbfd): undefined reference to `mysql_stmt_result_metadata@4'D:\Qt\4.7.4\plugins\sqldrivers\libqsqlmysql.a(qsql_mysql.o):qsql_mysql.cpp:(.text+0xc83): undefined reference to `mysql_character_set_name@4'D:\Qt\4.7.4\plugins\sqldrivers\libqsqlmysql.a(qsql_mysql.o):qsql_mysql.cpp:(.text+0xf56): undefined reference to `mysql_free_result@4'D:\Qt\4.7.4\plugins\sqldrivers\libqsqlmysql.a(qsql_mysql.o):qsql_mysql.cpp:(.text+0xf72): undefined reference to `mysql_next_result@4'D:\Qt\4.7.4\plugins\sqldrivers\libqsqlmysql.a(qsql_mysql.o):qsql_mysql.cpp:(.text+0xf8d): undefined reference to `mysql_stmt_close@4'D:\Qt\4.7.4\plugins\sqldrivers\libqsqlmysql.a(qsql_mysql.o):qsql_mysql.cpp:(.text+0xfaf): undefined reference to `mysql_free_result@4'D:\Qt\4.7.4\plugins\sqldrivers\libqsqlmysql.a(qsql_mysql.o):qsql_mysql.cpp:(.text+0x1103): undefined reference to `mysql_store_result@4'D:\Qt\4.7.4\plugins\sqldrivers\libqsqlmysql.a(qsql_mysql.o):qsql_mysql.cpp:(.text+0x147f): undefined reference to `mysql_errno@4'D:\Qt\4.7.4\plugins\sqldrivers\libqsqlmysql.a(qsql_mysql.o):qsql_mysql.cpp:(.text+0x1494): undefined reference to `mysql_field_seek@8'D:\Qt\4.7.4\plugins\sqldrivers\libqsqlmysql.a(qsql_mysql.o):qsql_mysql.cpp:(.text+0x149f): undefined reference to `mysql_fetch_field@4'D:\Qt\4.7.4\plugins\sqldrivers\libqsqlmysql.a(qsql_mysql.o):qsql_mysql.cpp:(.text+0x14dc): undefined reference to `mysql_fetch_field@4'D:\Qt\4.7.4\plugins\sqldrivers\libqsqlmysql.a(qsql_mysql.o):qsql_mysql.cpp:(.text+0x14f1): undefined reference to `mysql_field_seek@8'D:\Qt\4.7.4\plugins\sqldrivers\libqsqlmysql.a(qsql_mysql.o):qsql_mysql.cpp:(.text+0x1551): undefined reference to `mysql_error@4'D:\Qt\4.7.4\plugins\sqldrivers\libqsqlmysql.a(qsql_mysql.o):qsql_mysql.cpp:(.text+0x155f): undefined reference to `mysql_errno@4'D:\Qt\4.7.4\plugins\sqldrivers\libqsqlmysql.a(qsql_mysql.o):qsql_mysql.cpp:(.text+0x16a3): undefined reference to `mysql_stmt_error@4'D:\Qt\4.7.4\plugins\sqldrivers\libqsqlmysql.a(qsql_mysql.o):qsql_mysql.cpp:(.text+0x16af): undefined reference to `mysql_stmt_errno@4'D:\Qt\4.7.4\plugins\sqldrivers\libqsqlmysql.a(qsql_mysql.o):qsql_mysql.cpp:(.text+0x181d): undefined reference to `mysql_stmt_data_seek@12'D:\Qt\4.7.4\plugins\sqldrivers\libqsqlmysql.a(qsql_mysql.o):qsql_mysql.cpp:(.text+0x182e): undefined reference to `mysql_stmt_fetch@4'D:\Qt\4.7.4\plugins\sqldrivers\libqsqlmysql.a(qsql_mysql.o):qsql_mysql.cpp:(.text+0x18c8): undefined reference to `mysql_data_seek@12'D:\Qt\4.7.4\plugins\sqldrivers\libqsqlmysql.a(qsql_mysql.o):qsql_mysql.cpp:(.text+0x18d9): undefined reference to `mysql_fetch_row@4'D:\Qt\4.7.4\plugins\sqldrivers\libqsqlmysql.a(qsql_mysql.o):qsql_mysql.cpp:(.text+0x1a11): undefined reference to `mysql_list_fields@12'D:\Qt\4.7.4\plugins\sqldrivers\libqsqlmysql.a(qsql_mysql.o):qsql_mysql.cpp:(.text+0x1a5a): undefined reference to `mysql_fetch_field@4'D:\Qt\4.7.4\plugins\sqldrivers\libqsqlmysql.a(qsql_mysql.o):qsql_mysql.cpp:(.text+0x1a67): undefined reference to `mysql_free_result@4'D:\Qt\4.7.4\plugins\sqldrivers\libqsqlmysql.a(qsql_mysql.o):qsql_mysql.cpp:(.text+0x1c30): undefined reference to `mysql_next_result@4'D:\Qt\4.7.4\plugins\sqldrivers\libqsqlmysql.a(qsql_mysql.o):qsql_mysql.cpp:(.text+0x1cd6): undefined reference to `mysql_store_result@4'D:\Qt\4.7.4\plugins\sqldrivers\libqsqlmysql.a(qsql_mysql.o):qsql_mysql.cpp:(.text+0x1ced): undefined reference to `mysql_field_count@4'D:\Qt\4.7.4\plugins\sqldrivers\libqsqlmysql.a(qsql_mysql.o):qsql_mysql.cpp:(.text+0x1d3c): undefined reference to `mysql_affected_rows@4'D:\Qt\4.7.4\plugins\sqldrivers\libqsqlmysql.a(qsql_mysql.o):qsql_mysql.cpp:(.text+0x1d6a): undefined reference to `mysql_fetch_field_direct@8'D:\Qt\4.7.4\plugins\sqldrivers\libqsqlmysql.a(qsql_mysql.o):qsql_mysql.cpp:(.text+0x1df6): undefined reference to `mysql_free_result@4'D:\Qt\4.7.4\plugins\sqldrivers\libqsqlmysql.a(qsql_mysql.o):qsql_mysql.cpp:(.text+0x246d): undefined reference to `mysql_query@8'D:\Qt\4.7.4\plugins\sqldrivers\libqsqlmysql.a(qsql_mysql.o):qsql_mysql.cpp:(.text+0x256d): undefined reference to `mysql_query@8'D:\Qt\4.7.4\plugins\sqldrivers\libqsqlmysql.a(qsql_mysql.o):qsql_mysql.cpp:(.text+0x266d): undefined reference to `mysql_query@8'D:\Qt\4.7.4\plugins\sqldrivers\libqsqlmysql.a(qsql_mysql.o):qsql_mysql.cpp:(.text+0x27e5): undefined reference to `mysql_real_query@12'D:\Qt\4.7.4\plugins\sqldrivers\libqsqlmysql.a(qsql_mysql.o):qsql_mysql.cpp:(.text+0x2803): undefined reference to `mysql_store_result@4'D:\Qt\4.7.4\plugins\sqldrivers\libqsqlmysql.a(qsql_mysql.o):qsql_mysql.cpp:(.text+0x2825): undefined reference to `mysql_field_count@4'D:\Qt\4.7.4\plugins\sqldrivers\libqsqlmysql.a(qsql_mysql.o):qsql_mysql.cpp:(.text+0x2866): undefined reference to `mysql_affected_rows@4'D:\Qt\4.7.4\plugins\sqldrivers\libqsqlmysql.a(qsql_mysql.o):qsql_mysql.cpp:(.text+0x2892): undefined reference to `mysql_fetch_field_direct@8'D:\Qt\4.7.4\plugins\sqldrivers\libqsqlmysql.a(qsql_mysql.o):qsql_mysql.cpp:(.text+0x29d2): undefined reference to `mysql_field_count@4'D:\Qt\4.7.4\plugins\sqldrivers\libqsqlmysql.a(qsql_mysql.o):qsql_mysql.cpp:(.text+0x2b0e): undefined reference to `mysql_stmt_prepare@12'D:\Qt\4.7.4\plugins\sqldrivers\libqsqlmysql.a(qsql_mysql.o):qsql_mysql.cpp:(.text+0x2b27): undefined reference to `mysql_stmt_param_count@4'D:\Qt\4.7.4\plugins\sqldrivers\libqsqlmysql.a(qsql_mysql.o):qsql_mysql.cpp:(.text+0x2b3a): undefined reference to `mysql_stmt_param_count@4'D:\Qt\4.7.4\plugins\sqldrivers\libqsqlmysql.a(qsql_mysql.o):qsql_mysql.cpp:(.text+0x2c4a): undefined reference to `mysql_stmt_init@4'D:\Qt\4.7.4\plugins\sqldrivers\libqsqlmysql.a(qsql_mysql.o):qsql_mysql.cpp:(.text+0x2eff): undefined reference to `mysql_real_escape_string@16'D:\Qt\4.7.4\plugins\sqldrivers\libqsqlmysql.a(qsql_mysql.o):qsql_mysql.cpp:(.text+0x31ef): undefined reference to `mysql_fetch_lengths@4'D:\Qt\4.7.4\plugins\sqldrivers\libqsqlmysql.a(qsql_mysql.o):qsql_mysql.cpp:(.text+0x39e9): undefined reference to `mysql_stmt_reset@4'D:\Qt\4.7.4\plugins\sqldrivers\libqsqlmysql.a(qsql_mysql.o):qsql_mysql.cpp:(.text+0x3af9): undefined reference to `mysql_stmt_param_count@4'D:\Qt\4.7.4\plugins\sqldrivers\libqsqlmysql.a(qsql_mysql.o):qsql_mysql.cpp:(.text+0x3b13): undefined reference to `mysql_stmt_execute@4'D:\Qt\4.7.4\plugins\sqldrivers\libqsqlmysql.a(qsql_mysql.o):qsql_mysql.cpp:(.text+0x3b71): undefined reference to `mysql_stmt_affected_rows@4'D:\Qt\4.7.4\plugins\sqldrivers\libqsqlmysql.a(qsql_mysql.o):qsql_mysql.cpp:(.text+0x3ba4): undefined reference to `mysql_stmt_bind_result@8'D:\Qt\4.7.4\plugins\sqldrivers\libqsqlmysql.a(qsql_mysql.o):qsql_mysql.cpp:(.text+0x3bd5): undefined reference to `mysql_stmt_attr_set@12'D:\Qt\4.7.4\plugins\sqldrivers\libqsqlmysql.a(qsql_mysql.o):qsql_mysql.cpp:(.text+0x3be9): undefined reference to `mysql_stmt_store_result@4'D:\Qt\4.7.4\plugins\sqldrivers\libqsqlmysql.a(qsql_mysql.o):qsql_mysql.cpp:(.text+0x3c1e): undefined reference to `mysql_stmt_bind_result@8'D:\Qt\4.7.4\plugins\sqldrivers\libqsqlmysql.a(qsql_mysql.o):qsql_mysql.cpp:(.text+0x3d31): undefined reference to `mysql_stmt_param_count@4'D:\Qt\4.7.4\plugins\sqldrivers\libqsqlmysql.a(qsql_mysql.o):qsql_mysql.cpp:(.text+0x42e4): undefined reference to `mysql_stmt_bind_param@8'D:\Qt\4.7.4\plugins\sqldrivers\libqsqlmysql.a(qsql_mysql.o):qsql_mysql.cpp:(.text+0x45a3): undefined reference to `mysql_fetch_row@4'D:\Qt\4.7.4\plugins\sqldrivers\libqsqlmysql.a(qsql_mysql.o):qsql_mysql.cpp:(.text+0x45e3): undefined reference to `mysql_stmt_fetch@4'D:\Qt\4.7.4\plugins\sqldrivers\libqsqlmysql.a(qsql_mysql.o):qsql_mysql.cpp:(.text+0x46cb): undefined reference to `mysql_get_server_version@4'D:\Qt\4.7.4\plugins\sqldrivers\libqsqlmysql.a(qsql_mysql.o):qsql_mysql.cpp:(.text+0x4a0b): undefined reference to `mysql_list_tables@8'D:\Qt\4.7.4\plugins\sqldrivers\libqsqlmysql.a(qsql_mysql.o):qsql_mysql.cpp:(.text+0x4a35): undefined reference to `mysql_data_seek@12'D:\Qt\4.7.4\plugins\sqldrivers\libqsqlmysql.a(qsql_mysql.o):qsql_mysql.cpp:(.text+0x4a40): undefined reference to `mysql_fetch_row@4'D:\Qt\4.7.4\plugins\sqldrivers\libqsqlmysql.a(qsql_mysql.o):qsql_mysql.cpp:(.text+0x4afd): undefined reference to `mysql_free_result@4'D:\Qt\4.7.4\plugins\sqldrivers\libqsqlmysql.a(qsql_mysql.o):qsql_mysql.cpp:(.text+0x51d0): undefined reference to `mysql_init@4'D:\Qt\4.7.4\plugins\sqldrivers\libqsqlmysql.a(qsql_mysql.o):qsql_mysql.cpp:(.text+0x5348): undefined reference to `mysql_real_connect@32'D:\Qt\4.7.4\plugins\sqldrivers\libqsqlmysql.a(qsql_mysql.o):qsql_mysql.cpp:(.text+0x53ce): undefined reference to `mysql_set_character_set@8'D:\Qt\4.7.4\plugins\sqldrivers\libqsqlmysql.a(qsql_mysql.o):qsql_mysql.cpp:(.text+0x53e9): undefined reference to `mysql_get_client_version@0'D:\Qt\4.7.4\plugins\sqldrivers\libqsqlmysql.a(qsql_mysql.o):qsql_mysql.cpp:(.text+0x53fa): undefined reference to `mysql_thread_init@0'D:\Qt\4.7.4\plugins\sqldrivers\libqsqlmysql.a(qsql_mysql.o):qsql_mysql.cpp:(.text+0x5469): undefined reference to `mysql_get_server_version@4'D:\Qt\4.7.4\plugins\sqldrivers\libqsqlmysql.a(qsql_mysql.o):qsql_mysql.cpp:(.text+0x549b): undefined reference to `mysql_options@12'D:\Qt\4.7.4\plugins\sqldrivers\libqsqlmysql.a(qsql_mysql.o):qsql_mysql.cpp:(.text+0x5567): undefined reference to `mysql_close@4'D:\Qt\4.7.4\plugins\sqldrivers\libqsqlmysql.a(qsql_mysql.o):qsql_mysql.cpp:(.text+0x5698): undefined reference to `mysql_select_db@8'D:\Qt\4.7.4\plugins\sqldrivers\libqsqlmysql.a(qsql_mysql.o):qsql_mysql.cpp:(.text+0x57e1): undefined reference to `mysql_close@4'collect2: ld returned 1 exit statusmingw32-make[1]: *** [debug\bookmis.exe] Error 1mingw32-make[1]: Leaving directory `d:/bookmis'mingw32-make: *** [debug] Error 2 d:\bookmis>