1.CustomerService
//顾客表操作
package Service;
import java.util.List;
import DAO.CustomerDAO;
import Factory.DAOFactory;
import StoreManager.Customer;
public class CustomerService {
CustomerDAO cusDao = DAOFactory.getCustomerDAO();
public int insert(Customer cus) throws Exception {
return cusDao.insert(cus);
}
public void delete(String cusid) throws Exception{
cusDao.delete(cusid);
}
public String[][] queryById(String cusid) throws Exception{
return cusDao.queryById(cusid);
}
public List<String> queryAll() throws Exception{
return cusDao.queryAll();
}
public void update(Customer cus) throws Exception{
cusDao.update(cus);
}
public int update1(Customer cus) throws Exception{
return cusDao.update1(cus);
}
public int shopping(double balance,String id) throws Exception{
return cusDao.shopping(balance, id);
}
public double getBalance(String id) throws Exception{
return cusDao.getBalance(id);
}
public void update2(Customer cus) throws Exception{
cusDao.update2(cus);
}
}
2.FlowerService
//鲜花表操作
package Service;
import java.util.List;
import DAO.FlowerDAO;
import Factory.DAOFactory;
import StoreManager.Flower;
public class FlowerService {
FlowerDAO floDao = DAOFactory.getFlowerDAO();
public void insert(Flower flo) throws Exception{
floDao.insert(flo);
}
public void delete(int flid) throws Exception{
floDao.delete(flid);
}
public String[][] queryById(int flid) throws Exception{
return floDao.queryById(flid);
}
public String[][] queryByName(String flname) throws Exception{
return floDao.queryByName(flname);
}
public double getPrice(String flname) throws Exception{
return floDao.getPrice(flname);
}
public List<String> queryAll() throws Exception{
return floDao.queryAll();
}
public List<String> queryComBox() throws Exception{
return floDao.queryComBox();
}
public void update(Flower flo) throws Exception{
floDao.update(flo);
}
public int getStore(String name) throws Exception{
return floDao.getStore(name);
}
public int shopping(int number,String name) throws Exception{
return floDao.shopping(number, name);
}
}
3.OrdersService
//订单表操作
package Service;
import java.util.List;
import DAO.OrdersDAO;
import Factory.DAOFactory;
import StoreManager.Orders;
public class OrdersService {
OrdersDAO orDao = DAOFactory.getOrdersDAO();
public void insert(String s1,String s2,String s3,double s4) throws Exception{
orDao.insert(s1, s2, s3, s4);
}
public String[][] queryById(String ordid) throws Exception{
return orDao.queryById(ordid);
}
public List<String> queryByC_Id(String cusid) throws Exception{
return orDao.queryByC_Id(cusid);
}
public List<String> queryAll() throws Exception{
return orDao.queryAll();
}
public void delete(int ordid) throws Exception{
orDao.delete(ordid);
}
public void update(Orders ord) throws Exception{
orDao.update(ord);
}
public void storemessageclear(){
orDao.storemessageclear();
}
}
4.UserService
//管理员表操作
package Service;
import java.util.List;
import DAO.UserDAO;
import Factory.DAOFactory;
import StoreManager.User;
public class UserService {
UserDAO userDAO = DAOFactory.getUserDAO();
public void insert(User user) throws Exception{
userDAO.insert(user);
}
public void delete(String userid) throws Exception{
userDAO.delete(userid);
}
public String[][] queryById(String userid) throws Exception{
return userDAO.queryById(userid);
}
public List<String> queryAll() throws Exception{
return userDAO.queryAll();
}
public void update(User user) throws Exception{
userDAO.update(user);
}
public void update1(User user) throws Exception{
userDAO.update1(user);
}
}