DbExecutor
DbExecutor provides utility methods for interacting with a database, allowing you to query, insert, update, and delete data.
Methods
queryValue(query: String)
queryValue(query: String)Description: Executes a query on the specified database and returns a single string value. It's used for retrieving specific data from a database.
Parameters:
query(type: String): The SQL query to execute.
Returns: A string containing the result of the query.
Example: Get the email address of a user based on their username.
Use Case: Useful for retrieving user contact information from a database
var userEmail = DbUtil.getDbExecutorByName("Sample Database (MySQL)").queryValue("SELECT email from demo501db.users where username like 'Samuel'")insert(sql: String)
insert(sql: String)Description: Inserts data into the specified database using an SQL insert statement and returns the number of affected rows. It's used for adding new data records to a database.
Parameters:
sql(type: String): The SQL insert statement.
Returns: An Integer representing the number of rows affected by the insert operation.
Example: Insert a new product into the products database.
Use Case: Common in e-commerce systems for adding new items to the product catalog.
var newProductInsert = "INSERT INTO products (name, price) VALUES ('New Product', 50)";
var insertedRowCount = DbUtil.getDbExecutorByName("Sample Database (MySQL)").insert(newProductInsert);update(sql: String)
update(sql: String)Description: Updates data in the specified database using an SQL update statement and returns the number of affected rows. It's used for modifying existing data records in a database.
Parameters:
sql(type: String): The SQL update statement.
Returns: An Integer representing the number of rows affected by the update operation.
Example: Update the status of an order in the orders database.
Use Case: Common in order management systems to reflect the order's status changes.
var updateOrderStatus = "UPDATE orders SET status = 'Shipped' WHERE order_id = 1005";
var updatedRowCount = DbUtil.getDbExecutorByName("Sample Database (MySQL)").update(updateOrderStatus);delete(sql: String)
delete(sql: String)Description: Deletes data from the specified database using an SQL delete statement and returns the number of affected rows. It's used for removing data records from a database.
Parameters:
sql(type: String): The SQL delete statement.
Returns: An Integer representing the number of rows affected by the delete operation.
Example: Delete expired tasks from the tasks database.
Use Case: Applicable in task management systems to clean up and remove completed or outdated tasks.
var deleteExpiredTasks = "DELETE FROM tasks WHERE status = 'Expired'";
var deletedRowCount = DbUtil.getDbExecutorByName("Sample Database (MySQL)").delete(deleteExpiredTasks);