JDBC连接的几种方法

package com.cskaoyan.JDBCDemo;

import org.junit.Assert;
import org.junit.Test;

import java.sql.*;
import java.util.Properties;

public class JDBCDemo {
    public static void main(String[] args) {

    }


    @Test
    public void testGetConnection() throws SQLException {
        //注册驱动
        Driver driver = new com.mysql.jdbc.Driver();
        //建立连接
        String url = "jdbc:mysql://localhost:3306/db1";
        Properties info = new Properties();
        info.setProperty("user","root");
        info.setProperty("password","yang19960421");
        Connection connect = driver.connect(url, info);
        //获取sql语句执行平台
        Statement statement = connect.createStatement();
        String sql = "select id,name,hp_max from heros where id =1004 ";
        ResultSet resultSet = statement.executeQuery(sql);
        while (resultSet.next()){
            int id = resultSet.getInt("id");
            String name = resultSet.getNString("name");
            int hp_max = resultSet.getInt("hp_max");
            System.out.println(id+" "+name+" "+hp_max);
        }
        //关闭连接
        connect.close();
    }


    @Test
    public void conDemo1() throws SQLException {
       Driver driver = new com.mysql.jdbc.Driver();
       DriverManager.registerDriver(driver);
        Connection connection = DriverManager.getConnection("jdbc:mysql://localhost:3306/db1",
                "root", "yang19960421");
        //断言
        Assert.assertNotNull(connection);
    }


    @Test
    public  void conDemo2() throws ClassNotFoundException, IllegalAccessException, InstantiationException, SQLException {
        String diverClass = "com.mysql.jdbc.Driver";
        String url = "jdbc:mysql://localhost:3306/db1";
        String user = "root";
        String pwd = "yang19960421";
        //反射获取驱动类信息
        Class<?> clazz = Class.forName(diverClass);
        //实例化驱动
        Driver driver = (Driver) clazz.newInstance();
        DriverManager.registerDriver(driver);
        Connection connection = DriverManager.getConnection(url, user, pwd);
        Assert.assertNotNull(connection);
    }

    @Test
    public  void conDemo3() throws ClassNotFoundException, IllegalAccessException, InstantiationException, SQLException {
        String diverClass = "com.mysql.jdbc.Driver";
        String url = "jdbc:mysql://localhost:3306/db1";
        String user = "root";
        String pwd = "yang19960421";
        //类加载时自动注册驱动
        Class clzz  =Class.forName(diverClass);
        Connection connection = DriverManager.getConnection(url, user, pwd);
        Assert.assertNotNull(connection);
    }

    @Test
    public void conDemo4() throws SQLException {
        String url = "jdbc:mysql://localhost:3306/db1";
        String user = "root";
        String pwd = "yang19960421";
        Connection connection = DriverManager.getConnection(url, user, pwd);
        Assert.assertNotNull(connection);
    }

}