sql.properties

基于mvc的java进销存系统

# Sample ResourceBundle properties file
selectuser=select * from Users where UserName=? and PasswordCode=?
selectalluser=select * from Users
insertusers=insert into Users values (?,?,?,?,?)
updateusers=update Users set UserName=?,PasswordCode=?,DepartmentID=? where UserID=?
seluser=select * from Users where IsUse=?
deleteusers=delete from Users where UserID=?
reworkpassword=update Users set PasswordCode=? where UserName=?

selectcustomer=select * from Customer
insertcustomer=insert into Customer values (?,?,?,?,?,?,?)
updatecustomer=update Customer set CustomerName=?,Ower=?,MobilePhone=?,CustomerAddress=? where CustomerID=?
deletecustomer=delete from Customer where CustomerID=?
selcustomer=select * from Customer where CustomerID=?

selectsupplier=select * from Supplier
insertsupplier=insert into Supplier values (?,?,?,?,?,?,?,?)
deletesupplier=delete from Supplier where SupplierID=? or SupplierName=?
updatesupplier=update Supplier set SupplierName=?,OwerPost=?,Ower=?,Phone=?,MobilePhone=?,SupplierAddress=? where SupplierID=?
selsupplier=select * from Supplier where SupplierID=?
selecsupplier=select * from Supplier where SupplierID=?

selectproduct=select * from Product
selproduct=select * from Product where ProductID=?
insertproduct=insert into Product values (?,?,?,?,?,?,?,?)
updateQuantityproduct=update Product set Quantity=Quantity - ? where ProductID=?
updateproduct=update Product set ProductName=?,SafeStock=?,Quantity=?,SuggestBuyPrice=?,SuggestSalePrice=?,LastPurchaseDate=?,LastDeliveryDate=? where ProductID=?
addupdateproduct=update Product set Quantity=Quantity+? where ProductID=?
deleteproduct=delete from Product where ProductID=?
#xueronghan  
selectdeliveryDetail=select * from DeliveryDetail
seldeliveryDetail=select * from DeliveryDetail where DeliveryID=?
insertdeliveryDetail=insert into DeliveryDetail values (?,?,?,?,?)
updatedeliveryDetail=update  DeliveryDetail set ProductID=?,Quantity=?,Price=?,Amount=?
deletedeliveryDetail=delete from DeliveryDetail where DeliveryID=?

selectdeliveryMaster=select * from DeliveryMaster
seldeliveryMaster=select * from DeliveryMaster where DeliveryID=?
insertdeliveryMaster=insert into DeliveryMaster values (?,?,?,?,?)
updatedeliveryMaster=update  DeliveryMaster set DeliveryID=?,DeliveryProperty=?,DeliveryDate=?CustomerID=?,DeliveryAddress=?
deletedeliveryMaster=delete from DeliveryMaster where DeliveryID=?

selectpurchaseDetail=select * from PurchaseDetail
selpurchaseDetail=select * from PurchaseDetail where PurchaseID=?
insertpurchaseDetail=insert into PurchaseDetail (PurchaseID,ProductID,Quantity,Price)values (?,?,?,?)
updatepurchaseDetail=update  PurchaseDetail set PurchaseID=?,ProductID=?,Quantity=?,Price=?,Amount=?
deletepurchaseDetail=delete from PurchaseDetail where PurchaseID=? and ProductID=?

selectpurchaseMaster=select * from PurchaseMaster where PurchaseProperty=1
selpurchaseMaster=select * from PurchaseMaster where PurchaseID=?
findoutpurchaseMaster=select * from PurchaseMaster where PurchaseProperty=-1
insertpurchaseMaster=insert into PurchaseMaster ( PurchaseID,PurchaseProperty, PurchaseDate ,SupplierID )values (?,?,?,?)
updatepurchaseMaster=update  PurchaseMaster set PurchaseID=?,PurchaseProperty=?,PurchaseDate=?SupplierID=?
deletepurchaseMaster=delete from PurchaseMaster where PurchaseID=?