使用properties属性存储连接数据库用到的用户名和密码

1 . 在看代码之前,要清楚properties属性是怎么存储数据的,上篇博客中讲的非常详细,不懂properties属性怎么进行存储的建议先看上篇博客<<使用JAVA读写Properties属性文件>>
2 . Connection connection = DriverManager.getConnection(url, properties);
属性可以放url;
可以放url,root,password;
可以放 url,properties.

package com.sky.test;

import static org.hamcrest.CoreMatchers.instanceOf;

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

import org.junit.Test;

public class TestJDBC01 {
    @Test
    public void test01() throws Exception {
        //1.注册驱动
        Class.forName("com.mysql.jdbc.Driver");
        //2.连接数据库

        String url="jdbc:mysql://localhost:3306/1713_day03";
        Properties properties =new Properties();
        properties.put("user", "root");
        properties.put("password", "123");
        Connection connection = DriverManager.getConnection(url, properties);
        //3.获得statement对象
        Statement statement = connection.createStatement();
        //4.定义sql语句
        String sql="insert into user (name,passwod) values('木子','123')";
        //5. 执行
        int  rowCount = statement.executeUpdate(sql);
        if (rowCount>0) {
            System.out.println("����ɹ�");
        }else {
            System.out.println("����ʧ��");
        }
        //6.关闭
        statement.close();
        connection.close();
    }

}

总结:properties：存储个人信息
Properties属性(key/value对存在,至少包含user和password), 一般用作属性配置文件
Properties properties =new Properties();
properties.put(“user”, “root”);
properties.put(“password”, “123”);
DriverManager.getConnection(url,properties);
url地址： jdbc:mysql://localhost:3306/数据库名?useUnicode=true&characterEncoding=utf-8
user：用户名 password:密码 DriverManager.getConnection(url,user,password);