利用case语句查表
cat cktab.sh
:P3F5~#@4t)}%Stech.techweb.com.cnecho "###########Table Of Contents##########"程序开发，操作系统，服务器，源码下载，Linux,Unix,BSD,PHP,Apach,asp,下载,源码,黑客,安全,技术社区,技术论坛;m1W"V,P(D
echo Check Table basetab_pps_his..........1程序开发，操作系统，服务器，源码下载，Linux,Unix,BSD,PHP,Apach,asp,下载,源码,黑客,安全,技术社区,技术论坛;D O)E*G;^6_
echo Check Table iuser_userrentsrv........2TechWeb-技术社区#o3f#p&O8_5d
echo Check Table mvpn_phone...............3tech.techweb.com.cn1y9n/e-n"s'C:n7d)w-{
echo Check Table basetab_mvpn.............4程序开发，操作系统，服务器，源码下载，Linux,Unix,BSD,PHP,Apach,asp,下载,源码,黑客,安全,技术社区,技术论坛%r7h5{$u;c+^;l0I,{
echo Exit Menu............................5tech.techweb.com.cn"`.L#]"l.L
echo ""#S(X$M$Z.F2w/j
echo "Please Input Number :\c"
2C7H6@4q(r)Sread choice7q2Q(p0h7m;L${
case $choice in程序开发，操作系统，服务器，源码下载，Linux,Unix,BSD,PHP,Apach,asp,下载,源码,黑客,安全,技术社区,技术论坛+]"Y3w;\:R4v%t
1) echo "Please input msisdn number :\c"
#V4b5H;u/M5{'Y8K2r(s9{3| read msisdn b5M'z$i4C0_(Y1N
echo "select * from basetab_pps_his where msisdn='${msisdn}'"|dbaccess insms20
$k/D!X-a!q&? ;;
#]&~(I*a5[#e!A1v 2) echo "Please input msisdn number :\c"
,N9[#f7j+]/T4V0mTechWeb-技术社区 read msisdn
'P3N%v1Z1`+ctech.techweb.com.cn echo "select * from iuser_userrentsrv where msisdn='${msisdn}'"|dbaccess insms20
/u,Z2q8z4M8otech.techweb.com.cn ;;
4f9?!T:Q(k&x9K#f-i8N/~ 3) echo "Please input isdnnumber number :\c"
4H)~1l3i*A(J,P'Y%Vtech.techweb.com.cn read msisdntech.techweb.com.cn,N%b%N8M2i;B;?
echo "select * from mvpn_phone where isdnnumber='${msisdn}'"|dbaccess insms20程序开发，操作系统，服务器，源码下载，Linux,Unix,BSD,PHP,Apach,asp,下载,源码,黑客,安全,技术社区,技术论坛1d/z.C'N;L;S*h
;;
+v6{:I8~-g8I7g8y 4) echo "Please input groupnumber :\c"
2v*\-T0O,u;|:v(m1ktech.techweb.com.cn read msisdn$A&s8u&D"S7D4W:\3f2G
echo "select * from basetab_mvpn where groupnumber='${msisdn}'"|dbaccess insms20tech.techweb.com.cn)t/Q3|7c7g0t,f
;;
`:n;p,A(g.g:A q|Q|5) echo Goodbye;;TechWeb-技术社区/z:X.v!\+e)J:@
*) echo illegal Option8N"f E-J3\.y%o'l;o
esac
|
