Schema 接口和其实现的类

最新推荐文章于 2024-04-30 08:00:00 发布
最新推荐文章于 2024-04-30 08:00:00 发布
阅读量3k 收藏
点赞数
分类专栏： Java知识 文章标签： schema string null integer date import
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/hbuzhang/article/details/329308
版权

/**
 * <p>ClassName: Schema 接口 </p>
 * <p>Description: </p>
 * <p>Copyright: Copyright (c) 2002</p>
 * <p>Company:  </p>
 * @author: 
 * @version: 
 * @date: 
 */
public interface Schema
{
    public static int TYPE_NOFOUND = -1; //
    public static int TYPE_MIN = -1; // the minimum value of type
    public static int TYPE_STRING = 0; // java.lang.String
    public static int TYPE_DATE = 1; // java.util.Date
    public static int TYPE_FLOAT = 2; // float
    public static int TYPE_INT = 3; // int
    public static int TYPE_DOUBLE = 4; // double
    public static int TYPE_MAX = 5; // the maximum value of type

    public String[] getPK();

    // 按名字或索引返回值
    public String getV(String FCode);

    public String getV(int nIndex);

    // 按名字或索引返回字段的类型，如Schema.TYPE_STRING
    public int getFieldType(String strFieldName);

    public int getFieldType(int nFieldIndex);

    // 得到字段数
    public int getFieldCount();

    // 名字和索引互查
    public int getFieldIndex(String strFieldName);

    public String getFieldName(int nFieldIndex);

    // 按照名字设置
    public boolean setV(String strFieldName, String strFieldValue);
}
/*
 * <p>ClassName: LAHolsSchema </p>
 * <p>Description: DB层 Schema 类文件 </p>
 * <p>Copyright: Copyright (c) 2002</p>
 * <p>Company: sinosoft </p>
 * @Database: 管理
 * @CreateDate：2004-12-20
 */
package com.schema;

import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.Date;

import com.db.LAHolsDB;
import com.pubfun.FDate;
import com.utility.CError;
import com..utility.CErrors;
import com..utility.ChgData;
import com.utility.Schema;
import com.utility.StrTool;
import com..utility.SysConst;

public class LAHolsSchema implements Schema
{
    // @Field
    /** 编码 */
    private String AgentCode;
    /**  */
    private String AgentGroup;
    /** 机构 */
    private String ManageCom;
    /** 纪录顺序号 */
    private int Idx;
    /** 指标计算编码 */
    private String IndexCalNo;
    /** 请假类型 */
    private String AClass;
    /** 天数 */
    private int VacDays;
    /** 日期 */
    private Date LeaveDate;
    /** 日期 */
    private Date EndDate;
    /** 天数 */
    private String AbsDays;
    /** 填写标志 */
    private String FillFlag;
    /** 证明书标志 */
    private String ConfIdenFlag;
    /** 增加标志 */
    private String AddVacFlag;
    /** 金额 */
    private double SumMoney;
    /** 核准人 */
    private String ApproveCode;
    /** 批注 */
    private String Noti;
    /** 操作员代码 */
    private String Operator;
    /** 入机日期 */
    private Date MakeDate;
    /** 入机时间 */
    private String MakeTime;
    /** 最后一次修改日期 */
    private Date ModifyDate;
    /** 最后一次修改时间 */
    private String ModifyTime;
    /** 类型 */
    private String BranchType;
    /** 日期 */
    private Date ShouldEndDate;
    /** 状态 */
    private String LeaveState;
    /** 外部编码 */
    private String BranchAttr;

    public static final int FIELDNUM = 25; // 数据库表的字段个数

    private static String[] PK; // 主键

    private FDate fDate = new FDate(); // 处理日期

    public CErrors mErrors; // 错误信息

    // @Constructor
    public LAHolsSchema()
    {
        mErrors = new CErrors();

        String[] pk = new String[2];
        pk[0] = "AgentCode";
        pk[1] = "Idx";

        PK = pk;
    }

    // @Method
    public String[] getPK()
    {
        return PK;
    }

    public String getAgentCode()
    {
        if (AgentCode != null && !AgentCode.equals("") &&
            SysConst.CHANGECHARSET == true)
        {
            AgentCode = StrTool.unicodeToGBK(AgentCode);
        }
        return AgentCode;
    }

    public void setAgentCode(String aAgentCode)
    {
        AgentCode = aAgentCode;
    }

    public String getAgentGroup()
    {
        if (AgentGroup != null && !AgentGroup.equals("") &&
            SysConst.CHANGECHARSET == true)
        {
            AgentGroup = StrTool.unicodeToGBK(AgentGroup);
        }
        return AgentGroup;
    }

    public void setAgentGroup(String aAgentGroup)
    {
        AgentGroup = aAgentGroup;
    }

    public String getManageCom()
    {
        if (ManageCom != null && !ManageCom.equals("") &&
            SysConst.CHANGECHARSET == true)
        {
            ManageCom = StrTool.unicodeToGBK(ManageCom);
        }
        return ManageCom;
    }

    public void setManageCom(String aManageCom)
    {
        ManageCom = aManageCom;
    }

    public int getIdx()
    {
        return Idx;
    }

    public void setIdx(int aIdx)
    {
        Idx = aIdx;
    }

    public void setIdx(String aIdx)
    {
        if (aIdx != null && !aIdx.equals(""))
        {
            Integer tInteger = new Integer(aIdx);
            int i = tInteger.intValue();
            Idx = i;
        }
    }

    public String getIndexCalNo()
    {
        if (IndexCalNo != null && !IndexCalNo.equals("") &&
            SysConst.CHANGECHARSET == true)
        {
            IndexCalNo = StrTool.unicodeToGBK(IndexCalNo);
        }
        return IndexCalNo;
    }

    public void setIndexCalNo(String aIndexCalNo)
    {
        IndexCalNo = aIndexCalNo;
    }

    public String getAClass()
    {
        if (AClass != null && !AClass.equals("") && SysConst.CHANGECHARSET == true)
        {
            AClass = StrTool.unicodeToGBK(AClass);
        }
        return AClass;
    }

    public void setAClass(String aAClass)
    {
        AClass = aAClass;
    }

    public int getVacDays()
    {
        return VacDays;
    }

    public void setVacDays(int aVacDays)
    {
        VacDays = aVacDays;
    }

    public void setVacDays(String aVacDays)
    {
        if (aVacDays != null && !aVacDays.equals(""))
        {
            Integer tInteger = new Integer(aVacDays);
            int i = tInteger.intValue();
            VacDays = i;
        }
    }

    public String getLeaveDate()
    {
        if (LeaveDate != null)
        {
            return fDate.getString(LeaveDate);
        }
        else
        {
            return null;
        }
    }

    public void setLeaveDate(Date aLeaveDate)
    {
        LeaveDate = aLeaveDate;
    }

    public void setLeaveDate(String aLeaveDate)
    {
        if (aLeaveDate != null && !aLeaveDate.equals(""))
        {
            LeaveDate = fDate.getDate(aLeaveDate);
        }
        else
        {
            LeaveDate = null;
        }
    }

    public String getEndDate()
    {
        if (EndDate != null)
        {
            return fDate.getString(EndDate);
        }
        else
        {
            return null;
        }
    }

    public void setEndDate(Date aEndDate)
    {
        EndDate = aEndDate;
    }

    public void setEndDate(String aEndDate)
    {
        if (aEndDate != null && !aEndDate.equals(""))
        {
            EndDate = fDate.getDate(aEndDate);
        }
        else
        {
            EndDate = null;
        }
    }

