package com.imooc.dao.impl;

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

import com.imooc.dao.ProductDao;
import com.imooc.domain.Product;
import com.imooc.utils.JDBCUtils;
import com.mysql.cj.protocol.Resultset;

public class ProductDaoImpl implements ProductDao {

    @Override
    public List<Product> findAll() {
        System.out.println("1111111111");
        Connection conn = null;
        PreparedStatement pstmt = null;
        ResultSet rs = null;
        List<Product> list = null;
        try{
            // 获得连接
            conn = JDBCUtils.getConnection();
            // 编写sql
            String sql = "select * from product p,category c where p.cid = c.cid";
            // 预编译sql
            pstmt = conn.prepareStatement(sql);
            // 执行sql
            rs = pstmt.executeQuery();
            // 遍历结果集
            list = new ArrayList<Product>();
            while(rs.next()){
                Product product = new Product();
                product.setPid(rs.getInt("pid"));
                product.setPname(rs.getString("pname"));
                product.setAuthor(rs.getString("author"));
                product.setPrice(rs.getDouble("price"));
                product.setDescription(rs.getString("description"));
                product.setFilename(rs.getString("filename"));
                product.setPath(rs.getString("path"));
                // 封装商品的分类
                product.getCategory().setCid(rs.getInt("cid"));
                product.getCategory().setCname(rs.getString("cname"));
                product.getCategory().setCdesc(rs.getString("cdesc"));
                
                list.add(product);
            }
        }catch(Exception e){
            e.printStackTrace();
        }finally{
            JDBCUtils.release(rs, pstmt, conn);
        }
        return list;
    }

}