For this project, I implemented a web-based application that manages inventory. It has some basic functionalities like user-login, user-log out and user-sign up. It also supports users to build inventory(add new item), query in inventory(search), delete item, update item, and so on. Beside these functionalities, it contains a table to display the information of each item in the home page. Users can sort this table by different attributes, like category, inventory and date updated.Last but not least, it will display the information of some items that have low stock or haven't been updated for more than 30 days so that users are able to take measures to those items.
JAVA, MySQL, HTML, CSS, JavaScript
- Step1 Set up all the tables that we need in this project in MySQL database
- Step2 Built the web server by using Java and Socket
- Step3 Implement back-end including database operations
- Step4 Create front-end pages by using HTML, CSS and JavaScript
| Feature | Description |
|---|---|
| Login, logout | Allow a user to login and signout. |
| Sign up | Allow a user to create an account. |
| Search | Users are able to do partial search for inventory by item's name, category and brand. |
| View item | Click the name of an item and display details for this specific item. |
| Build inventory | Allow the user to create a new inventory by entering all appropriate detail. |
| Update item | Allow the user to update information for an item. |
| Delete item | Allow the user to delete an item. |
| Sort inventory | Allow the user to sort the inventory list by quantity, category and date updated. |
| Reminder | Display items with low-stock or haven't been updated for more than 30 days to the user. |
Login page:
Home page:
