一、 关于论题
传统的二手交易市场主要存在的问题有：
交易过程困难。传统的二手交易市场需要提供交易场所进行交易，需要通过跳蚤市场或是贴广告作为交易的中介，时间和地点的不稳定性提高了交易的困难度，想要成功进行交易变的非常困难。
信息流动滞后。对于买方想要获得二手交易市场的商品信息必须跑去跳蚤市场或是寻找公告板上张贴的广告。而对于卖方想要使自己想卖的物品信息传播出去要么破费去张贴广告，要么就是节假日去跳蚤市场摆摊。信息传播具有较大的滞后性。
网络利用率低。随着现在电子信息化的开展，网络的建设已经进入一个更加高速发展的时期，传统的二手交易市场没有充分利用这些现有的网络设备资源。
随着计算机技术的飞速发展，网络应用的普及，利用网络构建二手交易平台系统势在必行。本系统结合对二手交易市场的需求分析，采用Asp.Net结合SQL server的技术架构交易平台
二、 对论题的初步认识
从分析二手市场的起源以及二手市场的含义，结出二手交易平台在当今经济发展中与人民生活中的重要作用，既而提出设计二手交易系统的目的与意义。
因设计二手交易系统平台，主要运用的是Asp.Net结合SQL server的技术架构交易平台，所以运用的书籍与资料的方向为Asp.Net和SQL server相关书籍以及关于市场及二手市场的相关资料以及各大交易型网站的建设、功能、外观等。
本方案有两大模块:是用户信息，商品信息
用户信息包括用户基本信息和用户交互信息。其中用户基本信息是对用户的资料进行填写，内容包括用户名，密码，手机号码，性别，证件号码，电子邮箱等。用户交互信息有3个版块：1.常见问题；2.完全攻略；3.实战经验谈。
商品信息包括信息发布、热点信息、信息查看和信息留言4个部分。信息发布按类别分类，其中含有：房屋租赁，电脑网络，交通工具，家用电器，赏玩收藏，礼品，儿童用品，家居用品，宠物等。信息查看有2种，站内搜索和用户自发布查询。站内搜索可以按标题按内容按分类进行搜索。
三、研究和撰写计划：毕业设计进度表
1、 2007年9月24日，04正式开始毕业设计。
2、 2007年10月13日前，确定最终论文题目，将毕业论文开题报告电子文档交于指导教师处
3、 2007年10月26日前，将毕业论文需求分析电子文档交于指导教师处。
4、 2007年11月15日前，将毕业论文的数据库及程序的框架（窗体）设计完成。将程序交于指导教师处。
5、 2008年1月10日前，完善毕业设计各模块具体的功能，将最终数据库文件和程序交于指导教师处。
目 录
第1章 选题背景 1
1.1 二手交易系统平台开发的起源、涵义、目的 1
1.1.1二手市场起源 1
1.1.2二手市场的涵义 1
1.1.3二手交易系统平台开发的目的 2
1.2二手交易系统平台的用途 2
1.3二手交易系统平台的开发背景 3
1.4开发设计的思想 3
1.5解决此项目的思路 3
第2章 需求分析 4
2.1系统分析 4
2.2功能需求 4
2.2.1用户信息 4
2.2.2信息发布 5
2.3可行性分析的二个方面 5
2.3.1技术可行性 5
2.3.2操作可行性 13
2.4 数据流程图与数据字典 13
2.5 编程环境 13
2.5.1硬件需求 13
2.5.2软件需求 14
2.6系统的性能要求 14
第3章 总体设计 15
3.1总体功能 15
3.1.1二手交易系统平台 16
3.1.2用户信息 16
3.1.3用户基本信息 17
3.1.4用户交互信息 18
3.1.5商品信息 18
3.1.6信息发布 19
3.1.7热点信息 20
3.1.8信息留言 20
3.1.9信息查看 20
3.1.10站内搜索 21
3.1.11用户自查询 21
3.2部分数据与实体的关系 22
3.2.1用户基本信息关系 22
3.2.2常见问题关系 22
3.2.3留言管理关系 23
3.2.4商品类型关系 23
3.3数据库详细数据表 24
3.3.1 管理员信息 24
3.3.2 房屋信息 24
3.3.3 常见问题 25
3.3.4 完全攻略 25
3.3.5 实战经验 25
3.3.6 图片类型 25
3.3.7 商品信息 26
3.3.8 商品类型 26
3.3.9 房屋类型 27
3.3.10 发布时间 27
3.3.11 留言管理 27
3.3.12 类型留言 28
3.3.13 类型信息 28
3.3.14 用户信息 28
第4章 详细设计 29
4.1界面设计 29
4.1.1 主界面设计 29
4.1.2 用户登陆界面设计 30
4.1.3 注册界面设计 31
4.1.4 商品信息发布界面设计 33
4.1.5 房屋信息发布界面设计 34
4.1.6 热点信息界面设计 36
4.1.7 站内搜索界面设计 36
4.1.8 用户交互界面设计 38
4.2软件测试 39
第5章 编码实现 41
5.1信息搜索代码 41
5.2信息发布代码 42
5.3常见问题代码 45
第6章 软件部署 46
6.1网络部署 46
6.2部署方案 46
6.2.1边缘防火墙的部署 46
6.2.2主干网络防火墙的部署 47
总 结 48
参考文献 49
致 谢 50
二、功能需求描述
2.1总体功能
二手交易系统平台中主要包含二个模块，用户信息和信息发布，用户信息模块中包含基本信息和交互信息，基本信息是指用户的基本个人信息，如用户名，手机号码，性别，证件号码等。交互信息中包括常见问题，完全攻略和实战经验谈。信息发布中包含热点信息，信息查询，信息留言和商品类别。信息查询分为自发布查询和站内搜索两种形式，自发布查询可以按类别和按日期查询，站内搜索可以按标题，内容和类别查询。商品类别中包括房屋租赁，电脑网络，交通工具，家用电器等等。如图2-1所示。
1, on the topic
The traditional second-hand market The main problems are:
Difficult trading process. The traditional secondary market transactions need to provide a market place, the flea market or through advertisements posted as a trading intermediary, time and location of the instability of the difficulties of raising transaction and want to become a successful transaction is very difficult.
The flow of information lag. For the buyer want to get second-hand goods market information must go the flea market or find bulletin board posting ads. As for the seller wants to sell the items they want out of information dissemination or costly to put up ads, or go to the flea market stall is a holiday. Dissemination of information have greater lag.
Low network utilization. As is now the conduct of electronic information technology, network construction has entered a period of more rapid growth, the traditional second-hand market does not make full use of existing network equipment resources.
With the rapid development of computer technology, the popularity of network applications, using the Internet to build the secondary trading platform system is necessary. This system combined with the secondary trading market demand analysis, using Asp.Net with SQL server trading platform technology architecture
Second, a preliminary understanding on the topic
From the analysis of the origins of the secondary market, as well as the meaning of the secondary market, secondary trading platform to bear in today''s economic development and people''s lives in the important role of Jier secondary trading system proposed by the design purpose and meaning.
Secondary trading platform for the design, the main use is to Asp.Net with SQL server''s technical architecture trading platform, so the use of books and information on the direction of Asp.Net and SQL server books and on the market and the secondary market, as well as relevant information the construction of major transactional web site, function, appearance and so on.
The program has two main modules: a user information, commodity information
Basic user information including user information and user interaction information. Basic information which the user is to fill in the user''s information, content, including user names, passwords, phone numbers, gender, identification numbers, e-mail and so on. User interaction information with 3 Forum: 1. Frequently asked questions; 2. 完全 攻略; 3. Real-world experience to talk about.
Product information, including information release, hot information, information view, and information message 4 parts. Information dissemination by category classification, which contains: Housing leasing, computer network, transport, household appliances, Mid-Autumn collection, gifts, children''s items, household items, pets and so on. See there are two kinds of information, station search and user-issued query. Search by title by content you can search by category.
Third, research and writing program: Graduation schedule
1, September 24, 2007, 04 officially began graduate design.
2, October 13, 2007, determination of the final thesis topic, thesis opening report will be submitted in the electronic document to guide teachers in Office
3, October 26, 2007, the thesis needs analysis to guide teachers in electronic document delivery at the office.
4, November 15, 2007, the thesis of the database and program framework (form) design has been completed. The program to pay teachers on the guidance office.
5, January 10, 2008, improve the graduation design of specific features of each module, will ultimately pay the database files and programs to guide teachers in the office.
Directory
Topics of Chapter 1 Background 1
1.1 Second-hand trading system platform origin, meaning, the purpose of a
1.1.1 The origin of a secondary market
1.1.2 the meaning of a secondary market
1.1.3 Used for the purpose of trading systems platform 2
1.2 Second-hand trading system platform uses two
1.3 Second-hand trading system platform development background 3
1.4 development and design ideas 3
1.5 to resolve the idea of this project 3
Chapter 2 Demand Analysis 4
2.1 Analysis 4
2.2 Functional Requirement 4
2.2.1 User Information 4
2.2.2 Information Release 5
2.3 Feasibility analysis of two aspects of 5
2.3.1 Technical feasibility 5
2.3.2 Operation Feasibility 13
2.4 Data Flow Diagram and Data Dictionary 13
2.5 Programming Environment 13
2.5.1 Hardware Requirements 13
2.5.2 Software Requirements 14
2.6 System performance requirements 14
Chapter 3 Design 15
3.1 Overall Function 15
3.1.1 Secondary trading platform 16
3.1.2 User Information 16
3.1.3 the user basic information 17
3.1.4 User Interaction Information 18
3.1.5 Product Information 18
3.1.6 Information Release 19
3.1.7 Hot Information 20
3.1.8 Information Message 20
3.1.9 Information View 20
3.1.10 Search 21
3.1.11 user queries 21
3.2 part of the data and physical relationship between the 22
3.2.1 the relationship between the user basic information 22
3.2.2 Frequently Asked Questions relations 22
3.2.3 Message Management Relations 23
3.2.4 Types of goods between 23
3.3 database, detailed data tables 24
3.3.1 Administrator Information 24
3.3.2 Housing Information 24
3.3.3 Frequently Asked Questions 25
3.3.4 完全 攻略 25
3.3.5 actual combat experience 25
3.3.6 Image Type 25
3.3.7 Product Information 26
3.3.8 Type 26
3.3.9 Housing Type 27
3.3.10 Release Time 27
3.3.11 Message Manager 27
3.3.12 type of message 28
3.3.13 type information 28
3.3.14 User Information 28
Chapter 4 Detailed Design 29
4.1 Interface Design 29
4.1.1 Main Interface Design 29
4.1.2 User Login Interface Design 30
4.1.3 Registration Interface Design 31
Product information release 4.1.4 Interface Design 33
Housing information release 4.1.5 Interface Design 34
4.1.6 Hot Information Interface Design 36
4.1.7 Search Interface Design 36
4.1.8 User Interface for 38
4.2 Software Testing 39
Chapter 5 Coding 41
5.1 Information Search Code 41
5.2 Information Release Code 42
5.3 Frequently Asked Questions Code 45
Chapter 6 Software Deployment 46
6.1 Network Deployment 46
6.2 Deployment Scenarios 46
6.2.1 Edge Firewall deployment of 46
6.2.2 Backbone Network Firewall deployment 47
Summary 48
References 49
Thanks 50
Second, functional requirements describe the
2.1 Overall Function
Second-hand trading system platform consists mainly of two modules, user information and information dissemination, user information module contains the basic information and interactive information, basic information refers to the user''s basic personal information, such as user names, phone numbers, gender, identification numbers, etc. . Interactive information, including frequently asked questions, 完全 攻略 and practical to talk about. Information release includes hot information, information query, information, messages and merchandise categories. Information query is divided into self-released search queries and stations in two forms, since the release queries can query by category and by date, stations can search by title, content, and type queries. Product types include rental, computer network, transport, household appliances and so on. As shown in Figure 2-1.
