99久久99久久,国产日产久久高清欧美一区,久久国产高清一区二区三区

LingosHook:wxSQLite3不錯

??? Lingoes界面上的‘語言’字串可以選擇不同的語言，這樣導(dǎo)致其窗口的‘標題’不同，因此對于不同‘語言’界面的Lngoes還需要使用不同的字串傳給FindWndow。這個開始還真沒注意。
??? 另一個問題，當前沒有找到好的HTML Parser，于是打算采用直接分解‘text’的方式獲得結(jié)果。這樣做會使結(jié)果的處理非常的‘受限’，比如如果選擇了多個詞典，text方式處理起來就非常麻煩了。因此當前就先采用‘text’方式，處理一個默認字典先。
??? 今天發(fā)現(xiàn)wxSQLite3好用，和其封裝MySQL++類似，又能迎合wxWidgets的類型，用起來比較順手。今天的主要動作也是集中在LingosHook本地數(shù)據(jù)庫的設(shè)計和訪問接口的實現(xiàn)上，應(yīng)該說寫好了，就差合并使用了，這個明天再說吧。

??? wxSQLite3相關(guān)代碼如下,記錄一下，下次再用wxSQLite3就有參考了。第一次用，有錯誤再說吧，嘿嘿～

#include?<vector>

#include?"wx/wx.h"

#include?"wx/wxsqlite3.h"

class?CDBAccess

{

public:

????static?const?wxString?TABLENAME_WORD;

????static?const?wxString?TABLENAME_DICTIONARY;

????static?const?wxString?TABLENAME_RESULT;

????static?const?wxString?WORDCLASS_NOUN;

public:

????enum?WordClass?{?WC_UNKNOWN?=?-1,?WC_NOUN?=?0?};

????typedef?std::pair<int,?wxString>?TResultPair;//wordclass?+?result

????typedef?std::vector<TResultPair>?TResultVector;

????typedef?std::pair<wxString,?TResultVector>?TRecordPair;//dictionary+result?vector

????typedef?std::vector<TRecordPair>?TRecordVector;

????typedef?struct?_RecordData_t

????{

????????wxString?m_strWord;

????????wxString?m_strSymbol;

????????TRecordVector?m_vctResult;

????????wxString?m_strHTML;

????}?TRecordData;

public:

????CDBAccess();

????virtual?~CDBAccess();

????int?Init(const?wxString&?dbfile);

????

????int?Insert(const?TRecordData&?record);

????int?Remove(const?wxString&?word);

????int?Search(TRecordData&?record);

protected:

????int?InitTables();

????void?Close();

????int?InsertWordTable(const?TRecordData&?record,?wxLongLong&?id);

????int?InsertDictTable(const?wxString&?dict,?wxLongLong&?id);

????int?InsertResultTable(const?wxLongLong&?wordid,?const?wxLongLong&?dictid,?const?TResultPair&?result);

????WordClass?GetWordClass(const?wxString&?type)?const;

????int?RemoveWordTable(const?wxString&?word,?wxLongLong&?id);

????int?RemoveResultTable(const?wxLongLong&?wordid);

????int?SearchWordTable(TRecordData&?record,?wxLongLong&?id);

????int?SearchResultTable(const?wxLongLong&?wordid,?TRecordData&?record);

????const?wxString?SearchDictTable(const?wxLongLong&?dictid);

protected:

????wxString?_strDBFile;

????wxSQLite3Database?_DB;

};

#include?<map>

#include?"wx/wx.h"

#include?"DBAccess.h"

const?wxString?CDBAccess::TABLENAME_WORD????????????=????_("WordTable");

const?wxString?CDBAccess::TABLENAME_DICTIONARY????????=????_("DictionaryTable");

const?wxString?CDBAccess::TABLENAME_RESULT????????????=????_("ResultTable");

const?wxString?CDBAccess::WORDCLASS_NOUN????????????=????_("n.");

CDBAccess::CDBAccess()

{

}

CDBAccess::~CDBAccess()

{

????Close();

}

int?CDBAccess::Init(const?wxString?&dbfile)

{

????try

????{

????????Close();

????????_DB.Open(dbfile);

????????if(InitTables()?!=?0)

????????????return?-1;

????}

????catch(const?wxSQLite3Exception&?e)

????{

????????return?-1;

????}

????return?0;

}

