基于 MVC ＋ORACLE ＋ODAC 的企业内部业务数据系统的设计与实现

摘要

当前不少大企业都以业务数据为基础，来判断企业的投资领域和员工的绩效，业务数据的统计和呈现尤为重要。大多企业内部管理系统的现状：前台不可配置因而维护量大，后台业务复杂因而团队开发效率低、新版本发布延迟，以及跨国公司业务数据不能及时同步因而数据不可靠。针对这一需求和现状，采用基于 MVC ＋ORALCE ＋ODAC 的架构开发，结合 SVN、Robocopy 和 Jen-kins 机制自动同步数据和实时发布新版本。对系统的整体设计模型、完全可配置的前台、MVC ＋ORACLE ＋ODAC 架构在系统中的应用和关键技术进行重点描述。该系统目前已应用于杭州的某大公司，实际应用证明该系统具有可配置、高效、可靠和安全的特点。%At present,many big-sized companies determine the achievements in investment areas and the performance of employees based on business data,the statistics and presentation of business data is particularly important.The status quo of most of enterprises’inner business data system is:the user interface cannot be configured so that the maintenance load is heavy;the business logic is complicated so the efficiency of team development is low and the release of new version will be delayed;and the business data of multi-national corporations cannot be timely synchronised so the data is not reliable.In view of the demand and the current situation,we use the MVC +ORACLE +ODAC-based architecture for development,combines the mechanisms of SVN,Robocopy and Jenkins for automatic data synchronisation and for real-time new versions release.In this paper,we put the emphasis on describing the overall design model of the system,the fully configurable user interface,the application of MVC +ORACLE +ODAC architecture in the system,and the key technologies.The system has been applied in a large company of Hangzhou.Practical operations prove that the system has the characteristics of being configurable,high efficiency,reliable and safe.