greenDAO 使用初体验

1: 使用的架包:greenDAO-generator.jar ,freemarker.jar,greenDAO.jar
2:   在同一个classpath 路径下建立一个javaProject
3: 引入架包 greenDAO-generator.jar,freemarker.jar
4:编写bean类,dao类,DaoMaster,DaoSession 生成器 代码如下:
package com.guanzhi.daogenerator;

import java.io.IOException;

import de.greenrobot.daogenerator.Entity;
import de.greenrobot.daogenerator.Schema;

public class MyDaoGenerator {

    public static void main(String[] args) {
        Schema schema = new Schema(3, "com.example.db");

        addNote(schema);
        try {
            new de.greenrobot.daogenerator.DaoGenerator().generateAll(schema,
                    "../GrenDaoTest/src-gen");
        } catch (IOException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        } catch (Exception e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        }

    }

    private static void addNote(Schema schema) {

        Entity note = schema.addEntity("Person");
        note.addIdProperty().autoincrement();
        note.addStringProperty("name").notNull();
        note.addStringProperty("age").notNull();
        note.addStringProperty("color").notNull();
        note.addDateProperty("date");

    }

}

5:运行上面的工程
6:如果报src错误,请在指定工程下新建src-gen目录

7: 生成的结构如下图:

8:编写BaseApplication实例化,DaoMaster,DaoSession
package com.example.application;

import com.example.db.DaoMaster;
import com.example.db.DaoSession;
import com.example.db.DaoMaster.DevOpenHelper;

import android.app.Application;
import android.content.Context;
import android.database.sqlite.SQLiteDatabase;

public class BaseApplication extends Application {

	private static BaseApplication mInstance;
	private static final String DB_NAME = "pp-dbs";
	private static DaoMaster mDaoMaster;
	private static DaoSession mDaoSession;

	@Override
	public void onCreate() {
		// TODO Auto-generated method stub
		super.onCreate();
		if (mInstance == null)
			mInstance = this;
	}

	public static DaoMaster getDaoMaster(Context context) {
		if (mDaoMaster == null) {
			DevOpenHelper openHelper = new DevOpenHelper(context, DB_NAME, null);
			SQLiteDatabase db = openHelper.getWritableDatabase();
			mDaoMaster = new DaoMaster(db);
		}
		return mDaoMaster;
	};

	public static DaoSession getDaoSession(Context context) {
		if (mDaoSession == null) {
			if (mDaoMaster == null) {
				getDaoMaster(context);
			}
			mDaoSession = mDaoMaster.newSession();

		}
		return mDaoSession;
	}
}

9:数据操作工具类;
package com.example.db;

import java.util.List;

import com.example.application.BaseApplication;

import android.content.Context;


public class DbService {

             private final String TAG = DbService. class .getSimpleName();
             private static DbService mInstance;
             private static Context mContext;
             private DaoSession mDaoSession ;
             public PersonDao mPersonDao ;

             private DbService() {
            }

             public static DbService getInstance(Context context) {

                         if (mInstance == null) {
                                     mInstance = new DbService();
                                     if (mContext == null) {
                                                 mContext = context.getApplicationContext();
                                    }
                                     mInstance .mDaoSession = BaseApplication.getDaoSession(context);
                                     mInstance .mPersonDao = mInstance .mDaoSession .getPersonDao();
                        }
                         return mInstance ;
            }

             /**
             * 获取所有数据
             *
             * @return
             */
             public List<Person> getAllPerson() {

                         return mPersonDao .loadAll();
            }

             /**
             * 插入数据
             *
             * @param pp
             * @return
             */
             public   long savePerson(Person pp) {
                         return mPersonDao .insert(pp);
            }

             /**
             * 删除数据
             *
             * @param pp
             */
             public void deletePerson(Person pp) {
                         mPersonDao .delete(pp);
            }

             public void deletePersonDetail( long id){
                        
                         mPersonDao .deleteByKey(id);
            }
            
             public void deleteAllData(){
                         mPersonDao .deleteAll();
            }
             /**
             * 更新数据
             *
             * @param pp
             */
             public void updatePerson(Person pp) {

                         mPersonDao .update(pp);
            }

             /**
             * 根据id 获取数据
             *
             * @param id
             * @return
             */
             public Person loadPeron( long id) {
                         return mPersonDao .load(id);
            }

             /**
             * 根据条件查询
             */

             public List<Person> queryPerson(String where, String... params) {

                         return mPersonDao .queryRaw(where, params);
            }
}
10:测试
        package com.example.grendaotest;

import java.util.Date;
import java.util.Iterator;
import java.util.List;
import java.util.Random;

import com.example.db.DaoMaster;
import com.example.db.DaoSession;
import com.example.db.DaoMaster.DevOpenHelper;
import com.example.db.DbService;
import com.example.db.Person;
import com.example.db.PersonDao;
import com.example.db.PersonDao.Properties;

import android.os.Bundle;
import android.app.Activity;
import android.database.sqlite.SQLiteDatabase;
import android.util.Log;
import android.view.Menu;

public class MainActivity extends Activity {

     DbService mDbService;
     private final String TAG = MainActivity.class.getSimpleName();

     @Override
     protected void onCreate(Bundle savedInstanceState) {
          super.onCreate(savedInstanceState);
          setContentView(R.layout.activity_main);
          mDbService = DbService.getInstance(this);

          // Log.e(TAG, "已经插入数据个数:" + createPersonData().size());
          mDbService.deleteAllData();
          createPersonData();
//          deletePer();
          getDataWhere() ;
     }

     /**
     * 删除年龄为100的person
     */
     public void deletePer() {
          for (Iterator<Person> oo = getData().iterator(); oo.hasNext();) {
               Person pp = oo.next();
               if (pp.getAge().equals("100")) {
                    mDbService.deletePerson(pp);

               }
          }
          getData();
     }

     public List<Person> createPersonData() {
          for (int i = 0; i < 10; i++) {
               Person p = new Person();
               p.setAge(99 + i + "");
               p.setColor("红色"+i);
               p.setDate(new Date());
               p.setName("张三" + i);
               mDbService.savePerson(p);
          }
          getData();
          return mDbService.getAllPerson();
     }

     private List<Person> getDataWhere() {

          System.out.println("**********************************************");
          List<Person> dataperson;

          dataperson = (List<Person>) mDbService.mPersonDao.queryBuilder().where(
                    Properties.Age.between("100", "105"),Properties.Color.eq("红色3")).list();
          for (int i = 0; i < dataperson.size(); i++) {
               Log.e(TAG, dataperson.get(i).getAge());
          }
          System.out.println("**********************************************");
          return dataperson;
     }

     private List<Person> getData() {
          System.out.println("一共有" + mDbService.getAllPerson().size() + "条数据");
          for (Iterator<Person> ii = mDbService.getAllPerson().iterator(); ii
                    .hasNext();) {
               Log.e(TAG, "年龄=" + "\n" + ii.next().getAge());
          }
          return mDbService.getAllPerson();
     }

     @Override
     public boolean onCreateOptionsMenu(Menu menu) {
          // Inflate the menu; this adds items to the action bar if it is present.
          getMenuInflater().inflate(R.menu.main, menu);
          return true;
     }

}

其它详情,具体操作
                  http://www.w2bc.com/Article/20726



评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值