JDBC 返回int

最新推荐文章于 2023-04-03 19:56:59 发布

i秋风伴落叶

最新推荐文章于 2023-04-03 19:56:59 发布

阅读量1.6k

点赞数 1

分类专栏： java 方法积累

本文链接：https://blog.csdn.net/zxf1242652895/article/details/53388650

版权

java 方法积累专栏收录该内容

24 篇文章 0 订阅

订阅专栏

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