    public String getAbsDays()
    {
        if (AbsDays != null && !AbsDays.equals("") && SysConst.CHANGECHARSET == true)
        {
            AbsDays = StrTool.unicodeToGBK(AbsDays);
        }
        return AbsDays;
    }

    public void setAbsDays(String aAbsDays)
    {
        AbsDays = aAbsDays;
    }

    public String getFillFlag()
    {
        if (FillFlag != null && !FillFlag.equals("") && SysConst.CHANGECHARSET == true)
        {
            FillFlag = StrTool.unicodeToGBK(FillFlag);
        }
        return FillFlag;
    }

    public void setFillFlag(String aFillFlag)
    {
        FillFlag = aFillFlag;
    }

    public String getConfIdenFlag()
    {
        if (ConfIdenFlag != null && !ConfIdenFlag.equals("") &&
            SysConst.CHANGECHARSET == true)
        {
            ConfIdenFlag = StrTool.unicodeToGBK(ConfIdenFlag);
        }
        return ConfIdenFlag;
    }

    public void setConfIdenFlag(String aConfIdenFlag)
    {
        ConfIdenFlag = aConfIdenFlag;
    }

    public String getAddVacFlag()
    {
        if (AddVacFlag != null && !AddVacFlag.equals("") &&
            SysConst.CHANGECHARSET == true)
        {
            AddVacFlag = StrTool.unicodeToGBK(AddVacFlag);
        }
        return AddVacFlag;
    }

    public void setAddVacFlag(String aAddVacFlag)
    {
        AddVacFlag = aAddVacFlag;
    }

    public double getSumMoney()
    {
        return SumMoney;
    }

    public void setSumMoney(double aSumMoney)
    {
        SumMoney = aSumMoney;
    }

    public void setSumMoney(String aSumMoney)
    {
        if (aSumMoney != null && !aSumMoney.equals(""))
        {
            Double tDouble = new Double(aSumMoney);
            double d = tDouble.doubleValue();
            SumMoney = d;
        }
    }

    public String getApproveCode()
    {
        if (ApproveCode != null && !ApproveCode.equals("") &&
            SysConst.CHANGECHARSET == true)
        {
            ApproveCode = StrTool.unicodeToGBK(ApproveCode);
        }
        return ApproveCode;
    }

    public void setApproveCode(String aApproveCode)
    {
        ApproveCode = aApproveCode;
    }

    public String getNoti()
    {
        if (Noti != null && !Noti.equals("") && SysConst.CHANGECHARSET == true)
        {
            Noti = StrTool.unicodeToGBK(Noti);
        }
        return Noti;
    }

    public void setNoti(String aNoti)
    {
        Noti = aNoti;
    }

    public String getOperator()
    {
        if (Operator != null && !Operator.equals("") && SysConst.CHANGECHARSET == true)
        {
            Operator = StrTool.unicodeToGBK(Operator);
        }
        return Operator;
    }

    public void setOperator(String aOperator)
    {
        Operator = aOperator;
    }

    public String getMakeDate()
    {
        if (MakeDate != null)
        {
            return fDate.getString(MakeDate);
        }
        else
        {
            return null;
        }
    }

    public void setMakeDate(Date aMakeDate)
    {
        MakeDate = aMakeDate;
    }

    public void setMakeDate(String aMakeDate)
    {
        if (aMakeDate != null && !aMakeDate.equals(""))
        {
            MakeDate = fDate.getDate(aMakeDate);
        }
        else
        {
            MakeDate = null;
        }
    }

    public String getMakeTime()
    {
        if (MakeTime != null && !MakeTime.equals("") && SysConst.CHANGECHARSET == true)
        {
            MakeTime = StrTool.unicodeToGBK(MakeTime);
        }
        return MakeTime;
    }

    public void setMakeTime(String aMakeTime)
    {
        MakeTime = aMakeTime;
    }

    public String getModifyDate()
    {
        if (ModifyDate != null)
        {
            return fDate.getString(ModifyDate);
        }
        else
        {
            return null;
        }
    }

    public void setModifyDate(Date aModifyDate)
    {
        ModifyDate = aModifyDate;
    }

    public void setModifyDate(String aModifyDate)
    {
        if (aModifyDate != null && !aModifyDate.equals(""))
        {
            ModifyDate = fDate.getDate(aModifyDate);
        }
        else
        {
            ModifyDate = null;
        }
    }

    public String getModifyTime()
    {
        if (ModifyTime != null && !ModifyTime.equals("") &&
            SysConst.CHANGECHARSET == true)
        {
            ModifyTime = StrTool.unicodeToGBK(ModifyTime);
        }
        return ModifyTime;
    }

    public void setModifyTime(String aModifyTime)
    {
        ModifyTime = aModifyTime;
    }

    public String getBranchType()
    {
        if (BranchType != null && !BranchType.equals("") &&
            SysConst.CHANGECHARSET == true)
        {
            BranchType = StrTool.unicodeToGBK(BranchType);
        }
        return BranchType;
    }

    public void setBranchType(String aBranchType)
    {
        BranchType = aBranchType;
    }

    public String getShouldEndDate()
    {
        if (ShouldEndDate != null)
        {
            return fDate.getString(ShouldEndDate);
        }
        else
        {
            return null;
        }
    }

    public void setShouldEndDate(Date aShouldEndDate)
    {
        ShouldEndDate = aShouldEndDate;
    }

    public void setShouldEndDate(String aShouldEndDate)
    {
        if (aShouldEndDate != null && !aShouldEndDate.equals(""))
        {
            ShouldEndDate = fDate.getDate(aShouldEndDate);
        }
        else
        {
            ShouldEndDate = null;
        }
    }

    public String getLeaveState()
    {
        if (LeaveState != null && !LeaveState.equals("") &&
            SysConst.CHANGECHARSET == true)
        {
            LeaveState = StrTool.unicodeToGBK(LeaveState);
        }
        return LeaveState;
    }

    public void setLeaveState(String aLeaveState)
    {
        LeaveState = aLeaveState;
    }

    public String getBranchAttr()
    {
        if (BranchAttr != null && !BranchAttr.equals("") &&
            SysConst.CHANGECHARSET == true)
        {
            BranchAttr = StrTool.unicodeToGBK(BranchAttr);
        }
        return BranchAttr;
    }

    public void setBranchAttr(String aBranchAttr)
    {
        BranchAttr = aBranchAttr;
    }

    /**
     * 使用另外一个 LAHolsSchema 对象给 Schema 赋值
     * @param: Schema 对象
     * @return: 无
     **/
    public void setSchema(LAHolsSchema aLAHolsSchema)
    {
        this.AgentCode = aLAHolsSchema.getAgentCode();
        this.AgentGroup = aLAHolsSchema.getAgentGroup();
        this.ManageCom = aLAHolsSchema.getManageCom();
        this.Idx = aLAHolsSchema.getIdx();
        this.IndexCalNo = aLAHolsSchema.getIndexCalNo();
        this.AClass = aLAHolsSchema.getAClass();
        this.VacDays = aLAHolsSchema.getVacDays();
        this.LeaveDate = fDate.getDate(aLAHolsSchema.getLeaveDate());
        this.EndDate = fDate.getDate(aLAHolsSchema.getEndDate());
        this.AbsDays = aLAHolsSchema.getAbsDays();
        this.FillFlag = aLAHolsSchema.getFillFlag();
        this.ConfIdenFlag = aLAHolsSchema.getConfIdenFlag();
        this.AddVacFlag = aLAHolsSchema.getAddVacFlag();
        this.SumMoney = aLAHolsSchema.getSumMoney();
        this.ApproveCode = aLAHolsSchema.getApproveCode();
        this.Noti = aLAHolsSchema.getNoti();
        this.Operator = aLAHolsSchema.getOperator();
        this.MakeDate = fDate.getDate(aLAHolsSchema.getMakeDate());
        this.MakeTime = aLAHolsSchema.getMakeTime();
        this.ModifyDate = fDate.getDate(aLAHolsSchema.getModifyDate());
        this.ModifyTime = aLAHolsSchema.getModifyTime();
        this.BranchType = aLAHolsSchema.getBranchType();
        this.ShouldEndDate = fDate.getDate(aLAHolsSchema.getShouldEndDate());
        this.LeaveState = aLAHolsSchema.getLeaveState();
        this.BranchAttr = aLAHolsSchema.getBranchAttr();
    }

