public static int QualityGoodsNum(String start,String end){
Connection conn = null;
PreparedStatement st = null;
ResultSet rs = null;
int count=0;
try {
conn = JdbcUtil.getConnection();
String sql = "select sum(qualityGoodsNum) as qualityGoodsNum from mes_productstatistics where mac in(select mac from mes_machineStatus) and scheduleCode >='"+start+"' and scheduleCode <='"+end+"'";
st = conn.prepareStatement(sql);
System.out.println("该时间段所有机器总的生产数量"+sql);
rs = st.executeQuery();
rs.next();
count = rs.getInt("qualityGoodsNum");
} catch (Exception e) {
e.printStackTrace();
} finally {
JdbcUtil.release(conn, st, rs);
}
return count;
}
JDBC 返回int
最新推荐文章于 2024-08-11 09:30:00 发布