SQLite

最新推荐文章于 2024-04-09 02:59:26 发布

F_URY

最新推荐文章于 2024-04-09 02:59:26 发布

阅读量339

点赞数

分类专栏： Android DB

本文链接：https://blog.csdn.net/u012400327/article/details/45398211

版权

Android 同时被 2 个专栏收录

19 篇文章 0 订阅

订阅专栏

2 篇文章 0 订阅

订阅专栏

Android中使用SQLite数据库时,需要用adb来辅助调试,如果想在windows下的cmd命令行中使用adb 需要进入adb shell

在cmd中输入如下命令：adb shell;cd data; cd data; ls; cd com.example.sqlite; ls;命令可以看到databases 进入databases 输入ls 可查看当前存在的数据库。

sqlite3 sutdent.db 进入 student 数据库

package com.example.fury.sqlite;

import android.content.ContentValues;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.support.v7.app.ActionBarActivity;
import android.os.Bundle;
import android.view.Menu;
import android.view.MenuItem;
import android.view.View;
import android.widget.Button;
import android.view.View.OnClickListener;


public class MainActivity extends ActionBarActivity {

    private Button create_database = null;
    private Button update_database = null;
    private Button insert = null;
    private Button update = null;
    private Button query = null;
    private Button delete = null;
    private Button delete_database = null;

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

        create_database = (Button)findViewById(R.id.create_database);
        create_database.setOnClickListener(new CreateDatabaseOnClickListener());
        update_database = (Button)findViewById(R.id.update_database);
        update_database.setOnClickListener(new UpdateDatabaseOnClickListener());
        insert = (Button)findViewById(R.id.insert);
        insert.setOnClickListener(new InsertOnClickListener());
        update = (Button)findViewById(R.id.update);
        update.setOnClickListener(new UpdateOnClickListener());
        query = (Button)findViewById(R.id.query);
        query.setOnClickListener(new QueryOnClickListener());
        delete = (Button)findViewById(R.id.delete);
        delete.setOnClickListener(new DeleteOnClickListener());
        delete_database = (Button)findViewById(R.id.delete_database);
        delete_database.setOnClickListener(new Delete_databaseOnClickListener());

    }
    public class CreateDatabaseOnClickListener implements OnClickListener{

        public void onClick(View v) {
            //创建一个DatabaseHelper类的对象，该类是单独一个java文件,这里采用2个参数的构造函数，建立的数据
            //库的名字为tornadomeet.db
            DatabaseHelper database_helper = new DatabaseHelper(MainActivity.this, "tornadomeet.db");
            //只有调用getReadableDatabase()或者getWriteableDatabase()函数后才能返回一个SQLiteDatabase对象
            SQLiteDatabase db = database_helper.getReadableDatabase();
        }
    }
    public class UpdateDatabaseOnClickListener implements OnClickListener{

        public void onClick(View v) {
            DatabaseHelper database_helper = new DatabaseHelper(MainActivity.this, "tornadomeet.db", 2);
            SQLiteDatabase db = database_helper.getReadableDatabase();
        }
    }

    public class InsertOnClickListener implements OnClickListener{

        public void onClick(View v) {
            // 生成contentvallues对象，该对象用来存数据的
            ContentValues values = new ContentValues();
            values.put("id", 1);//注意值的类型要匹配
            values.put("name", "tornado");
            DatabaseHelper database_helper = new DatabaseHelper(MainActivity.this, "tornadomeet.db");
            SQLiteDatabase db = database_helper.getWritableDatabase();//这里是获得可写的数据库
            db.insert("user1", null, values);
        }
    }
    public class UpdateOnClickListener implements OnClickListener{

        public void onClick(View v) {
            DatabaseHelper database_helper = new DatabaseHelper(MainActivity.this, "tornadomeet.db");
            SQLiteDatabase db = database_helper.getWritableDatabase();
            ContentValues values = new ContentValues();
            values.put("name", "tornadomeet");
            //参数1为表名，参数2为更新后的值，参数3表示满足条件的列名称，参数4为该列名下的值
            db.update("user1", values, "id=?", new String[]{"1"});
        }
    }

    public class QueryOnClickListener implements OnClickListener{

        public void onClick(View v) {
            // TODO Auto-generated method stub
            DatabaseHelper database_helper = new DatabaseHelper(MainActivity.this, "tornadomeet.db");
            SQLiteDatabase db = database_helper.getWritableDatabase();
            //查询的语法，参数1为表名；参数2为表中的列名；参数3为要查询的列名；参数时为对应列的值；该函数返回的是一个游标
            Cursor cursor = db.query("user1", new String[]{"id", "name"}, "id=?", new String[]{"1"},  null, null, null);
            //遍历每一个记录
            while(cursor.moveToNext()) {
                String name = cursor.getString(cursor.getColumnIndex("name"));//返回列名为name的值
                System.out.println("query---->" + name);
            }
        }
    }
    public class DeleteOnClickListener implements OnClickListener{

        public void onClick(View v) {
            // TODO Auto-generated method stub
            DatabaseHelper database_helper = new DatabaseHelper(MainActivity.this, "tornadomeet.db");
            SQLiteDatabase db = database_helper.getWritableDatabase();
            //直接删除名为tornadomeet对应的那条记录
            db.delete("user1", "name=?" ,new String[]{"tornadomeet"});
        }

    }
    public class Delete_databaseOnClickListener implements OnClickListener{

        public void onClick(View v) {
            DatabaseHelper database_helper = new DatabaseHelper(MainActivity.this, "tornadomeet.db");
            boolean deleteSusseed = false;
            deleteSusseed = database_helper.deleteDatabase(MainActivity.this, "tornadomeet.db");
            if(deleteSusseed)
                System.out.println("susseed delete database!");
            else System.out.println("faile to delete!");
        }

    }
    @Override
    public boolean onCreateOptionsMenu(Menu menu) {
        getMenuInflater().inflate(R.menu.menu_main, menu);
        return true;
    }

    @Override
    public boolean onOptionsItemSelected(MenuItem item) {

        int id = item.getItemId();

        if (id == R.id.action_settings) {
            return true;
        }

        return super.onOptionsItemSelected(item);
    }
}

