旧物交易系统

package dao.impl; import java.util.List; import javax.swing.JOptionPane; import org.hibernate.criterion.DetachedCriteria; import org.hibernate.criterion.Restrictions; import org.hibernate.type.StandardBasicTypes; import org.springframework.orm.hibernate3.HibernateTemplate; import com.Encip; import pojo.Good; import pojo.Order; import dao.OrderDAO; public class OrderDAOImpl extends HibernateTemplate implements OrderDAO{ List<Order> orders; //根据ID获取订单 public Order get(int oid) { return (Order)get(Order.class,oid); } //对管理员列出订单 public List<Order> gllist(Order o) { DetachedCriteria dc = DetachedCriteria.forClass(Order.class); if(o!=null){ if(o.getOid()!=0){ dc.add(Restrictions.sqlRestriction("CAST({alias}.oid AS CHAR) like ?","%" + o.getOid()+"%", StandardBasicTypes.STRING)); //System.out.println(u.getUid()); } if(o.getGid()!=0){ dc.add(Restrictions.sqlRestriction("CAST({alias}.gid AS CHAR) like ?","%" + o.getGid()+"%", StandardBasicTypes.STRING)); } if(o.getUid()!=0){ dc.add(Restrictions.sqlRestriction("CAST({alias}.uid AS CHAR) like ?","%" + o.getUid()+"%", StandardBasicTypes.STRING)); } if(o.getLx()!=null&&!o.getLx().equals("")){ dc.add(Restrictions.eq("lx", o.getLx())); } if(o.getFs()!=null&&!o.getFs().equals("")){ dc.add(Restrictions.eq("fs", o.getFs())); } List<Order> cs=findByCriteria(dc); for (Order y : cs){ System.out.println(y.getGid()); } return cs; } return find("from Order o order by o.oid desc"); } //卖家按商品号列出订单 public List<Order> slist(Order o){ DetachedCriteria dc = DetachedCriteria.forClass(Order.class); if(o!=null){ dc.add(Restrictions.eq("gid", o.getGid())); if(o.getOid()!=0){ dc.add(Restrictions.sqlRestriction("CAST({alias}.oid AS CHAR) like ?","%" + o.getOid()+"%", StandardBasicTypes.STRING)); //System.out.println(u.getUid()); } if(o.getUid()!=0){ dc.add(Restrictions.sqlRestriction("CAST({alias}.uid AS CHAR) like ?","%" + o.getUid()+"%", StandardBasicTypes.STRING)); //System.out.println(u.getUid()); } if(o.getLx()!=null&&!o.getLx().equals("")){ dc.add(Restrictions.eq("lx", o.getLx())); } if(o.getFs()!=null&&!o.getFs().equals("")){ dc.add(Restrictions.eq("fs", o.getFs())); } List<Order> cs=findByCriteria(dc); for (Order y : cs){ System.out.println(y.getGid()); } return cs; } return find("from Order o order by o.oid desc"); } //买家按用户号列出订单 public List<Order> list(Order o){ DetachedCriteria dc = DetachedCriteria.forClass(Order.class); if(o!=null){ dc.add(Restrictions.eq("uid", o.getUid())); if(o.getOid()!=0){ dc.add(Restrictions.sqlRestriction("CAST({alias}.oid AS CHAR) like ?","%" + o.getOid()+"%", StandardBasicTypes.STRING)); //System.out.println(u.getUid()); } if(o.getGid()!=0){ dc.add(Restrictions.sqlRestriction("CAST({alias}.gid AS CHAR) like ?","%" + o.getGid()+"%", StandardBasicTypes.STRING)); } if(o.getLx()!=null&&!o.getLx().equals("")){ dc.add(Restrictions.eq("lx", o.getLx())); } if(o.getFs()!=null&&!o.getFs().equals("")){ dc.add(Restrictions.eq("fs", o.getFs())); } List<Order> cs=findByCriteria(dc); for (Order y : cs){ System.out.println(y.getGid()); } return cs; } return find("from Order o order by o.oid desc"); } //删除订单 public void delete(Order o){ super.delete(o); JOptionPane.showMessageDialog(null, "已删除！"); } //修改订单信息 public void bupdate(Order o){ String hql="from Order o where o.gid=? and o.lx=?"; String a="已确认"; orders=find(hql,o.getGid(),a); if(orders!=null&&orders.size()>0){ JOptionPane.showMessageDialog(null, "订单已确认，不可修改！"); } else{ super.update(o); JOptionPane.showMessageDialog(null, "成功修改订单！"); } } //修改订单信息 public void supdate(Order o){ String hql="from Order o where o.gid=? and o.lx=?"; String a="已确认"; orders=find(hql,o.getGid(),a); if(orders!=null&&orders.size()>0){ if(o.getLx().equals(a)){ JOptionPane.showMessageDialog(null, "该物品已售出！"); } else if(o.getLx().equals("已取消")){ super.update(o); JOptionPane.showMessageDialog(null, "成功取消订单！"); } else if(o.getLx().equals("已提交")){ super.update(o); JOptionPane.showMessageDialog(null, "请尽快取消订单！"); } } else{ if(o.getLx().equals(a)){ super.update(o); JOptionPane.showMessageDialog(null, "成功确认订单！"); } else if(o.getLx().equals("已取消")){ super.update(o); JOptionPane.showMessageDialog(null, "成功取消订单！"); } else if(o.getLx().equals("已提交")){ JOptionPane.showMessageDialog(null, "请尽快取消订单！"); } } } //买家增添订单 public Order add(Order o){ String hql="from Order o where o.gid=? and o.uid=?"; orders=find(hql,o.getGid(),o.getUid()); if(orders!=null&&orders.size()>0){ JOptionPane.showMessageDialog(null, "请勿重复提交订单！"); return orders.get(0); } else{ save(o); return null; } } //实例化对象 public List<Order> getOrders() { return orders; } public void setOrders(List<Order> orders) { this.orders = orders; } }