Demo1
<%@page import="java.sql.DriverManager"%>
<%@page import="java.sql.Connection"%>
<%@page import="java.sql.SQLException"%>
<%@ page language="java" import="java.util.*" pageEncoding="utf-8"%>
<html>
<head>
<title>连接MySQL数据库</title>
</head>
<body>
<%
try {
Class.forName("com.mysql.jdbc.Driver");
out.println("加载驱动类成功");
Connection conn=DriverManager.getConnection("jdbc:mysql://localhost:3306/test?user=root&&password=123456");
out.println("连接MySQL成功");
} catch (ClassNotFoundException e1) {
out.println("找不到驱动类");
}catch(SQLException e2){
out.println("连接MySQL失败");
}
%>
</body>
</html>
Demo2
<%@page import="java.sql.DriverManager"%>
<%@page import="java.sql.Connection"%>
<%@page import="java.sql.SQLException"%>
<%@ page language="java" import="java.util.*" pageEncoding="utf-8"%>
<html>
<head>
<title>连接MySQL数据库</title>
</head>
<body>
<%
String url="jdbc:mysql://localhost:3306/test";
String user="root";
String password="123456";
try {
Class.forName("com.mysql.jdbc.Driver");
out.println("加载驱动类成功");
Connection conn=DriverManager.getConnection(url,user,password);
out.println("连接MySQL成功");
} catch (ClassNotFoundException e1) {
out.println("找不到驱动类");
}catch(SQLException e2){
out.println("连接MySQL失败");
}
%>
</body>
</html>