SQLite数据库创建、升级、事务处理、添加、更新、删除、查询

只需要创建MyDatabaseHelper类来进行SQLite的所有操作(包括数据库创建、升级数据库、事务处理、添加、更新、删除、查询管理操作等)，可以根据自己的需要在指定的位置添加新增的数据表或数据表字段即可。

package netcx_love8023.csdn.httpblog.mytest.sqlite;

import java.util.Date;

/**
 * Created by xingkong on 2016/02/01.
 */
public class CollectGoods {
    public final String ID="id";
    public final String TABLE_NAME="CollectGoods";
    public final String PICTURE="picture";
    public final String NAME="name";
    public final String PRICE="price";
    public final String DATE="date";

    private long id;
    private String picture;
    private String name;
    private String price;
    private String date;

    public CollectGoods() {
        super();
    }

    public CollectGoods(long id,String picture, String name, String price) {
        this.id=id;
        this.picture = picture;
        this.name = name;
        this.price = price;
        this.date=MyDatabaseHelper.simpleDateFormat.format(new Date());
    }

    public long getId() {
        return id;
    }

    public void setId(long id) {
        this.id = id;
    }

    public String getPicture() {
        return picture;
    }

    public void setPicture(String picture) {
        this.picture = picture;
    }

    public String getName() {
        return name;
    }

    public void setName(String name) {
        this.name = name;
    }

    public String getPrice() {
        return price;
    }

    public void setPrice(String price) {
        this.price = price;
    }

    public String getDate() {
        return date;
    }

    public void setDate(String date) {
        this.date = date;
    }
}

MyDatabaseHelper类完整代码截图

测试Activity类截图