android Sqlite 模板 。

DatabaseHelper.java

import android.content.Context;import android.database.sqlite.SQLiteDatabase;import android.database.sqlite.SQLiteDatabase.CursorFactory;import android.database.sqlite.SQLiteOpenHelper;public class DatabaseHelper extends SQLiteOpenHelper{    private static final String DB_NAME = "foodtherapy.db";    private static final int VERSION = 1;    public DatabaseHelper(Context context, String name, CursorFactory factory,            int version) {        super(context, name, factory, version);    }    public DatabaseHelper(Context context) {        //TODO 初始化数据库        super(context, DB_NAME, null, VERSION);    }     @Override    public void onCreate(SQLiteDatabase db) {        // TODO 创建数据库表        String foodtable = "create table foodtable (id long primary key ,name varchar(45),img varchar(45),menu varchar(255),bar varchar(255),count integer,rcount integer ,fcount integer,summary varchar(255),detailText varchar(255))";        String cooktable = "create table cooktable (id long primary key ,name varchar(45),tag varchar(245),bar TEXT,img varchar(45),message varchar(255),count integer,food varchar(255))";        String newstable = "create table newstable (id long primary key ,title varchar(245),tag varchar(245),message varchar(255),img varchar(45),count integer,author varchar(45),focal integer,time datetime)";        db.execSQL(foodtable);        db.execSQL(cooktable);        db.execSQL(newstable);    }    @Override    public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {        // TODO 更新数据库        db.execSQL("drop table if exists foodtable");        db.execSQL("drop table if exists cooktable");        db.execSQL("drop table if exists newstable");        onCreate(db);    }}

数据库模版生成器

import java.util.ArrayList;import android.content.ContentValues;import android.content.Context;import android.database.Cursor;/** * Database builder template - facilitates adding and getting * objects from SQLite database *  * @author Lukasz Wisniewski * * @param <T> */public abstract class BaseDao<T> {    public DatabaseHelper dbHelper;    public Context context = null;    /**     * Creates object out of cursor     *      * @param c     * @return     */    public abstract T build(Cursor c);    /**     * Puts an object into a ContentValues instance     *      * @param t     * @return     */    public abstract ContentValues deconstruct(T t);    public abstract void insert(T t);    public abstract void delete(long id);    public abstract T select(long id);    public abstract ArrayList<T> findAll();    public abstract boolean isExits(long id);}

Example

import java.text.ParseException;import java.text.SimpleDateFormat;import java.util.ArrayList;import java.util.Date;import android.content.ContentValues;import android.content.Context;import android.database.Cursor;import android.database.sqlite.SQLiteDatabase;import iiijiaban.foodtherapy.db.DatabaseHelper;import iiijiaban.foodtherapy.db.FoodDB;import iiijiaban.foodtherapy.db.NewsDB;public class NewsDBDao extends BaseDao<NewsDB> {    public NewsDBDao(Context context) {        this.context = context;        this.dbHelper = new DatabaseHelper(context);    }    // private long id;//资讯id    // private String title; //资讯标题    // private String tag ;//资讯标签 tag    // private String message ;//资讯 详细内容    // private String img ;//图片    // private int count ;//浏览此时    // private String author; //作者    // private int focal; //是否焦点    // private Date time ;//发布时间    @Override    public NewsDB build(Cursor c) {        int columnid = c.getColumnIndex("id");        int columntitle = c.getColumnIndex("title");        int columntag = c.getColumnIndex("tag");        int columnmessage = c.getColumnIndex("message");        int columnimg = c.getColumnIndex("img");        int columncount = c.getColumnIndex("count");        int columnauthor = c.getColumnIndex("author");        int columnfocal = c.getColumnIndex("focal");        int columntime = c.getColumnIndex("time");         NewsDB fooddb = new NewsDB();        fooddb.setId(c.getLong(columnid));        fooddb.setTitle(c.getString(columntitle));        fooddb.setTag(c.getString(columntag));        fooddb.setMessage(c.getString(columnmessage));        fooddb.setImg(c.getString(columnimg));        fooddb.setCount(c.getInt(columncount));        fooddb.setAuthor(c.getString(columnauthor));        fooddb.setFocal(c.getInt(columnfocal));        SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd hh-mm-ss");        Date date = null;        try {            date = sdf.parse(c.getString(columntime));        } catch (ParseException e) {             e.printStackTrace();        }        fooddb.setTime(date);          return fooddb;    }    @Override    public ContentValues deconstruct(NewsDB t) {        ContentValues values = new ContentValues();        values.put("id", t.getId());        values.put("title", t.getTitle());        values.put("tag", t.getTag());        values.put("message", t.getMessage());        values.put("img", t.getImg());         values.put("count", t.getCount());        values.put("author", t.getAuthor());        values.put("focal", t.getFocal());        SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd hh-mm-ss");        String date = sdf.format(t.getTime());        values.put("time", date);         return values;    }    @Override    public void insert(NewsDB t) {        // TODO Auto-generated method stub        SQLiteDatabase db = dbHelper.getWritableDatabase();        ContentValues values = deconstruct(t);        db.insert("newstable", null, values);        db.close();    }    @Override    public void delete(long id) {        // TODO Auto-generated method stub        SQLiteDatabase db = dbHelper.getWritableDatabase();        db.delete("newstable", "id = " + id, null);        db.close();    }    @Override    public NewsDB select(long id) {        SQLiteDatabase db = dbHelper.getWritableDatabase();        NewsDB newsDB = new NewsDB();        Cursor cursor = db.query("newstable", null, "id = " + id, null, null,                null, null);        cursor.moveToFirst();        while (!cursor.isAfterLast()) {            newsDB = build(cursor);            cursor.moveToNext();        }        db.close();        return newsDB;    }    @Override    public ArrayList<NewsDB> findAll() {        SQLiteDatabase db = dbHelper.getWritableDatabase();        ArrayList<NewsDB> list = new ArrayList<NewsDB>();        Cursor cursor = db.query("newstable", null, null, null, null, null,                null);        cursor.moveToFirst();        while (!cursor.isAfterLast()) {            NewsDB newsDB = new NewsDB();            newsDB = build(cursor);            list.add(newsDB);            cursor.moveToNext();        }        db.close();        return list;    }    @Override    public boolean isExits(long id) {         SQLiteDatabase db = dbHelper.getWritableDatabase();        NewsDB newsDB = null;        Cursor cursor = db.query("newstable", null, "id = " + id, null, null,null, null);        cursor.moveToFirst();        while (!cursor.isAfterLast()) {            newsDB = build(cursor);            cursor.moveToNext();        }        db.close();        if(newsDB!=null){            return true;        }else{            return false;        }    }}