Define a header of a JTable and set a value into it

[Sarra Sakka]

Hello,
I want to create a JTable which "Analysis","Date" and "Price" the names of columns in header. Here's a piece of my code :

String sql = "Select name, Price from analysis_tab  where  name ='" + idclicked + "'";
DateFormat dateFormat = new SimpleDateFormat("yyyy/MM/dd");
Date date = new Date();
PreparedStatement preparestate = database.con.prepareStatement(sql);
ResultSet rs = preparestate.executeQuery();

So, the value of Analysis and Price were stored in my Data Base, and the Date get the value of the current day.
How can i create this JTable and how can i set the value into it ?

[Campbell Ritchie]

How familiar are you with Tables already?

[Sarra Sakka]

The "object[][]data " in JTable is dynamic .

[Maneesh Godbole]

Sarra Sakka wrote:The "object[][]data " in JTable is dynamic .

Arrays are not dynamic. However you can have the data as a List instead

[Sarra Sakka]

I have created a class MyModel the followings :

package com.pack.classes;

import java.util.LinkedList;

import javax.swing.table.AbstractTableModel;

import com.pack.beans.MyElement;

@SuppressWarnings("serial")
public class MyModel extends AbstractTableModel {

    public static final String[] columnNames = {"Analyse", "Date d'analyse","Prix"};
    private final LinkedList<MyElement> list; 

    public MyModel() {
        list = new LinkedList<MyElement>();
    }

    public void addElement(MyElement e) {
        // Adds the element in the last position in the list
        list.add(e);
        fireTableRowsInserted(list.size()-1, list.size()-1);
    }

    @Override
    public int getColumnCount() {
        return columnNames.length;
    }

    @Override
    public int getRowCount() {
        return list.size();
    }

    @Override
    public Object getValueAt(int rowIndex, int columnIndex) {
        switch(columnIndex) {
            case 0: return list.get(rowIndex).getAnalysis();
            case 1: return list.get(rowIndex).getDate();
            case 2: return list.get(rowIndex).getPrice();
        }
        return null;
    }

}

And i create a Bean MyElement the following :

package com.pack.beans;

import java.util.Date;

public class MyElement {

	String analysis;
	Date date;
	Double price;
	
	public String getAnalysis() {
		return analysis;
	}
	public void setAnalysis(String analysis) {
		this.analysis = analysis;
	}
	public Date getDate() {
		return date;
	}
	public void setDate(Date date) {
		this.date = date;
	}
	public Double getPrice() {
		return price;
	}
	public void setPrice(Double price) {
		this.price = price;
	}
	
}

this is a piece of my code which this class :

String sql = "Select name,number_b from analysis_tab  where  name ='" + idclicked + "'";
		    		DateFormat dateFormat = new SimpleDateFormat("yyyy/MM/dd");
		    		Date date = new Date();
		    		System.out.println(dateFormat.format(date));
		    		PreparedStatement preparestate = database.con.prepareStatement(sql);
					ResultSet rs = preparestate.executeQuery();
					MyModel mymodel = new MyModel();
				    String [] value = mymodel.columnNames;
				
					MyElement e = new MyElement();
					//e.setAnalysis(name);
					e.setDate(date);
					//e.setPrice("number_b");

Am I on the right path?? if yes, what should i do after that ?

[Sarra Sakka]

As a result i obtain a Table with 3 coloumn "A","B" and "C".I don't know hence these name comes!!!
Should you please to know how can i put my columns names "Analyse", "Date d'analyse","Prix" as a header in my Table?

[Maneesh Godbole]

Well done. You are on the right track.
1) Why did you extend abstract table model? Try extending Default table model.
2) Override the getColumnName() to return the name you desire (from your columnNames)

[Sarra Sakka]

Do you mean like this :

/    @Override
  public String getColumnName(int column) {
       return columnNames[column];
 }

[Sarra Sakka]

Very well, the column names appears now

[Sarra Sakka]

I have a problem now, when i add a new element the previous element will be overwritten
Would you please tell me where's the problem in my code :

	String idclicked = (table_analysis_list.getModel().getValueAt(row, 1).toString());
		    		String sql = "Select name,number_b from analysis_tab  where  name ='" + idclicked + "'";
		    		DateFormat dateFormat = new SimpleDateFormat("yyyy/MM/dd");
		    		Date date = new Date();
		    		dateFormat.format(date);// convert the 
		    		PreparedStatement preparestate = database.con.prepareStatement(sql);
					ResultSet rs = preparestate.executeQuery();
				
					if(rs.next())
					{
//						System.out.println(sql = rs.getString("name"));
//						System.out.println(sql = rs.getString("number_b"));
						short numberb = Short.parseShort(rs.getString("number_b"));
						MyElement e = new MyElement();
						e.setAnalysis(rs.getString("name"));
						e.setDate(dateFormat.format(date));
						e.setPrice(numberb*coefficient);
						mymodel.addElement(e);
					}

[Rob Camick]

Quit cross posting: http://stackoverflow.com/questions/28275181/set-value-in-jtable-dynamically

We don't appreciated spending time to answer questions only to find out they have already been answered in another forum.

[Sarra Sakka]

Sorry for this behavior, i need a solution that's why :/

[Rob Spoor]

Just BeForthrightWhenCrosspostingToOtherSites (<- click) next time.