package db;

import context.DBContext;
import entity.Category;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.logging.Level;
import java.util.logging.Logger;

public class CategoryDB {

    DBContext xDBcontext;
    Connection xConnection;

    public CategoryDB() {
        xDBcontext = new DBContext();
        try {
            xConnection = xDBcontext.getConnection();
        } catch (Exception ex) {
            Logger.getLogger(CategoryDB.class.getName()).log(Level.SEVERE, null, ex);
        }
    }

    public ArrayList<Category> getAll() {
        ArrayList<Category> xArrayListOfCategory = new ArrayList<>();
        String sqlLineCommand = "select *from Categories";

        try {
            //     CallableStatement // goi ham , thu tuc trong sql
            //   Statement // khong co tham so
            // PreparedStatement // co tham so
            PreparedStatement xPreparedStatement = xConnection.prepareStatement(sqlLineCommand);
            ResultSet xResultSet = xPreparedStatement.executeQuery();
            while (xResultSet.next()) {
                Category xCategory = new Category();
                //cai nay phai tu 1 (thuoc tinh )
                xCategory.setID(xResultSet.getString(1));
                xCategory.setName(xResultSet.getString(2));
                xCategory.setDescrible(xResultSet.getString(3));
                xArrayListOfCategory.add(xCategory);
            }
            return xArrayListOfCategory;
        } catch (SQLException ex) {
            Logger.getLogger(CategoryDB.class.getName()).log(Level.SEVERE, null, ex);
        }

        return null;
    }
}