selldetailsdao.java

java网上订餐系统java网上订餐系统java网上订餐系统

package com.dao;

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

import com.vo.SellDetails;

public class SellDetailsDao extends IBaseDaoAdapter {
	
	public List selectInfo() {
		ArrayList<SellDetails> list = new ArrayList<SellDetails>();
		String sql = "select * from sellDetails";
		try {
			pstmt = getConn().prepareStatement(sql);
			rs = pstmt.executeQuery();
			while(rs.next()){
				SellDetails sell = new SellDetails();
				sell.setSellID(rs.getInt(1));
				sell.setSellName(rs.getString(2));
				sell.setSellType(rs.getString(3));
				sell.setSellPrice(rs.getString(4));
				sell.setSellBrand(rs.getString(5));
				sell.setSellDescription(rs.getString(6));
				list.add(sell);
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}finally{
			closeAll();
		}
		// TODO 自动生成方法存根
		return list;
	}
}