将MySQL驱动放在tomcat的common目录下的lib目录下,
<%@page import="java.sql.ResultSet"%>
<%@page import="java.sql.DriverManager"%>
<!-- 代替下面两个包 -->
<%@page import="java.sql.Connection"%>
<%@page import="java.sql.Statement"%>
<!-- 包导错了,需要用上面的代替,否则出错 -->
<%-- <%@page import="com.mysql.jdbc.Statement"%> --%>
<%-- <%@page import="com.mysql.jdbc.Connection"%> --%>
<%@page import="com.mysql.*" %>
<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<h2>连接MySQL数据库</h2>
</head>
<body>
<%Class.forName("com.mysql.jdbc.Driver").newInstance();//加载驱动
Connection conn = DriverManager.getConnection("jdbc:mysql://localhost/mysql123","root","");
Statement stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery("select * from student");
while(rs.next())
{ %>
<%=rs.getString("username") %>
<%=rs.getString("password") %><br>
<%}
rs.close();
conn.close();
%>
</body>
</html>