shell脚本获取mysql的返回值_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