ʱ : 基于JSP的外卖点餐系统的设计与实?已修改查?- 再次修改查重(含源文件) - 百度文库ϿʼĶ
ҵƣҵģ
ϵͳǴӾϡϡԼϽзܵóϵͳǿԽпġϵͳһѧĿֻҪø˼ͬʱôѧѧϰJSPMysqlʵ֣ϵͳֻҪͨüڼУϵͳԴɸʵֵģۺ϶Աϵͳʵǿеġ
2.4 л
ϵͳҪлҪʾ 1ϵͳҪWindows XP Windows 7 2ڴҪ2GB 3ӲҪ160GB
4ҪJSP + Mysql + Tomcat
8
ҵƣҵģ
3 վʵ
3.1 վṹ
ϵͳҪΪǰ̨ҳ̨ҳ棬ͨģԱϵͳʵ֣ͼ3-1ʾDZվṹͼ
ͼ3-1վṹ
3.2 ݿṹ
3.2.1ݿE-Rͼ
ͼ3-2ʾDZϵͳE-RͼͨE-Rͼܹڴ϶Աϵͳҵ̽˽⡣
9
N N Ʒ 1 N N ҵƣҵģ 1 N Ӧ N
ͼ3-2 վE-Rͼ
3.2.2ݿṹ
վʹMySqlݿ⣬վҪݱûϢԱϢϢϢƷϢϢϢṹ£
1ԱϢ
Ҫڴ洢ԱϢṹ3-1ʾ
3-1 ԱϢ
ֶ user_id user_name user_pw user_type user_realname user_address user_sex user_tel user_email user_qq user_man user_age user_birthday user_xueli user_del user_one1 user_one2 user_one3 ֶ Int(4) varchar(50) Varchar(50) Int(4) varchar(50) varchar(50) varchar(50) varchar(50) varchar(50) varchar(50) varchar(50) varchar(50) varchar(50) varchar(50) varchar(50) varchar(50) varchar(50) varchar(50) Լ -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- ע ID 2ԱϢ
Ҫڴ洢ԱϢṹ3-2ʾ
3-2 ԱϢ ֶ userId userName ֶ Int(4) varchar(50) 10
Լ -- ע ID ҵƣҵģ
userPw Varchar(50) -- 3Ϣ
Ҫڴ洢Ϣṹ3-3ʾ
3-3 Ϣ
ֶ user_id order_bianhao order_date order_zhuangtai order_jine order_songhuodizhi order_fukuangfangshi order_user_id ֶ Int(4) varchar(50) Varchar(50) Varchar(50) Int(4) varchar(50) varchar(50) Int(4) Լ -- -- -- -- -- -- -- ע ID 4Ϣ
Ҫڴ洢ԵϢṹ3-4ʾ
3-4 Ϣ
ֶ liuyan_id liuyan_title liuyan_content liuyan_date liuyan_user ֶ Int(4) varchar(50) Varchar(5000) Varchar(50) Int(4) Լ -- -- -- -- ע ID 5ƷϢ
Ҫڴ洢ƷϢṹ3-5ʾ
3-5 ƷϢ
ֶ goods_id goods_name goods_miaoshu goods_pic goods_yanse goods_shichangjia goods_tejia goods_isnottejia goods_isnottuijian goods_catelog_id goods_del goods_renqun ֶ Int(4) varchar(50) Varchar(5000) Varchar(50) Varchar(50) Int(4) Int(4) varchar(50) varchar(50) Int(4) varchar(50) varchar(50) Լ -- -- -- -- -- -- -- -- -- -- -- ע ID 6Ϣ
11