创建数据库，并定义ContentProvider接口

于 2015-12-07 14:36:21 发布
阅读量321 收藏
点赞数
分类专栏： android
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/kongchengjiumenghx/article/details/50205487
版权 
package com.example.fourteen;

import android.app.Activity;
import android.content.ContentValues;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.os.Bundle;
import android.util.Log;
import android.view.View;
import android.widget.Button;
import android.widget.Toast;

/**
 * @author HD
 * @date 2015-12-7
 * @package_name com.example.fourteen
 * @file_name MainActivity.java
 */
public class MainActivity extends Activity {

    private Button btnCreateTable;
    private Button btnUpdatePrice;
    private Button btnDeleteData;
    private Button btnQueryData;
    private Button btnBegintransaction;

    private DatabaseHelper databaseHelper;
    private SQLiteDatabase db;

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

        databaseHelper = new DatabaseHelper(MainActivity.this, "BookStore.db",
                null, 4);
        db = databaseHelper.getWritableDatabase();
        btnCreateTable = (Button) findViewById(R.id.btnCreateTable);
        btnUpdatePrice = (Button) findViewById(R.id.btnUpdatePrice);
        btnDeleteData = (Button) findViewById(R.id.btnDeleteData);
        btnQueryData = (Button) findViewById(R.id.btnQueryData);
        btnBegintransaction = (Button) findViewById(R.id.btnBeginTransaction);

        btnCreateTable.setOnClickListener(new View.OnClickListener() {

            @Override
            public void onClick(View v) {
                // TODO 自动生成的方法存根
                ContentValues values = new ContentValues();
                values.put("name", "The First Rows Code");
                values.put("author", "郭霖");
                values.put("price", 98.50);
                values.put("pages", 650);
                db.insert("book", null, values);
                values.clear();
                values.put("name", "Thinking In Java");
                values.put("author", "nike");
                values.put("pages", 950);
                values.put("price", 85.50);
                db.insert("book", null, values);
            }
        });

        btnUpdatePrice.setOnClickListener(new View.OnClickListener() {

            @Override
            public void onClick(View v) {
                // TODO 自动生成的方法存根

                ContentValues values = new ContentValues();
                values.put("price", 20.50);
                db.update("book", values, "name = ?",
                        new String[] { "The First Rows Code" });
                Toast.makeText(MainActivity.this, "更新数据成功", Toast.LENGTH_SHORT)
                        .show();
            }
        });

        btnDeleteData.setOnClickListener(new View.OnClickListener() {

            @Override
            public void onClick(View v) {
                // TODO 自动生成的方法存根
                db.delete("book", "pages > ?", new String[]{"600"});
                Toast.makeText(MainActivity.this, "删除数据成功", Toast.LENGTH_SHORT).show();
            }
        });

        btnQueryData.setOnClickListener(new View.OnClickListener() {

            @Override
            public void onClick(View v) {
                // TODO 自动生成的方法存根
                Cursor cursor = db.query("book", null, null, null, null, null, null);
                if(cursor.moveToNext()){
                    do {
                        String name = cursor.getString(cursor.getColumnIndex("name"));
                        Double price = cursor.getDouble(cursor.getColumnIndex("price"));
                        int pages = cursor.getInt(cursor.getColumnIndex("pages"));
                        String author = cursor.getString(cursor.getColumnIndex("author"));
                        Log.i("hhhd", "书名:"+name+"/n"
                        +"价格:"+price+"/n"
                        +"页数："+pages+"/n"
                        +"作者:"+author);
                    } while (cursor.moveToNext());
                }
            }
        });

        btnBegintransaction.setOnClickListener(new View.OnClickListener() {

            @Override
            public void onClick(View v) {
                // TODO 自动生成的方法存根
                db.beginTransaction();
                try {
                    db.delete("book", null, null);
                    ContentValues values = new ContentValues();
                    values.put("name", "Gitar Test");
                    values.put("price", 25);
                    values.put("pages", 450);
                    values.put("author", "韩栋");
                    db.insert("book", null, values);
                    db.setTransactionSuccessful();
                } catch (Exception e) {
                    // TODO 自动生成的 catch 块
                    e.printStackTrace();
                }finally{
                    db.endTransaction();
                }
            }
        });
    }

}

package com.example.fourteen;

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

/**
 * @author HD
 * @date 2015-12-7
 * @package_name com.example.fourteen
 * @file_name DatabaseHelper.java
 */
public class DatabaseHelper extends SQLiteOpenHelper {

    public static final String CREATE_BOOK = "create table book("
            + "id integer primary key autoincrement," 
            + "author text,"
            + "price real," 
            + "pages integer," 
            + "name text,"
            + "category_id integer)";

    public static final String CREATE_CATEGORY = "create table Category("
            +"id integer primary key autoincrement,"
            +"category_name text,"
            +"category_code integer)";

