usergroupsql.java

来自「信息发布 发布系统 动态的菜单 和 信息统计」· Java 代码 · 共 29 行

package com.xuntian.material.sql.user;

import com.xuntian.material.sql.BaseSQL;

public class UserGroupSQL extends BaseSQL {
    public static String TABLE = "mat_user_group";

    public static String COLUMN_USER_ID = "user_id";// INT NOT NULL,

    public static String COLUMN_GROUP_ID = "group_id";// INT NOT NULL,

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

    public static String QUERY_USER_GROUP_LIST = getQuerySQL(COLUMNS, TABLE);

    public static String QUERY_USERGROUP_LIST_WITH_USER_ID = getQuerySQL(
            COLUMNS, TABLE, new String[] { COLUMN_USER_ID });

    public static String QUERY_USERGROUP_LIST_WITH_GROUP_ID = getQuerySQL(
            COLUMNS, TABLE, new String[] { COLUMN_GROUP_ID });

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

    public static String getDeleteUserGroup(String userID) {
        return getDeleteSQL(TABLE, COLUMN_USER_ID, new String[] { userID });
    }
}