shopnuminfodao.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.ShopNuminfo;

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

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

	public int merge(ShopNuminfo sni) {
		String sql="update shopnuminfo set sid="+sni.getSid()
		+",shopnumber="+sni.getShopnumber();
		return dm.updb(sql);
	}

	/*
	 * kid int not null, sid int null, shopnumber int null,
	 */
	public int save(ShopNuminfo sni) {
		String sql = "insert into shopnuminfo values(" 
				+ sni.getSid() + "," + sni.getShopnumber() + ")";
		return dm.updb(sql);
	}
	
	private List<ShopNuminfo> query(String sql)//查询
	{
		List<ShopNuminfo> list = new ArrayList<ShopNuminfo>();
		ResultSet rs = dm.getRs(sql);
		try {
			while(rs.next())
			{
				ShopNuminfo sni = new ShopNuminfo();
				sni.setKid(rs.getInt("kid"));
				sni.setSid(rs.getInt("sid"));
				sni.setShopnumber(rs.getInt("shopnumber"));
				list.add(sni);
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return list;
	}
	
	public List<ShopNuminfo> queryALL()//返回所有库存表信息
	{
		String sql="select * from shopnuminfo";
		return query(sql);
	}
	
	public List<ShopNuminfo> querybykid(ShopNuminfo sni)//根据库存编号查库存信息
	{
		String sql="select * from shopnuminfo where kid="+sni.getKid();
		return query(sql);
	}
	
	public List<ShopNuminfo> querybysid(Integer shopid)//根据商品编号查库存信息
	{
		String sql="select * from shopnuminfo where sid="+shopid;
		return query(sql);
	} 
	
	public List<ShopNuminfo> querybyshopnumber(ShopNuminfo sni)//查询库存量小于某个数的商品的信息
	{
		String sql="select * from shopnuminfo where shopnumber<"+sni.getShopnumber();
		return query(sql);
	} 

}