int?CDBAccess::InitTables()

{

????try

????{

????????const?char*?wordtable?=?"CREATE?TABLE?IF?NOT?EXISTS?WordTable?(ID?INTEGER?PRIMARY?KEY?AUTOINCREMENT,Word?VARCHAR(32)?UNIQUE,Symbol?VARCHAR(64),HTML?TEXT,UpdateTime?DATE)";

????????_DB.ExecuteUpdate(wordtable);

????????const?char*?dicttable?=?"CREATE?TABLE?IF?NOT?EXISTS?DictionaryTable?(ID?INTEGER?PRIMARY?KEY?AUTOINCREMENT,Title?VARCHAR(64),UpdateTime?DATE)";

????????_DB.ExecuteUpdate(dicttable);

????????const?char*?resulttable?=?"CREATE?TABLE?IF?NOT?EXISTS?ResultTable?(WordID?INTEGER,DictID?INTEGER,ClassID?INTEGER,Result?VARCHAR(255))";

????????_DB.ExecuteUpdate(resulttable);

????}

????catch(const?wxSQLite3Exception&?e)

????{

????????return?-1;

????}????

????return?0;

}

void?CDBAccess::Close()

{

????if(_DB.IsOpen())

????????_DB.Close();

}

int?CDBAccess::Insert(const?CDBAccess::TRecordData?&record)

{

????try

????{

????????_DB.Begin();

????????wxLongLong?wordid?=?0;

????????InsertWordTable(record,?wordid);

????????for(TRecordVector::const_iterator?it?=?record.m_vctResult.begin();?it?!=?record.m_vctResult.end();?++?it)

????????{

????????????wxLongLong?dictid?=?0;

????????????InsertDictTable(it->first,?dictid);

????????????for(TResultVector::const_iterator?i?=?it->second.begin();?i?!=?it->second.end();?++?i)

????????????{

????????????????InsertResultTable(wordid,?dictid,?*i);

????????????}

????????}

????????_DB.Commit();

????}

????catch(const?wxSQLite3Exception&?e)

????{

????????_DB.Rollback();

????????return?-1;

????}

????return?0;

}

int?CDBAccess::InsertWordTable(const?CDBAccess::TRecordData?&record,?wxLongLong?&id)

{

????wxSQLite3Statement?query?=?_DB.PrepareStatement("SELECT?ROWID?FROM?WordTable?WHERE?Word?=??");

????query.Bind(1,?record.m_strWord);

????wxSQLite3ResultSet?res?=?query.ExecuteQuery();

????if(!res.IsOk())

????????throw?wxSQLite3Exception(255,?_("SELECT?ROWID?of?WordTable?FAILED."));

????if(!res.Eof())

????{

????????id?=?res.GetInt64(0);

????}

????else

????{

????????wxSQLite3Statement?query?=?_DB.PrepareStatement("INSERT?INTO?WordTable?VALUES(NULL,??,??,??,?DATETIME('NOW',?'LOCALTIME'))");

????????query.Bind(1,?record.m_strWord);

????????query.Bind(2,?record.m_strSymbol);

????????query.Bind(3,?record.m_strHTML);

????????query.ExecuteUpdate();

????????id?=?_DB.GetLastRowId();

????}

????return?0;

}

int?CDBAccess::InsertDictTable(const?wxString&?dict,?wxLongLong?&id)

{

????wxSQLite3Statement?query?=?_DB.PrepareStatement("SELECT?ROWID?FROM?DictionaryTable?WHERE?Title?=??");

????query.Bind(1,?dict);

????wxSQLite3ResultSet?res?=?query.ExecuteQuery();

????if(!res.IsOk())

????????throw?wxSQLite3Exception(255,?_("SELECT?ROWID?of?DictTable?FAILED."));

????if(!res.Eof())

????{

????????id?=?res.GetInt64(0);

????}

????else

????{

????????wxSQLite3Statement?query?=?_DB.PrepareStatement("INSERT?INTO?DictionaryTable?VALUES(NULL,??,?DATETIME('NOW',?'LOCALTIME'))");

????????query.Bind(1,?dict);

????????query.ExecuteUpdate();

????????id?=?_DB.GetLastRowId();

????}

????return?0;

}

