menusql.java

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

package com.xuntian.material.sql.portal;

import com.xuntian.material.sql.BaseSQL;

public final class MenuSQL extends BaseSQL {
    public static String TABLE = "mat_menu";

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

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

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

    public static String COLUMN_URL = "menu_url";// VARCHAR(200),

    public static String COLUMN_ORDER = "menu_order";// INT,

    public static String SQL_QUERY_MAIN_MENU_LIST = "SELECT " + COLUMN_ID
            + ", " + COLUMN_NAME + ", " + COLUMN_URL + " FROM " + TABLE
            + " WHERE " + COLUMN_PARENT_ID + "=0 ORDER BY " + COLUMN_ORDER;

    public static String SQL_QUERY_SUB_MENU_LIST = "SELECT " + COLUMN_ID + ", "
            + COLUMN_NAME + ", " + COLUMN_URL + ", " + COLUMN_ORDER + " FROM "
            + TABLE + " WHERE " + COLUMN_PARENT_ID + "=? ORDER BY "
            + COLUMN_ORDER;
}