1.因需要查詢實(shí)體表中的code,name兩個(gè)字段,百度說可以自定義查詢實(shí)體類如:public class Entity implements Serializable(){ String code ; String name ;
... public Entity (String code, String name) { super(); this.code = code; this.name = name;
}
}sql語句@Query(value = "select new com.Vo.Entity(code,name) FROM user")
List<Entity> selectEntity();這樣就能將數(shù)據(jù)庫查詢的user表中的code和name字段自動(dòng)添加到entity實(shí)體中,現(xiàn)在保錯(cuò)如下:2018-08-31 18:44:45.113 DEBUG 8528 --> [nio-8080-exec-2] [ org.hibernate.SQL] : select new com.Vo.Entity(code,name) FROM user 2018-08-31 18:44:45.448 WARN 8528 --> [nio-8080-exec-2] [ o.h.engine.jdbc.spi.SqlExceptionHelper] : SQL Error: 923, SQLState:42000 2018-08-31 18:44:45.452 ERROR 8528 --> [nio-8080-exec-2] [ o.h.engine.jdbc.spi.SqlExceptionHelper] : ORA-00923: 未找到要求的 FROM 關(guān)鍵字明明是有from的為什么報(bào)未找到From關(guān)鍵字呢?
1 回答

慕田峪4524236
TA貢獻(xiàn)1875條經(jīng)驗(yàn) 獲得超5個(gè)贊
select new com.Vo.Entity(u.code,u.name) FROM user u
這樣應(yīng)該就OK了
添加回答
舉報(bào)
0/150
提交
取消