int?CDBAccess::InsertResultTable(const?wxLongLong?&wordid,?const?wxLongLong?&dictid,?const?TResultPair&?result)

{

//????WordClass?type?=?GetWordClass(result.first);

????

????wxSQLite3Statement?query?=?_DB.PrepareStatement("INSERT?INTO?ResultTable?VALUES(?,??,??,??)");

????query.Bind(1,?wordid);

????query.Bind(2,?dictid);

????query.Bind(3,?result.first);

????query.Bind(4,?result.second);

????query.ExecuteUpdate();????

????return?0;

}

CDBAccess::WordClass?CDBAccess::GetWordClass(const?wxString?&type)?const

{

????if(type?==?WORDCLASS_NOUN)

????????return?WC_NOUN;

????else

????????return?WC_UNKNOWN;

}

int?CDBAccess::Remove(const?wxString?&word)

{

????try

????{

????????_DB.Begin();

????????

????????wxLongLong?wordid?=?0;

????????RemoveWordTable(word,?wordid);

????????RemoveResultTable(wordid);

????????_DB.Commit();

????}

????catch(const?wxSQLite3Exception&?e)

????{

????????_DB.Rollback();

????????return?-1;

????}

????return?0;

}

int?CDBAccess::RemoveWordTable(const?wxString?&word,?wxLongLong?&id)

{

????wxSQLite3Statement?query?=?_DB.PrepareStatement("SELECT?ROWID?FROM?WordTable?WHERE?Word?=??");

????query.Bind(1,?word);

????wxSQLite3ResultSet?res?=?query.ExecuteQuery();

????if(!res.IsOk())

????????throw?wxSQLite3Exception(255,?_("SELECT?ROWID?of?WordTable?FAILED."));

????if(!res.Eof())

????{

????????id?=?res.GetInt64(0);

????????wxSQLite3Statement?query?=?_DB.PrepareStatement("DELETE?FROM?WordTable?WHERE?ID?=??");

????????query.Bind(1,?id);????????

????????query.ExecuteUpdate();

????}

????else

????{

????????throw?wxSQLite3Exception(254,?_("SELECT?WordTable?FAILED."));

????}

????return?0;

}

int?CDBAccess::RemoveResultTable(const?wxLongLong?&wordid)

{

????wxSQLite3Statement?query?=?_DB.PrepareStatement("DELETE?FROM?ResultTable?WHERE?WordID?=??");

????query.Bind(1,?wordid);????????

????query.ExecuteUpdate();

????return?0;

}

int?CDBAccess::Search(CDBAccess::TRecordData?&record)

{

????try

????{

????????wxLongLong?wordid?=?0;

????????SearchWordTable(record,?wordid);

????????SearchResultTable(wordid,?record);

????}

????catch(const?wxSQLite3Exception&?e)

????{

????????return?-1;

????}

????return?0;

}

int?CDBAccess::SearchWordTable(TRecordData&?record,?wxLongLong?&id)

{

????wxSQLite3Statement?query?=?_DB.PrepareStatement("SELECT?ROWID,Symbol?FROM?WordTable?WHERE?Word?=??");

????query.Bind(1,?record.m_strWord);

????wxSQLite3ResultSet?res?=?query.ExecuteQuery();

????if(!res.IsOk())

????????throw?wxSQLite3Exception(255,?_("SELECT?ROWID?of?WordTable?FAILED."));

????if(!res.Eof())

????{

????????id?=?res.GetInt64(0);

????????record.m_strSymbol?=?res.GetAsString(1);

????}

????else?

????{

????????throw?wxSQLite3Exception(254,?_("SELECT?WordTable?FAILED."));

????}

????return?0;

}

int?CDBAccess::SearchResultTable(const?wxLongLong&?wordid,?CDBAccess::TRecordData&?record)

