int id = getInt("id", 0);	// 如果有id参数并且值为整数类型，则转换为int类型，否则返回默认值0
float price = getFloat("price", 0);
long time = getLong("timestamp", 0L);
String name = getString("name");
String sex = getString("sex", "^(male|female)$", "male");

Clause clause = Clause.compose();
clause.and("id in (*)", 1, 2, 3, 4);	// 用*号代替需要指定确切数量的?
clause.and("is_delete = ?", false);
// 不再需要拼接又臭又长的where语句
Sheet users = Db.paginate(pageIndex, pageSize, "select *", "from tb_users {WHERE} order by id desc", clause);

// 使用*号代替需要指定确切数量的?
Long count = Db.queryLong("select count(*) from table where id in (*)", 1, 2, 3, 4);

[
	{
		"test": "2:lisi",
		"province_id": 3,
		"sex": true,
		"name": "lisi",
		"id": 2,
		"friends": [
			{
				"friend_name": "lilan",
				"friend_id": 3,
				"user_id": 2,
				"id": 3
			},
			{
				"friend_name": "huamulan",
				"friend_id": 4,
				"user_id": 2,
				"id": 4
			}
		],
		"fmt_reg_time": "2015-10-13 23:14"
	}
]