android Sqlitedatabase 应用

2012-07-29 11:31 8人阅读 评论(0) 收藏 举报

package hhh.com;

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

public class bd extends SQLiteOpenHelper {


    public static String DB_NAME = "S.db";
    public static String ID = "_id";
    public static String T_NAME = "stu_list";
    public static int VERSION = 1;
    public static String NAME = "s_name";
    public static String IDCODE = "s_id";
    public static String *** = "s_***";


    public bd(Context context) {
        super(context, DB_NAME, null, VERSION);
    }


    @Override
    public void onCreate(SQLiteDatabase db) {
        // TODO Auto-generated method stub
        String sql = "create table " + T_NAME + " ( " + ID
                + " integer primary key ," + IDCODE + " integer," + NAME
                + " text," + *** + " text)";
        db.execSQL(sql);
    }


    @Override
    public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
        // TODO Auto-generated method stub
        db.execSQL("drop table if exists" + T_NAME);
    }


    public long insert(int idcode, String name, String ***) {
        SQLiteDatabase db = getWritableDatabase();
        long row = 0;
        ContentValues cv = new ContentValues();
        cv.put(IDCODE, idcode);
        cv.put(NAME, name);
        cv.put(***, ***);
        row = db.insert(T_NAME, null, cv);
        return row;
    }
    public void delete(int id) {
        SQLiteDatabase db = getWritableDatabase();
        db.execSQL("delete from " + T_NAME + " where _id =" + id);
    }

    public Cursor qurey(String name) {
        SQLiteDatabase db = getReadableDatabase();
        String sql = "select * from " + T_NAME + " where s_name = ?";
        Cursor cursor = db.rawQuery(sql, new String[] { name });
        return cursor;
    }

    public int update(int _id, int id, String name, String ***) {
        SQLiteDatabase db = getWritableDatabase();
        ContentValues cv = new ContentValues();
        cv.put(IDCODE, id);
        cv.put(NAME, name);
        cv.put(***, ***);
        int flag = db.update(T_NAME, cv, ID + " = ? ",
                new String[] { Integer.toString(_id) });
        return flag;
        // db.execSQL("update " + T_NAME
        // + " set s_id=? , s_name=? , s_***=? where _id=?", new Object[] {
        // id, name, ***, _id });
    }
}

本文原创，转载请注明出处，谢谢合作！