KS X ISO IEC 9075-10-2011 Information technology－Database language SQLPart 10：Object Language Bindings(SQL OLB)《信息技术 数据库语言 结构化查询语言(SQL) 第10部分 对象语言绑定(SQL OLB)》.pdf

1、 KSKSKSKSKSKSKSK KSKSKS KSKSK KSKS KSK KS KS X ISO/IEC 9075 10 SQL 10： (SQL/OLB)KS X ISO/IEC 9075 10:2011 2011 12 30 http:/www.kats.go.krKS X ISO/IEC 9075 10:2011 : e ( ) ( ) () () ( ) : (COSD) ( ) : (http:/www.standard.go.kr) ： ：2002 11 20 ：2011 12 30 2011-0676 ： e ： (COSD) ( 025097262) (http:/www.

2、kats.go.kr). 10 5 , . KS X ISO/IEC 9075 10:2011 i . iv v 1 1 2 2 2.1 ISO IEC .2 2.2 .2 3 , .3 3.1 .3 3.2 (Conventions) 5 4 7 4.1 (Embeded syntax) 7 4.2 (Character strings) .7 4.3 SQLJ 7 5 (Lexical elements) .46 5.1 46 5.2 47 6 (Scalar expressions) 48 6.1 48 7 (Additional common elements) .49 7.1 .49

3、 8 SQL(Embedded SQL) 50 8.1 50 8.2 .53 9 SQL (SQL reserved names) 54 9.1 54 9.2 (Temporary varible names) 54 9.3 (Class and resource file names) .54 10 (Common subelements).56 10.1 56 10.2 .57 10.3 58 10.4 .59 10.5 .60 10.6 61 10.7 .63 10.8 64 11 .67 11.1 67 11.2 .68 11.3 .69 KS X ISO/IEC 9075 10:20

4、11 ii 11.4 74 11.5 76 11.6 (Generated positioned iterator class) 77 11.7 79 11.8 (Generated named iterator class).80 11.9 82 11.10 88 11.11 89 11.12 90 11.13 .92 11.14 .93 11.15 97 11.16 100 11.17 .102 11.18 103 11.19 104 11.20 105 11.21 106 11.22 .107 11.23 .109 11.24 111 11.25 .115 11.26 .117 11.2

5、7 .120 12 sqlj.runtime(Package sqlj.runtime)122 12.1 122 12.2 SQLJ (SQLJ runtime interfaces) 122 12.3 SQLJ (SQLJ Runtime Classes) .138 13 sqlj.runtime.profile.165 13.1 165 13.2 SQLJ sqlj.runtime.profile 165 13.3 SQLJ sqlj.runtime.profile (SQLJ sqlj.runtime.profile Classes) .253 14 sqlj.runtime.profi

6、le.util.ProfileCustomizer 287 14.1 287 14.2 .288 15 .291 15.1 SQLSTATE 291 16 292 16.1 SQL/OLB (Claims of conformance to SQL/OLB)292 16.2 SQL/OLB 292 16.3 SQL/OLB (Implied feature relationships of SQL/OLB) .292 A( ) SQL 293 B( ) .295 C( ) .298 D( ) 300 KS X ISO/IEC 9075 10:2011 iii E( ) ISO/IEC 9075

7、： 2003 .301 F( ) SQL 302 G( ) .303 H( ) SQLJ .304 320 1 SQLJ .12 2 SQLJ (SQLJ type properties) 15 3 SQLJ (part 1)23 4 SQLJ (part 2)24 5 SQLJ (part 3)25 6 SQLJ (part 4)26 7 SQLJ (part 1)27 8 SQLJ (part 2)28 9 SQLJ (part 3)29 10 SQLJ (part 4)30 11 java.sql.ResultSet 173 12 java.sql.ResultSet .174 13 R

8、TResultSet .174 14 java.sql.Statement .202 15 java.sql.Statement 202 16 java.sql.PreparedStatement 203 17 java.sql.PreparedStatement .204 18 java.sql.CallableStatement 204 19 java.sql.CallableStatement .205 20 RTStatement 205 21 .288 22 SQLSTATE .291 23 SQL/OLB .292 F.1 .302 KS X ISO/IEC 9075 10:201

9、1 iv . KS X ISO/IEC 9075 10： 2007 . . , , . , , . SQL SQL . SQL “SQLJ” . SQLJ SQLJ . . KS X ISO/IEC 9075 “ SQL” . 1： (SQL/ ) 2： (SQL/ ) 3： (SQL/CLI) 4： (SQL/PSM) 9： (SQL/MED) 10： (SQL/OLB) 11： (SQL/Schemata) 13： SQL (SQL/JRT) 14： XML (SQL/XML) KS X ISO/IEC 9075 10:2011 v 2008 3 ISO/IEC 9075 10, Info

10、rmation technology Database language SQL Part 10： Object Language Bindings(SQL/OLB) . . 1) 1 , “ ” . 2) 2 , “ ” . 3) 3 , “ , ” . 4) 4 , “ ” . 5) 5 , “ ” . 6) 6 , “ ” . 7) 7 , “ ” . 8) 8 , “ SQL” . 9) 9 , “SQL ” SQLJ . 10) 10 , “ ” SQLJ . 11) 11 , “ ” SQLJ . 12) 12 , “ sqlj.runtime” SQLJ . 13) 13 , “

