jmdbocommandkeys.java

MSN客服自动化机器人

package jm.dbo;

/**
 * DBTypes
 * @author fu_changyong(1shome)
 * @see jdk1.5.2
 * @version 1.5.2.2
 */
public interface JMDBOCommandKeys {
    //////////////////////////////////////////////////////////////////
    public static final String ITEM_IS_PASS = "PASS";

    public static final String ITEM_BLANK = " ";

    public static final String ITEM_REMOVE = "NULL";

    public static final String ITEM_IS_NULL = "IS NULL";

    public static final String ITEM_IS_NOT_NULL = "IS NOT NULL";

    //////////////////////////////////////////////////////////////////
    public static final String DB_SQLS =
            "SELECT SQLID , NAME , TYPE , SQLDATA , SQLTABLE , SQLWHERE , SQLORDERBY , SQLGROUPBY , ROOL , DELFLG , UPDATER , UPDATETIME FROM SC9000 WHERE SQLID =";

    public static final String DB_KEY_SQLID = "SQLID";

// 嬈柋庬椶*/
   public static final String DB_KEY_TYPE = "TYPE";

// 撪梕*/
   public static final String DB_KEY_SQLDATA = "SQLDATA";

// 撪梕*/
   public static final String DB_KEY_SQLTABLE = "SQLTABLE";

// 撪梕*/
   public static final String DB_KEY_SQLWHERE = "SQLWHERE";

// 撪梕*/
   public static final String DB_KEY_SQLORDERBY = "SQLORDERBY";

// 撪梕*/
   public static final String DB_KEY_SQLGROUPBY = "SQLGROUPBY";

// 尃尷*/
   public static final String DB_KEY_ROOL = "ROOL";

    //////////////////////////////////////////////////////////////////
    public static final String SVC_DB_RESULT = "RESULT";

    public static final String SVC_DB_RETURN = "RETURN";

    //////////////////////////////////////////////////////////////////
    public static final String SVC_DB_NAME_ORACLE = "ORACLE";

    public static final String SVC_DB_NAME_SQLSERVER = "SQLSERVER";

    public static final String SVC_DB_NAME_DB2 = "DB2";

    public static final String SVC_DB_NAME_MYSQL = "MYSQL";

    public static final String SVC_DB_NAME_AS400 = "AS400";
    /*---------------------------------------------------------*/
    public static final String SVC_DB_TYPE_DB = "DB";
    public static final String SVC_DB_TYPE_XML = "XML";
    public static final String SVC_DB_TYPE_PROPERTIES = "PROPERTIES";
    //////////////////////////////////////////////////////////////////
    public final static String SVC_DB_USER_INFO = "USERINFO";
    public static final String SVC_DB_SQL_CODE = "SVCSQLCODE";
    public static final String SVC_DB_SQL_COUNT = "SVCSQLCOUNT";
    public static final String SVC_DB_SQL_DATA = "SVCSQLDATA";
    public static final String SVC_DB_SQL_ID = "SVCSQLID";
    public static final String SVC_DB_SQL_MESSAGE = "SVCSQLMESSAGE";
    public static final String SVC_DB_NAME = "SVCSQLDBNAME";
    public static final String SVC_DB_SQL_WHERE = "SVCSQLWHERE";
    public static final String SVC_DB_PARAM = "PARAMETER";

//    public static final String SVC_DB_PKGID = "PKGID" ;

    //public static final String SVC_CLIENT_IP = "SVCCLIENTIP" ;

    //public static final String SVC_DB_SQL = "SQL" ;

    //public static final String SVC_DB_ROLE = "ROLE" ;

    //public static final String SVC_DB_ID = "ID" ;

    public static final String SVC_TB_PAGENO = "PAGENO";
    public static final String SVC_TB_PAGE_ROW = "PAGEROW";
    public static final String SVC_DB_EVENTID = "EVENTID";
    //////////////////////////////////////////////////////////////////

    public static final String DB_ALL_PAGE = "ALLPAGE";
    public static final String SVC_SELECT = "0001";
    public static final String SVC_INSERT = "0002";
    public static final String SVC_UPDATE = "0003";
    public static final String SVC_DELETE = "0004";
    public static final String SVC_PIC_SEL = "0005";
    public static final String SVC_PIC_CON = "0006";
    public static final String SVC_TABLE_SELECT = "0007";

}