极客学院案例-记事本代码

*数据库文件NotesDB

package com.jikexueyuan.hellonotes;

import android.content.Context;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteDatabase.CursorFactory;
import android.database.sqlite.SQLiteOpenHelper;

public class NotesDB extends SQLiteOpenHelper {
    public static final String TABLE_NAME = "notes";
    public static final String CONTENT = "content";
    public static final String ID = "_id";
    public static final String TIME = "time";
    public static final String PATH = "path";
    public static final String VIDEO = "video";

    public NotesDB(Context context) {
        super(context, "notes", null, 1);
    }

    @Override
    public void onCreate(SQLiteDatabase db) {
        db.execSQL("CREATE TABLE " + TABLE_NAME + "(" + ID
                + " INTEGER PRIMARY KEY AUTOINCREMENT," + CONTENT
                + " TEXT NOT NULL," + PATH + " TEXT NOT NULL," + VIDEO
                + " TEXT NOT NULL," + TIME + " TEXT NOT NULL)");
    }

    @Override
    public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {

    }

}

MainActivity页面

package com.jikexueyuan.hellonotes;


import android.app.Activity;
import android.content.Intent;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.os.Bundle;
import android.util.Log;
import android.view.View;
import android.view.View.OnClickListener;
import android.widget.AdapterView;
import android.widget.AdapterView.OnItemClickListener;
import android.widget.Button;
import android.widget.ListView;

public class MainActivity extends Activity implements OnClickListener {
    private NotesDB notesDB;
    private SQLiteDatabase dbReader;
    private Button textbtn, imgbtn, videobtn;
    private ListView lv;
    private Intent i;
    private MyAdapter adapter;
    private Cursor cursor;


    @Override
    protected void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.activity_main);
        initView();
    }

    public void initView() {
        lv = (ListView) findViewById(R.id.list);
        textbtn = (Button) findViewById(R.id.text);
        imgbtn = (Button) findViewById(R.id.img);
        videobtn = (Button) findViewById(R.id.video);
        textbtn.setOnClickListener(this);
        imgbtn.setOnClickListener(this);
        videobtn.setOnClickListener(this);

        notesDB = new NotesDB(this);//初始化数据库文件,获取数据库实例
        dbReader = notesDB.getReadableDatabase();//获取读取权限
        /**
         * 实现listview每个子项的单机事件
         */
        lv.setOnItemClickListener(new OnItemClickListener(){
            @Override
            public void onItemClick(AdapterView<?> parent, View view, int position,
                    long id) {
                Log.d("TAG", position+"");
                Log.d("TAG", id+"");
                cursor.moveToPosition(position);//指针指向当前用户点击的位置position,利用指针取出这个位置在数据库的其他列数据
                Intent intent = new Intent(MainActivity.this,SelectAtc.class);
                intent.putExtra(NotesDB.ID, cursor.getInt(cursor.getColumnIndex(NotesDB.ID)));
                intent.putExtra(NotesDB.CONTENT, cursor.getString(cursor.getColumnIndex(NotesDB.CONTENT)));
                intent.putExtra(NotesDB.TIME, cursor.getString(cursor.getColumnIndex(NotesDB.TIME)));
                intent.putExtra(NotesDB.VIDEO, cursor.getString(cursor.getColumnIndex(NotesDB.VIDEO)));
                intent.putExtra(NotesDB.PATH, cursor.getString(cursor.getColumnIndex(NotesDB.PATH)));
                startActivity(intent);

            }



        });
    } 

    public void selectDB(){
        Cursor cursor = dbReader.query(NotesDB.TABLE_NAME, null, null, null, null, null, null);
        adapter = new MyAdapter(this,cursor);//调用适配器页面
        lv.setAdapter(adapter);
    }

    @Override
    public void onClick(View v) {
        i = new Intent(this, AddContent.class);
        switch (v.getId()) {
        case R.id.text:
            i.putExtra("flag", "1");
            startActivity(i);
            break;
        case R.id.img:
            i.putExtra("flag", "2");
            startActivity(i);
            break;
        case R.id.video:
            i.putExtra("flag", "3");
            startActivity(i);
            break;
        }

    }
    //在onResume()中来实现数据库的加载
    @Override
    protected void onResume() {
        super.onResume();
        selectDB();
    }



}

适配器页面

package com.jikexueyuan.hellonotes;

