4. MJdbcUtils - JDBC Named Parameter Tools¶
MJdbcUtils is a Java Library for the handling of Named Parameters (e. g. :parameter) in Queries or DML or DDL statements.
It either replaces any Named Parameter with a Positional Parameter or rewrites the the Named Parameter with the parameter’s value and provides a convenient mapping between the Named Parameter and the provided values.
Further, it provides helpers for Parameter Dialogs and Batch Updates with parameters.
Latest stable release: MJdbcUtils-1.2.0.jar
Development version: MJdbcUtils-1.3.0-SNAPSHOT.jar
// DML statement with Named Parameters
String dmlStr = "INSERT INTO test VALUES ( :a, :b, :c, :d, :e )";
// Helper function will fill our parameter map with values
Map<String, Object> parameters = toMap("a", 1, "b", "Test String", "c", new Date(), "d", new Date(), "e", "0.12345");
// Create a Prepared Statement, which holds our parameter mapping
MPreparedStatement st = new MPreparedStatement(conn, dmlStr);
// Execute our statement with the provided parameter values
Assertions.assertFalse( st.execute(parameters) );
Features¶
Finds Named Parameters and Positional Parameters in SQL Statements
Maintains a map between the Named Parameter and the derived Positional Parameters so ever Named Parameter needs to be set just one single time
Rewrites the statement using Positional Parameters
?or the given values (useful for DDL statements)Retrieve the information about the used parameters for building a UI Dialog
Support for BatchUpdates and PreparedStatements with parameters