@Override
public void updateWord(Word word) {
Db_Help dbhelper = new Db_Help(mContext);
String query =
"UPDATE tb_words SET vocab='"
+ word.getVocab()
+ "'"
+ ",meaning='"
+ word.getMeaning()
+ "',pronunciation='"
+ word.getPronunciation()
+ "' WHERE _id='"
+ word.getId()
+ "'";
Log.e("DB_QUERY", query);
dbhelper.executeQuery(query);
}
@Override
public void insertWord(Word word) {
Db_Help dbhelper = new Db_Help(mContext);
Common_helper common_helper = new Common_helper(mContext);
String query =
"INSERT INTO tb_words VALUES ('"
+ common_helper.getGUID()
+ "',"
+ "'"
+ word.getVocab()
+ "',"
+ "'"
+ word.getPronunciation()
+ "',"
+ "'"
+ word.getMeaning()
+ "');";
Log.e("DB_QUERY", query);
dbhelper.executeQuery(query);
}
@Override
public void deleteAllWord() {
Db_Help dbhelper = new Db_Help(mContext);
String query = "DELETE FROM tb_words; ";
dbhelper.executeQuery(query);
}
@Override
public void deleteWord(Word word) {
Db_Help dbhelper = new Db_Help(mContext);
String query = "DELETE FROM tb_words where _id='" + word.getId() + "'";
dbhelper.executeQuery(query);
}