package ejb;

import javax.ejb.SessionBean;
import javax.ejb.SessionContext;
import javax.ejb.CreateException;
import javax.naming.*;
import java.util.*;
import java.util.Date;
import java.util.GregorianCalendar;

public class ShouJiSessionBean implements SessionBean {
    SessionContext sessionContext;
    public void ejbCreate() throws CreateException {
    }

    public void ejbRemove() {
    }

    public void ejbActivate() {
    }

    public void ejbPassivate() {
    }


    public void setSessionContext(SessionContext sessionContext) {
        this.sessionContext = sessionContext;
    }

    public boolean  inster(String photo, String name, String model,
                          String daXiao, String yanSe, String zhongLiang,
                          String xiangXiJieShao, float price) {
        boolean bool=false;
        try{
            Context ct = new InitialContext();
            ShouJiInfoHome home=(ShouJiInfoHome)ct.lookup("ShouJiInfo");

            Date date;
            GregorianCalendar cal;
            String number;
            date=new Date();
            cal=new GregorianCalendar();
            cal.setTime(date);
            number="X_"+cal.get(cal.YEAR)+""+cal.get(cal.MONTH)+""+cal.get(cal.DATE)+""+cal.get(cal.HOUR+1)+""+cal.get(cal.MINUTE)+""+cal.get(cal.SECOND);

            ShouJiInfo rm = home.create(number);
            rm.setPhoto(photo);
            rm.setName(name);
            rm.setDaXiao(daXiao);
            rm.setModel(model);
            rm.setZhongLiang(zhongLiang);
            rm.setPrice(price);
            rm.setXiangXiJieShao(xiangXiJieShao);
            rm.setYanSe(yanSe);
            bool=true;
       }catch(Exception e){e.printStackTrace();}
        return bool;
    }

    public boolean  xiugai(String photo, String number, String name,
                          String model, String daXiao, String yanSe,
                          String zhongLiang, String xiangXiJieShao, float price) {
        boolean bool=false;
        try{
            Context ct = new InitialContext();
            ShouJiInfoHome home = (ShouJiInfoHome) ct.lookup("ShouJiInfo");
            ShouJiInfo rm = home.findByPrimaryKey(number);
            rm.setPhoto(photo);
            rm.setName(name);
            rm.setDaXiao(daXiao);
            rm.setModel(model);
            rm.setZhongLiang(zhongLiang);
            rm.setPrice(price);
            rm.setXiangXiJieShao(xiangXiJieShao);
            rm.setYanSe(yanSe);
            bool=true;

        }catch(java.lang.Exception e){e.printStackTrace();}
        return bool;
    }

    public boolean  delete(String number) {
        boolean bool=false;
       try{
           Context ct = new InitialContext();
           ShouJiInfoHome home = (ShouJiInfoHome) ct.lookup("ShouJiInfo");
           ShouJiInfo rm = home.findByPrimaryKey(number);
           rm.remove();
           bool=true;
       }catch(java.lang.Exception e){e.printStackTrace();}
        return bool;
    }

    public List selectAll() {
          ArrayList list=new ArrayList();
        try{
            Context ct = new InitialContext();
           ShouJiInfoHome home = (ShouJiInfoHome) ct.lookup("ShouJiInfo");
           Iterator it=home.findAll().iterator();
           while(it.hasNext()){
               ShouJiInfo shouJiInfo=(ShouJiInfo)it.next();
               ShouJiInfoVo vo = new ShouJiInfoVo();
               vo.setDaXiao(shouJiInfo.getDaXiao());
               vo.setModel(shouJiInfo.getModel());
               vo.setName(shouJiInfo.getName());
               vo.setNumber(shouJiInfo.getNumber());
               vo.setPhoto(shouJiInfo.getPhoto());
               vo.setPrice(shouJiInfo.getPrice());
               vo.setXiangXiJieShao(shouJiInfo.getXiangXiJieShao());
               vo.setYanSe(shouJiInfo.getYanSe());
               vo.setZhongLiang(shouJiInfo.getZhongLiang());
               list.add(vo);
           }

        }catch(java.lang.Exception e){e.printStackTrace();}
        return list;
    }

    public List  selectForName(String name) {
          ArrayList list=new ArrayList();
        try{
            Context ct = new InitialContext();
            ShouJiInfoHome home = (ShouJiInfoHome) ct.lookup("ShouJiInfo");
            Iterator it = home.findForName(name).iterator();
            while(it.hasNext()){
             ShouJiInfo shouJiInfo=(ShouJiInfo)it.next();
             ShouJiInfoVo vo = new ShouJiInfoVo();
             vo.setDaXiao(shouJiInfo.getDaXiao());
             vo.setModel(shouJiInfo.getModel());
             vo.setName(shouJiInfo.getName());
             vo.setNumber(shouJiInfo.getNumber());
             vo.setPhoto(shouJiInfo.getPhoto());
             vo.setPrice(shouJiInfo.getPrice());
             vo.setXiangXiJieShao(shouJiInfo.getXiangXiJieShao());
             vo.setYanSe(shouJiInfo.getYanSe());
             vo.setZhongLiang(shouJiInfo.getZhongLiang());
             list.add(vo);
            }
      }catch(java.lang.Exception e){e.printStackTrace();}
          return list;
    }

    public List  selectForPrice(float price) {
        ArrayList list = new ArrayList();
        try {
            Context ct = new InitialContext();
            ShouJiInfoHome home = (ShouJiInfoHome) ct.lookup("ShouJiInfo");
            Iterator it = home.findForPrice(price).iterator();
            while (it.hasNext()) {
                ShouJiInfo shouJiInfo = (ShouJiInfo) it.next();
                ShouJiInfoVo vo = new ShouJiInfoVo();
                vo.setDaXiao(shouJiInfo.getDaXiao());
                vo.setModel(shouJiInfo.getModel());
                vo.setName(shouJiInfo.getName());
                vo.setNumber(shouJiInfo.getNumber());
                vo.setPhoto(shouJiInfo.getPhoto());
                vo.setPrice(shouJiInfo.getPrice());
                vo.setXiangXiJieShao(shouJiInfo.getXiangXiJieShao());
                vo.setYanSe(shouJiInfo.getYanSe());
                vo.setZhongLiang(shouJiInfo.getZhongLiang());
                list.add(vo);
            }
        } catch (java.lang.Exception e) {
            e.printStackTrace();
        }
        return list;
    }

    public List  selectForNumber(String number) {
        ArrayList list=new ArrayList();
try{
  Context ct = new InitialContext();
  ShouJiInfoHome home = (ShouJiInfoHome) ct.lookup("ShouJiInfo");
  Iterator it = home.findForNumber(number).iterator();
  while(it.hasNext()){
   ShouJiInfo shouJiInfo=(ShouJiInfo)it.next();
   ShouJiInfoVo vo = new ShouJiInfoVo();
   vo.setDaXiao(shouJiInfo.getDaXiao());
   vo.setModel(shouJiInfo.getModel());
   vo.setName(shouJiInfo.getName());
   vo.setNumber(shouJiInfo.getNumber());
   vo.setPhoto(shouJiInfo.getPhoto());
   vo.setPrice(shouJiInfo.getPrice());
   vo.setXiangXiJieShao(shouJiInfo.getXiangXiJieShao());
   vo.setYanSe(shouJiInfo.getYanSe());
   vo.setZhongLiang(shouJiInfo.getZhongLiang());
   list.add(vo);
  }
}catch(java.lang.Exception e){e.printStackTrace();}
return list;

    }
}