The connection URL is entered either in ij directly by the user or using a script.
连接URL可以由用户在ij 中直接输入，也可以使用一个脚本来提供。
Finally, you used metadata about the query results to print nicely formatted query results in a manner similar to the Apache Derby ij tool.
最后，使用了关于查询结果的元数据，以一种类似于ApacheDerby ij工具的方式来打印格式很好的查询结果。
As this script executes, you may see a combination of new ij> prompts, commands, and warning or error messages.
当该脚本执行时，您可能会看到新ij>提示、命令和警告或错误消息的组合。
Now let's look at a complete example that shows how to set your class path to run ij, the Derby SQL scripting tool.
现在，让我们来看一个完整的实例，它展示了如何设置类路径，以便运行ij这个Cloudscapesql脚本编制工具。
But first, notice how ij created a second connection when you created the second database.
但是，首先要注意，当您创建第二个数据库时ij如何创建第二个连接。
Previously, the articles in this series have demonstrated a number of database concepts by using the ij tool to connect and interact with an Apache Derby database.
在本系列以前的文章中，通过使用ij工具连接apache Derby数据库并与之进行交互，从而演示了许多数据库概念。
Rather than entering the table-creation SQL commands directly into the Derby ij tool, you can put them into a text file and have the ij tool run the commands in the file directly.
无需将用于创建表的SQL命令直接输入到Derbyij工具中，您可以将其放入文本文件中，并让ij工具直接运行文件中的命令。
This means ij, the database Explorer, and a client application external to Eclipse could all connect to and query the tables in the database.
这意味着ij、DatabaseExplorer和Eclipse外部的客户机应用程序都可以连接和查询该数据库中的表。
All of these capabilities can be combined to create a fairly functional — and useful — application right in ij, without having to build any external infrastructure.
可以将所有这些功能合并在一起，以便在ij中创建功能强大的、有用的应用程序，而无需构建任何外部基础设施。
This connection URL should look familiar — it's exactly what you used in previous articles when issuing a connect command in the ij tool.
这个连接url应该很眼熟——它与以前的文章中使用ij工具发出connect命令时使用的URL完全相同。
There is yet another way to run a Derby script: redirect the standard input of the ij tool to read from the script file.
还有另一种方法来运行Derby脚本：重定向ij工具的标准输入以从脚本文件中读取。
After a brief delay, the ij tool provides you with a new prompt.
在短暂的延迟之后，ij工具提供一个新提示符。
If the stored procedure does not include any OUT parameters, it can also be invoked using CALL in a tool that executes dynamic SQL statements, such as the ij tool.
如果存储过程不包含任何OUT参数，那么还可以在执行动态sql语句的工具(例如ij工具)中使用CALL来调用它。
The ij tool includes a help command that lists and describes some common commands you may want to use, as shown in Listing 3.
ij工具包括一个help命令，可以列出和描述要使用的一些常见命令，如清单3所示。
Next, the ij tool is started, and a connection to the appropriate database is made.
接下来，启动 ij工具，并建立与适当数据库的连接。
You could use the Derby ij command line to enter the SQL commands directly, or you could use a graphical SQL tool.
您可以使用Derbyij命令行直接输入SQL命令，也可以使用一个图形化sql工具。
Listing 1: Performing a backup of salesdb database through ij.
清单1：通过IJ对salesdb数据库进行备份。
After you've initialized a demo database, you can use the Apache Derby ij tool to connect to the test database and issue SQL commands.
初始化演示数据库后，可以使用ApacheDerbyij工具连接至测试数据库以及发出SQL命令。
In this case, you supply the name of the script file as a command-line argument to the ij tool.
在这种情况下，提供脚本文件名作为ij工具的命令行参数。
As shown in this example, you can also create a PreparedStatement to perform dynamic queries by using the ij tool.
如本例中所示，还可以创建一条PreparedStatement来使用ij工具执行动态查询。
This included using the ij tool to prepare, execute, and remove a PreparedStatement, which can be useful when you're prototyping different approaches.
这包括了使用ij工具准备、执行和删除PreparedStatement，它们会在构建不同方法的原型时十分有用。
This article used the ij tool to create a new database and then explored the directories and files that were generated when Derby created the new database.
本文使用ij工具创建了一个新数据库，然后研究了Derby创建新数据库时生成的目录和文件。
Ij enables you to do many of the same tasks you might think you can only accomplish using a full-fledged JDBC application, such as manipulating cursors and creating and executing prepared statements.
ij使您能够执行许多您原本认为只有使用完备的JDBC应用程序才能完成的任务，如操纵游标和创建并执行准备好的语句。
To begin, start the ij tool, and connect to a database, as shown in Listing 1.
开始时，启动ij工具，连接到数据库，如清单1 中所示。
The rest of this article shows you how to use the ij tool to perform simple database operations, like creating a database.
下文将展示如何使用ij工具执行简单的数据库操作，比如创建数据库。
The JDBC connection URL to connect to a Cloudscape database is shown using ij in the console of Eclipse.
下图显示了在Eclipse的控制台中使用ij 时用于连接到Cloudscape数据库的JDBC连接URL。
The simplest technique to execute the commands in a SQL script file is to run the script file from within the ij tool.
要执行sql脚本文件中的命令，最简单的方法是从ij工具中运行脚本文件。
But first make sure you can establish a Derby Network Server connection to the DB1 database using ij, the Derby SQL scripting tool.
但是，首先要确保您可以使用ij这个Derbysql脚本编制工具，建立到DB 1数据库的Derby Net workServer连接。
The ij tool can be used to connect to and issue commands to a database.
ij工具可用于连接数据库并向数据库发出命令。
After your environment is set up properly, you can run the ij tool to create a new directory, as shown in Listing 1.
正确设置了环境之后，可以运行ij工具来创建新的目录，如清单1所示。
应用推荐