Filter JTextField and Display in JTable
 

hai , all
This coding about filter data using jTextFiled and display in jtable, so help me to combine these class be one class.
thanks

//DBAccess.java

import ca.odell.glazedlists.BasicEventList;

import ca.odell.glazedlists.EventList;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.ResultSet;

import java.sql.SQLException;

import java.sql.Statement;



public class DBAccess {

    private static Connection c;

    private static Statement selectStatement;

    static{

    try{

        Class.forName("com.mysql.jdbc.Driver");

        c = DriverManager.getConnection("jdbc:mysql://localhost/MyDB","root","");

            selectStatement = c.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_READ_ONLY);

        } catch(ClassNotFoundException e){                            

            e.printStackTrace();

        } catch(SQLException e){ 

            e.printStackTrace(); 

        }   

   }



    public static EventList<Customer> getCustomer ()throws SQLException{

        EventList<Customer> list = new BasicEventList<Customer>();

        ResultSet rs = selectStatement.executeQuery("select * from customers");

        while(rs.next()){

            list.add(getCustomer(rs));

        }

        return list;

    }



    

    public static Customer getCustomer(ResultSet rs)throws SQLException{

        Customer customer = new Customer();

        customer.setCode(rs.getString(1));

        customer.setName(rs.getString(2));

        return customer 

   }

 }





//Customer.java

package newpackage;

public class Customer {

    private String code, name;

    public Customer () {}

    

    public String getCode() {

        return code; 

    }

    

    public void setCode(String code) {

        this.code = code; 

    }

    

    public String getName() {

        return name;

    }

    

    public void setName(String name) {

        this.name = name;

    }

    

    public String toString() {

        return getCode() + " " + getName();

    }

 }



//CustomerComparator.java

package newpackage;

import java.util.Comparator;

public class CustomerComparator implements Comparator{

   

public CustomerComparator() {}

 public int compare(Object a, Object b) {

        Customer cusA = (Customer) a;

        Customer cusB = (Customer) b;

        if(a.toString().equals(b.toString()))

            return 0;

            return cusA.getCode().compareTo(cusB.getCode());

    }

}

    

//CustomerFilter.java

package newpackage;

import ca.odell.glazedlists.TextFilterator;

import java.util.List;

import newpackage.Customer;

public class CustomerFilter implements TextFilterator{

    public CustomerFilter() { }

    public void getFilterStrings(List baseList, Object element) {

        Customer customer = (Customer) element;

        baseList.add(customer.getCode());

        baseList.add(customer.getName());

        }

}





//CustomerTableFormat.java

package newpackage;

import ca.odell.glazedlists.gui.TableFormat;

public class CustomerTableFormat implements TableFormat{

    public CustomerTableFormat() {}

    public int getColumnCount() { 

        return 2; 

    }

    

    public String getColumnName(int column) {

        switch(column){

            case 0: return "Code";

            case 1: return "Name";

            default: return "";

        }

    }

    

    public Object getColumnValue(Object baseObject,int column) {

        Customer customer = (Customer) baseObject;

        switch(column){

            case 0: return customer.getCode();

            case 1: return customer.getName();

            default: return "";

        }

    }

}





//CustomerTableFilter.java

package newpackage;

import ca.odell.glazedlists.EventList;

import ca.odell.glazedlists.FilterList;

import ca.odell.glazedlists.SortedList;

import ca.odell.glazedlists.swing.EventTableModel;

import ca.odell.glazedlists.swing.TextComponentMatcherEditor;

public class CustomerTableFilter extends javax.swing.JFrame {

    public CustomerTableFilter() {

    initComponents();

       try{

         EventList<Customer> list = DBAccess.getCustomer();   

         SortedList<Customer> sortedList = new SortedList<Customer>(list, new CustomerComparator());

        FilterList filterList = new FilterList(sortedList, new TextComponentMatcherEditor(txtFilter,new CustomerFilter()));      

        EventTableModel model = new EventTableModel(filterList, new CustomerTableFormat());

        tblCustomer.setModel(model);

       }catch (Exception e){e.printStackTrace();}

    }





public static void main(String args[]) {

        java.awt.EventQueue.invokeLater(new Runnable() {

            public void run() {

                new CustomerTableFilter().setVisible(true);

            }

        });

    }

    

