stockoutinfodao.java

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

package com.wl.dao;

import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;

import com.wl.dbconnection.DBManager;

import com.wl.entity.StockOutInfo;

/**
 * 出库单信息表
 * 
 * @author FengBo
 * 
 */
public class StockoutinfoDAO {
	/**
	 * 向出库单信息表添加信息
	 * 
	 * @return boolean
	 */
	DBManager db = new DBManager();
	boolean flag;

	public boolean AddInsertStockout(StockOutInfo stcokout) {
		flag = db.openDB();
		// System.out.print(flag);
		if (flag) {
			try {
				db.ps = db.conn
						.prepareStatement("insert into stockoutinfotable values(?,?,?,?,?,?,?,?,?)");
				db.ps.setString(1, stcokout.getStockOutId());
				db.ps.setString(2, stcokout.getStockOutDate());
				db.ps.setInt(3, stcokout.getChargeId());
				db.ps.setInt(4, stcokout.getGoodsId());
				db.ps.setInt(5, stcokout.getGoodsOutNumber());
				db.ps.setString(6, stcokout.getGoodsReceive());
				db.ps.setInt(7, stcokout.getTypeId());
				db.ps.setInt(8, stcokout.getCommodityId());
				db.ps.setString(9, stcokout.getGoodsOutMemo());
				db.ps.executeUpdate();
			} catch (SQLException e) {
				return false;
			} finally {
				db.closeDB();
			}
			return true;
		} else {
			return false;
		}
	}

	/**
	 * 根据出库单编号删除出库单信息
	 * 
	 * @param stockOutId
	 * @return true
	 */
	public boolean deletestockOutId(String stockOutId) {
		String sql = "delete stockoutinfotable where stockOutId=?";
		DBManager db = new DBManager();
		db.openDB();// 打开数据库
		try {
			db.ps = db.conn.prepareStatement(sql);
			db.ps.setString(1, stockOutId);
			db.ps.executeUpdate();
		} catch (SQLException e) {
			return false;
		} finally {
			db.closeDB();// 关闭数据库
		}
		return true;
	}

	/**
	 * 根据出库商品ID删除出库单信息
	 * 
	 * @param d
	 * @return true
	 */
	public boolean deletegoodsId(int goodsId) {
		String sql = "delete stockoutinfotable where goodsId=?";
		DBManager db = new DBManager();
		db.openDB();
		try {
			db.ps = db.conn.prepareStatement(sql);
			db.ps.setInt(1, goodsId);
			db.ps.executeUpdate();
		} catch (SQLException e) {
			return false;
		} finally {
			db.closeDB();
		}
		return true;
	}

	/**
	 * 
	 * @param stockId
	 * @return
	 */
	public boolean deletestockoutId(int id) {
		String sql = "delete stockoutinfotable where id=?";
		DBManager db = new DBManager();
		db.openDB();
		try {
			db.ps = db.conn.prepareStatement(sql);
			db.ps.setInt(1, id);
			db.ps.executeUpdate();
		} catch (SQLException e) {
			return false;
		} finally {
			db.closeDB();
		}
		return true;
	}

	/**
	 * 查询所有出库单信息
	 * 
	 * @return list
	 */
	public List<StockOutInfo> selectStockoutinfo() {
		List<StockOutInfo> list = new ArrayList<StockOutInfo>();
		flag = db.openDB();
		StockOutInfo stockout = null;
		String sql = "select stockoutinfotable.id,StockOutId,StockOutDate,ChargeId,stockoutinfotable.GoodsId,GoodsOutNumber,GoodsReceivePerson,stockoutinfotable.TypeId,CommodityId,GoodsOutMemo,goodsname from stockoutinfotable,goodsinfotable where goodsinfotable.id=stockoutinfotable.goodsid";
		if (flag) {
			try {
				db.ps = db.conn.prepareStatement(sql);
				ResultSet st = db.ps.executeQuery();
				while (st.next()) {
					stockout = new StockOutInfo(st.getInt(1), st.getString(2),
							st.getString(3), st.getInt(4), st.getInt(5), st
									.getInt(6), st.getString(7), st.getInt(8),
							st.getInt(9), st.getString(10), st.getString(11));
					list.add(stockout);
				}
			} catch (SQLException e) {
				System.out.println("查询出错");
			} finally {
				db.closeDB();
			}

		}
		return list;
	}

	public List<StockOutInfo> selectStockoutinfoBystockoutid(String stockoutid) {
		List<StockOutInfo> list = new ArrayList<StockOutInfo>();
		flag = db.openDB();
		StockOutInfo stockout = null;
		String sql = "select * from stockoutinfotable where StockOutId =?";
		if (flag) {
			try {
				db.ps = db.conn.prepareStatement(sql);
				db.ps.setString(1, stockoutid);
				ResultSet st = db.ps.executeQuery();
				while (st.next()) {
					stockout = new StockOutInfo(st.getString(2), st
							.getString(3), st.getInt(4), st.getInt(5), st
							.getInt(6), st.getString(7), st.getInt(8), st
							.getInt(9), st.getString(10));
					list.add(stockout);
				}
			} catch (SQLException e) {
				System.out.println("查询出错");
			} finally {
				db.closeDB();
			}

		}
		return list;
	}

	/**
	 * 分页查询
	 */
	public List<StockOutInfo> selectstockoutPage(int pageSize, int pageNum){
		 List<StockOutInfo> list = new  ArrayList<StockOutInfo>();
		 flag =db.openDB();// 打开数据库
		 if(flag){
			 try{
				 db.ps = db.conn.prepareStatement("select top " + pageSize
							+ "* from stockoutinfotable where Id not in(select top "
							+ pageSize * pageNum
							+ " Id from stockoutinfotable order by Id)order by Id");
				 ResultSet st=db.ps.executeQuery();
				 while(st.next()){
					    StockOutInfo stockout = new StockOutInfo(st.getString(2),
						st.getString(3),st.getInt(4),st.getInt(5),st.getInt(6),
						st.getString(7),st.getInt(8),st.getInt(9),st.getString(10));	 
						list.add(stockout);
					}
			 }catch(Exception e){
				 System.out.print("数据库连接失败!！");
			 }finally {
					db.closeDB();// 关闭数据库
				}
		 }
		return list;
			 
			}

	/**
	 * 通过页面大小获取总页数(2009.2.17 袁新锋修改)
	 * 
	 * @param pageSize
	 * @return num
	 */
	public int getPageNum(int pageSize) {
		int num = 0;
		db.openDB();// 打开数据库
		try {
			db.ps = db.conn
					.prepareStatement("select count(*) from stockoutinfotable");
			ResultSet rs = db.ps.executeQuery();
			while (rs.next()) {
				num = rs.getInt(1);
			}
			if (num % pageSize == 0) {
				return num / pageSize;
			} else {
				return num / pageSize + 1;
			}
		} catch (SQLException e) {
			System.out.println("数据库连接失败！");
			e.printStackTrace();
		} finally {
			db.closeDB();
		}
		return num;
	}

}