作为系统分析员，我开发了一个映射表各列的类对象，以便可以调用存储过程以json数组的形式返回类对象的列表。在检查表的SQL结构的整个过程中，有一个由LOOKUP_CODE和LOOKUP_TYPE组成的复合键。

sql数据库是Oracle 9i

结果： 某些字段缺少返回

在这种情况下，请您设计策略以匹配列吗？

这是我的表格列：

这是SQL：

 CREATE TABLE "PC_LOOKUP" 
   (    "LOOKUP_TYPE" VARCHAR2(30 BYTE) NOT NULL ENABLE,"LOOKUP_CODE" VARCHAR2(30 BYTE) NOT NULL ENABLE,"LOOKUP_VALUE" VARCHAR2(100 BYTE) NOT NULL ENABLE,"LOOKUP_DESC" VARCHAR2(200 BYTE),"LAST_UPD_DATE" DATE NOT NULL ENABLE,"LAST_UPD_BY" VARCHAR2(8 BYTE) NOT NULL ENABLE,CONSTRAINT "B_PC_LOOKUP_PK" PRIMARY KEY ("LOOKUP_TYPE","LOOKUP_CODE")

这是我的课程（LookUp.java）：

@NamedStoredProcedureQueries（{

   @NamedStoredProcedureQuery(name = "call_look_up_list",procedureName = "pkg.get_pc_lookup_value",parameters = {
                                 @StoredProcedureParameter(mode = ParameterMode.IN,name = "i_lookup_type",type = String.class),@StoredProcedureParameter(mode = ParameterMode.IN,name = "i_lookup_code",@StoredProcedureParameter(mode = ParameterMode.REF_CURSOR,name = "o_lookup_value",type =  void.class)
                              }),@NamedStoredProcedureQuery(name = "call_look_up_single",procedureName = "pkg.get_pc_lookup_value_prim",@StoredProcedureParameter(mode = ParameterMode.OUT,type = String.class)
                              })
})


public class LookUp implements Serializable{

    @Transient
    private static final long serialVersionUID = 3506968846904417333L;


    @Column(nullable = false,insertable = false,updatable=false,name = "LAST_UPD_BY" )
    private String lastUpdateBy;    

    @Column(nullable = false,columnDefinition = "TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP",name = "LAST_UPD_DATE")  
    private Date lastUpdateDate = new Date();


    @EmbeddedId
    private LookUpCompositeKey privateKey;

    @Column(nullable = true,name = "LOOKUP_DESC")
    private String desc;

    @Column(nullable = false,name = "LOOKUP_VALUE")
    private String value; 

这是我的课程：（LookUpCompositeKey .java）

@Embeddable
public class LookUpCompositeKey implements Serializable {

    private static final long serialVersionUID = -5628924656701586906L;


    @Column(  name = "LOOKUP_TYPE")
    String  type;

    @Column( name = "LOOKUP_CODE")
    String  code;


    public LookUpCompositeKey() {

    }