脚本一键搭建jspgou

#!/bin/bash
#一键搭建jspgou
systemctl start mysqld
unzip &>/dev/null
if [ $? -eq 0 ];then
        echo "正在解压项目源码包中..."
        unzip jspgouV6-ROOT.zip &>/dev/null
else
        echo "正在下载unzip..."
        yum -y install unzip && unzip jspgouV6-ROOT.zip
fi
echo "解压完成"
read -p "请输入您数据库user" user
read -p "请输入您数据库password" pwd

echo "始创建数据库授权用户中..."
read -p "请输入授权user" u
read -p "请输入需要被管理的database" k
read -p "请输入授权用户的password" p
mysql -u$user -p$pwd -e " create database $u default charset=utf8" &>/dev/null
mysql -u$user -p$pwd -e "grant all on $k.* to $u@'%' identified by '$p'" &>/dev/null
if [ $? -eq 0 ];then
        echo "授权用户创建完成,用户名为$u 密码为$p 管理的库为$k"
else
        echo "失败，请检查源码"
fi
mysql -u$user -p$pwd -e "flush privileges" &>/dev/null

echo "正在修改数据库配置文件中..."

cat << EOF >> /etc/my.cnf

sql_mode=STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
explicit_defaults_for_timestamp=1

EOF

echo "修改配置文件完成"

echo "正在导入数据中..."

systemctl restart mysqld

mysql -u$user -p$pwd $k </root/DB/jspgou.sql &>/dev/null
if [ $? -eq 0 ];then
        echo "导入数据成功"
else
        echo “导入数据失败”
fi

echo "导入数据完成"

rm -rf /usr/local/tomcat/webapps/*
cp -r ROOT /usr/local/tomcat/webapps/
#/usr/local/tomcat/webapps/ROOT/WEB-INF/config/jdbc.properties
sed -i '20c jdbc.url=jdbc:mysql://127.0.0.1:3306/'$k'?characterEncoding=UTF-8' /usr/local/tomcat/webapps/ROOT/WEB-INF/config/jdbc.properties
if [ $? -eq 0 ];then
        echo "替换jdbc文件中数据库接口 success"
else
        echo “false”
fi

sed -i '21c jdbc.username='$u'' /usr/local/tomcat/webapps/ROOT/WEB-INF/config/jdbc.properties
if [ $? -eq 0 ];then
        echo "替换jdbc文件中数据库接口 用户： success"
else
        echo “false”
fi

sed -i '22c jdbc.password='$p'' /usr/local/tomcat/webapps/ROOT/WEB-INF/config/jdbc.properties
if [ $? -eq 0 ];then
        echo "替换jdbc文件中数据库接口 用户： success"
else
        echo “false”
fi

sed -i '123d;130d' /usr/local/tomcat/conf/server.xml 
sed -i 's/\r//g' /usr/local/tomcat/webapps/ROOT/WEB-INF/config/jdbc.properties

bash /usr/local/tomcat/bin/shutdown.sh &>/dev/null
if [ $? -eq 0 ];then
        echo "停止服务中"
else
        echo “检查服务是否已经关闭”
fi

bash /usr/local/tomcat/bin/startup.sh &>/dev/null

if [ $? -eq 0 ];then
        echo "启动服务"
else
        echo “检查服务是否已经启动”
fi