    /**
     * 使用 ResultSet 中的第 i 行给 Schema 赋值
     * @param: ResultSet 对象; i 行数
     * @return: boolean
     **/
    public boolean setSchema(ResultSet rs, int i)
    {
        try
        {
            //rs.absolute(i);  // 非滚动游标
            if (rs.getString("AgentCode") == null)
            {
                this.AgentCode = null;
            }
            else
            {
                this.AgentCode = rs.getString("AgentCode").trim();
            }

            if (rs.getString("AgentGroup") == null)
            {
                this.AgentGroup = null;
            }
            else
            {
                this.AgentGroup = rs.getString("AgentGroup").trim();
            }

            if (rs.getString("ManageCom") == null)
            {
                this.ManageCom = null;
            }
            else
            {
                this.ManageCom = rs.getString("ManageCom").trim();
            }

            this.Idx = rs.getInt("Idx");
            if (rs.getString("IndexCalNo") == null)
            {
                this.IndexCalNo = null;
            }
            else
            {
                this.IndexCalNo = rs.getString("IndexCalNo").trim();
            }

            if (rs.getString("AClass") == null)
            {
                this.AClass = null;
            }
            else
            {
                this.AClass = rs.getString("AClass").trim();
            }

            this.VacDays = rs.getInt("VacDays");
            this.LeaveDate = rs.getDate("LeaveDate");
            this.EndDate = rs.getDate("EndDate");
            if (rs.getString("AbsDays") == null)
            {
                this.AbsDays = null;
            }
            else
            {
                this.AbsDays = rs.getString("AbsDays").trim();
            }

            if (rs.getString("FillFlag") == null)
            {
                this.FillFlag = null;
            }
            else
            {
                this.FillFlag = rs.getString("FillFlag").trim();
            }

            if (rs.getString("ConfIdenFlag") == null)
            {
                this.ConfIdenFlag = null;
            }
            else
            {
                this.ConfIdenFlag = rs.getString("ConfIdenFlag").trim();
            }

            if (rs.getString("AddVacFlag") == null)
            {
                this.AddVacFlag = null;
            }
            else
            {
                this.AddVacFlag = rs.getString("AddVacFlag").trim();
            }

            this.SumMoney = rs.getDouble("SumMoney");
            if (rs.getString("ApproveCode") == null)
            {
                this.ApproveCode = null;
            }
            else
            {
                this.ApproveCode = rs.getString("ApproveCode").trim();
            }

            if (rs.getString("Noti") == null)
            {
                this.Noti = null;
            }
            else
            {
                this.Noti = rs.getString("Noti").trim();
            }

            if (rs.getString("Operator") == null)
            {
                this.Operator = null;
            }
            else
            {
                this.Operator = rs.getString("Operator").trim();
            }

            this.MakeDate = rs.getDate("MakeDate");
            if (rs.getString("MakeTime") == null)
            {
                this.MakeTime = null;
            }
            else
            {
                this.MakeTime = rs.getString("MakeTime").trim();
            }

            this.ModifyDate = rs.getDate("ModifyDate");
            if (rs.getString("ModifyTime") == null)
            {
                this.ModifyTime = null;
            }
            else
            {
                this.ModifyTime = rs.getString("ModifyTime").trim();
            }

            if (rs.getString("BranchType") == null)
            {
                this.BranchType = null;
            }
            else
            {
                this.BranchType = rs.getString("BranchType").trim();
            }

            this.ShouldEndDate = rs.getDate("ShouldEndDate");
            if (rs.getString("LeaveState") == null)
            {
                this.LeaveState = null;
            }
            else
            {
                this.LeaveState = rs.getString("LeaveState").trim();
            }

            if (rs.getString("BranchAttr") == null)
            {
                this.BranchAttr = null;
            }
            else
            {
                this.BranchAttr = rs.getString("BranchAttr").trim();
            }

        }
        catch (SQLException sqle)
        {
            // @@错误处理
            CError tError = new CError();
            tError.moduleName = "LAHolsSchema";
            tError.functionName = "setSchema";
            tError.errorMessage = sqle.toString();
            this.mErrors.addOneError(tError);

            return false;
        }
        return true;
    }

    public LAHolsSchema getSchema()
    {
        LAHolsSchema aLAHolsSchema = new LAHolsSchema();
        aLAHolsSchema.setSchema(this);
        return aLAHolsSchema;
    }

    public LAHolsDB getDB()
    {
        LAHolsDB aDBOper = new LAHolsDB();
        aDBOper.setSchema(this);
        return aDBOper;
    }


    /**
     * 数据打包，按 XML 格式打包，顺序参见<A href ={@docRoot}/dataStructure/tb.html#PrpLAHols描述/A>表字段
     * @param: 无
     * @return: 返回打包后字符串
     **/
    public String encode()
    {
        String strReturn = "";
        strReturn = StrTool.cTrim(StrTool.unicodeToGBK(AgentCode)) +
                    SysConst.PACKAGESPILTER
                    + StrTool.cTrim(StrTool.unicodeToGBK(AgentGroup)) +
                    SysConst.PACKAGESPILTER
                    + StrTool.cTrim(StrTool.unicodeToGBK(ManageCom)) +
                    SysConst.PACKAGESPILTER
                    + ChgData.chgData(Idx) + SysConst.PACKAGESPILTER
                    + StrTool.cTrim(StrTool.unicodeToGBK(IndexCalNo)) +
                    SysConst.PACKAGESPILTER
                    + StrTool.cTrim(StrTool.unicodeToGBK(AClass)) +
                    SysConst.PACKAGESPILTER
                    + ChgData.chgData(VacDays) + SysConst.PACKAGESPILTER
                    +
                    StrTool.cTrim(StrTool.unicodeToGBK(fDate.getString(
                            LeaveDate))) +
                    SysConst.PACKAGESPILTER
                    +
                    StrTool.cTrim(StrTool.unicodeToGBK(fDate.getString(EndDate))) +
                    SysConst.PACKAGESPILTER
                    + StrTool.cTrim(StrTool.unicodeToGBK(AbsDays)) +
                    SysConst.PACKAGESPILTER
                    + StrTool.cTrim(StrTool.unicodeToGBK(FillFlag)) +
                    SysConst.PACKAGESPILTER
                    + StrTool.cTrim(StrTool.unicodeToGBK(ConfIdenFlag)) +
                    SysConst.PACKAGESPILTER
                    + StrTool.cTrim(StrTool.unicodeToGBK(AddVacFlag)) +
                    SysConst.PACKAGESPILTER
                    + ChgData.chgData(SumMoney) + SysConst.PACKAGESPILTER
                    + StrTool.cTrim(StrTool.unicodeToGBK(ApproveCode)) +
                    SysConst.PACKAGESPILTER
                    + StrTool.cTrim(StrTool.unicodeToGBK(Noti)) +
                    SysConst.PACKAGESPILTER
                    + StrTool.cTrim(StrTool.unicodeToGBK(Operator)) +
                    SysConst.PACKAGESPILTER
                    +
                    StrTool.cTrim(StrTool.unicodeToGBK(fDate.getString(MakeDate))) +
                    SysConst.PACKAGESPILTER
                    + StrTool.cTrim(StrTool.unicodeToGBK(MakeTime)) +
                    SysConst.PACKAGESPILTER
                    +
                    StrTool.cTrim(StrTool.unicodeToGBK(fDate.getString(
                            ModifyDate))) +
                    SysConst.PACKAGESPILTER
                    + StrTool.cTrim(StrTool.unicodeToGBK(ModifyTime)) +
                    SysConst.PACKAGESPILTER
                    + StrTool.cTrim(StrTool.unicodeToGBK(BranchType)) +
                    SysConst.PACKAGESPILTER
                    +
                    StrTool.cTrim(StrTool.unicodeToGBK(fDate.getString(
                            ShouldEndDate))) +
                    SysConst.PACKAGESPILTER
                    + StrTool.cTrim(StrTool.unicodeToGBK(LeaveState)) +
                    SysConst.PACKAGESPILTER
                    + StrTool.cTrim(StrTool.unicodeToGBK(BranchAttr));
        return strReturn;
    }

