CREATE TABLE `feedbacktbl` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`userId` varchar(45) DEFAULT NULL,
`feedbackTime` varchar(45) DEFAULT NULL,
`content` varchar(1000) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
CREATE TABLE `managertbl` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`username` varchar(45) DEFAULT NULL,
`password` varchar(45) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
CREATE TABLE `menutbl` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`typeID` int(11) DEFAULT NULL,
`name` varchar(50) DEFAULT NULL,
`price` int(11) DEFAULT NULL,
`pic` varchar(100) DEFAULT NULL,
`remark` varchar(200) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `typeID_idx` (`typeID`),
CONSTRAINT `fk_typeID_id` FOREIGN KEY (`typeID`) REFERENCES `menutypetbl` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=36 DEFAULT CHARSET=utf8;
CREATE TABLE `menutypetbl` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(20) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;
CREATE TABLE `orderdetailtbl` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`orderid` int(11) DEFAULT NULL,
`menuid` int(11) DEFAULT NULL,
`num` int(11) DEFAULT NULL,
`remark` varchar(200) DEFAULT NULL,
`Whetherserved` varchar(45) DEFAULT '否',
PRIMARY KEY (`id`),
KEY `fk_orderid_id_idx` (`orderid`),
KEY `fk_menuid_idx` (`menuid`),
CONSTRAINT `fk_menuid` FOREIGN KEY (`menuid`) REFERENCES `menutbl` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
CONSTRAINT `fk_orderid_id` FOREIGN KEY (`orderid`) REFERENCES `ordertbl` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=59 DEFAULT CHARSET=utf8;
CREATE TABLE `ordertbl` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`orderTime` varchar(30) DEFAULT NULL,
`userID` int(11) DEFAULT NULL,
`tableid` int(11) DEFAULT NULL,
`personNum` int(11) DEFAULT NULL,
`isPay` int(11) DEFAULT '0',
`remark` varchar(200) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `fk_tableid_id_idx` (`tableid`)
) ENGINE=InnoDB AUTO_INCREMENT=65 DEFAULT CHARSET=utf8;
CREATE TABLE `tabletbl` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`num` int(11) DEFAULT NULL,
`flag` int(11) DEFAULT '0',
`description` varchar(100) DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `num_UNIQUE` (`num`)
) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8;
CREATE TABLE `usertbl` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`account` varchar(20) DEFAULT NULL,
`password` varchar(20) DEFAULT NULL,
`name` varchar(20) DEFAULT NULL,
`gender` varchar(20) DEFAULT NULL,
`permission` int(11) DEFAULT NULL,
`remark` varchar(200) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=38 DEFAULT CHARSET=utf8;
ALTER TABLE menutbl CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE menutypetbl CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE orderdetailtbl CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE ordertbl CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE tabletbl CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE usertbl CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
select * from test.usertbl;
select * from test.menutbl;
select * from test.menutypetbl;
select * from test.orderdetailtbl;
select * from test.ordertbl;
select * from test.tabletbl;
/*
数据库为了支持中文需要修改字符集：
(1) 最简单的修改方法，就是修改mysql的my.ini文件中的字符集键值，
如 default-character-set = utf8
character_set_server = utf8
修改完后，重启mysql的服务，service mysql restart
使用 mysql> SHOW VARIABLES LIKE 'character%';查看，发现数据库编码均已改成utf8
(2) 对于已经建立的表修改字符集
把表默认的字符集和所有字符列（CHAR,VARCHAR,TEXT）改为新的字符集：
ALTER TABLE tbl_name CONVERT TO CHARACTER SET character_name [COLLATE ...]
如：ALTER TABLE logtest CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
*/
基于Android平台的无线点餐系统（客户端源码+服务端源码+数据库+文档）.zip
版权申诉
5星 · 超过95%的资源 166 浏览量
2022-03-25
16:51:44
上传
评论 11
收藏 9.1MB ZIP 举报 
基于Android平台的无线点餐系统（客户端源码+服务端源码+数据库+文档）.zip （472个子文件） 
resources.ap_ 1.06MB WirelessOrder_Client.apk 1.09MB jarlist.cache 120B MainMenuActivity.class 10KB OrderActivity.class 7KB UpdateActivity.class 7KB AddActivity.class 6KB LoginActivity.class 6KB MenuProvider.class 5KB TableProvider.class 5KB QuerServlet.class 4KB ServedActivity.class 4KB OrderActivity$1.class 4KB OrderActivity$4.class 4KB AddActivity$3.class 4KB PayServlet.class 4KB DisplayCL.class 4KB FeedbackActivity$1.class 4KB PayDaoImpl.class 4KB DisplayUserCL.class 4KB DisplayMenuCL.class 3KB DisplayFeedbackCL.class 3KB DisplayTableCL.class 3KB AddActivity$2.class 3KB MainMenuActivity$ImageAdapter.class 3KB OrderDaoImpl.class 3KB UpdateServlet.class 3KB GetNoServedOrder.class 3KB OrderActivity$3.class 3KB HttpUtil.class 3KB R$id.class 3KB ServedActivity$MyAdapter.class 3KB UpdateDaoImpl.class 3KB UpdateUserCL.class 3KB CheackTableNum.class 3KB CheackUserAccount.class 3KB UpdateMenuCL.class 3KB ChangePasswordActivity$1.class 3KB UpdateTableCL.class 3KB AddUserCL.class 2KB CheckTableActivity$ImageAdapter.class 2KB MainMenuActivity$17.class 2KB CheckTableActivity.class 2KB GetNoServedServlet.class 2KB UserDaoImpl.class 2KB UpdateClientActivity.class 2KB LoginServlet.class 2KB AddMenuCL.class 2KB CheckTableServlet.class 2KB AddTableCL.class 2KB GetOrderDaoImpl.class 2KB UnionTableDaoImpl.class 2KB StartTableServlet.class 2KB OrderDetailServlet.class 2KB UnionTableServlet.class 2KB MainMenuActivity$15.class 2KB FeedbackServlet.class 2KB PayActivity.class 2KB GoServedActivity$1.class 2KB PayMoneyServlet.class 2KB PayActivity$2.class 2KB LoginCL.class 2KB ChangeTableServlet.class 2KB UnionTableServlet2.class 2KB LoginActivity$4.class 2KB QuerActivity.class 2KB ChangePasswordActivity.class 2KB DBUtil.class 2KB QuerActivity$1.class 2KB ChangeTableDaoImpl.class 2KB CheckTableDaoImpl.class 2KB PayActivity$1.class 2KB MainMenuActivity$19.class 2KB OrderList.class 2KB OrderList.class 2KB Order.class 2KB User.class 2KB User.class 2KB DBUtil.class 2KB ServedActivity$1.class 2KB ManagerDaoImpl.class 2KB DBHelper.class 2KB SetActivity.class 2KB ChangepwServlet.class 2KB GoServedActivity.class 2KB DisplayOrderDetail.class 2KB QuerMenuDaoImpl.class 1KB UpdateClientActivity$1.class 1KB MainMenuActivity$21.class 1KB OrderDetail.class 1KB QuerTableDaoImpl.class 1KB FeedbackDaoImpl.class 1KB UpdateServedServlet.class 1KB Menu.class 1KB Menu.class 1KB ChangePasswordDaoImpl.class 1KB QuerMenuDaoImpl.class 1KB MyApplication.class 1KB UpdateServedDaoImpl.class 1KB FeedbackActivity.class 1KB共 472 条
- 1
- 2
- 3
- 4
- 5
- 1
- 2
- 3
前往页