基于Android Studio开发的单词本APP源码（安卓期末大作业）.zip

package com.example.dao; import android.content.ContentValues; import android.content.Context; import android.database.Cursor; import android.database.sqlite.SQLiteDatabase; import com.example.model.Word; import com.example.model.WordRecord; import java.util.ArrayList; import java.util.Iterator; import java.util.List; import java.util.Map; import java.util.Random; import java.util.TreeMap; public class WordRecordDao { private DBOpenHelper helper; private SQLiteDatabase db; private Context context; //构造方法 public WordRecordDao(Context context){ this.context=context; } //添加方法 public void add(WordRecord wordRecord) { helper=new DBOpenHelper(context); db=helper.getReadableDatabase(); ContentValues values=new ContentValues(); values.put("wordId", wordRecord.getWordId()); values.put("isFalse", wordRecord.getIsFalse()); values.put("isFlag", wordRecord.getIsFlag()); values.put("reperaNum", wordRecord.getReperaNum()); values.put("timeFirst", wordRecord.getTimeFirst()); values.put("timeFinish", wordRecord.getTimeFinish()); db.insert("tb_wordrecord",null,values); //关闭数据库 db.close(); helper.close(); } //更新方法 public void update(WordRecord wordRecord) { helper=new DBOpenHelper(context); db=helper.getReadableDatabase(); ContentValues values=new ContentValues(); values.put("wordId", wordRecord.getWordId()); values.put("isFalse", wordRecord.getIsFalse()); values.put("isFlag", wordRecord.getIsFlag()); values.put("reperaNum", wordRecord.getReperaNum()); values.put("timeFirst", wordRecord.getTimeFirst()); values.put("timeFinish", wordRecord.getTimeFinish()); db.update("tb_wordrecord",values,"wordId=?",new String[]{String.valueOf(wordRecord.getWordId())}); //关闭数据库 db.close(); helper.close(); } //查找方法 public WordRecord find(Word word) { helper=new DBOpenHelper(context); db=helper.getReadableDatabase(); String sql="select * from tb_wordrecord where wordId=?"; Cursor cursor=db.rawQuery(sql,new String[]{String.valueOf(word.get_id())}); if (cursor.moveToNext()){ int _id=cursor.getInt(cursor.getColumnIndex("_id")); int wordId=cursor.getInt(cursor.getColumnIndex("wordId")); int isFalse=cursor.getInt(cursor.getColumnIndex("isFalse")); int isFlag=cursor.getInt(cursor.getColumnIndex("isFlag")); int reperaNum=cursor.getInt(cursor.getColumnIndex("reperaNum")); long timeFirst=cursor.getLong(cursor.getColumnIndex("timeFirst")); long timeFinish=cursor.getLong(cursor.getColumnIndex("timeFinish")); WordRecord wordRecord =new WordRecord(_id,wordId,isFalse,isFlag,reperaNum,timeFirst,timeFinish); //关闭游标和数据库 cursor.close(); db.close(); helper.close(); return wordRecord; } //关闭游标和数据库 cursor.close(); db.close(); helper.close(); return null; } //返回本难度所有背过的单词数据 public List<Word> getLearnedWords() { List<Word> words_list=new ArrayList<Word>(); helper=new DBOpenHelper(context); db=helper.getReadableDatabase(); SettingDao settingDao=new SettingDao(context); String type=settingDao.getDifficulty(); String sql="select * from tb_word,tb_wordrecord where tb_word._id=tb_wordrecord.wordId and tb_word.wordType=? and reperaNum>0"; Cursor cursor=db.rawQuery(sql,new String[]{type}); while (cursor.moveToNext()){ int _id=cursor.getInt(cursor.getColumnIndex("wordId")); int wordRank=cursor.getInt(cursor.getColumnIndex("wordRank")); String headWord=cursor.getString(cursor.getColumnIndex("headWord")); String sentences=cursor.getString(cursor.getColumnIndex("sentences")); String usphone=cursor.getString(cursor.getColumnIndex("usphone")); String ukphone=cursor.getString(cursor.getColumnIndex("ukphone")); String syno=cursor.getString(cursor.getColumnIndex("syno")); String phrases=cursor.getString(cursor.getColumnIndex("phrases")); String tranCN=cursor.getString(cursor.getColumnIndex("tranCN")); String tranEN=cursor.getString(cursor.getColumnIndex("tranEN")); String wordType=cursor.getString(cursor.getColumnIndex("wordType")); Word word=new Word(_id,wordRank,headWord,sentences,usphone,ukphone,syno,phrases,tranCN,tranEN,wordType); words_list.add(word); } cursor.close(); db.close(); helper.close(); return words_list; } //返回本难度所有背过的单词数据 public List<Word> getLearnedWords(String type) { List<Word> words_list=new ArrayList<Word>(); helper=new DBOpenHelper(context); db=helper.getReadableDatabase(); String sql="select * from tb_word,tb_wordrecord where tb_word._id=tb_wordrecord.wordId and tb_word.wordType=? and reperaNum>0"; Cursor cursor=db.rawQuery(sql,new String[]{type}); while (cursor.moveToNext()){ int _id=cursor.getInt(cursor.getColumnIndex("wordId")); int wordRank=cursor.getInt(cursor.getColumnIndex("wordRank")); String headWord=cursor.getString(cursor.getColumnIndex("headWord")); String sentences=cursor.getString(cursor.getColumnIndex("sentences")); String usphone=cursor.getString(cursor.getColumnIndex("usphone")); String ukphone=cursor.getString(cursor.getColumnIndex("ukphone")); String syno=cursor.getString(cursor.getColumnIndex("syno")); String phrases=cursor.getString(cursor.getColumnIndex("phrases")); String tranCN=cursor.getString(cursor.getColumnIndex("tranCN")); String tranEN=cursor.getString(cursor.getColumnIndex("tranEN")); String wordType=cursor.getString(cursor.getColumnIndex("wordType")); Word word=new Word(_id,wordRank,headWord,sentences,usphone,ukphone,syno,phrases,tranCN,tranEN,wordType); words_list.add(word); } cursor.close(); db.close(); helper.close(); return words_list; } //返回本难度需复习的单词数据 public List<Word> getNeedReWords(int todayneedreview) { List<Word> words_list=new ArrayList<Word>(); helper=new DBOpenHelper(context); db=helper.getReadableDatabase(); SettingDao settingDao=new SettingDao(context); String type=settingDao.getDifficulty(); String sql="select * from tb_word,tb_wordrecord where tb_word._id=tb_wordrecord.wordId and reperaNum<5 and reperaNum>=1 and tb_word.wordType=? order by timeFirst ASC limit ?"; Cursor cursor=db.rawQuery(sql,new String[]{type,String.valueOf(todayneedreview)}); while (cursor.moveToNext()){ int _id=cursor.getInt(cursor.getColumnIndex("wordId")); int wordRank=cursor.getInt(cursor.getColumnIndex("wordRank")); String headWord=cursor.getString(cursor.getColumnIndex("headWord")); String sentences=cursor.getString(cursor.getColumnIndex("sentences")); String usphone=cursor.getString(cursor.getColumnIndex("usphone")); String ukphone=cursor.getString(cursor.getColumnIndex("ukphone")); String syno=cursor.getString(cursor.getColumnIndex("syno")); String phrases=cursor.getString(cursor.getColumnIndex("phrases")); String tranCN=cursor.getString(cursor.getColumnIndex("tranCN")); String tranEN=cursor.getString(cursor.getColumnIndex("tranEN")); String wordType=cursor.getString(cur