Java-JDBC-之常用的几种创建Mysql的连接方式

常用的java-jdbc创建Mysql的连接方式

package com.shufang.jdbc1;

import java.io.IOException;
import java.io.InputStream;
import java.sql.Connection;
import java.sql.Driver;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.util.Properties;

public class TestConnection01 {
    public static void main(String[] args) throws SQLException, ClassNotFoundException, IllegalAccessException, InstantiationException, IOException {


        /**
         * 方式一 java.sql.Driver
         */
        Driver driver = new com.mysql.jdbc.Driver();
        //封装账号，密码
        Properties info = new Properties();
        info.put("user", "root");
        info.put("password", "888888");
        //
        String url = "jdbc:mysql://localhost:3306/test";

        Connection connect = driver.connect(url, info);

        System.out.println(connect);
        connect.close();

        /**
         * 方式二，Driver的反射
         */

        Class clazz = Class.forName("com.mysql.jdbc.Driver");
        Driver driver1 = (Driver) clazz.newInstance();
        Connection connect1 = driver1.connect(url, info);
        System.out.println(connect1);
        connect1.close();

        /**
         * 方式三 使用DriverManager
         */

        //Class.forName("com.mysql.jdbc.Driver");
        DriverManager.registerDriver(driver);
        Connection connection = DriverManager.getConnection(url, info);
        System.out.println(connection);
        connection.close();


        /**
         * 方式四：读取配置文件的方式读取配置信息
         */

        InputStream inputStream = TestConnection01.class.getClassLoader().getResourceAsStream("jdbc.properties");
        Properties props = new Properties();
        props.load(inputStream);

        String user = props.getProperty("user");
        String password = props.getProperty("password");
        String url1 = props.getProperty("url");
        String driverClass = props.getProperty("driverClass");


        Class.forName(driverClass);
        Connection connection1 = DriverManager.getConnection(url1, user, password);
        System.out.println(connection1);
        connection1.close();

    }
}