1.查询oracle中的number类型的字段,调用hibernate中的查询方法,会转换成BigDecimal, 2.查询oracle中的varchar2类型的字段,调用hibernate中的查询方法,会转换成String, 不用转换了,方便些 public int getPypxYxjhByXnXqPyxmid(int pyxmid, String xn, String xq){ String sql = "SELECT p.fprs FROM XG_PYPX_YXJH p where p.xn='"+xn+"' and p.xq='"+xq+"' and p.pyxmid='"+pyxmid+"'"; return (int)((BigDecimal)super.executeSQLScalar(sql)).longValue(); //String sql = "SELECT p.xq FROM XG_PYPX_YXJH p where p.xn='"+xn+"' and p.xq='"+xq+"' and p.pyxmid='"+pyxmid+"'"; //return (Integer)super.executeSQLScalar(sql); }
转载于:https://www.cnblogs.com/seein/archive/2012/04/04/2461219.html