java Why语句不返回结果

Question

我试图从表Type中获取对象，但查询返回空结果集：

public Type get(String id) {
    Type type = null;

    StringBuilder queryBuilder = new StringBuilder();
    queryBuilder.append("SELECT * FROM ");
    queryBuilder.append(TABLE_NAME);
    queryBuilder.append(" WHERE ");
    queryBuilder.append(TYPE + "=?;");
    String query = queryBuilder.toString();

    try {
        PreparedStatement statement = connection.prepareStatement(query);
        statement.setString(1, id);
        ResultSet result = statement.executeQuery();
        if(result.next()){
            type = new Type(id,
                    result.getString(DEFINITION));
        }
    } catch (SQLException e) {
        e.printStackTrace();
    }

    return type;
}

表_名称和类型分别为“类型”和“类型”

如果我在MySQL控制台中使用相同的参数尝试查询，它将返回结果。怎么了