Purpose
This report deals with the development of website for the music products. The website aims to provide ease in maintaining the product and related operations such as update, delate and add product and so on. Moreover, the website can help to reach more number of people, where people can find all the information of the available products, in the website. However, this is one of the objective of website development. The development of website includes various stages and purpose. Here, the main objective is product maintenance with the help of website which contains database management facility. The database management facility is very important for any business, as it can help to see the growth and performance of the business. The database management system ensures to manage the product details, then it can help in maintaining the product related data. For instance, it can help in storing, updating, deleting, adding and manipulating the data. For this project, the programming language such as Java is selected for the development of the website. The website management responsibility can be managed by the admin.
The purpose of this project includes developing a product’s webpage for the maintenance of the product, for its smooth functioning and to have friendly user interface. The purpose relates to database maintenance of the products on the website. For example, the functions like, adding products, updating the products and deleting the products in the webpage.
The scope of the project denotes to ensure the customers can view the available products with ease on the webpage. With this, it benefits to discard the unwanted products and the new products can be included easily without any mess. Moreover, the changes made are visible in no time, on the webpage for the users.
JDBC-Java Database Connectivity
The aim of JDBC is to have interaction with the database. It is a software component which can help in enabling the java applications.
For have a secure channel, the SSL security protocol is utilized.
JSP-Java Server Pages
JSP refers to a server side technology which contains various benefits for the website.
JPA – Java Persistence API
JPA helps to manage the data present between the java object and the java class.
This is a development of a website that manages the products which deals with music. The requirement of the website is to provide the suitable code, music product details, in-depth product description and their cost, which must be viewed on the webpage easily. Because, these are the basic information requested by the customers to choose the product.
The product is an open source. It is also a web based client server model. The website contains a login page for each user. To login the user is required to first create his/her account which will be unique for each individual. The main purpose of having this login option is to differentiate between the authorized and unauthorized users, especially for data security of the user. It also has many things to deal with customer satisfaction and so on. The user has the facility to update their profile.
Scope
User interface is a medium which helps to provide communication with the operating system. Here, it is necessary to have a system interface between the system and the products of the system.
There is an interaction required among the class, object, public and static, because the interface interacts with both the java class and the java object.
Hardware interface denotes the connected system, where window 10 is utilized for the website development (Sacks, 2012).
The Java programming language is used along with SQL as a database management system (“CREATE SQL QUERY USING NATURAL LANGUAGE PROCESSING”, 2017).
As mentioned already, the website contains a login page for each user of the website. The users are given facility of communication with the webpage. To do this, the user must login to his/her created account, which will be unique for each individual. The user has the authority to add or delete and update by the product webpage. This is how the user communicate with the help of the webpage.
For maintenance of the product, memory space is allocated. The development of website includes the usage of both Java and database, where database helps to handle the memory space of the data that is allotted.
As any application starts with the index page, even this project’s website application begins with the index page. However, the other pages such as, admin page, user login page, add product page, product delete page and update the product page are also present for the application. It contain an “Add button”, to additionally include any required product. Once the product is added, all the product details are displayed on the webpage.
Admin Page
User Login Page
Product Page
For initializing the sequence and data, the requirements mention the provided site and its operations.
The product function comprises of both physical input and physical output, which describes the relation between the input and output. The following figure represents the above statement (Plumley, 2013).
The characteristics approaches the process of user development to have interaction with the specific product and process.
It includes a model which is based on constraints for choosing the cost, material, design methods and description of the product.
The webpage comprises of add product, delete and update product pages, which are linked with one another.
The User interface is utilized for the following project. For the future, advanced requirements are required.
It is evident that the database has been established connection with the webpages i.e., the pages such as admin page, login page and product page are connected with the database, through the SQL.
The functions used here includes, adding product to the product detail page, then delete the product and update the product on the same webpage. After the function is completed, the details of the product represent the name of the product, cost, code and description.
For improving the performance of the website, the requirement is using Java programming language along with the database for storing the data.
To store the data in the database, the SQL query is used. Add product page, delete product page and update product page are the used webpages, which will be used for the automatic storage, update, deletion and addition process (Ramakrishnan & Gehrke, 2011).
To have an effective website, it is necessary for the web browser to be compliant with. This is a software method which is required.
Reliability refers to the complete consistency and the function’s performance needed in the required time.
Availability refers to the presence of the product details along with their description on the product webpage.
To maintain the security of the user information, user account is created to login to the webpage, which facilitates the user with a unique username and password.
The admin contain the power to update the data. The product maintain page is created here to automatically update the details of the product.
It is the webpage portal which manages and displays the user interface software components.
Mode of System
The running code could ignored the user permission. But, the user has no permission to alter the security level and sharing.
Each operation is displayed by the user class and it define each user operation.
The product is referred as the object.
For displaying the details of the music product the features are used. The displayed information are, details of the product, cost of the product and the product’s description.
The stimulus encourages the activity of function and people.
The users requested is responded by the administrator/ admin, while the product is purchased by the users.
It denotes the connection with each function. For instance, the user login page and the product page are present in the admin page, whereas, the product details pages is present in the user page.
Additionally, other functions can also be included apart from add product, delete product and update product page.
The communication vision is changed which represents the quality, risk, quantity and problems of the product.
The approval of document helps to meet the requirements of the business and people’s approval.
Conclusion
This report accomplishes the development of website for the music products. The website’s intension to provide ease in maintaining the product and related operations such as update, delate and add product are achieved. The database management system manages the product details and maintains the product related data. For this project, the programming language such as Java and SQL are selected for the development of the website and database management.
References
Create Sql Query Using Natural Language Processing.. (2017). International Journal Of Advance Engineering And Research Development, 4(01). doi: 10.21090/ijaerd.etcw23
Plumley, G. (2013). Website design and development. Hoboken, N.J.: Wiley.
Ramakrishnan, R., & Gehrke, J. (2011). Database management systems. Boston: McGraw-Hill.
Sacks, M. (2012). Pro Website Development and Operations. Berkeley, CA: Apress.
Smallwood, N., & Ulrich, D. (2004). Capitalizing on Capabilities. Retrieved from https://hbr.org/2004/06/capitalizing-on-capabilities.