goodsinfo.java

基于j2ee的物流软件

package com.wuliu.entity;

import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

import com.wuliu.DBConnection.DBConnection;

/**
 * @author 刘海鹏
 * @version 商品信息表(共16个属性)
 */

public class GoodsInfo {
	private int id; // 该表ID号
	private String goodsId = null; // 商品编号
	private String goodsName = null; // 商品名称
	private String goodsTypeId = null; // 商品分类编号
	private String goodsConsignerId = null; // 发货人编号
	private String goodsConsigneeId = null; // 收货人编号
	private String goodsStart = null; // 始发地
	private String goodsAim = null; // 目的地
	private String goodsABC = null; // 商品ABC分类
	private String goodsCity = null; // 商品产地省市
	private String goodsStockId = null; // 所在仓库编号
	private String goodsStockRegionId = null; // 商品所在仓库位置编号
	private double goodsPrice = 0; // 商品单价
	private String goodsNumber = null; // 商品量
	private String goodsUnit = null; // 商品单位
	private String goodsState = null; // 商品状态(入库，运送中，完成)
	
	//空的构造方法
	public GoodsInfo() {
	}

	//不含商品信息表Id参构造方法
	public GoodsInfo(String goodsId, String goodsName,
			String goodsTypeId, String goodsConsignerId,
			String goodsConsigneeId, String goodsStart, String goodsAim,
			String goodsABC, String goodsCity, String goodsStockId,
			String goodsStockRegionId, double goodsPrice, String goodsNumber,
			String goodsUnit, String goodsState){
		this.goodsId = goodsId;
		this.goodsName = goodsName;
		this.goodsTypeId = goodsTypeId;
		this.goodsConsignerId = goodsConsignerId;
		this.goodsConsigneeId = goodsConsigneeId;
		this.goodsStart = goodsStart;
		this.goodsAim = goodsAim;
		this.goodsABC = goodsABC;
		this.goodsCity = goodsCity;
		this.goodsStockId = goodsStockId;
		this.goodsStockRegionId = goodsStockRegionId;
		this.goodsPrice = goodsPrice;
		this.goodsNumber = goodsNumber;
		this.goodsUnit = goodsUnit;
		this.goodsState = goodsState;
	}
	
	//不含商品信息表Id参构造方法
	public GoodsInfo(String goodsName,
			String goodsTypeId, String goodsConsignerId,
			String goodsConsigneeId, String goodsStart, String goodsAim,
			String goodsABC, String goodsCity, String goodsStockId,
			String goodsStockRegionId, double goodsPrice, String goodsNumber,
			String goodsUnit, String goodsState){
		this.goodsName = goodsName;
		this.goodsTypeId = goodsTypeId;
		this.goodsConsignerId = goodsConsignerId;
		this.goodsConsigneeId = goodsConsigneeId;
		this.goodsStart = goodsStart;
		this.goodsAim = goodsAim;
		this.goodsABC = goodsABC;
		this.goodsCity = goodsCity;
		this.goodsStockId = goodsStockId;
		this.goodsStockRegionId = goodsStockRegionId;
		this.goodsPrice = goodsPrice;
		this.goodsNumber = goodsNumber;
		this.goodsUnit = goodsUnit;
		this.goodsState = goodsState;
	}
	
	//含商品信息表Id参构造方法
	public GoodsInfo(int id, String goodsId, String goodsName,
			String goodsTypeId, String goodsConsignerId,
			String goodsConsigneeId, String goodsStart, String goodsAim,
			String goodsABC, String goodsCity, String goodsStockId,
			String goodsStockRegionId, double goodsPrice, String goodsNumber,
			String goodsUnit, String goodsState) {
		this(goodsId, goodsName, goodsTypeId, goodsConsignerId,
				goodsConsigneeId, goodsStart, goodsAim, goodsABC,
				goodsCity, goodsStockId, goodsStockRegionId, goodsPrice,
				goodsNumber, goodsUnit, goodsState);
		this.id = id;
	}
	
	/* 自动生成员工ID号 EP＋年份号＋流水号 */
	private String getTempId()
	{
		String temp = null;
		DBConnection db = new DBConnection();
		Connection cn = db.getConnection();
		try
		{
			Statement st = cn.createStatement();
			ResultSet rs = st.executeQuery("select max(GoodsInfoTableId)" +
					" from GoodsInfoTable");
			if (rs.next())
			{
				int no = rs.getInt(1) + 1;
				// 生成员工编号
				temp = "GOODS" + no;
			}
		} catch (SQLException e)
		{
			e.printStackTrace();
		} finally
		{
			db.closeConnection(cn);
		}
		return temp;
	}
	
	public static void main(String[] args){
		GoodsInfo goods = new GoodsInfo();
		System.out.print(goods.getTempId());
		
	}
	
	public int getId() {
		return id;
	}

	public void setId(int id) {
		this.id = id;
	}

	public String getGoodsId() {
		return goodsId;
	}

	public void setGoodsId(String goodsId) {
		this.goodsId = goodsId;
	}
	
	public String getGoodsName() {
		return goodsName;
	}

	public void setGoodsName(String goodsName) {
		this.goodsName = goodsName;
	}

	public String getGoodsTypeId() {
		return goodsTypeId;
	}

	public void setGoodsTypeId(String goodsTypeId) {
		this.goodsTypeId = goodsTypeId;
	}

	public String getGoodsConsignerId() {
		return goodsConsignerId;
	}

	public void setGoodsConsignerId(String goodsConsignerId) {
		this.goodsConsignerId = goodsConsignerId;
	}

	public String getGoodsConsigneeId() {
		return goodsConsigneeId;
	}

	public void setGoodsConsigneeId(String goodsConsigneeId) {
		this.goodsConsigneeId = goodsConsigneeId;
	}

	public String getGoodsStart() {
		return goodsStart;
	}

	public void setGoodsStart(String goodsStart) {
		this.goodsStart = goodsStart;
	}

	public String getGoodsAim() {
		return goodsAim;
	}

	public void setGoodsAim(String goodsAim) {
		this.goodsAim = goodsAim;
	}

	public String getGoodsABC() {
		return goodsABC;
	}

	public void setGoodsABC(String goodsABC) {
		this.goodsABC = goodsABC;
	}

	public String getGoodsCity() {
		return goodsCity;
	}

	public void setGoodsCity(String goodsCity) {
		this.goodsCity = goodsCity;
	}

	public String getGoodsStockId() {
		return goodsStockId;
	}

	public void setGoodsStockId(String goodsStockId) {
		this.goodsStockId = goodsStockId;
	}

	public String getGoodsStockRegionId() {
		return goodsStockRegionId;
	}

	public void setGoodsStockRegionId(String goodsStockRegionId) {
		this.goodsStockRegionId = goodsStockRegionId;
	}

	public double getGoodsPrice() {
		return goodsPrice;
	}

	public void setGoodsPrice(double goodsPrice) {
		this.goodsPrice = goodsPrice;
	}

	public String getGoodsNumber() {
		return goodsNumber;
	}

	public void setGoodsNumber(String goodsNumber) {
		this.goodsNumber = goodsNumber;
	}

	public String getGoodsUnit() {
		return goodsUnit;
	}

	public void setGoodsUnit(String goodsUnit) {
		this.goodsUnit = goodsUnit;
	}

	public String getGoodsState() {
		return goodsState;
	}

	public void setGoodsState(String goodsState) {
		this.goodsState = goodsState;
	}
	public static void main(){
		
	}
}