    public static final String CREATE_MANAGER = "create table Manager("
            +"id integer primary key autoincrement,"
            +"name text,"
            +"age integer,"
            +"address text,"
            +"salary real)";

    private Context context;

    public DatabaseHelper(Context context, String name, CursorFactory factory,
            int version) {
        super(context, name, factory, version);
        // TODO 自动生成的构造函数存根
        this.context = context;
    }

    @Override
    public void onCreate(SQLiteDatabase db) {
        // TODO 自动生成的方法存根
        db.execSQL(CREATE_BOOK);
        db.execSQL(CREATE_CATEGORY);
        db.execSQL(CREATE_MANAGER);
        Toast.makeText(context, "创建表成功", Toast.LENGTH_SHORT).show();
    }

    @Override
    public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
        // TODO 自动生成的方法存根
        switch (oldVersion) {
        case 1:
            db.execSQL(CREATE_CATEGORY);

        case 2:
            db.execSQL(CREATE_MANAGER);

        case 3:
            db.execSQL("alter table book add column category_id integer");

        default:

        }
    }

}

package com.example.fourteen;

import android.content.ContentProvider;
import android.content.ContentValues;
import android.content.UriMatcher;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.net.Uri;

/**
 * @author HD
 * @date 2015-12-7
 * @package_name com.example.fourteen
 * @file_name DatabaseProvider.java
 */
public class DatabaseProvider extends ContentProvider {

    public static final int BOOK_DIR = 0;
    public static final int BOOK_ITEM = 1;
    public static final int CATEGORY_DIR = 2;
    public static final int CATEGORY_ITEM = 3;

    public static UriMatcher uriMatcher;

    public static final String AUTHORITY = "com.example.fourteen.provider";

    private DatabaseHelper databaseHelper;

    static {
        uriMatcher.addURI(AUTHORITY, "book", BOOK_DIR);
        uriMatcher.addURI(AUTHORITY, "book/#", BOOK_ITEM);
        uriMatcher.addURI(AUTHORITY, "Category", CATEGORY_DIR);
        uriMatcher.addURI(AUTHORITY, "Category/#", CATEGORY_ITEM);
    }

    @Override
    public boolean onCreate() {
        // TODO 自动生成的方法存根
        databaseHelper = new DatabaseHelper(getContext(), "BookStore.db", null,
                4);
        return true;
    }

    @Override
    public Cursor query(Uri uri, String[] projection, String selection,
            String[] selectionArgs, String sortOrder) {
        // TODO 自动生成的方法存根
        SQLiteDatabase db = databaseHelper.getReadableDatabase();
        Cursor cursor = null;
        switch (uriMatcher.match(uri)) {
        case BOOK_DIR:
            cursor = db.query("book", projection, selection, selectionArgs,
                    null, null, sortOrder);
            break;
        case BOOK_ITEM:
            String bookId = uri.getPathSegments().get(1);
            cursor = db.query("book", projection, "id = ?",
                    new String[] { bookId }, null, null, sortOrder);
            break;
        case CATEGORY_DIR:
            cursor = db.query("Category", projection, selection, selectionArgs,
                    null, null, sortOrder);
            break;
        case CATEGORY_ITEM:
            String CategoryId = uri.getPathSegments().get(1);
            cursor = db.query("Category", projection, "id = ?",
                    new String[] { CategoryId }, null, null, sortOrder);
            break;
        }
        return cursor;

    }

    @Override
    public String getType(Uri uri) {
        // TODO 自动生成的方法存根
        switch (uriMatcher.match(uri)) {
        case BOOK_DIR:
            return "vnd.android.cursor.dir/vnd.com.example.fourteen.provider.book";
        case BOOK_ITEM:
            return "vnd.android.cursor.item/vnd.com.example.fourteen.provider.book";
        case CATEGORY_DIR:
            return "vnd.android.cursor.dir/vnd.com.example.fourteen.provider.Category";
        case CATEGORY_ITEM:
            return "vnd.android.cursor.item/vnd.com.example.fourteen.provider.Category";
        }
        return null;
    }

    @Override
    public Uri insert(Uri uri, ContentValues values) {
        // TODO 自动生成的方法存根
        SQLiteDatabase db = databaseHelper.getWritableDatabase();
        Uri uriReturn = null;
        switch (uriMatcher.match(uri)) {
        case BOOK_DIR:
        case BOOK_ITEM:
            long bookItem = db.insert("book", null, values);
            uriReturn = uri.parse("content://" + AUTHORITY + "/book/"
                    + bookItem);
            break;
        case CATEGORY_DIR:
        case CATEGORY_ITEM:
            long categoryItem = db.insert("Category", null, values);
            uriReturn = uri.parse("content://" + AUTHORITY + "/Category"
                    + categoryItem);
        }
        return uriReturn;
    }

