JavaWeb连接MySQL

1.新建项目JavaWeb&MySQL

 

 2.MySQL :: Download MySQL Connector/J (Archived Versions)

 

 

 

 将下载的压缩包解压

 

 拖到项目lib文件夹下

 

 

 

 

 

 3.新建mysql.jsp文件

<%@page import="java.sql.DriverManager"%>
<%@page import="java.sql.DriverAction"%>
<%@page import="java.sql.Connection"%>
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
<meta http-equiv="Content-Type" content:"text/html" charset="UTF-8">
<title>MySQL</title>
</head>
<body>
<%
try {
//注册驱动程序
Class.forName("com.mysql.cj.jdbc.Driver"); //显示声明将数据库驱动程序注册到jdbc的驱动管理器中
Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/text?useUnicode=true&characterEncoding=utf8", "root" , "1234"); //连接数据库，路径、用户名、密码
out.print("数据库连接成功！");
conn.close();
} catch (Exception e) {
out.print("数据库连接失败！");
out.print("错误信息：" + e.toString());
}
%>

</body>
</html>

名字保持一致

 

 

 出现链接错误，在MySQL中新建一个text数据库, jdbc:mysql://3306/text

 

数据库连接成功

 新建login.jsp文件

<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>登录</title>
</head>
<body>
<form>
用户名：<input name="userName"/><br>
密码：<input type="password" name="userPassword"><br/>
<input type="submit"/>
</form>
</body>
</html>

 

 

 

posted @ 2022-05-06 15:34  不想看月亮  阅读(131)  评论(0)    收藏  举报