01-09-2014, 11:56 AM
After the years of stagnation, there are indications that the typical “Indian Consumer” has finally come online for not most, but at least few sectors of online purchases of items some including books, electronics, gaming, entertainment, and even more. This case study is to build a web store for an online retail management to sell their business merchandise over a finite geographical area.
After the years of stagnation, there are indications that the typical “Indian Consumer” has finally come online for not most, but at least few sectors of online purchases of items some including books, electronics, gaming, entertainment, and even more. This case study is to build a web store for an online retail management to sell their business merchandise over a finite geographical area. Since Internet technology is rapidly improving, more and more people are using the Internet for their business growth and cost reduction in order to achieve their business goals. Business consumers want more convenient and straightforward access to Web applications. There are many technologies that can be used to build Web services and Web applications. This web application does implement the technologies provided by Java namely JSPs, JSTL, Servlets and Java Beans. This application allows users to register online, make purchases online, and track the order and shipping status online. It stores the persistent data into MySQL database and uses Java Database Connectivity (JDBC) to manipulate the data through calls made by the JDBC from the Web Application. The application was built using the current latest web standards. The services were designed using Java as its core programming for its business logics, while the presentational part was been done on varied technologies some including Ajax with jQuery, CSS3, and HTML5. The statistical reports were been designed and presented with Google charts API. For the most of the application’s part, the images and resources were only used when it was in a real need to have its presence to signify the item, while the rest of the presentation was done using Cascading Style Sheets. It seems varied and different streams of information meet together, when we in particular create something out of it. Description of current project At present the work is currently been processed through all the papers and registers, every possible data entry has to be done in the registers every day after the shop has been closed. Here all the records of the items sold, purchased, are maintained by separate registers. Keeping track of the members who are on credit balance and credit purchases are been done in separate registers as well which s time consuming process. There is a separate track of records been maintained in a separate register for all those dealers and merchants who provide goos and/or services to them. The entire process is done all throughout the monthly basis and finally a record is kept track for all those products which we sold as per user’s requirements and a track of all those products help them to make their next orders on safer side. After the records have been tracked each month, Every month is been compared to the sales, purchases and businesses of the previous months, this helps them to keep records on the future gains and the development of their business. • Goods once purchased are kept aside for thorough checking process for any defects/counterfeit, Once done are kept at their respective categorized places and checked regularly • Goods Sold are kept records every night before closing time for their appropriate buying decisions from dealer next time • Every month a transaction process is record which gives the owner the track of their current gains in their business Proposed system and its advantages 1. The proposed automated system will be a database comprising of brief compact, systematic organization of the information which are currently recorded and may be redundant in nature. 2.System will be website based, user friendly and efficient, so that even a non‐technical user can use the system without any difficulty. 3. The proposed system will be computerized system, so this system will not be time consuming. 4. Appropriate master tables must be present so that user will be able to find any kind of records and details. 5. Security will be maintained in this system. No one will be able to see the undesired data unless the administrator permits him. 6. Reports should be generated as follows: a) Bill generation. b) Selling detail report c) Purchases Registration report(Customer wise)
After the years of stagnation, there are indications that the typical “Indian Consumer” has finally come online for not most, but at least few sectors of online purchases of items some including books, electronics, gaming, entertainment, and even more. This case study is to build a web store for an online retail management to sell their business merchandise over a finite geographical area. Since Internet technology is rapidly improving, more and more people are using the Internet for their business growth and cost reduction in order to achieve their business goals. Business consumers want more convenient and straightforward access to Web applications. There are many technologies that can be used to build Web services and Web applications. This web application does implement the technologies provided by Java namely JSPs, JSTL, Servlets and Java Beans. This application allows users to register online, make purchases online, and track the order and shipping status online. It stores the persistent data into MySQL database and uses Java Database Connectivity (JDBC) to manipulate the data through calls made by the JDBC from the Web Application. The application was built using the current latest web standards. The services were designed using Java as its core programming for its business logics, while the presentational part was been done on varied technologies some including Ajax with jQuery, CSS3, and HTML5. The statistical reports were been designed and presented with Google charts API. For the most of the application’s part, the images and resources were only used when it was in a real need to have its presence to signify the item, while the rest of the presentation was done using Cascading Style Sheets. It seems varied and different streams of information meet together, when we in particular create something out of it. Description of current project At present the work is currently been processed through all the papers and registers, every possible data entry has to be done in the registers every day after the shop has been closed. Here all the records of the items sold, purchased, are maintained by separate registers. Keeping track of the members who are on credit balance and credit purchases are been done in separate registers as well which s time consuming process. There is a separate track of records been maintained in a separate register for all those dealers and merchants who provide goos and/or services to them. The entire process is done all throughout the monthly basis and finally a record is kept track for all those products which we sold as per user’s requirements and a track of all those products help them to make their next orders on safer side. After the records have been tracked each month, Every month is been compared to the sales, purchases and businesses of the previous months, this helps them to keep records on the future gains and the development of their business. • Goods once purchased are kept aside for thorough checking process for any defects/counterfeit, Once done are kept at their respective categorized places and checked regularly • Goods Sold are kept records every night before closing time for their appropriate buying decisions from dealer next time • Every month a transaction process is record which gives the owner the track of their current gains in their business Proposed system and its advantages 1. The proposed automated system will be a database comprising of brief compact, systematic organization of the information which are currently recorded and may be redundant in nature. 2.System will be website based, user friendly and efficient, so that even a non‐technical user can use the system without any difficulty. 3. The proposed system will be computerized system, so this system will not be time consuming. 4. Appropriate master tables must be present so that user will be able to find any kind of records and details. 5. Security will be maintained in this system. No one will be able to see the undesired data unless the administrator permits him. 6. Reports should be generated as follows: a) Bill generation. b) Selling detail report c) Purchases Registration report(Customer wise)