    /**
     * 数据解包，解包顺序参见<A href ={@docRoot}/dataStructure/tb.html#PrpLAHols>历史记账凭证主表信息</A>表字段
     * @param: strMessage：包含一条纪录数据的字符串
     * @return: boolean
     **/
    public boolean decode(String strMessage)
    {
        try
        {
            AgentCode = StrTool.getStr(StrTool.GBKToUnicode(strMessage), 1,
                                       SysConst.PACKAGESPILTER);
            AgentGroup = StrTool.getStr(StrTool.GBKToUnicode(strMessage), 2,
                                        SysConst.PACKAGESPILTER);
            ManageCom = StrTool.getStr(StrTool.GBKToUnicode(strMessage), 3,
                                       SysConst.PACKAGESPILTER);
            Idx = new Integer(ChgData.chgNumericStr(StrTool.getStr(strMessage,
                    4, SysConst.PACKAGESPILTER))).intValue();
            IndexCalNo = StrTool.getStr(StrTool.GBKToUnicode(strMessage), 5,
                                        SysConst.PACKAGESPILTER);
            AClass = StrTool.getStr(StrTool.GBKToUnicode(strMessage), 6,
                                    SysConst.PACKAGESPILTER);
            VacDays = new Integer(ChgData.chgNumericStr(StrTool.getStr(
                    strMessage, 7, SysConst.PACKAGESPILTER))).intValue();
            LeaveDate = fDate.getDate(StrTool.getStr(StrTool.GBKToUnicode(
                    strMessage), 8, SysConst.PACKAGESPILTER));
            EndDate = fDate.getDate(StrTool.getStr(StrTool.GBKToUnicode(
                    strMessage), 9, SysConst.PACKAGESPILTER));
            AbsDays = StrTool.getStr(StrTool.GBKToUnicode(strMessage), 10,
                                     SysConst.PACKAGESPILTER);
            FillFlag = StrTool.getStr(StrTool.GBKToUnicode(strMessage), 11,
                                      SysConst.PACKAGESPILTER);
            ConfIdenFlag = StrTool.getStr(StrTool.GBKToUnicode(strMessage), 12,
                                          SysConst.PACKAGESPILTER);
            AddVacFlag = StrTool.getStr(StrTool.GBKToUnicode(strMessage), 13,
                                        SysConst.PACKAGESPILTER);
            SumMoney = new Double(ChgData.chgNumericStr(StrTool.getStr(
                    strMessage, 14, SysConst.PACKAGESPILTER))).doubleValue();
            ApproveCode = StrTool.getStr(StrTool.GBKToUnicode(strMessage), 15,
                                         SysConst.PACKAGESPILTER);
            Noti = StrTool.getStr(StrTool.GBKToUnicode(strMessage), 16,
                                  SysConst.PACKAGESPILTER);
            Operator = StrTool.getStr(StrTool.GBKToUnicode(strMessage), 17,
                                      SysConst.PACKAGESPILTER);
            MakeDate = fDate.getDate(StrTool.getStr(StrTool.GBKToUnicode(
                    strMessage), 18, SysConst.PACKAGESPILTER));
            MakeTime = StrTool.getStr(StrTool.GBKToUnicode(strMessage), 19,
                                      SysConst.PACKAGESPILTER);
            ModifyDate = fDate.getDate(StrTool.getStr(StrTool.GBKToUnicode(
                    strMessage), 20, SysConst.PACKAGESPILTER));
            ModifyTime = StrTool.getStr(StrTool.GBKToUnicode(strMessage), 21,
                                        SysConst.PACKAGESPILTER);
            BranchType = StrTool.getStr(StrTool.GBKToUnicode(strMessage), 22,
                                        SysConst.PACKAGESPILTER);
            ShouldEndDate = fDate.getDate(StrTool.getStr(StrTool.GBKToUnicode(
                    strMessage), 23, SysConst.PACKAGESPILTER));
            LeaveState = StrTool.getStr(StrTool.GBKToUnicode(strMessage), 24,
                                        SysConst.PACKAGESPILTER);
            BranchAttr = StrTool.getStr(StrTool.GBKToUnicode(strMessage), 25,
                                        SysConst.PACKAGESPILTER);
        }
        catch (NumberFormatException ex)
        {
            // @@错误处理
            CError tError = new CError();
            tError.moduleName = "LAHolsSchema";
            tError.functionName = "decode";
            tError.errorMessage = ex.toString();
            this.mErrors.addOneError(tError);

            return false;
        }
        return true;
    }

