salemanager.java

来自「这是本人刚刚得到的JBuilder9软件开发项目实践的源码」· Java 代码 · 共 63 行

package jxc;

/**
 * <p>Title: jxc demo</p>
 * <p>Description: </p>
 * <p>Copyright: Copyright (c) 2003</p>
 * <p>Company: </p>
 * @author cwx
 * @version 1.0
 */

import java.sql.*;

public class SaleManager {
  public SaleManager() {
  }

  static public boolean addSale(String wareID, float salePrice,
                               int saleQty, String saleDate){
    Connection conn = null;
    PreparedStatement stmt = null;

    try {
      conn = ConnectionManager.getConnection();
      stmt = conn.prepareStatement("insert into Sale (wareID,salePrice,saleQty,saleDate)"
                                   +" values(?,?,?,?)");

      stmt.setString(1, wareID);
      stmt.setFloat(2, salePrice);
      stmt.setInt(3, saleQty);
      stmt.setString(4, saleDate);
      stmt.executeUpdate();
      //更新库存
      stmt.close();
      stmt = conn.prepareStatement("update Reserve set resQty=resQty-" +
                                     saleQty+" where wareID="+wareID);
      stmt.executeUpdate();
        //通过
      return true;
    }
    catch (java.sql.SQLException e) {
      System.err.println(e);
    }
    finally {
      //关闭数据库资源
      if (stmt != null) {
        try {
          stmt.close();
        } catch (Exception exception) {}
      }
      if (conn != null) {
        try {
          conn.close();
        } catch (Exception exception) {}
      }
    }

    //失败
    return false;
  }


}