    // Variables declaration - do not modify                     

    private javax.swing.JScrollPane jScrollPane1;

    private javax.swing.JTable tblCustomer;

    private javax.swing.JTextField txtFilter;

    // End of variables declaration                   

    

}

Re: Filter JTextField and Display in JTable
 

it is always good to use diff classes in java... datz the whole point of OO programming... i don't know y u r trying to put them together.
n wat classes do u want to combine? watz the approach u have made? show us some of ur work so that we can figure out where u r facing problem.

Re: Filter JTextField and Display in JTable
 

i have tried, but still error or data can't display in jtable

// NewJFrame.java

package newpackage;



import ca.odell.glazedlists.BasicEventList;

import ca.odell.glazedlists.EventList;

import ca.odell.glazedlists.FilterList;

import ca.odell.glazedlists.SortedList;

import ca.odell.glazedlists.TextFilterator;

import ca.odell.glazedlists.gui.TableFormat;

import ca.odell.glazedlists.swing.EventTableModel;

import ca.odell.glazedlists.swing.TextComponentMatcherEditor;

import java.sql.Connection;

import java.sql.ResultSet;

import java.sql.SQLException;

import java.sql.Statement;

import java.util.Comparator;

import java.util.List;



public class NewJFrame extends javax.swing.JFrame {

    private static Connection c;

    private static Statement selectStatement;

    public NewJFrame() {

        initComponents();

        

       try{

        EventList<Customer> list =getCustomer();   

        SortedList<Customer> sortedList = new SortedList<Customer>(list, new CustomerComparator());

        FilterList filterList = new FilterList(sortedList, new TextComponentMatcherEditor(txtFilter,new CustomerFilter()));      

        EventTableModel model = new EventTableModel(filterList, new CustomerTableFormat());

        tblCustomer.setModel(model);

       }catch (Exception e){e.printStackTrace();}

        

    }

    

  public  class Customer {

    private String code, name;

    

    public String getCode() {

        return code;

    }

    

    public void setCode(String code) {

        this.code = code;

    }

    

    public String getName() {

        return name;

    }

    

    public void setName(String name) {

        this.name = name;

    }

    

    

    public String toString() {

        return getCode() + " " + getName();

    }

 }

    

    

class CustomerComparator implements Comparator{

    public int compare(Object a, Object b) {

        Customer cusA = (Customer) a;

        Customer cusB = (Customer) b;

         

        if(a.toString().equals(b.toString()))

            return 0;

            return cusA.getCode().compareTo(cusB.getCode());

    }

    

}





class CustomerFilter implements TextFilterator{

 public void getFilterStrings(List baseList, Object element) {

        Customer customer = (Customer) element;

        baseList.add(customer.getCode());

        baseList.add(customer.getName());

        }

}



    

public class CustomerTableFormat implements TableFormat{

    public int getColumnCount() { 

        return 2; 

    }

    

    public String getColumnName(int column) {

        switch(column){

            case 0: return "Code";

            case 1: return "Name";

            default: return "";

        }

    }

    

    public Object getColumnValue(Object baseObject,int column) {

        Customer customer = (Customer) baseObject;

        switch(column){

            case 0: return customer.getCode();

            case 1: return customer.getName();

            default: return "";

        }

    }

}    

    

    public static EventList<Customer> getCustomer()throws SQLException{

        EventList<Customer> list = new BasicEventList<Customer>();

        ResultSet rs = DBAccess.selectStatement.executeQuery("select * from customer");

        while(rs.next()){

            list.add(getCustomer(rs));

        }

        return list;

    }



    

