当前位置：首页 > article >正文

数据库保存点播播放历史

article 2025/9/16 11:20:31

果子TV：VideoPlayerActivity.java类中：

public void insertHistory() {if (sqlite == null) {sqlite = new SQLiteHelper(VideoPlayerActivity.this);}SQLiteDatabase db = sqlite.getWritableDatabase();if (db != null) {try {//查找语句Cursor c = db.rawQuery("select * from historymedias  where  "+ MediaColumns.COL_ID + " = ?",new String[] { database_id });if (c.getCount() > 0) {handler.sendEmptyMessage(DATABASE_EXITS);return;}SQLiteStatement stat = db.compileStatement("INSERT INTO historymedias("+ MediaColumns.COL_ID + ","+ MediaColumns.COL_NAME + ","+ MediaColumns.COL_IMAGEURL + ","+ MediaColumns.COL_URL + ","+ MediaColumns.COL_CLASS+ ") VALUES(?,?,?,?,?)");//index 为1开始索引，value为入库的值  bingXXX为插入XXX类型  int index = 1;stat.bindString(index++, database_id);// idstat.bindString(index++, database_name);// namestat.bindString(index++, database_imgUrl); // imgurlstat.bindString(index++, database_detailUrl); // urlstat.bindString(index++, database_type);// classstat.execute();//老式的数据插入，以上是优化后的插入代码
//			db.execSQL("INSERT INTO historymedias("
//					+ MediaColumns.COL_ID + ","
//					+ MediaColumns.COL_NAME + ","
//					+ MediaColumns.COL_IMAGEURL + ","
//					+ MediaColumns.COL_URL + ","
//					+ MediaColumns.COL_CLASS
//					+ ") VALUES(?,?,?,?,?)", 
//					new String[]{database_id,database_name,database_imgUrl,database_detailUrl,database_type});//				handler.sendEmptyMessage(DATABASE_SUCCESS);} catch (Exception e) {e.printStackTrace();} finally {db.close();}}
}

以下也是一个查找语句：

                search.setOnClickListener(new OnClickListener(){//@Overridepublic void onClick(View source){// »ñÈ¡ÓÃ»§ÊäÈëString key = ((EditText) findViewById(R.id.key)).getText().toString();// 查找word或detail的记录   and就是且，含有两者Cursor cursor = dbHelper.getReadableDatabase().rawQuery("select * from dict where word like ? or detail like ?", new String[]{"%" + key + "%" , "%" + key + "%"});//ŽŽœšÒ»žöBundle¶ÔÏóBundle data = new Bundle();data.putSerializable("data", converCursorToList(cursor));//ŽŽœšÒ»žöIntentIntent intent = new Intent(Dict.this, ResultActivity.class);intent.putExtras(data);//Æô¶¯ActivitystartActivity(intent);}});