Java code/p>
入库操作String name ="";
if(!session.isNew())
{
// response.setContentType( "text/html; charset=gb2312");
name=(String)session.getAttribute("username");
if(name==null)
name="";
}
String aa=request.getParameter("StockInNumber");
int Si_Number = Integer.parseInt(aa);
String date=new SimpleDateFormat("yyyy.MM.dd").format(Calendar.getInstance().getTime());
String SIName=SI.getSIName();
String SIPrice=SI.getSIPrice();
int Si_Price = Integer.parseInt(SIPrice);
int Si_Money = Si_Number*Si_Price;
String SIMoney = Integer.toString(Si_Money);
String SISupName=SI.getSISupName();
String SIstorehouse=SI.getSIstorehouse();
String sql="insert into StockIn(SiId,SiName,SiNumber,SiPrice,SiSupName,Sistorehouse,SiUser,SiTime,SiMoney) VALUES(NULL,'"+SIName+"','"+Si_Number+"','"+SIPrice+"','"+SISupName+"','"+SIstorehouse+"','"+name+"','"+date+"','"+SIMoney+"') ";
ConnDBSQLite.executeUpdate(sql);
%>
商品入库表
商品名 | 进货数量 | 进货价格 | 供应商 | 仓库 | 操作员 | 时间 | 进货金额 |
---|---|---|---|---|---|---|---|
¥ | ¥ |
String siname=new String(SIName.getBytes("ISO-8859-1"),"gb2312");
String upstno = "UPDATE stock SET StockNumber=5 where StockName=' "+siname+" ' ";
delect.executeUpdate(upstno);
%>