Problems with connecting java to mysql

When querying a mysql database using Java, the same SQL statement can be queried in Workbench, but the results cannot be found in Java code. For example, the results can be found in. Workbench! The same statement in Java cannot be found. (the Workbench SQL statement is copied and pasted from the Java side )! [Image description] (img. ask. csdn. netupload201... mysqljava

When querying a mysql database using Java, the same SQL statement can be queried in Workbench, but the results cannot be found in Java code. For example:
Results can be found in. Workbench
The same statement in. Java cannot find the result (the Workbench SQL statement is copied and pasted from the Java side)
Finally, the ResultSet object getRow () generated by SQL returns 0.
What is the cause of a previous-generation guidance problem?