SQL的小游戏

技术中心的老师布置的，也贴上来分享下，看看大家有没有啥意见，哈哈

场景：

create proc help

as

begin

print

'-----------------------------------------------------

Hello, Welcome to Nani search adventure game!

Your Role player as the adventurer is that of a three year

old.  The Nani is your security blanket.  It is getting

late and you are tired, but you can not go to sleep

without your Nani.

Your mission is to find the Nani.

-----------------------------------------------------

Use simple English sentences to enter commands.

The commands show bellow if you

 Want to help ,you can use help                      (ex. help)

 Want to goto a room ,you can use go2 Room           (ex. go2 office)

 Want to look around ,you can use look               (ex. look)

 Want to look in something ,you can use lookin Thing    (ex. lookin desk)

 Want to take something ,you can use take Thing         (ex. take apple)

 Want to drop something ,you can use release Thing      (ex. release apple)

 Want to eat something ,you can use eat Thing         (ex. eat apple)

 Want to turn on light ,you can use turnon Light         (ex. turnon light)

 Want to turn off light ,you can use turnoff Light       (ex. turnoff light)

 Want to inventory your things , you can use  list       (ex. list)

-----------------------------------------------------

Enjoy your game

'

end

go

 

Nani是玩家的一个玩具，由于玩家年纪比较小（3岁），所以，没有他的玩具陪伴他就没办法入睡，所以，要在房间里找到他的玩具Nani。

 

上图为小朋友冒险的地方，

在书房（Office）里的Desk里，他可以找到手电筒（flashlight）和饼干（crackers）；

餐厅（Dining Room）的Table上，他可以拿到苹果（apple）和一个椰菜（broccoli）；

穿过厨房（Kitchen）可以到达地窖（cellar），检查下洗衣机（Washing machine），就会找到Nani了。

其实，他的Nani 是放在地窖（cellar）里面的，但是地窖没有灯光，他需要打开手电筒才敢进去找东西，找到Nani后，游戏就结束啦。

说明：冒险者身上只能带两件东西哦！

 

咋看起来还真是不知道他其实要做啥诶

 

 

转载于:https://www.cnblogs.com/yifengzhiming/archive/2010/07/07/SQL_game.html