有效沟通问答-【官方】百战程序员_IT在线教育培训机构

报错，

"C:\Program Files\Java\jdk1.8.0_201\bin\java.exe" "-javaagent:D:\program files\JetBrains\IntelliJ IDEA 2019.1\lib\idea_rt.jar=49766:D:\program files\JetBrains\IntelliJ IDEA 2019.1\bin" -Dfile.encoding=UTF-8 -classpath "C:\Program Files\Java\jdk1.8.0_201\jre\lib\charsets.jar;C:\Program Files\Java\jdk1.8.0_201\jre\lib\deploy.jar;C:\Program Files\Java\jdk1.8.0_201\jre\lib\ext\access-bridge-64.jar;C:\Program Files\Java\jdk1.8.0_201\jre\lib\ext\cldrdata.jar;C:\Program Files\Java\jdk1.8.0_201\jre\lib\ext\dnsns.jar;C:\Program Files\Java\jdk1.8.0_201\jre\lib\ext\jaccess.jar;C:\Program Files\Java\jdk1.8.0_201\jre\lib\ext\jfxrt.jar;C:\Program Files\Java\jdk1.8.0_201\jre\lib\ext\localedata.jar;C:\Program Files\Java\jdk1.8.0_201\jre\lib\ext\nashorn.jar;C:\Program Files\Java\jdk1.8.0_201\jre\lib\ext\sunec.jar;C:\Program Files\Java\jdk1.8.0_201\jre\lib\ext\sunjce_provider.jar;C:\Program Files\Java\jdk1.8.0_201\jre\lib\ext\sunmscapi.jar;C:\Program Files\Java\jdk1.8.0_201\jre\lib\ext\sunpkcs11.jar;C:\Program Files\Java\jdk1.8.0_201\jre\lib\ext\zipfs.jar;C:\Program Files\Java\jdk1.8.0_201\jre\lib\javaws.jar;C:\Program Files\Java\jdk1.8.0_201\jre\lib\jce.jar;C:\Program Files\Java\jdk1.8.0_201\jre\lib\jfr.jar;C:\Program Files\Java\jdk1.8.0_201\jre\lib\jfxswt.jar;C:\Program Files\Java\jdk1.8.0_201\jre\lib\jsse.jar;C:\Program Files\Java\jdk1.8.0_201\jre\lib\management-agent.jar;C:\Program Files\Java\jdk1.8.0_201\jre\lib\plugin.jar;C:\Program Files\Java\jdk1.8.0_201\jre\lib\resources.jar;C:\Program Files\Java\jdk1.8.0_201\jre\lib\rt.jar;D:\workspace\jdbcDemo\out\production\jdbcDemo;D:\workspace\jdbcDemo\lib\mysql-connector-java-5.1.47.jar" com.bjsxt.JdbcTest

Sat Nov 02 21:15:19 CST 2019 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.

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

at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:965)

at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3978)

at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3914)

at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:871)

at com.mysql.jdbc.MysqlIO.proceedHandshakeWithPluggableAuthentication(MysqlIO.java:1714)

at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1224)

at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2199)

at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2230)

at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2025)

at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:778)

at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47)

at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)

at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)

at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)

at java.lang.reflect.Constructor.newInstance(Constructor.java:423)

at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)

at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:386)

at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:330)

at java.sql.DriverManager.getConnection(DriverManager.java:664)

at java.sql.DriverManager.getConnection(DriverManager.java:247)

at com.bjsxt.JdbcTest.insertDepartments(JdbcTest.java:17)

at com.bjsxt.JdbcTest.main(JdbcTest.java:44)

Process finished with exit code 0

老师怎么解决？？？

JAVA 全系列/第三阶段：数据库编程/JDBC技术（旧） 1756楼

我发现MySQL也提供了像Oracle的employee那样的示例表，只是需要手动从官网下载并导入。研究了一下，成功导入，这样做MySQL下的查询学习就很方便了。

附上我的笔记链接给需要的同学参考：

Windows下安装MySQL示例数据库

https://www.wolai.com/xavier/2xEqymNj3y7bWBZtfNJyTJ?theme=dark

JAVA 全系列/第三阶段：数据库编程/MySQL数据库的使用 1757楼

老师，如何修改查询结果的列宽和行高呢啊，太小了，我看着难受

JAVA 全系列/第三阶段：数据库编程/SQL 语言 1758楼

老师，麻烦问一下，我在创建这个表名的时候为什么报错呢？

JAVA 全系列/第三阶段：数据库编程/Oracle 数据库的使用 1759楼

为啥步骤一样却执行不起来，很纳闷啊，老师指教一下

JAVA 全系列/第三阶段：数据库编程/Oracle 数据库的使用 1760楼

package com.bjsxt;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.SQLException;

import java.sql.Statement;

public class JdbcTest {

//向departments表中添加一条数据

public void insertDepartments(String department_name,int location_id){

Connection conn = null;

Statement state = null;

try {

//驱动注册

Class.forName("com.mysql.jdbc.Driver");

//创建连接

conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/bjsxt?useUnicode=true&characterEncoding=utf-8","root","123456");

//执行sql

String sql="insert into departments values(default,'"+department_name+"'"+location_id+")";

state = conn.createStatement();

int falg = state.executeUpdate(sql);

System.out.println(falg);

} catch (Exception e) {

e.printStackTrace();

}finally {

if (state !=null){

try {

state.close();

} catch (SQLException e) {

e.printStackTrace();

}

if (conn !=null){

try {

conn.close();

} catch (SQLException e) {

e.printStackTrace();

}

public static void main(String[] args) {

JdbcTest test = new JdbcTest();

test.insertDepartments("研发部",8);

}

报错：