jdbc连接数据库

/*
jdbc连接数据库，导入mysql-connect-java-5.17-bin.jar包 day17
*/

public class demo1 {

    //jdbc协议:数据库子协议:主机：端口/连接的数据库//
    private String url = "jdbc:mysql://localhost:3306/day15";

    private String user = "root";   //用户名
    private String password = "root";   //密码

    @Test
    public void test1()throws Exception {
        //1.创建驱动程序类对象
        Driver driver = new com.mysql.jdbc.Driver();    //新版本
        //Driver driver = new org.gjt.mm.mysql.Driver();  //旧版本


        Properties props = new Properties();
        props.setProperty("user", user);
        props.setProperty("password", password);

        //2.连接数据库
        Connection conn = driver.connect(url, props);

        System.out.println(conn);
    }

    @Test
    public void test2() throws Exception{
        Driver driver = new com.mysql.jdbc.Driver();
        //1.注册驱动程序(可以注册多个驱动程序)
        DriverManager.registerDriver(driver);

        //2.连接到具体的数据库
        Connection conn = DriverManager.getConnection(url,user,password);
        System.out.println(conn);
    }

    @Test
    public void test3() throws Exception{
        //通过字节码对象的方式加载静态代码块，从而注册驱动程序
        Class.forName("com.mysql.jdbc.Driver");
        Connection conn = DriverManager.getConnection(url,user,password);
        System.out.println(conn);
    }   
}