Hibernate字段查询问题小记
我有一个实体类，包含了BLOB字段和集合属性字段，有时候查询希望排除BLOB字段和集合属性字段，有时候又希望只排除其中一个，这时问题就来了。
本来BLOB字段也可以设为lazy为true的，但是要做什么字节码强化，我想走走其他路子。
EntityBean
public class FormInfo {@Id@GeneratedValue(strategy=GenerationType.AUTO)//主键private long id;@Column(name="owner_id")//所有者主键private long ownerId;@Column(name="title_text",nullable=false)//标题private String titleText;@OneToMany(cascade={CascadeType.ALL}, fetch=FetchType.LAZY)@org.hibernate.annotations.Cascade(org.hibernate.annotations.CascadeType.DELETE_ORPHAN)@JoinColumn(name="forminfo_id")//字段private Set<FieldInfo> fields;@Basic(fetch=FetchType.LAZY)@Lob@Column(name="source_code",columnDefinition="CLOB")//表单源码private String sourceCode;@Column(name="table_name",unique=true,nullable=false)//数据表名private String tableName;@Column(name="create_time")//创建时间private Timestamp createTime;@Column(name="update_time")//修改时间private Timestamp updateTime;//描述private String description;//删除标记private boolean deleted;//锁定标记private boolean locked; //完成标记private boolean completed;@Column(name="module_id")//模块主键private long moduleId;public FormInfo(){}//为HQL准备 日期类型改为java.util.Date类型，不然会报找不到构造方法异常public FormInfo(long id, long ownerId, String titleText,Set<FieldInfo> fields, String tableName, java.util.Date createTime,java.util.Date updateTime, String description, boolean deleted,boolean locked, boolean completed, long moduleId) {super();this.id = id;this.ownerId = ownerId;this.titleText = titleText;this.fields = fields;this.tableName = tableName;this.createTime = new java.sql.Timestamp(createTime.getTime());this.updateTime = new java.sql.Timestamp(updateTime.getTime());this.description = description;this.deleted = deleted;this.locked = locked;this.completed = completed;this.moduleId = moduleId;}public FormInfo(long id, long ownerId, String titleText, String tableName,java.util.Date createTime, java.util.Date updateTime, String description,boolean deleted, boolean locked, boolean completed, long moduleId) {super();this.id = id;this.ownerId = ownerId;this.titleText = titleText;this.tableName = tableName;this.createTime = new java.sql.Timestamp(createTime.getTime());this.updateTime = new java.sql.Timestamp(updateTime.getTime());this.description = description;this.deleted = deleted;this.locked = locked;this.completed = completed;this.moduleId = moduleId;}//...省略getter、setter}public class BeanUtils {private static Log logger = LogFactory.getLog(BeanUtils.class);/** * @param entityClass 实体类 * @param prefix 前缀 * @param fields 要过滤的字段列表 * @return 返回逗号分隔的entityClass的所有声明字段，排除filters指定的字段 */public static String getFieldNames(Class entityClass, String prefix, String... filters){Field[] fs = entityClass.getDeclaredFields();StringBuilder sb = new StringBuilder();String p = prefix != null ? prefix : "";for(int i=0;i<fs.length;i++){Field f = fs[i];if(contains(f.getName(), filters)){continue;}if(i>0)sb.append(",");sb.append(p + f.getName());}return sb.toString();}private static boolean contains( String f, String... fs){if(fs == null)return false;boolean result = false;for(int i=0; i<fs.length; i++){if(fs[i].indexOf(",") != -1){return contains(f, fs[i].split(","));}else{if(f.equals(fs[i])){result = true;break;}}}return result;}}