国内宠物行业的快速发展,人们为了能够更加方便地管理宠物交易,宠物交易平台被人们开发出来从而更好地方便管理宠物交易,一个完美的宠物交易平台已经成为各个宠物店的追求目标。
本系统利用SSM技术进行开发宠物交易平台是未来的趋势。该系统使用的编程语言是Java,数据库采用的是MySQL数据库,基本完成了系统设定的目标,建立起了一个较为完整的系统。建立的宠物交易平台用户使用浏览器就可以对其进行访问,管理员在操作上面能够方便管理,因此用户和管理员能够方便对这个系统进行操作。论文全面介绍系统数据库,功能设计和业务流程设计。数据库能够存储宠物交易平台需要的数据。
本系统的功能有管理员:个人中心,用户管理,宠物分类管理,宠物信息管理,留言板管理,系统管理,订单管理。用户:查看宠物信息。购买宠物,查看新闻公告,留言反馈,个人中心,收藏,评论。
关键词:SSM;Java;MySQL
Abstract
With the rapid development of domestic pet industry, in order to manage pet trading more conveniently, pet trading platform has been developed to manage pet trading better. A perfect pet trading platform has become the goal of all pet stores.
This system uses SSM technology to develop pet trading platform is the future trend. The programming language used in the system is Java, and the database is mysql. The goal set by the system has been basically completed, and a relatively complete system has been established. The user of the pet trading platform can access it by using browser. The administrator can manage it easily. Therefore, the user and the administrator can operate the system conveniently. This paper introduces the system database, function design and business process design. The database can store the data needed by the pet trading platform.
The functions of the system include: personal center, user management, pet classification management, pet information management, message board management, system management, order management. User: View pet information. Buy pets, view news bulletins, message feedback, personal center, collections, review
据库表设计
数据库的表信息属于设计的一部分,下面介绍数据库中的各个表的详细信息。
表4-1 allusers表
列名 | 数据类型 | 长度 | 约束 |
id | int | 11 | NOT NULL |
username | varchar | 50 | default NULL |
pwd | varchar | 50 | default NULL |
cx | varchar | 50 | default NULL |
表4-2 chongwuxinxi表
列名 | 数据类型 | 长度 | 约束 |
id | int | 11 | NOT NULL |
addtime | varchar | 50 | default NULL |
chongwuming | varchar | 50 | default NULL |
chongwuzhonglei | varchar | 50 | default NULL |
chongwuxingbie | varchar | 50 | default NULL |
tupian | varchar | 50 | default NULL |
nianling | varchar | 50 | default NULL |
xingqing | varchar | 50 | default NULL |
aihao | varchar | 50 | default NULL |
daguoyimiao | varchar | 50 | default NULL |
表4-3:chongwuyongpin表
列名 | 数据类型 | 长度 | 约束 |
id | int | 11 | NOT NULL |
addtime | varchar | 50 | default NULL |
shangpinbianhao | varchar | 50 | default NULL |
shangpinmingcheng | varchar | 50 | default NULL |
tupian | varchar | 50 | default NULL |
shangpinfenlei | varchar | 50 | default NULL |
pinpai | varchar | 50 | default NULL |
shangpinxiangqing | varchar | 50 | default NULL |
表4-4:yonghu表
列名 | 数据类型 | 长度 | 约束 |
id | int | 11 | NOT NULL |
addtime | varchar | 50 | default NULL |
yonghuzhanghao | varchar | 50 | default NULL |
mima | varchar | 50 | default NULL |
yonghuxingming | varchar | 50 | default NULL |
xingbie | varchar | 50 | default NULL |
nianling | varchar | 50 | default NULL |
touxiang | varchar | 50 | default NULL |
表4-5:shangpinfenlei表
列名 | 数据类型 | 长度 | 约束 |
id | int | 11 | NOT NULL |
addtime | varchar | 50 | default NULL |
shangpinfenlei | varchar | 50 | default NULL |