import android.content.Context;
import android.database.Cursor;
import android.graphics.Bitmap;
import android.graphics.BitmapFactory;
import android.media.ThumbnailUtils;
import android.provider.MediaStore;
import android.view.LayoutInflater;
import android.view.View;
import android.view.ViewGroup;
import android.widget.BaseAdapter;
import android.widget.ImageView;
import android.widget.LinearLayout;
import android.widget.TextView;

public class MyAdapter extends BaseAdapter {

    private Context context;
    private Cursor cursor;
    private LinearLayout layout;

    // 传递上下文环境context,以及指针给适配器
    public MyAdapter(Context context, Cursor cursor) {
        this.context = context;
        this.cursor = cursor;

    }

    @Override
    public int getCount() {
        return cursor.getCount();
    }

    @Override
    public Object getItem(int position) {
        return position;
    }

    @Override
    public long getItemId(int position) {
        // TODO Auto-generated method stub
        return 0;
    }

    @Override
    public View getView(int position, View convertView, ViewGroup parent) {
        LayoutInflater inflater =LayoutInflater.from(context);//从当前 context中获取布局加载器
       //LayoutInflater layout =  (LayoutInflater) context.getSystemService(Context.LAYOUT_INFLATER_SERVICE);
        layout = (LinearLayout)inflater.inflate(R.layout.cell, null);//加载xml文件cell,成为当前的布局
        //从当前布局中取出各个UI组件
        TextView contentTv= (TextView)layout.findViewById(R.id.list_content);
        TextView timeTv= (TextView)layout.findViewById(R.id.list_time);
        ImageView imgIv= (ImageView)layout.findViewById(R.id.list_img);
        ImageView videoIv= (ImageView)layout.findViewById(R.id.list_video);

        cursor.moveToPosition(position);
        String content = cursor.getString(cursor.getColumnIndex("content"));
        String time = cursor.getString(cursor.getColumnIndex("time"));
        String uri = cursor.getString(cursor.getColumnIndex("path"));
        String uri_video = cursor.getString(cursor.getColumnIndex("video"));
        contentTv.setText(content);
        timeTv.setText(time);
        videoIv.setImageBitmap(getVideoThumbnail(uri_video,200,200,MediaStore.Images.Thumbnails.MICRO_KIND));
        imgIv.setImageBitmap(getImageThumbnail(uri,200,200));
        return layout;
    }

    // 获取相机照片的缩略图,直接获取原始图片会触发系统 oom错误
    public Bitmap getImageThumbnail(String uri, int width, int height) {
        //72-75行是为了防止发生图片过大导致内存溢出错误,用BitmapFactory.Options的方法,得到bitmap=要取出图片的宽和高信息
        Bitmap bitmap = null;
        BitmapFactory.Options options = new BitmapFactory.Options();
        options.inJustDecodeBounds = true;
        bitmap = BitmapFactory.decodeFile(uri, options);
        options.inJustDecodeBounds = false;//取出bitmap信息之后关闭options.inJustDecodeBounds,与上面成对出现

        int beWidth = options.outWidth / width;
        int beHeight = options.outHeight / height;
        int be = 1;
        if (beWidth < beHeight) {
            be = beWidth;
        } else {
            be = beHeight;
        }
        if (be <= 0) {
            be = 1;
        }
        options.inSampleSize = be;
        bitmap = BitmapFactory.decodeFile(uri, options);//根据uri地址取出bitmap,同时options不为空时,这个bitmap将按照前面这只的比例显示
        bitmap = ThumbnailUtils.extractThumbnail(bitmap, width, height,
                ThumbnailUtils.OPTIONS_RECYCLE_INPUT);
        return bitmap;

    }

    private Bitmap getVideoThumbnail(String uri, int width, int height, int kind) {
        Bitmap bitmap = null;
        bitmap = ThumbnailUtils.createVideoThumbnail(uri, kind);
        bitmap = ThumbnailUtils.extractThumbnail(bitmap, width, height,
                ThumbnailUtils.OPTIONS_RECYCLE_INPUT);
        return bitmap;
    }
}

添加数据页面

package com.jikexueyuan.hellonotes;

import java.io.File;
import java.text.SimpleDateFormat;
import java.util.Date;

import android.app.Activity;
import android.content.ContentValues;
import android.content.Intent;
import android.database.sqlite.SQLiteDatabase;
import android.graphics.Bitmap;
import android.graphics.BitmapFactory;
import android.net.Uri;
import android.os.Bundle;
import android.os.Environment;
import android.provider.MediaStore;
import android.util.Log;
import android.view.View;
import android.view.View.OnClickListener;
import android.widget.Button;
import android.widget.EditText;
import android.widget.ImageView;
import android.widget.VideoView;

