摘要：本课题研究的主要内容是钱币拍卖网站的开发、维护以及后台管理，目的是通过降低拍卖准入门槛和操作难度，让更多的普通民众参与到拍卖过程中，从而方便爱好者对古钱币的交易与收藏。同时，钱币拍卖系统还有许多优点，例如：资源流通速度加快，配置更加合理化。互联网的发展是透明的，实名参与的，所以在过程监管方面，相比传统的拍卖行，会更加的严格。该网站应实现用户在网上进行钱币在线拍卖，委托拍卖，下单，收藏等功能。其开发主要包括后台数据库的建立和后台维护管理程序以及前台拍卖网站程序的开发三个方面。

基于系统的应用需求和使用特点，本课题使用Microsoft公司开发的Internet服务器端脚本环境ASP。并采用c#语言来实现编程。后台使用性能优越的数据库MYSQL，利用其提供的各种编程工具，快速构建应用系统原型，然后，经过反复测试和优化，直至最终系统完成并上线，直到达到令人满意的效果。

关键词：钱币收藏；在线拍卖；数据库；个性化推荐

Analysis and design of ancient coins auction website

Abstract：The main content of this paper is the development of coin auction site, maintenance and management background, the purpose is to facilitate the collection of ancient coins lovers, at the same time, the network auction can make access to lower the threshold, more ordinary people to participate in the auction industry. At the same time, there are other benefits, such as: the circulation speed of resource allocation more reasonable, accelerate the development of the Internet is transparent, full participation, so in the process of supervision, compared with the traditional auction, will be more strict. The site should be achieved online users online auction of coins, commissioned auction, orders, collections and other functions. Its development mainly includes the backstage database establishment and the backstage maintenance management procedure as well as the onstage auction website program development three aspects.

After analysis, we use Microsoft company developed Internet  server-side scripting environment ASP. And the use of c# language  programming. The background using the MYSQL database using the advantages of superior performance, provide a variety of programming, in a short period of time to establish a prototype system, and constantly revised and improved until the initial prototype system, to achieve satisfactory results.

Key words ： Coin collection ； Online auction ； database ； Personalized recommendation

目录

0引言 1

1课题研究 2

1.1研究背景 2

1.2研究目的及意义 2

1.3研究思路及方法 2

2现状及需求分析 4

2.1国内外拍卖现状及发展趋势 4

2.1.1国外现状 4

2.1.2国内现状 4

2.1.3发展趋势 4

2.2古钱币拍卖网站需求分析 5

3系统设计 6

3.1系统流程图 6

3.2功能结构设计 8

3.3开发架构设计 15

3.3.1三层结构原理 16

3.4数据库设计 16

3.4.1数据库设计思路 16