Shulou(Shulou.com)06/03 Report--

This article shares with you the content of a sample analysis of the JavaWeb warehouse management system. The editor thinks it is very practical, so share it with you as a reference and follow the editor to have a look.

System interface diagram

Coefficient of difficulty (easy to enter)

Because there is a relatively basic grammar, for Java beginners, the foundation is not very good friends, it is also relatively easy to use

Backend:

1. Using Java Servlet itself is a Java syntax, seamless linking, and invalid configuration, web.xml can be easily configured at once.

two。 Use C3P0 to connect to the database, configuration files, code, jar package, are in place, no need for secondary operation.

3. The code adopts Service and Dao hierarchical logic, which is clear and practical, and the code is simple and easy to understand.

Front end:

1.Jsp is also a Java syntax, so you don't need to learn anything new, just write Java code.

2.HTML only needs the most simple syntax of commonly used tags, and rookies can easily understand it.

3.css is just a little bit of page style, it's easy.

4.JavaScript needs to know the basic grammar, and learning web is a must.

5.Jquery is the plug-in library of JavaScript, which is only used to interact with the background, and can only interact with the background using $. Post.

The most important thing is that through relatively simple, basic syntax, let you understand how to use Java to develop a web system, a complete understanding of the entire development process, and then enhance the confidence of learning and increase the sense of achievement.

Development environment

Only if I like to use it personally, I can choose what I like.

Development tool: eclipse/myEclipse8.5

Database: mysql 5

Web container: tomcat 6

Jdk version: 1.6

System function

Role introduction

1. Super Admin

Permissions: Super Admin is the most privileged role, with all the permissions of the system.

two。 System administrator

Authority: user management, warehouse management, classification management, goods management, import and export information management, password management, login module.

3. Ordinary user

Permissions: the role with the least permissions, only changing passwords, registering, logging in and logging out of the system, viewing categories, querying goods information, and querying their own shipping information.

Introduction of table structure

User table

/ / user table CREATE TABLE `user` (`id` int (11) NOT NULL auto_increment COMMENT 'key', `no` varchar (20) default NULL COMMENT 'account-students generally use student ID', `name` varchar (100) not NULL COMMENT 'name', `password` varchar (20) not NULL COMMENT 'password', `sex`varchar (20) default NULL COMMENT 'gender', `phone`varchar (20) default NULL COMMENT 'phone', `role_ id` default NULL COMMENT 'role 0 super administrator, 1 administrator 2 ordinary user', `isValid` varchar (4) whether default'Y' COMMENT'is valid, Y is valid, others are invalid', PRIMARY KEY (`id`) ENGINE=InnoDB DEFAULT CHARSET=utf8

Insert Super Admin data by default

INSERT INTO `user`VALUES ('1customers,' sa', 'Super Management', '123customers,' 1managers, '111users,' 0users,'Y')

Menu list

CREATE TABLE `menu` (`id` int (11) NOT NULL, `menuCode` varchar (8) default NULL COMMENT 'menu code', `menuName` varchar (16) default NULL COMMENT 'menu name', `menuLevel` varchar (2) default NULL COMMENT 'menu level', `menuParentCode` varchar (8) default NULL COMMENT 'menu parent code', `menuClick` varchar (16) default NULL COMMENT' click triggered function', `menuRight` varchar (8) default NULL COMMENT 'permission 0 super administrator, 1 indicates administrator, 2 indicates ordinary user You can use', PRIMARY KEY (`id`) ENGINE=InnoDB DEFAULT CHARSET=utf8 in combination with commas.

Data inserted by default (it is recommended to insert row by row, anyway, my mysql is done one by one, otherwise the following Chinese will be garbled)

INSERT INTO `menu` VALUES ('1customers,' 001miles, 'administrator management', '1levels, null,' adminManage','0'); INSERT INTO `menu` VALUES ('2levels,' 002cycles, 'user management', '1levels, null,' userManage', '0memery 1'); INSERT INTO `menu`VALUES ('3customers,' 003records, 'warehouse management', '1customers, null,' storageManage', '0mem1') INSERT INTO `menu` VALUES ('4minutes,' 004records, 'items classification management', '1records, null,' goodsTypeManage', '0memires 1memu` 2'); INSERT INTO `menu`VALUES (' 5times, '005cycles,' item management', '1menu` VALUES', '1minutes, null,' goodsManage', '0menu` VALUES'); INSERT INTO `menu`VALUES ('6records,' 006records, 'entry and exit records', '1records, null,' recordManage', '0jin1Ji 2') INSERT INTO `menu` VALUES ('7numbers,' 007codes, 'change passwords', '1records, null,' modPwd', '0memu` VALUES'); INSERT INTO `menu` VALUES ('8minutes,' 008records, 'exit system', '1records, null,' logout', '0meme2')

Warehouse table

CREATE TABLE `storage` (`id` int (11) NOT NULL auto_increment COMMENT 'primary key', `name` varchar (100) not NULL COMMENT 'warehouse name', `remark` varchar (1000) default NULL COMMENT 'remarks', PRIMARY KEY (`id`) ENGINE=InnoDB DEFAULT CHARSET=utf8

Classification table

CREATE TABLE `goodsType` (`id` int (11) NOT NULL auto_increment COMMENT 'primary key', `name` varchar (100) not NULL COMMENT 'category name', `remark` varchar (1000) default NULL COMMENT 'remarks', PRIMARY KEY (`id`)) ENGINE=InnoDB DEFAULT CHARSET=utf8

Goods list

CREATE TABLE `goods` (`id` int (11) NOT NULL auto_increment COMMENT 'key', `name` varchar (100) not NULL COMMENT 'name', `storage` int (11) not NULL COMMENT 'warehouse', `goodsType` int (11) not NULL COMMENT 'category', `count` int (11) default NULL COMMENT 'quantity', `remark` varchar (1000) default NULL COMMENT 'remarks', PRIMARY KEY (`id`) ENGINE=InnoDB DEFAULT CHARSET=utf8

In-and-out record table

CREATE TABLE `record` (`id` int (11) NOT NULL auto_increment COMMENT 'key', `goods` int (11) not NULL COMMENT 'goods id', `userId` int (11) default NULL COMMENT' consignee / replenishment', `createtime`datetime default NULL COMMENT 'operating time', `admin_ id`int (11) default NULL COMMENT 'operator id', `count`int (11) default NULL COMMENT' quantity', `remark` varchar (1000) default NULL COMMENT 'remarks', PRIMARY KEY (`id`) ENGINE=InnoDB DEFAULT CHARSET=utf8 System module introduces system administrator management

Super Admin has the right to add, modify, and delete system administrators.

User management

Administrators and super managers can operate, add, modify, delete and other operations.

Warehouse management

Administrators and super managers can operate, add, modify, delete and other operations.

Classified management

Administrators and super managers can operate, add, modify, delete and other operations.

Goods management

Administrator and super management can operate, add, modify, delete, ship, replenish and other operations.

Users only have the function of viewing.

Management of incoming and outgoing goods

You can view the situation in and out of the warehouse (including goods, operator, consignee, time, quantity, etc., red negative number indicates shipment, green indicates replenishment).

Modify the password

Code directory java file

Page

Backend layering

Pay attention

1.

two。

3. It is inevitable that there will be some bug, but it is not for online use. I think it is enough for reference study.

4. There is also deployment documentation in the code.

Thank you for reading! This is the end of this article on "sample Analysis of JavaWeb Warehouse Management system". I hope the above content can be of some help to you, so that you can learn more knowledge. if you think the article is good, you can share it out for more people to see!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.