sql语句 select sum(xgd) as AA from ht_htxmgx where xmid not in(select inid from kp_xmzd where xmbh='HWNJA7') and htbh='KS01201004058'
直接在oracle中运行结果如图,但是在java程序中确实1,不知道是不是我rs结果集搞错了,请大家帮忙看下
pstmt = conn.prepareStatement("select sum(xgd) as AA from ht_htxmgx where xmid not in(select inid from kp_xmzd where xmbh=?) and htbh=?");
pstmt.setString(1, xmbh);
pstmt.setString(2, htbh);
rs = pstmt.executeQuery();
rs.next();
sum=Integer.parseInt(rs.getString("AA"));