package cn.xwkj.dao;

import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;
import cn.xwkj.entity.Msoxq;

public class MsoxqDao extends BaseDao{

	// 查询方法(返回结果用集合存储)
			public List<Msoxq> list(String sql, String msoid){
				List<Msoxq> list=new ArrayList<Msoxq>();
				ResultSet rs=executeQuery(sql, msoid);
				try {
					while(rs.next())
					{
						Msoxq m=new Msoxq();
						m.setpImg(rs.getString("pImg"));
						m.setpSn(rs.getString("pSn"));
						m.setpNum(rs.getInt("count"));
						m.setpPrice(rs.getDouble("subtotal"));
						list.add(m);
					}
					return list;
				} catch (SQLException e) {
					e.printStackTrace();
				}
				finally
				{
					closeAll();
				}
				return null;
			}
}