java数据库链接(jdbc)

通过参数 变量链接数据库

//链接数据库参数  通过properties文件
driverClassName =com.mysql.jdbc.Driver
url=jdbc:mysql://127.0.0.1:3306/day12
username=root
password=root


//封装类
`package com.jdbc;

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

public class JdbcUtill {
    private static String driverClassName;
    private static String url;
    private  static String password;
    private static String username;

    static {
        try {
            InputStream resourceAsStream = JdbcUtill.class.getResourceAsStream("dbconfig.properties");
            Properties properties = new Properties();
            properties.load(resourceAsStream);
             driverClassName = properties.getProperty("driverClassName");
             url = properties.getProperty("url");
             password = properties.getProperty("password");
             username = properties.getProperty("username");

            Class.forName(driverClassName);
        } catch (Exception e) {
            e.printStackTrace();
        }
    }

    //创建链接
    public static Connection getConnection(){
        Connection connection =null;
        try {
            connection = DriverManager.getConnection(url,username,password);
        }
        catch(SQLException e){
            e.printStackTrace();
        }

        return connection;
    }
    //释放增删改
    public static void close(Connection connection , Statement statement ){
        close(connection,statement,null);

    }
    //释放资源 释放查寻
    public static void close(Connection connection , Statement statement , ResultSet resultSet){
        try {
            if (resultSet!=null){
                resultSet.close();
            }
            if (statement!=null){
                statement.close();
            }
            if (connection!=null){
                connection.close();
            }
        }catch (SQLException e){
            e.printStackTrace();
        }
    }
}