使用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);