Hibernate的createSQLQuery在myql下查询表表中含有(boolean)bit字
如下面方法所示:
public List queryKpiData(String tableName, Integer firstResult,Integer maxResults) { StringBuffer sql = new StringBuffer();sql.append("SELECT * FROM ").append(tableName.toUpperCase());Query query = this.getSession().createSQLQuery(sql.toString());query.setFirstResult(firstResult.intValue());query.setMaxResults(maxResults.intValue());List list = query.list(); return list; }