src/com/util/kucunService.java

微信扫码关注公众号，代码整理好后第一时间通知你。

package com.util;

import java.sql.ResultSet;

import com.dao.DB;

public class kucunService
{
	public static int kucunShuliang(int goodsId)
	{
		int kucunshuliang=0;
		DB mydb=new DB();
		try
		{
				String sql="select sum(shuliang) from t_ruku where goodsId=? and del='no'";
				Object[] params1={goodsId};
				mydb.doPstm(sql, params1);
				ResultSet rs=mydb.getRs();
				rs.next();
				int rukugoodsShuliang=rs.getInt(1);
				
				sql="select sum(shuliang) from t_chuku where goodsId=? and del='no'";
				Object[] params2={goodsId};
				mydb.doPstm(sql, params2);
				rs=mydb.getRs();
				rs.next();
				int chukugoodsShuliang=rs.getInt(1);
				kucunshuliang=rukugoodsShuliang-chukugoodsShuliang;
			
		}
		catch(Exception e)
		{
			e.printStackTrace();
		}
		mydb.closed();
		return kucunshuliang;
	}
	
	public static void main(String[] args)
	{
		int i=kucunShuliang(1);
		System.out.println(i);
	}

}