ORM框架GreenDao
GreenDao官方文档翻译—–http://blog.csdn.net/xushuaic/article/details/24438841
官方文档原文——http://greendao-orm.com/documentation/
官网—–http://greendao-orm.com/
Github源码—— https://github.com/greenrobot/greenDAO
建议首先阅读完官方文档或者中文翻译。
下面以Github上的例子代码为例,从头创建项目并将2个例子揉在一起看看如何使用GreenDao。
1,如果不能使用 Maven 或者 Gradle,可以到官网的连接下载两个jar包,目前最新版本分别为greendao-1.3.7.jar和greendao-generator-1.3.1.jar
然后将jar包引入到工程的lib。
2,Github例子有两个例子,其中DaoExampleGenerator是用来生成数据类,可以理解为bean。而DaoExample这个例子可以直接使用DaoExampleGenerator生成的数据类,并通过greendao来操作数据库。
3,为了防止在DaoGenerator().generateAll(schema, “../”); 生成自动数据的时候报错,还需要导入freemarker.jar库,太老的库还不行,使用最新的就对了
生成Bean数据类
import de.greenrobot.daogenerator.DaoGenerator;
import de.greenrobot.daogenerator.Entity;
import de.greenrobot.daogenerator.Property;
import de.greenrobot.daogenerator.Schema;
import de.greenrobot.daogenerator.ToMany;
public class ExampleDaoGenerator {
public static void main(String[] args) throws Exception {
Schema schema = new Schema(1000, "com.chen.greendaotest");
addNote(schema);
addCustomerOrder(schema);
new DaoGenerator().generateAll(schema, "../GreenDaoTest/src-gen");
}
private static void addNote(Schema schema) {
Entity note = schema.addEntity("Note");
note.addIdProperty();
note.addStringProperty("text").notNull();
note.addStringProperty("comment");
note.addDateProperty("date");
}
private static void addCustomerOrder(Schema schema) {
Entity customer = schema.addEntity("Customer");
customer.addIdProperty();
customer.addStringProperty("name").notNull();
Entity order = schema.addEntity("Order");
order.setTableName("ORDERS"); // "ORDER" is a reserved keyword
order.addIdProperty();
Property orderDate = order.addDateProperty("date").getProperty();
Property customerId = order.addLongProperty("customerId").notNull().getProperty();
order.addToOne(customer, customerId);
ToMany customerToOrders = customer.addToMany(order, customerId);
customerToOrders.setName("orders");
customerToOrders.orderAsc(orderDate);
}
}
main函数执行完之后,会在GreenDaoTest工程目录下的GreenDaoTest/src-gen文件夹生成com\chen\greendaotest包,并生成Note,Customer,Order和对应的Dao。除此之外还包含默认的DaoMaster 和DaoSession类。
生成结束后,就可以在工程中使用了。工程只包含一个ListActivity,其主要功能是通过一个按钮,一个EditText,用户输入的内容生成Note对象。并插入到数据库。并重新查询数据库,将数据库的内容显示在ListView中。
而ListView中存在的Note,则在点击后从数据库删除对应Note,并重新查询显示。
代码如下:
package com.chen.greendaotest;
import java.text.DateFormat;
import java.util.Date;
import android.app.ListActivity;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.os.Bundle;
import android.text.Editable;
import android.text.TextWatcher;
import android.util.Log;
import android.view.KeyEvent;
import android.view.View;
import android.view.inputmethod.EditorInfo;
import android.widget.EditText;
import android.widget.ListView;
import android.widget.SimpleCursorAdapter;
import android.widget.TextView;
import android.widget.TextView.OnEditorActionListener;
import com.chen.greendaotest.DaoMaster.DevOpenHelper;
public class MainActivity extends ListActivity {
private SQLiteDatabase db;
private EditText editText;
private DaoMaster daoMaster;
private DaoSession daoSession;
private NoteDao noteDao;
private Cursor cursor;
@Override
public void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.activity_main);
DevOpenHelper helper = new DaoMaster.DevOpenHelper(this, "notes-db", null);
db = helper.getWritableDatabase();
daoMaster = new DaoMaster(db);
daoSession = daoMaster.newSession();
noteDao = daoSession.getNoteDao();
String textColumn = NoteDao.Properties.Text.columnName;
String orderBy = textColumn + " COLLATE LOCALIZED ASC";
cursor = db.query(noteDao.getTablename(), noteDao.getAllColumns(), null, null, null, null, orderBy);
String[] from = { textColumn, NoteDao.Properties.Comment.columnName };
int[] to = { android.R.id.text1, android.R.id.text2 };
SimpleCursorAdapter adapter = new SimpleCursorAdapter(this, android.R.layout.simple_list_item_2, cursor, from,
to);
setListAdapter(adapter);
editText = (EditText) findViewById(R.id.editTextNote);
addUiListeners();
}
protected void addUiListeners() {
editText.setOnEditorActionListener(new OnEditorActionListener() {
@Override
public boolean onEditorAction(TextView v, int actionId, KeyEvent event) {
if (actionId == EditorInfo.IME_ACTION_DONE) {
addNote();
return true;
}
return false;
}
});
final View button = findViewById(R.id.buttonAdd);
button.setEnabled(false);
editText.addTextChangedListener(new TextWatcher() {
@Override
public void onTextChanged(CharSequence s, int start, int before, int count) {
boolean enable = s.length() != 0;
button.setEnabled(enable);
}
@Override
public void beforeTextChanged(CharSequence s, int start, int count, int after) {
}
@Override
public void afterTextChanged(Editable s) {
}
});
}
public void onMyButtonClick(View view) {
addNote();
}
private void addNote() {
String noteText = editText.getText().toString();
editText.setText("");
final DateFormat df = DateFormat.getDateTimeInstance(DateFormat.MEDIUM, DateFormat.MEDIUM);
String comment = "Added on " + df.format(new Date());
Note note = new Note(null, noteText, comment, new Date());
noteDao.insert(note);
Log.d("DaoExample", "Inserted new note, ID: " + note.getId());
cursor.requery();
}
@Override
protected void onListItemClick(ListView l, View v, int position, long id) {
noteDao.deleteByKey(id);
Log.d("DaoExample", "Deleted note, ID: " + id);
cursor.requery();
}
}