"Springmvc+mybatis project" Jie Xin Business-6. Key Knowledge Review

1. Key Knowledge Review

Maven
1) covering the warehouse files, the actual enterprise development, the company will be a test server, in the test server. Our developer program is connected to the private service. When there are no projects in the project to use the Jar,myeclipse Maven plugin will automatically go to the database to find the jar, if not found to go to the central warehouse Maven search, found after download. activiti-engine-5.13.jar.lastupdated when accessing a remote repository, it is possible to interrupt due to network instability. When the program is connected again, it will be automatically corrected. Pom file error, jar error, go to the warehouse directory to find Jar,jar exist, click Jar Open can open. If the jar does not open, the jar is damaged on download, and Maven does not automatically fix it. Manually delete, let him automatically re-download. Whether it's a remote repository or a local repository, the Jar,myeclipse maven plugin will automatically load it.

2) Maven jar is divided into two categories, and one is the jar of Maven's own plugin. Another type of program calls the jar. The first category, which is closely related to the MyEclipse Maven plugin version. The minor version number associated with the Maven plugin.

3) Extreme: Maven skeleton not found, specifically configure a skeleton link

A bug when Maven created the project:

Oracle
In the actual enterprise, on the test server, install the Oracle service side. Install the operating system first, install the operating system, and any other software do not install, install Oracle. Oracle can easily conflict with other programs, and after a conflict, it only prompts for service or interception.
To uninstall, Oracle First program uninstall, and then open the registry, search contains the beginning of the Ora all content, are deleted. (under Baidu, Oracle uninstalls the article, it compares specifically to tell you which to delete.) ）
Re-install.

On our local machine, install the Oracle client. Create a local service. Install the client that has an application in its menu. Called "Installation Assistant". Configure local services.

1) Install XE Lite, which is automatically served as a server. Because it is installed natively, it automatically creates an XE local service that we can use directly without having to install the client.
2) Install the virtual machine, you must install an Oracle client locally, and then configure the local service.

This IP address is the address in the virtual machine. The service name SID that can be created with the default Oracle server when it is connected


PowerDesigner 15.1
It is used primarily for database modeling, which itself creates all the diagrams of UML.
Use case diagrams: Understand the capabilities of the entire system and who uses them to understand the overall overview of the system. Process products.

system function Structure diagram: to the user to see, at the same time it is to calculate the contract costs, can be quoted by the module. Developers can assign work tasks on schedule. Process products.

System architecture diagram: When developers get a new architecture, there are a lot of new technologies, drawing this architecture diagram, so that developers understand the architecture of the system. When we develop, in the order of the graph to achieve step by step.


2. Database modeling
The tables are all from the requirements,
Business: When the goods under the contract are filled out, it is a manufacturer; there is a manufacturer when filling in the accessories under the goods. Senior design based on experience, they are common, presented as a basic information template, in the goods and accessories can be common in this information.

3. What is the field content of the business?
Communicating with the customer, the customer will tell us what information he needs and we will compile the information to form a field.

4. Development specification:
A) specification of database design
Database tables and fields are capitalized
Tables have business suffixes, such as _c client table _b base table _p Permissions table
Must have primary key, primary key is table name remove business suffix, add _id, most table's primary key use UUID
When multiple words are in a field, all capitals, separated by underscores
Type Int/long/double/timestamp/char/varchar2 as much as possible in these types, so database design is fairly simple
Sort Number Dead name Order_no
Permissions two fields Create_by creator, create_dept create a department
Record creation Time Create_time
b) Code Development specifications
Place static resources between WebApps and web-inf/pages (secure) with dynamic resource needs validation permissions
The class file is placed under Src/main/java, and the resource file Src/main/resources;web file is placed under Src/main/webapp
Cn.hpu.jk.domain Store all entity files PO
Cn.hpu.jk.dao stores all the DAO's interfaces and implementation classes, the business interface must inherit the Basedao interface, and the business implementation class must inherit the Basedaoimpl implementation class.
Cn.hpu.jk.service stores all service interfaces and implementation classes without inheritance.
Cn.hpu.jk.controller holds all SPRINGMVC controllers, it does not have to inherit Basecontroller; it creates two levels of directory structure, one for the large module name, the second for the small module name, and the business content below.
JSP, which is placed in the Web-inf/pages directory, also create a level two directory, the first layer is the large module name, the second layer is the small module name.
Webapp/components a directory of its third-party components, such as jquery
Webapp/js/common.js It is the whole project common JS
Webapp/mak/xlsprint template files for Excel reports


The current catalogue details of our project:

Code Files Directory

Configuration file Directory

Resource file directory

"Springmvc+mybatis project" Jie Xin Business-6. Key Knowledge Review