public class AddContent extends Activity implements OnClickListener {
    private String val;
    private Button savebtn, deletebtn;
    private ImageView c_img;
    private EditText ettext;
    private VideoView v_video;
    private NotesDB notesDB;
    private SQLiteDatabase dbWriter;
    private File phoneFile;
    private File videoFile;

    @Override
    protected void onCreate(Bundle savedInstanceState) {
        // TODO Auto-generated method stub
        super.onCreate(savedInstanceState);
        setContentView(R.layout.addcontent);
        val = getIntent().getStringExtra("flag");// 接受前面传递的按钮类型
        savebtn = (Button) findViewById(R.id.save);
        deletebtn = (Button) findViewById(R.id.delete);
        c_img = (ImageView) findViewById(R.id.c_img);
        v_video = (VideoView) findViewById(R.id.c_video);
        ettext = (EditText) findViewById(R.id.text);
        savebtn.setOnClickListener(this);
        deletebtn.setOnClickListener(this);

        notesDB = new NotesDB(this);
        dbWriter = notesDB.getWritableDatabase();
        initView();
    }

    private void initView() {
        if (val.equals("1")) {// 添加的是文字
            c_img.setVisibility(View.GONE);
            v_video.setVisibility(View.GONE);
        }
        if (val.equals("2")) {// 添加的是图片
            c_img.setVisibility(View.VISIBLE);
            v_video.setVisibility(View.GONE);
            Intent iimg = new Intent(MediaStore.ACTION_IMAGE_CAPTURE);// 跳转到系统相机
            // /storage/emulated/0/2016年12月07日 02:19:49.jpg
            phoneFile = new File(Environment.getExternalStorageDirectory()
                    .getAbsoluteFile() + "/" + getTime() + ".jpg");// 绝对路径+图片名称
            iimg.putExtra(MediaStore.EXTRA_OUTPUT, Uri.fromFile(phoneFile));
            Log.d("TAG", phoneFile + "");
            startActivityForResult(iimg, 1);
        }
        if (val.equals("3")) {
            c_img.setVisibility(View.GONE);
            v_video.setVisibility(View.VISIBLE);

            Intent video = new Intent(MediaStore.ACTION_VIDEO_CAPTURE);// 跳转到系统相机
            // /storage/emulated/0/2016年12月07日 02:19:49.jpg
            videoFile = new File(Environment.getExternalStorageDirectory()
                    .getAbsoluteFile() + "/" + getTime() + ".mp4");// 绝对路径+图片名称
            video.putExtra(MediaStore.EXTRA_OUTPUT, Uri.fromFile(videoFile));
            Log.d("TAG", videoFile + "");
            startActivityForResult(video, 2);



        }
    }

    @Override
    public void onClick(View v) {
        switch (v.getId()) {
        case R.id.save:
            addDB();
            finish();
            break;
        case R.id.delete:
            finish();
            break;
        }

    }

    public void addDB() {
        ContentValues cv = new ContentValues();
        cv.put(NotesDB.CONTENT, ettext.getText().toString());
        cv.put(NotesDB.TIME, getTime());
        Log.d("TAG", phoneFile+"");
        cv.put(NotesDB.PATH, phoneFile+"");
        cv.put(NotesDB.VIDEO, videoFile+"");
        dbWriter.insert(NotesDB.TABLE_NAME, null, cv);
    }

    private String getTime() {
        SimpleDateFormat format = new SimpleDateFormat("yyyy年MM月dd日 HH:mm:ss");
        Date date = new Date();
        String str = format.format(date);
        return str;
    }

    @Override
    protected void onActivityResult(int requestCode, int resultCode, Intent data) {
        super.onActivityResult(requestCode, resultCode, data);
        if (requestCode == 1) {
            Bitmap bitmap = BitmapFactory.decodeFile(phoneFile
                    .getAbsolutePath());
            c_img.setImageBitmap(bitmap);
        }
        if(requestCode ==2){
            v_video.setVideoURI(Uri.fromFile(videoFile));
            v_video.start();
        }
    }
}

几个XML文件
activity_main.xml

addcontent.xml

cell.xml页面


select.xml

  • 1
    点赞
  • 6
    收藏
    觉得还不错? 一键收藏
  • 2
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论 2
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值