ordercrud.java

仓库管理系统

package edu.scau.order.persist;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.text.SimpleDateFormat;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;
import java.util.UUID;

import edu.scau.database.DBUtil;
import edu.scau.order.OrderBean;
import edu.scau.order.OrderItemBean;


public class OrderCRUD {

	/**
	 * @param args
	 */
	public static void main(String[] args) {
		// TODO Auto-generated method stub
		OrderCRUD o = new OrderCRUD();
		o.readOrder("001");

	}

	public boolean createOrder(OrderBean orderBean) {
		boolean result = false;
		OrderItemBean oi = null;
		DBUtil db = new DBUtil();
		Connection conn = db.getConn();
		Statement sm = null;
		String insertOrderSql = null;
		String insertOrderItemSql = null;

		Date bizDate = orderBean.getBizDate();
		SimpleDateFormat sdf = new SimpleDateFormat("yyyy-mm-dd");
		String bizDateStr = sdf.format(bizDate);

		try {
			UUID uuid = UUID.randomUUID();
			sm = conn.createStatement();
			orderBean.setUuid(uuid.toString());
			insertOrderSql = "insert into t_scm_order(uuid,number,customer,totalCost,bizDate) values('" + uuid.toString() + "','" + orderBean.getNumber() + "','" + orderBean.getCustomer() + "'," + orderBean.getTotalCost() + "," + bizDateStr + ")";
			System.out.println(insertOrderSql);
			sm.addBatch(insertOrderSql);
			List li = orderBean.getOrderItemBeans();

			for (int i = 0; i < li.size(); i++) {
				oi = (OrderItemBean) li.get(i);
				UUID itemUuid = UUID.randomUUID();
				insertOrderItemSql = "insert into t_scm_orderitem(uuid,name,qty,price,amt,orderUuid) values('" + itemUuid.toString() + "','" + oi.getName() + "'," + oi.getQty() + "," + oi.getPrice() + "," + oi.getAmt() + ",'" + orderBean.getUuid() + "')";
				System.out.println(insertOrderItemSql);
				// psm.setString(1, oi.getName());
				// psm.setInt(2, oi.getQty());
				// psm.setBigDecimal(3, oi.getPrice());
				// psm.setBigDecimal(4, oi.getAmt());
				sm.addBatch(insertOrderItemSql);
			}
			sm.executeBatch();
			result = true;
			sm.close();
		} catch (SQLException e) {
			result = false;
			// TODO Auto-generated catch block
			e.printStackTrace();
		} finally {
			db.closeConnection(conn);
		}

		return result;
	}

	public OrderBean readOrder(String number) {
		OrderBean orderBean = null;
		OrderItemBean oii = null;
		List li = new ArrayList();
		DBUtil db = new DBUtil();
		Connection conn = db.getConn();
		Statement sm = null;
		ResultSet rs = null;
		String findByNumberSql = "select t_scm_order.uuid uuid,number,customer,bizDate,totalCost,name,qty,price,amt from t_scm_order left join  t_scm_orderitem" + " on t_scm_order.uuid = t_scm_orderitem.orderuuid" + " where t_scm_order.number ='" + number + "' order by t_scm_order.uuid";
		System.out.println(findByNumberSql);
		try {
			sm = conn.createStatement();
			rs = sm.executeQuery(findByNumberSql);
			orderBean = new OrderBean();
			int i = 0;
			while (rs != null && rs.next()) {
				oii = new OrderItemBean();
				if (i == 0) {
					orderBean.setUuid(rs.getString("uuid"));
					orderBean.setCustomer(rs.getString("customer"));
					orderBean.setNumber(rs.getString("number"));
					orderBean.setTotalCost(rs.getBigDecimal("totalCost"));
				}
				oii.setName(rs.getString("name"));
				oii.setQty(rs.getInt("qty"));
				oii.setPrice(rs.getBigDecimal("price"));
				oii.setAmt(rs.getBigDecimal("amt"));
				li.add(oii);
			}
			orderBean.setOrderItemBeans(li);

		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		} finally {
			db.closeConnection(conn);
		}
		return orderBean;
	}

	public int updateOrder(OrderBean orderBean) {
		int i = 0;

		return i;
	}

	public int deleteOrder(OrderBean orderBean) {
		int i = 0;

		return i;
	}

}