Rewrite Netbeans e-commerce tutorial using Spring framework

1. Designing application:
   • Scenario
   • Requirements
   • Mockups
   • Architecture
2. Setting up development environment:
   • IDE: Spring Tool Suite
   • DBMS: MySQL
   • Create a new Spring MVC template project
   • Template engine: Velocity or Thymeleaf; Layout: Bootstrap
3. Preparing views and controllers (front-end).
4. Designing data model:
   • Identify the entities and their relationships
   • Follow bottom up or top down approach using Hibernate
5. Developing business logic.
6. Integrating with front-end.
7. Others:
• Securing the application
• Adding language support
• Testing
• Deploying on OpenShift -> visit demo app:
• The front store
• The admin console (username/password found in sql_scripts/admin-console_data.sql)

From: https://github.com/sunshine55/affablebean-spring-tutorial

Read More

Ofbiz

• Ofbiz is used as an ERP system rather than an ECommerce application so be careful when choosing it as a shop.
• Demo
  https://www.antwebsystems.com/control/main
  https://fhdemo.solveda.com/webtools/control/login(use admin/ofbiz to login)
  http://bigfish.solveda.com/bfDemo.html 
  http://demo-stable-ofbiz.apache.org/ecommerce/control/main
  http://demo-stable-ofbiz.apache.org/catalog/control/main?USERNAME=admin&PASSWORD=ofbiz&JavaScriptEnabled=Y

Read More

ECommerce Concept

 Catalog:

provides flexible product and category organization to manage categories and products.

SKU:

Stock-Keeping Unit. In the field of inventory management, a stock keeping unit (SKU /ˌɛsˌkeɪˈjuː, ˈsk(j)uː/) is a distinct type of item for sale,^[1]: 122 such as a product or service, and all attributes associated with the item type that distinguish it from other item types. For a product, these attributes can include manufacturer, description, material, size, color, packaging, and warranty terms. When a business takes inventory of its stock, it counts the quantity it has of each SKU.

SKU can also refer to a unique identifier or code, sometimes represented via a barcode for scanning and tracking, that refers to the particular stock keeping unit. These identifiers are not regulated or standardized. When a company receives items from a vendor, it has a choice of maintaining the vendor's SKU or creating its own.^{[2]: 74–75} This makes them distinct from Global Trade Item Number (GTIN), which are standard, global, tracking units. Universal Product Code (UPC), International Article Number (EAN), and Australian Product Number (APN) are special cases of GTINs. 

Inventory: (tồn kho)

Inventory is the amount of goods kept in the warehouse (kho). Includes finished goods (thành phẩm) and unfinished products (nguyên liệu, bán thành phẩm - Unfinished goods – components, ingredients, raw materials, semi-processed materials, and subassemblies). However, actual inventory is complex and has a huge impact on the performance of the entire supply chain. Therefore, businesses need an effective Inventory Management plan.

Inventory Management is the process of planning, strategizing, and controlling inventory (quantity).

Read More

Magento

Magento là một mã nguồn mở tạo web thương mại điện tử đã được ra mắt vào ngày 31 tháng 3 năm 2008. Magento được phát triển bởi Varien, với sự giúp đỡ từ các lập trình viên trong cộng đồng mã nguồn mở, nhưng chỉ được sở hữu bởi Magento Inc. Magento được xây dựng trên nền tảng Zend Framework. Nó sử dụng các mô hình thực thể thuộc tính giá trị cơ sở dữ liệu (EAV – entity-attribute-value) để lưu trữ dữ liệu.site.

• https://magento.com/
• http://builtwith.com/ecommerce/
• Magento for Developers

Read More

The NetBeans E-commerce Tutorial - 3..13

• Setting up the Development Environment
• Designing the Data Model
• Preparing the Page Views and Controller Servlet
• Connecting the Application to the Database
• Adding Entity Classes and Session Beans
• Managing Sessions
• Integrating Transactional Business Logic
• Adding Language Support
• Securing the Application
• Testing and Profiling
• Conclusion

Read More

The NetBeans E-commerce Tutorial - Designing the Application 2

The application that you design in this tutorial is based on a real-world scenario. After being introduced to the tutorial scenario, you consolidate a high-level list of customer requirements. You then prepare a diagram of the application's business process flow, and a series of mockups which help both you and your customer get a clearer picture of how the final application will look to an end-user. Finally, you break down the customer requirements into a set of implementation tasks, and structure your application so that the responsibilities and interactions among functional components are clearly defined.

