@SuppressWarnings("unchecked")	public SimplePage
    
      listPage(WorkFlowEventDto condition, int start, int limit) {		StringBuilder selectColumnSql = new StringBuilder("SELECT a.`id` as id,g.name as resourceType,b.name as instanceName,pin.`serial_num` AS instanceNumber," +				"h.`op_name` as operation,a.status as status,a.`create_time` as createdTime,c.`vm_name` as vmName" +				",d.`vdisk_name` as vdiskName,e.`file_sys_name` as fsName");		StringBuilder selectCountSql = new StringBuilder("select count(a.id)");		StringBuilder sql = new StringBuilder(				" FROM work_flow_event a LEFT JOIN resource_instance b ON a.`resourece_instance_id`=b.`id`" +				" LEFT JOIN product_instance pin ON pin.`id`=b.`product_instance_id`" +				" LEFT JOIN vm_res_instance c ON b.id=c.`vm_id` LEFT JOIN vdisk_resource_instance d ON b.`id`=d.`vdisk_id`" +				" LEFT JOIN file_sys_resource_instance e ON b.`id`=e.`file_sys_id` LEFT JOIN resource f ON b.`resource_id`=f.`id`" +				" LEFT JOIN resource_type g ON f.`type_id`=g.`id` LEFT JOIN work_flow h ON a.event_type=h.op_type WHERE 1=1");		List
     
    

这是一个按条件分页查询，主要就是用hibernate查询出对象，WorkFlowEventDto不是一个hibernate实体，重要的不是上边那堆，注意看下边。