mysql jdbc怎么用jdbc连接mysql数据库

怎么用jdbc连接mysql数据库

首先导入驱动jar包，程序是 package test; import java.sql.Connection; import java.sql.DriverManager; import java.sql.SQLException; public class connectionMySql { private static Connection connection; static{ String driver=&.mysql.jdbc.Driver"; String url="jdbc:mysql://localhost:3306/purview"; try { Class.forName(driver); } catch (ClassNotFoundException e) { // TODO Auto-generated catch block System.out.print("加载驱动失败"); e.printStackTrace(); } try { connection=DriverManager.getConnection(url, "root", "root"); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } } public static Connection getConnection() { return connection; } public static void main(String [] args) { Connection con=connectionMySql.getConnection(); if(!con.equals("")){ System.out.print("数据库连接成功，连接id是:"+con); } } }