代码:
import java.sql.*;
public class PreparedStatement {
public static void main(String[] args) {
try {
Class.forName("com.mysql.cj.jdbc.Driver");
} catch (ClassNotFoundException e){
e.printStackTrace();
};
String url = "jdbc:mysql://localhost/jdbc?user=root&password=123456&serverTimezone=UTC";
Connection conn = null;
Statement stmt = null;
ResultSet rs = null;
try {
conn = DriverManager.getConnection(url);
stmt = conn.createStatement();
rs = stmt.executeQuery("select id from emp where deptno > 1"); //执行这行代码时报错
while (rs.next()) {
System.out.println(rs.getObject("id"));
}
} catch (SQLException e){
e.printStackTrace();
} finally {
try {
rs.close();
stmt.close();
conn.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
}
报错信息:
java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '?' at line 1
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120)
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)
at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
at com.mysql.cj.jdbc.StatementImpl.executeQuery(StatementImpl.java:1200)
at PreparedStatement.main(PreparedStatement.java:21)
Exception in thread "main" java.lang.NullPointerException
at PreparedStatement.main(PreparedStatement.java:30)
Process finished with exit code 1
求助各位大佬