grouprolesql.java

信息发布 发布系统 动态的菜单 和 信息统计

package com.xuntian.material.sql.user;

import com.xuntian.material.sql.BaseSQL;

public final class GroupRoleSQL extends BaseSQL {
    public static String TABLE = "mat_group_role";

    public static String COLUMN_GROUP_ID = "group_id";

    public static String COLUMN_TYPE = "dict_type";

    public static String COLUMN_RECORD_ID = "record_id";

    public static String[] COLUMNS = new String[] { COLUMN_GROUP_ID,
            COLUMN_TYPE, COLUMN_RECORD_ID };

    public static String QUERY_GROUPROLE_ITEM_WITH_GROUPID = getQuerySQL(
            new String[] { COLUMN_RECORD_ID }, TABLE,
            new String[] { COLUMN_GROUP_ID })
            + getAndCondition(COLUMN_TYPE, "2");

    public static String QUERY_GROUPROLE_MENU_WITH_GROUPID = getQuerySQL(
            new String[] { COLUMN_RECORD_ID }, TABLE,
            new String[] { COLUMN_GROUP_ID })
            + getAndCondition(COLUMN_TYPE, "1");

    public static String INSERT_GROUPROLE = getInsertSQL(TABLE, COLUMNS);

    public static String DELETE_GROUPROLE = getDeleteSQL(TABLE,
            new String[] { COLUMN_GROUP_ID });
}