使用JDBC连接Mysql的3种方式

public class Test 01{public static void main(String[] args) throws Exception {Class.forName("com.mysql.jdbc.Driver");String url = "jdbc:mysql://localhost:3306/test";Connection conn = DriverManager.getConnection(url, "root", "000000");System.out.println(conn);Statement stat = conn.createStatement();      String create="create table  person(pid integer, name  varchar(20))";      stat.execute(create);      }}

当然还有另外一种连接方式：

public class Test01 {public static void main(String[] args) throws Exception {Driver  driver=new  com.mysql.jdbc.Driver();//与Class.forName("com.mysql.jdbc.Driver")等价String url="jdbc:mysql://localhost:3306/test";Properties info=new Properties();info.setProperty("user", "root");info.setProperty("password", "000000");Connection connection=driver.connect(url, info);System.out.println(connection);}}

当然这种连接方式也是可以的：

public class Test01 {public static void main(String[] args) throws Exception {Driver  driver=new  com.mysql.jdbc.Driver();String url="jdbc:mysql://localhost:3306/test";Properties info=new Properties();info.setProperty("user", "root");info.setProperty("password", "000000");DriverManager.registerDriver(driver);Connection connection=DriverManager.getConnection(url, info);System.out.println(connection);}}