Java获取数据库连接的五种方式

Java获取数据库连接的原理主要涉及JDBC（Java DataBase Connectivity，Java数据库连接）API的使用，该API提供了一套标准的Java类库，用于访问各种关系型数据库。以下是Java获取数据库连接原理的详细解释，包括主要步骤和关键点：

jdbc简介

• 定义：JDBC是Java编程语言中用来连接数据库的一种API，它为开发者提供了一种标准的方式来访问数据库。
• 组成：JDBC由一组用Java语言编写的类和接口组成，这些类和接口位于java.sql包中。

import com.mysql.jdbc.Driver;

import java.io.FileInputStream;
import java.io.FileNotFoundException;
import java.io.IOException;
import java.sql.DriverManager;
import java.sql.Statement;
import java.sql.Connection;
import java.sql.SQLException;
import java.util.Properties;

public class jdbc01 {
    public static void main(String[] args) throws SQLException, ClassNotFoundException, InstantiationException, IllegalAccessException, IOException {
        /*
        方法一：
        Driver driver = new Driver();
        String url = "jdbc:mysql://localhost:3306/cities";
        Properties properties = new Properties();
        properties.setProperty("user", "root");
        properties.setProperty("password", "314159");
        Connection connect = driver.connect(url, properties);
         */


        /*
        方法二：
        Class<?> aClass = Class.forName("com.mysql.jdbc.Driver");
        Driver driver=(Driver)aClass.newInstance();
        String url = "jdbc:mysql://localhost:3306/cities";
        Properties properties = new Properties();
        properties.setProperty("user", "root");
        properties.setProperty("password", "314159");
        Connection connect = driver.connect(url, properties);
        */


        /*
        方法三：
        Class<?> aClass = Class.forName("com.mysql.jdbc.Driver");
        Driver driver=(Driver)aClass.newInstance();
        String url = "jdbc:mysql://localhost:3306/cities";
        String user = "root";
        String password = "314159";
        DriverManager.registerDriver(driver);
        Connection connect = DriverManager.getConnection(url, user, password);
        */

        /*
        方法四：（推荐）
        Class.forName("com.mysql.jdbc.Driver");
        String url = "jdbc:mysql://localhost:3306/cities";
        String user = "root";
        String password = "314159";
        Connection connect = DriverManager.getConnection(url, user, password);
        */


        /*
        相关配置文件
        user=root
        password=314159
        url=jdbc:mysql://localhost:3306/cities
        driver=com.mysql.jdbc.Driver
         */
        /*
        方法五：
        Properties properties=new Properties();
        properties.load(new FileInputStream("src\\mysql.properties"));
        String user =properties.getProperty("user");
        String password = properties.getProperty("password");
        String url = properties.getProperty("url");
        String driver = properties.getProperty("driver");
        Class.forName(driver);
        Connection connect = DriverManager.getConnection(url, user, password);
        */


        /*
        String sql = "insert into students ( id,name,Englishname,grade,sex,age,address) values (36,'Tom','Tom','10','male',18,'China');";
        Statement statement = connect.createStatement();
        int count = statement.executeUpdate(sql);
        if (count > 0) {
            System.out.println("Insert success!");
        } else {
            System.out.println("Insert failed!");
        }
        statement.close();
        connect.close();
        */




    }
}