hibernate ---oracle

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);}