数据库中char字段对应java.lang.Character,只有一个字符,若想转为String,用addScalar方法。
String sql = "select "+sel
+ " from dbo.yj_tab where 1=1 and "
+ " isnull(dbo.yj_tab.freetime,'')='' and (dbo.yj_tab.issuedate between '"+start+"' and '"+end+"')";
Query query = entityManager.createNativeQuery(sql);
List<YjTab> list = query.unwrap(SQLQuery.class)
.addScalar("yjcontent", StandardBasicTypes.STRING)
.addScalar("id", StandardBasicTypes.INTEGER)
.addScalar("iiiii", StandardBasicTypes.STRING)
.addScalar("sta_name", StandardBasicTypes.STRING)
.addScalar("yjtitle", StandardBasicTypes.STRING)
.addScalar("issuedate", StandardBasicTypes.TIMESTAMP)
.addScalar("hissignal", StandardBasicTypes.STRING)
.addScalar("yjcontentnotic", StandardBasicTypes.STRING)
.setResultTransformer(Transformers.aliasToBean(YjTab.class))
.list();
返回的json取别名
@JsonInclude(Include.NON_NULL)
public class YjTab {
private Integer id;
@JsonProperty(value="stationname")
private String iiiii;
if(element[i].equals("iiiii")||element[i].equals("stationname")) {
newyt.setIiiii(yt.getIiiii());
}