primefaces in-cell-editing data table not update data in database...

[Ramakrishna brahma]

/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */
package my;

import hiber.Master;
import hiber.myutil;
import java.io.Serializable;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.Iterator;
import javax.faces.application.FacesMessage;
import javax.faces.bean.ManagedBean;
import javax.faces.bean.ViewScoped;
import javax.faces.context.FacesContext;
import javax.inject.Named;
import javax.naming.InitialContext;
import javax.naming.NamingException;
import javax.sql.DataSource;
import org.hibernate.Query;
import org.hibernate.Session;
import org.hibernate.Transaction;
import org.primefaces.event.RowEditEvent;

/**
 *
 * @author Ram
 */
@Named(value = "viewtable")
@ManagedBean
@ViewScoped
public final class viewtable implements Serializable {

    //SessionFactory sf = new Configuration().configure().buildSessionFactory();;
    //Session sess = myutil.getSessionFactory().getCurrentSession();
    //Transaction tr;
    ArrayList<viewbean> dlist = new ArrayList<viewbean>();
    ArrayList<Master> mlist = new ArrayList<Master>();

    
    public ArrayList<viewbean> getDlist() {
        return dlist;
    }

    public viewtable()  {
        get();
        /*getdata();

        for (Iterator it = mlist.iterator(); it.hasNext();) {
            Master m = (Master) it.next();
            dlist.add(new viewbean(m.getRegno(), m.getRollno(), m.getFname(), m.getLname(), m.getDob(), m.getAddress(), m.getAvatar(), m.getEmail(), m.getPhno(), m.getDept(), m.getYear(), m.getInidate(), m.getEnddate(), m.getRemarks(), m.getDelivery(), m.getMessdelivery()));
        }*/

    }
    
    public void get()
    {
        try
        {
        InitialContext ic=new InitialContext();
        DataSource ds=(DataSource) ic.lookup("jdbc/mydsn");
        Connection con=ds.getConnection();
        
        PreparedStatement ps=con.prepareStatement("select * from master");
        ResultSet rs=ps.executeQuery();
        
        while(rs.next())
        {
            dlist.add(new viewbean(rs.getString(1), rs.getString(2),rs.getString(3),rs.getString(4),rs.getDate(5), rs.getString(6), rs.getBytes(7), rs.getString(8),rs.getString(9),rs.getString(10),rs.getString(11),rs.getDate(12),rs.getDate(13),rs.getString(14),rs.getString(15), rs.getString(16)));
        }
        }catch(Exception ex)
        {
            System.out.println("Conncetion pool db error-> "+ex);
        }
        
    }

   /* public void getdata() {
        try {
            //sess=sf.getCurrentSession();
            tr = sess.beginTransaction();
            String hql = "from hiber.Master";
            Query q = sess.createQuery(hql);
            /*
             * for (Iterator it = q.iterate(); it.hasNext();) { Master m =
             * (Master) it.next(); dlist.add(new viewbean(m.getRegno(),
             * m.getRollno(), m.getFname(), m.getLname(), m.getDob(),
             * m.getAddress(), m.getAvatar(), m.getEmail(), m.getPhno(),
             * m.getDept(), m.getYear(), m.getInidate(), m.getEnddate(),
             * m.getRemarks(), m.getDelivery(), m.getMessdelivery())); }
             
            mlist = (ArrayList<Master>) q.list();
            tr.commit();
            if (sess.isOpen()) {
                sess.flush();
                sess.close();
            }
        } catch (Exception ex) {

            System.err.println("Datatable Error-> " + ex);
        }*/



    

    public void onEdit(RowEditEvent event) {
        
        }

    }

i made mistake in get() method please tell me how to connect to database using primefaces datatable

[Tim Holloway]

Welcome to the JavaRanch, Ramakrishna!

Our message editor has a "Code" button that generates special tags that preserver the formatting of Java code, XML, and other pre-formatted text and make it easier to read. We recommend that you do this. I've updated your post with them.

Your first and biggest problem is that your classname does not conform to standards. Class names should always begin with a capital letter, just as instance and member names should always begin with a lower-case letter. If you don't do this, the JSF support mechanisms cannot process them properly.