JDBC Scripting
JDBC scripting with free-form SQL is one of the main motivations for JudoScript
itself. SQL statements can be run directly by executeSQL and
executeQuery or prepared and run by prepare and its family
of shortcut statements. Stored procedure calls are supported, too. SQL
statements can be run individually or in a batch via executeBatch;
they can be specified altogether or added one by one. This article describes
all the basic features with a small sample database application. The scrtipts
herein are executable; they create the sample database and its content;
explanation is done for Oracle code. Some Microsoft SQL Server code is
provided, too. More advanced JDBC topics will be in another article.