src/com/accp/myShopping/llg/car/dao/GoodsDao.java

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

package com.accp.myShopping.llg.car.dao;

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

import com.accp.myShopping.llg.car.entity.GoodsBean;
import com.accp.myShopping.util.DataBaseUtil;
public class GoodsDao {

	private DataBaseUtil db= new DataBaseUtil();
	
	//  搜索产品 返回商品ID
	public int findGoodsBeanByName(String str,String name){
		String sql="select * from goods where G_typeid in("+str+") and keywords like '%"+name+"%'";
			List<GoodsBean> list= this.getGoodsBeans(sql);
			if(list!=null&&list.size()>0){
				GoodsBean g =list.get(0);
				return Integer.parseInt(g.getG_id());
			}else{
				return 0;
			}
	}
	

	
	/**
	 *  根据商品类型返回商品列表
	 * */
	public List<GoodsBean> findGoodsByTypeId(String tid){
		String sql="select * from goods where g_typeid="+tid;
		return this.getGoodsBeans(sql);
	}
	
	
	//根据商品ID获得商品所购买 数量
	public int getGoodsBuyNum(String gid){
		String sql="select sum(O_count)as yy from orderdetail where o_gid="+gid;
		ResultSet rs=null;
		int number=0;
		try {
				rs=db.getResultSet(sql);
				rs.next();
				number=rs.getInt("yy");
				return number;
		} catch (SQLException e) {
			 System.out.println("getGoodsBuyNum执行SQL失败");
			 e.printStackTrace();
		}catch(NumberFormatException ex){
			 System.out.println("getGoodsBuyNum转换转换");
			 ex.printStackTrace();
		}finally{
			db.release(rs);
		}
		return 0;
	}