    /**
     * 取得对应传入参数的String形式的字段值
     * @param: FCode 希望取得的字段名
     * @return: FValue String形式的字段值
     *   FValue = ""  没有匹配的字段
     *   FValue = "null" 字段值为null
     **/
    public String getV(String FCode)
    {
        String strReturn = "";
        if (FCode.equals("AgentCode"))
        {
            strReturn = StrTool.GBKToUnicode(strReturn.valueOf(AgentCode));
        }
        if (FCode.equals("AgentGroup"))
        {
            strReturn = StrTool.GBKToUnicode(strReturn.valueOf(AgentGroup));
        }
        if (FCode.equals("ManageCom"))
        {
            strReturn = StrTool.GBKToUnicode(strReturn.valueOf(ManageCom));
        }
        if (FCode.equals("Idx"))
        {
            strReturn = StrTool.GBKToUnicode(strReturn.valueOf(Idx));
        }
        if (FCode.equals("IndexCalNo"))
        {
            strReturn = StrTool.GBKToUnicode(strReturn.valueOf(IndexCalNo));
        }
        if (FCode.equals("AClass"))
        {
            strReturn = StrTool.GBKToUnicode(strReturn.valueOf(AClass));
        }
        if (FCode.equals("VacDays"))
        {
            strReturn = StrTool.GBKToUnicode(strReturn.valueOf(VacDays));
        }
        if (FCode.equals("LeaveDate"))
        {
            strReturn = StrTool.GBKToUnicode(strReturn.valueOf(this.
                    getLeaveDate()));
        }
        if (FCode.equals("EndDate"))
        {
            strReturn = StrTool.GBKToUnicode(strReturn.valueOf(this.getEndDate()));
        }
        if (FCode.equals("AbsDays"))
        {
            strReturn = StrTool.GBKToUnicode(strReturn.valueOf(AbsDays));
        }
        if (FCode.equals("FillFlag"))
        {
            strReturn = StrTool.GBKToUnicode(strReturn.valueOf(FillFlag));
        }
        if (FCode.equals("ConfIdenFlag"))
        {
            strReturn = StrTool.GBKToUnicode(strReturn.valueOf(ConfIdenFlag));
        }
        if (FCode.equals("AddVacFlag"))
        {
            strReturn = StrTool.GBKToUnicode(strReturn.valueOf(AddVacFlag));
        }
        if (FCode.equals("SumMoney"))
        {
            strReturn = StrTool.GBKToUnicode(strReturn.valueOf(SumMoney));
        }
        if (FCode.equals("ApproveCode"))
        {
            strReturn = StrTool.GBKToUnicode(strReturn.valueOf(ApproveCode));
        }
        if (FCode.equals("Noti"))
        {
            strReturn = StrTool.GBKToUnicode(strReturn.valueOf(Noti));
        }
        if (FCode.equals("Operator"))
        {
            strReturn = StrTool.GBKToUnicode(strReturn.valueOf(Operator));
        }
        if (FCode.equals("MakeDate"))
        {
            strReturn = StrTool.GBKToUnicode(strReturn.valueOf(this.getMakeDate()));
        }
        if (FCode.equals("MakeTime"))
        {
            strReturn = StrTool.GBKToUnicode(strReturn.valueOf(MakeTime));
        }
        if (FCode.equals("ModifyDate"))
        {
            strReturn = StrTool.GBKToUnicode(strReturn.valueOf(this.
                    getModifyDate()));
        }
        if (FCode.equals("ModifyTime"))
        {
            strReturn = StrTool.GBKToUnicode(strReturn.valueOf(ModifyTime));
        }
        if (FCode.equals("BranchType"))
        {
            strReturn = StrTool.GBKToUnicode(strReturn.valueOf(BranchType));
        }
        if (FCode.equals("ShouldEndDate"))
        {
            strReturn = StrTool.GBKToUnicode(strReturn.valueOf(this.
                    getShouldEndDate()));
        }
        if (FCode.equals("LeaveState"))
        {
            strReturn = StrTool.GBKToUnicode(strReturn.valueOf(LeaveState));
        }
        if (FCode.equals("BranchAttr"))
        {
            strReturn = StrTool.GBKToUnicode(strReturn.valueOf(BranchAttr));
        }
        if (strReturn.equals(""))
        {
            strReturn = "null";
        }

        return strReturn;
    }


    /**
     * 取得Schema中指定索引值所对应的字段值
     * @param: nFieldIndex 指定的字段索引值
     * @return: 字段值。
     *          如果没有对应的字段，返回""
     *          如果字段值为空，返回"null"
     **/
    public String getV(int nFieldIndex)
    {
        String strFieldValue = "";
        switch (nFieldIndex)
        {
            case 0:
                strFieldValue = StrTool.GBKToUnicode(AgentCode);
                break;
            case 1:
                strFieldValue = StrTool.GBKToUnicode(AgentGroup);
                break;
            case 2:
                strFieldValue = StrTool.GBKToUnicode(ManageCom);
                break;
            case 3:
                strFieldValue = String.valueOf(Idx);
                break;
            case 4:
                strFieldValue = StrTool.GBKToUnicode(IndexCalNo);
                break;
            case 5:
                strFieldValue = StrTool.GBKToUnicode(AClass);
                break;
            case 6:
                strFieldValue = String.valueOf(VacDays);
                break;
            case 7:
                strFieldValue = StrTool.GBKToUnicode(String.valueOf(this.
                        getLeaveDate()));
                break;
            case 8:
                strFieldValue = StrTool.GBKToUnicode(String.valueOf(this.
                        getEndDate()));
                break;
            case 9:
                strFieldValue = StrTool.GBKToUnicode(AbsDays);
                break;
            case 10:
                strFieldValue = StrTool.GBKToUnicode(FillFlag);
                break;
            case 11:
                strFieldValue = StrTool.GBKToUnicode(ConfIdenFlag);
                break;
            case 12:
                strFieldValue = StrTool.GBKToUnicode(AddVacFlag);
                break;
            case 13:
                strFieldValue = String.valueOf(SumMoney);
                break;
            case 14:
                strFieldValue = StrTool.GBKToUnicode(ApproveCode);
                break;
            case 15:
                strFieldValue = StrTool.GBKToUnicode(Noti);
                break;
            case 16:
                strFieldValue = StrTool.GBKToUnicode(Operator);
                break;
            case 17:
                strFieldValue = StrTool.GBKToUnicode(String.valueOf(this.
                        getMakeDate()));
                break;
            case 18:
                strFieldValue = StrTool.GBKToUnicode(MakeTime);
                break;
            case 19:
                strFieldValue = StrTool.GBKToUnicode(String.valueOf(this.
                        getModifyDate()));
                break;
            case 20:
                strFieldValue = StrTool.GBKToUnicode(ModifyTime);
                break;
            case 21:
                strFieldValue = StrTool.GBKToUnicode(BranchType);
                break;
            case 22:
                strFieldValue = StrTool.GBKToUnicode(String.valueOf(this.
                        getShouldEndDate()));
                break;
            case 23:
                strFieldValue = StrTool.GBKToUnicode(LeaveState);
                break;
            case 24:
                strFieldValue = StrTool.GBKToUnicode(BranchAttr);
                break;
            default:
                strFieldValue = "";
        }
        ;
        if (strFieldValue.equals(""))
        {
            strFieldValue = "null";
        }
        return strFieldValue;
    }