    @Override
    public int delete(Uri uri, String selection, String[] selectionArgs) {
        // TODO 自动生成的方法存根
        SQLiteDatabase db = databaseHelper.getWritableDatabase();
        int deleteRows = 0;
        switch (uriMatcher.match(uri)) {
        case BOOK_DIR:
            deleteRows = db.delete("book", selection, selectionArgs);
            break;
        case BOOK_ITEM:
            String bookId = uri.getPathSegments().get(1);
            deleteRows = db.delete("book", "id = ?", new String[] { bookId });
            break;
        case CATEGORY_DIR:
            deleteRows = db.delete("Category", selection, selectionArgs);
            break;
        case CATEGORY_ITEM:
            String CategoryId = uri.getPathSegments().get(1);
            deleteRows = db.delete("Category", "id = ?",
                    new String[] { CategoryId });
            break;
        }
        return deleteRows;
    }

    @Override
    public int update(Uri uri, ContentValues values, String selection,
            String[] selectionArgs) {
        // TODO 自动生成的方法存根
        SQLiteDatabase db = databaseHelper.getWritableDatabase();
        int updataRows = 0;
        switch (uriMatcher.match(uri)) {
        case BOOK_DIR:
            updataRows = db.update("book", values, selection, selectionArgs);
            break;
        case BOOK_ITEM:
            String bookId = uri.getPathSegments().get(1);
            updataRows = db.update("book", values, "id = ?", new String[]{bookId});
            break;
        case CATEGORY_DIR:
            updataRows = db.update("Category", values, selection, selectionArgs);
            break;
        case CATEGORY_ITEM:
            String categoryId = uri.getPathSegments().get(1);
            updataRows = db.update("Category", values, selection, selectionArgs);
            break;
        }
        return updataRows;
    }

}

<RelativeLayout xmlns:android="http://schemas.android.com/apk/res/android"
    xmlns:tools="http://schemas.android.com/tools"
    android:layout_width="match_parent"
    android:layout_height="match_parent"
    android:paddingBottom="@dimen/activity_vertical_margin"
    android:paddingLeft="@dimen/activity_horizontal_margin"
    android:paddingRight="@dimen/activity_horizontal_margin"
    android:paddingTop="@dimen/activity_vertical_margin"
    tools:context="com.example.fourteen.MainActivity" >

    <Button
        android:id="@+id/btnCreateTable"
        android:layout_width="wrap_content"
        android:layout_height="wrap_content"
        android:layout_alignParentTop="true"
        android:layout_centerHorizontal="true"
        android:layout_marginTop="140dp"
        android:text="创建数据库" />

    <Button
        android:id="@+id/btnUpdatePrice"
        android:layout_width="wrap_content"
        android:layout_height="wrap_content"
        android:layout_alignRight="@+id/btnCreateTable"
        android:layout_below="@+id/btnCreateTable"
        android:layout_marginTop="62dp"
        android:text="更新价格" />

    <Button
        android:id="@+id/btnDeleteData"
        android:layout_width="wrap_content"
        android:layout_height="wrap_content"
        android:layout_alignRight="@+id/btnUpdatePrice"
        android:layout_below="@+id/btnUpdatePrice"
        android:layout_marginTop="40dp"
        android:text="删除数据" />

    <Button
        android:id="@+id/btnQueryData"
        android:layout_width="wrap_content"
        android:layout_height="wrap_content"
        android:layout_alignParentBottom="true"
        android:layout_alignRight="@+id/btnDeleteData"
        android:text="查询数据" />

    <Button
        android:id="@+id/btnBeginTransaction"
        android:layout_width="wrap_content"
        android:layout_height="wrap_content"
        android:layout_alignLeft="@+id/btnCreateTable"
        android:layout_alignParentTop="true"
        android:layout_marginTop="66dp"
        android:text="开始事务" />

</RelativeLayout>

<?xml version="1.0" encoding="utf-8"?>
<manifest xmlns:android="http://schemas.android.com/apk/res/android"
    package="com.example.fourteen"
    android:versionCode="1"
    android:versionName="1.0" >

    <uses-sdk
        android:minSdkVersion="14"
        android:targetSdkVersion="21" />

    <application
        android:allowBackup="true"
        android:icon="@drawable/ic_launcher"
        android:label="@string/app_name"
        android:theme="@style/AppTheme" >
        <activity
            android:name=".MainActivity"
            android:label="@string/app_name" >
            <intent-filter>
                <action android:name="android.intent.action.MAIN" />

                <category android:name="android.intent.category.LAUNCHER" />
            </intent-filter>
        </activity>

        <provider
            android:name=".DatabaseProvider"
            android:authorities="com.example.fourteen.provider" >
        </provider>
    </application>

</manifest>
HanDong_
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
专栏目录
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值