public class sqlitedemo extends SQLiteOpenHelper {

    public sqlitedemo(Context context) {
//      String name, CursorFactory factory,
        
        super(context, "xiaoer", null, 1);
        // TODO Auto-generated constructor stub
    }
    
    @Override
    public void onCreate(SQLiteDatabase db) {
        // TODO Auto-generated method stub
        db.execSQL("create table two(_id integer primary key autoincrement,name varchar(30),age varchar(10))");
        Log.i("sqlite","oncreate");
    }

    @Override
    public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
        // TODO Auto-generated method stub
        Log.i("sqlite","onUpgrade");
    }

}

需要繼承自SQLiteOpenHelper

super(context, "xiaoer", null, 1);

有4個參數(shù)第二個是數(shù)據(jù)庫的名字 第三個是用來操作表的填null默認用系統(tǒng)自帶的 1是數(shù)據(jù)庫的版本

varchar： 是類型參數(shù)可以指定對應(yīng)數(shù)的大小

public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion)

是再版本升級的時候會調(diào)用oncreate之會調(diào)用一次 可以進行數(shù)據(jù)庫表的操作等
例如：增加一個字段

db.execSQL("alter table two add heights integer");

增刪該查demo

public class sqliteStudent {

    private SQLiteDatabase db;

    public sqliteStudent(Context context, sqliteTableOpenHelper table) {
        super();

        db = table.getWritableDatabase();
        
        Log.e("haha", db.toString());

    }

    public void add(Student s) {
        db.execSQL("insert into student values(null,?,?)",
                new Object[] { s.getName(), s.getNumber() });
    }

    public void delete(Student s) {
        db.execSQL("delete from student where age=?",
                new Object[] { s.getNumber() });
    }

    public void update(Student s) {
        db.execSQL("update student set name=?", new Object[] { "haha" });
    }

    public Student query(Student s) {
        Cursor rawQuery = db.rawQuery("select *from student where age=?",
                new String[] { s.getNumber() + "" });
        while (rawQuery.moveToNext()) {

        }

        return new Student("xaioer", 20);
    }

}

demo::

package com.example.sqlitedemo3;

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

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

public class studentSqlite {
    private sqliteManager sq;
    private SQLiteDatabase db;

    public studentSqlite(Context context) {

        super();

        sq = new sqliteManager(context);
        db = sq.getWritableDatabase();
    }

    public void add(Student s) {
        db.execSQL("insert into student values(null,?,?)",
                new Object[] { s.getName(), s.getAge() });
    }

    public void delete(Student s) {
        db.execSQL("delete from student where name=?",
                new Object[] { s.getName() });
    }

    public void update(Student s) {

        db.execSQL("update student set name=?", new Object[] { s.getName() });
    }

    public List<Student> query() {
        db = sq.getReadableDatabase();
        Cursor rawQuery = db.rawQuery("select *from student", null);
        List<Student> datas = new ArrayList<Student>();
        Student s = new Student();
        while (rawQuery.moveToNext()) {
            //得到每行對應(yīng)字段的索引通過索引得到對應(yīng)的內(nèi)容
            s.setName(rawQuery.getString(rawQuery.getColumnIndex("name")));
            s.setAge(rawQuery.getString(rawQuery.getColumnIndex("age")));
            datas.add(s);
        }
              //記得關(guān)閉啊
        rawQuery.close();
        return datas;
    }

}





package com.example.sqlitedemo3;

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

public class sqliteManager extends SQLiteOpenHelper {

    public sqliteManager(Context context) {
        super(context, "students", null, 1);
        // TODO Auto-generated constructor stub
    }

    @Override
    public void onCreate(SQLiteDatabase db) {
        // TODO Auto-generated method stub
        db.execSQL("create table student(_id integer primary key autoincrement,name varchar(30),age varchar(10))");
    }

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

}