基于Java框架开发的WMS管理系统+完整源码+数据库备份

基于Java框架开发的WMS管理系统+完整源码+数据库备份，

package kaga.Dao.Impl;

import java.sql.ResultSet;
import java.text.DecimalFormat;
import java.util.ArrayList;
import java.util.List;
import java.util.Map;

import javax.servlet.http.HttpServletRequest;

import org.apache.struts2.ServletActionContext;

import com.opensymphony.xwork2.ActionContext;

import kaga.it.Tools.JDBCUtil;
import kaga.it.Model.PickShortage;
import kaga.it.Model.InventoryReport;
import kaga.it.Model.inboundHistory;
import kaga.it.Model.inventory_summary;
import kaga.it.Model.pickSummary;
import kaga.it.Model.item;
import kaga.it.Model.PickShortageByPO;
import kaga.it.Model.InboundDetail;

public class WMSExcelExportDao {
	/*
	 * @ClassName: WMS各功能导出
	 * 
	 * @Description:dfdfd
	 * 
	 * @author Fish_Wang@kaga.com.cn
	 * 
	 * @date 2012-11-21 下午04:19:27
	 */
	private java.sql.Connection conn = null;
	private java.sql.PreparedStatement pstmt = null;
	private ResultSet rs = null;

	// PickShortageByPO List

	public List PickShortageByPO（String keyword） {

		System.out.println（“PickShortageByPO“）;

		List list = new ArrayList（）;
		try {
			conn = JDBCUtil.getConn（）;
			pstmt = conn.prepareStatement（“select * from  kg_inbounditem“）;
			rs = pstmt.executeQuery（）;

			while （rs.next（）） {

				PickShortageByPO p = new PickShortageByPO（）;

				p.setCODE（rs.getString（“ref_no“））;

				p.setDEscriptION（rs.getString（“part_desc1“））;

				p.setQTY（rs.getString（“qty_order“））;

				p.setHKGSTOCK（rs.getString（“ref_no“））;

				p.setSHORTAGE（rs.getString（“ref_no“））;

				p.setOVERAGE（rs.getString（“ref_no“））;

				p.setPONO（rs.getString（“pono_china“））;

				p.setKAGAJPPONO（rs.getString（“pono_kaga“））;

				p.setLOTNO（rs.getString（“lot_no“））;

				p.setLOTNOSEQ（rs.getString（“ref_no“））;

				list.add（p）;

			}
			JDBCUtil.free（rs pstmt conn）;
			// write（list）;
		} catch （Exception ce） {
			System.out.println（“获取记录集失败“）;
			ce.printStackTrace（）;
		}
		return list;
	}

	// PickShortage Data List

