相关软件压缩包(都是我从网上下载的,大家可以找得到):
链接:https://pan.baidu.com/s/1Rk1491en2wFtVUbmoRHgPA
提取码:n81r
复制这段内容后打开百度网盘手机App,操作更方便哦
大家下载jar包时一定要注意跟自己的Mysql版本匹配,要不然后续并不能连接成功!!!
测试myeclipse是否成功连接数据库
相关代码如下:
<%@ page language="java" import="java.sql.*" pageEncoding="utf-8"%>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<base href="<%=basePath%>">
<title>My JSP 'index.jsp' starting page</title>
<meta http-equiv="pragma" content="no-cache">
<meta http-equiv="cache-control" content="no-cache">
<meta http-equiv="expires" content="0">
<meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
<meta http-equiv="description" content="This is my page">
<!--
<link rel="stylesheet" type="text/css" href="styles.css">
-->
</head>
<body>
<%
try {
String url ="jdbc:mysql://localhost:3306/school";
String user="root"; //访问数据库的用户名
String password="root"; //访问数据库的密码
DriverManager.getConnection(url,user,password);
out.println("数据库连接成功!");
} catch (SQLException ex) {
out.println("数据库连接失败!");
ex.printStackTrace();
}
try {
Class.forName("com.mysql.jdbc.Driver");
DriverManager.getConnection("jdbc:mysql://localhost:3306/school","root","root");
out.println("数据库连接成功!");
}catch(ClassNotFoundException ex){
out.println("加载数据库驱动时抛出异常!");
ex.printStackTrace();
}catch (SQLException ex) {
out.println("数据库连接失败!");
ex.printStackTrace();
}
%>
</body>
</html>