[leduyquang]

Hi guys! I've had a little problem with how to bind record from database into Jtable Writing code by line by line is ok and work well but when i try to write this code in design by draging control to the JFrame ,it doesn't work! Hope you guys help me to fix this problem.Thank so much !
Here is my code:

  //connection database is Ok
  // problem is following here:
     Resultset rs=bll.getdata(proname, param); // this line work well                
     DefaultTableModel model=new DefaultTableModel();
     String Id="";
     String Name="";
                 while(rs.next())
                 {
                   Id=rs.getString("Emp_ID");
                   Name=rs.getString("Emp_Name");
                   temp=new Vector();
                   temp.addElement(Id);
                   temp.addElement(Name);
                   data.addElement(temp);  //data and heading are vector                
                   model.addColumn(heading);
                   model.addRow(data);
                   jTable1.setModel(model);
                 }

This post has been edited by macosxnerd101: 18 January 2011 - 09:15 AM
Reason for edit:: Please use code tags

[japanir]

What exactly is the problem? do you get any error messages? if yes, please post them.

[macosxnerd101]

Also, Vector is generic. So it should be Vector<Object>, Vector<String>, etc., for whatever type you're storing.

[redhotfire0]

temp=new Vector();

You are initializing a new vector everytime the resultset changes row. Is that what you really need? Just a question.

This post has been edited by redhotfire0: 18 January 2011 - 09:21 AM

[macosxnerd101]

JTable accepts a Vector<Vector<?>>, so there should be a Vector for each row. That being said, you need to add the Vector from each iteration to a main Vector.

[pbl]

A lot easier to make your own class to implement the model

	class MyModel extends AbstractTableModel {

		Vector<String> vId, vName;
		String[] header = {"Id", "Name"};
		// constructor
		MyModel() {
			vId = new Vector<String>();
			vName = new Vector<String>();
		}
		// to empty the vector
		void clear() {
			vId.clear();
			vName.clear();
		}
		// to add an element
		void add(String id, String name) {
			vId.add(id);
			vName.add(name);
		}
		public int getColumnCount() {
			return 2;
		}
		public int getRowCount() {
			return vId.size();
		}

		public String getColumnName(int col) {
			return header[col];
		}
		
		public Object getValueAt(int row, int col) {
			if(col == 0)
				return vId.get(row);
			else
				return vName.get(row);
		}
		
	}

Then you can have something like that to create model and JTable

	{
		MyModel tm = new MyModel();
		JTable table = new JTable(tm);
                ....
                loadFromBD(tm);
	}
	
	private void loadFromBD(MyModel tm) {
		// empty model data
		tm.clear();
		// loop on resultset
		while(rs.next()) {
			...
			// add new row
			tm.add(id, name);
		}
	}

Now you can call back loadFromBD() as often as you wish like after database change