Bash使用

 

#! /bin/bash

CODE_FILELIST_FILE="filelist.txt"
find   -name "*.*htm*" | xargs grep -l -e 'dtl.php?mvid=[0-9]/{1,6/}' > ${CODE_FILELIST_FILE}
while read line_str; do
    if [ -f ${line_str} ]; then
        echo "File:" ${line_str}
 grep -h -o -e 'dtl.php?mvid=[0-9]/{1,6/}' ${line_str}  | awk -F'=' '{print $2}' | sort | uniq > 1.txt
 cat 1.txt | awk  '{printf "select  count(movieid) , max(isaudited), %s,max(movieName)   from mvdetail where movieid = %s ; /n",$1,$1} ' >2.txt
 /home/work/mysql/bin/mysql -uroot -p111111 movie  -N -s <2.txt | awk '{if($1==0 || $2==0) printf "%s/t%s/n ",$3,$4}'
 echo " "
 rm -f 1.txt
 rm -f 2.txt
 rm -f 3.txt
 
    else
        echo "Error!"
    fi
done < ${CODE_FILELIST_FILE}

rm -f  ${CODE_FILELIST_FILE}