java如何连接MySQL数据库?

其实连接MySQL与SQLserver大同小异,说明一下,MySQL默认端口号是3306,如果你自己改了,记得把代码中的改一下.别忘了用户名和密码也得改成和你自己数据库的一样.
mysql链接数据库jar包下载地址:
链接:https://pan.baidu.com/s/1C6gNlgtureBF2aCJ2xa0qQ
提取码:t26d
其他步骤同上篇文章;
废话不多说,具体代码如下:
注意:要使你的端口号以及数据库名称,用户名和密码与你自己的SQLserver所对应的一样!

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

public class DBManager {
	private Connection con;
	private Statement sta;
	private ResultSet rs;
	private static final String DRIVER= "com.mysql.jdbc.Driver";        
    private static final String URL="jdbc:mysql://localhost:3306/information?useUnicode=true&characterEncoding=utf-8&useSSL=false";
    private static final String USER="root";
    private static final String PASSWORD="meiyou";
    static {
		try {
			Class.forName(DRIVER);
		} catch (ClassNotFoundException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}

	public Connection getConnection(){
        try {
            con =DriverManager.getConnection(URL, USER, PASSWORD);
        } catch (SQLException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
            System.out.println("连接失败");
        }
        return con;
    }

public int update(String sql) {
		int count = 0;
		con = getConnection();
		try {
			sta = con.createStatement();
			count = sta.executeUpdate(sql);
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		} finally {
			this.close();
		}
		return count;
	}
	/**
	 * 获取结果集
	 * 
	 * @param sql
	 * @return
	 */
	public ResultSet query(String sql) {
		con = getConnection();
		try {
			sta = con.createStatement();
			rs = sta.executeQuery(sql);
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return rs;
	}

	/**
	 * 关闭资源
	 */
	public void close() {
		try {
			if (rs != null) {
				rs.close();
				rs = null;
			}
			if (sta != null) {
				sta.close();
				sta = null;
			}
			if (con != null) {
				con.close();
				con = null;
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}
}