1.因需要查詢實體表中的code,name兩個字段,百度說可以自定義查詢實體類如: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();這樣就能將數據庫查詢的user表中的code和name字段自動添加到entity實體中,現在保錯如下: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 關鍵字明明是有from的為什么報未找到From關鍵字呢?
添加回答
舉報
0/150
提交
取消