groupsql.java

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

package com.xuntian.material.sql.user;

import java.util.Map;

import com.xuntian.material.sql.BaseSQL;

public final class GroupSQL extends BaseSQL {
    public static String TABLE = "mat_group";

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

    public static String COLUMN_PARENT_ID = "parent_id";// INT,

    public static String COLUMN_DICT_PARENT = getDictionaryColumn(TABLE,
            COLUMN_PARENT_ID, COLUMN_PARENT_ID);

    public static String COLUMN_NAME = "group_name";// VARCHAR(50),

    public static String COLUMN_DESCRIPTION = "group_description";// VARCHAR(500),

    private static String[] COLUMNS_LIST = new String[] { COLUMN_ID,
            COLUMN_DICT_PARENT, COLUMN_NAME, COLUMN_DESCRIPTION,
            COLUMN_PARENT_ID };

    private static String[] COLUMNS_ID = new String[] { COLUMN_ID };

    private static String[] COLUMNS_NO_ID = new String[] { COLUMN_PARENT_ID,
            COLUMN_NAME, COLUMN_DESCRIPTION };

    public static String QUERY_GROUP = getQuerySQL(COLUMNS_LIST, TABLE);

    public static String getQueryGroup(Map<String, String> params) {
        return getQuerySQL(COLUMNS_LIST, TABLE, params);
    }

    public static String QUERY_GROUP_WITH_ID = getQuerySQL(TABLE, COLUMNS_ID);

    public static String INSERT_GROUP = getInsertSQL(TABLE, COLUMNS_NO_ID);

    public static String UPDATE_GROUP = getUpdateSQL(TABLE,
            new String[] { COLUMN_DESCRIPTION }, COLUMNS_ID);

    public static String getDeleteGroup(String[] values) {
        return getDeleteSQL(TABLE, COLUMN_ID, values);
    }
}