userrolesql.java

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

package com.xuntian.material.sql.user;

import com.xuntian.material.sql.BaseSQL;

public final class UserRoleSQL extends BaseSQL {
    public static String TABLE = "mat_user_role";

    public static String VIEW = "view_user_role";

    public static String COLUMN_USER_ID = "user_id";

    public static String COLUMN_TYPE = "dict_type";

    public static String COLUMN_RECORD_ID = "record_id";

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

    public static String VIEW_USERROLE_ITEM_WITH_USER_ID = getQuerySQL(
            new String[] { COLUMN_RECORD_ID }, VIEW,
            new String[] { COLUMN_USER_ID })
            + getAndCondition(COLUMN_TYPE, "2");

    public static String VIEW_USERROLE_MENU_WITH_USER_ID = getQuerySQL(
            new String[] { COLUMN_RECORD_ID }, VIEW,
            new String[] { COLUMN_USER_ID })
            + getAndCondition(COLUMN_TYPE, "1");

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

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

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

    public static String DELETE_USERROLE = getDeleteSQL(TABLE,
            new String[] { COLUMN_USER_ID });
}