query2

wangbing6557

于 2009-11-04 10:40:00 发布

阅读量486

点赞数

CC 4.0 BY-SA版权

文章标签： query

本文链接：https://blog.youkuaiyun.com/wangbing6557/article/details/4766257

TableColumn categorytype= new TableColumn(aliases[1],"categorytype");
            TableColumn categoryvalue= new TableColumn(aliases[1],"categoryvalue");
            qs.appendSelect(categoryvalue, false);

            qs.appendWhere(new SearchCondition(categorytype,SearchCondition.EQUAL,ConstantExpression.newExpression("1")),new int[]{resourceCateIndex});

            qs.appendAnd();
            qs.appendWhere(new SearchCondition(sub_categorytype,SearchCondition.EQUAL,ConstantExpression.newExpression("1~2")),new int[]{sub_resourceCateIndex});

            /*SearchCondition sc2 = new SearchCondition(new KeywordExpression("A2.ida3a5"),SearchCondition.EQUAL,new KeywordExpression("A0.ida2a2"));
            qs.appendSearchCondition(sc2);
            qs.appendAnd();
            SearchCondition sc3 = new SearchCondition(new KeywordExpression("A2.ida3b5"),SearchCondition.EQUAL,new KeywordExpression("A1.ida2a2"));
            qs.appendSearchCondition(sc3);
            qs.appendAnd();*/