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

来源：互联网发布：免费收款收据软件编辑：程序博客网时间：2024/05/17 19:21

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);}}

0 0