JAVA GUI – How To Display JTable Selected Rows On Another JFrame JTabel – Netbeans (Source Code)
JAVA GUI – How To Display JTable Selected Rows On Another JFrame JTabel – Netbeans (Source Code)
The select rows from one JFrame Form Are Displayed On Another Jframe Form Table in this tutorial. To get the rows from one jtable am using getSelectedRows() method to get all selected rows. The method returns an arrays of rows, So am looping on them while outputting them on a new jframe form that appears on button click.
Code Snippet
public void displaySelectedRowsFromJFrameJtableToAnotherJFrameJtable() {
int[] getSelectedRows = jTable1.getSelectedRows();
Object[] newFormRows = new Object[4];
for (int i = 0; i < getSelectedRows.length; i++) {
newFormRows[0] = model.getValueAt(getSelectedRows[i], 0);
newFormRows[1] = model.getValueAt(getSelectedRows[i], 1);
newFormRows[2] = model.getValueAt(getSelectedRows[i], 2);
newFormRows[3] = model.getValueAt(getSelectedRows[i], 3);
selectedRowsJFrameForm.SelectedRowsJFrameFormModel.addRow(newFormRows);
}
selectedRowsJFrameForm.setVisible(true);
selectedRowsJFrameForm.setDefaultCloseOperation(JFrame.DISPOSE_ON_CLOSE);
}
Entire Source Code
/*
* How To Import Excel in Java JTable (GUI) Swing Application Tutorial - Netbeans
*/
package AddDataToJTable;
import java.awt.Component;
import java.awt.Image;
import java.io.BufferedInputStream;
import java.io.BufferedOutputStream;
import java.io.File;
import java.io.FileInputStream;
import java.io.FileNotFoundException;
import java.io.FileOutputStream;
import java.io.IOException;
import javax.swing.ImageIcon;
import javax.swing.JFileChooser;
import javax.swing.JFrame;
import javax.swing.JLabel;
import javax.swing.JOptionPane;
import javax.swing.JTable;
import javax.swing.filechooser.FileNameExtensionFilter;
import javax.swing.table.DefaultTableModel;
import javax.swing.table.TableCellRenderer;
import javax.swing.table.TableColumn;
import org.apache.poi.xssf.usermodel.XSSFCell;
import org.apache.poi.xssf.usermodel.XSSFRow;
import org.apache.poi.xssf.usermodel.XSSFSheet;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;
/**
*
* @author Genuine
*/
public class AddDataToJTable extends javax.swing.JFrame {
/**
* Creates new form AddDataToJTable
*/
public AddDataToJTable() {
initComponents();
//Calling method/function to add column header to jtable
addTableHeader();
}
ViewSelectedRowJFrame viewSelectedRow = new ViewSelectedRowJFrame();
SelectedRowsJFrameForm selectedRowsJFrameForm = new SelectedRowsJFrameForm();
/**
* 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.
*/
@SuppressWarnings("unchecked")
// <editor-fold defaultstate="collapsed" desc="Generated Code">
private void initComponents() {
buttonGroup1 = new javax.swing.ButtonGroup();
buttonGroup2 = new javax.swing.ButtonGroup();
jScrollPane1 = new javax.swing.JScrollPane();
jTable1 = new javax.swing.JTable();
jTextFieldName = new javax.swing.JTextField();
jLabel1 = new javax.swing.JLabel();
jRadioButtonMale = new javax.swing.JRadioButton();
jRadioButtonFemale = new javax.swing.JRadioButton();
jCheckBoxJava = new javax.swing.JCheckBox();
jCheckBoxPHP = new javax.swing.JCheckBox();
jComboBoxSubjects = new javax.swing.JComboBox();
jButton1 = new javax.swing.JButton();
jLabelImage = new javax.swing.JLabel();
jButtonBrowseImage = new javax.swing.JButton();
jButton2 = new javax.swing.JButton();
jButton3 = new javax.swing.JButton();
jButton4 = new javax.swing.JButton();
jButton5 = new javax.swing.JButton();
jButton6 = new javax.swing.JButton();
jButton7 = new javax.swing.JButton();
jButton8 = new javax.swing.JButton();
jButton9 = new javax.swing.JButton();
setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE);
jTable1.setModel(new javax.swing.table.DefaultTableModel(
new Object [][] {
},
new String [] {
"null"
}
));
jTable1.addMouseListener(new java.awt.event.MouseAdapter() {
public void mouseClicked(java.awt.event.MouseEvent evt) {
jTable1MouseClicked(evt);
}
});
jScrollPane1.setViewportView(jTable1);
jTextFieldName.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
jTextFieldNameActionPerformed(evt);
}
});
jLabel1.setText("Name");
buttonGroup1.add(jRadioButtonMale);
jRadioButtonMale.setText("Male");
buttonGroup1.add(jRadioButtonFemale);
jRadioButtonFemale.setText("Female");
buttonGroup2.add(jCheckBoxJava);
jCheckBoxJava.setText("Java");
buttonGroup2.add(jCheckBoxPHP);
jCheckBoxPHP.setText("PHP");
jComboBoxSubjects.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "Computer Science", "Information Technology", "Business Information Technology" }));
jButton1.setText("Add Data");
jButton1.addMouseListener(new java.awt.event.MouseAdapter() {
public void mouseClicked(java.awt.event.MouseEvent evt) {
jButton1MouseClicked(evt);
}
});
jButton1.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
jButton1ActionPerformed(evt);
}
});
jButtonBrowseImage.setText("Browse //");
jButtonBrowseImage.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
jButtonBrowseImageActionPerformed(evt);
}
});
jButton2.setText("Move Up");
jButton2.addMouseListener(new java.awt.event.MouseAdapter() {
public void mouseClicked(java.awt.event.MouseEvent evt) {
jButton2MouseClicked(evt);
}
});
jButton2.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
jButton2ActionPerformed(evt);
}
});
jButton3.setText("Move Down");
jButton3.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
jButton3ActionPerformed(evt);
}
});
jButton4.setText("Clear");
jButton4.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
jButton4ActionPerformed(evt);
}
});
jButton5.setText("View Selected Row");
jButton5.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
jButton5ActionPerformed(evt);
}
});
jButton6.setText("Export (Excel)");
jButton6.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
jButton6ActionPerformed(evt);
}
});
jButton7.setText("Import (Excel)");
jButton7.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
jButton7ActionPerformed(evt);
}
});
jButton8.setText("Delete Selected Row");
jButton8.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
jButton8ActionPerformed(evt);
}
});
jButton9.setText("View Selected Rows");
jButton9.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
jButton9ActionPerformed(evt);
}
});
javax.swing.GroupLayout layout = new javax.swing.GroupLayout(getContentPane());
getContentPane().setLayout(layout);
layout.setHorizontalGroup(
layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(layout.createSequentialGroup()
.addContainerGap()
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(layout.createSequentialGroup()
.addComponent(jScrollPane1, javax.swing.GroupLayout.DEFAULT_SIZE, 722, Short.MAX_VALUE)
.addContainerGap())
.addGroup(layout.createSequentialGroup()
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING, false)
.addComponent(jComboBoxSubjects, 0, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
.addComponent(jButton2, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
.addGroup(layout.createSequentialGroup()
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addComponent(jRadioButtonMale)
.addComponent(jCheckBoxJava))
.addGap(18, 18, 18)
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addComponent(jCheckBoxPHP)
.addComponent(jRadioButtonFemale)))
.addGroup(layout.createSequentialGroup()
.addComponent(jTextFieldName, javax.swing.GroupLayout.PREFERRED_SIZE, 97, javax.swing.GroupLayout.PREFERRED_SIZE)
.addGap(18, 18, 18)
.addComponent(jLabel1)))
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING, false)
.addComponent(jButton8, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
.addComponent(jButton6, javax.swing.GroupLayout.Alignment.TRAILING, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
.addComponent(jButton3, javax.swing.GroupLayout.DEFAULT_SIZE, 165, Short.MAX_VALUE)
.addComponent(jButton4, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
.addComponent(jButton5, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
.addComponent(jButton7, javax.swing.GroupLayout.Alignment.TRAILING, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
.addGap(10, 10, 10)
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(javax.swing.GroupLayout.Alignment.TRAILING, layout.createSequentialGroup()
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(javax.swing.GroupLayout.Alignment.TRAILING, layout.createSequentialGroup()
.addComponent(jButton9, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
.addGap(18, 18, 18)
.addComponent(jButton1, javax.swing.GroupLayout.PREFERRED_SIZE, 150, javax.swing.GroupLayout.PREFERRED_SIZE))
.addComponent(jButtonBrowseImage, javax.swing.GroupLayout.Alignment.TRAILING, javax.swing.GroupLayout.PREFERRED_SIZE, 150, javax.swing.GroupLayout.PREFERRED_SIZE))
.addGap(15, 15, 15))
.addComponent(jLabelImage, javax.swing.GroupLayout.Alignment.TRAILING, javax.swing.GroupLayout.PREFERRED_SIZE, 146, javax.swing.GroupLayout.PREFERRED_SIZE)))))
);
layout.setVerticalGroup(
layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(javax.swing.GroupLayout.Alignment.TRAILING, layout.createSequentialGroup()
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(layout.createSequentialGroup()
.addContainerGap()
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(jTextFieldName, javax.swing.GroupLayout.PREFERRED_SIZE, 30, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(jLabel1)
.addComponent(jButton8, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(jRadioButtonMale)
.addComponent(jRadioButtonFemale))
.addComponent(jButton7, javax.swing.GroupLayout.PREFERRED_SIZE, 29, javax.swing.GroupLayout.PREFERRED_SIZE))
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addComponent(jButton6, javax.swing.GroupLayout.PREFERRED_SIZE, 28, javax.swing.GroupLayout.PREFERRED_SIZE)
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(layout.createSequentialGroup()
.addGap(5, 5, 5)
.addComponent(jButton5, javax.swing.GroupLayout.PREFERRED_SIZE, 35, javax.swing.GroupLayout.PREFERRED_SIZE))
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(jCheckBoxJava)
.addComponent(jCheckBoxPHP)))
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addComponent(jComboBoxSubjects, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(jButton4, javax.swing.GroupLayout.PREFERRED_SIZE, 41, javax.swing.GroupLayout.PREFERRED_SIZE)))
.addGroup(layout.createSequentialGroup()
.addComponent(jLabelImage, javax.swing.GroupLayout.PREFERRED_SIZE, 121, javax.swing.GroupLayout.PREFERRED_SIZE)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addComponent(jButtonBrowseImage, javax.swing.GroupLayout.PREFERRED_SIZE, 38, javax.swing.GroupLayout.PREFERRED_SIZE)))
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING, false)
.addComponent(jButton9, javax.swing.GroupLayout.DEFAULT_SIZE, 35, Short.MAX_VALUE)
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING, false)
.addComponent(jButton3, javax.swing.GroupLayout.DEFAULT_SIZE, 35, Short.MAX_VALUE)
.addComponent(jButton1, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
.addComponent(jButton2, javax.swing.GroupLayout.Alignment.TRAILING, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)))
.addGap(28, 28, 28)
.addComponent(jScrollPane1, javax.swing.GroupLayout.PREFERRED_SIZE, 251, javax.swing.GroupLayout.PREFERRED_SIZE)
.addContainerGap())
);
pack();
setLocationRelativeTo(null);
}// </editor-fold>
private void jTextFieldNameActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add your handling code here:
}
DefaultTableModel model;
String name = "";
String gender = "";
String programmingLanguage = "";
String Subject = "";
String selectedImagePath = "";
String excelImagePath = "";
// byte imageJtable = new Byte(1024);
//Adding table headers
public void addTableHeader() {
model = (DefaultTableModel) jTable1.getModel();
Object[] newIdentifiers = new Object[]{"Name", "Gender", "Language", "Subject", "Image"};
model.setColumnIdentifiers(newIdentifiers);
//Get Image column and override TableCellRenderer class component method (getTableCellRendererComponent)
jTable1.getColumn("Image").setCellRenderer(new myTableCellRenderer());
}
private void populateInputfields() {
// Display data from jtable in input fields
int selectedRow = jTable1.getSelectedRow();
jTextFieldName.setText(model.getValueAt(selectedRow, 0).toString());
String tableGender = model.getValueAt(selectedRow, 1).toString();
if (tableGender.equals("Male")) {
jRadioButtonMale.setSelected(true);
} else if (tableGender.equals("Female")) {
jRadioButtonFemale.setSelected(true);
}
String checkPLanguage = model.getValueAt(selectedRow, 2).toString();
if (checkPLanguage.equals("Java")) {
jCheckBoxJava.setSelected(true);
} else if (checkPLanguage.equals("PHP")) {
jCheckBoxPHP.setSelected(true);
}
String comboSub = model.getValueAt(selectedRow, 3).toString();
for (int i = 0; i < jComboBoxSubjects.getItemCount(); i++) {
if (jComboBoxSubjects.getItemAt(i).toString().equalsIgnoreCase(comboSub)) {
jComboBoxSubjects.setSelectedIndex(i);
}
}
//The image is stored as ImageIcon in jlabel
//The image is stored in the fourth column
JLabel imageJl = (JLabel) model.getValueAt(selectedRow, 4);
//Retrieving image icon from jlabel
//Store image icon In ImageIcon type Variable
ImageIcon imageJLIcon = (ImageIcon) imageJl.getIcon();
//Resize image to fit to jlable
Image imageJLFit = imageJLIcon.getImage().getScaledInstance(jLabelImage.getWidth(), jLabelImage.getHeight(), Image.SCALE_SMOOTH);
//Display selected image on jlabel
jLabelImage.setIcon(new ImageIcon(imageJLFit));
}
class myTableCellRenderer implements TableCellRenderer {
@Override
public Component getTableCellRendererComponent(JTable table, Object value, boolean isSelected, boolean hasFocus, int row, int column) {
// Change Image column minimum width and maximum width
TableColumn tb = jTable1.getColumn("Image");
tb.setMaxWidth(60);
tb.setMinWidth(60);
jTable1.setRowHeight(60);
return (Component) value;
}
}
private void jButton1MouseClicked(java.awt.event.MouseEvent evt) {
// TODO add your handling code here:
}
private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add your handling code here:
name = jTextFieldName.getText();
if (jRadioButtonMale.isSelected()) {
gender = "Male";
} else if (jRadioButtonFemale.isSelected()) {
gender = "Female";
}
if (jCheckBoxJava.isSelected()) {
programmingLanguage = "Java";
} else if (jCheckBoxPHP.isSelected()) {
programmingLanguage = "PHP";
}
Subject = jComboBoxSubjects.getSelectedItem().toString();
JLabel imageLabel = new JLabel();
ImageIcon imageicon = new ImageIcon(selectedImagePath);
//Resize image to fixed dimensions 60 * 60 (width and height).
Image imageIc = imageicon.getImage().getScaledInstance(60, 60, Image.SCALE_SMOOTH);
// Set Description
ImageIcon excelSetDescription = new ImageIcon(imageIc);
excelSetDescription.setDescription(selectedImagePath);
//Storing imageicon in a jlabel
imageLabel.setIcon(excelSetDescription);
//Checking if one or more field is empty
if (name.isEmpty() || gender.isEmpty() || programmingLanguage.isEmpty() || Subject.isEmpty() || imageIc == null) {
JOptionPane.showMessageDialog(null, "One Or More Fields Are Empty");
} else {
// JOptionPane.showMessageDialog(null, "All Fields are filled");
//Adding entered data to jtable
model.addRow(new Object[]{name, gender, programmingLanguage, Subject, imageLabel});
JOptionPane.showMessageDialog(null, "Data Inserted");
//clear fields after inserting the data
clearFields();
}
}
private void jTable1MouseClicked(java.awt.event.MouseEvent evt) {
// TODO add your handling code here:
//Display Selected row data in input field
populateInputfields();
}
private void jButtonBrowseImageActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add your handling code here:
// Setting default browser location
JFileChooser browseImageFile = new JFileChooser("C:\\Users\\Public\\Pictures\\Sample Pictures");
//Filter image extensions
FileNameExtensionFilter fnef = new FileNameExtensionFilter("IMAGES", "png", "jpg", "jpeg");
browseImageFile.addChoosableFileFilter(fnef);
int showOpenDialogue = browseImageFile.showOpenDialog(null);
if (showOpenDialogue == JFileChooser.APPROVE_OPTION) {
File selectedImageFile = browseImageFile.getSelectedFile();
selectedImagePath = selectedImageFile.getAbsolutePath();
JOptionPane.showMessageDialog(null, selectedImagePath);
//Display image on jlable
ImageIcon ii = new ImageIcon(selectedImagePath);
// Resize image to fit jlabel
Image image = ii.getImage().getScaledInstance(jLabelImage.getWidth(), jLabelImage.getHeight(), Image.SCALE_SMOOTH);
jLabelImage.setIcon(new ImageIcon(image));
}
}
//Move up button
private void jButton2ActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add your handling code here:
//Get jtable selected row
int currentlySelectedRow = jTable1.getSelectedRow();
if (currentlySelectedRow > 0) {
// Substact one (1) from current row to move upwards
model.moveRow(currentlySelectedRow, currentlySelectedRow, currentlySelectedRow - 1);
jTable1.getSelectionModel().setSelectionInterval(currentlySelectedRow - 1, currentlySelectedRow - 1);
} else {
JOptionPane.showMessageDialog(null, "You have reached the end!! Click move down button - to move downwards");
}
}
private void jButton3ActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add your handling code here:
//Get jtable selected row
int currentlySelectedRow = jTable1.getSelectedRow();
if (currentlySelectedRow < jTable1.getRowCount() - 1) {
// Add one (1) To current row to move downwards
model.moveRow(currentlySelectedRow, currentlySelectedRow, currentlySelectedRow + 1);
jTable1.getSelectionModel().setSelectionInterval(currentlySelectedRow + 1, currentlySelectedRow + 1);
} else {
JOptionPane.showMessageDialog(null, "You have reached the end!! Click move up button - to move upwards");
}
}
private void jButton2MouseClicked(java.awt.event.MouseEvent evt) {
// TODO add your handling code here:
//Display Selected row data in input field
}
private void jButton5ActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add your handling code here:
viewSelectedRow.setVisible(true);
//prevent the frame from closing the parent frame
viewSelectedRow.setDefaultCloseOperation(JFrame.DISPOSE_ON_CLOSE);
// Get selected row
int selectedRowForNewJframe = jTable1.getSelectedRow();
// check if the row is selected
if (selectedRowForNewJframe == -1) {
//display error message
viewSelectedRow.jLabel1NoselectedRowMessage.setText("No Row Selected !!..");
} else {
//Clear error message first
viewSelectedRow.jLabel1NoselectedRowMessage.setText(null);
System.out.println("selected row value " + selectedRowForNewJframe);
//Retrieving jtable selected row
String newName = model.getValueAt(selectedRowForNewJframe, 0).toString();
String newGender = model.getValueAt(selectedRowForNewJframe, 1).toString();
String newProgrammingLanguage = model.getValueAt(selectedRowForNewJframe, 2).toString();
String newsubject = model.getValueAt(selectedRowForNewJframe, 3).toString();
JLabel newImageJL = (JLabel) model.getValueAt(selectedRowForNewJframe, 4);
ImageIcon newImageIcon = (ImageIcon) newImageJL.getIcon();
//Resize image to fit new Jlabel
Image newImage = newImageIcon.getImage().getScaledInstance(viewSelectedRow.jLabelImageNewJframe.getWidth(), viewSelectedRow.jLabelImageNewJframe.getHeight(), Image.SCALE_SMOOTH);
//Displaying selected row on new jframe input fields
viewSelectedRow.jTextFieldNameNewJframe.setText(newName);
viewSelectedRow.jTextFieldGenderNewJframe.setText(newGender);
viewSelectedRow.jTextFieldPLanguageNewJframe.setText(newProgrammingLanguage);
viewSelectedRow.jTextFieldSubjectNewJframe.setText(newsubject);
viewSelectedRow.jLabelImageNewJframe.setIcon(new ImageIcon(newImage));
}
}
private void jButton4ActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add your handling code here:
clearFields();
}
private void jButton6ActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add your handling code here:
FileOutputStream excelFOU = null;
BufferedOutputStream excelBOU = null;
XSSFWorkbook excelJTableExporter = null;
//Choose Location For Saving Excel File
JFileChooser excelFileChooser = new JFileChooser("C:\\Users\\Authentic\\Desktop");
// Change Dilog Box Title
excelFileChooser.setDialogTitle("Save As");
// Onliny filter files with these extensions "xls", "xlsx", "xlsm"
FileNameExtensionFilter fnef = new FileNameExtensionFilter("EXCEL FILES", "xls", "xlsx", "xlsm");
excelFileChooser.setFileFilter(fnef);
int excelChooser = excelFileChooser.showSaveDialog(null);
// Check if save button is clicked
if (excelChooser == JFileChooser.APPROVE_OPTION) {
try {
//Import excel poi libraries to netbeans
excelJTableExporter = new XSSFWorkbook();
XSSFSheet excelSheet = excelJTableExporter.createSheet("JTable Sheet");
// Loop to get jtable columns and rows
for (int i = 0; i < model.getRowCount(); i++) {
XSSFRow excelRow = excelSheet.createRow(i);
for (int j = 0; j < model.getColumnCount(); j++) {
XSSFCell excelCell = excelRow.createCell(j);
//Now Get ImageNames From JLabel
//get the last column
if (j == model.getColumnCount() - 1) {
JLabel excelJL = (JLabel) model.getValueAt(i, j);
ImageIcon excelIMageIcon = (ImageIcon) excelJL.getIcon();
//Before retrieving the description of the image first set it...
excelImagePath = excelIMageIcon.getDescription();
}
excelCell.setCellValue(model.getValueAt(i, j).toString());
// Change the values of the fourth column to image paths
if (excelCell.getColumnIndex() == model.getColumnCount() - 1) {
excelCell.setCellValue(excelImagePath);
}
}
} //Append xlsx file extensions to selected files. To create unique file names
excelFOU = new FileOutputStream(excelFileChooser.getSelectedFile() + ".xlsx");
excelBOU = new BufferedOutputStream(excelFOU);
excelJTableExporter.write(excelBOU);
JOptionPane.showMessageDialog(null, "Exported Successfully !!!........");
} catch (FileNotFoundException ex) {
ex.printStackTrace();
} catch (IOException ex) {
ex.printStackTrace();
} finally {
try {
if (excelBOU != null) {
excelBOU.close();
}
if (excelFOU != null) {
excelFOU.close();
}
if (excelJTableExporter != null) {
excelJTableExporter.close();
}
} catch (IOException ex) {
ex.printStackTrace();
}
}
}
}
private void jButton7ActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add your handling code here:
File excelFile;
FileInputStream excelFIS = null;
BufferedInputStream excelBIS = null;
XSSFWorkbook excelJTableImport = null;
//Select Default Path
String defaultCurrentDirectoryPath = "C:\\Users\\Authentic\\Desktop";
JFileChooser excelFileChooser = new JFileChooser(defaultCurrentDirectoryPath);
//Filter Only Excel Files
FileNameExtensionFilter fnef = new FileNameExtensionFilter("EXCEL FILES", "xls", "xlsx", "xlsm");
excelFileChooser.setFileFilter(fnef);
//Set Dialog Title
excelFileChooser.setDialogTitle("Select Excel File");
int excelChooser = excelFileChooser.showOpenDialog(null);
//If Open Button Is clicked
if (excelChooser == JFileChooser.APPROVE_OPTION) {
try {
excelFile = excelFileChooser.getSelectedFile();
excelFIS = new FileInputStream(excelFile);
excelBIS = new BufferedInputStream(excelFIS);
excelJTableImport = new XSSFWorkbook(excelBIS);
XSSFSheet excelSheet = excelJTableImport.getSheetAt(0);
//Looping through excel columns and rows
for (int row = 0; row < excelSheet.getLastRowNum(); row++) {
XSSFRow excelRow = excelSheet.getRow(row);
XSSFCell excelNAme = excelRow.getCell(0);
XSSFCell excelGender = excelRow.getCell(1);
XSSFCell excelProgrammingLanguage = excelRow.getCell(2);
XSSFCell excelSubject = excelRow.getCell(3);
XSSFCell excelImage = excelRow.getCell(4);
//resize images
JLabel excelJL = new JLabel(new ImageIcon(new ImageIcon(excelImage.toString()).getImage().getScaledInstance(60, 60, Image.SCALE_SMOOTH)));
model.addRow(new Object[]{excelNAme, excelGender, excelProgrammingLanguage, excelSubject, excelJL});
}
JOptionPane.showMessageDialog(null, "Imported Successfully.. !! ");
} catch (FileNotFoundException ex) {
JOptionPane.showMessageDialog(null, ex.getMessage());
} catch (IOException ex) {
JOptionPane.showMessageDialog(null, ex.getMessage());
} finally {
try {
if (excelFIS != null) {
excelFIS.close();
}
if (excelBIS != null) {
excelBIS.close();
}
if (excelJTableImport != null) {
excelJTableImport.close();
}
} catch (IOException iOException) {
JOptionPane.showMessageDialog(null, iOException.getMessage());
}
}
}
}
private void jButton8ActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add your handling code here:
//Delete Selected Row
int getSelectedRowForDeletion = jTable1.getSelectedRow();
//Check if their is a row selected
if (getSelectedRowForDeletion >= 0) {
model.removeRow(getSelectedRowForDeletion);
JOptionPane.showMessageDialog(null, "Row Deleted");
} else {
JOptionPane.showMessageDialog(null, "Unable To Delete");
}
}
private void jButton9ActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add your handling code here:
int[] getSelectedRows = jTable1.getSelectedRows();
Object[] newFormRows = new Object[4];
for (int i = 0; i < getSelectedRows.length; i++) {
newFormRows[0] = model.getValueAt(getSelectedRows[i], 0);
newFormRows[1] = model.getValueAt(getSelectedRows[i], 1);
newFormRows[2] = model.getValueAt(getSelectedRows[i], 2);
newFormRows[3] = model.getValueAt(getSelectedRows[i], 3);
selectedRowsJFrameForm.SelectedRowsJFrameFormModel.addRow(newFormRows);
}
selectedRowsJFrameForm.setVisible(true);
selectedRowsJFrameForm.setDefaultCloseOperation(JFrame.DISPOSE_ON_CLOSE);
}
/**
* @param args the command line arguments
*/
public static void main(String args[]) {
/* Set the Nimbus look and feel */
//<editor-fold defaultstate="collapsed" desc=" Look and feel setting code (optional) ">
/* If Nimbus (introduced in Java SE 6) is not available, stay with the default look and feel.
* For details see http://download.oracle.com/javase/tutorial/uiswing/lookandfeel/plaf.html
*/
try {
for (javax.swing.UIManager.LookAndFeelInfo info : javax.swing.UIManager.getInstalledLookAndFeels()) {
if ("Nimbus".equals(info.getName())) {
javax.swing.UIManager.setLookAndFeel(info.getClassName());
break;
}
}
} catch (ClassNotFoundException ex) {
java.util.logging.Logger.getLogger(AddDataToJTable.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
} catch (InstantiationException ex) {
java.util.logging.Logger.getLogger(AddDataToJTable.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
} catch (IllegalAccessException ex) {
java.util.logging.Logger.getLogger(AddDataToJTable.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
} catch (javax.swing.UnsupportedLookAndFeelException ex) {
java.util.logging.Logger.getLogger(AddDataToJTable.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
}
//</editor-fold>
/* Create and display the form */
java.awt.EventQueue.invokeLater(new Runnable() {
public void run() {
new AddDataToJTable().setVisible(true);
}
});
}
// Variables declaration - do not modify
private javax.swing.ButtonGroup buttonGroup1;
private javax.swing.ButtonGroup buttonGroup2;
private javax.swing.JButton jButton1;
private javax.swing.JButton jButton2;
private javax.swing.JButton jButton3;
private javax.swing.JButton jButton4;
private javax.swing.JButton jButton5;
private javax.swing.JButton jButton6;
private javax.swing.JButton jButton7;
private javax.swing.JButton jButton8;
private javax.swing.JButton jButton9;
private javax.swing.JButton jButtonBrowseImage;
private javax.swing.JCheckBox jCheckBoxJava;
private javax.swing.JCheckBox jCheckBoxPHP;
private javax.swing.JComboBox jComboBoxSubjects;
private javax.swing.JLabel jLabel1;
private javax.swing.JLabel jLabelImage;
private javax.swing.JRadioButton jRadioButtonFemale;
private javax.swing.JRadioButton jRadioButtonMale;
private javax.swing.JScrollPane jScrollPane1;
private javax.swing.JTable jTable1;
private javax.swing.JTextField jTextFieldName;
// End of variables declaration
private void clearFields() {
jTextFieldName.setText("");
buttonGroup1.clearSelection();
buttonGroup2.clearSelection();
jComboBoxSubjects.setSelectedIndex(0);
jLabelImage.setIcon(null);
}
}
