《Andorid开源》greenDao 数据库orm框架

  1 public class NoteDao extends AbstractDao<Note, Long> {
  2 
  3     public static final String TABLENAME = "NOTE";
  4 
  5     public static class Properties {
  6 
  7         public final static Property Id = new Property(0, Long.class, "id", true, "_id");
  8 
  9         public final static Property Text = new Property(1, String.class, "text", false, "TEXT");
 10 
 11         public final static Property Comment = new Property(2, String.class, "comment", false, "COMMENT");
 12 
 13         public final static Property Date = new Property(3, java.util.Date.class, "date", false, "DATE");
 14 
 15     };
 16 
 17  
 18 
 19     public NoteDao(DaoConfig config) {
 20 
 21         super(config);
 22 
 23     }
 24 
 25    
 26 
 27     public NoteDao(DaoConfig config, DaoSession daoSession) {
 28 
 29         super(config, daoSession);
 30 
 31     }
 32 
 33     /** Creates the underlying database table. */
 34 
 35     public static void createTable(SQLiteDatabase db, boolean ifNotExists) {
 36 
 37         String constraint = ifNotExists? "IF NOT EXISTS ": "";
 38 
 39         db.execSQL("CREATE TABLE " + constraint + "‘NOTE‘ (" + //
 40 
 41                 "‘_id‘ INTEGER PRIMARY KEY ," + // 0: id
 42 
 43                 "‘TEXT‘ TEXT NOT NULL ," + // 1: text
 44 
 45                 "‘COMMENT‘ TEXT," + // 2: comment
 46 
 47                 "‘DATE‘ INTEGER);"); // 3: date
 48 
 49     }
 50 
 51     /** Drops the underlying database table. */
 52 
 53     public static void dropTable(SQLiteDatabase db, boolean ifExists) {
 54 
 55         String sql = "DROP TABLE " + (ifExists ? "IF EXISTS " : "") + "‘NOTE‘";
 56 
 57         db.execSQL(sql);
 58 
 59     }
 60 
 61     /** @inheritdoc */
 62 
 63     @Override
 64 
 65     protected void bindValues(SQLiteStatement stmt, Note entity) {
 66 
 67         stmt.clearBindings();
 68 
 69  
 70 
 71         Long id = entity.getId();
 72 
 73         if (id != null) {
 74 
 75             stmt.bindLong(1, id);
 76 
 77         }
 78 
 79         stmt.bindString(2, entity.getText());
 80 
 81  
 82 
 83         String comment = entity.getComment();
 84 
 85         if (comment != null) {
 86 
 87             stmt.bindString(3, comment);
 88 
 89         }
 90 
 91  
 92 
 93         java.util.Date date = entity.getDate();
 94 
 95         if (date != null) {
 96 
 97             stmt.bindLong(4, date.getTime());
 98 
 99         }
100 
101     }
102 
103     /** @inheritdoc */
104 
105     @Override
106 
107     public Long readKey(Cursor cursor, int offset) {
108 
109         return cursor.isNull(offset + 0) ? null : cursor.getLong(offset + 0);
110 
111     }    
112 
113     /** @inheritdoc */
114 
115     @Override
116 
117     public Note readEntity(Cursor cursor, int offset) {
118 
119         Note entity = new Note( //
120 
121             cursor.isNull(offset + 0) ? null : cursor.getLong(offset + 0), // id
122 
123             cursor.getString(offset + 1), // text
124 
125             cursor.isNull(offset + 2) ? null : cursor.getString(offset + 2), // comment
126 
127             cursor.isNull(offset + 3) ? null : new java.util.Date(cursor.getLong(offset + 3)) // date
128 
129         );
130 
131         return entity;
132 
133     }
134 
135      
136 
137     /** @inheritdoc */
138 
139     @Override
140 
141     public void readEntity(Cursor cursor, Note entity, int offset) {
142 
143         entity.setId(cursor.isNull(offset + 0) ? null : cursor.getLong(offset + 0));
144 
145         entity.setText(cursor.getString(offset + 1));
146 
147         entity.setComment(cursor.isNull(offset + 2) ? null : cursor.getString(offset + 2));
148 
149         entity.setDate(cursor.isNull(offset + 3) ? null : new java.util.Date(cursor.getLong(offset + 3)));
150 
151 }
152    
153 
154     /** @inheritdoc */
155 
156     @Override
157 
158     protected Long updateKeyAfterInsert(Note entity, long rowId) {
159 
160         entity.setId(rowId);
161 
162         return rowId;
163 
164     }
165 
166     /** @inheritdoc */
167 
168     @Override
169 
170     public Long getKey(Note entity) {
171 
172         if(entity != null) {
173 
174             return entity.getId();
175 
176         } else {
177 
178             return null;
179 
180         }
181 
182     }
183 
184     /** @inheritdoc */
185 
186     @Override    
187 
188     protected boolean isEntityUpdateable() {
189 
190         return true;
191 
192     }
193 
194 }

1 Entity note = schema.addEntity("Note");

1 dao.addIntProperty("cityId");
2 dao.addStringProperty("infoType").notNull();//非null字段
3 dao.addDoubleProperty("Id");

1 public List<PhotoGalleryDB> getPhotoGallery()
2 {
3     return photoGalleryDao.loadAll();// 获取图片相册
4 }

1  String updateName = content.getText().toString().trim();
2    QueryBuilder qb2 = studentDao.queryBuilder();
3    qb2.where(Properties.Name.eq("张三"));
4    List<Student> update = qb2.list();
5    String newName = content.getText().toString().trim();
6    for (Student student222 : update) {
7     student222.setAge(20);
8      studentDao.insertOrReplaceInTx(student222);
9    }