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,可以在网上查找下载