JDBC 返回int

- 日理万妓 2021-10-08 05:38 313阅读 0赞 
  1. public static int QualityGoodsNum(String start,String end){
  2.     Connection conn = null;
  3.     PreparedStatement st = null;
  4.     ResultSet rs = null;
  5.     int count=0;
  6.     try {
  7.     conn = JdbcUtil.getConnection();
  9.     String sql = "select sum(qualityGoodsNum) as qualityGoodsNum from mes_productstatistics where mac in(select mac from mes_machineStatus) and scheduleCode >='"+start+"' and scheduleCode <='"+end+"'";
  10.     st = conn.prepareStatement(sql);
  11.     System.out.println("该时间段所有机器总的生产数量"+sql);
  12.     rs = st.executeQuery();
  14.     rs.next();
  15.     count = rs.getInt("qualityGoodsNum");
  16.     } catch (Exception e) {
  17.     e.printStackTrace();
  18.     } finally {
  19.     JdbcUtil.release(conn, st, rs);
  20.     }
  21.     return count;
  22.     }

发表评论

表情：
评论列表 （有 0 条评论，313人围观）

还没有评论，来说两句吧...

相关阅读