linux apache tomcat mysql jsp_Linux下搭建Tomcat+MySQL+JSP

安装环境为：CentOS-6.5-x86_64-minimal

安装mysql

sudo yum install mysql mysql-server mysql-devel

install_mysql.png

creat_db_tomcat.png

grant_db_tomcat.png

安装jdk和tomcat

创建安装jdk和tomcat的文件夹

mkdir_java_tomcat.png

cp_jdk_tomcat_to_opt.png

add_java_env.png

java_version.png

简单配置tomcat

config_tomcat1.png

config_tomcat2.png

启动tomcat

start_tomcat.png

see_tomcat_index.png

连接数据库

tomcat_copy_mysql_driver.png

[reber@WYB ~]$ vim /opt/tomcat/apache-tomcat-8.0.36/webapps/ROOT/a.jsp

String driver = "com.mysql.jdbc.Driver";

String url = "jdbc:mysql://localhost:3306/tomcat"; //数据库web

String user = "tomcat";

String password = "123456";

try {

Class.forName(driver);

Connection conn = DriverManager.getConnection(url, user, password);

if(!conn.isClosed())

out.println("数据库连接成功！");

conn.close();

}

catch(ClassNotFoundException e) {

out.println("找不到驱动程序");

e.printStackTrace();

}

catch(SQLException e) {

e.printStackTrace();

}

%>

tomcat_conn_mysql.png