aapt获取apk信息存储mysql

CREATE TABLE IF NOT EXISTS `apk_info` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT '日志编号',
  `version_code` varchar(200) NOT NULL COMMENT '版本号',
  `package_md5` varchar(100) NOT NULL COMMENT '包文件的md5值',
  `package_name` varchar(100) NOT NULL COMMENT '包名称',
  `version_name` varchar(20) NOT NULL COMMENT '版本名',
  `sdk_version` varchar(20) NOT NULL COMMENT '最小SDK版本',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COMMENT='获取APK信息' AUTO_INCREMENT=8 ;

#!/bin/bash
#####
# 获取APK信息并保存到MYSQL数据库
#####
#mysql配置
HOST='localhost'
PORT=3306
USERNAME='root'
PASSWORD='Joyous'
DB='apk'
#获取APK信息
logname=/home/joyous/joyous/scripts/study/temp.log
/home/joyous/joyous/scripts/study/aapt d badging ${1} >${logname}
if [ -f "$logname" ]; then
    #包名
    NAME=`grep "package" ${logname}|awk -F"'" '{print $2}'`
    isversionCode=`grep "versionCode" ${logname}|awk -F"'" '{print $3}'|grep versionCode |wc -l` 
    if [ "$isversionCode" -eq 1 ];then
        VERSIONCODE=`grep "versionCode" ${logname}|awk -F"'" '{print $4}'`
    fi
    isversionCode=`grep "versionCode" ${logname}|awk -F"'" '{print $5}'|grep versionCode |wc -l` 
    if [ "$isversionCode" -eq 1 ];then
        VERSIONCODE=`grep "versionCode" ${logname}|awk -F"'" '{print $6}'`
    fi
    isversionName=`grep "versionName" ${logname}|awk -F"'" '{print $3}'|grep versionName |wc -l`  
    if [ "$isversionName" -eq 1 ];then
        VERSIONNAME=`grep "versionName" ${logname}|awk -F"'" '{print $4}'`
    fi
    isversionName=`grep "versionName" ${logname}|awk -F"'" '{print $5}'|grep versionName |wc -l`  
    if [ "$isversionName" -eq 1 ];then
        VERSIONNAME=`grep "versionName" ${logname}|awk -F"'" '{print $6}'`
    fi
    SDKVERSION=`grep "sdkVersion" ${logname}|awk -F"'" '{print $2}'`

    PACKMD5=`md5sum $1|cut -d ' ' -f1`
    insert_sql="insert into apk_info (version_code,package_md5, package_name,version_name,sdk_version) VALUES ('${VERSIONCODE}','${PACKMD5}','${NAME}','${VERSIONNAME}','${SDKVERSION}')"
    echo ${insert_sql}
    res=(`/usr/bin/mysql -h ${HOST} -u ${USERNAME} -P ${PORT} -p${PASSWORD} -e "use ${DB};${insert_sql}"`)
fi