{

????wxSQLite3Statement?query?=?_DB.PrepareStatement("SELECT?DictID,?ClassID,?Result?FROM?ResultTable?WHERE?wordid?=??");

????query.Bind(1,?wordid);

????wxSQLite3ResultSet?res?=?query.ExecuteQuery();

????if(!res.IsOk())

????????throw?wxSQLite3Exception(255,?_("SELECT?ROWID?of?ResultTable?FAILED."));

????

????std::map<wxLongLong,?TResultVector>?mapResult;

??????? res.NextRow();//add

????while(!res.Eof())

????{

????????wxLongLong?dictid?=?res.GetInt64(0);

????????std::map<wxLongLong,?TResultVector>::iterator?it?=?mapResult.find(dictid);

????????if(it?==?mapResult.end())

????????????it?=?mapResult.insert(std::make_pair(dictid,?TResultVector())).first;

????????it->second.push_back(std::make_pair(res.GetInt(1),?res.GetAsString(2)));

????????res.NextRow();

????}

????for(std::map<wxLongLong,?TResultVector>::const_iterator?it?=?mapResult.begin();?it?!=?mapResult.end();?++?it)

????{

????????wxString?dict?=?SearchDictTable(it->first);

????????record.m_vctResult.push_back(std::make_pair(dict,?it->second));

????}

????return?0;

}

const?wxString?CDBAccess::SearchDictTable(const?wxLongLong?&dictid)

{

????wxSQLite3Statement?query?=?_DB.PrepareStatement("SELECT?Title?FROM?DictionaryTable?WHERE?ID?=??");

????query.Bind(1,?dictid);

????wxSQLite3ResultSet?res?=?query.ExecuteQuery();

????if(!res.IsOk())

????????return?_("FAILED.");

????if(res.Eof())

????????return?_("Unknown.");

????return?res.GetAsString(0);

}

posted on 2009-11-17 18:57 codejie 閱讀(1208) 評論(4) 編輯收藏引用所屬分類: C++

@Liu
我也想MSN啊，但現(xiàn)在的環(huán)境不像咱們以前啊，這里我就發(fā)現(xiàn)不了代理啊。上班對著電腦，一句話不說對我也是折磨啊，好懷念那時一起‘飛揚跋扈’的上班時光。。。
不過咱們MSN聊什么呢？技術(shù)？上班夠無聊的了；MM？年紀都一大把了；小孩？咱們男女不同，用的尿片都不一樣啊。。。你說，咱們除了互相詆毀之外，似乎也沒別的要說了，嘿嘿。。。

另：
我打算收你的閱讀費，不過分吧。。。。回復(fù) 更多評論

# re: LingosHook:wxSQLite3不錯[未登錄] 2009-11-18 14:55 Liu

@codejie

你真是典型的給臉不要臉啊…… 回復(fù) 更多評論

# re: LingosHook:wxSQLite3不錯 2009-11-18 16:30 codejie

@Liu
哇哈哈。。。。

你Y是沒睡呢，還是早起呢，還是在給寶寶泡奶呢？這時間好怪啊～咱們時差到底多少啊～別說你Y又跑到火星去了～回復(fù) 更多評論

刷新評論列表

只有注冊用戶登錄后才能發(fā)表評論。
【推薦】100%開源！大型工業(yè)跨平臺軟件C++源碼提供，建模，組態(tài)！

相關(guān)文章: C++: c++ wrap for libpq Why the inline function can not be covered? LingosHook : Development Environment Setup LingosHook : HTML Data in Android Client LingosHook: CDocumentOutputObject LingosHook : Optimize TinyHtmlParser Class OCI : do NOT debug on TWO different windows LingosHook：Lingoes生詞本第二十五版 LingosHook：1.4.000 and gettext wxWidget：Catch KEY event of wxStaticBitmap.

網(wǎng)站導(dǎo)航: 博客園 IT新聞 BlogJava 博問 Chat2DB 管理

# re: LingosHook:wxSQLite3不錯[未登錄] 2009-11-18 02:08 Liu

# re: LingosHook:wxSQLite3不錯 2009-11-18 10:07 codejie

# re: LingosHook:wxSQLite3不錯[未登錄] 2009-11-18 14:55 Liu

# re: LingosHook:wxSQLite3不錯 2009-11-18 16:30 codejie

Codejie's C++ Space

LingosHook:wxSQLite3不錯

評論

公告

導(dǎo)航

統(tǒng)計

留言簿(73)

隨筆分類(513)

積分與排名

最新評論

閱讀排行榜

評論排行榜