环境搭建
eclipse
jdk1.7
tomcat9.0
mysql5.6
naivicat for mysql(NAVH-WK6A-DMVK-DKW3)
jar包(mysql-connector-java-5.1.19-bin)
命令安装Tomcat
service install tomcat
path
%CATALINA_HOME%\bin;
.;C:\Program Files\Java\jdk1.7.0_79\bin;
%JAVA_HOME%\bin;%JAVA_HOME%\jre7\bin;
C:\mysql-5.6.10-winx64\bin;
CATALINA_BASE
C:\apache-tomcat-7.0.72
CATALINA_HOME
C:\apache-tomcat-7.0.72
CLASSPATH
.;%JAVA_HOME%\lib\dt.jar;%JAVA_HOME%\lib\tools.jar;%TOMCAT_HOME%\lib\servlet-api.jar;
JAVA_HOME
C:\Program Files\Java\jdk1.7.0_79
TOMCAT_HOME
C:\apache-tomcat-7.0.72
导入.sql文件命令
创建数据库;
mysql> USE 数据库名;
mysql> SOURCE d:/test.sql;
退出命令
quit;