      public static Customer getCustomer(ResultSet rs)throws SQLException{

        Customer customer = null; // data can't show in jtable

        //Customer customer = new Customer(); //err non-static variable this cannot be referenced from a static context

        customer.setCode(rs.getString(1));

        customer.setName(rs.getString(2));

        return customer;

    }

    

    

    /** This method is called from within the constructor to

     * initialize the form.

     * WARNING: Do NOT modify this code. The content of this method is

     * always regenerated by the Form Editor.

     */

    // <editor-fold defaultstate="collapsed" desc=" Generated Code ">

    private void initComponents() {

        jScrollPane1 = new javax.swing.JScrollPane();

        tblCustomer = new javax.swing.JTable();

        txtFilter = new javax.swing.JTextField();



        setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE);

        tblCustomer.setModel(new javax.swing.table.DefaultTableModel(

            new Object [][] {

                {null, null, null, null},

                {null, null, null, null},

                {null, null, null, null},

                {null, null, null, null}

            },

            new String [] {

                "Title 1", "Title 2", "Title 3", "Title 4"

            }

        ));

        jScrollPane1.setViewportView(tblCustomer);



        org.jdesktop.layout.GroupLayout layout = new org.jdesktop.layout.GroupLayout(getContentPane());

        getContentPane().setLayout(layout);

        layout.setHorizontalGroup(

            layout.createParallelGroup(org.jdesktop.layout.GroupLayout.LEADING)

            .add(layout.createSequentialGroup()

                .addContainerGap()

                .add(layout.createParallelGroup(org.jdesktop.layout.GroupLayout.LEADING)

                    .add(txtFilter, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE, 188, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE)

                    .add(jScrollPane1, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE, 375, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE))

                .addContainerGap(15, Short.MAX_VALUE))

        );

        layout.setVerticalGroup(

            layout.createParallelGroup(org.jdesktop.layout.GroupLayout.LEADING)

            .add(org.jdesktop.layout.GroupLayout.TRAILING, layout.createSequentialGroup()

                .add(txtFilter, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE)

                .addPreferredGap(org.jdesktop.layout.LayoutStyle.RELATED, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)

                .add(jScrollPane1, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE, 275, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE))

        );

        pack();

    }// </editor-fold>

    

    /**

     * @param args the command line arguments

     */

    public static void main(String args[]) {

        java.awt.EventQueue.invokeLater(new Runnable() {

            public void run() {

                new NewJFrame().setVisible(true);

            }

        });

    }



     

    // Variables declaration - do not modify

    private javax.swing.JScrollPane jScrollPane1;

    private javax.swing.JTable tblCustomer;

    private javax.swing.JTextField txtFilter;

    // End of variables declaration

    

}





//DBAccess.java



package newpackage;



import ca.odell.glazedlists.BasicEventList;

import ca.odell.glazedlists.EventList;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.ResultSet;

import java.sql.SQLException;

import java.sql.Statement;

public class DBAccess {

     public static Connection c;

     public static Statement selectStatement;



    static{

        try{

            Class.forName("com.mysql.jdbc.Driver");

            c = DriverManager.getConnection("jdbc:mysql://localhost/mydb","root","");

            selectStatement = c.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_READ_ONLY);

        } catch(ClassNotFoundException e){                            

            e.printStackTrace();

        } catch(SQLException e){ 

            e.printStackTrace(); 

        }   

   }



 }

Re: Filter JTextField and Display in JTable
 

seems like you have taken the code from some where else (a lot of things are inconsistent... i don't see how you are initiating the customer.)..... for programming you must need to know what your code is doing.
for example, in following code:

  public static Customer getCustomer(ResultSet rs)throws SQLException{

        Customer customer = null; // data can't show in jtable

        //Customer customer = new Customer(); //err non-static variable this cannot be referenced from a static context

        customer.setCode(rs.getString(1));

        customer.setName(rs.getString(2));

        return customer;

    }

how you can access to the customer if you have not created any?
you need at least a constructor to make customer class work. wat are the errors you are getting?