goodsorderdao.java~18~

销售管理系统 随着我国国民经济的持续发展

package com.dao;

import com.tool.JDBConnection;
import java.util.*;
import com.domain.GoodsOrderVO;
import java.sql.*;

public class GoodsOrderDao {
  private JDBConnection connection = null;
  public GoodsOrderDao() {
    connection = new JDBConnection();
    this.connection.creatConnection(); //利用构造方法调用类中的对象对数据库创建连接
  }

//全部查询
  public List goodsOrderSelect(Integer title) {
    List list = new ArrayList();
    GoodsOrderVO vo = null;
    String sql = "";
    if (title == null) {
      sql = "select * from tb_goodsOrder";
    }
    else {
      sql = "select * from tb_goodsOrder where title='" + title + "'";
    }
    ResultSet rs = connection.executeQuery(sql);
    try {
      while (rs.next()) {
        vo = new GoodsOrderVO();
        vo.setId(Integer.valueOf(rs.getString(1)));
        vo.setGoods_number(rs.getString(2));
        vo.setGoods_goodsNumber(rs.getString(3));
        vo.setGoods_account(Integer.parseInt(rs.getString(4)));
        vo.setGoods_money(Float.parseFloat(rs.getString(5)));
        vo.setGoods_company(rs.getString(6));
        vo.setNumber(rs.getString(7));
        vo.setTitle(Integer.parseInt(rs.getString(8)));
        vo.setEmployeeIn(rs.getString(9));
        vo.setEmployeeOut(rs.getString(10));
        vo.setMethod(rs.getString(11));
        vo.setOrdertime(rs.getString(12));
        vo.setOutime(rs.getString(13));
        list.add(vo);
      }
    }
    catch (SQLException ex) {
    }
    connection.closeConnection();
    return list;
  }

  public GoodsOrderVO goodsOrderSelect(String number) {
    GoodsOrderVO vo = null;
    String sql = "select * from tb_goodsOrder where goods_number='" + number +
        "'";
    ResultSet rs = connection.executeQuery(sql);
    try {
      while (rs.next()) {
        vo = new GoodsOrderVO();
        vo.setId(Integer.valueOf(rs.getString(1)));
        vo.setGoods_goodsNumber(rs.getString(2));
        vo.setGoods_goodsNumber(rs.getString(3));
        vo.setGoods_account(Integer.parseInt(rs.getString(4)));
        vo.setGoods_money(Float.parseFloat(rs.getString(5)));
        vo.setGoods_company(rs.getString(6));
        vo.setNumber(rs.getString(7));
        vo.setTitle(Integer.parseInt(rs.getString(8)));
        vo.setEmployeeIn(rs.getString(9));
        vo.setEmployeeOut(rs.getString(10));
        vo.setMethod(rs.getString(11));
        vo.setOrdertime(rs.getString(12));
        vo.setOutime(rs.getString(13));
      }
    }
    catch (SQLException ex) {
    }
    connection.closeConnection();
    return vo;
  }

  //查看要出货的信息
  public GoodsOrderVO goodsOrderOut(String number,int title) {
    GoodsOrderVO vo = null;
    String sql = "select * from tb_goodsOrder where  number='" + number +
        "' and title='"+title+"'";
    ResultSet rs = connection.executeQuery(sql);
    try {
      while (rs.next()) {
        vo = new GoodsOrderVO();
        vo.setId(Integer.valueOf(rs.getString(1)));
        vo.setGoods_number(rs.getString(2));
        vo.setGoods_goodsNumber(rs.getString(3));
        vo.setGoods_account(Integer.parseInt(rs.getString(4)));
        vo.setGoods_money(Float.parseFloat(rs.getString(5)));
        vo.setGoods_company(rs.getString(6));
        vo.setNumber(rs.getString(7));
        vo.setTitle(Integer.parseInt(rs.getString(8)));
        vo.setEmployeeIn(rs.getString(9));
        vo.setEmployeeOut(rs.getString(10));
        vo.setMethod(rs.getString(11));
        vo.setOrdertime(rs.getString(12));
        vo.setOutime(rs.getString(13));
      }
    }
    catch (SQLException ex) {
    }
    connection.closeConnection();
    return vo;
  }

  //删除操作
  public void orderDelete(Integer id) {
    String sql = "delete from tb_goodsOrder where id='" + id + "'";
    connection.executeUpdate(sql);
    connection.closeConnection();
  }

//添加定单
  public void goodsOrderInsert(GoodsOrderVO vo) {
    String sql = "insert into tb_goodsOrder (goods_number,goods_goodsNumber,goods_account,goods_money,goods_company,number,title,employeeIn,ordertime) values ('" +
        vo.getGoods_number() + "','" + vo.getGoods_goodsNumber() + "','" +
        vo.getGoods_account() + "','" + vo.getGoods_money() +
        "','" + vo.getGoods_company() + "','" + vo.getNumber() + "','" +
        vo.getTitle() + "','" + vo.getEmployeeIn() + "',getDate())";
    connection.executeUpdate(sql);
    connection.closeConnection();
  }

  //修改编号
  public void orderUpdateNumber(Integer id, String number) {
    String unNumber = "order-" + String.valueOf(id);
    String sql = "update tb_goodsOrder set goods_number='" + unNumber +
        "'  where goods_number='" + number + "'";
    connection.executeUpdate(sql);
    connection.closeConnection();
  }

  //出货
  public void orderOut(GoodsOrderVO vo) {
    String sql = "update tb_goodsOrder set title='" + vo.getTitle() +
        "',employeeOut='" + vo.getEmployeeOut() + "',method='" + vo.getMethod() +
        "',outime=getDate() where id='" + vo.getId() + "'";
    connection.executeUpdate(sql);
    connection.closeConnection();
  }

  //退货
  public void orderCancel(int account,String number) {
    String sql = "update tb_goodsOrder set goods_account='"+account+"' where  goods_number='"+number+"'";
    connection.executeUpdate(sql);
    connection.closeConnection();
  }


  public int goodsOrderAccount(String number) {
    int accounts =0;
    String sql = "select * from tb_goodsOrder where goods_number='" + number +
        "'";
    ResultSet rs = connection.executeQuery(sql);
    try {
      while (rs.next()) {
       accounts=rs.getInt("");
      }
    }
    catch (SQLException ex) {
    }
    connection.closeConnection();
    return accounts;
  }



}