java.sql.SQLException Access denied for user ‘Administrator‘@‘localhost‘ (using password YES)

不废话上代码

{
    public static String URL = "";
    public static String CLASS_NAME = "";
    public static String USERNAME = "";
    public static String PASSWORD = "";



    public static void main(String[] args) throws IOException, ClassNotFoundException, SQLException {

        //1、创建Properties对象
        Properties pro=new Properties();


        //2、创建inputstream对象
        InputStream is=new FileInputStream("week5demo/java.properties");

        //3、加载对象并解析
        pro.load(is);


        //获取解析数据
        URL=pro.getProperty("url");
        System.out.println("URL = " + URL);

       CLASS_NAME=pro.getProperty("className");
        System.out.println("CLASS_NAME = " + CLASS_NAME);

       USERNAME=pro.getProperty("user");
        System.out.println("USERNAME = " + USERNAME);

        PASSWORD=pro.getProperty("password");
        System.out.println("PASSWORD = " + PASSWORD);

        DruidDataSource dds=new DruidDataSource();


        //利用德鲁伊创建连接池

        dds.setUrl(URL);
        dds.setDriverClassName(CLASS_NAME);
        dds.setName(USERNAME);
        dds.setPassword(PASSWORD);



        //进行连接
        Connection connection=dds.getConnection();
        System.out.println(connection);


    }
}

java.sql.SQLException Access denied for user 'Administrator'@'localhost' (using password YES)

这句话的意思是访问权限被拒绝了，using password YES的意思不是你的密码对了，而是说你登录需要密码，仅此而已。

出错位置：

  dds.setName(USERNAME);

这里应该是 dds.setUserName(USERNAME);