java----jdbc(利用资源绑定ResourceBundle)

package com.Jdbc;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.Statement;
import java.util.ResourceBundle;

//1.注册驱动
//2.获取数据库连接
//3.获取数据库执行对象
//4.执行sql语句
//5.返回结果集
//6.释放资源
public class test04 {
    public static void main(String[] args) {
        Connection connection = null;
        Statement statement = null;

        //绑定资源对象
        ResourceBundle bundle = ResourceBundle.getBundle("db");
        String driver = bundle.getString("driver");
        String url = bundle.getString("url");
        String username = bundle.getString("username");
        String password = bundle.getString("password");

        try {
            //1.注册驱动
            Class.forName(driver);
            //2.获取数据库连接
            connection = DriverManager.getConnection(url,username,password);
            //3.获取数据库执行对象
            statement = connection.createStatement();
            //4.执行sql语句
            String sql = "update smbms_role set roleCode = 'SMMM' where id = 4 ";
            int i = statement.executeUpdate(sql);
            System.out.println(i>=1?"ok":"false");
            //5.返回结果集

        }catch (Exception e){
            e.printStackTrace();
        }finally {
            //6.释放资源
            try{
                if (statement!=null){
                    statement.close();
                }
            }catch (Exception e){
                e.printStackTrace();
            }

            try{
                if (connection!=null){
                    connection.close();
                }
            }catch (Exception e){
                e.printStackTrace();
            }
        }
    }
}

资源 db.properties

driver=com.mysql.jdbc.Driver
url=jdbc:mysql://localhost:3306/sm?useUnicode=true&useSSL=true
username=root
password=root