package net.shopxx.daoImpl;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.Arrays;
import java.util.List;


import net.shopxx.dao.ProductManageDao;
import net.shopxx.entity.Product;
import util.DBPoolConnection;

//商品管理
public class ProductManageImpl implements ProductManageDao{
	Connection conn;
	PreparedStatement ps;
	ResultSet rs;
	@Override
	public List<Product> getAllProduct() {
		List<Product> list=new ArrayList<>();
		
		try {
			String sql="select * from xx_product ";
			conn=DBPoolConnection.getConnection();
			ps=conn.prepareStatement(sql);
			rs=ps.executeQuery();
			while(rs.next()){
				Product product=new Product();
				product.setId(rs.getLong("id"));
				product.setFullName(rs.getString("full_name"));
				product.setMarketPrice(rs.getBigDecimal("market_price"));
				product.setIsMarketable(rs.getBoolean("is_marketable"));
				product.setCreateDate(rs.getDate("create_date"));
				list.add(product);
			}
			
		} catch (SQLException e) {
			e.printStackTrace();
		}finally{
			DBPoolConnection.close(conn, ps, rs);
		}
		return list;
	}
public static void main(String[] args) {
	ProductManageImpl p=new ProductManageImpl();
	System.out.println(p.getAllProduct().get(0).getFullName());
}
}