在不返回任何内容之间使用MySQL?

company_id

数据库截图:

我的代码:

// Create Calendar and Date objects
Calendar calendar = Calendar.getInstance();
java.sql.Date date = new java.sql.Date(calendar.getTime().getTime());

// Get all datapoints from last week from this company's id
query = "SELECT * FROM survey_data WHERE (company_id = ?) AND (date_entered BETWEEN ? + interval ? day AND ? + interval ? day)";
preparedStatement = conn.prepareStatement(query);
preparedStatement.setString(1, companyId);
preparedStatement.setDate(2, date);
preparedStatement.setInt(3, -Calendar.DAY_OF_WEEK - 6);
preparedStatement.setDate(4, date);
preparedStatement.setInt(5, -Calendar.DAY_OF_WEEK);
resultSet = preparedStatement.executeQuery();