事项声明

当前已经安装完成Tomcat（安装路径/opt/tomcat）、MySQL5.5,系统环境为CentOS7-x86_64,ip为10.10.10.111

下载、配置驱动包

https://dev.mysql.com/downloads/connector/j/

然后选择Platform Independent
点 “Download”
转跳到下载页面，右键“No thanks, just start my download.”复制链接地址
目前最新的是这 https://dev.mysql.com/get/Downloads/Connector-J/mysql-connector-java-8.0.13.tar.gz

wget https://dev.mysql.com/get/Downloads/Connector-J/mysql-connector-java-8.0.13.tar.gz
tar -xzvf mysql-connector-java-8.0.13.tar.gz
cd mysql-connector-java-8.0.13
cp -R cp -R mysql-connector-java-8.0.13.jar /opt/tomcat/lib/ #将驱动复制到tomcat的lib文件夹内，改路径可能因安装配置不同而有所差异
sudo systemctl restart tomcat

配置测试用jsp文件

cd /opt/tomcat/webapps/
mkdir test
cd test/
vi test.jsp

以下是test.jsp 的代码部分

<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>
<%@ page import="java.naming.*" %>
<%@ page import="java.sql.*" %>
<html>
<head>
	<title>Tomcat2MySQL</title>
</head>
　　<body data-rsssl=1>
	<h1>
		<%
			try 
			{
				//加载驱动
				Class.forName("com.mysql.jdbc.Driver");
				//建立连接,root为mysql用户名 passw0rd 为root的密码
				Connection con=DriverManager.getConnection("jdbc:mysql://localhost:3306/tomcat2mysql","root","passw0rd");
				//创建状态
				Statement state=con.createStatement();
				//插入数据
				String sql1="insert into user(id,name) values('01','test')";
				state.executeUpdate(sql1);
				String sql2="select * from user";
				ResultSet rs=state.executeQuery(sql2);
				while(rs.next())
				{
					String id=rs.getString("id");
					String name=rs.getString("name");
					out.println("id:"+id+" "+"name:"+name+"<br>");
				}
				out.println("success..."+"<br>");
				state.close();
				con.close();
			} 
			catch (Exception e) 
			{
				e.printStackTrace();
			}
		%>
	</h1>
	</body>
</html>
</html>

修改拥有权

cd /opt/tomcat/
sudo chown -R tomcat webapps/test/
sudo systemctl restart tomcat

创建数据库

[root@localhost ~]# mysql -u root -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 12
Server version: 5.5.62 MySQL Community Server (GPL)

Copyright (c) 2000, 2018, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| performance_schema |
+--------------------+
3 rows in set (0.00 sec)

mysql> create database tomcat2mysql;
Query OK, 1 row affected (0.00 sec)

mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| performance_schema |
| tomcat2mysql       |
+--------------------+
4 rows in set (0.00 sec)

mysql> use tomcat2mysql;
Database changed
mysql> CREATE TABLE user (id VARCHAR(20),name VARCHAR(20));
Query OK, 0 rows affected (0.01 sec)

mysql> exit ;
Bye

测试

浏览器访问测试
http://10.10.10.111:8080/test/test.jsp

数据库信息确认

小明の博客

Tomcat连接MySQL数据库demo测试

事项声明

下载、配置驱动包

配置测试用jsp文件

创建数据库

测试

小明の博客