数据库SQLiteOpenHelper自创

增:insert into 表名 (字段名,字段名) values (?,?,?)
删:delete from 表名 where 字段=?
改:update 表名 set 字段=?,字段=? where 条件=?
查:select * form 表名 where 字段=?
(*可以更改为想要查找的内容)

 创建数据库

package com.bawei.zsgcactivity;

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

public class MySqlistHelper extends SQLiteOpenHelper{

    public MySqlistHelper(Context context, String name, CursorFactory factory,
            int version) {
        super(context, name, factory, version);
        // TODO Auto-generated constructor stub
    }

    @Override
    public void onCreate(SQLiteDatabase db) {
        // TODO Auto-generated method stub
        db.execSQL("create  table good (id integer primary key autoincrement,name char(50) not null, price char(50),producter char(50),color char(50) )");
        db.execSQL("insert into good values(null,'小米','1000','北京','黄色')");    
        db.execSQL("insert into good values(null,'华为','1000','上海','红色')");    
        db.execSQL("insert into good values(null,'苹果','1000','深圳','白色')");    

    }

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

}

主方法调用


MySqlistHelper helper=new MySqlistHelper(this, "07a", null, 1);
SQLiteDatabase   dp = helper.getReadableDatabase();

查询

 Cursor  c = dp.rawQuery("select * from good", null);
      
        while (c.moveToNext()) {
            int id = c.getInt(c.getColumnIndex("id"));
            String name=c.getString(c.getColumnIndex("name"));
            String price=c.getString(c.getColumnIndex("price"));
            String producter=c.getString(c.getColumnIndex("producter"));
            String color=c.getString(c.getColumnIndex("color"));
            list.add(new Goods(id, name, price, producter, color));
        
        }

修改

MySqlistHelper  helper=new MySqlistHelper(Xiougai.this, "07a", null, 1);
              dp = helper.getReadableDatabase();
             dp.execSQL("update good set name=?,price=?,producter=?,color=? where id=?", new Object[]{name1,price1,producter1,color1,id}); 

增加

dp.execSQL("insert into good values(null,?,?,?,?)", new Object[]{name,price,producter,color});

删除

dp.execSQL("delete from good where id=?", new Object[]{list.get(position).getId()});

posted @ 2016-01-08 11:51  无名“  阅读(181)  评论(0编辑  收藏  举报