Based on data report processing system (vue+ssm+mysql)

pick want
In the new century , The human economy is developing rapidly , Earth shaking changes have taken place in people's lives , Especially the application and popularization of computers in various fields of economic and social life . In enterprise applications , Data report processing system is a technology that every enterprise must apply and develop . Now , More and more companies are creating report application systems suitable for their practical applications and needs , So that internal employees can view the report in an intuitive way 、 Query and analyze the statistical data of the company's daily business data . Browser style interface , This can be done more conveniently .
In design , The system adopts Java Of SSM frame , use VUE Technical design dynamic page , And consider system security and code reusability , use JavaBeans Encapsulate the core code of the program . Use of the platform Eclipse Tools and Tomcat As Web The server , Back end connectivity MySQL database , Realize a clear function 、 The cost is low 、 Strong commonality 、 A system suitable for China's national conditions .
This paper introduces the design goal of the system 、 Technology and tools used 、 The overall design of the system 、 Detailed design and implementation . The user module design of the system includes personal information query 、 Personal information modification 、 Report entry 、 Report query 、 Report modification 、 to examine 、 Employee information entry 、 correct 、 Functions such as audit and user module function authorization . The system has complete functions 、 Simple and easy to use 、 well appointed , It can meet the needs of typical small and medium-sized enterprises .
key word ： Data reports ;Java,SSM,VUE,MySQL; Processing system
Abstract
Since the beginning of the new century, with the rapid development of human economy, people’s life has undergone earth-shaking changes, especially the application and popularization of computers in all fields of economic and social life.In enterprise application, data report processing system is a technology that must be developed by every enterprise.Nowadays, more and more companies are creating reporting application systems suitable for their practical applications and needs, so that internal employees can view reports, query, and analyze the statistics of the company’s daily business data in an intuitive way.Browser style interface which can be done more easily.
In the design, the system adopts Java’s SSM framework, using VUE technology to design dynamic pages, and considers the system security and code multiplexing, using the JavaBeans package program core code.The platform uses Eclipse tools and Tomcat as a Web server, and the back end is connected to the MySQL database, realizing a system with clear functions, low cost, strong versatility and suitable for China’s national conditions.
This paper introduces the design objectives of the system, the techniques and tools used, the overall design of the system, the detailed design and implementation.The user module design of the system includes personal information query, personal information modification, report entry, report query, report modification, audit, employee information input, correction, audit, and user module function authorization.The system is fully functional, easy to use, and fully equipped, which can meet the needs of typical small and medium-sized enterprises.
Key words: data report; Java, SSM, VUE, MySQL; processing system
Objective record
pick want I
Abstract II
Chapter one Preface 1
1.1 Background and significance of the topic 1
1.2 Analysis of the advantages and current situation of data report processing system 2
1.4 The main contents of the study are 4
1.5 The structure of the paper 5
Chapter two Related technology 、 Tools and feasibility analysis 6
2.1 SpringBoot + Shiro + JWT 6
2.1.1 SpringBoot 6
2.1.2 Shiro 7
2.1.3 JWT 7
2.2 MySql + MyBatis 8
2.2.1 MySql 8
2.2.2 MyBatis 9
2.3 Redis 9
2.4 Vue.js + WebPack 11
2.4.1 Vue.js 11
2.4.2 WebPack 12
2.5 SublimText 13
2.6 Tomcat 18
2.7 Feasibility analysis 18
2.7.1 Market feasibility 19
2.7.2 Technical feasibility 19
2.7.3 Application feasibility 19
The third chapter Requirements analysis and system design 20
3.1 Demand analysis 20
3.1.1 market research 20
3.1.2 User needs analysis 21
3.1.3 flow chart 23
3.1.4 System use case diagram 23
3.2 The system design 25
3.2.1 System objectives 25
3.2.2 Overall design of system module 25
3.3 Database design 27
3.3.1 Database conceptual design 27
3.3.2 Database logic design 30
3.3.3 Detailed database design 31
Chapter four system implementation 34
4.1 System home page design 34
4.2 User management 35
4.3 Role management 36
4.4 Menu management 36
4.5 Report type management 42
4.6 Report template management 45
4.7 Report management 47
4.8 Report view page 48
4.9 Large screen template management 50
4.9.1 Big screen design 51
4.9.2 Preview button 51
4.10 Print template management 53
The first 5 Chapter The system test 54
5.1 System software testing 54
5.2 Data report processing system test 54
5.2.1 Test of login module 54
5.2.2 Test of report module 54
5.2.3 Test of information module 55
5.2.4 Authority module 55
The first 6 Chapter The conclusion of this paper is 56
reference 57
Cause thank 59
4.1 System home page design
The main interface of this system is designed , It adopts a relatively simple and generous page design concept , You can
To determine whether it is the user module or the administrator block . The interface design is shown in the figure 5.1 Shown .

chart 5.1 System main interface
The following is the core code of the login module :

	    public String execute() throws Exception{
    
		forms=formsDao.getFormsById(id);
		System.out.println(forms);
		hf=HDao.getHFormsById(id);
		System.out.println(hf);
		forms.setEntry_user(hf.getEntry_user());
		forms.setEntry_date(hf.getEntry_date());
		forms.setFile_catalog(hf.getFile_catalog());
		forms.setStatus(String.valueOf(1));
		forms.setTypeid(hf.getTypeid());
		forms.setUserID(hf.getUserID());
		formsDao.updateForms(forms);
		user=userDao.getUserById(userid);
		list=formsDao.getAllForms(page, pageSize, userid);
		totalPages=formsDao.getTotalPages(userid, pageSize);
		return "success";
	}
public String execute() throws Exception{
    
		// Judge whether the login is successful , Query the login user information 
		user=userDao.getUser(username, password);
		System.out.println(user)
		// Landing successful 
		if(user!=null){
    
			role=roleDao.getRoleById(user.getRoleID());
			if(user.getRoleID()==1){
    // Ordinary users 
				list.add(user);
				page=1;
				totalPage=1;
			}else if(user.getRoleID()==2){
    // Administrator user 
				list=userDao.getAllUser(page, pageSize);
				totalPage=userDao.getTotalPages(pageSize);
			}
		}
		if(user!=null){
    
			return "success";
		}else{
    
			errorMsg=2;
			return "error";
		}
	}

4.2 User management
Login personnel of the management system , The default password for new users is 123456 Functions include query / Reset , see , edit , Delete , Batch deletion If you are a super administrator, you do not need to add roles for users , The super administrator has all the permissions If you are not a super administrator , You need to add roles for users , The corresponding roles are maintained in the role management module
4.3 Role management
The role of the management system , You can grant certain permissions to roles , Then assign the role to a user , Control users' permissions through roles . Permission temporarily includes two parts of permission ：1、 Menu function permissions 2、 The report permissions Menu function permissions ： Determines which menus and functions the user can access The report permissions ： Users can see those reports in the report management module .
4.4 Menu management
Maintain the menus in the system and the corresponding functions under the menus There are two rules for accessing menus ：1、 Access after login 2 Log in and authorize access Access after login ： As long as you log in to the system, you can access the menu Log in and authorize access ： The menu that needs to be logged in and authorized to the user through the role management function
There are three kinds of access rules for functions ：1、 Public access 2 Access after login 3 Log in and authorize access Public access ： No authorization is required , The system will not do any interception , Anytime Access after login ： You need to log in with token Information can be accessed Log in and authorize access ： You need to authorize by role , You need to bring token Information , And you can only access . Screenshot of user management page ：
Reprinted from ：http://www.biyezuopin.vip/onews.asp?id=16454