itemsql.java

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

package com.xuntian.material.sql.baseinfo;

import java.util.Map;

import com.xuntian.material.sql.BaseSQL;

public final class ItemSQL extends BaseSQL {
	
    public static String TABLE = "info_item";

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


    public static String COLUMN_NAME = "item_name";// VARCHAR(100),/*名称*/

    private static String[] COLUMNS_LIST = new String[] { COLUMN_ID,
            COLUMN_NAME };
    private static String[] COLUMNS_ALL = new String[] { COLUMN_ID,
        COLUMN_NAME};
    private static String[] COLUMNS = new String[] {  COLUMN_NAME
            };

    public static String QUERY_ITEM = getQuerySQL(COLUMNS_LIST, TABLE);
    public static String QUERY_ITEM1 = getQuerySQL(COLUMNS_ALL, TABLE);
    
    public static String getQueryItem(Map<String, String> params) {
        return getQuerySQL(COLUMNS_LIST, TABLE, params);
    }

    public static String QUERY_ITEM_WITH_ID = getQuerySQL(TABLE,
            new String[] { COLUMN_ID });

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

    public static String UPDATE_ITEM = getUpdateSQL(TABLE, COLUMNS,
            new String[] { COLUMN_ID });

    public static String getDeleteItem(String[] itemIDs) {
        return getDeleteSQL(TABLE, COLUMN_ID, itemIDs);
    }
    
    public static String getDeleteMsg(String[] itemIDs){
    	return getDeleteSQL("info_msg", "msg_id", itemIDs);
    }
    public static String getItemRoleCondition(String[] columns, String table,
            int[] itemIDs) {
        StringBuffer cond = new StringBuffer(getQuerySQL(columns, table));
        cond.append(WHERE_1_EQUALS_1);
        prepareInCondition(cond, COLUMN_ID, itemIDs);
        prepareOrderAsc(cond, ItemSQL.COLUMN_NAME);
        return cond.toString();
    }
}