DataPanel.java

package RowSetTest;

import java.awt.GridBagConstraints;
import java.awt.GridBagLayout;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.sql.SQLException;
import java.util.ArrayList;

import javax.sql.RowSet;
import javax.swing.JLabel;
import javax.swing.JPanel;
import javax.swing.JTextField;

/**
 * Panel pentru dare
 * @author Dan
 *
 */
public class DataPanel extends JPanel
{

	/**
	 * 
	 */
	private static final long serialVersionUID = 1L;
	
	/**
	 * @param rs resultatul ce trebue efisat
	 * @throws SQLException 
	 */
	public DataPanel(RowSet rs) throws SQLException
	{
		fields = new ArrayList<JTextField>();
		
		setLayout(new GridBagLayout());
		GridBagConstraints gbc = new GridBagConstraints();
		gbc.gridwidth = 1;
		gbc.gridheight = 1;
		
		ResultSetMetaData rsmd = rs.getMetaData();
		for(int i = 1; i <= rsmd.getColumnCount(); i++)
		{
			gbc.gridy = i - 1;
			
			String columnName = rsmd.getColumnLabel(i);
			gbc.gridx = 0;
			gbc.anchor = GridBagConstraints.EAST;
			add(new JLabel(columnName),gbc);
			
			int columnWidth = 50;
			JTextField tb = new JTextField(columnWidth);
			fields.add(tb);
			
			gbc.gridx = 1;
			gbc.anchor = GridBagConstraints.WEST;
			add(tb,gbc);
		}
	}
	
	/**
	 * Afisarea rindului. Cimpului de redactare se umple cu valorile coloanelor
	 * @throws SQLException 
	 */
	public void showRow(ResultSet rs) throws SQLException
	{
		for(int i = 1; i <= fields.size(); i++)
		{
			String field = rs.getString(i);
			System.out.println(field);
			JTextField tb = (JTextField) fields.get(i-1);
			tb.setText(field);
			
		}
	}
	
	private ArrayList<JTextField> fields;
}