Oracle & A small information management system developed by JSP (i) Description documentation

js|oracle| Information Management
Information Management System Documentation



Website structure Design



I. Goal design



1. Information management



1.1 Information added



1.2 Information modification



1.3 Information deletion



2. Information display



2.1 Show All information



2.2 Displaying information by category



2.3 Displaying information by keyword



Two. Design ideas



This system is a simple information inquiry system, the system has the following characteristics:



1. Practical: The realization of a complete information query decency



2. Simple and practical: in order to enable users to master the use of the entire system as soon as possible, the structure of the system is simple but full-featured, concise page design makes the operation more convenient



3. Code specification: Code concise, clear and understandable



4. System structure: DB server, Web server, client (modify delete Add browsing function)



Three. system function analysis and design



Information Query system is divided into 3 modules: Information Management module, information display module, information query module, as shown:










Information Management Module



Information Display Module



Information Query Module



Information modification



Information added



Information deletion



Show All information



Display information by category



Keyword Query



Keywords query information in the station






















































































Database structure Design



1. Database Requirements Analysis



The information record contains the following contents:



Information Record number



Information name



Information category



Information description



Information size



Information time and browse times







2. Database Logic Design



Database name: Learning



ARTICLE_ID Number (10), Information record No.



Types VARCHAR2 (50), Information record category



Title VARCHAR2 (255), Information headlines



URL varchar2 (255), reference URL



Content VARCHAR2 (1000), contents



Hits number (10), clicks



Big VARCHAR2 (50), size



Vote VARCHAR2 (50), evaluation



From1 VARCHAR2 (50), related home



Form_url varchar2 (255), related address

Date_and_time VARCHAR2 (32) time



























































Information Management Module



Contains the following modules:



1. Information management



login.jsp



chklogin.jsp



manage.jsp







2. Add information



add.jsp



save.jsp







3. Information modification



edit.jsp



saveedit.jsp



delete.jsp








Administrator Login



login.jsp



Audit account



chklogin.jsp



Manage pages



manage.jsp



Web page



index.jsp



Information added



add.jsp



Information modification



edit.jsp



Information deletion



delete.jsp