orderstatedao.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.OrderState;

public class OrderStateDAO{
     DBManager dm=new DBManager();
	public int delete(Integer id) {
		String sql="delete from orderstate where osid="+id;
		return dm.updb(sql);
	}

	public int merge(OrderState os) {
		String sql="update orderstate set ostatename='"+os.getOstatename()
		+"' where osid="+os.getOsid();
		return dm.updb(sql);
	}

	public int save(OrderState os) {
		String sql="insert into orderstate values('"
			+os.getOstatename()+"')";
		return dm.updb(sql);
	}
	
	private List<OrderState> query(String sql)//查询 
	{
		List<OrderState> list = new ArrayList<OrderState>();
		ResultSet rs = dm.getRs(sql);
		try {
			while(rs.next())
			{
				OrderState os = new OrderState();
				os.setOsid(rs.getInt("osid"));
				os.setOstatename(rs.getString("ostatename"));
				list.add(os);
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return list;
	}
	
	public List<OrderState> querybyALL()//查询所有订单状态信息
	{
		String sql="select * from orderstate";
		return query(sql);
	}
	
	public List<OrderState> querybyosid(Integer osid)//根据订单状态编号查询订单状态信息 
	{
		String sql="select * from orderstate where osid="+osid;
		return query(sql);
	}


}