usersql.java

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

package com.xuntian.material.sql.user;

import java.util.Map;

import com.xuntian.material.sql.BaseSQL;

public final class UserSQL extends BaseSQL {
    public static String TABLE = "mat_user";

    public static String COLUMN_ID = "user_id";

    public static String COLUMN_NAME = "user_name";

    public static String COLUMN_PASSWORD = "user_password";

    public static String COLUMN_REALNAME = "user_realname";


    public static String COLUMN_COMPANY = "user_company";

    public static String COLUMN_DEPARTMENT = "user_department";

    public static String COLUMN_GROUP = "user_group";

    public static String COLUMN_TEL_PERSON = "user_tel_person";

    public static String COLUMN_TEL_OFFICE = "user_tel_office";

    public static String COLUMN_TAX_PERSON = "user_tax_person";

    public static String COLUMN_TAX_OFFICE = "user_tax_office";

    public static String COLUMN_MOBILE_PERSON = "user_mobile_person";

    public static String COLUMN_MOBILE_OFFICE = "user_mobile_office";

    public static String COLUMN_EMAIL = "user_email";

    public static String COLUMN_OICQ = "user_oicq";

    public static String COLUMN_DESCRIPTION = "user_description";

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

    private static String[] COLUMNS_INSERT = new String[] { COLUMN_NAME,
            COLUMN_PASSWORD, COLUMN_REALNAME,  COLUMN_COMPANY,
            COLUMN_DEPARTMENT, COLUMN_GROUP, COLUMN_TEL_PERSON,
            COLUMN_TEL_OFFICE, COLUMN_TAX_PERSON, COLUMN_TAX_OFFICE,
            COLUMN_MOBILE_PERSON, COLUMN_MOBILE_OFFICE, COLUMN_EMAIL,
            COLUMN_OICQ, COLUMN_DESCRIPTION };

    private static String[] COLUMNS_UPDATE_PASSWORD = new String[] { COLUMN_PASSWORD };

    private static String[] COLUMNS_UPDATE_USERINFO = new String[] {
    	    COLUMN_NAME,COLUMN_REALNAME,
            COLUMN_COMPANY, COLUMN_DEPARTMENT, COLUMN_GROUP,
            COLUMN_TEL_PERSON, COLUMN_TEL_OFFICE, COLUMN_TAX_PERSON,
            COLUMN_TAX_OFFICE, COLUMN_MOBILE_PERSON, COLUMN_MOBILE_OFFICE,
            COLUMN_EMAIL, COLUMN_OICQ, COLUMN_DESCRIPTION };

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

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

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

    public static String QUERY_USER_LOGIN = getQuerySQL(TABLE,
            new String[] { COLUMN_NAME, COLUMN_PASSWORD });

    public static String INSERT_USER = getInsertSQL(TABLE, COLUMNS_INSERT);

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

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

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