I have a class that implement all my workflow method. At some pointing time, when the request is approved by the workflow, I need to update status in database. For this I need to call the respective service class to save the status. The following method is saving the status in db:

public void changeStatus(String employeeNumber, String carid,String Status) throws Exception {
    Car car = carService.findCarByPrimaryKey(carid);

I want to make this method generic since I don't have status for car only. I have to update status for different object depending from the application made. It can be for application for leave/parking...I can keep the field Status with the same name in all table. Please advise me how to proceed. Thanks

2 Years
Discussion Span
Last Post by samantha2015

you can pass the tablename, columnname id and new value as parameters:
update <tablename> set columname = <new value> where id = <id>


but am not writing the query in the method. I'm calling only service class. the service class will call my dao and as such it will execute the query. Is there any sample available like this?

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.