static void nativeExecute(JNIEnv* env, jclass clazz, jlong connectionPtr,
jlong statementPtr) {
SQLiteConnection* connection = reinterpret_cast<SQLiteConnection*>(connectionPtr);
sqlite3_stmt* statement = reinterpret_cast<sqlite3_stmt*>(statementPtr);
executeNonQuery(env, connection, statement);
}
int command::executeUpdateByParameter(PCWSTR ptable, PCWSTR pwhere)
{
assert(ptable && m_vecParameter.size() > 0);
std::wstring wsUpdates, wssql(L"UPDATE "), wstr, wsWhere(pwhere);
for (parameter::ArrayType::iterator iter = m_vecParameter.begin(); iter != m_vecParameter.end(); ++iter)
{
wsUpdates += (*iter)->getName() + L"=@" + (*iter)->getName();
if (iter != m_vecParameter.end()-1)
{
wsUpdates += L",";
}
}
wssql += ptable;
wssql += L" SET " + wsUpdates;
//
gtc::stringUtil::trimLeft(wsWhere);
//gtc::convert::trimLeft(wsWhere);
wstr = wsWhere;
//gtc::convert::toUpper(wstr);
gtc::stringUtil::toUpper(wstr);
if(wstr.length() > 6 && wstr.substr(0, 6) == L"WHERE ")
wssql += L" " + wsWhere;
else
wssql += L" WHERE " + wsWhere;
return executeNonQuery(wssql);;
}
static jint nativeExecuteForChangedRowCount(JNIEnv* env, jclass clazz,
jlong connectionPtr, jlong statementPtr) {
SQLiteConnection* connection = reinterpret_cast<SQLiteConnection*>(connectionPtr);
sqlite3_stmt* statement = reinterpret_cast<sqlite3_stmt*>(statementPtr);
int err = executeNonQuery(env, connection, statement);
return err == SQLITE_DONE ? sqlite3_changes(connection->db) : -1;
}
static jlong nativeExecuteForLastInsertedRowId(JNIEnv* env, jclass clazz,
jlong connectionPtr, jlong statementPtr) {
SQLiteConnection* connection = reinterpret_cast<SQLiteConnection*>(connectionPtr);
sqlite3_stmt* statement = reinterpret_cast<sqlite3_stmt*>(statementPtr);
int err = executeNonQuery(env, connection, statement);
return err == SQLITE_DONE && sqlite3_changes(connection->db) > 0
? sqlite3_last_insert_rowid(connection->db) : -1;
}
int command::executeInsertByParameter(PCWSTR ptable)
{
assert(ptable && m_vecParameter.size() > 0);
std::wstring wsFields, wsValues, wssql(L"INSERT INTO ");
for (parameter::ArrayType::iterator iter = m_vecParameter.begin(); iter != m_vecParameter.end(); ++iter)
{
wsFields += (*iter)->getName();
wsValues += L"@" + (*iter)->getName();
if (iter != m_vecParameter.end()-1)
{
wsFields += L",";
wsValues += L",";
}
}
wssql += ptable;
wssql += L"(" + wsFields + L") VALUES(" + wsValues + L")";
return executeNonQuery(wssql);
}
bool StageInfo::deleteTableStageInfo(){
return executeNonQuery(getDeleteTableQuery());
}
bool StageInfo::updateStageInfo(){
return executeNonQuery(getUpdateQuery());
}
bool StageInfo::insertStageInfo(){
return executeNonQuery(getInsertQuery());
}
