Java连接MySQL数据库

public class MySQL {
	private static final String url = "jdbc:mysql://localhost:3306/jingwu?useUnicode=true&characterEncoding=utf-8&useSSL=false&serverTimezone=UTC";
	private static final String user = "root";//mysql的用户名
	private static final String password = "zsy0702";//密码
	private static Connection con;
	static Connection getconnect()
	{
		try 
		{
                        //mysql版本5.0以上,需要用下面给出的驱动
			Class.forName("com.mysql.cj.jdbc.Driver");
			con = DriverManager.getConnection(url, user, password);
		} 
		catch (ClassNotFoundException e) 
		{
			e.printStackTrace();
		} 
		catch (SQLException e) 
		{
			e.printStackTrace();
		}
		return con;
	}
}    

  java连接数据库需要用到一个jar包,根据自己的mysql版本下载,我的是mysql-connector-java-8.0.15.jar,可以在网上查找下载

posted @ 2019-08-09 15:27  若离若不弃  阅读(170)  评论(0)    收藏  举报