shell编写

#!/bin/bash  －－第一行表示此文件默认使用的解释器 

export JAVA_HOME=/root/jdk
export PATH=$JAVA_HOME/bin:$PATH

ORACLETNS="jdbc:oracle:thin:user_name/password@//192.139.178.77:1521/etlnew"

basedir=$(dirname $0)

ret=$(bash $basedir/oracle.sh "$sql" $ORACLETNS)

if [ $? -ne 0 ]; then －－上次命令结果执行报错则 
 sms_url="""
    http://alarm.qyq.com/alarm?title=DACAlarm&alarmEmail=qyq&alarmSms=qyq&body=db_query_failed
    """
    echo $sms_url
    curl  $sms_url 
    exit 1
fi

echo -e $ret

if [ x"" != x"$ret" ]; then
    echo "send sms to qyq"


    ret=${ret//:/\-}     －－吧：替换 为－
    ret=${ret//\//}     －－吧／替换为空 
    
    echo "+-----------+"
    echo $ret
    ret=$(echo $ret | awk -F ' ' '{print $1"|"$2"|"$3"|"$4"|"$5"|"$6"|"$7"|"$8"|"$9}')
    echo $ret
    echo "+-----------+"


    sms_url="""
    http://alarm.qyq.com/alarm?title=DACAlarm&alarmEmail=qyq&alarmSms=qyq&body=$ret
    """


    echo $sms_url
    curl $sms_url
fi