62,614
社区成员
发帖
与我相关
我的任务
分享
public void updatemnum(BigDecimal consignment_product_num , Integer salesorder_product_id) throws SQLException
{
System.out.println(consignment_product_num);
String sql = "Update DPC_SalesOrder_Product set SALESORDER_PRODUCT_MNUM=(select SALESORDER_PRODUCT_MNUM - ? from DPC_SalesOrder_Product where SALESORDER_PRODUCT_ID=? ) where SALESORDER_PRODUCT_ID=?";
// 设置参数值
ps = conn.prepareStatement(sql);
ps.setBigDecimal(1, consignment_product_num);
ps.setInt(2, salesorder_product_id);
ps.setInt(3, salesorder_product_id);
// 执行
ps.executeUpdate();
System.out.println(sql);
}
import java.math.BigDecimal;
/**
* 销售订单产品数据库实体类
*
*/
public class SalesOrderProductModel
{
private Integer salesorder_product_id;
private BigDecimal salesorder_product_mnum;
public Integer getSalesorder_product_id()
{
return salesorder_product_id;
}
public void setSalesorder_product_id(Integer salesorder_product_id)
{
this.salesorder_product_id = salesorder_product_id;
}
public BigDecimal getSalesorder_product_mnum()
{
return salesorder_product_mnum;
}
public void setSalesorder_product_mnum(BigDecimal salesorder_product_mnum)
{
this.salesorder_product_mnum = salesorder_product_mnum;
}
}
public void updatemnum(BigDecimal consignment_product_num , Integer salesorder_product_id) throws SQLException
{
String sql = " update DPC_SalesOrder_Product set SALESORDER_PRODUCT_MNUM = SALESORDER_PRODUCT_MNUM - ? where SALESORDER_PRODUCT_ID = ?";
ps = conn.prepareStatement(sql);
ps.setBigDecimal(1, consignment_product_num);
ps.setInt(2, salesorder_product_id);
ps.executeUpdate();
}
spdao.updatemnum(new BigDecimal(request.getParameter("consignment_product_num" + tokens[z]).toString()), Integer.parseInt(request.getParameter("salesorder_product_id" + tokens[z])));
update DPC_SalesOrder_Product t set t.SALESORDER_PRODUCT_MNUM = t.SALESORDER_PRODUCT_MNUM - ? where SALESORDER_PRODUCT_ID = ?
Update DPC_SalesOrder_Product set SALESORDER_PRODUCT_MNUM=(select SALESORDER_PRODUCT_MNUM - 1 from DPC_SalesOrder_Product where SALESORDER_PRODUCT_ID=46 ) where SALESORDER_PRODUCT_ID=46