利用case语句查表
cat cktab.sh
8P"Y6A0c9I F%RTechWeb-技术社区echo "###########Table Of Contents##########"tech.techweb.com.cn'l5d:e/D U7x
echo Check Table basetab_pps_his..........1tech.techweb.com.cn)}:V%_.g%r!L7|6k:C
echo Check Table iuser_userrentsrv........2
2E4K-k;`.M%Y#L$w7Iecho Check Table mvpn_phone...............3程序开发,操作系统,服务器,源码下载,Linux,Unix,BSD,PHP,Apach,asp,下载,源码,黑客,安全,技术社区,技术论坛4a9H/g2@;A"D
echo Check Table basetab_mvpn.............48q8Z j*O'^%l
echo Exit Menu............................5
0n:k6P0E'o5Z6n4z"k2L程序开发,操作系统,服务器,源码下载,Linux,Unix,BSD,PHP,Apach,asp,下载,源码,黑客,安全,技术社区,技术论坛echo ""2?1o5g6|$W f#r,\
echo "Please Input Number :\c"
+Z&t2m%w%Z'W3a(A(C ]5i/iread choice1w-m;D U9N$N
case $choice in
*X't8V.`%L8q6f 1) echo "Please input msisdn number :\c"
![%s9D+~5x#b0`&^TechWeb-技术社区 read msisdn
%[.T)D!r*m1X/G0Q+X0hTechWeb-技术社区 echo "select * from basetab_pps_his where msisdn='${msisdn}'"|dbaccess insms20
8w+Q+l ?3l8V2s5g程序开发,操作系统,服务器,源码下载,Linux,Unix,BSD,PHP,Apach,asp,下载,源码,黑客,安全,技术社区,技术论坛 ;;tech.techweb.com.cn:B I*O(e!d9|&n
2) echo "Please input msisdn number :\c"
'Y"d7y e(c7~0tTechWeb-技术社区 read msisdn"Q&X%_)\(G-D c
echo "select * from iuser_userrentsrv where msisdn='${msisdn}'"|dbaccess insms20
2Y:n!k$R4j.u1m程序开发,操作系统,服务器,源码下载,Linux,Unix,BSD,PHP,Apach,asp,下载,源码,黑客,安全,技术社区,技术论坛 ;;
+g#?3t0u y$t.D#a 3) echo "Please input isdnnumber number :\c"TechWeb-技术社区6{ J,j*\,w1y#v
read msisdn*H)O8A"i+p9[%b
echo "select * from mvpn_phone where isdnnumber='${msisdn}'"|dbaccess insms20
,j2Y:[5Z5f.}&z3C+|'d8R ;;程序开发,操作系统,服务器,源码下载,Linux,Unix,BSD,PHP,Apach,asp,下载,源码,黑客,安全,技术社区,技术论坛"C2I-|5J8P)a3j
4) echo "Please input groupnumber :\c"
-L6k/|%u;R#F*L-m+{'D5i'K read msisdn.Q5[#^-G&s Z3p
echo "select * from basetab_mvpn where groupnumber='${msisdn}'"|dbaccess insms20tech.techweb.com.cn2Q(G-M7\,y-c7{#\&M4h
;;
"k6h7P1q'S3}#? m.K#[tech.techweb.com.cn q|Q|5) echo Goodbye;;
#`/\5{"~:r3_%[ W*L0@.m"dTechWeb-技术社区 *) echo illegal Option
)O6W0@ j)i&`8f!lesac
|