分享自用ORM工具类。

[img]http://dl.iteye.com/upload/attachment/0067/6944/38aeb00f-33a9-33b7-95fa-310d758630a3.png[/img]
添加
[img]http://dl.iteye.com/upload/attachment/0067/6946/5137853e-a442-34bc-a8e3-e447d84ce018.png[/img]
查询
[img]http://dl.iteye.com/upload/attachment/0067/6948/1cd6e0ab-b406-3eec-b2c6-9ce90cf17be0.png[/img]


Step 1:创建实体对象

@Table(name = "book")
public class Book {
    @Id
    private Long id;

    @Column(name = "book_name")
    private String bookName;

    public Book() {

    }

    public Long getId() {
        return id;
    }

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

    public String getBookName() {
        return bookName;
    }

    public void setBookName(String bookName) {
        this.bookName = bookName;
    }

}

Step 2:创建 DatabaseHelper

public class DatabaseHelper extends SQLiteOpenHelper {
    public static final String BOOK_TABLE_NAME = "orm_book";

    public static final String DATABASE_NAME = "OrmDemo.db";

    public DatabaseHelper(Context context) {
        super(context, DATABASE_NAME, null, 1);
    }

    @Override
    public void onCreate(SQLiteDatabase db) {
        TableUtils.createTable(db, true, Book.class);
    }

    @Override
    public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
        TableUtils.dropTable(db, Book.class);
        onCreate(db);
    }

}

Step 3:创建 DatabaseService

public class DatabaseService {
    private Context mContext;

    private DatabaseHelper mDatabaseHelper;

    private SQLiteDatabase mSQLiteDatabase;

    private AhibernateDao<Book> mBookDao;

    public DatabaseService(Context context) {
        this.mContext = context;
        this.mDatabaseHelper = new DatabaseHelper(mContext);
        this.mSQLiteDatabase = mDatabaseHelper.getWritableDatabase();

        this.mBookDao = new AhibernateDao<Book>(this.mSQLiteDatabase);
    }

    // ===================book begin===========================
    public List<Book> getBooksByWhere(Map<String, String> where) {
        List<Book> bookList = mBookDao.queryList(Book.class, where);
        return bookList;
    }

    public List<Book> getBooks(Book book) {
        List<Book> bookList = mBookDao.queryList(book);
        return bookList;
    }

    public int addBook(Book book) {
        return mBookDao.insert(book);
    }

    public void updateBook(Book book, Map<String, String> where) {
        mBookDao.update(book, where);
    }

    public void deleteBook(Map<String, String> where) {
        mBookDao.delete(Book.class, where);
    }
    // ===================book end===============================

Step 4:创建Activity

public class OrmDemoActivity extends Activity {
    /** Called when the activity is first created. */
    DatabaseService mDatabaseService;

    Button mAddButton;

    Button mQueryButton;

    TextView mTextView;

    @Override
    public void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.main);
        mAddButton = (Button) findViewById(R.id.add);
        mQueryButton = (Button) findViewById(R.id.query);
        mTextView = (TextView) findViewById(R.id.count);
        mDatabaseService = new DatabaseService(this);
        mAddButton.setOnClickListener(new OnClickListener() {
            @Override
            public void onClick(View arg0) {
                Book book = new Book();
                Random ra = new Random();
                book.setId(ra.nextLong());
                book.setBookName("demo");
                mDatabaseService.addBook(book);
                Toast.makeText(OrmDemoActivity.this, "添加成功", Toast.LENGTH_SHORT).show();
            }
        });

        mQueryButton.setOnClickListener(new OnClickListener() {
            @Override
            public void onClick(View v) {
                mTextView.setText("总共有" + mDatabaseService.getBooksByWhere(null).size() + "本书");
            }
        });
    }

工具类源码地址：http://ahibernate.googlecode.com/svn/trunk/