This tutorial unit discusses the MVC (Model-View-Controller) design pattern. After investigating the benefits that this pattern offers, you set about mapping JSP, Servlet, and other technologies to the MVC architecture, and draft a diagram that illustrates the components of the application in terms of MVC.

This unit makes various references to Designing Enterprise Applications with the J2EE Platform, Second Edition. This book contains guidelines promoted by Java BluePrints.

Although this tutorial unit does not require use of the NetBeans IDE, it is essential because it lays the groundwork for tasks that will be covered in the following units.

You can view a live demo of the application that you build in this tutorial: NetBeans E-commerce Tutorial Demo Application.

The Scenario

A small grocery store, the Affable Bean, collaborates with several local farms to supply a community with organic produce and foods. Due to a long-standing customer base and increasing affluence to the area, the store has decided to investigate the possibility of providing an online delivery service to customers. A recent survey has indicated that 90% of its regular clientele has continuous Internet access, and 65% percent would be interested in using this service.

The grocery store staff have asked you, the Java web developer, to create a website that will enable their customers to shop online. They have also asked that you create an administration console alongside the website, which will allow staff members to keep track of orders.

The store's location is in Prague, in the Czech Republic. Because regular clientele are both English and Czech-speaking, staff have requested that the website support both languages.

The grocery store has already purchased a domain and web hosting plan that provides a Java EE 6-compliant server and MySQL database server. Staff have indicated that one technically-oriented member is able to deploy the application to the production server once it is ready.

Based on the provided scenario, the Affable Bean staff have communicated to you that the application you are to create should fulfill the following requirements:

1. An online representation of the products that are sold in the physical store. There are four categories (dairy, meats, bakery, fruit & veg), and four products for each category, which online shoppers can browse. Details are provided for each product (i.e., name, image, description, price).
2. Shopping cart functionality, which includes the ability to:
   • add items to a virtual shopping cart.
   • remove items from the shopping cart.
   • update item quantities in the shopping cart.
   • view a summary of all items and quantities in the shopping cart.
   • place an order and make payment through a secure checkout process.
3. An administration console, enabling staff to view customer orders.
4. Security, in the form of protecting sensitive customer data while it is transferred over the Internet, and preventing unauthorized access to the administration console.
5. Language support for both English and Czech. (Website only)

Read More

The NetBeans E-commerce Tutorial - Introduction 1

Welcome to the NetBeans E-commerce Tutorial. In this multi-part tutorial, you learn how to create a simple yet effective e-commerce application that demonstrates various important features of Java web and EE development. In doing so, you'll familiarize yourself with the NetBeans IDE and become capable of applying it to your own development purposes.

Taking the time to master the IDE will ultimately lead you to become more efficient and versatile as a developer. While you work through the tutorial units, you'll learn how to make best use of the IDE's facilities and tools. These include:
>>Editor support for different languages: syntax highlighting, code completion, API documentation support, keyboard shortcuts, refactoring capabilities, and code templates
>>Window system: Projects, Files and Services windows, the Tasks window, Javadoc window, HTTP Monitor, Navigator and Palette
>>Integration with other services: automatic deployment to a registered server, database connectivity, browser interoperability
>>Development tools: Debugger, Profiler, HTTP Server Monitor, Local History support, and a graphical Diff Viewer

The tutorial is modular in fashion, with each unit focusing on specific concepts, technologies, and features of the IDE. You can successfully follow a tutorial unit on its own using the provided setup instructions and application snapshots (from Unit 5 onward). However, you'll get the most benefit by working through all units consecutively, from beginning to end. This will also help to illustrate the development process.

Unit 3, Setting up the Development Environment introduces you to the NetBeans IDE. In it, you create a Java web project which is the basis for the work you undertake in later tutorial units. In Unit 4, Designing the Data Model, you primarily work with MySQL WorkBench, a visual database design tool, to create a data model for the application. Each successive tutorial unit provides you with a project snapshot that corresponds to the project's beginning state for that given unit. This enables you to work through a single tutorial unit outside of the E-commerce Tutorial's larger context. To use these snapshots, download them to your computer and open them in the IDE using the Open Project wizard (Ctrl-Shift-O; ⌘-Shift-O on Mac).

You can view a live demo of the application that you build in this tutorial: NetBeans E-commerce Tutorial Demo Application.

The remainder of this unit covers some information relevant to the tutorial, as well as basic concepts necessary for Java EE development. Make sure you understand the concepts outlined below before proceeding with development.

Read More