apk访问mysql_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 ;

aapt可以在这里下载：http://blog.phpfs.com/archives/2104.html

#!/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