11、 sqlj.runtime.profile” SQLJ . 14) 14 , “sqlj.runtime.profile.util.ProfileCustomizer” SQLJ . 15) 15 , “ ” SQLSTATE . 16) 16 , “ ” . 17) A, “SQL ” . SQL . 18) B, “ ” . SQL , , . 19) C, “ ” . SQL , , . 20) D, “ ” . . 21) E, “ISO/IEC 9075： 2003 ” . . 22) F, “SQL ” . SQL . SQL . 23) G, “ ” . . , . 24) H,

12、 “SQLJ ” . SQL . KS X ISO/IEC 9075 10:2011 SQL 1： (SQL/OLB) Information technology Database language SQL Part 10： Object Language Bindings(SQL/OLB) 1 KS X ISO/IEC 9075 2 Ada, C, COBOL, Fortran, MUMPS, Pascal PL/1 SQL . , (JavaTM) SQL SQL . SQL Java “SQLJ” . SQLJ SQLJ . , Java ( ). , “SQLJ” “SQL/OLB”

13、 . KS X ISO/IEC 9075 10:2011 2 2 . . ( ) . 2.1 ISO IEC KS X ISO/IEC 9075 1： 2011, SQL Part 1： (SQL/Framework) KS X ISO/IEC 9075 2： 2011, SQL Part 2： (SQL/Foundation) 2.2 Unicode The Unicode Consortium, The Unicode Standard(Information about the latest version of the Unicode standard can be found by

14、using the “Latest Unicode Version“ link on the “Enumerated Versions of The Unicode Standard“ page.) http:/www.unicode.org/versions/enumeratedversions.html Java The Java Language Specification, Third Edition, James Gosling, Bill Joy, Guy Steele, and Gilad Bracha, Prentice Hall, June 14, 2005, ISBN 0

15、321 24678 0 JDBC JDBC 4.0 Specification, Final v1.0, Lance Andersen, Sun Microsystems, Inc., November 7, 2006 JNDI Java Naming and Directory Interface, Sun Microsystems, Inc. http:/ JavaBeans The JavaBeans 1.01 Specification http:/ KS X ISO/IEC 9075 10:2011 3 3 , KS X ISO/IEC 9075 2 3. “ , , ” . 3.1

16、 KS X ISO/IEC 9075 2 3.1 “ ” . 3.1.1 . 3.1.1.1 (accessor method) (result set iterator object) . (named) (positioned) . . . . . 3.1.1.2 (customization) SQLJ SQL SQL . , SQLJ - . 3.1.1.3 (generated connection class) SQL- . Java . 3.1.1.4 (generated iterator class) (result set iterators) SQL . . , . ,

17、. 3.1.1.5 getter RTStatement RTResultSet . KS X ISO/IEC 9075 10:2011 4 3.1.1.6 (implementation specific) SQL , SQL . 3.1.1.7 SQL_J (installation of an SQL_J application) SQLJ SQL SQL . 3.1.1.8 Java (Java primitive datatype) . a) boolean, byte, short, int, long, float double 1 JDBC , Java char . 3.1.

18、1.9 l value (l value expression) Java Java (lefthanddside) Java . , , , l value . 3.1.1.10 (profile) SQLJ Java SQL SQL . SQLJ . 3.1.1.11 (profile file) SQLJ 3.1.1.12 (runtime library component) SQLJ , . JDBC- ( , java.sql.Statement RTStatement ) . 3.1.1.13 setter (setter method) RTStatement RTStatem

19、ent , SQL . 3.1.1.14 SQL_J (SQL_J file) .sqlj( sqlj) SQL_J Java SQL_J (constructs) . KS X ISO/IEC 9075 10:2011 5 3.1.1.15 SQL_J (SQL_J translation) SQL Java , SQL SQLJ API Java Java , . 3.1.1.16 SQL_J (SQL_J translation unit) SQLJ , SQLJ SQLJ Java . 3.2 (Conventions) KS X ISO/IEC 9075 2 3.3 “ ” . (

20、) , . 3.2.1 KS X ISO/IEC 9075 2 3.3.1 “ ” . 3.2.1.1 KS X ISO/IEC 9075 2 3.3.1.1 “ ” . ( ) , “ ” “Java (java type object) ” , Java Java . Java Java “Java ” Java Java . ( ) Java Java , “Java ” . Java Java ( ) . (connection context object) SQLJ . sqlj.runtime.Connection Context . (execution context obj

21、ect) sqlj.runtime.ExecutionContext . (named iterator) SQLJ . sqlj.runtime. NamedIterator . (positioned iterator) SQLJ . sqlj.runtime.PositionedIterator . KS X ISO/IEC 9075 10:2011 6 . 3.2.2 (Specification of translator generated classes) KS X ISO/IEC 9075 1 , . . 10. “ ” 11. “ ” . (Function) . (Sign

22、ature) . (Definitions and Rules) . EntryInfo (Profile EntryInfo Properties) EntryInfo . EntryInfo Java , 4.3.5.1 “EntryInfo “ . (Binary Composition) . , SQLJ , . (headings) . (heading) . (Code generation) , sqlj.runtime.profile ConnectedProfile, RTStatement RTResultSet , . , . (heading) , . . . SQLJ

23、 . SQLJ . . KS X ISO/IEC 9075 10:2011 7 4 KS X ISO/IEC 9075 2 4. “ (Concepts)” . 4.1 (Embeded syntax) KS X ISO/IEC 9075 2 4.23 “ ” . ( ) , . ( ) , SQL JDBC Java . 4.2 (Character strings) KS X ISO/IEC 9075 2 4.2 “ ” . 4.2.1 (Unicode support) Java Unicode( KS X ISO/IEC 10646, (UCS) , .) . Java . KS X ISO/IEC 9075 2 UTF8, UTF16 UTF32 .