The thesis introduces the analysis,the design and the implementation of a general foreign trade software system based on Oracle DBMS, and expounds its technical points and difficulties.The system is developed from a commercioganic foreign trade software based on VFP. The main advantages of analysis,design and implementation of the system are listed as following: After analyzing many foreign trade companies, we proposed a general foreign trade process. Compatibility and smooth upgrade from the previous software(user interface, database structure, data etc.)must be considered when the system is designed. Function modules in this system are independent, but they can be combined according to the requirements. The design of access control mechanism in application layer is the most splendid innovation of this system. We design the module combining with the requirements and characteristics of foreign trade process. Then the thesis gives an instance of an improved and general purpose access control model in the foreign trade field. Following the theory of modularizing design, we design and implement the system,such as serial number prompt, interface encapsulation of general controller.Finally,some personal opinions about the system are put forward.I believe these observations in software development will do great help to the developers in this field. |