/**
* 添加到程序所里面
*
* @param packageName 包名
*/
public void add(String packageName) {
SQLiteDatabase db = helper.getWritableDatabase();
ContentValues values = new ContentValues();
values.put("packagename", packageName);
db.insert("info", null, values);
db.close();
}
/**
* 查询全部的锁定的包名
*
* @return
*/
public List<String> findAll() {
SQLiteDatabase db = helper.getReadableDatabase();
Cursor cursor = db.query("info", new String[] {"packagename"}, null, null, null, null, null);
List<String> packnames = new ArrayList<String>();
while (cursor.moveToNext()) {
packnames.add(cursor.getString(0));
}
cursor.close();
db.close();
return packnames;
}
/**
* 查询当前的包是否在程序锁里面
*
* @param packageName
* @return
*/
public boolean find(String packageName) {
boolean result = false;
SQLiteDatabase db = helper.getReadableDatabase();
Cursor cursor =
db.query("info", null, "packagename=?", new String[] {packageName}, null, null, null);
if (cursor.moveToNext()) {
result = true;
}
cursor.close();
db.close();
return result;
}
/**
* 从程序锁里面删除当前的包
*
* @param packageName
*/
public void delete(String packageName) {
SQLiteDatabase db = helper.getWritableDatabase();
db.delete("info", "packagename=?", new String[] {packageName});
db.close();
}