SQLite数据库的创建、常用方法增删改查

首先应该创建一个数据库。
第一建个类继承SQLiteOpenHelper方法，重写onCreate（建表）、onUpgrade（用于版本更新）

package com.example.util;

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

public class DBcreat extends SQLiteOpenHelper {
    public static final String DATABASE_NAME = "users.db";

    public DBcreat(Context context) {
        super(context, DATABASE_NAME, null, 1);

    }

    @Override
    public void onCreate(SQLiteDatabase db) {
        // 创建表格
        String str = new String(
                "create table user (id integer primary key autoincrement , name varchar(20))");
        String str2 = new String(
                "create table unuser (id integer primary key autoincrement , name varchar(20))");
         //执行
        db.execSQL(str);
        db.execSQL(str2);
        String str21 = new String("insert into unuser(name) values (?)");

        db.execSQL(str21, new String[] { "历史回眸" });
        db.execSQL(str21, new String[] { "社员风采" });
        String str1 = new String("insert into user(name) values (?)");

        db.execSQL(str1, new String[] { "社内简介" });
        db.execSQL(str1, new String[] { "本社介绍" });
        db.execSQL(str1, new String[] { "履行职能" });
        db.execSQL(str1, new String[] { "自身建设" });

    }

    @Override//版本更新
    public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
        // TODO Auto-generated method stub

    }

}

数据库常用的一些方法（增加、删除、修改、查询）

package com.example.util;

import java.util.ArrayList;
import java.util.List;

import com.example.bean.Unuser;
import com.example.bean.User;

import android.content.Context;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.util.Log;

public class Dbutil {
    private SQLiteDatabase db;

    public Dbutil(Context context) {
        DBcreat dBcreat = new DBcreat(context);
        db = dBcreat.getWritableDatabase();

    }

    // 添加
    public void addAll(User user) {
        String name = user.getName();
        String str = new String("insert into user(name) values (?)");

        db.execSQL(str, new String[] { name });
        Log.e("", "添加成功");
    }


    // 查询
    public List<User> findAll() {
        List<User> list = new ArrayList<User>();
        Cursor cursor = db.query("user", null, null, null, null, null, null);
        if (cursor != null) {
            int columnIndexid = cursor.getColumnIndex("id");
            int columnIndexname = cursor.getColumnIndex("name");
            while (cursor.moveToNext()) {
                int id = cursor.getInt(columnIndexid);
                String name = cursor.getString(columnIndexname);
                User user = new User(id, name);
                list.add(user);
                Log.e("", "查询成功");
            }
        }

        return list;

    }

    // 删除
    public void deleteAll(User user) {
        String name = user.getName();
        String str = new String("delete from user where name=?");
        db.execSQL(str, new String[] { name });
    }

    // 修改
    public void updateAll(String name, int id) {
        String str = "update user set name =? where id=?";
        db.execSQL(str, new Object[] { name, id });
    }
}