对象继承的例子:CREATE TYPE address_t AS OBJECT
EXTERNAL NAME 'Examples.Address' LANGUAGE JAVA
USING SQLData(
street_attr varchar(250) EXTERNAL NAME 'street',
city_attr varchar(50) EXTERNAL NAME 'city',
state varchar(50) EXTERNAL NAME 'state',
zip_code_attr number EXTERNAL NAME 'zipCode',
STATIC FUNCTION recom_width RETURN NUMBER
EXTERNAL VARIABLE NAME 'recommendedWidth',
STATIC FUNCTION create_address RETURN address_t
EXTERNAL NAME 'create() return Examples.Address',
STATIC FUNCTION construct RETURN address_t
EXTERNAL NAME 'create() return Examples.Address',
STATIC FUNCTION create_address (street VARCHAR, city VARCHAR,
state VARCHAR, zip NUMBER) RETURN address_t
EXTERNAL NAME 'create (java.lang.String, java.lang.String,
java.lang.String, int) return Examples.Address',
STATIC FUNCTION construct (street VARCHAR, city VARCHAR,
state VARCHAR, zip NUMBER) RETURN address_t
EXTERNAL NAME
'create (java.lang.String, java.lang.String,
java.lang.String, int) return Examples.Address',
MEMBER FUNCTION to_string RETURN VARCHAR
EXTERNAL NAME 'tojava.lang.String() return java.lang.String',
MEMBER FUNCTION strip RETURN SELF AS RESULT
EXTERNAL NAME 'removeLeadingBlanks () return Examples.Address'
) NOT FINAL;CREATE OR REPLACE TYPE long_address_t
UNDER address_t
EXTERNAL NAME 'Examples.LongAddress' LANGUAGE JAVA
USING SQLData(
street2_attr VARCHAR(250) EXTERNAL NAME 'street2',
country_attr VARCHAR (200) EXTERNAL NAME 'country',
address_code_attr VARCHAR (50) EXTERNAL NAME 'addrCode',
STATIC FUNCTION create_address RETURN long_address_t
EXTERNAL NAME 'create() return Examples.LongAddress',
STATIC FUNCTION construct (street VARCHAR, city VARCHAR,
state VARCHAR, country VARCHAR, addrs_cd VARCHAR)
RETURN long_address_t
EXTERNAL NAME
'create(java.lang.String, java.lang.String,
java.lang.String, java.lang.String, java.lang.String)
return Examples.LongAddress',
STATIC FUNCTION construct RETURN long_address_t
EXTERNAL NAME 'Examples.LongAddress()
return Examples.LongAddress',
STATIC FUNCTION create_longaddress (
street VARCHAR, city VARCHAR, state VARCHAR, country VARCHAR,
addrs_cd VARCHAR) return long_address_t
EXTERNAL NAME
'Examples.LongAddress (java.lang.String, java.lang.String,
java.lang.String, java.lang.String, java.lang.String)
return Examples.LongAddress',
MEMBER FUNCTION get_country RETURN VARCHAR
EXTERNAL NAME 'country_with_code () return java.lang.String'
);
EXTERNAL NAME 'Examples.Address' LANGUAGE JAVA
USING SQLData(
street_attr varchar(250) EXTERNAL NAME 'street',
city_attr varchar(50) EXTERNAL NAME 'city',
state varchar(50) EXTERNAL NAME 'state',
zip_code_attr number EXTERNAL NAME 'zipCode',
STATIC FUNCTION recom_width RETURN NUMBER
EXTERNAL VARIABLE NAME 'recommendedWidth',
STATIC FUNCTION create_address RETURN address_t
EXTERNAL NAME 'create() return Examples.Address',
STATIC FUNCTION construct RETURN address_t
EXTERNAL NAME 'create() return Examples.Address',
STATIC FUNCTION create_address (street VARCHAR, city VARCHAR,
state VARCHAR, zip NUMBER) RETURN address_t
EXTERNAL NAME 'create (java.lang.String, java.lang.String,
java.lang.String, int) return Examples.Address',
STATIC FUNCTION construct (street VARCHAR, city VARCHAR,
state VARCHAR, zip NUMBER) RETURN address_t
EXTERNAL NAME
'create (java.lang.String, java.lang.String,
java.lang.String, int) return Examples.Address',
MEMBER FUNCTION to_string RETURN VARCHAR
EXTERNAL NAME 'tojava.lang.String() return java.lang.String',
MEMBER FUNCTION strip RETURN SELF AS RESULT
EXTERNAL NAME 'removeLeadingBlanks () return Examples.Address'
) NOT FINAL;CREATE OR REPLACE TYPE long_address_t
UNDER address_t
EXTERNAL NAME 'Examples.LongAddress' LANGUAGE JAVA
USING SQLData(
street2_attr VARCHAR(250) EXTERNAL NAME 'street2',
country_attr VARCHAR (200) EXTERNAL NAME 'country',
address_code_attr VARCHAR (50) EXTERNAL NAME 'addrCode',
STATIC FUNCTION create_address RETURN long_address_t
EXTERNAL NAME 'create() return Examples.LongAddress',
STATIC FUNCTION construct (street VARCHAR, city VARCHAR,
state VARCHAR, country VARCHAR, addrs_cd VARCHAR)
RETURN long_address_t
EXTERNAL NAME
'create(java.lang.String, java.lang.String,
java.lang.String, java.lang.String, java.lang.String)
return Examples.LongAddress',
STATIC FUNCTION construct RETURN long_address_t
EXTERNAL NAME 'Examples.LongAddress()
return Examples.LongAddress',
STATIC FUNCTION create_longaddress (
street VARCHAR, city VARCHAR, state VARCHAR, country VARCHAR,
addrs_cd VARCHAR) return long_address_t
EXTERNAL NAME
'Examples.LongAddress (java.lang.String, java.lang.String,
java.lang.String, java.lang.String, java.lang.String)
return Examples.LongAddress',
MEMBER FUNCTION get_country RETURN VARCHAR
EXTERNAL NAME 'country_with_code () return java.lang.String'
);
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货