return mDaoSession.getUserDao().queryBuilder().
 XXX.
 XXX.
 XXX.
 list();

return mDaoSession.getUserDao().queryBuilder().
 where(UserDao.Properties.UserId.in(userIdList), UserDao.Properties.UserAge.eq(19)).
 list();

String queryString =
 "SELECT DISTINCT " + UserBookDao.Properties.UserName.columnName + " FROM " + UserBookDao.TABLENAME
  + " ORDER BY "
  + UserBookDao.Properties.CreatedTime
  + " DESC "
  + " LIMIT "
  + page * LIMIT_NUM
  + " , "
  + LIMIT_NUM;
 
ArrayList<String> result = new ArrayList<>();
Cursor c = mDaoSession.getDatabase().rawQuery(queryString,new String[]{});
try {
 if (c != null) {
 if (c.moveToFirst()) {
  do {
  result.add(c.getString(0));
  } while (c.moveToNext());
 }
 }
} finally {
 if (c != null) {
 c.close();
 }
}

String queryString =
 "SELECT DISTINCT " + UserBookDao.Properties.UserName.columnName + " FROM " + UserBookDao.TABLENAME // 董铂然博客园
  + " WHERE "
  + UserBookDao.Properties.Publisher.columnName + " = ?"
  + " AND "
  + UserBookDao.Properties.Price.columnName + " > ?"
  + " ORDER BY "
  + UserBookDao.Properties.CreatedTime
  + " DESC ";
 
ArrayList<String> result = new ArrayList<>();
Cursor c = mDaoSession.getDatabase().rawQuery(queryString, new String[]{"某出版社"),
 String.valueOf(100.00)});
try {
 if (c != null) {
 if (c.moveToFirst()) {
  do {
  result.add(c.getString(0));
  } while (c.moveToNext());
 }
 }
} finally {
 if (c != null) {
 c.close();
 }
}

String queryString = "SELECT "
 + UserBookDao.TABLENAME + "." + UserBookDao.Properties.BookName.columnName + ","
 + UserBookDao.TABLENAME + "." + UserBookDao.Properties.Publisher.columnName + ","
 + UserBookDao.TABLENAME + "." + UserBookDao.Properties.Price.columnName + " "
 + "FROM "
 + UserBookDao.TABLENAME + " "
 + "WHERE"
 + UserBookDao.Properties.Price + " > 100.00 ";
Cursor cursor = null;
try {
 cursor = session.getDatabase().rawQuery(queryString,new String[]{});
 if (cursor == null) {
 return payMap;
 }
 // 取出三个字段分别对应的索引，下面再对着索引去取值
 int nameIndex = cursor.getColumnIndex(UserBookDao.Properties.BookName.columnName);
 int publisherIndex = cursor.getColumnIndex(UserBookDao.Properties.Publisher.columnName);
 int priceIndex = cursor.getColumnIndex(UserBookDao.Properties.Price.columnName);
 if (nameIndex != -1 && publisherIndex != -1 && priceIndex != -1) {
 while (cursor.moveToNext()) {
  String name = cursor.getString(nameIndex);
  String publisher = cursor.getString(publisherIndex);
  Double price = cursor.getDouble(priceIndex);
  // 这里取到三个字段 自己是存模型还是字典 自己处理。
 }
 }
} finally {
 if (null != cursor) {
 cursor.close();
 }
}

private boolean hasColumn(SQLiteDatabase db, String tableName, String column) {
 if (TextUtils.isEmpty(tableName) || TextUtils.isEmpty(column)) {
 return false;
 }
 Cursor cursor = null;
 try {
 cursor = db.query(tableName, null, null, null, null, null, null);
 if (null != cursor && cursor.getColumnIndex(column) != -1) {
  return true;
 }
 } finally {
 if (null != cursor) {
  cursor.close();
 }
 }
 return false;
}

private static class DemoOpenHelper extends DaoMaster.OpenHelper {
 public DemoOpenHelper(Context context, String name, SQLiteDatabase.CursorFactory factory) {
 super(context, name, factory);
 }
 @Override
 public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
 // 数据库的版本控制 可以随着版本叠加不断增加差值
 if (oldVersion < 2) {
  if (!hasColumn(db, UserBookDao.TABLENAME, UserBookDao.Properties.Author.columnName)) {
  String sql = "alter table " + UserBookDao.TABLENAME +
   " add COLUMN " + UserBookDao.Properties.Author.columnName + " TEXT";
  db.execSQL(sql);
  }
  if (!hasColumn(db, UserBookDao.TABLENAME, UserBookDao.Properties.Type.columnName)) {
  String sql = "alter table " + UserBookDao.TABLENAME +
   " add COLUMN " + UserBookDao.Properties.Type.columnName + " INTEGER";
  db.execSQL(sql);
  }
 }
 }
}

if (oldVersion < 3) {
 UserDao.dropTable(new StandardDatabase(db),true);
 UserStudentDao.createTable(new StandardDatabase(db),true);
}

private static void addUser(Schema schema) {
 Entity user = schema.addEntity("User");
 user.addIdProperty();
 user.addStringProperty("name").notNull().defValue("\"jack\"");
 user.addStringProperty("address");
 user.addStringProperty("teacher");
 user.addIntProperty("age").primJavaType().defValue("17");
}

@Entity
public class Student {
 @Id(autoincrement = true)
 private long id; //主键
 private String name;
 private String schoolTime = "09-01"; //开学时间默认都是9月1日
 private int age = 19; // 刚上大学的默认都是19岁
 // 下面生成的getter 和setter省略 。。。
}

// 上面判断该列名是否存在
// ...
String sql = "alter table " + UserBookDao.TABLENAME +
 " add COLUMN " + UserBookDao.Properties.Type.columnName + " INTEGER" + " NOT NULL DEFAULT(-1) "; // 直接拼接在语句最后 董铂然博客园
db.execSQL(sql);
// ...