Sqlite

1、继承SqliteOpenHelper类

public class MyOpenHelper extends SQLiteOpenHelper {
    public static final String DB_NAME="student.db";

    public MyOpenHelper(Context context) {
        super(context,DB_NAME,null,1);
    }

    @Override
    public void onCreate(SQLiteDatabase db) {
       db.execSQL("create table person(_id integer primary key autoincrement,name char(10),money integer(10))");
    }

    @Override
    public void onUpgrade(SQLiteDatabase arg0,int arg1,int arg2) {
    }

}

2、获取数据库实例

 MyOpenHelper oh=new MyOpenHelper(getContext()); SQLiteDatabase db=oh.getWritableDatabase();

3、数据库增删查改操作
（1）插入

public void insertDatebase(){
        MyOpenHelper oh=new MyOpenHelper(getContext());
        SQLiteDatabase db=oh.getWritableDatabase();
        db.execSQL("insert into person(name,money) values('ppa',7000);");
        db.close();
    }

（2）更新

public void updateDatabase(){
        MyOpenHelper oh=new MyOpenHelper(getContext());
        SQLiteDatabase db = oh.getWritableDatabase();
        db.execSQL("update person set money=? where name=?",new Object[]{13000,"ppa"});
    }

（3）删除

public void deleteDatabase(){
        MyOpenHelper oh=new MyOpenHelper(getContext());
        SQLiteDatabase db=oh.getWritableDatabase();
        db.execSQL("delete from person where name ='李四'");
        db.close();
    }

(4)查询

public void select(){
        MyOpenHelper oh=new MyOpenHelper(getContext());
        SQLiteDatabase db = oh.getWritableDatabase();
//      Cursor cursor = db.rawQuery("select name,money from person",null);
        Cursor cursor = db.rawQuery("select * from person where name=?",new String[]{"潘平安"} );
        while (cursor.moveToNext()) {
            String name = cursor.getString(cursor.getColumnIndex("name"));
            String money = cursor.getString(2);
            System.out.println(name+";"+money);
        }
    }

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!