	public List PickShortage（String keyword） {
		
		ActionContext actionContext = ActionContext.getContext（）;
		Map session = actionContext.getSession（）;


		List list = new ArrayList（）;
		try {
			conn = JDBCUtil.getConn（）;

			String CurrentSQL = “select sum（ROUND（OUB.dime_l*OUB.dime_w*OUB.dime_h/10000003）） as CBMifnull（OUB.price_orig 0.00000） as price_origifnull（OUB.curr ‘‘） as currOUB.ctn_nwOUB.ctn_gwOUB.rmksOUB.partsnOUB.pallet_noOUB.ref_noOUB.outbound_idOUB.partno_cnOUB.partno_kagaOUB.part_desc1OUB.part_desc2OUB.part_desc3OUB.supplierOUB.cartonOUB.locationOUB.pick_idOUB.qty_packOUB.qty_pickOUB.mpqstatusOUB.rmksOUB.createdonOUB.createdbyOUB.partsnOUB.inbound_idOUB.ctn_gwOUB.dime_lOUB.dime_wOUB.dime_h from kg_outbounditem as OUB where OUB.ref_no=‘“
					+ keyword
					+ “‘ GROUP BY  OUB.price_origOUB.currOUB.ctn_nwOUB.ctn_gwOUB.rmksOUB.partsnOUB.pallet_noOUB.ref_noOUB.outbound_idOUB.partno_cnOUB.partno_kagaOUB.part_d

 属性            大小     日期    时间   名称
----------- ---------  ---------- -----  ----

     文件        511  2013-01-02 09:01  kgwms\.classpath

     文件       1002  2014-02-25 14:49  kgwms\.project

     文件        443  2012-09-13 15:05  kgwms\.settings\.jsdtscope

     文件        167  2012-12-22 09:57  kgwms\.settings\org.eclipse.core.resources.prefs

     文件        587  2013-01-02 09:01  kgwms\.settings\org.eclipse.jdt.core.prefs

     文件      10039  2012-09-17 16:13  kgwms\.settings\org.eclipse.jdt.ui.prefs

     文件        436  2014-02-25 14:49  kgwms\.settings\org.eclipse.wst.common.component

     文件        222  2012-09-13 15:05  kgwms\.settings\org.eclipse.wst.common.project.facet.core.xml

     文件         49  2012-09-13 15:05  kgwms\.settings\org.eclipse.wst.jsdt.ui.superType.container

     文件          6  2012-09-13 15:05  kgwms\.settings\org.eclipse.wst.jsdt.ui.superType.name

     文件          2  2014-02-25 14:50  kgwms\.svn\entries

     文件          2  2014-02-25 14:50  kgwms\.svn\format

     文件        288  2014-02-25 14:50  kgwms\.svn\pristine\01\01cc6b78e58da0020f537a711ac2dfd99bac8034.svn-base

     文件      28209  2014-02-25 14:50  kgwms\.svn\pristine\02\02484bf8557518a48bbb6412fc6bbc554aa3eb79.svn-base

     文件     367444  2014-02-25 14:50  kgwms\.svn\pristine\03\03b254c872b95141751f414e353a25c2ac261b51.svn-base

     文件      22759  2014-02-25 14:50  kgwms\.svn\pristine\05\055ddeef6668e93d5874144b7a1dfbafa94a0149.svn-base

     文件       1070  2014-02-25 14:50  kgwms\.svn\pristine\0b\0b4bd4d35a3166c5f1bfb137932f555cf9b0850c.svn-base

     文件       2770  2014-02-25 14:50  kgwms\.svn\pristine\0c\0c18a0785dfdd59558ffc00e986426a586adbd29.svn-base

     文件     168081  2014-02-25 14:50  kgwms\.svn\pristine\0c\0c3f31f4a65461c44e6697bf29070e638bef09d8.svn-base

     文件       2082  2014-02-25 14:50  kgwms\.svn\pristine\0d\0d39b328f2892c81fd0b97be709aa9b4a48fa43b.svn-base

     文件     725247  2014-02-25 14:50  kgwms\.svn\pristine\12\127948c04822fd5192828a9f4669472f410c3270.svn-base

     文件      10039  2014-02-25 14:50  kgwms\.svn\pristine\14\145776bc8dbc717bb0f874220869802f8a2a6ed6.svn-base

     文件       3446  2014-02-25 14:50  kgwms\.svn\pristine\15\1561c50b1b4808d29e62e03969454cbc0b2b4159.svn-base

     文件       2197  2014-02-25 14:50  kgwms\.svn\pristine\17\1719b2e966cf3e70c443d0518e34defacd48d7c1.svn-base

     文件       1868  2014-02-25 14:50  kgwms\.svn\pristine\1a\1a5834b7d78f2aff11abe174ab8e6581b41f7cf3.svn-base

     文件        167  2014-02-25 14:50  kgwms\.svn\pristine\1b\1b6346021d32412920ad1769c20964a0821a5a43.svn-base

     文件       6028  2014-02-25 14:50  kgwms\.svn\pristine\1c\1c575525c8f8fe8375e2d2fc8d9db3928101739d.svn-base

     文件       8645  2014-02-25 14:50  kgwms\.svn\pristine\20\2000c373052000fde8ee86d3c59d8e3523527a96.svn-base

     文件       8535  2014-02-25 14:50  kgwms\.svn\pristine\20\20b7958d4216fe24f631c3180c8e9eba2a32f99c.svn-base

     文件       3137  2014-02-25 14:50  kgwms\.svn\pristine\20\20bc83229d00fb84039fc128955f917fa1f68c12.svn-base

............此处省略533个文件信息