Java_DB_Utils_Ex

public void insertCategory(List<CategoryDTO> listCategory) {
        JDBCUtil util = new JDBCUtil();
        String conString = util.createConnectionString("XMLData", "sa", "123456");

        int i = 1;
        String query = "Insert into Category values(?,?)";
        for (CategoryDTO cate : listCategory) {
            Object[] params = new Object[2];
            params[0] = cate.getId();
            params[1] = cate.getName();

            boolean success = util.insert(conString, query, params);

            if (!success) {
                System.out.println(query);
                System.out.println("Error categories.");
                break;
            }
            i++;
        }
    }



    public List<CategoryDTO> getAllCategory(){
        List<CategoryDTO> listCate = new ArrayList<CategoryDTO>();
        JDBCUtil util = new JDBCUtil();
        String conString = util.createConnectionString("XMLData", "sa", "123456");

        String query = "Select * from Category";
        try {
            List<Object[]> data = util.getAll(conString, query);
            for (Object[] obj : data) {
                CategoryDTO cate = new CategoryDTO();
                cate.setId(Integer.parseInt(obj[0].toString()));
                cate.setName(obj[1].toString());
                listCate.add(cate);
            }
            return listCate;
        } catch (SQLException ex) {
            ex.printStackTrace();
        }
        return null;

    }