在 Android 版 ORMLite 中加入类会引发 SQL 异常：找不到外部类，反之亦然

我正在尝试使用 QueryBuilder 为两个不同的类创建一个联接查询，一个Product类和一个Coupon类，引用 Product 属性，storeId.

public class Coupon {

    @DatabaseField(columnName = TableColumns.PRODUCT, foreign = true, foreignColumnName = Product.TableColumns.STOREID)
    private Product product;
}


public class Product {

    @DatabaseField(columnName = TableColumns.ID, generatedId = true)
    private Integer id;

    @DatabaseField(columnName = TableColumns.STOREID, index = true, unique = true)
    private Integer storeId;
}

我需要根据产品获取优惠券列表storeId.

public static List<Coupon> getByProduct(Product product) throws SQLException {
    QueryBuilder<Coupon, String> couponBuilder = dao.queryBuilder();
    QueryBuilder<Product, Integer> productBuilder = Product.dao.queryBuilder();     
    productBuilder.where().eq(Product.TableColumns.STOREID, product.getStoreId());
    return couponBuilder.join(productBuilder).query();
}

此查询抛出 SQL 异常：

04-22 11:26:08.058: W/System.err(19479): java.sql.SQLException: Could not find a foreign class com.cde.express.mccopa.model.Coupon field in class com.cde.express.mccopa.model.Product or vice versa

04-22 11:26:08.059: W/System.err(19479):    at com.j256.ormlite.stmt.QueryBuilder.matchJoinedFields(QueryBuilder.java:554)

04-22 11:26:08.059: W/System.err(19479):    at com.j256.ormlite.stmt.QueryBuilder.addJoinInfo(QueryBuilder.java:525)

04-22 11:26:08.059: W/System.err(19479):    at com.j256.ormlite.stmt.QueryBuilder.join(QueryBuilder.java:316)

例外情况是我的类与外部字段不相关，但优惠券类有一个外部产品属性，并已正确注释。我已经检查了数据库，表中的值是正确的。

我该如何修复它？

查看QueryBuilder.java里面的代码

       for (FieldType fieldType : tableInfo.getFieldTypes()) {
            // if this is a foreign field and its foreign-id field is the same as the other's id
            FieldType foreignIdField = fieldType.getForeignIdField();
            if (fieldType.isForeign() && foreignIdField.equals(joinedQueryBuilder.tableInfo.getIdField())) {
                joinInfo.localField = fieldType;
                joinInfo.remoteField = foreignIdField;
                return;
            }
        }
        // if this other field is a foreign field and its foreign-id field is our id
        for (FieldType fieldType : joinedQueryBuilder.tableInfo.getFieldTypes()) {
            if (fieldType.isForeign() && fieldType.getForeignIdField().equals(idField)) {
                joinInfo.localField = idField;
                joinInfo.remoteField = fieldType;
                return;
            }
        }

上面指出，如果您想使用 QueryBuilder 进行联接，则需要确保在 id 字段上放置联接，因此在我看来，这就像 orm-lite 中 QueryBuilder.java 的限制。如果您设置了外键作为 Coupon.java 中的 id 它会起作用。

一个快速的解决方法应该是使用原始查询字符串来实现您想要的。

例如 -

final GenericRawResults<Coupon> results = couponDao.queryRaw("SELECT "
                + "product_table.product_id AS id, "
                + "product_table.store_id AS storeId "
                + " FROM coupon_table "
                + "JOIN product_table ON coupon_table.store_id = product_table.store_id "
                + "WHERE product_table.store_id = 1", new RawRowMapper<Coupon>() {

                    @Override
                    public Coupon mapRow(String[] columnNames, String[] resultColumns) throws SQLException {
                        final Integer productId = Integer.parseInt(resultColumns[0]);
                        final Integer storeId = Integer.parseInt(resultColumns[1]);

                        final Product product = new Product();
                        product.setId(productId);
                        product.setStoreId(storeId);

                        final Coupon coupon = new Coupon();
                        coupon.setProduct(product);
                        return coupon;
                    }

                });

            final Coupon coupon = results.getResults().get(0);
            final Product product = coupon.getProduct();
            System.out.println("Product id is " + product.getId() + " , Store id is " + product.getStoreId());