微信小程序大学校园二手教材与书籍拍卖系统设计与实现

摘 要
随着应用技术的发展以及电子商务平台的崛起，利用线上平台实现的二手交易为传统的二手交易市场注入了新的生机，大学校园内的新生和应届毕业生的相互交替产生了巨大的二手交易空间，同时考虑到环保和资源再利用，大学校园的书籍二手交易需求量不断增加，结合网购的便捷性很多大学生利用网购交易平台实现在线的学习用品及生活用品的购买，帮助节约生活开支的同时也让闲置的物品得到了二次利用。目前人们所熟知的二手交易平台如转转、闲鱼等，作为综合型二手交易平台涵盖了大量的商品，但是无法满足很多大学生对于专业书籍的选择以及学习资料的获取，很多大学生还在通过他人介绍来实现二手书籍的交易，结合而当前大学生二手交易的现状，利用微信小程序应用的便捷性开发设计一款针对大学校园环境内的二手教材及书籍拍卖系统，利用该系统实现在线的书籍教材拍卖，通过竞拍和加价的方式来实现书籍的交易，满足学生书籍需求的同时也实现了资源的再利用。
此次大学校园二手教材与书籍拍卖系统平台的开发设计主要借助微信小程序端来实现，微信小程序依托微信应用平台来实现使用，因此用户不需要额外安装应用且能够实现随时随地的应用和分享，主要的功能模块包括了书籍信息查询、竞拍信息管理以及书籍在线拍卖等内容，结合用户端的需求对于书籍信息的管理按照类别进行划分，同时考虑竞拍的公平公正性需要设定对应的竞拍结束时间、竞拍实时价格，对于竞拍入围的用户开通对应的在线支付窗口，通过以上功能模块的运行来实现二手教材及书籍拍卖系统平台的运行。

关键词：微信小程序；Java语言；Mysql数据库；二手书籍交易平台

The Design and Implementation of University Campus Second hand Textbook and Book Auction System Based on WeChat Applet
Abstract
With the development of application technology and the rise of e-commerce platforms, the second-hand trading realized by online platforms has injected new vitality into the traditional second-hand trading market. The alternation between freshmen and fresh graduates on campus has created a huge second-hand trading space. At the same time, considering environmental protection and resource reuse, the demand for second-hand trading of books on campus is increasing, Combined with the convenience of online shopping, many college students use the online shopping trading platform to purchase online learning supplies and daily necessities, helping to save living expenses and making secondary use of idle goods. At present, people are familiar with second-hand trading platforms such as Zhuanzhuan and Xianyu. As a comprehensive second-hand trading platform, it covers a large number of goods, but it can not meet the needs of many college students to choose professional books and obtain learning materials. Many college students are still trading second-hand books through other people’s introductions. Combined with the current situation of second-hand trading among college students, Utilize the convenience of WeChat applet application to develop and design a second-hand textbook and book auction system for the university campus environment. Use this system to realize online book and textbook auction, and achieve book transactions through auction and price increase, to meet the needs of students’ books and also realize the reuse of resources.
WeChat applets rely on the WeChat application platform to achieve use. Therefore, users do not need to install additional applications and can realize the application and sharing anytime and anywhere. The main functional modules include book information query, auction information management and online book auction, The management of book information is divided according to categories according to the needs of users, and the fairness and fairness of bidding needs to be considered. The corresponding auction end time and real-time auction price should be set. The online payment window should be opened for the users who are shortlisted in the auction, and the operation of the second-hand textbooks and book auction system platform can be realized through the operation of the above function modules.

Keywords: WeChat applet; Java language; MySQL database; Second hand book trading platform;
目 录
摘 要 2
Abstract 3
第一章 绪论 1
1.1研究背景 1
1.2国内外发展现状 1
1.3研究的意义 2
1.4开发工具及技术 2
1.4.1 微信小程序开发工具 2
1.4.2 Mysql数据库 2
1.4.3 JAVA语言 3
第二章 需求分析 4
2.1可行性分析 4
2.1.1技术的可行性 4
2.1.2经济的可行性 4
2.1.3操作可行性 4
2.2需求调研 4
第三章 数据库设计 6
3.1数据库的分析与设计 6
3.1.1数据库的概念结构设计 6
3.1.2数据表的逻辑结构设计 7
第四章 系统功能实现 8
4.1 系统后台界面 8
4.2书籍类别管理 8
4.3 书籍信息界面 9
4.4竞拍管理界面 9
4.5 微信小程序首页 9
4.6书籍信息添加 10
4.7书籍竞拍界面 11
4.8用户后台界面 11
第五章 系统测试 12
5.1 系统测试的意义 12
5.2 系统测试的内容 12
5.3系统测试结果 12
总结 13
致 谢 14
参考文献 15