package com.example.fury.sqlite;

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

/**
 * Created by flt on 2015/4/30.
 */
public class DatabaseHelper extends SQLiteOpenHelper {
    private static final int  VERSON = 1;//默认的数据库版本
    //继承SQLiteOpenHelper类的类必须有自己的构造函数
    //该构造函数4个参数，直接调用父类的构造函数。其中第一个参数为该类本身；第二个参数为数据库的名字；
    //第3个参数是用来设置游标对象的，这里一般设置为null；参数四是数据库的版本号。
    public DatabaseHelper(Context context, String name, SQLiteDatabase.CursorFactory factory, int verson){
        super(context, name, factory, verson);
    }

    //该构造函数有3个参数，因为它把上面函数的第3个参数固定为null了
    public DatabaseHelper(Context context, String name, int verson){
        this(context, name, null, verson);
    }
    //该构造函数只有2个参数，在上面函数 的基础山将版本号固定了
    public DatabaseHelper(Context context, String name){
        this(context, name, VERSON);
    }
    /**
     * 删除数据库
     * @param context
     * @return
     */
    public boolean deleteDatabase(Context context,String name) {
        return context.deleteDatabase(name);
    }
    //该函数在数据库第一次被建立时调用
    @Override
    public void onCreate(SQLiteDatabase arg0) {
        System.out.println("create a sqlite database");
        //execSQL()为执行参数里面的SQL语句，因此参数中的语句需要符合SQL语法,这里是创建一个表
        arg0.execSQL("create table user1(id int, name varchar(20))");
    }
    @Override
    public void onUpgrade(SQLiteDatabase arg0, int arg1, int arg2) {
        System.out.println("update a sqlite database");
    }

}

<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:paddingLeft="@dimen/activity_horizontal_margin"
    android:paddingRight="@dimen/activity_horizontal_margin"
    android:paddingTop="@dimen/activity_vertical_margin"
    android:paddingBottom="@dimen/activity_vertical_margin" tools:context=".MainActivity">

    <TextView android:text="@string/hello_world" android:layout_width="wrap_content"
        android:layout_height="wrap_content" />
    <Button
        android:id="@+id/create_database"
        android:layout_width="fill_parent"
        android:layout_height="wrap_content"
        android:layout_alignParentBottom="true"
        android:text="@string/create_database"
        />

    <Button
        android:id="@+id/update_database"
        android:layout_width="fill_parent"
        android:layout_height="wrap_content"
        android:layout_above="@id/create_database"
        android:layout_alignParentLeft="true"
        android:text="@string/update_database" />

    <Button
        android:id="@+id/insert"
        android:layout_width="fill_parent"
        android:layout_height="wrap_content"
        android:layout_above="@id/update_database"
        android:layout_alignParentLeft="true"
        android:text="@string/insert" />

    <Button
        android:id="@+id/update"
        android:layout_width="fill_parent"
        android:layout_height="wrap_content"
        android:layout_above="@id/insert"
        android:layout_alignParentLeft="true"
        android:text="@string/update" />

    <Button
        android:id="@+id/query"
        android:layout_width="fill_parent"
        android:layout_height="wrap_content"
        android:layout_alignParentLeft="true"
        android:layout_above="@id/update"
        android:text="@string/query"
        />
    <Button
        android:id="@+id/delete"
        android:layout_width="fill_parent"
        android:layout_height="wrap_content"
        android:layout_alignParentLeft="true"
        android:layout_above="@id/query"
        android:text="@string/delete"
        />
    <Button
        android:id="@+id/delete_database"
        android:layout_width="fill_parent"
        android:layout_height="wrap_content"
        android:layout_alignParentLeft="true"
        android:layout_above="@id/delete"
        android:text="@string/delete_database"
        />


</RelativeLayout>