package com.dao.impl;

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

import com.dao.ProductDao;
import com.entity.Product;
import com.entity.User;
import com.util.DBUtils;

public class ProductDaoImpl implements ProductDao{

	@Override
	public List<Product> getProductList() {
		// TODO Auto-generated method stub
		Connection con = null;
        PreparedStatement ps = null;
        ResultSet rs = null;
        List<Product> productList = new ArrayList<>();
        try {
            con = DBUtils.getConnection();
            ps = con.prepareStatement("SELECT * FROM t_product");
            rs = ps.executeQuery();
            while (rs.next()) {
            	Product product = new Product();
            	product.setId(rs.getInt("id"));
            	product.setProduct(rs.getString("product"));
            	product.setPrice(rs.getInt("price"));
            	product.setNum(rs.getInt("num"));
            	productList.add(product);
            }
        } catch (ClassNotFoundException e) {
            e.printStackTrace();
        } catch (SQLException e) {
            e.printStackTrace();
        }
        return productList;
	}

	@Override
	public Product getById(int id) {
		// TODO Auto-generated method stub
		Connection con = null;
        PreparedStatement ps = null;
        ResultSet rs = null;
        try {
            con = DBUtils.getConnection();
            ps = con.prepareStatement("SELECT * FROM t_product where id=?");
            ps.setInt(1, id);
            rs = ps.executeQuery();
            if (rs.next()) {
            	Product product = new Product();
            	product.setId(rs.getInt("id"));
            	product.setProduct(rs.getString("product"));
            	product.setPrice(rs.getInt("price"));
            	product.setNum(rs.getInt("num"));
            	return product;
            }
        } catch (ClassNotFoundException e) {
            e.printStackTrace();
        } catch (SQLException e) {
            e.printStackTrace();
        }
        return null;
	}

}