对象字段java_访问 Java 对象的字段和方法

-- Invoice.init takes a string argument (Ljava/lang/String;)

-- a double (D), a string argument (Ljava/lang/String;), and

-- another double (D), and returns nothing (V)

CREATE PROCEDURE init( IN arg1 CHAR(50),

IN arg2 DOUBLE,

IN arg3 CHAR(50),

IN arg4 DOUBLE)

EXTERNAL NAME

'Invoice.init(Ljava/lang/String;DLjava/lang/String;D)V'

LANGUAGE JAVA;

-- Invoice.rateOfTaxation take no arguments ()

-- and returns a double (D)

CREATE FUNCTION rateOfTaxation()

RETURNS DOUBLE

EXTERNAL NAME

'Invoice.rateOfTaxation()D'

LANGUAGE JAVA;

-- Invoice.rateOfTaxation take no arguments ()

-- and returns a double (D)

CREATE FUNCTION totalSum()

RETURNS DOUBLE

EXTERNAL NAME

'Invoice.totalSum()D'

LANGUAGE JAVA;

-- Invoice.getLineItem1Description take no arguments ()

-- and returns a string (Ljava/lang/String;)

CREATE FUNCTION getLineItem1Description()

RETURNS CHAR(50)

EXTERNAL NAME

'Invoice.getLineItem1Description()Ljava/lang/String;'

LANGUAGE JAVA;

-- Invoice.getLineItem1Cost take no arguments ()

-- and returns a double (D)

CREATE FUNCTION getLineItem1Cost()

RETURNS DOUBLE

EXTERNAL NAME

'Invoice.getLineItem1Cost()D'

LANGUAGE JAVA;

-- Invoice.getLineItem2Description take no arguments ()

-- and returns a string (Ljava/lang/String;)

CREATE FUNCTION getLineItem2Description()

RETURNS CHAR(50)

EXTERNAL NAME

'Invoice.getLineItem2Description()Ljava/lang/String;'

LANGUAGE JAVA;

-- Invoice.getLineItem2Cost take no arguments ()

-- and returns a double (D)

CREATE FUNCTION getLineItem2Cost()

RETURNS DOUBLE

EXTERNAL NAME

'Invoice.getLineItem2Cost()D'

LANGUAGE JAVA;