无法连接上MySql

Question

问题遇到的现象和发生背景

问题相关代码，请勿粘贴截图

C:\Users\86176\.jdks\corretto-1.8.0_322\bin\java.exe "-javaagent:C:\Program Files\JetBrains\IntelliJ IDEA Community Edition 2021.3.1\lib\idea_rt.jar=64962:C:\Program Files\JetBrains\IntelliJ IDEA Community Edition 2021.3.1\bin" -Dfile.encoding=UTF-8 -classpath C:\Users\86176\.jdks\corretto-1.8.0_322\jre\lib\charsets.jar;C:\Users\86176\.jdks\corretto-1.8.0_322\jre\lib\ext\access-bridge-64.jar;C:\Users\86176\.jdks\corretto-1.8.0_322\jre\lib\ext\cldrdata.jar;C:\Users\86176\.jdks\corretto-1.8.0_322\jre\lib\ext\dnsns.jar;C:\Users\86176\.jdks\corretto-1.8.0_322\jre\lib\ext\jaccess.jar;C:\Users\86176\.jdks\corretto-1.8.0_322\jre\lib\ext\jfxrt.jar;C:\Users\86176\.jdks\corretto-1.8.0_322\jre\lib\ext\localedata.jar;C:\Users\86176\.jdks\corretto-1.8.0_322\jre\lib\ext\nashorn.jar;C:\Users\86176\.jdks\corretto-1.8.0_322\jre\lib\ext\sunec.jar;C:\Users\86176\.jdks\corretto-1.8.0_322\jre\lib\ext\sunjce_provider.jar;C:\Users\86176\.jdks\corretto-1.8.0_322\jre\lib\ext\sunmscapi.jar;C:\Users\86176\.jdks\corretto-1.8.0_322\jre\lib\ext\sunpkcs11.jar;C:\Users\86176\.jdks\corretto-1.8.0_322\jre\lib\ext\zipfs.jar;C:\Users\86176\.jdks\corretto-1.8.0_322\jre\lib\jce.jar;C:\Users\86176\.jdks\corretto-1.8.0_322\jre\lib\jfr.jar;C:\Users\86176\.jdks\corretto-1.8.0_322\jre\lib\jfxswt.jar;C:\Users\86176\.jdks\corretto-1.8.0_322\jre\lib\jsse.jar;C:\Users\86176\.jdks\corretto-1.8.0_322\jre\lib\management-agent.jar;C:\Users\86176\.jdks\corretto-1.8.0_322\jre\lib\resources.jar;C:\Users\86176\.jdks\corretto-1.8.0_322\jre\lib\rt.jar;D:\jdbc\out\production\jdbc_Demo;D:\jdbc\mysql-connector-java-8.0.24\mysql-connector-java-8.0.24.jar jdbc_1.jdbcDemo
Loading class `com.mysql.jdbc.Driver'. This is deprecated. The new driver class is `com.mysql.cj.jdbc.Driver'. The driver is automatically registered via the SPI and manual loading of the driver class is generally unnecessary.
Exception in thread "main" java.sql.SQLSyntaxErrorException: Unknown column 'id' in 'where clause'
    at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120)
    at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
    at com.mysql.cj.jdbc.StatementImpl.executeUpdateInternal(StatementImpl.java:1333)
    at com.mysql.cj.jdbc.StatementImpl.executeLargeUpdate(StatementImpl.java:2106)
    at com.mysql.cj.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1243)
    at jdbc_1.jdbcDemo.main(jdbcDemo.java:22)

Process finished with exit code 1

运行结果及报错内容

我的解答思路和尝试过的方法

我想要达到的结果

Answer 1

已经连上了,这个报错提示的是sql语法错误

java.sql.SQLSyntaxErrorException: Unknown column 'id' in 'where clause'

你的表里面没有id这个字段,因此不能在where条件中使用