예제 #1
0
  /**
   * 查找单个的联系人,返回的是一个字符串
   *
   * @param name 要查找用户的姓名
   * @return
   */
  public String find(String name) {

    SQLiteDatabase db = helper.getWritableDatabase(); // 得到数据库

    // Cursor cursor = db.rawQuery("select *from person where name=?;", new String[]{name});
    // //得到查询返回的结果集

    Cursor cursor = db.query("mycard", null, "name=?", new String[] {name}, null, null, null);

    if (cursor.moveToNext()) {

      String name1 = cursor.getString(cursor.getColumnIndex("name"));

      String number1 = cursor.getString(cursor.getColumnIndex("number"));

      return name1 + ":" + number1;

    } else {

      return "该联系人不存在!";
    }

    //		 boolean result = cursor.moveToNext();  //游标移向查找的数据,存在返回true,否则反之。
    //
    //		 cursor.close();
    //		 db.close();
    //		 return result;

  }
예제 #2
0
  /** 添加一条数据 */
  public void add(
      String cardName,
      String name,
      String cellNumber,
      String phoneNumber,
      String email,
      String qq,
      String address,
      String company,
      String remark) {

    SQLiteDatabase db = helper.getWritableDatabase(); // 得到数据库

    //  db.execSQL("insert into person (name,number) values(?,?);", new Object[]{name,number});
    ContentValues values = new ContentValues();
    values.put("cardName", cardName);
    values.put("name", name);
    values.put("cellNumber", cellNumber);
    values.put("phoneNumber", phoneNumber);
    values.put("email", email);
    values.put("qq", qq);
    values.put("address", address);
    values.put("company", company);
    values.put("remark", remark);

    db.insert("mycard", null, values);

    db.close();
  }
예제 #3
0
  /**
   * 更新数据库中数据的属性,忽略联系人的name,
   *
   * @param cardName
   * @param cellNumber
   * @param phoneNumber
   * @param email
   * @param qq
   * @param address
   * @param company
   * @param remark
   * @return
   */
  public int update(
      String cardName,
      String name,
      String cellNumber,
      String phoneNumber,
      String email,
      String qq,
      String address,
      String company,
      String remark) {
    SQLiteDatabase db = helper.getWritableDatabase(); // 得到数据库
    // db.execSQL("update person set number=? where name=?;", new Object[]{number,name});
    ContentValues values = new ContentValues();

    values.put("cardName", cardName);
    values.put("cellNumber", cellNumber);
    values.put("phoneNumber", phoneNumber);
    values.put("email", email);
    values.put("qq", qq);
    values.put("address", address);
    values.put("company", company);
    values.put("remark", remark);

    int numberAffected = db.update("mycard", values, "name=?", new String[] {name}); // 得到修改后影响的行数

    db.close();

    return numberAffected;
  }
예제 #4
0
  /**
   * 查询所有数据,返回一个List集合
   *
   * @return
   */
  @SuppressLint("NewApi")
  public ArrayList<ContactBean> findAll() {
    ArrayList<ContactBean> list = new ArrayList<ContactBean>();
    ContactBean contact;
    SQLiteDatabase db = helper.getWritableDatabase(); // 得到数据库
    // Cursor cursor = db.rawQuery("select *from person", null);
    Cursor cursor =
        db.query(
            "mycard",
            new String[] {
              "id",
              "cardName",
              "name",
              "cellNumber",
              "phoneNumber",
              "email",
              "qq",
              "address",
              "company",
              "remark"
            },
            null,
            null,
            null,
            null,
            null,
            null);
    while (cursor.moveToNext()) {
      // int id = cursor.getInt(cursor.getColumnIndex("id"));
      String cardName = cursor.getString(cursor.getColumnIndex("cardName"));
      String name = cursor.getString(cursor.getColumnIndex("name"));
      String cellNumber = cursor.getString(cursor.getColumnIndex("cellNumber"));
      String phoneNumber = cursor.getString(cursor.getColumnIndex("phoneNumber"));
      String email = cursor.getString(cursor.getColumnIndex("email"));
      String qq = cursor.getString(cursor.getColumnIndex("qq"));
      String address = cursor.getString(cursor.getColumnIndex("address"));
      String company = cursor.getString(cursor.getColumnIndex("company"));
      String remark = cursor.getString(cursor.getColumnIndex("remark"));

      contact =
          new ContactBean(
              cardName, name, cellNumber, phoneNumber, email, qq, address, company, remark);

      list.add(contact);
    }

    cursor.close();
    db.close();
    return list;
  }
예제 #5
0
 /**
  * 删除一条数据
  *
  * @param name 要删除人的名字
  */
 public void delete(String name) {
   SQLiteDatabase db = helper.getWritableDatabase(); // 得到数据库
   //	db.execSQL("delete from person where name=?;", new Object[]{name});
   db.delete("mycard", "name=?", new String[] {name});
   db.close();
 }