android电子点餐系统源码

CREATE DATABASE wireless_db; USE wireless_db; CREATE TABLE usertbl( id INT PRIMARY KEY AUTO_INCREMENT, account VARCHAR(25), PASSWORD VARCHAR(25), NAME VARCHAR(25), permission INT, remark VARCHAR(25) ); INSERT INTO usertbl(account,PASSWORD,NAME,permission,remark) VALUES('admin','123','test',1,'test'); CREATE TABLE ordertbl( id INT PRIMARY KEY AUTO_INCREMENT, orderTime VARCHAR(25), userId INT, tableId INT, personNum INT, isPay INT ); CREATE TABLE orderdetailtbl( orderId INT , menuId INT , num INT, remark VARCHAR(25) ); CREATE TABLE tableTbl( id INT PRIMARY KEY, num INT, flag INT ); CREATE TABLE MenuTbl( id INT PRIMARY KEY AUTO_INCREMENT, typeId INT, price INT, NAME VARCHAR(25), pic VARCHAR(25), remark VARCHAR(25) ); CREATE PROCEDURE `new_proc`(IN tableId1 INTEGER(11), IN tableId2 INTEGER(11)) NOT DETERMINISTIC SQL SECURITY DEFINER COMMENT '' BEGIN declare perNum,oId1,oId2 integer; select personNum into perNum from OrderTbl as ot where ot.tableId =tableId2 and ot.isPay = 0; select id into oId1 from OrderTbl as ot where ot.tableId = tableId1 and ot.isPay = 0; select id into oId2 from OrderTbl as ot where ot.tableId = tableId2 and ot.isPay = 0; update OrderTbl set personNum = personNum + perNum where id = oId2; update OrderDetailTbl set orderId = oId2 where orderId = oId1; update TableTbl set flag = 0 where id = tableId1; delete from OrderTbl where id = oId1; END;