• qt实现sqlite数据库文件与csv文件相互转换

    一、使用场景

            假设一：目前有一个项目记录数据是采用sqlite文件存储的，数据量很大，里面的记录数据客户需要将其导入到execl中进行报表编辑及汇报工作；

            假设二：用户手里有点表配置表格，需要导入到工程的sqlite配置文件中给应用程序使用，配量很大。

    二、实现设计

            在sqlite数据库文件读写方面，基于QT插件库提供的QSQLiteDriverPlugin实现数据库打开、读写、查询等操作。

            

    1. bool executeSQL(QSqlDatabase db,QString _sql)
    2. {
    3. 	QSqlQuery query(db);
    4.     return query.exec(_sql);
    5. };
    6.  
    7. bool checkTable(QSqlDatabase db, QString _table)
    8. {
    9.     QString _sql = QString("select count(*) from sqlite_master where type='table' and name='%1'").arg(_table);
    10.     QSqlQuery query(db);
    11.     query.exec(_sql);
    12.     bool _existTable = true;
    13.     if (query.next())
    14.     {
    15.         int _countTable = query.value(0).toInt();
    16.         if (1!=_countTable)
    17.         {
    18.             _existTable = false;
    19.         }
    20.     }else{
    21.         _existTable = false;
    22.     }
    23.     return _existTable;
    24. };
    25.  
    26. bool opendb(QSqlDatabase &db, QString _dbn,QString _dbLink)
    27. {
    28.     QString dbv = "QSQLITE";
    29.     // QString _dbLink = "db_sqlite_record";
    30.     if (QSqlDatabase::contains(_dbLink))
    31.     {
    32. 		db = QSqlDatabase::database(_dbLink);
    33.     }else{
    34.     	db = QSqlDatabase::addDatabase(dbv,_dbLink);
    35.     }
    36. 	// checkDBLink(_dbLink);
    37. 	// db = QSqlDatabase::addDatabase(dbv,_dbLink);
    38.     db.setDatabaseName(_dbn);
    39.  
    40.     if (db.open())
    41.     {
    42.         return true;
    43.     }else{
    44.         qDebug() << "open db failed!"<< "---"<< db.lastError().text()<<" \n";
    45.         return false;
    46.     }
    47. };
    48.  
    49. bool checkdb_etconf(QSqlDatabase &db, QString _dbn)
    50. {
    51. 	if (!opendb(db,_dbn,"db_sqlite_etconf"))
    52. 	{
    53. 		return false;
    54. 	}else{
    55. 		if(!executeSQL(db,"PRAGMA synchronous = OFF"))
    56. 		{
    57. 			qDebug() << db.lastError() << "\n";
    58. 		}
    59. 	}
    60.     //注意，这里进行表过滤，只获取我们需要的表格
    61. 	if(!checkTable(db,"s101yc"))
    62. 	{
    63. 		return false;
    64. 	}
    65. 	if(!checkTable(db,"s101yx"))
    66. 	{
    67. 		return false;
    68. 	}
    69. 	if(!checkTable(db,"s101yk"))
    70. 	{
    71. 		return false;
    72. 	}
    73. 	if(!checkTable(db,"s101yt"))
    74. 	{
    75. 		return false;
    76. 	}
    77. 	return true;
    78. };

            在针对csv（XLS 工作表）的文件读写方面，是基于QFile实现的FileQt类封装实现csv文件的有序读取、写入等操作。同时支持直接的.xls文件操作.

    1. //QString _div为csv文件中每行的分割符，QVector > &_lists为读取的数据信息，采用二元数组存储行、列数据
    2. bool readToVector(QString _file,QVector > &_lists, QString _div)
    3. {
    4. 	QFile file(_file);
    5.     if (!file.open(QFile::ReadOnly)) {
    6.     	qDebug() << "conn't open file  " << _file << "!\n";
    7.         return false;
    8.     }else{
    9.         QTextStream stream( &file );
    10.         QString line;
    11.         while ( !stream.atEnd() ) {
    12.             line = stream.readLine();
    13.             QStringList _strL = line.split(QRegExp(_div));
    14.             // QStringList _strL = line.split(QRegExp(_div),QString::SkipEmptyParts);
    15.             QVector _onev;
    16.             for (int i = 0; i < _strL.size(); i++)
    17.             {
    18.             	_onev.push_back(_strL[i]);
    19.             }
    20.             _lists.push_back(_onev);
    21.         }
    22.         file.close();
    23.  
    24.         if (_lists.empty())
    25.     	{
    26.     		return false;
    27.     	}else{
    28.     		return true;
    29.     	}
    30.     }
    31. }
    32.  
    33. bool writeListInfo(QVector list,const QString path,bool appendf)
    34. {
    35.     QFile f(path);
    36.     if(!f.open(QFile::WriteOnly | QFile::Text | (appendf?QFile::Append:QFile::Truncate)))
    37.         return false;
    38.  
    39.     QTextStream out(&f);
    40.  
    41.     // out.setCodec("UTF-8"); //中文编码
    42.     for (int i = 0; i < list.size(); i++)
    43.     {
    44.         out << QString(list[i]);
    45.     }
    46.     f.close();
    47.     return true;
    48. };
    49.  
    50. /*
    51. *这类函数的意义主要是csv文件里面只有数据，转存到sqlite数据文件中，需要构建表格，就是需要指定表格
    52. *的表名、列名，表名采用csv文件名来表示，列名需要额外指定，本文直接硬代码实现，当然也可以在csv文件
    53. *里面的第一列增加列名，在程序处理时先读取第一列，进行列名命名，在进行转换导入。
    54. */
    55. void inYx(QSqlDatabase &db,QString _path)
    56. {
    57. 	QVector > _lists;
    58. 	readToVector(_path,_lists,",");
    59.  
    60. 	QSqlQuery query(db);
    61. 	query.exec("DELETE FROM s101yx");
    62.  
    63. 	QVariantList indexids;
    64. 	QVariantList devids;
    65. 	QVariantList names;
    66. 	QVariantList localaddrs;
    67. 	QVariantList nots;
    68. 	QVariantList sampdevids;
    69. 	QVariantList sampaddrs;
    70. 	QVariantList nametomsts;
    71.  
    72. 	int _count = 0;
    73. 	QString _sql = "INSERT INTO s101yx (INDEXID,DEVID,NAME,LOCALADDR,\"NOT\",SAMPDEVID,SAMPADDR,NAMETOMST) "
    74. 			       "VALUES (?,?,?,?,?,?,?,?)";
    75.  
    76. 	for (int i = 0; i < _lists.size(); i++)
    77. 	{
    78. 		if (8!=_lists[i].size())
    79. 		{
    80. 			continue;
    81. 		}
    82. 		indexids << _lists[i][0].toInt();
    83. 		devids << _lists[i][1].toInt();
    84. 		names << _lists[i][2];
    85. 		// names << QString("%1").arg(_lists[i][2].toAscii().data());
    86. 		localaddrs << _lists[i][3].toInt();
    87. 		nots << _lists[i][4].toInt();
    88. 		sampdevids << _lists[i][5].toInt();
    89. 		sampaddrs << _lists[i][6].toInt();
    90. 		nametomsts << _lists[i][7];
    91. 		// nametomsts << QString("%1").arg(_lists[i][7].toAscii().data());
    92.  
    93. 		_count+=1;
    94. 		if (_count>=200||(i==(_lists.size()-1)))
    95. 		{
    96. 			try{
    97. 				query.prepare(_sql);
    98. 				query.addBindValue(indexids);
    99. 				query.addBindValue(devids);
    100. 				query.addBindValue(names);
    101. 				query.addBindValue(localaddrs);
    102. 				query.addBindValue(nots);
    103. 				query.addBindValue(sampdevids);
    104. 				query.addBindValue(sampaddrs);
    105. 				query.addBindValue(nametomsts);
    106.  
    107. 				if (!query.execBatch())
    108. 				{
    109. 					qDebug() << query.lastError();
    110. 				}
    111. 			}catch(...){
    112. 				qDebug() << query.lastError();
    113. 			}
    114. 			indexids.clear();
    115. 		    devids.clear();
    116. 		    names.clear();
    117. 		    localaddrs.clear();
    118. 		    nots.clear();
    119. 		    sampdevids.clear();
    120. 		    sampaddrs.clear();
    121. 		    nametomsts.clear();
    122.  
    123. 		    _count = 0;
    124. 		}
    125. 	}
    126. };
    127. ...

            提供一个简要对话框设置数据库文件路径及csv文件路径，提供转换选择按钮实现文件数据转换输出。

    1. void InOrOutConf::DBToCsv()
    2. {
    3. 	QString _dbn = this->pathEdit->text();
    4. 	QFile _file(_dbn);
    5. 	if (!_file.exists())
    6. 	{
    7. 		warLabel->setText("db isn't exist!");
    8. 		return;
    9. 	}
    10. 	// s101yc * ycs = new s101yc[10];
    11. 	// int ret = GetS101yc(_dbn.toStdString().c_str(),"",ycs,10);
    12. 	// if(ret>0){
    13. 	// 	for (int i = 0; i < ret; i++)
    14. 	// 	{
    15. 	// 		qDebug() <<  QString("%1").arg(ycs[i].NAME)<<"\n";
    16. 	// 		qDebug() <<  QString("%1").arg(G2U(ycs[i].NAME))<<"\n";
    17. 	// 		qDebug() <<  QString("%1").arg(U2G(ycs[i].NAME))<<"\n";
    18. 	// 		qDebug() <<  QString("%1").arg(ASCII2UTF_8(std::string(ycs[i].NAME)).c_str())<<"\n";
    19. 	// 		qDebug() <<  QString("%1").arg(UTF_82ASCII(std::string(ycs[i].NAME)).c_str())<<"\n";
    20. 	// 	}
    21. 	// }
    22.  
    23. 	QSqlDatabase db;
    24. 	if(!checkdb_etconf(db,_dbn))
    25. 	{
    26. 		warLabel->setText("db isn't table we need!");
    27. 		return;
    28. 	}
    29. 	warLabel->setText("db to csv runing!");
    30.     //这里本应通过读取表名（或配置实现）+路径来命名csv文件路径的，本案例测试时，强行指定文件名
    31. 	outYc(db,this->dirEdit->text()+divPath+"s101yc.csv");
    32. 	outYx(db,this->dirEdit->text()+divPath+"s101yx.csv");
    33. 	outYk(db,this->dirEdit->text()+divPath+"s101yk.csv");
    34. 	outYt(db,this->dirEdit->text()+divPath+"s101yt.csv");
    35. 	warLabel->setText("db to csv finish!");
    36. 	db.close();
    37. };
    38.  
    39. void InOrOutConf::scvToDB()
    40. {
    41. 	QString _dbn = this->pathEdit->text();
    42. 	QFile _file(_dbn);
    43. 	if (!_file.exists())
    44. 	{
    45. 		warLabel->setText("db isn't exist!");
    46. 		return;
    47. 	}
    48.  
    49. 	QSqlDatabase db;
    50. 	if(!checkdb_etconf(db,_dbn))
    51. 	{
    52. 		warLabel->setText("db isn't table we need!");
    53. 		return;
    54. 	}
    55. 	warLabel->setText("csv to db runing!");
    56.     //这里本应通过配置定义+路径来读取csv文件，本案例测试时，强行指定文件名
    57. 	inYc(db,this->dirEdit->text()+divPath+"s101yc.csv");
    58. 	inYx(db,this->dirEdit->text()+divPath+"s101yx.csv");
    59. 	inYk(db,this->dirEdit->text()+divPath+"s101yk.csv");
    60. 	inYt(db,this->dirEdit->text()+divPath+"s101yt.csv");
    61. 	warLabel->setText("csv to db finish!");
    62. 	db.close();
    63. };

      三、工程实现

            本文采用qt5.8来实现的，并对该版本进行了静态编译,win系统是win10-64bit，linux系统是centos7-64bit系统,同时静态编译了plugins\\sqldrivers插件。

            整个工程目录结构如下：

    1. sqlite_and_csv_trans
    2.     bin
    3.     file
    4.         FileQt.h
    5.         FileQt.cpp
    6.         myfiledialog.h
    7.         myfiledialog.cpp
    8.         strcode.hpp
    9.         strcode.cpp
    10.     languages
    11.         dbInOrOut_cn.qm
    12.         dbInOrOut_cn.ts
    13.     view
    14.         inOrOutConf.h
    15.         inOrOutConf.cpp
    16.     dbInOrOut.qrc
    17.     dbIntOrOut.pro
    18.     main.cpp

     dbIntOrOut.pro:

    1. QT      += core
    2. QT      += gui
    3. QT      += sql
    4.  
    5. greaterThan(QT_MAJOR_VERSION, 4) {
    6.     QT += printsupport
    7.     QT += concurrent
    8.     QT += widgets
    9. }
    10.  
    11. TEMPLATE = app
    12. DESTDIR = bin
    13.  
    14. CONFIG += qt warn_on debug_and_release
    15. CONFIG += static
    16.  
    17. CONFIG(debug, debug|release) {
    18.     TARGET          = dbInOrOutd
    19.     OBJECTS_DIR     = debug/obj
    20.     MOC_DIR         = debug/moc
    21.     CONFIG          += console
    22.     DEFINES         += _DEBUG
    23. }else{
    24.     TARGET          = dbInOrOut
    25.     OBJECTS_DIR     = release/obj
    26.     MOC_DIR         = release/moc
    27.     DEFINES         += NODEBUG
    28. }
    29.  
    30. DEFINES +=  QTWIN_32 \
    31.         QT_CORE_LIB \
    32.         QT_GUI_LIB \
    33.         QT_SQL_LIB \
    34.         QT_THREAD_SUPPORT
    35. #请指定qt的sqlite插件路径
    36. QT_SQL = D:\\workForSoftware\\Qt\\Qt5.8.0\\5.8\\msvc2015_64_static\\plugins\\sqldrivers
    37.  
    38. win32{
    39.     CONFIG(debug, debug|release) {
    40.         LIBS             += $$(QT_SQL)\\qsqlited.lib
    41.     } else {
    42.         LIBS             += $$(QT_SQL)\\qsqlite.lib
    43.     }
    44. }
    45. HEADERS  += view/inOrOutConf.h \
    46. 		file/myfiledialog.h \
    47. 		file/strcode.hpp \
    48.  
    49.  
    50. SOURCES += main.cpp\
    51.     view/inOrOutConf.cpp \
    52.     file/myfiledialog.cpp \
    53.     file/strcode.cpp \
    54.  
    55.  
    56. TRANSLATIONS += languages/dbInOrOut_cn.ts
    57. RESOURCES += dbInOrOut.qrc

    dbInOrOut.qrc

    1. "1.0">
    2.     "/">
    3.         languages/dbInOrOut_cn.qm
    4.

    strcode.hpp，实现字符编码转换

    1. #if _MSC_VER > 1000
    2. #pragma once
    3. #endif // _MSC_VER > 1000
    4.  
    5. #ifndef STRCODE_HPP
    6. #define STRCODE_HPP
    7.  
    8. #include 
    9. #ifdef WIN32
    10. #include 
    11. #endif
    12.  
    13. #ifdef __linux__
    14. int code_convert(char *from_charset,char *to_charset,char *inbuf,size_t inlen,char *outbuf,size_t outlen);
    15. int u2g(char *inbuf,int inlen,char *outbuf,int outlen);
    16. int g2u(char *inbuf,size_t inlen,char *outbuf,size_t outlen);
    17. int u2a(char *inbuf,int inlen,char *outbuf,int outlen);
    18. int a2u(char *inbuf,int inlen,char *outbuf,int outlen);
    19. #endif
    20.  
    21. #ifdef WIN32
    22. std::wstring Utf82Unicode(const std::string& utf8string);
    23. std::string WideByte2Acsi(std::wstring& wstrcode);
    24. std::wstring Acsi2WideByte(std::string& strascii);
    25. std::string Unicode2Utf8(const std::wstring& widestring);
    26. #endif
    27. bool UnicodeToAnsi(wchar_t* lpString,char* szAnsi);//(in,out)
    28. bool AnsiToUnicode(char* lpString,wchar_t* szUnicode);//(in,out) 
    29. char* U2G(const char* utf8);
    30. char* G2U(const char* gb2312);
    31.  
    32. std::string UTF_82ASCII(std::string &strUtf8Code);
    33. std::string ASCII2UTF_8(std::string& strAsciiCode);
    34. //using namespace std;
    35. bool containStr(std::string _str, std::string _strsub);
    36.  
    37. int enc_unicode_to_utf8_one(unsigned long unic, unsigned char *pOutput, int outSize);
    38. // int enc_utf8_to_unicode_one(const unsigned char* pInput, unsigned long *Unic);
    39. //
    40. /*
    41. std::string ws2s(const std::wstring& ws);
    42. std::wstring s2ws(const std::string& s);
    43. std::wstring UTF2Uni(const char* src, std::wstring &t);
    44. int Uni2UTF( const std::wstring& strRes, char *utf8, int nMaxSize );
    45. std::string s2utfs(const  std::string&  strSrc);
    46. std::string  utfs2s(const std::string& strutf);
    47. */
    48.  
    49. #endif //STRCODE_HPP

    strcode.cpp

    1. #include "strcode.hpp"
    2.  
    3. #include 
    4. #include 
    5. #include 
    6. #include 
    7. #include 
    8. #include 
    9. #include 
    10.  
    11. #ifdef __linux__
    12. #include  
    13. #endif
    14.  
    15. #ifdef __linux__
    16. //代码转换:从一种编码转为另一种编码 
    17. int code_convert(char *from_charset,char *to_charset,char *inbuf,size_t inlen,char *outbuf,size_t outlen) 
    18. { 
    19.     iconv_t cd; 
    20.     int rc; 
    21.     char **pin = &inbuf; 
    22.     char **pout = &outbuf; 
    23.  
    24.     cd = iconv_open(to_charset,from_charset); 
    25.     if (cd==0) return -1; 
    26.     memset(outbuf,0,outlen); 
    27.     if (iconv(cd,pin,&inlen,pout,&outlen)==-1) return -1; 
    28.     iconv_close(cd); 
    29.     return 0; 
    30. } 
    31. //UNICODE码转为GB2312码 
    32. int u2g(char *inbuf,int inlen,char *outbuf,int outlen) 
    33. { 
    34.     return code_convert("utf-8","gb2312",inbuf,inlen,outbuf,outlen); 
    35. } 
    36. //GB2312码转为UNICODE码 
    37. int g2u(char *inbuf,size_t inlen,char *outbuf,size_t outlen) 
    38. { 
    39.     return code_convert("gb2312","utf-8",inbuf,inlen,outbuf,outlen); 
    40. } 
    41.  
    42. int u2a(char *inbuf,int inlen,char *outbuf,int outlen)
    43. {
    44.     return code_convert("utf-8","ascii",inbuf,inlen,outbuf,outlen); 
    45. }
    46.  
    47. int a2u(char *inbuf,int inlen,char *outbuf,int outlen)
    48. {
    49.     return code_convert("ascii","utf-8",inbuf,inlen,outbuf,outlen); 
    50. }
    51.  
    52. #endif
    53.  
    54. #ifdef WIN32
    55. //UTF-8¡ÁaUnicode
    56. std::wstring Utf82Unicode(const std::string& utf8string)
    57. {
    58. 	int widesize = ::MultiByteToWideChar(CP_UTF8, 0, utf8string.c_str(), -1, NULL, 0);
    59. 	if (widesize == ERROR_NO_UNICODE_TRANSLATION)
    60. 	{
    61. 		throw std::exception("Invalid UTF-8 sequence.");
    62. 	}
    63. 	if (widesize == 0)
    64. 	{
    65. 		throw std::exception("Error in conversion.");
    66. 	}
    67.  
    68. 	std::vector<wchar_t> resultstring(widesize);
    69.  
    70. 	int convresult = ::MultiByteToWideChar(CP_UTF8, 0, utf8string.c_str(), -1, &resultstring[0], widesize);
    71.  
    72. 	if (convresult != widesize)
    73. 	{
    74. 		throw std::exception("La falla!");
    75. 	}
    76.  
    77. 	return std::wstring(&resultstring[0]);
    78. };
    79.  
    80. //unicode ¡Áa?a ascii
    81.  
    82. std::string WideByte2Acsi(std::wstring& wstrcode)
    83. {
    84. 	int asciisize = ::WideCharToMultiByte(CP_OEMCP, 0, wstrcode.c_str(), -1, NULL, 0, NULL, NULL);
    85. 	if (asciisize == ERROR_NO_UNICODE_TRANSLATION)
    86. 	{
    87. 		throw std::exception("Invalid UTF-8 sequence.");
    88. 	}
    89. 	if (asciisize == 0)
    90. 	{
    91. 		throw std::exception("Error in conversion.");
    92. 	}
    93. 	std::vector<char> resultstring(asciisize);
    94. 	int convresult =::WideCharToMultiByte(CP_OEMCP, 0, wstrcode.c_str(), -1, &resultstring[0], asciisize, NULL, NULL);
    95.  
    96. 	if (convresult != asciisize)
    97. 	{
    98. 		throw std::exception("La falla!");
    99. 	}
    100.  
    101. 	return std::string(&resultstring[0]);
    102. };
    103. ///
    104.  
    105. //ascii ¡Áa Unicode
    106.  
    107. std::wstring Acsi2WideByte(std::string& strascii)
    108. {
    109. 	int widesize = MultiByteToWideChar (CP_ACP, 0, (char*)strascii.c_str(), -1, NULL, 0);
    110. 	if (widesize == ERROR_NO_UNICODE_TRANSLATION)
    111. 	{
    112. 		throw std::exception("Invalid UTF-8 sequence.");
    113. 	}
    114. 	if (widesize == 0)
    115. 	{
    116. 		throw std::exception("Error in conversion.");
    117. 	}
    118. 	std::vector<wchar_t> resultstring(widesize);
    119. 	int convresult = MultiByteToWideChar (CP_ACP, 0, (char*)strascii.c_str(), -1, &resultstring[0], widesize);
    120.  
    121. 	if (convresult != widesize)
    122. 	{
    123. 		throw std::exception("La falla!");
    124. 	}
    125.  
    126. 	return std::wstring(&resultstring[0]);
    127. };
    128.  
    129. //Unicode ¡Áa Utf8
    130.  
    131. std::string Unicode2Utf8(const std::wstring& widestring)
    132. {
    133. 	int utf8size = ::WideCharToMultiByte(CP_UTF8, 0, widestring.c_str(), -1, NULL, 0, NULL, NULL);
    134. 	if (utf8size == 0)
    135. 	{
    136. 		throw std::exception("Error in conversion.");
    137. 	}
    138.  
    139. 	std::vector<char> resultstring(utf8size);
    140.  
    141. 	int convresult = ::WideCharToMultiByte(CP_UTF8, 0, widestring.c_str(), -1, &resultstring[0], utf8size, NULL, NULL);
    142.  
    143. 	if (convresult != utf8size)
    144. 	{
    145. 		throw std::exception("La falla!");
    146. 	}
    147.  
    148. 	return std::string(&resultstring[0]);
    149. };
    150. #endif
    151.  
    152. //mbstowcs()函数和wcstombs()函数，选自CRT库。平台无关，但需设定local。不设定Local,中文会乱码
    153. bool UnicodeToAnsi(wchar_t* lpString,char* szAnsi)//(in,out)
    154. {
    155. 	size_t nLen=wcslen(lpString)*2;//wcslen  
    156. 	char* lpszBuf=(char*)malloc(nLen);//malloc  and  
    157. 	setlocale(LC_ALL,"");
    158. 	size_t nRet=wcstombs(lpszBuf,lpString,nLen);//wcstombs  
    159. 	if(nRet<0)
    160. 	{
    161. 		free(lpszBuf);
    162. 		return false;
    163. 	}
    164. 	strcpy(szAnsi,lpszBuf);
    165. 	return true;
    166. };
    167.  
    168. bool AnsiToUnicode(char* lpString,wchar_t* szUnicode)//(in,out) 
    169. {
    170. 	size_t nLen=strlen(lpString);
    171. 	wchar_t* lpszBuf=(wchar_t*)malloc(nLen);//malloc  and 
    172. 	setlocale(LC_ALL,"");
    173. 	size_t nRet = mbstowcs(lpszBuf, lpString, nLen);
    174. 	if(nRet<0)
    175. 	{
    176. 		free(lpszBuf);
    177. 		return false;
    178. 	}
    179. 	wcscpy(szUnicode,lpszBuf);
    180. 	return true;
    181. };
    182.  
    183. //UTF-8到GB2312的转换
    184. char* U2G(const char* utf8){
    185.     static char szRet[1024];
    186.     memset( szRet, 0x00, 1024);
    187.     int len = MultiByteToWideChar(CP_UTF8, 0, utf8, -1, NULL, 0);
    188.     wchar_t* wstr = new wchar_t[len+1];
    189.     memset(wstr, 0, len+1);
    190.     MultiByteToWideChar(CP_UTF8, 0, utf8, -1, wstr, len);
    191.     len = WideCharToMultiByte(CP_ACP, 0, wstr, -1, NULL, 0, NULL, NULL);
    192.     WideCharToMultiByte(CP_ACP, 0, wstr, -1, szRet, len, NULL, NULL);
    193.     if(wstr) delete[] wstr;
    194.     return szRet;
    195. };
    196.  
    197. //GB2312到UTF-8的转换
    198. char* G2U(const char* gb2312){
    199.     static char szRet[1024];
    200.     memset( szRet,0x00,1024 );
    201.     int len = MultiByteToWideChar(CP_ACP, 0, gb2312, -1, NULL, 0);
    202.     wchar_t* wstr = new wchar_t[len+1];
    203.     memset(wstr, 0, len+1);
    204.     MultiByteToWideChar(CP_ACP, 0, gb2312, -1, wstr, len);
    205.     len = WideCharToMultiByte(CP_UTF8, 0, wstr, -1, NULL, 0, NULL, NULL);
    206.     WideCharToMultiByte(CP_UTF8, 0, wstr, -1, szRet, len, NULL, NULL);
    207.     if(wstr) delete[] wstr;
    208.     return szRet;
    209. };
    210.  
    211. std::string UTF_82ASCII(std::string &strUtf8Code)
    212. {
    213. 	#ifdef WIN32
    214. 	std::string strRet("");
    215. 	//?¨¨¡ã? utf8 ¡Áa?a unicode 
    216. 	std::wstring wstr = Utf82Unicode(strUtf8Code);
    217.  
    218. 	//¡Á?o¨®¡ã? unicode ¡Áa?a ascii
    219. 	strRet = WideByte2Acsi(wstr);
    220. 	return strRet;
    221. 	#endif
    222. 	#ifdef linux
    223.     char lpszBuf[256]={0};
    224.     u2a(const_cast<char*>(strUtf8Code.c_str()),strUtf8Code.size(),lpszBuf,256);
    225. 	return std::string(lpszBuf);
    226. 	#endif
    227. };
    228.  
    229. //ascii ¡Áa Utf8
    230. std::string ASCII2UTF_8(std::string& strAsciiCode)
    231. {
    232. 	#ifdef WIN32
    233. 	std::string strRet("");
    234. 	//?¨¨¡ã? ascii ¡Áa?a unicode 
    235. 	std::wstring wstr = Acsi2WideByte(strAsciiCode);
    236. 	//¡Á?o¨®¡ã? unicode ¡Áa?a utf8
    237. 	strRet = Unicode2Utf8(wstr);
    238. 	return strRet;
    239. 	#endif
    240. 	#ifdef linux
    241.     char lpszBuf[256]={0};
    242.     a2u(const_cast<char*>(strAsciiCode.c_str()),strAsciiCode.size(),lpszBuf,256);
    243. 	return std::string(lpszBuf);
    244. 	#endif
    245. };
    246.  
    247. /
    248. bool containStr(std::string _str, std::string _strsub)
    249. {
    250. 	std::string::size_type pos = _str.find(_strsub);//²éÕÒ_strsub±êʶ
    251. 	if(pos!=std::string::npos){
    252. 		return true;
    253. 	}
    254. 	return false;
    255. };
    256.  
    257. /
    258. /***************************************************************************** 
    259.  * 将一个字符的Unicode(UCS-2和UCS-4)编码转换成UTF-8编码. 
    260.  * 
    261.  * 参数: 
    262.  *    unic     字符的Unicode编码值 
    263.  *    pOutput  指向输出的用于存储UTF8编码值的缓冲区的指针 
    264.  *    outsize  pOutput缓冲的大小 
    265.  * 
    266.  * 返回值: 
    267.  *    返回转换后的字符的UTF8编码所占的字节数, 如果出错则返回 0 . 
    268.  * 
    269.  * 注意: 
    270.  *     1. UTF8没有字节序问题, 但是Unicode有字节序要求; 
    271.  *        字节序分为大端(Big Endian)和小端(Little Endian)两种; 
    272.  *        在Intel处理器中采用小端法表示, 在此采用小端法表示. (低地址存低位) 
    273.  *     2. 请保证 pOutput 缓冲区有最少有 6 字节的空间大小! 
    274.  ****************************************************************************/  
    275. int enc_unicode_to_utf8_one(unsigned long unic, unsigned char *pOutput, int outSize)  
    276. {  
    277.     assert(pOutput != NULL);  
    278.     assert(outSize >= 6);  
    279.   
    280.     if ( unic <= 0x0000007F )  
    281.     {  
    282.         // * U-00000000 - U-0000007F:  0xxxxxxx  
    283.         *pOutput     = (unic & 0x7F);  
    284.         return 1;  
    285.     }  
    286.     else if ( unic >= 0x00000080 && unic <= 0x000007FF )  
    287.     {  
    288.         // * U-00000080 - U-000007FF:  110xxxxx 10xxxxxx  
    289.         *(pOutput+1) = (unic & 0x3F) | 0x80;  
    290.         *pOutput     = ((unic >> 6) & 0x1F) | 0xC0;  
    291.         return 2;  
    292.     }  
    293.     else if ( unic >= 0x00000800 && unic <= 0x0000FFFF )  
    294.     {  
    295.         // * U-00000800 - U-0000FFFF:  1110xxxx 10xxxxxx 10xxxxxx  
    296.         *(pOutput+2) = (unic & 0x3F) | 0x80;  
    297.         *(pOutput+1) = ((unic >>  6) & 0x3F) | 0x80;  
    298.         *pOutput     = ((unic >> 12) & 0x0F) | 0xE0;  
    299.         return 3;  
    300.     }  
    301.     else if ( unic >= 0x00010000 && unic <= 0x001FFFFF )  
    302.     {  
    303.         // * U-00010000 - U-001FFFFF:  11110xxx 10xxxxxx 10xxxxxx 10xxxxxx  
    304.         *(pOutput+3) = (unic & 0x3F) | 0x80;  
    305.         *(pOutput+2) = ((unic >>  6) & 0x3F) | 0x80;  
    306.         *(pOutput+1) = ((unic >> 12) & 0x3F) | 0x80;  
    307.         *pOutput     = ((unic >> 18) & 0x07) | 0xF0;  
    308.         return 4;  
    309.     }  
    310.     else if ( unic >= 0x00200000 && unic <= 0x03FFFFFF )  
    311.     {  
    312.         // * U-00200000 - U-03FFFFFF:  111110xx 10xxxxxx 10xxxxxx 10xxxxxx 10xxxxxx  
    313.         *(pOutput+4) = (unic & 0x3F) | 0x80;  
    314.         *(pOutput+3) = ((unic >>  6) & 0x3F) | 0x80;  
    315.         *(pOutput+2) = ((unic >> 12) & 0x3F) | 0x80;  
    316.         *(pOutput+1) = ((unic >> 18) & 0x3F) | 0x80;  
    317.         *pOutput     = ((unic >> 24) & 0x03) | 0xF8;  
    318.         return 5;  
    319.     }  
    320.     else if ( unic >= 0x04000000 && unic <= 0x7FFFFFFF )  
    321.     {  
    322.         // * U-04000000 - U-7FFFFFFF:  1111110x 10xxxxxx 10xxxxxx 10xxxxxx 10xxxxxx 10xxxxxx  
    323.         *(pOutput+5) = (unic & 0x3F) | 0x80;  
    324.         *(pOutput+4) = ((unic >>  6) & 0x3F) | 0x80;  
    325.         *(pOutput+3) = ((unic >> 12) & 0x3F) | 0x80;  
    326.         *(pOutput+2) = ((unic >> 18) & 0x3F) | 0x80;  
    327.         *(pOutput+1) = ((unic >> 24) & 0x3F) | 0x80;  
    328.         *pOutput     = ((unic >> 30) & 0x01) | 0xFC;  
    329.         return 6;  
    330.     }  
    331.   
    332.     return 0;  
    333. }  
    334.  
    335. /***************************************************************************** 
    336.  * 将一个字符的UTF8编码转换成Unicode(UCS-2和UCS-4)编码. 
    337.  * 
    338.  * 参数: 
    339.  *    pInput      指向输入缓冲区, 以UTF-8编码 
    340.  *    Unic        指向输出缓冲区, 其保存的数据即是Unicode编码值, 
    341.  *                类型为unsigned long . 
    342.  * 
    343.  * 返回值: 
    344.  *    成功则返回该字符的UTF8编码所占用的字节数; 失败则返回0. 
    345.  * 
    346.  * 注意: 
    347.  *     1. UTF8没有字节序问题, 但是Unicode有字节序要求; 
    348.  *        字节序分为大端(Big Endian)和小端(Little Endian)两种; 
    349.  *        在Intel处理器中采用小端法表示, 在此采用小端法表示. (低地址存低位) 
    350.  ****************************************************************************/  
    351.  /*
    352. int enc_utf8_to_unicode_one(const unsigned char* pInput, unsigned long *Unic)  
    353. {  
    354.     assert(pInput != NULL && Unic != NULL);  
    355.   
    356.     // b1 表示UTF-8编码的pInput中的高字节, b2 表示次高字节, ...  
    357.     char b1, b2, b3, b4, b5, b6;  
    358.   
    359.     *Unic = 0x0; // 把 *Unic 初始化为全零  
    360.     int utfbytes = enc_get_utf8_size(*pInput);  
    361.     unsigned char *pOutput = (unsigned char *) Unic;  
    362.   
    363.     switch ( utfbytes )  
    364.     {  
    365.         case 0:  
    366.             *pOutput     = *pInput;  
    367.             utfbytes    += 1;  
    368.             break;  
    369.         case 2:  
    370.             b1 = *pInput;  
    371.             b2 = *(pInput + 1);  
    372.             if ( (b2 & 0xE0) != 0x80 )  
    373.                 return 0;  
    374.             *pOutput     = (b1 << 6) + (b2 & 0x3F);  
    375.             *(pOutput+1) = (b1 >> 2) & 0x07;  
    376.             break;  
    377.         case 3:  
    378.             b1 = *pInput;  
    379.             b2 = *(pInput + 1);  
    380.             b3 = *(pInput + 2);  
    381.             if ( ((b2 & 0xC0) != 0x80) || ((b3 & 0xC0) != 0x80) )  
    382.                 return 0;  
    383.             *pOutput     = (b2 << 6) + (b3 & 0x3F);  
    384.             *(pOutput+1) = (b1 << 4) + ((b2 >> 2) & 0x0F);  
    385.             break;  
    386.         case 4:  
    387.             b1 = *pInput;  
    388.             b2 = *(pInput + 1);  
    389.             b3 = *(pInput + 2);  
    390.             b4 = *(pInput + 3);  
    391.             if ( ((b2 & 0xC0) != 0x80) || ((b3 & 0xC0) != 0x80)  
    392.                     || ((b4 & 0xC0) != 0x80) )  
    393.                 return 0;  
    394.             *pOutput     = (b3 << 6) + (b4 & 0x3F);  
    395.             *(pOutput+1) = (b2 << 4) + ((b3 >> 2) & 0x0F);  
    396.             *(pOutput+2) = ((b1 << 2) & 0x1C)  + ((b2 >> 4) & 0x03);  
    397.             break;  
    398.         case 5:  
    399.             b1 = *pInput;  
    400.             b2 = *(pInput + 1);  
    401.             b3 = *(pInput + 2);  
    402.             b4 = *(pInput + 3);  
    403.             b5 = *(pInput + 4);  
    404.             if ( ((b2 & 0xC0) != 0x80) || ((b3 & 0xC0) != 0x80)  
    405.                     || ((b4 & 0xC0) != 0x80) || ((b5 & 0xC0) != 0x80) )  
    406.                 return 0;  
    407.             *pOutput     = (b4 << 6) + (b5 & 0x3F);  
    408.             *(pOutput+1) = (b3 << 4) + ((b4 >> 2) & 0x0F);  
    409.             *(pOutput+2) = (b2 << 2) + ((b3 >> 4) & 0x03);  
    410.             *(pOutput+3) = (b1 << 6);  
    411.             break;  
    412.         case 6:  
    413.             b1 = *pInput;  
    414.             b2 = *(pInput + 1);  
    415.             b3 = *(pInput + 2);  
    416.             b4 = *(pInput + 3);  
    417.             b5 = *(pInput + 4);  
    418.             b6 = *(pInput + 5);  
    419.             if ( ((b2 & 0xC0) != 0x80) || ((b3 & 0xC0) != 0x80)  
    420.                     || ((b4 & 0xC0) != 0x80) || ((b5 & 0xC0) != 0x80)  
    421.                     || ((b6 & 0xC0) != 0x80) )  
    422.                 return 0;  
    423.             *pOutput     = (b5 << 6) + (b6 & 0x3F);  
    424.             *(pOutput+1) = (b5 << 4) + ((b6 >> 2) & 0x0F);  
    425.             *(pOutput+2) = (b3 << 2) + ((b4 >> 4) & 0x03);  
    426.             *(pOutput+3) = ((b1 << 6) & 0x40) + (b2 & 0x3F);  
    427.             break;  
    428.         default:  
    429.             return 0;  
    430.             break;  
    431.     }  
    432.   
    433.     return utfbytes;  
    434. }  
    435. */
    436. ///
    437. /*
    438. std::string ws2s(const std::wstring& ws)
    439. {
    440.     std::string curLocale = setlocale(LC_ALL, NULL); // curLocale = "C";
    441.     setlocale(LC_ALL, "chs"); 
    442.     const wchar_t* _Source = ws.c_str();
    443.     size_t _Dsize = 2 * ws.size() + 1;
    444.     char *_Dest = new char[_Dsize];
    445.     memset(_Dest,0,_Dsize);
    446.     wcstombs(_Dest,_Source,_Dsize);
    447.     std::string result = _Dest;
    448.     delete []_Dest;
    449.     setlocale(LC_ALL, curLocale.c_str());
    450.     return result;
    451. }
    452. */ 
    453. /*
    454. std::wstring s2ws(const std::string& s)
    455. {
    456.     setlocale(LC_ALL, "chs"); 
    457.     const char* _Source = s.c_str();
    458.     size_t _Dsize = s.size() + 1;
    459.     wchar_t *_Dest = new wchar_t[_Dsize];
    460.     wmemset(_Dest, 0, _Dsize);
    461.     int nret = mbstowcs(_Dest,_Source,_Dsize);
    462.     std::wstring result = _Dest;
    463.     delete []_Dest;
    464.     setlocale(LC_ALL, "C");
    465.  
    466.     return result;
    468. }
    469. */
    470.  
    471. /* 
    472. std::wstring UTF2Uni(const char* src, std::wstring &t)
    473. {
    474.     if (src == NULL) 
    475.     {
    476.         return L"";
    477.     }
    478.     
    479.     int size_s = strlen(src);
    480.     int size_d = size_s + 10;          //?
    481.     
    482.     wchar_t *des = new wchar_t[size_d];
    483.     memset(des, 0, size_d * sizeof(wchar_t));
    484.     
    485.     int s = 0, d = 0;
    486.     bool toomuchbyte = true; //set true to skip error prefix.
    487.     
    488.     while (s < size_s && d < size_d)
    489.     {
    490.         unsigned char c = src[s];
    491.         if ((c & 0x80) == 0) 
    492.         {
    493.             des[d++] += src[s++];
    494.         } 
    495.         else if((c & 0xE0) == 0xC0)  ///< 110x-xxxx 10xx-xxxx
    496.         {
    497.             WCHAR &wideChar = des[d++];
    498.             wideChar  = (src[s + 0] & 0x3F) << 6;
    499.             wideChar |= (src[s + 1] & 0x3F);
    500.             
    501.             s += 2;
    502.         }
    503.         else if((c & 0xF0) == 0xE0)  ///< 1110-xxxx 10xx-xxxx 10xx-xxxx
    504.         {
    505.             WCHAR &wideChar = des[d++];
    506.             
    507.             wideChar  = (src[s + 0] & 0x1F) << 12;
    508.             wideChar |= (src[s + 1] & 0x3F) << 6;
    509.             wideChar |= (src[s + 2] & 0x3F);
    510.             
    511.             s += 3;
    512.         } 
    513.         else if((c & 0xF8) == 0xF0)  ///< 1111-0xxx 10xx-xxxx 10xx-xxxx 10xx-xxxx 
    514.         {
    515.             WCHAR &wideChar = des[d++];
    516.             
    517.             wideChar  = (src[s + 0] & 0x0F) << 18;
    518.             wideChar  = (src[s + 1] & 0x3F) << 12;
    519.             wideChar |= (src[s + 2] & 0x3F) << 6;
    520.             wideChar |= (src[s + 3] & 0x3F);
    521.             
    522.             s += 4;
    523.         } 
    524.         else 
    525.         {
    526.             WCHAR &wideChar = des[d++]; ///< 1111-10xx 10xx-xxxx 10xx-xxxx 10xx-xxxx 10xx-xxxx 
    527.             
    528.             wideChar  = (src[s + 0] & 0x07) << 24;
    529.             wideChar  = (src[s + 1] & 0x3F) << 18;
    530.             wideChar  = (src[s + 2] & 0x3F) << 12;
    531.             wideChar |= (src[s + 3] & 0x3F) << 6;
    532.             wideChar |= (src[s + 4] & 0x3F);
    533.             
    534.             s += 5;
    535.         }
    536.     }
    537.     
    538.     t = des;
    539.     delete[] des;
    540.     des = NULL;
    541.     
    542.     return t;
    543. }
    544. */
    545.  
    546. /*
    547. int Uni2UTF( const std::wstring& strRes, char *utf8, int nMaxSize )
    548. {
    549.     if (utf8 == NULL) {
    550.         return -1;
    551.     }
    552.     int len = 0;
    553.     int size_d = nMaxSize;
    556.     for (std::wstring::const_iterator it = strRes.begin(); it != strRes.end(); ++it)
    557.     {
    558.         wchar_t wchar = *it;
    559.         if (wchar < 0x80)
    560.         {  //
    561.             //length = 1;
    562.             utf8[len++] = (char)wchar;
    563.         }
    564.         else if(wchar < 0x800)
    565.         {
    566.             //length = 2;
    567.             
    568.             if (len + 1 >= size_d)
    569.                 return -1;
    570.             
    571.             utf8[len++] = 0xc0 | ( wchar >> 6 );
    572.             utf8[len++] = 0x80 | ( wchar & 0x3f );
    573.         }
    574.         else if(wchar < 0x10000 )
    575.         {
    576.             //length = 3;
    577.             if (len + 2 >= size_d)
    578.                 return -1;
    579.             
    580.             utf8[len++] = 0xe0 | ( wchar >> 12 );
    581.             utf8[len++] = 0x80 | ( (wchar >> 6) & 0x3f );
    582.             utf8[len++] = 0x80 | ( wchar & 0x3f );
    583.         }
    584.         else if( wchar < 0x200000 ) 
    585.         {
    586.             //length = 4;
    587.             if (len + 3 >= size_d)
    588.                 return -1;
    589.             
    590.             utf8[len++] = 0xf0 | ( (int)wchar >> 18 );
    591.             utf8[len++] = 0x80 | ( (wchar >> 12) & 0x3f );
    592.             utf8[len++] = 0x80 | ( (wchar >> 6) & 0x3f );
    593.             utf8[len++] = 0x80 | ( wchar & 0x3f );
    594.         }
    595.     
    596.     }
    597.     
    599.     return len;
    600. }
    601. */
    602. /*
    603. std::string s2utfs(const  std::string&  strSrc)
    604. {
    605.     std::string  strRes;
    606.     std::wstring  wstrUni = s2ws(strSrc);
    607.     
    608.     char*  chUTF8 = new char[wstrUni.length() * 3];
    609.     memset(chUTF8,0x00,wstrUni.length() * 3);
    610.     Uni2UTF(wstrUni,chUTF8, wstrUni.length() * 3);
    611.     strRes = chUTF8;    
    612.     delete  []chUTF8;
    613.     return strRes;
    614. }
    615. */
    616. /*
    617. std::string  utfs2s(const std::string& strutf)
    618. {
    619.     std::wstring  wStrTmp;
    620.     UTF2Uni( strutf.c_str(),wStrTmp);
    621.     return ws2s(wStrTmp);
    622. }
    623. */

    myfiledialog.h基于QFileDialog实现自定义对话框

    1. #ifndef MYFILEDIALOG_H
    2. #define MYFILEDIALOG_H
    3.  
    4. #include 
    5.  
    6. class MyFileDialog : public QFileDialog
    7. {
    8. 	Q_OBJECT
    9. public:
    10. 	MyFileDialog( QWidget * parent = 0
    11. 		, int _model = 0
    12. 		, const QString & caption = QString()
    13. 		, const QString & directory = QString()
    14. 		, const QString & filter = QString());
    15. 	~MyFileDialog();
    16. private:
    17. 	void init(int _model);
    18. private:
    19. 	QString initDir;
    20. 	/* data */
    21. };
    22.  
    23. #endif //MYFILEDIALOG_H

    myfiledialog.cpp

    1. #include "myfiledialog.h"
    2.  
    3. #include 
    4.  
    5. MyFileDialog::MyFileDialog(QWidget * parent
    6. 		, int _model
    7. 		, const QString & caption
    8. 		, const QString & directory
    9. 		, const QString & filter )
    10. 	: QFileDialog(parent,caption,directory,filter)
    11. 	, initDir(directory)
    12. {
    13. 	init(_model);
    14. }
    15.  
    16. MyFileDialog::~MyFileDialog()
    17. {
    18.  
    19. }
    20.  
    21. void MyFileDialog::init(int _model)
    22. {
    23.     this->setWindowTitle(tr("File Path Set Dialog"));
    24.     this->setLabelText(QFileDialog::LookIn,tr("MyLookIn"));
    25.     this->setLabelText(QFileDialog::FileName,tr("MyfileName"));
    26.     this->setLabelText(QFileDialog::FileType,tr("MyFileType"));
    27.     QString _appDir = QCoreApplication::applicationDirPath();
    28.     switch(_model)
    29.     {
    30.     	case 0:
    31.     	    this->setAcceptMode(QFileDialog::AcceptSave);
    32. 		    this->setLabelText(QFileDialog::Accept,tr("mySave"));
    33. 	        this->setDirectory(_appDir);
    34.             this->setNameFilter(tr("csv Files (*.csv)"));
    35.     		break;
    36.     	case 1:
    37.     	    this->setAcceptMode(QFileDialog::AcceptSave);
    38. 		    this->setLabelText(QFileDialog::Accept,tr("mySave"));
    39. 		    this->setDirectory(_appDir);
    40.             this->setNameFilter(tr("xml Files (*.xml)"));
    41.     		break;
    42.     	case 2:
    43.     	    this->setAcceptMode(QFileDialog::AcceptOpen);
    44. 		    this->setLabelText(QFileDialog::Accept,tr("myOpen"));
    45. 		    this->setDirectory(_appDir);
    46.             this->setNameFilter(tr("xml Files (*.xml)"));
    47.     		break;
    48.     	case 3:
    49.     	{
    50.  
    51.     	    // this->setAcceptMode(QFileDialog::AcceptOpen);
    52. 		    this->setFilter(QDir::NoDotAndDotDot);
    53. 		    this->setFileMode(QFileDialog::Directory);
    54. 		    this->setOptions(QFileDialog::ReadOnly);
    55. 		    this->setLabelText(QFileDialog::Accept,tr("myChoose"));
    56.     	}
    57.     		break;
    58.     	case 4:
    59.     	{
    60.     	    this->setAcceptMode(QFileDialog::AcceptOpen);
    61. 		    this->setLabelText(QFileDialog::Accept,tr("myOpen"));
    62.             this->setNameFilter(tr("sqlite Files (*.db)"));
    63.     	}
    64.     		break;
    65.     	case 5:
    66.     	{
    67. 		    this->setAcceptMode(QFileDialog::AcceptOpen);
    68. 		    this->setLabelText(QFileDialog::Accept,tr("myOpen"));
    69.             this->setFilter(QDir::Files);
    70. 		}
    71.     		break;
    72.     	case 6:
    73.     	{
    74. 		    this->setAcceptMode(QFileDialog::AcceptSave);
    75. 		    this->setLabelText(QFileDialog::Accept,tr("mySave"));
    76.             this->setNameFilter(tr("csv Files (*.csv)"));
    77.     	}
    78.     	case 7:
    79.     	{
    80.     		this->setAcceptMode(QFileDialog::AcceptOpen);
    81. 		    this->setLabelText(QFileDialog::Accept,tr("myOpen"));
    82. 	        this->setDirectory(_appDir);
    83.             this->setNameFilter(tr("csv Files (*.csv);;"
    84. 		    	"ini files (*.ini);;"
    85. 		    	"Text files (*.txt);;"
    86. 		    	"xml files (*.xml);;"
    87. 		    	"Any files (*)"));
    88.     	}
    89.     		break;
    90.     	case 8:
    91.     	{
    92. 		    this->setAcceptMode(QFileDialog::AcceptOpen);
    93. 		    this->setLabelText(QFileDialog::Accept,tr("myOpen"));
    94.             this->setNameFilter(tr("Any files (*)"));
    95. 		}
    96.     		break;
    97.     	default:
    98.     		// this->setDirectory(_appDir);
    99.     		break;
    100.     }
    101.     this->setLabelText(QFileDialog::Reject,tr("myCancel"));
    102. }

    FileQt.h的FileQt类是一个单体类，可以全局调用，实现txt、csv、ini、xls等文件读取、写入操作，支持文件目录、文件名等查询、读取、删除等操作，可以依据读写文件信息的API扩展新的功能或调整实现新文件类型的支持。

    1. #ifndef FILEQT_H
    2. #define FILEQT_H
    3.  
    4. #include 
    5. #include 
    6. #include 
    7.  
    8. class FileQt
    9. {
    10. public:
    11. 	static FileQt* getInstance();
    12. 	static void Destroy();
    13. 	~FileQt();
    14.  
    15. 	bool writeListInfo(QVector list,const QString path,bool appendf=true);
    16. 	bool readListInfo(QVector > &list,const QString path,QString _div);
    17. 	bool readListInfo(QVector > &list,const QString path);
    18. 	bool readListInfo_dot(QVector > &list,const QString path);
    19. 	bool readListInfo(QVector &list,const QString path);
    20. 	void getAllFileName_dot(const QString directory, const QString extName, QStringList& fileNames);
    21. 	void getAllFileName(const QString& directory, const QString& extName, QStringList& fileNames);
    22. 	void getSubDir(const QString& directory, QStringList& subdirs);
    23.  
    24. 	bool readToVectorXML(QString _file, QStringList elements, QVector &_lists);
    25. 	bool readToVectorXML(QString _file, QStringList elements, QVector > &_lists,QString _div=",");
    26. #ifdef WIN32
    27. 	bool readToVectorXLS(QString _file, QVector > &_lists, int sheet = 1);
    28. #endif
    29. private:
    30. 	bool readToVector(QString _file, QVector > &_lists,QString _div="\\s+");
    31. 	bool readToVector(QString _file, QVector &_lists);
    32. private:
    33. 	FileQt();
    34. 	FileQt(const FileQt& ) {} // copy constructor
    35. 	FileQt& operator=(const FileQt& ) { return *this; } // assignment operator
    36. private:
    37. 	static FileQt* instance;
    38. };
    39.  
    40. #endif //FILEQT_H

    FileQt.cpp

    1. #include "FileQt.h"
    2.  
    3. #include 
    4. #include 
    5. #include 
    6. #include 
    7. #include 
    8. #include 
    9. #include 
    10. #include 
    11. #include 
    12. #include 
    13. #include 
    14. #ifdef WIN32
    15. #include 
    16. #endif
    17.  
    18. FileQt* FileQt::instance = NULL;
    19. FileQt* FileQt::getInstance()
    20. {
    21.     if(NULL == FileQt::instance)
    22.     {
    23.         FileQt::instance = new FileQt();
    24.     }
    25.     return FileQt::instance;
    26. }
    27.  
    28. void FileQt::Destroy()
    29. {
    30. 	if(NULL!=FileQt::instance){
    31. 		delete FileQt::instance;
    32. 		FileQt::instance = NULL;
    33. 	}
    34. }
    35.  
    36. FileQt::FileQt()
    37. {
    38. }
    39.  
    40. FileQt::~FileQt()
    41. {
    42. }
    43.  
    44. bool FileQt::readListInfo(QVector > &list,const QString path,QString _div)
    45. {
    46.     return readToVector(path,list,_div);
    47. }
    48.  
    49. bool FileQt::readListInfo(QVector > &list,const QString path)
    50. {
    51. 	return readToVector(path,list,"\\W+");
    52. }
    53.  
    54. bool FileQt::readListInfo_dot(QVector > &list,const QString path)
    55. {
    56. 	return readToVector(path,list,",");
    57. }
    58.  
    59. bool FileQt::readListInfo(QVector &list,const QString path)
    60. {
    61. 	return readToVector(path,list);
    62. }
    63.  
    64. bool FileQt::readToVector(QString _file,QVector > &_lists, QString _div)
    65. {
    66.     #ifdef WIN32
    67.     if (_file.contains(".xls", Qt::CaseInsensitive))
    68.     {
    69.         return readToVectorXLS(_file,_lists);
    70.     }
    71.     #endif
    72. 	QFile file(_file);
    73.     if (!file.open(QFile::ReadOnly)) {
    74.     	qDebug() << "conn't open file  " << _file << "!\n";
    75.         return false;
    76.     }else{
    77.         QTextStream stream( &file );
    78.         QString line;
    79.         while ( !stream.atEnd() ) {
    80.             line = stream.readLine();
    81.             QStringList _strL = line.split(QRegExp(_div));
    82.             // QStringList _strL = line.split(QRegExp(_div),QString::SkipEmptyParts);
    83.             QVector _onev;
    84.             for (int i = 0; i < _strL.size(); i++)
    85.             {
    86.             	_onev.push_back(_strL[i]);
    87.             }
    88.             _lists.push_back(_onev);
    89.         }
    90.         file.close();
    91.  
    92.         if (_lists.empty())
    93.     	{
    94.     		return false;
    95.     	}else{
    96.     		return true;
    97.     	}
    98.     }
    99. }
    100.  
    101. bool FileQt::readToVector(QString _file, QVector &_lists)
    102. {
    103. 	QFile file(_file);
    104.     if (!file.open(QFile::ReadOnly))
    105.     {
    106.     	qDebug() << "conn't open file  " << _file << "!\n";
    107.         return false;
    108.     }else{
    109.         QTextStream stream( &file );
    110.         stream.setCodec("UTF-8"); //中文编码
    111.         QString line;
    112.         while ( !stream.atEnd() ) {
    113.             line = stream.readLine();
    114.             _lists.push_back(line);
    115.         }
    116.         file.close();
    117.  
    118.         if (_lists.empty())
    119.     	{
    120.     		return false;
    121.     	}else{
    122.     		return true;
    123.     	}
    124.     }
    125. }
    126.  
    127. void FileQt::getAllFileName_dot(const QString directory, const QString extName, QStringList& fileNames)
    128. {
    129.     QDir _dir(directory);
    130.     QStringList filters;
    131.     filters << ("*."+extName);
    132.     _dir.setNameFilters(filters);
    133.     _dir.setFilter(QDir::Files | QDir::NoDotAndDotDot | QDir::NoSymLinks);
    134.     _dir.setSorting(QDir::Name);
    135.     fileNames = _dir.entryList();
    136.     qDebug() << fileNames << "\n";
    137. }
    138.  
    139. void FileQt::getAllFileName(const QString& directory, const QString& extName, QStringList& fileNames)
    140. {
    141.     QDir _dir(directory);
    142.     QStringList filters;
    143.     filters << ("*."+extName);
    144.     _dir.setNameFilters(filters);
    145.     _dir.setFilter(QDir::Files | QDir::NoDotAndDotDot | QDir::NoSymLinks);
    146.     _dir.setSorting(QDir::Name);
    147.     QStringList _files = _dir.entryList();
    148.     for (int i = 0; i < _files.size(); i++)
    149.     {
    150.         fileNames << _files[i].left(_files[i].lastIndexOf("."));
    151.     }
    152.     qDebug() << fileNames << "\n";
    153. }
    154.  
    155. void FileQt::getSubDir(const QString& directory, QStringList& subdirs)
    156. {
    157.     QDir _dir(directory);
    158.     _dir.setFilter(QDir::Dirs | QDir::NoDotAndDotDot | QDir::NoSymLinks);
    159.     _dir.setSorting(QDir::Name);
    160.     subdirs = _dir.entryList();
    161.     qDebug() << subdirs << "\n";
    162. }
    163.  
    164. bool FileQt::readToVectorXML(QString _file, QStringList elements, QVector &_lists)
    165. {
    166.     QFile inputFile(_file);
    167.     if(!inputFile.open(QFile::ReadOnly))
    168.     {
    169.         qDebug() << "cann't create file: "<< _file <<"\n";
    170.         return false;
    171.     }
    172. 	 QByteArray data = inputFile.readAll();
    173.     inputFile.close();
    174.  
    175.     QTextCodec *codec = QTextCodec::codecForHtml(data);
    176.     QString str = codec->toUnicode(data);
    177.     QXmlStreamReader reader(str);
    178.     //reader.readNext();
    179.  
    180.     bool readF = false;
    181.     while (!reader.atEnd()&&!reader.hasError())
    182.     {
    183.         reader.readNext();
    184.         if (reader.error())
    185.         {
    186.             qDebug()<errorString()<<": "<name().toString()<<"\n";
    187.             return false;
    188.         } else{
    189.             if (QXmlStreamReader::StartElement==reader.tokenType()
    190.                && elements.contains(reader.name().toString()))
    191.             {
    192.                 readF = true;
    193.                 continue;
    194.             }
    195.             if (QXmlStreamReader::EndElement==reader.tokenType()
    196.                 && elements.contains(reader.qualifiedName().toString()))
    197.             {
    198.                 readF = false;
    199.                 continue;
    200.             }
    201.             if(readF){
    202.                 _lists.push_back(reader.text().toString());
    203.             }
    204.         }
    205.     }
    206.     return true;
    207. }
    208.  
    209. bool FileQt::readToVectorXML(QString _file, QStringList elements, QVector > &_lists,QString _div)
    210. {
    211.     QVector _list;
    212.     if(readToVectorXML(_file,elements,_list)){
    213.         for (int i = 0; i < _list.size(); i++)
    214.         {
    215.             QStringList _linelist = _list[i].split(QRegExp(_div));
    216.             QVector _linevect;
    217.             for (int j = 0; j < _linelist.size(); j++)
    218.             {
    219.                 _linevect << _linelist[j];
    220.             }
    221.             _lists.push_back(_linevect);
    222.         }
    223.         return true;
    224.     }
    225.     return false;
    226. }
    227.  
    228. #ifdef WIN32
    229. bool FileQt::readToVectorXLS(QString _file, QVector > &_lists, int sheet)
    230. {
    231. 	if(sheet<=0)
    232. 	{
    233. 		return false;
    234. 	}
    235.     QAxObject *excel = NULL;
    236.     QAxObject *workbooks = NULL;
    237.     QAxObject *workbook = NULL;
    238.  
    239.     excel = new QAxObject("Excel.Application");//连接Excel控件
    240.     if (!excel) {
    241.         qDebug()<< QObject::tr("error info: ") << QObject::tr("EXCEL object loss") <<"\n";
    242.         return false;
    243.     }
    244.     excel->dynamicCall("SetVisible(bool)", false);//不显示窗体
    245.     excel->setProperty("DisplayAlerts", false);//不显示任何警告信息。
    246.  
    247.     workbooks = excel->querySubObject("WorkBooks");//获取工作簿集合
    248.     workbook = workbooks->querySubObject("Open(QString, QVariant)", _file); //打开工作簿
    249. 	qDebug() << "workbooks size = " << workbook->querySubObject("WorkSheets")->property("Count").toInt() << "\n";
    250. 	if(sheet>workbook->querySubObject("WorkSheets")->property("Count").toInt()){
    251. 		delete workbook;
    252. 		workbook = NULL;
    253. 		delete workbooks;
    254. 		workbooks = NULL;
    255. 		delete excel;
    256. 		excel = NULL;
    257. 		return false;
    258. 	}
    259.     QAxObject * worksheet = workbook->querySubObject("WorkSheets(int)", sheet);//打开第一个sheet
    260.  
    261.     QAxObject * usedrange = worksheet->querySubObject("UsedRange");//获取该sheet的使用范围对象
    262.     int intRowStart = usedrange->property("Row").toInt();
    263.     int intColStart = usedrange->property("Column").toInt();
    264.  
    265.     QAxObject * rows = usedrange->querySubObject("Rows");
    266.     int intRows = rows->property("Count").toInt();
    267.  
    268.     QAxObject * columns = usedrange->querySubObject("Columns");
    269.     int intCols = columns->property("Count").toInt();
    270.  
    271.     for (int i = intRowStart; i < intRowStart + intRows; i++)//row
    272.     {
    273.         QVector _onev;
    274.         for (int j = intColStart; j < intColStart + intCols; j++)//column
    275.         {
    276.             // QAxObject * range = worksheet->querySubObject("Cells(QVariant,QVariant)", i, j ); //获取单元格
    277.             // // qDebug() << i << j << range->property("Value");
    278.             // _onev.push_back(range->property("Value").toString());
    279.  
    280.             _onev.push_back(
    281.                 worksheet->querySubObject("Cells(QVariant,QVariant)", i, j )->property("Value").toString());
    282.         }
    283.         _lists.push_back(_onev);
    284.     }
    285.     workbook->dynamicCall("Close()");//关闭工作簿
    286.     excel->dynamicCall("Quit()");//关闭excel
    287.  
    288.     delete columns;
    289.     columns = NULL;
    290.     delete rows;
    291.     rows = NULL;
    292.     delete usedrange;
    293.     usedrange = NULL;
    294.     delete worksheet;
    295.     worksheet = NULL;
    296.     delete workbook;
    297.     workbook = NULL;
    298.     delete workbooks;
    299.     workbooks = NULL;
    300.     delete excel;
    301.     excel = NULL;
    302.  
    303.     return true;
    304. }
    305. #endif
    306.  
    307. bool FileQt::writeListInfo(QVector list,const QString path,bool appendf)
    308. {
    309.     QFile f(path);
    310.     if(!f.open(QFile::WriteOnly | QFile::Text | (appendf?QFile::Append:QFile::Truncate)))
    311.         return false;
    312.  
    313.     QTextStream out(&f);
    314.  
    315.     out.setCodec("UTF-8"); //中文编码
    316.     for (int i = 0; i < list.size(); i++)
    317.     {
    318.         out << QString(list[i]);
    319.     }
    320.     f.close();
    321.     return true;
    322. }

    inOrOutConf.h实现简要的界面窗口，

    提供sqlite数据库文件路径及csv文件目录编辑以及两个转换按钮。

    1. #ifndef INOROUT_CONF_H
    2. #define INOROUT_CONF_H
    3.  
    4. #include 
    5.  
    6. class QLineEdit;
    7. class QPushButton;
    8. class QLabel;
    9.  
    10. class InOrOutConf : public QWidget
    11. {
    12. 	Q_OBJECT
    13. public:
    14. 	InOrOutConf(QWidget * parent = 0,Qt::WindowFlags f = 0);
    15. 	~InOrOutConf();
    16.  
    17. private slots:
    18. 	void setDBPath();
    19. 	void setCsvPath();
    20. 	void scvToDB();
    21. 	void DBToCsv();
    22. private:
    23. 	QString divPath;
    24. 	QLineEdit *pathEdit;	//db路径编辑框
    25. 	QPushButton *pathset;	//db路径打开
    26.  
    27. 	QLineEdit *dirEdit;	//文件目录编辑框
    28. 	QPushButton *dirset;	//文件目录打开
    29.  
    30. 	QPushButton *inButton;	//csv到db
    31. 	QPushButton *outButton;	//db到csv
    32. 	QPushButton *close;	//
    33.  
    34. 	QLabel *warLabel;
    35. };
    36.  
    37. #endif //INOROUT_CONF_H
    38.

    inOrOutConf.cpp，注意inYc、outYc等API主要实现关于表格名、列表名特定处理，暂没做抽象提取及可配置实现。

    1. #include "inOrOutConf.h"
    2.  
    3. #include 
    4. #include 
    5. #include 
    6. #include 
    7. #include 
    8. #include 
    9. #include 
    10.  
    11. #include 
    12. #include 
    13. #include 
    14. #include 
    15. #include 
    16.  
    17. #ifdef WIN32
    18. #include 
    19. Q_IMPORT_PLUGIN(QSQLiteDriverPlugin)
    20. #endif
    21.  
    22. #include 
    23. #include 
    24. #include 
    25.  
    26. // #include "sqlite/sqlite3.h"
    27. // #include "sqlite/CSQLite.h"
    28.  
    29. #include "file/myfiledialog.h"
    30. #include "file/strcode.hpp"
    31.  
    32. // //101YC配置表
    33. // typedef struct _s101yc{
    34. // 	int INDEXID;
    35. // 	int DEVID;
    36. // 	char NAME[256];
    37. // 	unsigned int LOCALADDR;
    38. // 	double COEF;
    39. // 	double THV;
    40. // 	char NAMETOMST[256];
    41. // 	unsigned int ZEROVAL;
    42. // 	unsigned int SAMPADDR;
    43. // 	unsigned int SAMPDEVID;
    44. // 	char EXPLAIN[256];
    45. // }s101yc;
    46.  
    47.  
    48. // //101YX配置表
    49. // typedef struct _s101yx{
    50. // 	int INDEXID;
    51. // 	int DEVID;
    52. // 	char NAME[256];
    53. // 	unsigned int LOCALADDR;
    54. // 	unsigned int NOT;
    55. //  	unsigned int SAMPDEVID;
    56. // 	unsigned int SAMPADDR;
    57. // 	char NAMETOMST[256];
    58. // }s101yx;
    59.  
    60.  
    61. // //101YK配置表
    62. // typedef struct _s101yk{
    63. // 	int INDEXID;
    64. // 	unsigned int LOCALADDR;
    65. // 	int DEVID;
    66. // 	char NAME[256];
    67. // 	unsigned int SAMPDEVID;
    68. // 	unsigned int SAMPADDR;
    69. // 	char NAMETOMST[256];
    70. // }s101yk;
    71.  
    72. // //YC
    73. // int GetS101yc(const char * dbfile, const char* condition, s101yc * ycs, int size)
    74. // {
    75. // 	CSQLiteDB db;
    76. // 	if( !db.open(dbfile) ){
    77. // 		printf("open db: error!", dbfile);
    78. // 		return -1;
    79. // 	}
    80. // 	char sql[1024] ={0};
    81. // 	if( strlen(condition) > 0 )
    82. // 		sprintf(sql,"select * from s101yc where %s", condition);
    83. // 	else
    84. // 		sprintf(sql,"select * from s101yc");
    85. // 	int icount = 0;
    86. // 	CSQLiteQuery query;
    87. // 	try{
    88. // 		query = db.execQuery(sql);
    89. // 		while( !query.eof() && icount
    90. // 			ycs[icount].INDEXID = query.getIntField("INDEXID");
    91. // 			ycs[icount].DEVID = query.getIntField("DEVID");
    92. // 			strcpy( ycs[icount].NAME,query.getStringField("NAME"));
    93. // 			ycs[icount].LOCALADDR = query.getIntField("LOCALADDR");
    94. // 			ycs[icount].COEF = query.getFloatField("COEF");
    95. // 			ycs[icount].THV = query.getFloatField("THV");
    96. // 			strcpy( ycs[icount].NAMETOMST,query.getStringField("NAMETOMST"));
    97. // 			ycs[icount].ZEROVAL = query.getIntField("ZEROVAL");
    98. // 			ycs[icount].SAMPADDR = query.getIntField("SAMPADDR");
    99. // 			ycs[icount].SAMPDEVID = query.getIntField("SAMPDEVID");
    100. // 			strcpy( ycs[icount].EXPLAIN,query.getStringField("EXPLAIN"));
    101. // 			icount++;
    102. // 			query.nextRow();
    103. // 		}
    104. // 	}catch (CSQLiteException& e) {
    105. // 		printf("db query error %d\n",e.errorCode());
    106. // 		return -1;
    107. // 	}
    108. // 	return icount;
    109. // };
    110.  
    111. InOrOutConf::InOrOutConf(QWidget * parent,Qt::WindowFlags f)
    112. 	: QWidget(parent,f)
    113. {
    114. 	pathEdit = new QLineEdit(this);
    115.     pathEdit->setMinimumWidth(200);
    116.     pathset = new QPushButton(tr("dbOpen"),this);
    117.     pathset->setMaximumWidth(72);
    118.     connect(pathset,SIGNAL(clicked()),this,SLOT(setDBPath()));
    119.  
    120. 	//layout
    121.     QFormLayout *formLayout_00 = new QFormLayout;
    122.     formLayout_00->setContentsMargins(0,0,0,0);
    123.     formLayout_00->addRow(tr("dbPath:"), pathEdit);
    124.  
    125.     QHBoxLayout *m_QHBoxLayout_00 = new QHBoxLayout;
    126.     m_QHBoxLayout_00->setContentsMargins(0,0,0,0);
    127.     m_QHBoxLayout_00->addLayout(formLayout_00);
    128.     m_QHBoxLayout_00->addWidget(pathset);
    129.  
    130.     dirEdit = new QLineEdit(this);
    131.     dirEdit->setMinimumWidth(200);
    132.     dirset = new QPushButton(tr("scvDirCheck"),this);
    133.     dirset->setMaximumWidth(72);
    134.     connect(dirset,SIGNAL(clicked()),this,SLOT(setCsvPath()));
    135.  
    136. 	//layout
    137.     QFormLayout *formLayout_01 = new QFormLayout;
    138.     formLayout_01->setContentsMargins(0,0,0,0);
    139.     formLayout_01->addRow(tr("scvDir:"), dirEdit);
    140.  
    141.     QHBoxLayout *m_QHBoxLayout_01 = new QHBoxLayout;
    142.     m_QHBoxLayout_01->setContentsMargins(0,0,0,0);
    143.     m_QHBoxLayout_01->addLayout(formLayout_01);
    144.     m_QHBoxLayout_01->addWidget(dirset);
    145.  
    146.     QVBoxLayout *m_QVBoxLayout = new QVBoxLayout;
    147.     m_QVBoxLayout->addLayout(m_QHBoxLayout_00);
    148.     m_QVBoxLayout->addLayout(m_QHBoxLayout_01);
    149.  
    150.     warLabel = new QLabel(this);
    151.  
    152.     inButton = new QPushButton(tr("scvToDB"),this);
    153.     inButton->setMaximumWidth(72);
    154.     connect(inButton,SIGNAL(clicked()),this,SLOT(scvToDB()));
    155.     outButton = new QPushButton(tr("DBToCsv"),this);
    156.     outButton->setMaximumWidth(72);
    157.     connect(outButton,SIGNAL(clicked()),this,SLOT(DBToCsv()));
    158.     close = new QPushButton(tr("Close"),this);
    159.     close->setMaximumWidth(72);
    160.     connect(close,SIGNAL(clicked()),this,SLOT(close()));
    161.  
    162.     QGridLayout *_QGridLayout = new QGridLayout(this);
    163.     _QGridLayout->addLayout(m_QVBoxLayout,0,0,2,10);
    164.     _QGridLayout->addWidget(warLabel,2,0,1,10);
    165.     _QGridLayout->addWidget(inButton,3,7,1,1);
    166.     _QGridLayout->addWidget(outButton,3,8,1,1);
    167.     _QGridLayout->addWidget(close,3,9,1,1);
    168. 	#ifdef WIN32
    169.     divPath = "\\";
    170.     #else
    171.     divPath = "/";
    172.     #endif
    173. };
    174.  
    175. InOrOutConf::~InOrOutConf()
    176. {
    177.  
    178. };
    179.  
    180. void InOrOutConf::setDBPath()
    181. {
    182. 	QString dbPath = QCoreApplication::applicationDirPath()+divPath+"exxconf.db";
    183.     MyFileDialog *fileDialog = new MyFileDialog(this,4,tr("open DB file"),dbPath);
    184.  
    185.     if(fileDialog->exec() == QDialog::Accepted) {
    186.         dbPath = fileDialog->selectedFiles()[0];
    187.     }
    188.     qDebug() << "dbPath = "<"\n";
    189.     this->pathEdit->setText(dbPath);
    190. };
    191.  
    192. void InOrOutConf::setCsvPath()
    193. {
    194. 	QString csvDir = QCoreApplication::applicationDirPath();
    195.     MyFileDialog *fileDialog = new MyFileDialog(this,3,tr("open CSV dir"),csvDir);
    196.  
    197.     if(fileDialog->exec() == QDialog::Accepted) {
    198.         csvDir = fileDialog->selectedFiles()[0];
    199.     }
    200.     qDebug() << "csvDir = "<"\n";
    201.     this->dirEdit->setText(csvDir);
    202. };
    203.  
    204. bool executeSQL(QSqlDatabase db,QString _sql)
    205. {
    206. 	QSqlQuery query(db);
    207.     return query.exec(_sql);
    208. };
    209.  
    210. bool checkTable(QSqlDatabase db, QString _table)
    211. {
    212.     QString _sql = QString("select count(*) from sqlite_master where type='table' and name='%1'").arg(_table);
    213.     QSqlQuery query(db);
    214.     query.exec(_sql);
    215.     bool _existTable = true;
    216.     if (query.next())
    217.     {
    218.         int _countTable = query.value(0).toInt();
    219.         if (1!=_countTable)
    220.         {
    221.             _existTable = false;
    222.         }
    223.     }else{
    224.         _existTable = false;
    225.     }
    226.     return _existTable;
    227. };
    228.  
    229. bool opendb(QSqlDatabase &db, QString _dbn,QString _dbLink)
    230. {
    231.     QString dbv = "QSQLITE";
    232.     // QString _dbLink = "db_sqlite_record";
    233.     if (QSqlDatabase::contains(_dbLink))
    234.     {
    235. 		db = QSqlDatabase::database(_dbLink);
    236.     }else{
    237.     	db = QSqlDatabase::addDatabase(dbv,_dbLink);
    238.     }
    239. 	// checkDBLink(_dbLink);
    240. 	// db = QSqlDatabase::addDatabase(dbv,_dbLink);
    241.     db.setDatabaseName(_dbn);
    242.  
    243.     if (db.open())
    244.     {
    245.         return true;
    246.     }else{
    247.         qDebug() << "open db failed!"<< "---"<< db.lastError().text()<<" \n";
    248.         return false;
    249.     }
    250. };
    251.  
    252. bool checkdb_etconf(QSqlDatabase &db, QString _dbn)
    253. {
    254. 	if (!opendb(db,_dbn,"db_sqlite_etconf"))
    255. 	{
    256. 		return false;
    257. 	}else{
    258. 		if(!executeSQL(db,"PRAGMA synchronous = OFF"))
    259. 		{
    260. 			qDebug() << db.lastError() << "\n";
    261. 		}
    262. 	}
    263.  
    264. 	if(!checkTable(db,"s101yc"))
    265. 	{
    266. 		return false;
    267. 	}
    268. 	if(!checkTable(db,"s101yx"))
    269. 	{
    270. 		return false;
    271. 	}
    272. 	if(!checkTable(db,"s101yk"))
    273. 	{
    274. 		return false;
    275. 	}
    276. 	if(!checkTable(db,"s101yt"))
    277. 	{
    278. 		return false;
    279. 	}
    280. 	return true;
    281. };
    282.  
    283. bool readToVector(QString _file,QVector > &_lists, QString _div)
    284. {
    285. 	QFile file(_file);
    286.     if (!file.open(QFile::ReadOnly)) {
    287.     	qDebug() << "conn't open file  " << _file << "!\n";
    288.         return false;
    289.     }else{
    290.         QTextStream stream( &file );
    291.         QString line;
    292.         while ( !stream.atEnd() ) {
    293.             line = stream.readLine();
    294.             QStringList _strL = line.split(QRegExp(_div));
    295.             // QStringList _strL = line.split(QRegExp(_div),QString::SkipEmptyParts);
    296.             QVector _onev;
    297.             for (int i = 0; i < _strL.size(); i++)
    298.             {
    299.             	_onev.push_back(_strL[i]);
    300.             }
    301.             _lists.push_back(_onev);
    302.         }
    303.         file.close();
    304.  
    305.         if (_lists.empty())
    306.     	{
    307.     		return false;
    308.     	}else{
    309.     		return true;
    310.     	}
    311.     }
    312. }
    313.  
    314. void inYc(QSqlDatabase &db,QString _path)
    315. {
    316. 	QVector > _lists;
    317. 	readToVector(_path,_lists,",");
    318.  
    319. 	QSqlQuery query(db);
    320. 	query.exec("DELETE FROM s101yc");
    321.  
    322. 	QVariantList indexids;
    323. 	QVariantList devids;
    324. 	QVariantList names;
    325. 	QVariantList localaddrs;
    326. 	QVariantList coefs;
    327. 	QVariantList thvs;
    328. 	QVariantList nametomsts;
    329. 	QVariantList zerovals;
    330. 	QVariantList sampaddrs;
    331. 	QVariantList sampdevids;
    332. 	QVariantList explains;
    333.  
    334. 	int _count = 0;
    335. 	QString _sql = "INSERT INTO s101yc (INDEXID,DEVID,NAME,LOCALADDR,COEF,THV,NAMETOMST,ZEROVAL,SAMPADDR,SAMPDEVID,EXPLAIN) "
    336. 			       "VALUES (?,?,?,?,?,?,?,?,?,?,?)";
    337.  
    338. 	for (int i = 0; i < _lists.size(); i++)
    339. 	{
    340. 		if (11!=_lists[i].size())
    341. 		{
    342. 			continue;
    343. 		}
    344. 		indexids << _lists[i][0].toInt();
    345. 		devids << _lists[i][1].toInt();
    346. 		names << _lists[i][2];
    347. 		// names << QString("%1").arg(_lists[i][2].toAscii().data());
    348. 		localaddrs << _lists[i][3].toInt();
    349. 		coefs << _lists[i][4].toDouble();
    350. 		thvs << _lists[i][5].toDouble();
    351. 		nametomsts << _lists[i][6];
    352. 		// nametomsts << QString("%1").arg(_lists[i][6].toAscii().data());
    353. 		zerovals << _lists[i][7].toInt();
    354. 		sampaddrs << _lists[i][8].toInt();
    355. 		sampdevids << _lists[i][9].toInt();
    356. 		explains << _lists[i][10];
    357. 		// explains << QString("%1").arg(_lists[i][10].toAscii().data());
    358. 		_count+=1;
    359. 		if (_count>=200||(i==(_lists.size()-1)))
    360. 		{
    361. 			try{
    362. 				query.prepare(_sql);
    363. 				query.addBindValue(indexids);
    364. 				query.addBindValue(devids);
    365. 				query.addBindValue(names);
    366. 				query.addBindValue(localaddrs);
    367. 				query.addBindValue(coefs);
    368. 				query.addBindValue(thvs);
    369. 				query.addBindValue(nametomsts);
    370. 				query.addBindValue(zerovals);
    371. 				query.addBindValue(sampaddrs);
    372. 				query.addBindValue(sampdevids);
    373. 				query.addBindValue(explains);
    374.  
    375. 				if (!query.execBatch())
    376. 				{
    377. 					qDebug() << query.lastError();
    378. 				}
    379. 			}catch(...){
    380. 				qDebug() << query.lastError();
    381. 			}
    382. 			indexids.clear();
    383. 		    devids.clear();
    384. 		    names.clear();
    385. 		    localaddrs.clear();
    386. 		    coefs.clear();
    387. 		    thvs.clear();
    388. 		    nametomsts.clear();
    389. 		    zerovals.clear();
    390. 		    sampaddrs.clear();
    391. 		    sampdevids.clear();
    392. 		    explains.clear();
    393. 		    _count = 0;
    394. 		}
    395.  
    396. 	}
    397. };
    398.  
    399. void inYx(QSqlDatabase &db,QString _path)
    400. {
    401. 	QVector > _lists;
    402. 	readToVector(_path,_lists,",");
    403.  
    404. 	QSqlQuery query(db);
    405. 	query.exec("DELETE FROM s101yx");
    406.  
    407. 	QVariantList indexids;
    408. 	QVariantList devids;
    409. 	QVariantList names;
    410. 	QVariantList localaddrs;
    411. 	QVariantList nots;
    412. 	QVariantList sampdevids;
    413. 	QVariantList sampaddrs;
    414. 	QVariantList nametomsts;
    415.  
    416. 	int _count = 0;
    417. 	QString _sql = "INSERT INTO s101yx (INDEXID,DEVID,NAME,LOCALADDR,\"NOT\",SAMPDEVID,SAMPADDR,NAMETOMST) "
    418. 			       "VALUES (?,?,?,?,?,?,?,?)";
    419.  
    420. 	for (int i = 0; i < _lists.size(); i++)
    421. 	{
    422. 		if (8!=_lists[i].size())
    423. 		{
    424. 			continue;
    425. 		}
    426. 		indexids << _lists[i][0].toInt();
    427. 		devids << _lists[i][1].toInt();
    428. 		names << _lists[i][2];
    429. 		// names << QString("%1").arg(_lists[i][2].toAscii().data());
    430. 		localaddrs << _lists[i][3].toInt();
    431. 		nots << _lists[i][4].toInt();
    432. 		sampdevids << _lists[i][5].toInt();
    433. 		sampaddrs << _lists[i][6].toInt();
    434. 		nametomsts << _lists[i][7];
    435. 		// nametomsts << QString("%1").arg(_lists[i][7].toAscii().data());
    436.  
    437. 		_count+=1;
    438. 		if (_count>=200||(i==(_lists.size()-1)))
    439. 		{
    440. 			try{
    441. 				query.prepare(_sql);
    442. 				query.addBindValue(indexids);
    443. 				query.addBindValue(devids);
    444. 				query.addBindValue(names);
    445. 				query.addBindValue(localaddrs);
    446. 				query.addBindValue(nots);
    447. 				query.addBindValue(sampdevids);
    448. 				query.addBindValue(sampaddrs);
    449. 				query.addBindValue(nametomsts);
    450.  
    451. 				if (!query.execBatch())
    452. 				{
    453. 					qDebug() << query.lastError();
    454. 				}
    455. 			}catch(...){
    456. 				qDebug() << query.lastError();
    457. 			}
    458. 			indexids.clear();
    459. 		    devids.clear();
    460. 		    names.clear();
    461. 		    localaddrs.clear();
    462. 		    nots.clear();
    463. 		    sampdevids.clear();
    464. 		    sampaddrs.clear();
    465. 		    nametomsts.clear();
    466.  
    467. 		    _count = 0;
    468. 		}
    469. 	}
    470. };
    471.  
    472. void inYk(QSqlDatabase &db,QString _path)
    473. {
    474. 	QVector > _lists;
    475. 	readToVector(_path,_lists,",");
    476.  
    477. 	QSqlQuery query(db);
    478. 	query.exec("DELETE FROM s101yk");
    479.  
    480. 	QVariantList indexids;
    481. 	QVariantList localaddrs;
    482. 	QVariantList devids;
    483. 	QVariantList names;
    484. 	QVariantList sampaddrs;
    485. 	QVariantList sampdevids;
    486. 	QVariantList nametomsts;
    487.  
    488. 	int _count = 0;
    489. 	QString _sql = "INSERT INTO s101yk (INDEXID,LOCALADDR,DEVID,NAME,SAMPADDR,SAMPDEVID,NAMETOMST) "
    490. 			       "VALUES (?,?,?,?,?,?,?)";
    491.  
    492. 	for (int i = 0; i < _lists.size(); i++)
    493. 	{
    494. 		if (7!=_lists[i].size())
    495. 		{
    496. 			continue;
    497. 		}
    498. 		indexids << _lists[i][0].toInt();
    499. 		localaddrs << _lists[i][1].toInt();
    500. 		devids << _lists[i][2].toInt();
    501. 		names << _lists[i][3];
    502. 		// names << QString("%1").arg(_lists[i][3].toAscii().data());
    503. 		sampaddrs << _lists[i][4].toInt();
    504. 		sampdevids << _lists[i][5].toInt();
    505. 		nametomsts << _lists[i][6];
    506. 		// nametomsts << QString("%1").arg(_lists[i][6].toAscii().data());
    507.  
    508. 		_count+=1;
    509. 		if (_count>=200||(i==(_lists.size()-1)))
    510. 		{
    511. 			try{
    512. 				query.prepare(_sql);
    513. 				query.addBindValue(indexids);
    514. 				query.addBindValue(localaddrs);
    515. 				query.addBindValue(devids);
    516. 				query.addBindValue(names);
    517. 				query.addBindValue(sampaddrs);
    518. 				query.addBindValue(sampdevids);
    519. 				query.addBindValue(nametomsts);
    520.  
    521. 				if (!query.execBatch())
    522. 				{
    523. 					qDebug() << query.lastError();
    524. 				}
    525. 			}catch(...){
    526. 				qDebug() << query.lastError();
    527. 			}
    528. 			indexids.clear();
    529. 			localaddrs.clear();
    530. 		    devids.clear();
    531. 		    names.clear();
    532. 		    sampaddrs.clear();
    533. 		    sampdevids.clear();
    534. 		    nametomsts.clear();
    535.  
    536. 		    _count = 0;
    537. 		}
    538. 	}
    539. };
    540.  
    541. void inYt(QSqlDatabase &db,QString _path)
    542. {
    543. 	QVector > _lists;
    544. 	readToVector(_path,_lists,",");
    545.  
    546. 	QSqlQuery query(db);
    547. 	query.exec("DELETE FROM s101yt");
    548.  
    549. 	QVariantList indexids;
    550. 	QVariantList localaddrs;
    551. 	QVariantList devids;
    552. 	QVariantList names;
    553. 	QVariantList sampaddrs;
    554. 	QVariantList sampdevids;
    555. 	QVariantList nametomsts;
    556.  
    557. 	int _count = 0;
    558. 	QString _sql = "INSERT INTO s101yt (INDEXID,LOCALADDR,DEVID,NAME,SAMPADDR,SAMPDEVID,NAMETOMST) "
    559. 			       "VALUES (?,?,?,?,?,?,?)";
    560.  
    561. 	for (int i = 0; i < _lists.size(); i++)
    562. 	{
    563. 		if (7!=_lists[i].size())
    564. 		{
    565. 			continue;
    566. 		}
    567. 		indexids << _lists[i][0].toInt();
    568. 		localaddrs << _lists[i][1].toInt();
    569. 		devids << _lists[i][2].toInt();
    570. 		names << _lists[i][3];
    571. 		// names << QString("%1").arg(_lists[i][3].toAscii().data());
    572. 		sampaddrs << _lists[i][4].toInt();
    573. 		sampdevids << _lists[i][5].toInt();
    574. 		nametomsts << _lists[i][6];
    575. 		// nametomsts << QString("%1").arg(_lists[i][6].toAscii().data());
    576.  
    577. 		_count+=1;
    578. 		if (_count>=200||(i==(_lists.size()-1)))
    579. 		{
    580. 			try{
    581. 				query.prepare(_sql);
    582. 				query.addBindValue(indexids);
    583. 				query.addBindValue(localaddrs);
    584. 				query.addBindValue(devids);
    585. 				query.addBindValue(names);
    586. 				query.addBindValue(sampaddrs);
    587. 				query.addBindValue(sampdevids);
    588. 				query.addBindValue(nametomsts);
    589.  
    590. 				if (!query.execBatch())
    591. 				{
    592. 					qDebug() << query.lastError();
    593. 				}
    594. 			}catch(...){
    595. 				qDebug() << query.lastError();
    596. 			}
    597. 			indexids.clear();
    598. 			localaddrs.clear();
    599. 		    devids.clear();
    600. 		    names.clear();
    601. 		    sampaddrs.clear();
    602. 		    sampdevids.clear();
    603. 		    nametomsts.clear();
    604.  
    605. 		    _count = 0;
    606. 		}
    607. 	}
    608. };
    609.  
    610. void InOrOutConf::scvToDB()
    611. {
    612. 	QString _dbn = this->pathEdit->text();
    613. 	QFile _file(_dbn);
    614. 	if (!_file.exists())
    615. 	{
    616. 		warLabel->setText("db isn't exist!");
    617. 		return;
    618. 	}
    619.  
    620. 	QSqlDatabase db;
    621. 	if(!checkdb_etconf(db,_dbn))
    622. 	{
    623. 		warLabel->setText("db isn't table we need!");
    624. 		return;
    625. 	}
    626. 	warLabel->setText("csv to db runing!");
    627. 	inYc(db,this->dirEdit->text()+divPath+"s101yc.csv");
    628. 	inYx(db,this->dirEdit->text()+divPath+"s101yx.csv");
    629. 	inYk(db,this->dirEdit->text()+divPath+"s101yk.csv");
    630. 	inYt(db,this->dirEdit->text()+divPath+"s101yt.csv");
    631. 	warLabel->setText("csv to db finish!");
    632. 	db.close();
    633. };
    634.  
    635. bool writeListInfo(QVector list,const QString path,bool appendf)
    636. {
    637.     QFile f(path);
    638.     if(!f.open(QFile::WriteOnly | QFile::Text | (appendf?QFile::Append:QFile::Truncate)))
    639.         return false;
    640.  
    641.     QTextStream out(&f);
    642.  
    643.     // out.setCodec("UTF-8"); //中文编码
    644.     for (int i = 0; i < list.size(); i++)
    645.     {
    646.         out << QString(list[i]);
    647.     }
    648.     f.close();
    649.     return true;
    650. };
    651.  
    652. void outYc(QSqlDatabase &db,QString _path)
    653. {
    654. 	QSqlQuery query(db);
    655.  
    656. 	QString _sql = "select INDEXID,DEVID,NAME,LOCALADDR,COEF,THV,NAMETOMST,ZEROVAL,SAMPADDR,SAMPDEVID,EXPLAIN from s101yc";
    657. 	query.prepare(_sql);
    658. 	query.exec();
    659. 	
    660. 	QVector list;
    661. 	QString _sb =  QObject::tr("shebei");
    662. 	QString _cj = QObject::tr("caiji");
    663. 	while (query.next()) {
    664. 		QString _line = "";
    665. 		for (int i = 0; i < 11; i++)
    666. 		{
    667. 			_line+=query.value(i).toString();
    668. 			if (i!=10)
    669. 			{
    670. 				_line+=",";
    671. 			}
    672. 		}
    673. 		_line+="\n";
    674. 		// _line = QString("%1").arg(ASCII2UTF_8(_line.toStdString()).c_str());
    675. 		// _line.replace(QString("??"), _sb);
    676. 		// _line.replace(QString("?"), _cj);
    677. 		list.push_back(_line);
    678. 		// char *buf= new char[512];
    679. 		// buf = G2U(_line.toStdString().c_str());
    680. 		// list.push_back( QString("%1").arg(buf));
    681. 		// qDebug()<<"_line="<<_line<<"\n";
    682. 		// qDebug()<<"_line_utf="<
    683. 		if (list.size()>1000)
    684. 		{
    685. 			writeListInfo(list,_path,true);
    686. 			list.clear();
    687. 		}
    688. 	}
    689. 	writeListInfo(list,_path,true);
    690. 	list.clear();
    691. };
    692.  
    693. void outYx(QSqlDatabase &db,QString _path)
    694. {
    695. 	QSqlQuery query(db);
    696.  
    697. 	QString _sql = "select INDEXID,DEVID,NAME,LOCALADDR,\"NOT\",SAMPDEVID,SAMPADDR,NAMETOMST from s101yx";
    698. 	query.prepare(_sql);
    699. 	query.exec();
    700. 	
    701. 	QVector list;
    702. 	while (query.next()) {
    703. 		QString _line = "";
    704. 		for (int i = 0; i < 8; i++)
    705. 		{
    706. 			_line+=query.value(i).toString();
    707. 			if (i!=7)
    708. 			{
    709. 				_line+=",";
    710. 			}
    711. 		}
    712. 		_line+="\n";
    713. 		// _line = QString("%1").arg(ASCII2UTF_8(_line.toStdString()).c_str());
    714. 		// _line.replace(QString("??"), QObject::tr("shebei"));
    715. 		// _line.replace(QString("?"), QObject::tr("caiji"));
    716. 		list.push_back(_line);
    717. 		// char *buf= new char[512];
    718. 		// buf = G2U(_line.toStdString().c_str());
    719. 		// list.push_back( QString("%1").arg(buf));
    720. 		// qDebug()<<"_line="<<_line<<"\n";
    721. 		// qDebug()<<"_line_utf="<
    722. 		if (list.size()>1000)
    723. 		{
    724. 			writeListInfo(list,_path,true);
    725. 			list.clear();
    726. 		}
    727. 	}
    728. 	writeListInfo(list,_path,true);
    729. 	list.clear();
    730. };
    731.  
    732. void outYk(QSqlDatabase &db,QString _path)
    733. {
    734. 	QSqlQuery query(db);
    735.  
    736. 	QString _sql = "select INDEXID,LOCALADDR,DEVID,NAME,SAMPADDR,SAMPDEVID,NAMETOMST from s101yk";
    737. 	query.prepare(_sql);
    738. 	query.exec();
    739. 	
    740. 	QVector list;
    741. 	while (query.next()) {
    742. 		QString _line = "";
    743. 		for (int i = 0; i < 7; i++)
    744. 		{
    745. 			_line+=query.value(i).toString();
    746. 			if (i!=6)
    747. 			{
    748. 				_line+=",";
    749. 			}
    750. 		}
    751. 		_line+="\n";
    752. 		// _line = QString("%1").arg(ASCII2UTF_8(_line.toStdString()).c_str());
    753. 		// _line.replace(QString("??"), QObject::tr("shebei"));
    754. 		// _line.replace(QString("?"), QObject::tr("caiji"));
    755. 		list.push_back(_line);
    756. 		// char *buf= new char[512];
    757. 		// buf = G2U(_line.toStdString().c_str());
    758. 		// list.push_back( QString("%1").arg(buf));
    759. 		// qDebug()<<"_line="<<_line<<"\n";
    760. 		// qDebug()<<"_line_utf="<
    761. 		if (list.size()>1000)
    762. 		{
    763. 			writeListInfo(list,_path,true);
    764. 			list.clear();
    765. 		}
    766. 	}
    767. 	writeListInfo(list,_path,true);
    768. 	list.clear();
    769. };
    770.  
    771. void outYt(QSqlDatabase &db,QString _path)
    772. {
    773. 	QSqlQuery query(db);
    774.  
    775. 	QString _sql = "select INDEXID,LOCALADDR,DEVID,NAME,SAMPADDR,SAMPDEVID,NAMETOMST from s101yt";
    776. 	query.prepare(_sql);
    777. 	query.exec();
    778. 	
    779. 	QVector list;
    780. 	while (query.next()) {
    781. 		QString _line = "";
    782. 		for (int i = 0; i < 7; i++)
    783. 		{
    784. 			_line+=query.value(i).toString();
    785. 			if (i!=6)
    786. 			{
    787. 				_line+=",";
    788. 			}
    789. 		}
    790. 		_line+="\n";
    791. 		// _line = QString("%1").arg(ASCII2UTF_8(_line.toStdString()).c_str());
    792. 		// _line.replace(QString("??"), QObject::tr("shebei"));
    793. 		// _line.replace(QString("?"), QObject::tr("caiji"));
    794. 		list.push_back(_line);
    795. 		// char *buf= new char[512];
    796. 		// buf = G2U(_line.toStdString().c_str());
    797. 		// list.push_back( QString("%1").arg(buf));
    798. 		// qDebug()<<"_line="<<_line<<"\n";
    799. 		// qDebug()<<"_line_utf="<
    800. 		if (list.size()>1000)
    801. 		{
    802. 			writeListInfo(list,_path,true);
    803. 			list.clear();
    804. 		}
    805. 	}
    806. 	writeListInfo(list,_path,true);
    807. 	list.clear();
    808. };
    809. void InOrOutConf::DBToCsv()
    810. {
    811. 	QString _dbn = this->pathEdit->text();
    812. 	QFile _file(_dbn);
    813. 	if (!_file.exists())
    814. 	{
    815. 		warLabel->setText("db isn't exist!");
    816. 		return;
    817. 	}
    818. 	// s101yc * ycs = new s101yc[10];
    819. 	// int ret = GetS101yc(_dbn.toStdString().c_str(),"",ycs,10);
    820. 	// if(ret>0){
    821. 	// 	for (int i = 0; i < ret; i++)
    822. 	// 	{
    823. 	// 		qDebug() <<  QString("%1").arg(ycs[i].NAME)<<"\n";
    824. 	// 		qDebug() <<  QString("%1").arg(G2U(ycs[i].NAME))<<"\n";
    825. 	// 		qDebug() <<  QString("%1").arg(U2G(ycs[i].NAME))<<"\n";
    826. 	// 		qDebug() <<  QString("%1").arg(ASCII2UTF_8(std::string(ycs[i].NAME)).c_str())<<"\n";
    827. 	// 		qDebug() <<  QString("%1").arg(UTF_82ASCII(std::string(ycs[i].NAME)).c_str())<<"\n";
    828. 	// 	}
    829. 	// }
    830.  
    831. 	QSqlDatabase db;
    832. 	if(!checkdb_etconf(db,_dbn))
    833. 	{
    834. 		warLabel->setText("db isn't table we need!");
    835. 		return;
    836. 	}
    837. 	warLabel->setText("db to csv runing!");
    838. 	outYc(db,this->dirEdit->text()+divPath+"s101yc.csv");
    839. 	outYx(db,this->dirEdit->text()+divPath+"s101yx.csv");
    840. 	outYk(db,this->dirEdit->text()+divPath+"s101yk.csv");
    841. 	outYt(db,this->dirEdit->text()+divPath+"s101yt.csv");
    842. 	warLabel->setText("db to csv finish!");
    843. 	db.close();
    844. };
    845.

    main.cpp

    1. #include 
    2. #include 
    3. #include 
    4.  
    5. #include "view/inOrOutConf.h"
    6. //主函数入口
    7. int main(int argc, char *argv[])
    8. {
    9. 	//app构造
    10.     QApplication app(argc, argv);
    11.  
    12.     //languages translation, main event is translate Marco tr("")
    13.     QTranslator translator;
    14.     //装载翻译文件
    15.     //lupdate *.pro导出源文代码
    16.     translator.load(":/languages/dbInOrOut_cn.qm");
    17.     //app.setFont(QFont("wenquanyi")); //set font stype lib
    18.     app.installTranslator(&translator);
    19.     // //设置本地语言
    20.     // QTextCodec::setCodecForLocale(QTextCodec::codecForLocale());
    21.     // QTextCodec::setCodecForCStrings(QTextCodec::codecForLocale());
    22.     // QTextCodec::setCodecForTr(QTextCodec::codecForLocale());
    23.  
    24.     InOrOutConf w;
    25.     w.show();
    26. 	return app.exec();
    27. }

    四、编译及测试

            qmake -o Makefile dbIntOrOut.pro && make debug | make release(win use nmake)

            运行效果如下：

     五、附件

            上面已近给出了全部源码，如果还是无法建立工程，以下是完整工程代码下载连接：

    qt实现的sqlites数据库文件与csv文件相互转换案例代码-C++文档类资源-CSDN下载

  • 相关阅读:
    智慧用电解决方案-最新全套文件
    Java开发琐碎语法（长期更新）
    Android驱动开发之如何编译和更换内核
    【会议资源】2022年第三届自动化科学与工程国际会议（JCASE 2022）
    java并发数据结构之CopyOnWriteArrayList
    前端之一阶段[HTML、CSS]问题记录
    python数据分析小案例：把招聘数据做可视化处理~
    潮流来袭！中国首届虚拟艺术巡展NFS将在广州YCC!天宜盛大开启！
    JS - WebAPI 基础
    Kotlin协程：挂起与恢复原理逆向刨析
  • 原文地址：https://blog.csdn.net/py8105/article/details/127133837