shoporderdao.java

一个仿造淘宝的jsp网站。功能比较完善

package com.jc.taobao.gjj.dao;

import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;

import com.jc.taobao.gjj.db.DBManager;
import com.jc.taobao.gjj.entity.ShopInfo;
import com.jc.taobao.gjj.entity.ShopOrder;

public class ShopOrderDAO {
	DBManager dm = new DBManager();

	public int delete(Integer id) {
		// TODO Auto-generated method stub
		return 0;
	}

	public int merge(ShopOrder so) {
		String sql="update shoporder set sid="+so.getSid()
		+",oid="+so.getOid()+",shopnumber="+so.getShopnumber()+" where sid="+so.getSid();
		return dm.updb(sql);
	}

	public int save(ShopOrder so) {
		String sql = "insert into shoporder values(" + so.getSid() + ","
				+ so.getOid() + "," + so.getShopnumber() + "')";
		return dm.updb(sql);
	}
	
	private List<ShopOrder> query(String sql)//查询
	{
		List<ShopOrder> list = new ArrayList<ShopOrder>();
		ResultSet rs = dm.getRs(sql);
		try {
			while(rs.next())
			{
				ShopOrder so = new ShopOrder();
				so.setSid(rs.getInt("sid"));
				so.setOid(rs.getInt("oid"));
				so.setShopnumber(rs.getInt("shopnumber"));
				list.add(so);
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return list;
	}
	
	public List<ShopOrder> queryALL()//查询所有订单对照表信息
	{
		String sql="select * from shoporder";
		return query(sql);
	}
	
	public List<ShopOrder> querybysid(ShopOrder so)//根据商品编号查
	{
		String sql="select * from shoporder where sid="+so.getSid();
		return query(sql);
	}
	
	public List<ShopOrder> querybyoid(ShopOrder so)//根据订单编号查
	{
		String sql="select * from shoporder where oid="+so.getOid();
		return query(sql);
	}
	
	public List<ShopOrder> querybyshopnumber(ShopOrder so)//根据订购数量查
	{
		String sql="select * from shoporder where shopnumber>"+so.getShopnumber();
		return query(sql);
	}

}