Пример #1
0
 /**
  * 往Password表中添加记录
  *
  * @param passwordInfo
  */
 public void insert(PasswordInfo passwordInfo) throws SQLException {
   synchronized (dbHelper) {
     SQLiteDatabase db = dbHelper.getWritableDatabase();
     // 为了防止SQL注入,输入的参数用?来占位符来指定
     String addSql = "insert into password (password , question , answer , flag) values (?,?,?,?)";
     try {
       db.execSQL(
           addSql,
           new Object[] {
             passwordInfo.getPassword(),
             passwordInfo.getQuestion(),
             passwordInfo.getAnswer(),
             passwordInfo.getFlag()
           });
     } catch (Exception e) {
       e.printStackTrace();
     } finally {
       db.close();
     }
     Log.i(TAG, "insert");
   }
 }
Пример #2
0
 /**
  * 更新password表中的记录
  *
  * @throws SQLException
  */
 public void update(PasswordInfo passwordInfo) throws SQLException {
   synchronized (dbHelper) {
     SQLiteDatabase db = dbHelper.getWritableDatabase();
     passwordInfo.set_id(1);
     String updateSql =
         "update "
             + PasswordTable.TABLE_NAME
             + " SET "
             + PasswordTable.PASSWORD
             + " = '"
             + passwordInfo.getPassword()
             + "',"
             + PasswordTable.QUESTION
             + " = '"
             + passwordInfo.getQuestion()
             + "',"
             + PasswordTable.ANSWER
             + " = '"
             + passwordInfo.getAnswer()
             + "',"
             + PasswordTable.FLAG
             + " = "
             + passwordInfo.getFlag()
             + " WHERE "
             + PasswordTable._ID
             + " = "
             + passwordInfo.get_id();
     try {
       db.execSQL(updateSql);
     } catch (Exception e) {
       e.printStackTrace();
     } finally {
       db.close();
     }
     Log.i(TAG, "update");
   }
 }