    /**
     * 设置对应传入参数的String形式的字段值
     * @param: FCode 希望取得的字段名
     * @return: FValue String形式的字段值
     *   FValue = ""  没有匹配的字段
     *   FValue = "null" 字段值为null
     **/
    public boolean setV(String FCode, String FValue)
    {
        if (StrTool.cTrim(FCode).equals(""))
        {
            return false;
        }

        if (FCode.equals("AgentCode"))
        {
            if (FValue != null && !FValue.equals(""))
            {
                AgentCode = FValue.trim();
            }
            else
            {
                AgentCode = null;
            }
        }
        if (FCode.equals("AgentGroup"))
        {
            if (FValue != null && !FValue.equals(""))
            {
                AgentGroup = FValue.trim();
            }
            else
            {
                AgentGroup = null;
            }
        }
        if (FCode.equals("ManageCom"))
        {
            if (FValue != null && !FValue.equals(""))
            {
                ManageCom = FValue.trim();
            }
            else
            {
                ManageCom = null;
            }
        }
        if (FCode.equals("Idx"))
        {
            if (FValue != null && !FValue.equals(""))
            {
                Integer tInteger = new Integer(FValue);
                int i = tInteger.intValue();
                Idx = i;
            }
        }
        if (FCode.equals("IndexCalNo"))
        {
            if (FValue != null && !FValue.equals(""))
            {
                IndexCalNo = FValue.trim();
            }
            else
            {
                IndexCalNo = null;
            }
        }
        if (FCode.equals("AClass"))
        {
            if (FValue != null && !FValue.equals(""))
            {
                AClass = FValue.trim();
            }
            else
            {
                AClass = null;
            }
        }
        if (FCode.equals("VacDays"))
        {
            if (FValue != null && !FValue.equals(""))
            {
                Integer tInteger = new Integer(FValue);
                int i = tInteger.intValue();
                VacDays = i;
            }
        }
        if (FCode.equals("LeaveDate"))
        {
            if (FValue != null && !FValue.equals(""))
            {
                LeaveDate = fDate.getDate(FValue);
            }
            else
            {
                LeaveDate = null;
            }
        }
        if (FCode.equals("EndDate"))
        {
            if (FValue != null && !FValue.equals(""))
            {
                EndDate = fDate.getDate(FValue);
            }
            else
            {
                EndDate = null;
            }
        }
        if (FCode.equals("AbsDays"))
        {
            if (FValue != null && !FValue.equals(""))
            {
                AbsDays = FValue.trim();
            }
            else
            {
                AbsDays = null;
            }
        }
        if (FCode.equals("FillFlag"))
        {
            if (FValue != null && !FValue.equals(""))
            {
                FillFlag = FValue.trim();
            }
            else
            {
                FillFlag = null;
            }
        }
        if (FCode.equals("ConfIdenFlag"))
        {
            if (FValue != null && !FValue.equals(""))
            {
                ConfIdenFlag = FValue.trim();
            }
            else
            {
                ConfIdenFlag = null;
            }
        }
        if (FCode.equals("AddVacFlag"))
        {
            if (FValue != null && !FValue.equals(""))
            {
                AddVacFlag = FValue.trim();
            }
            else
            {
                AddVacFlag = null;
            }
        }
        if (FCode.equals("SumMoney"))
        {
            if (FValue != null && !FValue.equals(""))
            {
                Double tDouble = new Double(FValue);
                double d = tDouble.doubleValue();
                SumMoney = d;
            }
        }
        if (FCode.equals("ApproveCode"))
        {
            if (FValue != null && !FValue.equals(""))
            {
                ApproveCode = FValue.trim();
            }
            else
            {
                ApproveCode = null;
            }
        }
        if (FCode.equals("Noti"))
        {
            if (FValue != null && !FValue.equals(""))
            {
                Noti = FValue.trim();
            }
            else
            {
                Noti = null;
            }
        }
        if (FCode.equals("Operator"))
        {
            if (FValue != null && !FValue.equals(""))
            {
                Operator = FValue.trim();
            }
            else
            {
                Operator = null;
            }
        }
        if (FCode.equals("MakeDate"))
        {
            if (FValue != null && !FValue.equals(""))
            {
                MakeDate = fDate.getDate(FValue);
            }
            else
            {
                MakeDate = null;
            }
        }
        if (FCode.equals("MakeTime"))
        {
            if (FValue != null && !FValue.equals(""))
            {
                MakeTime = FValue.trim();
            }
            else
            {
                MakeTime = null;
            }
        }
        if (FCode.equals("ModifyDate"))
        {
            if (FValue != null && !FValue.equals(""))
            {
                ModifyDate = fDate.getDate(FValue);
            }
            else
            {
                ModifyDate = null;
            }
        }
        if (FCode.equals("ModifyTime"))
        {
            if (FValue != null && !FValue.equals(""))
            {
                ModifyTime = FValue.trim();
            }
            else
            {
                ModifyTime = null;
            }
        }
        if (FCode.equals("BranchType"))
        {
            if (FValue != null && !FValue.equals(""))
            {
                BranchType = FValue.trim();
            }
            else
            {
                BranchType = null;
            }
        }
        if (FCode.equals("ShouldEndDate"))
        {
            if (FValue != null && !FValue.equals(""))
            {
                ShouldEndDate = fDate.getDate(FValue);
            }
            else
            {
                ShouldEndDate = null;
            }
        }
        if (FCode.equals("LeaveState"))
        {
            if (FValue != null && !FValue.equals(""))
            {
                LeaveState = FValue.trim();
            }
            else
            {
                LeaveState = null;
            }
        }
        if (FCode.equals("BranchAttr"))
        {
            if (FValue != null && !FValue.equals(""))
            {
                BranchAttr = FValue.trim();
            }
            else
            {
                BranchAttr = null;
            }
        }
        return true;
    }

    public boolean equals(Object otherObject)
    {
        if (this == otherObject)
        {
            return true;
        }
        if (otherObject == null)
        {
            return false;
        }
        if (getClass() != otherObject.getClass())
        {
            return false;
        }
        LAHolsSchema other = (LAHolsSchema) otherObject;
        return
                AgentCode.equals(other.getAgentCode())
                && AgentGroup.equals(other.getAgentGroup())
                && ManageCom.equals(other.getManageCom())
                && Idx == other.getIdx()
                && IndexCalNo.equals(other.getIndexCalNo())
                && AClass.equals(other.getAClass())
                && VacDays == other.getVacDays()
                && fDate.getString(LeaveDate).equals(other.getLeaveDate())
                && fDate.getString(EndDate).equals(other.getEndDate())
                && AbsDays.equals(other.getAbsDays())
                && FillFlag.equals(other.getFillFlag())
                && ConfIdenFlag.equals(other.getConfIdenFlag())
                && AddVacFlag.equals(other.getAddVacFlag())
                && SumMoney == other.getSumMoney()
                && ApproveCode.equals(other.getApproveCode())
                && Noti.equals(other.getNoti())
                && Operator.equals(other.getOperator())
                && fDate.getString(MakeDate).equals(other.getMakeDate())
                && MakeTime.equals(other.getMakeTime())
                && fDate.getString(ModifyDate).equals(other.getModifyDate())
                && ModifyTime.equals(other.getModifyTime())
                && BranchType.equals(other.getBranchType())
                && fDate.getString(ShouldEndDate).equals(other.getShouldEndDate())
                && LeaveState.equals(other.getLeaveState())
                && BranchAttr.equals(other.getBranchAttr());
    }

    /**
     * 取得Schema拥有字段的数量
     **/
    public int getFieldCount()
    {
        return FIELDNUM;
    }

    /**
     * 取得Schema中指定字段名所对应的索引值
     * 如果没有对应的字段，返回-1
     **/
    public int getFieldIndex(String strFieldName)
    {
        if (strFieldName.equals("AgentCode"))
        {
            return 0;
        }
        if (strFieldName.equals("AgentGroup"))
        {
            return 1;
        }
        if (strFieldName.equals("ManageCom"))
        {
            return 2;
        }
        if (strFieldName.equals("Idx"))
        {
            return 3;
        }
        if (strFieldName.equals("IndexCalNo"))
        {
            return 4;
        }
        if (strFieldName.equals("AClass"))
        {
            return 5;
        }
        if (strFieldName.equals("VacDays"))
        {
            return 6;
        }
        if (strFieldName.equals("LeaveDate"))
        {
            return 7;
        }
        if (strFieldName.equals("EndDate"))
        {
            return 8;
        }
        if (strFieldName.equals("AbsDays"))
        {
            return 9;
        }
        if (strFieldName.equals("FillFlag"))
        {
            return 10;
        }
        if (strFieldName.equals("ConfIdenFlag"))
        {
            return 11;
        }
        if (strFieldName.equals("AddVacFlag"))
        {
            return 12;
        }
        if (strFieldName.equals("SumMoney"))
        {
            return 13;
        }
        if (strFieldName.equals("ApproveCode"))
        {
            return 14;
        }
        if (strFieldName.equals("Noti"))
        {
            return 15;
        }
        if (strFieldName.equals("Operator"))
        {
            return 16;
        }
        if (strFieldName.equals("MakeDate"))
        {
            return 17;
        }
        if (strFieldName.equals("MakeTime"))
        {
            return 18;
        }
        if (strFieldName.equals("ModifyDate"))
        {
            return 19;
        }
        if (strFieldName.equals("ModifyTime"))
        {
            return 20;
        }
        if (strFieldName.equals("BranchType"))
        {
            return 21;
        }
        if (strFieldName.equals("ShouldEndDate"))
        {
            return 22;
        }
        if (strFieldName.equals("LeaveState"))
        {
            return 23;
        }
        if (strFieldName.equals("BranchAttr"))
        {
            return 24;
        }
        return -1;
    }

