JAVA使用反射机制注册JDBC驱动-----JDBC

旧约Alatus

已于 2023-11-10 15:21:17 修改

阅读量145

点赞数 1

分类专栏： JAVA 文章标签： java 数据库后端 spring maven tomcat mybatis

于 2023-08-07 20:52:39 首次发布

本文链接：https://blog.csdn.net/2201_75960169/article/details/132154434

版权

JAVA 专栏收录该内容

534 篇文章 3 订阅

订阅专栏

import java.sql.*;
import java.util.ResourceBundle;

public class JDBCTest03
{
    //注册驱动的另外一种方式
    public static void main(String[] args)
    {
        Connection connection = null;
        Statement statement = null;
        ResultSet resultSet = null;
        ResourceBundle resourceBundle = ResourceBundle.getBundle("JDBC");
        try
        {
            //注册的第一种方法
//            Constructor constructor = Class.forName(resourceBundle.getString("Driver")).getDeclaredConstructor();
//            Driver driver = (Driver)constructor.newInstance();
//            DriverManager.registerDriver(driver);
            //反射机制注册驱动,利用了Driver实现类自带的静态代码块中的注册操作实现,我们使用加载类对象到内存空间的方式去执行了静态代码块的注册操作
            Class.forName(resourceBundle.getString("Driver"));
            //使用反射机制的原理,Class.forName()方法,类加载的时候会执行静态代码块
            String url = resourceBundle.getString("url");
            String user = resourceBundle.getString("user");
            String password = resourceBundle.getString("password");
            connection = DriverManager.getConnection(url,user,password);
            statement = connection.createStatement();
        }
        catch(Exception e)
        {
            e.printStackTrace();
        }
        finally
        {
            try
            {
                if (statement != null)
                {
                    statement.close();
                }
            }
            catch (SQLException e)
            {
                throw new RuntimeException(e);
            }
            try
            {
                if (connection != null)
                {
                    connection.close();
                }
            }
            catch (SQLException e)
            {
                throw new RuntimeException(e);
            }
        }
    }
}
import java.sql.*;
import java.util.ResourceBundle;

public class JDBCTest03
{
//注册驱动的另外一种方式
public static void main(String[] args)
{
Connection connection = null;
Statement statement = null;
ResultSet resultSet = null;
ResourceBundle resourceBundle = ResourceBundle.getBundle("JDBC");
try
{
//注册的第一种方法
// Constructor constructor = Class.forName(resourceBundle.getString("Driver")).getDeclaredConstructor();
// Driver driver = (Driver)constructor.newInstance();
// DriverManager.registerDriver(driver);
//反射机制注册驱动,利用了Driver实现类自带的静态代码块中的注册操作实现,我们使用加载类对象到内存空间的方式去执行了静态代码块的注册操作
Class.forName(resourceBundle.getString("Driver"));
//使用反射机制的原理,Class.forName()方法,类加载的时候会执行静态代码块
String url = resourceBundle.getString("url");
String user = resourceBundle.getString("user");
String password = resourceBundle.getString("password");
connection = DriverManager.getConnection(url,user,password);
statement = connection.createStatement();
}
catch(Exception e)
{
e.printStackTrace();
}
finally
{
try
{
if (statement != null)
{
statement.close();
}
}
catch (SQLException e)
{
throw new RuntimeException(e);
}
try
{
if (connection != null)
{
connection.close();
}
}
catch (SQLException e)
{
throw new RuntimeException(e);
}
}
}
}

url=jdbc:mysql://127.0.0.1:13306/Mall
user=root
Driver=com.mysql.jdbc.Driver
password=abc123
url=jdbc:mysql://127.0.0.1:13306/Mall
user=root
Driver=com.mysql.jdbc.Driver
password=abc123