orderinfodao.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.OrderInfo;
import com.jc.taobao.gjj.entity.ShopOrder;

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

	public int delete(Integer id) {
		String sql = "delete from orderinfo where oid=" + id;
		return dm.updb(sql);
	}

	public int merge(OrderInfo oi) {
		String sql = "update orderinfo set userid=" + oi.getUserid() + ",osid="
				+ oi.getOsid() + ",ordertime='" + oi.getOrdertime() + "',getshopman='"
				+ oi.getGetshopman() + "',telephone='" + oi.getTelephone() + "',address='"
				+ oi.getAddress() +"',glideid='"+oi.getGlideid()+"' where oid=" + oi.getOid();
		return dm.updb(sql);
	}

	public int save(OrderInfo oi) {
		String sql = "insert into orderinfo values("
				+ oi.getUserid() + "," + oi.getOsid() + ",'"
				+ oi.getOrdertime() + "','" + oi.getGetshopman() + "','"
				+ oi.getTelephone() + "','" + oi.getAddress() + "','"+oi.getGlideid()+"')";
		return dm.updb(sql);
	}
	public int updatestate(Integer oid,Integer stateid)
	{
		String sql="update orderinfo set osid="+stateid+" where oid="+oid;
		return dm.updb(sql);
	}
	
	
	private List<OrderInfo> query(String sql)//查询
	{
		List<OrderInfo> list = new ArrayList<OrderInfo>();
		DBManager db = new DBManager();
		ResultSet rs = db.getRs(sql);
		try {
			while(rs.next())
			{
				OrderInfo order = new OrderInfo();
				order.setOid(rs.getInt("oid"));
				order.setUserid(rs.getInt("userid"));
				order.setOsid(rs.getInt("osid"));
				order.setOrdertime(rs.getString("ordertime"));
				order.setGetshopman(rs.getString("getshopman"));
				order.setTelephone(rs.getString("telephone"));
				order.setAddress(rs.getString("address"));
				order.setGlideid(rs.getString("glideid"));
				list.add(order);
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return list;
	}
	
	public List<OrderInfo> queryALL()//查询所有订单信息
	{
		String sql="select * from orderinfo";
		return query(sql);
	}
	
	public List<OrderInfo> queryOrderInfoByCurrentPage(Integer page)
	  {
		  String sql="select top 6 * from orderinfo where oid not in " +
		  		"(select top "+(page-1)*6+" oid from orderinfo)";
		  return query(sql);
	  }
	
	public List<OrderInfo> querybyOid(OrderInfo order)//根据订单编号查
	{
		String sql="select * from orderinfo where oid="+order.getOid();
		return query(sql);
	}
	
	public List<OrderInfo> querybyUserid(OrderInfo order)//根据用户编号查
	{
		String sql="select * from orderinfo where userid="+order.getUserid();
		return query(sql);
	}
	public List<OrderInfo> querybyOsid(OrderInfo order)//根据订货状态查
	{
		String sql="select * from orderinfo where osid="+order.getOsid();
		return query(sql);
	}
	public List<OrderInfo> querybyOrdertime(OrderInfo order)//根据订货时间查
	{
		String sql="select * from orderinfo where ordertime='"+order.getOrdertime()+"'";
		return query(sql);
	}
	public List<OrderInfo> querybygetshopman(OrderInfo order)//根据订货人查
	{
		String sql="select * from orderinfo where getshopman='"+order.getGetshopman()+"'";
		return query(sql);
	}
	public List<OrderInfo> querybyglideid(String glideid)
	{
		String sql="select * from orderinfo where glideid='"+glideid+"'";
		return query(sql);
	}
	public List<OrderInfo> querybyaddress(OrderInfo order)//根据订货地址查
	{
		String sql="select * from orderinfo where address='"+order.getAddress()+"'";
		return query(sql);
	}

}