MySQL zip 安装与使用

1.如果没有安装MySQL,可以通过下面的博客进行下载安装

https://blog.csdn.net/mixika99/article/details/105997881
https://blog.csdn.net/alnorthword/article/details/88034499

2.在eclipse里面连接数据库

https://www.cnblogs.com/caiwenjing/p/8079227.html
上面的博客是在java类文件里面连接数据库，其实也可以在jsp里面连接。

package servlet;
import java.sql.*;

import java.io.IOException;
import java.io.PrintWriter;

import javax.servlet.RequestDispatcher;
import javax.servlet.ServletConfig;
import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
public class Test2 extends HttpServlet{
	
	//jsp连接数据库
	private static final long serialVersionUID =1L;
	public void init(ServletConfig config) throws ServletException{
		super.init(config);
	}
	public void service(HttpServletRequest request, HttpServletResponse response)
		throws IOException{
		response.setContentType("text/html;charset=utf-8");
		PrintWriter out = response.getWriter();
		
	    try {
	      Class.forName("com.mysql.jdbc.Driver");     //加载MYSQL JDBC驱动程序   
	     out.println("Success loading Mysql Driver!<br>");
	    }catch (Exception e) {
	      out.println("Error loading Mysql Driver!");
	      e.printStackTrace();
	    }
	    try {
	      Connection connect = DriverManager.getConnection(
	          "jdbc:mysql://localhost:3306/test","root","123456");
	           //连接URL为   jdbc:mysql//服务器地址/数据库名  ，后面的2个参数分别是登陆用户名和密码

	      out.println("Success connect Mysql server!<br>");
	      Statement stmt = connect.createStatement();
	      ResultSet rs = stmt.executeQuery("select * from user");
	                                                              //user 为你表的名称
	      while (rs.next()) {
	        out.println(rs.getString("name"));
	      }
	    }catch (Exception e) {
	      out.println("get data error!<br>");
	      e.printStackTrace();
	    }
	}
}

web.xml文件配置

<?xml version="1.0" encoding="UTF-8"?>
<web-app xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://java.sun.com/xml/ns/javaee" xsi:schemaLocation="http://java.sun.com/xml/ns/javaee http://java.sun.com/xml/ns/javaee/web-app_3_0.xsd" id="WebApp_ID" version="3.0">  
  <servlet>
  	<servlet-name>test2</servlet-name>
  	<servlet-class>servlet.Test2</servlet-class>
  </servlet>
  <servlet-mapping>
  	<servlet-name>test2</servlet-name>
  	<url-pattern>/test2</url-pattern>
  </servlet-mapping>
  
</web-app>

运行结果：