productservicebean.java~35~

一个很不错的电子商务后台管理系统 这是一个电子商务网站的后台管理系统 要运行此系统必须具备以下条件 1.首先要把SNSQL文本中的SQL脚本确保在SQL Server中执行 2.包Se

package xian.bin.serivce;

import java.util.*;
import app.Test;
import xian.bin.product.*;
import xian.bin.dto.*;
import xian.bin.dao.*;
public class ProductServiceBean implements ServiceProduct {
  private ProductDAO dao;
  public ProductServiceBean() {
    dao=new ProductDAO();
  }
  //添加商品信息
  public void addProduct(String pid,String pname, String brand, String spec, String unit,
                         float price, float assprice, String pictrue, String explain, String bigcatalog, String smaillcatalog) throws Exception {
    try{
      dao.addProduct(pid,pname,brand,spec,unit,price,assprice,pictrue,explain,bigcatalog,smaillcatalog);
    }
    catch(Exception e){
      e.printStackTrace();
    }
  }
  //获得所有商品信息
  public Collection getAllProduct() throws Exception {
    try{
      return dao.getAllProduct();
    }
    catch(Exception e){
      e.printStackTrace();
    }
    return null;
  }
  //删除商品信息
  public void delProduct(String pid) throws Exception {
    try{
      dao.delProduct(pid);
    }
    catch(Exception e){
      e.printStackTrace();
    }
  }
  //获得一个商品信息
  public ProductDTO getProduct(String pname) throws Exception {
    try{
      return dao.getProduct(pname);
    }
    catch(Exception e){
      e.printStackTrace();
    }
    return null;
  }
  //修改商品信息
  public void updateProduct(String pid, String pname, String brand, String spec, String unit, float price, float assprice, String pictrue, String explain, String bigcatalog, String smaillcatalog) throws Exception {
    try{
      dao.updateProduct(pid,pname,brand,spec,unit,price,assprice,pictrue,explain,bigcatalog,smaillcatalog);
    }
    catch(Exception e){
      e.printStackTrace();
    }
  }

  //显示所有大类
  public ArrayList getBigCatalog()throws Exception{
      try{
       return dao.getBigCatalog();
      }
      catch(Exception e){
        e.printStackTrace();
      }
      return null;
    }

    //显示所有小类
    public ArrayList getSmaillCatalog()throws Exception{
      ArrayList smaillcatalogs=new ArrayList();
      Connection con=pcon.getConnection();
      PreparedStatement pstmt=null;
      try{
        pstmt=con.prepareStatement("select * from smallcatalog");
        ResultSet rs=pstmt.executeQuery();
        while(rs.next()){
          SmallcatalogDTO dto=new SmallcatalogDTO();
          dto.setCatalog(rs.getString("catalog"));
          dto.setOrder(rs.getInt("order"));
          smaillcatalogs.add(dto);
        }
      }
      catch(Exception e){
        e.printStackTrace();
      }
      return smaillcatalogs;
    }

    //显示所有品牌
    public ArrayList getBrand()throws Exception{
      ArrayList brands=new ArrayList();
      Connection con=pcon.getConnection();
      PreparedStatement pstmt=null;
      try{
        pstmt=con.prepareStatement("select * from brand");
        ResultSet rs=pstmt.executeQuery();
        while(rs.next()){
          BrandDTO dto=new BrandDTO();
          dto.setSequecnse(rs.getInt("sequecnse"));
          dto.setBrandName(rs.getString("brandname"));
          dto.setIsCommend(rs.getString("iscommend"));
          dto.setArrange(rs.getInt("arrange"));
          brands.add(dto);
        }
      }
      catch(Exception e){
        e.printStackTrace();
      }
      return brands;
    }
}