shell脚本:读取mysql数据并调用java命令

【核心代码】

#! /bin/bash

HOSTNAME="*******"
PORT=3306
USERNAME="*******"
PASSWORD="*******"
DBNAME="db_datastory_champion"
TABLENAME="OutsideCall"

    select_sql="select * from ${TABLENAME} where status=1"
    sql="SELECT * FROM OutsideCall WHERE STATUS=1"

while [ true ]; do
/bin/sleep 1
	result=`mysql -h${HOSTNAME}  -P${PORT}  -u${USERNAME} -p${PASSWORD} ${DBNAME} -Bse "${select_sql}"`
	if [ ! -n "${result}" ]; then  
		echo "IS NULL"
	else  
		 id=`echo ${result} | awk '{print $1}'` #获取到的第一个值
		 company_id=`echo ${result} | awk '{print $2}'` #获取到的第二个值
		 phone=`echo ${result} | awk '{print $3}'` #获取到的第N个值
		 sip_id=`echo ${result} | awk '{print $4}'` #获取到的第N个值
		 task_id=`echo ${result} | awk '{print $5}'` #获取到的第N个值
		 tmp_id=`echo ${result} | awk '{print $6}'` #获取到的第N个值
		 task_name=`echo ${result} | awk '{print $7}'` #获取到的第N个值
		 calltimes=`echo ${result} | awk '{print $8}'` #获取到的第N个值
		 moblie=`echo ${result} | awk '{print $9}'` #获取到的第N个值
		 status=`echo ${result} | awk '{print $10}'` #获取到的第N个值
		 echo $id
		 echo $company_id
		 echo $phone
		 echo $sip_id
		 echo $task_id
		 echo $tmp_id
		 echo $task_name
		 echo $calltimes
		 echo $moblie
		 echo $status
                 update_sql="update ${TABLENAME} set status=2 where id=$id"
                 mysql -h${HOSTNAME}  -P${PORT}  -u${USERNAME} -p${PASSWORD} ${DBNAME} -e "${update_sql}" 

	java -Xmx180m -Xms8m -cp /home/test1/app4test/app/approot7 com.champion.sip.bridge.BridgeCall -phone $phone  -mobile $moblie -id $id >>/tmp/$id-$phone-$moblie.txt

	fi 

done