仓库管理系统部分代码--struts实现

package models; import java.sql.*; import java.util.*; import utils.connectionFactory; public class goodsManager { private Connection conn = null; private Statement stmtg = null; private Statement stmts = null; private Statement stmtin = null; private Statement stmtout=null; private Statement stmtprice=null; private ResultSet rsg = null; private ResultSet rss = null; private ResultSet rsin = null; private ResultSet rsout = null; private ResultSet rsprice = null; private List <Goods> goodses = new ArrayList<Goods>(); public List<Goods> getGoodsList() throws Exception { conn = connectionFactory.getConnection(); stmtg = conn.createStatement(); stmts = conn.createStatement(); stmtin = conn.createStatement(); stmtout = conn.createStatement(); stmtprice = conn.createStatement(); rsg = stmtg.executeQuery("use WHAT select * from Goods"); while(rsg.next()){ Goods goods = new Goods(); goods.setId(rsg.getString(1)); goods.setName(rsg.getString(2)); int amount,ams,amin,amout; rss = stmts.executeQuery("use WHAT select * from Tack_Stock where id="+goods.getId()); boolean f = rss.next(); System.out.println(f); if(!f){ ams = 0; }else{ ams = rss.getInt(2); } amin = 0; rsin = stmtin.executeQuery("use WHAT select * from InBill where goodsId="+goods.getId()); while(rsin.next()){ amin+=rsin.getInt(3); } amout = 0; rsout = stmtout.executeQuery("use WHAT select * from OutBill where goodsId="+goods.getId()); while(rsout.next()){ amout+=rsout.getInt(3); } amount=ams+amin-amout; goods.setAmount(amount); goods.setUnit(rsg.getString(4)); rsprice = stmtprice.executeQuery("use WHAT select * from GoodsPrice where id='"+goods.getId()+"'and Ending_Date is NULL"); f=rsprice.next(); if(!f){ throw new Exception(goods.getName()+"价格设定错误！货物编号："+goods.getId()); } goods.setPrice(rsprice.getDouble(4)); goods.setSC(rsg.getInt(5)); goods.setZC(rsg.getInt(6)); goodses.add(goods); } if(rsg!=null)rsg.close(); if(rss!=null)rss.close(); if(rsin!=null)rsin.close(); if(rsout!=null)rsout.close(); if(rsprice!=null)rsprice.close(); if(stmtg!=null)stmtg.close(); if(stmts!=null)stmts.close(); if(stmtin!=null)stmtin.close(); if(stmtout!=null)stmtout.close(); if(stmtprice!=null)stmtprice.close(); if(conn!=null)conn.close(); return goodses; } public List<Goods> getGoodsList(Goods g) throws Exception { boolean f; conn = connectionFactory.getConnection(); stmtg = conn.createStatement(); stmts = conn.createStatement(); stmtin = conn.createStatement(); stmtout = conn.createStatement(); stmtprice = conn.createStatement(); System.out.println("g.getId输出："+g.getId()+"g.getSC输出:"+g.getSC()); if(g.getId()!=null&&g.getId().equals("")){ g.setId(null); } if(g.getSC()==0){ rsg = stmtg.executeQuery("use WHAT select * from Goods where id='"+g.getId()+"'"); } if(g.getId()==null){ rsg = stmtg.executeQuery("use WHAT select * from Goods where SC='"+g.getSC()+"'"); } if(g.getSC()!=0&&g.getId()!=null){ rsg = stmtg.executeQuery("use WHAT select * from Goods where id='"+g.getId()+"'and SC='"+g.getSC()+"'"); } while(rsg.next()){ Goods goods = new Goods(); goods.setId(rsg.getString(1)); goods.setName(rsg.getString(2)); int amount,ams,amin,amout; rss = stmts.executeQuery("use WHAT select * from Tack_Stock where id="+goods.getId()); f=rss.next(); if(!f){ ams = 0; }else{ ams = rss.getInt(2); } amin = 0; rsin = stmtin.executeQuery("use WHAT select * from InBill where goodsId="+goods.getId()); while(rsin.next()){ amin+=rsin.getInt(3); } amout = 0; rsout = stmtout.executeQuery("use WHAT select * from OutBill where goodsId="+goods.getId()); while(rsout.next()){ amout+=rsout.getInt(3); } amount=ams+amin-amout; goods.setAmount(amount); goods.setUnit(rsg.getString(4)); rsprice = stmtprice.executeQuery("use WHAT select * from GoodsPrice where id='"+goods.getId()+"'and Ending_Date is NULL"); f=rsprice.next(); if(!f){ throw new Exception("价格设定错误！"); } goods.setPrice(rsprice.getDouble(4)); goods.setSC(rsg.getInt(5)); goods.setZC(rsg.getInt(6)); goodses.add(goods); } if(rsg!=null)rsg.close(); if(rss!=null)rss.close(); if(rsin!=null)rsin.close(); if(rsout!=null)rsout.close(); if(rsprice!=null)rsprice.close(); if(stmtg!=null)stmtg.close(); if(stmts!=null)stmts.close(); if(stmtin!=null)stmtin.close(); if(stmtout!=null)stmtout.close(); if(stmtprice!=null)stmtprice.close(); if(conn!=null)conn.close(); return goodses; } }