goodsinfodao.java

老牌java开发的物流管理系统 详细的我也没有怎么看 好像是恒基的

				String goodsOrderDate = rs.getString("GoodsOrderDate");
				String goodsStockInDate = rs.getString("GoodsStockInDate");
				String goodsUnit = rs.getString("GoodsUnit");
    			typeId = rs.getInt("TypeId");
				GoodsInfo goodsinfo = new GoodsInfo(id, goodsId, goodsName,
						goodsCateId, goodsSupplyId, goodsABC, goodsProvince,
						goodsCity, goodsStockId, goodsPrice, goodsStockNumber,
						goodsOrderDate, goodsStockInDate, goodsUnit,
						typeId);
				list.add(goodsinfo);
			}
		} catch (SQLException e) {
			e.printStackTrace();
			System.out.println("数据库连接失败!");
		} finally {
			db.closeDB();
		}
		return list;
	}

	/**
	 * 向商品信息表中插入数据记录方法
	 * 
	 * @param goodsinfo
	 * @return boolean
	 */
	// --------------------------向商品信息表中插入数据记录方法--------------------------------------
	public boolean insertGoodsInfo(GoodsInfo goodsinfo) {
		String sql = "insert into goodsinfotable(GoodsId,GoodsName,GoodsCateId,GoodsSupplyId,"
				+ "GoodsABC,GoodsProvince,GoodsCity,GoodsStockId,GoodsPrice,GoodsStockNumber"
				+ ",GoodsOrderDate,GoodsStockInDate,GoodsUnit,TypeId)  values(?,?,?,?,?,?,?,?,?,?,?,?,?,?)";
		db.openDB();
		try {
			db.ps = db.conn.prepareStatement(sql);
			db.ps.setString(1, goodsinfo.getGoodsId());
			db.ps.setString(2, goodsinfo.getGoodsName());
			db.ps.setInt(3, goodsinfo.getGoodsCateId());
			db.ps.setInt(4, goodsinfo.getGoodsSupplyId());
			db.ps.setString(5, goodsinfo.getGoodsABC());
			db.ps.setString(6, goodsinfo.getGoodsProvince());
			db.ps.setString(7, goodsinfo.getGoodsCity());
			db.ps.setInt(8, goodsinfo.getGoodsStockId());
			db.ps.setFloat(9, goodsinfo.getGoodsPrice());
			db.ps.setInt(10, goodsinfo.getGoodsStockNumber());
			db.ps.setString(11, goodsinfo.getGoodsOrderDate());
			db.ps.setString(12, goodsinfo.getGoodsStockInDate());
			db.ps.setString(13, goodsinfo.getGoodsUnit());
			db.ps.setInt(14, goodsinfo.getTypeId());
			db.ps.executeUpdate();
		} catch (SQLException e) {
			e.printStackTrace();
			System.out.println("数据库连接失败!");
		} finally {
			db.closeDB();
		}
		return true;
	}
