JDBC and SQLJ can interoperate in the same application.
JDBC和SQLJ可以在同一个应用程序中互操作。
For SQLJ applications with embedded static SQL statements.
对于含嵌入式静态sql语句的SQLJ应用程序。
The SQLJ API is defined within the SQL 1999 specification.
SQLJAPI是在SQL 1999规范中定义的。
Possible values for relational databases are JDBC and SQLJ.
对于关系数据库来说可能的值为JDBC和SQLJ。
SQLJ provides a simplified way of processing SQL statements.
SQLJ为处理sql语句提供了一种简化的方式。
SQLJ programs require fewer lines of code than JDBC programs.
SQLJ程序需要的代码行数比JDBC程序更少。
DB2 SQLJ support enables you to build and run SQLJ applets and applications.
DB 2SQLJ支持使您能构建和运行SQLJapplet和应用程序。
Here are some of the advantages that SQLJ offers over coding directly in JDBC.
下面是SQLJ相对于直接在JDBC中编写代码的优势。
Unless SQLJ was chosen as the API, all other access choices used dynamic execution.
除非已选择 SQLJ作为API,否则所有其他访问都选择使用动态执行。
The SQLJ has three components: a translator, customizer, and a run-time environment.
SQLJ有三个组件;转换器、定制器和运行时环境。
When writing a SQLJ stored procedure, you will need to execute two additional steps.
在编写SQLJ存储过程时,需要执行两个额外的步骤。
The package for SQLJ application is generated at the time db2sqljcustomize is executed.
SQLJ应用程序的包是在 db2sqljcustomize执行时生成的。
Enter the package name and the file name and then select Finish to create the SQLJ file.
输入包名和文件名,然后选择Finish创建SQLJ文件。
Translation of SQLJ applications produce .class files and one or more serialized profiles.
翻译SQLJ应用程序会生成.class文件和一个或多个序列化配置文件。
The default value for this property is true, which means that all SQLJ tools will call System.exit .
此属性的默认值是true,表示所有的SQLJ工具将会在完成以后调用System .exit 。
SQLJ can perform syntactic and semantic checking on the code, using database connections at compile time.
SQLJ可以通过在编译时使用数据库连接,对代码执行语法和语义上的检查。
Although it is not covered in this article, it is still possible to use SQLJ to develop Stored Procedures.
虽然本文没有提到,但使用SQLJ开发存储过程也是可行的。
JDBC and SQLJ enhancements have been made in order to support some of the other enhancements described earlier.
为了支持前面提到的其他增强功能,对JDBC和SQLJ进行了增强。
You can also use the DWB to develop SQLJ applications, and create, edit, and run SQL statements and XML queries.
还可以使用DWB开发SQLJ应用程序,并创建、编辑和运行SQL语句和XML查询。
Double-click SQLJ profiles and pureQuery bind files under Database Profiles in the bottom right corner (Figure 5).
双击右下角DatabaseProfiles下面的SQLJ profilesand pureQuerybindfiles(请参见图 5)。
We will create a SQLJ method, which reads an employee record given the employee number from the DB2 SAMPLE database.
我们将创建一个SQLJ方法,该方法从DB2SAMPLE数据库中根据给定的雇员号读取一个雇员记录。
SQLJ provides the unique ability to develop using static SQL statements and control access at the DB2 package level.
SQLJ提供了独特的使用静态SQL语句进行开发以及在DB2包级别控制访问的能力。
In the first part, learn how to build, customize, and test an SQLJ application using Rational application Developer.
在第一部分中可以学习如何使用RationalApplication Developer构建、定制和测试SQLJ应用程序。
One key advantage of pureQuery over SQLJ is the ease of enabling static SQL access in a way that is more streamlined.
pureQuery相对于 SQLJ的一个主要优点是很容易以更加简化的方式实现静态SQL访问。
You can also use the Data Stuidio to develop SQLJ applications, and create, edit, and run SQL statements and XML queries.
还可以使用Data Stuidio开发SQLJ应用程序,以及创建、编辑和运行sql语句和XML查询。
In a typical enterprise application environment, DB2 applications often use the SQLJ tools db2sqljcustomize and db2sqljbind.
在典型的企业应用程序环境中,DB2应用程序通常会使用SQLJ工具db2sqljcustomize和db2sqljbind。
For example, one subclass might implement these three methods using JDBC, while another might implement them using SQLJ or JDO.
例如,一个子类可能实现这3个方法用jdbc,然而其他的可能实现他们用sqlj或者jdo。
As you might imagine, you can use SQLJ in your J2EE application either in servlets, Session beans, BMP Entity beans and MDB beans.
您可能想到,还可以在J2EE应用程序、servlet、会话bean、BMP实体bean和MDB bean中使用SQLJ。
For SQLJ stored procedures, bind the serialized profiles to the target server incorporating the bind options from the Deploy wizard.
对于SQLJ存储过程,根据Deploy向导中的绑定选项,将串行化的profile文件绑定到目标服务器。
In the second part, learn how to deploy an SQLJ application into a WebSphere application Server and do a test run in that environment.
在第二部分中可以学习如何将SQLJ应用程序部署到WebSphereApplicationServer,以及如何在该环境中测试运行。
应用推荐