qt 封装的类 表根据字段名和值 生成sql语句

#include "csqlfile.h" #include <QVector> cSqlFile::cSqlFile( ) { } cSqlFile::~cSqlFile( ) { m_file.close(); } bool cSqlFile::openFile( QString &name, QString& dataBase ) { m_file.setFileName( name ); if( !m_file.open(QIODevice::WriteOnly|QIODevice::Text ) ) return false; m_outStream.setDevice( &m_file ); m_outStream << "USE `"; m_outStream << dataBase; m_outStream << "`;\n"; return true; } int cSqlFile::insertData( QString &table, QVector< QVector < QString> >& data, QVector<int>& dataType, QVector < QString>* pField ) { int typeLen = dataType.size(); int size = data.size(); if( typeLen < 1 || size < 1 ) return -1; if( NULL != pField && typeLen != pField->size() ) return -2; int i = 0, j =0 ; QString str("LOCK TABLES `"); str += table; str += "` WRITE;\n"; //QString strTemp; str += "INSERT INTO `"; str += table; if ( NULL == pField) { str += "` VALUES "; } else { str += "` "; for(i =0;i<typeLen;i++) { if ( 0 == i ) str += "("; str += pField->at(i); if( typeLen-1 == j) str += ")"; else str += ","; } str += " VALUES "; } for(i =0;i<size;i++) { int lenTemp = data[i].size(); if( typeLen != lenTemp ) return -3; if ( 0 != i ) str += ","; for( j =0;j<typeLen;j++ ) { if ( 0 == j ) str += "("; switch (dataType[j]) { case 0://整型 double 浮点型 str += data[i][j]; break; case 1: //字符串 日期时间类型 str += "'"; str += data[i][j]; str += "'"; break; } if( typeLen-1 == j) str += ")"; else str += ","; } } str += ";\n"; str += "UNLOCK TABLES;\n"; m_outStream << str; //m_outStream.flush(); return 0; }