阅读更多
package com.hangcheng;import java.io.File;import java.util.ArrayList;import com.example.bdcustomer_demo.R;import com.hangcheng.entity.FileBin;import com.hangcheng.helper.MySQLiteHelper;import android.app.Activity;import android.content.Intent;import android.database.Cursor;import android.database.sqlite.SQLiteDatabase;import android.os.Bundle;import android.os.Environment;import android.util.Log;import android.view.LayoutInflater;import android.view.View;import android.view.ViewGroup;import android.view.Window;import android.webkit.WebChromeClient.CustomViewCallback;import android.widget.BaseAdapter;import android.widget.Button;import android.widget.EditText;import android.widget.ListView;import android.widget.SimpleAdapter;import android.widget.TextView;import android.widget.Toast;public class DbActivity extends Activity {private EditText editText_type;private Button btn_search;private TextView textView_id;private TextView textView_type;private TextView textView_path;private Button btn_delete;private Button btn_play;private String file_id = "";private String file_type = "";private String file_path = "";private ListView listView_db;ArrayList data;private Cursor cursor;private FileBin fileBin;private String fileid;private String type;private String path;BaseAdapter adapter;@Overrideprotected void onCreate(Bundle savedInstanceState) {super.onCreate(savedInstanceState);requestWindowFeature(Window.FEATURE_NO_TITLE);setContentView(R.layout.dbfile);data = new ArrayList();initView();cursor = new MySQLiteHelper(DbActivity.this, "file.db", null, 1).querydataFromdb(file_id, file_type, file_path);cursor.moveToFirst();while (cursor.moveToNext()) {android.util.Log.e("tag",cursor.getString(cursor.getColumnIndex("_id"))+ cursor.getString(cursor.getColumnIndex("type"))+ cursor.getString(cursor.getColumnIndex("filepath")));}data = new MySQLiteHelper(DbActivity.this, "file.db", null, 1).getfileData();android.util.Log.e("MESSAGE", data.size() + "");adapter = new BaseAdapter() {@Overridepublic View getView(final int position, View convertView,ViewGroup parent) {if (convertView == null) {convertView = LayoutInflater.from(DbActivity.this).inflate(R.layout.list_view_filedb_items, null);}FileBin filebin = (FileBin) data.get(position);Log.e("MESSAGE", filebin.getId());Log.e("MESSAGE", filebin.getType());Log.e("MESSAGE", filebin.getFilepath());textView_id = (TextView) convertView.findViewById(R.id.textViewdb_id);textView_type = (TextView) convertView.findViewById(R.id.textViewdb_type);textView_path = (TextView) convertView.findViewById(R.id.textViewdb_path);btn_delete = (Button) convertView.findViewById(R.id.btn_delete);btn_play = (Button) convertView.findViewById(R.id.btn_play);textView_id.setText(filebin.getId());textView_type.setText(filebin.getType());textView_path.setText(filebin.getFilepath());final int id = position;btn_play.setOnClickListener(new View.OnClickListener() {@Overridepublic void onClick(View v) {Log.e("HAHAHAHHAHA", "进来了");Log.e("HAHAHAHHAHA", "当前点击的位置是:" + position + "");Log.e("HAHAHAHHAHA",((FileBin) data.get(position)).getType());Log.e("HAHAHAHHAHA",((FileBin) data.get(position)).getFilepath());type = ((FileBin) data.get(position)).getType();path = ((FileBin) data.get(position)).getFilepath();if (type.equals("jpg") || type.equals("png")|| type.equals("jpeg")) {Intent intent = new Intent(getBaseContext(),PictureActivity.class);intent.putExtra("picpath", path);startActivity(intent);}if (type.equals("mp4") || type.equals("wav")|| type.equals("avi") || type.equals("mp3")) {Log.e("HAHAHAHAHHA", "进入播放");Intent intent = new Intent(DbActivity.this,VideoActivity.class);intent.putExtra("videopath", path);startActivity(intent);}if (type.equals("gif")) {Intent intent = new Intent(getBaseContext(),GifViewActivity.class);intent.putExtra("gifpath", path);startActivity(intent);}}});btn_delete.setOnClickListener(new View.OnClickListener() {@Overridepublic void onClick(View v) {fileid = ((FileBin) data.get(position)).getId();MySQLiteHelper helper = new MySQLiteHelper(getBaseContext(), "file.db", null, 1);helper.deletedataFromdb(Integer.parseInt(fileid));data = new MySQLiteHelper(DbActivity.this, "file.db",null, 1).getfileData();listView_db.setAdapter(adapter);listView_db.invalidate();adapter.notifyDataSetChanged();}});return convertView;}@Overridepublic long getItemId(int arg0) {return arg0;}@Overridepublic Object getItem(int arg0) {fileBin = (FileBin) data.get(arg0);fileid = fileBin.getId();type = fileBin.getType();path = fileBin.getFilepath();return data.get(arg0);}@Overridepublic int getCount() {return data.size();}};listView_db.setAdapter(adapter);btn_search.setOnClickListener(new View.OnClickListener() {@Overridepublic void onClick(View v) {file_type = editText_type.getText().toString();if (file_type.equals("")) {data = new MySQLiteHelper(DbActivity.this, "file.db", null,1).getfileData();} else {data = new MySQLiteHelper(DbActivity.this, "file.db", null,1).getfilebyTypeData(file_type);}cursor.moveToFirst();listView_db.setAdapter(new BaseAdapter() {@Overridepublic View getView(final int position, View convertView,ViewGroup parent) {if (convertView == null) {convertView = LayoutInflater.from(DbActivity.this).inflate(R.layout.list_view_filedb_items,null);}FileBin filebin = (FileBin) data.get(position);Log.e("MESSAGE", filebin.getId());Log.e("MESSAGE", filebin.getType());Log.e("MESSAGE", filebin.getFilepath());textView_id = (TextView) convertView.findViewById(R.id.textViewdb_id);textView_type = (TextView) convertView.findViewById(R.id.textViewdb_type);textView_path = (TextView) convertView.findViewById(R.id.textViewdb_path);btn_delete = (Button) convertView.findViewById(R.id.btn_delete);btn_play = (Button) convertView.findViewById(R.id.btn_play);textView_id.setText(filebin.getId());textView_type.setText(filebin.getType());textView_path.setText(filebin.getFilepath());type = filebin.getType();path = filebin.getFilepath();btn_play.setOnClickListener(new View.OnClickListener() {@Overridepublic void onClick(View v) {Log.e("HAHAHAHHAHA", "进来了");Log.e("HAHAHAHHAHA", "当前点击的位置是:" + position+ "");Log.e("HAHAHAHHAHA", ((FileBin) data.get(position)).getType());Log.e("HAHAHAHHAHA", ((FileBin) data.get(position)).getFilepath());type = ((FileBin) data.get(position)).getType();path = ((FileBin) data.get(position)).getFilepath();if (type.equals("jpg") || type.equals("png")|| type.equals("jpeg")) {Intent intent = new Intent(getBaseContext(),PictureActivity.class);intent.putExtra("picpath", path);startActivity(intent);}if (type.equals("mp4") || type.equals("wav")|| type.equals("avi")|| type.equals("mp3")) {Log.e("HAHAHAHAHHA", "进入播放");Intent intent = new Intent(DbActivity.this,VideoActivity.class);intent.putExtra("videopath", path);startActivity(intent);}if (type.equals("gif")) {Intent intent = new Intent(getBaseContext(),GifViewActivity.class);intent.putExtra("gifpath", path);startActivity(intent);}}});btn_delete.setOnClickListener(new View.OnClickListener() {@Overridepublic void onClick(View v) {fileid = ((FileBin) data.get(position)).getId();MySQLiteHelper helper = new MySQLiteHelper(getBaseContext(), "file.db",null, 1);helper.deletedataFromdb(Integer.parseInt(fileid));data = new MySQLiteHelper(DbActivity.this, "file.db",null, 1).getfileData();listView_db.setAdapter(adapter);listView_db.invalidate();adapter.notifyDataSetChanged();}});return convertView;}@Overridepublic long getItemId(int arg0) {return arg0;}@Overridepublic Object getItem(int arg0) {return data.get(arg0);}@Overridepublic int getCount() {return data.size();}});}});}private void initView() {editText_type = (EditText) findViewById(R.id.file_type);btn_search = (Button) findViewById(R.id.btn_search);listView_db = (ListView) findViewById(R.id.listview_db);}}

更多相关文章

  1. android 6.0锁屏界面时间位置修改
  2. Android 1.6 支持更多的屏幕大小和分辨率
  3. android 修改AVD的存放位置
  4. Android Studio第三十一期 - 记录RecyclerView滚动位置并恢复
  5. Android 调用系统原生相机拍照并储存到指定位置
  6. Android自定义控件布局刷新自定义控件回到初始位置问题的解决
  7. android学习轨迹之二:Android权限标签uses-permission的书写位置

随机推荐

  1. BRCM5.02编译八: ERROR: you are missing
  2. BRCM5.02编译九:cannot find -lncurses
  3. BRCM5.02编译十:cmake: command not found
  4. 安装Sublime Text 支持Go插件
  5. slf4j 整合log4j 报错 WARN Please in
  6. 关于修改密码带特殊符号以及数据泵参数设
  7. 【等待事件】User I/O类 等待事件(2.8)--re
  8. 【DB笔试面试462】如何将一个数字转换为
  9. 【OCP最新题库解析(052)--题18】 Which t
  10. 【OCP最新题库解析(052)--题16】Your dat