自己整理的androidstudio操作sqlite

1.操作界面activity_sqlite.xml文件

<?xml version="1.0" encoding="utf-8"?>
<LinearLayout xmlns:android="http://schemas.android.com/apk/res/android"
    xmlns:app="http://schemas.android.com/apk/res-auto"
    xmlns:tools="http://schemas.android.com/tools"
    android:layout_width="match_parent"
    android:layout_height="match_parent"
    android:orientation="vertical"
    tools:context="com.example.hyld.SQLiteActivity">

    <Button
        android:id="@+id/createDatabase"
        android:layout_width="fill_parent"
        android:layout_height="wrap_content"
        android:text="createDatabse"/>
    <Button
        android:id="@+id/updateDatabase"
        android:layout_width="fill_parent"
        android:layout_height="wrap_content"
        android:text="updateDatabase"/>
    <Button
        android:id="@+id/insert"
        android:layout_width="fill_parent"
        android:layout_height="wrap_content"
        android:text="insert"/>
    <Button
        android:id="@+id/update"
        android:layout_width="fill_parent"
        android:layout_height="wrap_content"
        android:text="update"/>
    <Button
        android:id="@+id/query"
        android:layout_width="fill_parent"
        android:layout_height="wrap_content"
        android:text="query"/>
    <Button
        android:id="@+id/delete"
        android:layout_width="fill_parent"
        android:layout_height="wrap_content"
        android:text="delete"/>

</LinearLayout>

2.sql基础配置文件DatabaseHelper

package com.example.hyld;

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

public class DatabaseHelper extends SQLiteOpenHelper{
    private static final int VERSION = 1;
    private static final String SWORD="SWORD";
    //三个不同参数的构造函数
    //带全部参数的构造函数，此构造函数必不可少
    public DatabaseHelper(Context context, String name, CursorFactory factory,
                          int version) {
        super(context, name, factory, version);

    }
    //带两个参数的构造函数，调用的其实是带三个参数的构造函数
    public DatabaseHelper(Context context,String name){
        this(context,name,VERSION);
    }
    //带三个参数的构造函数，调用的是带所有参数的构造函数
    public DatabaseHelper(Context context,String name,int version){
        this(context, name,null,version);
    }
    //创建数据库
    public void onCreate(SQLiteDatabase db) {
        //Log.i(SWORD,"create a Database");
        //创建数据库sql语句
        String sql = "create table users(id int,name varchar(20))";
        //String sql2 = "create table zouyang(id int,name varchar(20))";
        //执行创建数据库操作
        db.execSQL(sql);
        //db.execSQL(sql2);
    }

    @Override
    public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
        //创建成功，日志输出提示
        //Log.i(SWORD,"update a Database");
    }

}

3.数据库操作文件SQLiteActivity

package com.example.hyld;

import com.example.hyld.DatabaseHelper;
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.view.View.OnClickListener;
import android.widget.Button;
import android.widget.Toast;

public class SQLiteActivity extends Activity{

    private final static String SWORD="SWORD";

    Button createDatabase;
    Button updateDatabase;
    Button insert;
    Button update;
    Button query;
    Button delete;
    DatabaseHelper dbHelper = new DatabaseHelper(SQLiteActivity.this, "test_db");

    public void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.activity_sqlite);
        init();
    }

    private void init() {
        //根据控件ID得到控件
        createDatabase = (Button) this.findViewById(R.id.createDatabase);
        updateDatabase = (Button) this.findViewById(R.id.updateDatabase);
        insert = (Button) this.findViewById(R.id.insert);
        update = (Button) this.findViewById(R.id.update);
        query = (Button) this.findViewById(R.id.query);
        delete = (Button) this.findViewById(R.id.delete);

        //创建数据库
        createDatabase.setOnClickListener(new OnClickListener() {
            @Override
            public void onClick(View v) {
                try {
                    SQLiteDatabase db1 = dbHelper.getReadableDatabase();
                } catch (Exception e) {
                    Toast.makeText(SQLiteActivity.this,"创建数据库失败~~",Toast.LENGTH_SHORT).show();
                    e.printStackTrace();
                } finally {

                }

            }
        });

        //更新数据库
        updateDatabase.setOnClickListener(new OnClickListener() {
            @Override
            public void onClick(View v) {
                DatabaseHelper dbHelper2 = new DatabaseHelper(SQLiteActivity.this, "test_db", 2);
                SQLiteDatabase db2 = dbHelper.getReadableDatabase();
            }
        });

        //插入数据
        insert.setOnClickListener(new OnClickListener() {
            @Override
            public void onClick(View v) {
                try {
                    //创建存放数据的ContentValues对象
                    ContentValues values = new ContentValues();
                    //像ContentValues中存放数据
                    values.put("id", 1);
                    values.put("name","zhangsan");
                    SQLiteDatabase db3 = dbHelper.getWritableDatabase();
                    //数据库执行插入命令
                    db3.insert("users", null, values);
//                ContentValues values1 = new ContentValues();
//                values1.put("id", 1);
//                values1.put("name","boo");
//                SQLiteDatabase db = dbHelper.getWritableDatabase();
//                db.insert("zouyang",null, values1);
                   Toast.makeText(SQLiteActivity.this,"插入成功~~",Toast.LENGTH_SHORT).show();
                } catch (Exception e) {
                    Toast.makeText(SQLiteActivity.this,"插入失败~~",Toast.LENGTH_SHORT).show();
                    e.printStackTrace();
                } finally {

                }

            }
        });

        //修改数据
        update.setOnClickListener(new OnClickListener() {
            @Override
            public void onClick(View v) {
                SQLiteDatabase db4 = dbHelper.getWritableDatabase();
                ContentValues values2 = new ContentValues();
                values2.put("name", "xiaosan");
                db4.update("users", values2, "id=?", new String[]{"1"});
                Toast.makeText(SQLiteActivity.this,"修改成功~~",Toast.LENGTH_SHORT).show();
            }
        });

        //查询数据
        query.setOnClickListener(new OnClickListener() {
            @Override
            public void onClick(View v) {
                try {
                    SQLiteDatabase db5 = dbHelper.getReadableDatabase();
                    //创建游标对象
                    Cursor cursor = db5.query("users", new String[]{"id","name"}, "id=?", new String[]{"1"}, null, null, null, null);
                    //利用游标遍历所有数据对象
                    while(cursor.moveToNext()){
                        String name = cursor.getString(cursor.getColumnIndex("name"));
                        Toast.makeText(SQLiteActivity.this,name,Toast.LENGTH_SHORT).show();
                    }
//                Cursor cursor = db5.query("zouyang", new String[]{"id","name"}, "id=?", new String[]{"1"}, null, null, null, null);
//                while(cursor.moveToNext()){
//                    String b = cursor.getString(cursor.getColumnIndex("name"));
//                    Toast.makeText(SQLiteActivity.this,b,Toast.LENGTH_SHORT).show();
//                }
                } catch (Exception e) {
                    String result = e.getMessage()+"";
                    Toast.makeText(SQLiteActivity.this,"查询失败:"+result,Toast.LENGTH_SHORT).show();
                    e.printStackTrace();
                } finally {

                }

            }
        });

        //删除数据
        delete.setOnClickListener(new OnClickListener() {
            @Override
            public void onClick(View v) {
                SQLiteDatabase db6 = dbHelper.getWritableDatabase();
                db6.delete("userinfo", "id=?", new String[]{"1"});
            }
        });
    }

}