java连接MySQL（从驱动下载到测试）

1.从http://www.mysql.com/products/connector/中下载下图所示：

2.测试代码

package com.cym.servlet;

import java.io.IOException;

import java.io.PrintWriter;
import java.sql.DriverManager;

import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import java.sql.*;

public class MyServlet1 extends HttpServlet {

	public void doGet(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {

		response.setContentType("text/html");
		PrintWriter out = response.getWriter();
		out.println("hello " + new java.util.Date().toString());
		try {
			Class.forName("com.mysql.jdbc.Driver");
			out.print("Driver Loader");
			Connection con = DriverManager.getConnection(
					"jdbc:mysql://localhost/users", "root", "");
			out.print("OK");
		} catch (Exception e) {
			e.printStackTrace();
		}

	}

	public void doPost(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {

		this.doGet(request, response);
	}

}