can't get to distribute my individual datas into row in JTable

hi everybody in the house

i am try to insert datas from database into Jtable rows, that is i want to add another row to the bottom of my table

the issue is these
i use vector utility to collate my datas from the database then add it to the table, ok fine!! i got the datas into my vector and add, but instead of it distributing it to different cells, it only add to a particular cell which is not what i want.
take a look into my code.
this is working mechine to get the datas from the batabase into the vector.

public Vector setTableQuery(int acc_code){
    final String dataQuery = "Select banksName,chequeNum,debit_amt,credit_amt,accountCode,pvNumber,payeeName,TransactionDate from account where accountCode="+acc_code ;
	 datas = new Vector();
	//ArrayList<Account>  datas = new ArrayList<Account>();
	//ArrayList  datas = new ArrayList();
	try {
	//execute query and store the resultSet and its metadata.
	conn = DriverManager.getConnection(url,user,pass);
	stat = conn.createStatement();
	ResultSet rs = stat.executeQuery(dataQuery);
	ResultSetMetaData meta = rs.getMetaData();
    colCount = meta.getColumnCount();
	
		while (rs.next()) {
			Vector record = new Vector();
			//record.addElement(rs.getObject());
		
			for (int i = 1; i <= colCount; i++) {
			record.addElement(rs.getObject(i));
			//record.add(rs.getObject(i));
			}
			
			/*for (int i = 1; i <= rowCount; i++) {
			record.addElement(rs.getObject(i));
			//record.add(rs.getObject(i));
			}*/
			//record.addElement(rs.getObject());
		  //datas.addElement(record);
		  datas.add(record);
		  //fireTableDataChanged();
		}
       //fireTableChanged(); // notify everyone that we have a new table.
    } catch (Exception e) {
      //datas = new Vector(); // blank it out and keep going.
      e.printStackTrace();
    }
	System.out.println(datas.size());
	System.out.println(datas);
	int rowCount = meta.getRowCount();
	    
	return datas;
  }

And this is the table adding part

public JPanel showReportPanel() {
			//connect = new ConnectionClass();
			
			String[] columnNames = {"Date","Chq No.","PV No.","Payee","","Code","Dr","Cr","Balance"};
			Object[][] cells = {{"","","","","","","N","N","N"},{"","","","","Balance B/forward","","","",""}};
			    DefaultTableModel model = new DefaultTableModel(cells,columnNames);
				JPanel mainReportPanel = new JPanel(new BorderLayout(10,10));
				JLabel view = new JLabel("View Reports Here");
				JPanel viewPanel = new JPanel();
				viewPanel.add(view);
				mainReportPanel.add(viewPanel,BorderLayout.NORTH);
				final JTable reportTable = new JTable(model);
				
				// model.insertRow(reportTable.getRowCount(),setTableQuery(d_acctCode));
				 //model.addRow(reportTable.getRowCount(),setTableQuery(d_acctCode));
				 model.insertRow(reportTable.getRowCount(),setTableQuery(d_acctCode));
				reportTable.setRowSelectionAllowed(false);
				mainReportPanel.add(new JScrollPane(reportTable),BorderLayout.CENTER);
				JButton printBtn = new JButton("Print Report");
				printBtn.addActionListener(new ActionListener(){
							public void actionPerformed(ActionEvent evt){
								try{
									reportTable.print();
								}
								catch(java.awt.print.PrinterException pe) {
									pe.printStackTrace();
								}
							}
					});
				JPanel printBtnPanel = new JPanel();
				printBtnPanel.add(printBtn);
				mainReportPanel.add(printBtnPanel,BorderLayout.SOUTH);
				
				return mainReportPanel;
			}

please i need to know what i did wrong cause it is getting me off the edge

thanks

You are treating your Vector of Vectors, which should be your model's entire data set, as a simple row Vector. You should iterate over this Vector, adding each Vector separately.

And instead of using insertRow you can use addRow to add a row to the end.

please can you write an example short code to show this
thanks

I'm sure you can write a simple loop and the casting of each element to Vector yourself, can't you?