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.