cksql.java

很好的东东 本人随便做的 仅供学习之用

package cangku.javabeans;


public class CKSql {
	public static String ckloginsql="select name,password,warehouseID,warehouse from warehousekeeper where name=? and password=? ";//登陆
    public static String cksendlbsql="select * from send where warehouseID=? and warehouse=? and status=?" ;   //仓库出货单列表
    public static String ckordersql="select * from [order] where ID=? ";   //调出所有订单
    public static String ckwarehouse="select warehouse from warehouse";  //调出所有仓库
    public static String ckorderdetail="select * from orderdetail where orderID=?";  //某订单的药品明细表
    public static String ckhauler="select ID,name from hauler";   //调出所有承运商
    public static String ckypcc="select counts from storage where drugID=? and warehouseID=? ";   //某仓库某药品的数量
    public static String ckypkc="update storage set counts=? where drugID=? and warehouseID=?";   //修改库存信息
    public static String cksendupdate="update send set status=?,haulerID=?,hauler=?,sendtime=? where ID=?";  //修改发货单状态，选择承运商
    public static String ckcuyp="select * from storage where warehouseID=? ";   //调出某仓库所有药品的ID，名称和数量
    public static String ckpcb="update drugwaste set reason=?,comment=?,counts=? where drugID=?";   //仓库盘存损益表进行修改
    public static String ckpcbdrugid="select drugid,counts from drugwaste where drugID=?"; //查询已损耗的药品ID
    public static String ckpcadd="insert into drugwaste(drugID,reason,comment,counts) values(?,?,?,?)";  //新增一条损失药品信息
}