public void insertSQL(String url, String Key, int good, int bad, int collect) {
String SQL =
"insert into "
+ DetailColumn.TABLE_NAME
+ "("
+ DetailColumn.URL
+ ","
+ DetailColumn.KEY
+ ","
+ DetailColumn.GOOD
+ ","
+ DetailColumn.BAD
+ ","
+ DetailColumn.COLLECT
+ ") values('"
+ url
+ "','"
+ Key
+ "','"
+ good
+ "','"
+ bad
+ "','"
+ collect
+ "')";
dbHelper.ExecSQL(SQL);
}
/**
* 更改评价
*
* @param id
* @param good
* @param bad
* @param collect
* @return
*/
public int updateSQL(int id, int good, int bad, int collect) {
ContentValues values = new ContentValues();
values.put(DetailColumn.GOOD, good);
values.put(DetailColumn.BAD, bad);
values.put(DetailColumn.COLLECT, collect);
return dbHelper.update(
DetailColumn.TABLE_NAME, values, DetailColumn._ID + "=?", new String[] {id + ""});
}
public Cursor querySQL(String url) {
String SQL =
"select * from "
+ DetailColumn.TABLE_NAME
+ " where "
+ DetailColumn.URL
+ "='"
+ url
+ "'";
return dbHelper.rawQuery(SQL, null);
}
public void dbClose() {
dbHelper.closeDb();
}
public int deleteSQL(int id) {
return dbHelper.delete(DetailColumn.TABLE_NAME, id);
}
public DetailDB(Context context) {
dbHelper = DBHelper.getInstance(context);
}