设计一个报刊订阅应用系统，使系统满足以下功能和需求：

1）

a一个订户可订多种报刊；一种报刊可被多个用户订阅；订单只能订阅现有报刊目录内容；

b投递时，必须根据订单的情况进行投递，不得超出订单的订阅品种、数量；

2）、系统功能包括：

a订户管理：订户添加、修改、删除；

b 目录管理：目录添加、修改、删除；

c订单管理：完成订户订阅数据的管理（包括添加、修改、删除）；

d 订单查询：按订户或者订单号查询订单详细情况；

e统计查询：按报刊目录统计各类报刊的订阅数量及金额；

f表单生成：根据统计查询结果导出统计信息到文件（.xls）

-Design a newspaper subscr iption application, the system functions and meet the following requirements:

1)

a subscriber may provide a variety of newspapers and periodicals　a newspaper can be multiple user subscr iption　orders can only subscribe to newspapers and catalog existing content　

b delivery must be conducted according to the order of delivery, shall not exceed the order of the subscr iption type, quantity　

2), the system features include:

a subscriber management: subscribers to add, modify, delete　

b directory management: the directory to add, modify, delete　

c Order management: the complete subscriber subscr iption data management (including add, modify, delete)　

d Order: order number by subscriber or check order details　

e Statistics Query: statistics by various newspapers and catalog number of subscr iptions to newspapers and the amount　

f form generation: According to the statistical results to export statistics to a file (. xls)