sql执行查询报错,Column 'SERIAL_NUM' not found,其中有一种原因,详解如下。
正确举例一:
StringBuilder sql2 = new StringBuilder("select t.id as id,t.name as name from CollegeDoubleChooseActivities t where 1=1 ");
return this.currentSession().createQuery(sql2.toString()).setResultTransformer(Transformers.aliasToBean(CollegeDoubleChooseActivities.class)).list();
正确举例二:
StringBuilder sql2 = new StringBuilder("select t.* from CollegeDoubleChooseActivities t where 1=1 ");
return this.currentSession().createQuery(sql2.toString()).addEntity(CollegeDoubleChooseActivities.class).list();
CollegeDoubleChooseActivities 为数据库表的映射对象。
当select查询某个或某几个字段的时候,查询结果封装转换对象的时候使用setResultTransformer(Transformers.aliasToBean(CollegeDoubleChooseActivities.class));
当select查询全部字段的时候,查询结果封装转换对象的时候使用addEntity(CollegeDoubleChooseActivities.class)
否则会出现此错误。