sql.java

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

package kefu.javabeans;

public class Sql {
	//发货单信息
	public static String sendStr=
		"select *from send where orderID in (select orderID from" +
		" [order] where customername=?)";
//	收货确认
	public static String confirmStr=
		"update send set status='是' where ID=?";
//	退
	public static String withDrawRequestStr=
		"insert into withdraw(orderID,withdrawtime,status,reason) values(?,?,?,?)";
	public static String withDetailRequestStr=
		"insert into withdrawdetail(withID,drugID,drugname,counts) values(?,?,?,?)";
	public static  String orderDetail=
		"Select *from orderdetail where orderID=?";
	public static String order=
		"select *from [order] where customername=?";
}