//	public static void main(String [] args){
//		GoodsInfoDAO dao = new GoodsInfoDAO();
//		dao.insertGoodsInfo("10003","长虹29寸平板彩电",3,3,"B","四川省","成都市",3,3000,20,"2004-06-17","2004-09-10","台",2,1));
//}
	/**
	 * 根据商品信息表自动编号删除商品信息方法
	 * 
	 * @param id
	 * @return boolean
	 */
	// -----------------------根据商品信息表自动编号删除商品信息方法------------------------------------
	public boolean delGoodsInfoByid(int id) {
		String sql = "delete from goodsinfotable where Id =?";
		db.openDB();
		try {
			db.ps = db.conn.prepareStatement(sql);
			db.ps.setInt(1, id);
			db.ps.executeUpdate();
		} catch (SQLException e) {
			e.printStackTrace();
			System.out.println("数据库连接失败!");
		} finally {
			db.closeDB();
		}
		return true;
	}

	/**
	 * 根据商品编号删除商品信息方法
	 * 
	 * @param goodsid
	 * @return boolean
	 */
	// -----------------------根据商品编号删除商品信息方法------------------------------------
	public boolean delGoodsInfoBygoodsid(String goodsid) {
		String sql = "delete from goodsinfotable where GoodsId =?";
		db.openDB();
		try {
			db.ps = db.conn.prepareStatement(sql);
			db.ps.setString(1, goodsid);
			db.ps.executeUpdate();
		} catch (SQLException e) {
			e.printStackTrace();
			System.out.println("数据库连接失败!");
		} finally {
			db.closeDB();
		}
		return true;
	}

	/**
	 * 根据商品名称删除商品信息方法
	 * 
	 * @param goodsname
	 * @return boolean
	 */
	// -----------------------根据商品名称删除商品信息方法------------------------------------
	public boolean delGoodsInfoByGoodsName(String goodsname) {
		String sql = "delete from goodsinfotable where GoodsName =?";
		db.openDB();
		try {
			db.ps = db.conn.prepareStatement(sql);
			db.ps.setString(1, goodsname);
			db.ps.executeUpdate();
		} catch (SQLException e) {
			e.printStackTrace();
			System.out.println("数据库连接失败!");
		} finally {
			db.closeDB();
		}
		return true;
	}

	/**
	 * 根据商品分类编号删除商品信息方法
	 * 
	 * @param goodscateId
	 * @return boolean
	 */
	// -----------------------根据商品分类编号删除商品信息方法------------------------------------
	public boolean delGoodsInfoByGoodsCateId(int goodscateId) {
		String sql = "delete from goodsinfotable where GoodsCateId =?";
		db.openDB();
		try {
			db.ps = db.conn.prepareStatement(sql);
			db.ps.setInt(1, goodscateId);
			db.ps.executeUpdate();
		} catch (SQLException e) {
			e.printStackTrace();
			System.out.println("数据库连接失败!");
		} finally {
			db.closeDB();
		}
		return true;
	}

	/**
	 * 根据商品供应商Id删除商品信息方法
	 * 
	 * @param goodsSupplyId
	 * @return boolean
	 */
	// -----------------------根据商品供应商Id删除商品信息方法------------------------------------
	public boolean delGoodsInfoBySupplyId(int goodsSupplyId) {
		String sql = "delete from goodsinfotable where GoodsSupplyId =?";
		db.openDB();
		try {
			db.ps = db.conn.prepareStatement(sql);
			db.ps.setInt(1, goodsSupplyId);
			db.ps.executeUpdate();
		} catch (SQLException e) {
			e.printStackTrace();
			System.out.println("数据库连接失败!");
		} finally {
			db.closeDB();
		}
		return true;
	}

	/**
	 * 根据商品ABC分类删除商品信息方法
	 * 
	 * @param goodsABC
	 * @return boolean
	 */
	// -----------------------根据商品ABC分类删除商品信息方法------------------------------------
	public boolean delGoodsInfoByGoodsABC(String goodsABC) {
		String sql = "delete from goodsinfotable where GoodsABC =?";
		db.openDB();
		try {
			db.ps = db.conn.prepareStatement(sql);
			db.ps.setString(1, goodsABC);
			db.ps.executeUpdate();
		} catch (SQLException e) {
			e.printStackTrace();
			System.out.println("数据库连接失败!");
		} finally {
			db.closeDB();
		}
		return true;
	}

	/**
	 * 根据商品所在省删除商品信息方法
	 * 
	 * @param goodsPrice
	 * @return boolean
	 */
	// -----------------------根据商品所在省删除商品信息方法------------------------------------
	public boolean delGoodsInfoByGoodsProvince(String goodsPrice) {
		String sql = "delete from goodsinfotable where GoodsProvince =?";
		db.openDB();
		try {
			db.ps = db.conn.prepareStatement(sql);
			db.ps.setString(1, goodsPrice);
			db.ps.executeUpdate();
		} catch (SQLException e) {
			e.printStackTrace();
			System.out.println("数据库连接失败!");
		} finally {
			db.closeDB();
		}
		return true;
	}

	/**
	 * 根据商品所在市删除商品信息方法
	 * 
	 * @param goodscity
	 * @return boolean
	 */
	// -----------------------根据商品所在市删除商品信息方法------------------------------------
	public boolean delGoodsInfoByGoodsCity(String goodscity) {
		String sql = "delete from goodsinfotable where GoodsCity =?";
		db.openDB();
		try {
			db.ps = db.conn.prepareStatement(sql);
			db.ps.setString(1, goodscity);
			db.ps.executeUpdate();
		} catch (SQLException e) {
			e.printStackTrace();
			System.out.println("数据库连接失败!");
		} finally {
			db.closeDB();
		}
		return true;
	}

	/**
	 * 根据商品定购日期删除商品信息方法
	 * 
	 * @param goodsorderdate
	 * @return boolean
	 */
	// -----------------------根据商品定购日期删除商品信息方法------------------------------------
	public boolean delGoodsInfoByOrderDate(String goodsorderdate) {
		String sql = "delete from goodsinfotable where GoodsOrderDate =?";
		db.openDB();
		try {
			db.ps = db.conn.prepareStatement(sql);
			db.ps.setString(1, goodsorderdate);
			db.ps.executeUpdate();
		} catch (SQLException e) {
			e.printStackTrace();
			System.out.println("数据库连接失败!");
		} finally {
			db.closeDB();
		}
		return true;
	}

	/**
	 * 根据商品入库日期删除商品信息方法
	 * 
	 * @param goodstockIndate
	 * @return boolean
	 */
	// -----------------------根据商品入库日期删除商品信息方法------------------------------------
	public boolean delGoodsInfoByStockInDate(String goodstockIndate) {
		String sql = "delete from goodsinfotable where GoodsStockInDate =?";
		db.openDB();
		try {
			db.ps = db.conn.prepareStatement(sql);
			db.ps.setString(1, goodstockIndate);
			db.ps.executeUpdate();
		} catch (SQLException e) {
			e.printStackTrace();
			System.out.println("数据库连接失败!");
		} finally {
			db.closeDB();
		}
		return true;
	}

	/**
	 * 根据商品在库中位置编号删除商品信息方法
	 * 
	 * @param stockregionId
	 * @return boolean
	 */
	// -----------------------根据商品在库中位置编号删除商品信息方法------------------------------------
	public boolean delGoodsInfoBystockRegionId(int stockregionId) {
		String sql = "delete from goodsinfotable where StockRegionId =?";
		db.openDB();
		try {
			db.ps = db.conn.prepareStatement(sql);
			db.ps.setInt(1, stockregionId);
			db.ps.executeUpdate();
		} catch (SQLException e) {
			e.printStackTrace();
			System.out.println("数据库连接失败!");
		} finally {
			db.closeDB();
		}
		return true;
	}

	/**
	 * 根据商品在库中位置编号删除商品信息方法
	 * 
	 * @param typeid
	 * @return boolean
	 */
	// -----------------------根据商品在库中位置编号删除商品信息方法------------------------------------
	public boolean delGoodsInfoByTypeId(int typeid) {
		String sql = "delete from goodsinfotable where TypeId =?";
		db.openDB();
		try {
			db.ps = db.conn.prepareStatement(sql);
			db.ps.setInt(1, typeid);
			db.ps.executeUpdate();
		} catch (SQLException e) {
			e.printStackTrace();
			System.out.println("数据库连接失败!");
		} finally {
			db.closeDB();
		}
		return true;
	}
	// public static void main(String [] args ){
	// GoodsInfoDAO gdao = new GoodsInfoDAO();
	// List<GoodsInfo> list = new ArrayList<GoodsInfo>();
	// list=gdao.selectAllGoodsInfo();
	// Iterator it=list.iterator();
	// while(it.hasNext()){
	// System.out.print(it.next());
	// }
	// }
}