    /**
     * 取得Schema中指定索引值所对应的字段名
     * 如果没有对应的字段，返回""
     **/
    public String getFieldName(int nFieldIndex)
    {
        String strFieldName = "";
        switch (nFieldIndex)
        {
            case 0:
                strFieldName = "AgentCode";
                break;
            case 1:
                strFieldName = "AgentGroup";
                break;
            case 2:
                strFieldName = "ManageCom";
                break;
            case 3:
                strFieldName = "Idx";
                break;
            case 4:
                strFieldName = "IndexCalNo";
                break;
            case 5:
                strFieldName = "AClass";
                break;
            case 6:
                strFieldName = "VacDays";
                break;
            case 7:
                strFieldName = "LeaveDate";
                break;
            case 8:
                strFieldName = "EndDate";
                break;
            case 9:
                strFieldName = "AbsDays";
                break;
            case 10:
                strFieldName = "FillFlag";
                break;
            case 11:
                strFieldName = "ConfIdenFlag";
                break;
            case 12:
                strFieldName = "AddVacFlag";
                break;
            case 13:
                strFieldName = "SumMoney";
                break;
            case 14:
                strFieldName = "ApproveCode";
                break;
            case 15:
                strFieldName = "Noti";
                break;
            case 16:
                strFieldName = "Operator";
                break;
            case 17:
                strFieldName = "MakeDate";
                break;
            case 18:
                strFieldName = "MakeTime";
                break;
            case 19:
                strFieldName = "ModifyDate";
                break;
            case 20:
                strFieldName = "ModifyTime";
                break;
            case 21:
                strFieldName = "BranchType";
                break;
            case 22:
                strFieldName = "ShouldEndDate";
                break;
            case 23:
                strFieldName = "LeaveState";
                break;
            case 24:
                strFieldName = "BranchAttr";
                break;
            default:
                strFieldName = "";
        }
        ;
        return strFieldName;
    }

    /**
     * 取得Schema中指定字段名所对应的字段类型
     * 如果没有对应的字段，返回Schema.TYPE_NOFOUND
     **/
    public int getFieldType(String strFieldName)
    {
        if (strFieldName.equals("AgentCode"))
        {
            return Schema.TYPE_STRING;
        }
        if (strFieldName.equals("AgentGroup"))
        {
            return Schema.TYPE_STRING;
        }
        if (strFieldName.equals("ManageCom"))
        {
            return Schema.TYPE_STRING;
        }
        if (strFieldName.equals("Idx"))
        {
            return Schema.TYPE_INT;
        }
        if (strFieldName.equals("IndexCalNo"))
        {
            return Schema.TYPE_STRING;
        }
        if (strFieldName.equals("AClass"))
        {
            return Schema.TYPE_STRING;
        }
        if (strFieldName.equals("VacDays"))
        {
            return Schema.TYPE_INT;
        }
        if (strFieldName.equals("LeaveDate"))
        {
            return Schema.TYPE_DATE;
        }
        if (strFieldName.equals("EndDate"))
        {
            return Schema.TYPE_DATE;
        }
        if (strFieldName.equals("AbsDays"))
        {
            return Schema.TYPE_STRING;
        }
        if (strFieldName.equals("FillFlag"))
        {
            return Schema.TYPE_STRING;
        }
        if (strFieldName.equals("ConfIdenFlag"))
        {
            return Schema.TYPE_STRING;
        }
        if (strFieldName.equals("AddVacFlag"))
        {
            return Schema.TYPE_STRING;
        }
        if (strFieldName.equals("SumMoney"))
        {
            return Schema.TYPE_DOUBLE;
        }
        if (strFieldName.equals("ApproveCode"))
        {
            return Schema.TYPE_STRING;
        }
        if (strFieldName.equals("Noti"))
        {
            return Schema.TYPE_STRING;
        }
        if (strFieldName.equals("Operator"))
        {
            return Schema.TYPE_STRING;
        }
        if (strFieldName.equals("MakeDate"))
        {
            return Schema.TYPE_DATE;
        }
        if (strFieldName.equals("MakeTime"))
        {
            return Schema.TYPE_STRING;
        }
        if (strFieldName.equals("ModifyDate"))
        {
            return Schema.TYPE_DATE;
        }
        if (strFieldName.equals("ModifyTime"))
        {
            return Schema.TYPE_STRING;
        }
        if (strFieldName.equals("BranchType"))
        {
            return Schema.TYPE_STRING;
        }
        if (strFieldName.equals("ShouldEndDate"))
        {
            return Schema.TYPE_DATE;
        }
        if (strFieldName.equals("LeaveState"))
        {
            return Schema.TYPE_STRING;
        }
        if (strFieldName.equals("BranchAttr"))
        {
            return Schema.TYPE_STRING;
        }
        return Schema.TYPE_NOFOUND;
    }

    /**
     * 取得Schema中指定索引值所对应的字段类型
     * 如果没有对应的字段，返回Schema.TYPE_NOFOUND
     **/
    public int getFieldType(int nFieldIndex)
    {
        int nFieldType = Schema.TYPE_NOFOUND;
        switch (nFieldIndex)
        {
            case 0:
                nFieldType = Schema.TYPE_STRING;
                break;
            case 1:
                nFieldType = Schema.TYPE_STRING;
                break;
            case 2:
                nFieldType = Schema.TYPE_STRING;
                break;
            case 3:
                nFieldType = Schema.TYPE_INT;
                break;
            case 4:
                nFieldType = Schema.TYPE_STRING;
                break;
            case 5:
                nFieldType = Schema.TYPE_STRING;
                break;
            case 6:
                nFieldType = Schema.TYPE_INT;
                break;
            case 7:
                nFieldType = Schema.TYPE_DATE;
                break;
            case 8:
                nFieldType = Schema.TYPE_DATE;
                break;
            case 9:
                nFieldType = Schema.TYPE_STRING;
                break;
            case 10:
                nFieldType = Schema.TYPE_STRING;
                break;
            case 11:
                nFieldType = Schema.TYPE_STRING;
                break;
            case 12:
                nFieldType = Schema.TYPE_STRING;
                break;
            case 13:
                nFieldType = Schema.TYPE_DOUBLE;
                break;
            case 14:
                nFieldType = Schema.TYPE_STRING;
                break;
            case 15:
                nFieldType = Schema.TYPE_STRING;
                break;
            case 16:
                nFieldType = Schema.TYPE_STRING;
                break;
            case 17:
                nFieldType = Schema.TYPE_DATE;
                break;
            case 18:
                nFieldType = Schema.TYPE_STRING;
                break;
            case 19:
                nFieldType = Schema.TYPE_DATE;
                break;
            case 20:
                nFieldType = Schema.TYPE_STRING;
                break;
            case 21:
                nFieldType = Schema.TYPE_STRING;
                break;
            case 22:
                nFieldType = Schema.TYPE_DATE;
                break;
            case 23:
                nFieldType = Schema.TYPE_STRING;
                break;
            case 24:
                nFieldType = Schema.TYPE_STRING;
                break;
            default:
                nFieldType = Schema.TYPE_NOFOUND;
        }
        ;
        return nFieldType;
    }
}

hbuzhang
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 2
    评论
