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);
}
1.查询oracle中的number类型的字段,调用hibernate中的查询方法,会转换成BigDecimal,2.查询oracle中的varchar2类型的字段,调用hibernate中的查询方法,会转换成String, 不用转换了,方便些 public int getPypxYxjhByXnXqPyxmid(int pyxmid, String xn, String xq){ St