java检查数据库中的日期是否大于今天
所以我的数据库里有一张带预订的桌子。 在Java中,我只想展示今天及以后的保留
PreparedStatement statement = con.prepareStatement(
"SELECT reservatieID,klanten.voornaam,klanten.achternaam,kamerID,startDatum,eindDatum "
+ "FROM reservatie "
+ "INNER JOIN klanten ON reservatie.klantID = klanten.klantID"
+ "WHERE eindDatum =>?");
String now = basisLogin.getDate();
statement.setString(1, now);
ResultSet resultSet = statement.executeQuery();
这是我的代码。今天日期的字符串格式为:yyyy-MM-dd
这就是我得到的错误:
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have anerror in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'eindDatum >'2017-03-07'' at line 1
java.lang.ArrayIndexOutOfBoundsException: 0 >= 0
我做错了什么
共 (0) 个答案