专栏目录
深入理解Avro和SchemaRegistry
禅与计算机程序设计艺术
08-01 1844
数据序列化与反序列化是数据传输、存储等领域中一个重要且基础的环节。Apache Avro 是 Apache 的一款开源的高性能数据序列化框架，它提供了数据序列化的语言无关性，支持复杂的数据结构，并且提供对数据 evolution（演进）的兼容性保证。Schema Registry 是一个独立于平台的服务，用于存储 Avro 消息的 schema。本文将详细阐述 Avro 和 Schema Registry 的相关知识点及其运作方式。
接口测试框架实战（四）| 搞定 Schema 断言
ceshiren456的博客
08-02 210
JSON Schema 是描述 JSON 数据结构的一种格式，JSON Schema 模式是一个词汇表。通过 JSON Schema 可以注释 JSON 的字段以及字段数据类型等信息。在实际工作中，对接口返回值进行断言校验，除了常用字段的断言检测以外，还要对其他字段的类型进行检测。对返回的字段一个个写断言显然是非常耗时的，这个时候就需要一个模板，可以定义好数据类型和匹配条件，除了关键参数外，其余可直接通过此模板来断言，Json Schema 可以完美实现这样的需求。...
接口测试 & Json Schema
10-30 614
测试xml用过类似的方法xmllint，如果只是对结果进行基本的检查，利用弱类型语言的特性，使用Python进行反序列化即可验证文件格式是否正确，但如果需要进行类型、数值范围等逻辑测试，通过Json Schema非常适合。Json Schema是定义Json数据约束的一个标准，数据发送方、接收方都可以通过这个约定，进行数据验证保证交换数据的正确性。描述已知的数据格式；提供人类和机器都可以清晰阅读的文档；为以下场景的数据验证提供帮助；自动化测试；确保用户提交的数据质量。
接口测试之JSON Schema
行走在路上
12-07 564
JSON Schema简介： json是数据交互的常用数据格式，JSON Schema是对json数据约束的一个标准。 JSON Schema官网： JSON Schema | The home of JSON Schema JSON Schema官网教程： Getting Started Step-By-Step | JSON Schema JSON Schema校验工具： JSON Schema Validator - Newtonsoft JSON Schema使用方式： Json
Python 数据接口schema定义与检查（pydantic）
weixin_40123451的博客
05-25 902
摘要：https://blog.csdn.net/codename_cys/article/details/107675748
iOS中使用schema协议调用APP和使用iframe打开APP的例子
09-04
在iOS开发中，为了实现从Web页面调用和打开应用程序，有两种主要方法：schema协议和Smart App Banner。本文将重点介绍使用schema协议和iframe来打开iOS应用。 首先，schema协议是一种自定义URL协议，允许开发者定义...
typescript-interface-to-jsonschema:将TypeScript接口（以代码形式）转换为JSON-Schemata
05-09
跑步 sudo npm install -g typescript （如果您还没有的话） sudo npm install -g JSV （验证所需） ... tsc --out ifacejson.js ... 可以在 + 上找到用Java而不是JS实现的从TypeScript到JSON Schema的类似转换器。
JAVA Json-Schema接口校验利器
热门推荐
BugRoot的博客
08-04 1万+
何为Json-Schema Json-schema是描述你的JSON数据格式；JSON模式（应用程序/模式+ JSON）有多种用途，其中之一就是实例验证。验证过程可以是交互式或非交互式的。例如，应用程序可以使用JSON模式来构建用户界面使互动的内容生成除了用户输入检查或验证各种来源获取的数据。（来自百度百科） 相关jar包 <dependency> <groupId>com.github.fge</groupId> <artifactId&g
MySQL源码详解三 performance_schema接口实现的一些主意事项
u010220902的博客
11-27 1678
看PERFORMANCE_SCHEMA的默认实现的代码之前先看一下他的接口设计思路，下面截选出自pfs.cc的注释   PERFORMANCE_SCHEMA是一种内省服务端运行时内部执行情况的办法，INFORMATION_SCHEMA主要用来观察数据库元信息的，而他专注于数据库的表现信息   对于用户来说他的表现形势就是一个专用的数据库，叫做PERFORMANCE_SCHEMA，其中的表可
接口开发中jsonschema的使用
weixin_30477293的博客
05-13 567
1.导入模块 import jsonschema from jsonschema import schemas,validators from jsonschema.validators import Draft4Validator 2.自定义参数校验规则 schema = { 'description': '对请求json数据参数进行校验', 'ty...
Scheme的数据类型
Besich的专栏
04-23 2360
    Scheme中的数据非常之丰富！总的来说分两种，一种是简单数据类型，一种是复合数据类型。 简单数据类型中，又包含逻辑型，数值性，字符型和符号型这四种数据类型。 复杂数据类型，包含字符串型，向量型，点对型，和列表型。下面分别简要介绍这些。1：逻辑型    这没什么好说的，就个真假问题，对应的数值是#t, #f这点请和c++中的true，false区别开来。
swagger2 同一个实体用在多个不同的controller接口展示不同的字段
qq_28326501的博客
04-24 2134
一、自定义注解。 一个用于排除，一个用于需要。 package com.yx.common.swagger; import java.lang.annotation.ElementType; import java.lang.annotation.Retention; import java.lang.annotation.RetentionPolicy; import java.lang.annotation.Target; /** * 自定义aop注解 支持swagger的动态属性 ..
详解JAVA中的@Schema注解
最新发布
码农研究僧的博客
04-30 9322
在 Swagger 3 中，引入了 @Schema 注解来描述数据模型，用于取代 Swagger 2 中的 @ApiModelProperty
Schema约束、Http协议、WebService服务学习笔记
苏格拉没有底xx的博客
10-23 4248
Web service是什么？ 1.基于Web的服务，服务器端整出一些资源让客户端应用访问（获取数据）。 2.一个跨语言、跨平台的规范（抽象）。 3.多个跨平台、跨语言的应用间通信整合的方案（实际）。
将Schema文件转换为Java文件
姚双双 廊坊师范学院七期信息技术提高班
11-30 1955
可通过xjc命令完成将schema文件转换为java文件。 打开命令控制台，切换至项目中xsd文件所在目录，如E:\Eclipse\webservice\03_schema\src\schema 输入命令：xjc -d  -verbose 如：xjc -d E:\Eclipse\webserviceimport\02 -verbose classroom.xsd 生成的Java文件：
Schema详解1
写自己的代码，让别人去看吧
03-22 947
simpleType 详解 simpleType元素作用是定义一个简单类型决定了元素的属性值的约束和相关的信息。 restriction定义一个约束条件 test5.xsd http://www.w3.org/2001/XMLSchema" elementFormDefault ="qualified"   attributeFormDefault="unqualified">
详解Schema
yuan_xw的专栏
07-08 2549
Schema(important!) 1.XML Schema是用一种套预选规定好的XML元素和属性创建的，这些元素和属性定义了XML文档的结构和内容模式。  2.XML Schema是规定XML文档实例的结构和每个元素/属性的数据类型。   SQL-------------->Xpath   数据库----------->XML文档   表结构----------->Schema
mybatisplus实现多租户多schema
07-28
MyBatis Plus可以很好地支持多租户多schema的实现。下面是一些步骤和建议： 1. 配置数据源：为每个租户创建一个独立的数据库schema，配置数据源时，可以根据租户信息动态切换数据源或者动态切换schema。 2. 实现多租户解析器：创建一个实现MultiTenantHandler接口的类，用于解析当前请求的租户信息。可以通过请求头、请求参数、ThreadLocal等方式获取租户标识。 3. 配置MyBatis Plus插件：使用MyBatis Plus提供的插件功能，配置多租户插件。可以通过继承AbstractInterceptor类并实现intercept()方法，根据当前的租户信息动态修改SQL语句的表名或者schema。 4. 配置MyBatis Plus全局配置：在MyBatis Plus的全局配置文件中，开启多租户模式，设置多租户解析器和多租户插件。 5. 编写Mapper接口和SQL语句：在Mapper接口中，使用@TableName注解指定表名的占位符，例如`@TableName("{user}")`。在SQL语句中，使用`#{T(com.example.TenantContextHolder).getTenantId()}`获取租户标识，并在需要动态修改表名或者schema的地方使用占位符。 通过以上步骤，你就可以实现多租户多schema的功能了。希望对你有所帮助！如果还有其他问题，请继续提问。
评论 2
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值