广告管理系统的软件外包

广告管理系统的软件外包

摘 要

广告管理系统是本人对日本大阪电视台的外包服务。此系统是要解决广告的基本信息的录入和维护（查询、添加、修改、统计等），实现广告管理的系统化、规范化、自动化。

基于ehydra框架，使用1个开放源代码的、基于 Java 的可扩展开发的eclipse平台工具，采用SQL数据库,这些都使得开发起来更灵活，更快捷；用户登录从数据库连接验证开始，具有很好的安全性。本系统依发包方的任务要求，含有3大系统界面(新规画面、编辑画面、复原画面属同1界面)，囊括检索、新规、削除、复原、CSV出力、返回6大功能，共计出现有5个画面。

经用例测试，此设计达到发包方要求，已经被其接收。本系统已被用到电视台的广告管理中，在功能上也能进1步扩展，大阪电视台可以根据自身需求，进1步开发完善。

关键词：广告管理；软件外包；eclipse；SQL

Abstract

Advertising Management System is a software outsourcing services to the television of Osaka, Japan, which is designed by me. This system is to address the input for the basic advertising information and the maintenance (select, add, update, count, etc.) , also to achieve advertising management system, standardization and automation. Based on ehydra framework, the use of an open source, Java-based extensible platform for the development of the eclipse tools, Database using SQL database as server, which makes up the development of more flexible and efficient; the user login validation link from the database, have good security.The system has issued the contract in accordance with the demand of the task, containing three systems interface (the add screen, edit screen, restore screen is the same screen interface), won search, add , delete, restore, CSV save and return to the six functions, Total, there are five pictures. After using test cases, the request has issued the contract to design, which would have been its reception. The system has been used in television advertising management, the functional can be further expanded, Osaka stations according to their needs, the further development of sound.

Keywords : advertising management; Software outsourcing ; eclipse; SQL