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;
基于Android网上点餐系统源码
4星 · 超过85%的资源 需积分: 44 22 浏览量
2011-09-27
17:17:14
上传
评论 2
收藏 2.39MB RAR 举报 
基于Android网上点餐系统源码 （206个子文件） 
resources.ap_ 1.01MB WirelessOrder_Client.apk 1.03MB MainMenuActivity.class 7KB OrderActivity.class 7KB UpdateActivity.class 6KB LoginActivity.class 5KB MenuProvider.class 5KB TableProvider.class 5KB PayServlet.class 4KB OrderActivity$1.class 4KB PayDaoImpl.class 4KB OrderDaoImpl.class 3KB OrderActivity$4.class 3KB HttpUtil.class 3KB OrderActivity$3.class 3KB MainMenuActivity$ImageAdapter.class 3KB CheckTableActivity$ImageAdapter.class 2KB UserDaoImpl.class 2KB LoginServlet.class 2KB CheckTableServlet.class 2KB UpdateServlet.class 2KB CheckTableActivity.class 2KB UnionTableDaoImpl.class 2KB StartTableServlet.class 2KB UpdateDaoImpl.class 2KB UnionTableServlet.class 2KB OrderDetailServlet.class 2KB PayMoneyServlet.class 2KB MainMenuActivity$10.class 2KB R$id.class 2KB MainMenuActivity$8.class 2KB ChangeTableServlet.class 2KB PayActivity.class 2KB UnionTableServlet2.class 2KB CheckTableDaoImpl.class 2KB ChangeTableDaoImpl.class 2KB MainMenuActivity$12.class 2KB LogoutActivity$1.class 2KB Order.class 2KB PayActivity$2.class 2KB User.class 2KB DBUtil.class 2KB LogoutActivity.class 2KB Menu.class 1KB DBHelper.class 1KB PayActivity$1.class 1KB QueryOrderDetail.class 1KB OrderDetail.class 1KB LoginActivity$2.class 1KB EncodingFilter.class 1KB QueryOrder.class 1KB MainMenuActivity$2.class 1KB MainMenuActivity$1.class 1KB MainMenuActivity$4.class 1KB MainMenuActivity$3.class 1KB UpdateActivity$1.class 1000B Menus.class 888B MainMenuActivity$11.class 862B MainMenuActivity$9.class 861B MainMenuActivity$13.class 858B UpdateActivity$2.class 852B LogoutActivity$2.class 844B LoginActivity$3.class 837B Tables.class 794B R$drawable.class 786B LoginActivity$1.class 785B MainMenuActivity$7.class 764B MainMenuActivity$5.class 764B MainMenuActivity$6.class 764B OrderActivity$2.class 746B R$layout.class 727B CheckTable.class 669B CheckTable.class 665B UnionTable.class 663B R.class 503B R$string.class 415B R$attr.class 328B OrderDao.class 290B PayDao.class 239B UnionTableDao.class 197B UserDao.class 191B UpdateDao.class 180B CheckTableDao.class 166B ChangeTableDao.class 154B .classpath 433B .classpath 280B Thumbs.db 41KB Thumbs.db 41KB Thumbs.db 36KB classes.dex 39KB
mysql-connector-java-5.0.3-bin.jar 482KB commons-io-1.4.jar 106KB commons-fileupload-1.2.1.jar 56KB MainMenuActivity.java 11KB OrderActivity.java 10KB UpdateActivity.java 4KB R.java 4KB PayServlet.java 4KB MenuProvider.java 4KB PayDaoImpl.java 4KB共 206 条
- 1
- 2
- 3
- 1
- 2
- 3
- 4
前往页