private int GetWrongWordsCount()
{
string tableName = GetCurrentLearningWordsTabelName();
MySQLiteHelper sql = MySQLiteHelper.Instance;
// 连接数据库
sql.GetConnectionWith(CommonData.dataBaseName);
// 检查存放指定单词类型的表是否存在（目前只做了测试用的CET4这一个表，添加表使用参考editor文件夹下的DataBaseManager）
if (!sql.CheckTableExist(tableName))
{
Debug.Log("查询的表不存在");
return(0);
}
// 查询当前学习的单词类型中所有背错过的单词数量
string[] ungraspedCondition = new string[] { "ungraspTimes>0" };
int count = sql.GetItemCountOfTable(tableName, ungraspedCondition, true);
sql.CloseAllConnections();
return(count);
}
public static GeneralWord RandomGeneralWord()
{
string tableName = "AllWordsData";
MySQLiteHelper sql = MySQLiteHelper.Instance;
// 连接数据库
sql.GetConnectionWith(CommonData.dataBaseName);
int wordsCount = sql.GetItemCountOfTable(tableName, null, true);
int wordId = Random.Range(0, wordsCount);
string[] conditions = new string[] { string.Format("wordId={0}", wordId) };
IDataReader reader = sql.ReadSpecificRowsOfTable(tableName, null, conditions, true);
reader.Read();
string spell = reader.GetString(1);
string explaination = reader.GetString(2);
// bool valid = reader.GetBoolean (4);
return(new GeneralWord(wordId, spell, explaination));
}
/// <summary>
/// 获取当前词库的单词总数
/// </summary>
/// <returns>The total words count.</returns>
private int GetTotalWordsCount()
{
string tableName = GetCurrentLearningWordsTabelName();
MySQLiteHelper sql = MySQLiteHelper.Instance;
// 连接数据库
sql.GetConnectionWith(CommonData.dataBaseName);
// 检查存放指定单词类型的表是否存在（目前只做了测试用的CET4这一个表，添加表使用参考editor文件夹下的DataBaseManager）
if (!sql.CheckTableExist(tableName))
{
sql.CloseConnection(CommonData.dataBaseName);
return(0);
}
// 查询当前学习的单词类型中的所有单词数量
int count = sql.GetItemCountOfTable(tableName, null, true);
sql.CloseConnection(CommonData.dataBaseName);
return(count);
}
/// <summary>
/// 获取当前词库已学习单词总数
/// </summary>
/// <returns>The current learned words count.</returns>
private int GetCurrentLearnedWordsCount()
{
string tableName = GetCurrentLearningWordsTabelName();
MySQLiteHelper sql = MySQLiteHelper.Instance;
// 连接数据库
sql.GetConnectionWith(CommonData.dataBaseName);
if (!sql.CheckTableExist(tableName))
{
sql.CloseConnection(CommonData.dataBaseName);
return(0);
}
// 查询当前学习的单词类型中的所有单词数量
string[] learnedCondition = { "learnedTimes>0" };
int count = sql.GetItemCountOfTable(tableName, learnedCondition, true);
sql.CloseConnection(CommonData.dataBaseName);
return(count);
}
public static LearnWord RandomWord()
{
LearningInfo learnInfo = LearningInfo.Instance;
int wordId = 0;
if (learnInfo.learnedWordCount != 0)
{
wordId = Random.Range(0, learnInfo.learnedWordCount);
List <LearnWord> learnedWords = learnInfo.GetAllLearnedWords();
return(learnedWords [wordId]);
}
string tableName = string.Empty;
WordType wt = GameManager.Instance.gameDataCenter.gameSettings.wordType;
switch (wt)
{
case WordType.CET4:
tableName = CommonData.CET4Table;
break;
case WordType.CET6:
tableName = "CET6";
break;
case WordType.Daily:
tableName = "Daily";
break;
case WordType.Bussiness:
tableName = "Bussiness";
break;
}
MySQLiteHelper sql = MySQLiteHelper.Instance;
// 连接数据库
sql.GetConnectionWith(CommonData.dataBaseName);
int wordsCount = sql.GetItemCountOfTable(tableName, null, true);
wordId = Random.Range(0, wordsCount);
string[] conditions = new string[] { string.Format("wordId={0}", wordId) };
IDataReader reader = sql.ReadSpecificRowsOfTable(tableName, null, conditions, true);
reader.Read();
string spell = reader.GetString(1);
string explaination = reader.GetString(2);
string phoneticSymbol = reader.GetString(3);
string example = reader.GetString(4);
int learnedTimes = reader.GetInt16(5);
int ungraspTimes = reader.GetInt16(6);
return(new LearnWord(wordId, spell, explaination, phoneticSymbol, example, learnedTimes, ungraspTimes));
}