How to edit database table in jsf

[Adnan Gondal]

Hi all!

I'm having a bean class with id,firstName,lastName attributes having public getters and setters, and an updateEmployee method.

i'm using following jsf page to get database table values.

When i click on update button success page is shown but values are not changing in the database. Can any one tell me the reason that why vales are not getting change in the database?

Thanks in advance.

JSF page:

<h:dataTable value="#{tableBean.employeeList}" var="employee" border="1">
   <h:column>
          <f:facet name="header">First name</f:facet>
          <h:inputText value="#{employee.firstName}" />
   </h:column>

   <h:column>
          <f:facet name="header">Last name</f:facet>
          <h:inputText value="#{employee.lastName}" />
   </h:column>
</h:dataTable>
<h:commandButton value = "update" action="#{employee.updateEmployee}"/>

Employee.java:

public String updateEmployee(){
   String query = "update employee set firstName = ?,lastName = ? where id = 1";         
   pstmt = conn.prepareStatement(query);
   pstmt.setString(2,this.firstName);
   pstmt.setString(3,this.lastName); 
   pstmt.executeUpdate(); // execute update statement
   conn.commit();
   committed = true;
   return "success.xhtml";
   }catch (Exception e) {
       e.printStackTrace();
       return null;
   } finally {
      try{
         if (!committed) conn.rollback();
              pstmt.close();
          conn.close();
       }catch(Exception e){
            e.printStackTrace();
      }
    }
 }

[Tim Holloway]

JSF does not include any persistency functions at all. It leaves that task for other frameworks, such as Hibernate.

To save a datatable after editing it, you need an action method that will be invoked when you click the "Submit" button on the form that displays the datatable. When that method is called, the dataModel that's backing the dataTable View will have been updated with the user's new values (after having first been validated). So at that point, it's up to you to provide logic to persist that dataModel out to the database.

When using an ORM such as hibernate/JPA, you can often use your Domain Model as the View Model, which can make the whole process fairly simple. Sometimes, however, the View model and domain models aren't quite identical, however, so in cases like that you'd have to build up and persist your own Domain Model.

If you're not using an ORM, and are, for example, using raw JDBC, you simply have to create code to iterate through the View Model and supply the appropriate JDBC insert/update functions.