Java tutorial
/* * To change this license header, choose License Headers in Project Properties. * To change this template file, choose Tools | Templates * and open the template in the editor. */ package mymoney; import com.itextpdf.text.pdf.PdfContentByte; import com.itextpdf.text.pdf.PdfTemplate; import com.itextpdf.text.pdf.PdfWriter; import java.sql.Connection; import java.sql.DatabaseMetaData; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.Statement; import javax.swing.DefaultListModel; import javax.swing.JOptionPane; import java.awt.*; import java.awt.event.*; import java.io.BufferedWriter; import java.io.File; import java.io.FileOutputStream; import java.io.FileWriter; import java.util.*; import java.util.List; import javafx.scene.control.ComboBox; import javax.swing.*; import javax.swing.plaf.basic.BasicComboBoxRenderer; import javax.swing.table.DefaultTableModel; import org.apache.poi.ss.usermodel.Row; import org.apache.poi.xssf.usermodel.XSSFCell; import org.apache.poi.xssf.usermodel.XSSFSheet; import org.apache.poi.xssf.usermodel.XSSFWorkbook; /** * * @author Vinayak Singh */ public class Multi_cal extends javax.swing.JFrame { String tablename = ""; String value = ""; /** * Creates new form Multi_cal */ public Multi_cal() { initComponents(); } /** * 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">//GEN-BEGIN:initComponents private void initComponents() { jScrollPane1 = new javax.swing.JScrollPane(); jTable1 = new javax.swing.JTable(); jLabel5 = new javax.swing.JLabel(); jButton9 = new javax.swing.JButton(); jScrollPane2 = new javax.swing.JScrollPane(); jList1 = new javax.swing.JList(); jname = new javax.swing.JTextField(); jButton3 = new javax.swing.JButton(); jLabel2 = new javax.swing.JLabel(); jRadioButton1 = new javax.swing.JRadioButton(); jRadioButton3 = new javax.swing.JRadioButton(); jButton2 = new javax.swing.JButton(); jComboBox3 = new javax.swing.JComboBox(); jLabel6 = new javax.swing.JLabel(); jButton8 = new javax.swing.JButton(); jButton10 = new javax.swing.JButton(); jTextField4 = new javax.swing.JTextField(); jButton5 = new javax.swing.JButton(); jButton7 = new javax.swing.JButton(); jTextField3 = new javax.swing.JTextField(); jComboBox2 = new javax.swing.JComboBox(); jLabel7 = new javax.swing.JLabel(); jButton1 = new javax.swing.JButton(); jButton4 = new javax.swing.JButton(); jButton11 = new javax.swing.JButton(); jButton6 = new javax.swing.JButton(); setDefaultCloseOperation(javax.swing.WindowConstants.DISPOSE_ON_CLOSE); setResizable(false); jTable1.setModel(new javax.swing.table.DefaultTableModel(new Object[][] { }, new String[] { "DATE", "NAME", "AMOUNT", "CATEGORY", "TYPE" }) { Class[] types = new Class[] { java.lang.String.class, java.lang.String.class, java.lang.Integer.class, java.lang.String.class, java.lang.String.class }; public Class getColumnClass(int columnIndex) { return types[columnIndex]; } }); jScrollPane1.setViewportView(jTable1); jLabel5.setText(" SELECT TABLE"); jButton9.setText("LOAD ALL TABLES"); jButton9.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { jButton9ActionPerformed(evt); } }); jScrollPane2.setViewportView(jList1); jname.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { jnameActionPerformed(evt); } }); jButton3.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { jButton3ActionPerformed(evt); } }); jRadioButton1.setText("NAME"); jRadioButton1.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { jRadioButton1ActionPerformed(evt); } }); jRadioButton3.setText("CATEGORY"); jRadioButton3.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { jRadioButton3ActionPerformed(evt); } }); jButton2.setText("VIEW ALL"); jButton2.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { jButton2ActionPerformed(evt); } }); jComboBox3.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "SELECT" })); jComboBox3.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { jComboBox3ActionPerformed(evt); } }); jLabel6.setText("CALCULATIONS BY NAME"); jButton8.setText("LOAD NAMES"); jButton8.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { jButton8ActionPerformed(evt); } }); jButton10.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { jButton10ActionPerformed(evt); } }); jButton5.setText("LOAD CATEGORIES"); jButton5.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { jButton5ActionPerformed(evt); } }); jButton7.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { jButton7ActionPerformed(evt); } }); jComboBox2.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "SELECT" })); jComboBox2.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { jComboBox2ActionPerformed(evt); } }); jLabel7.setText("CALCULATIONS BY CATEGORY"); jButton1.setText("CLOSE"); jButton1.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { jButton1ActionPerformed(evt); } }); jButton4.setText("SAVE DATA TO TEXT FILE"); jButton4.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { jButton4ActionPerformed(evt); } }); jButton11.setText("SAVE AS PDF"); jButton11.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { jButton11ActionPerformed(evt); } }); jButton6.setText("SAVE DATA TO EXCEL SHEET"); jButton6.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { jButton6ActionPerformed(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() .addComponent(jScrollPane1, javax.swing.GroupLayout.PREFERRED_SIZE, 507, javax.swing.GroupLayout.PREFERRED_SIZE) .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addGroup(javax.swing.GroupLayout.Alignment.TRAILING, layout.createSequentialGroup() .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE) .addGroup(layout .createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING) .addComponent(jLabel6, javax.swing.GroupLayout.PREFERRED_SIZE, 168, javax.swing.GroupLayout.PREFERRED_SIZE) .addGroup(javax.swing.GroupLayout.Alignment.LEADING, layout .createParallelGroup( javax.swing.GroupLayout.Alignment.LEADING, false) .addComponent(jButton8, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE) .addComponent(jComboBox3, 0, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE) .addComponent(jButton10, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE) .addComponent(jTextField4, javax.swing.GroupLayout.PREFERRED_SIZE, 168, javax.swing.GroupLayout.PREFERRED_SIZE))) .addGap(36, 36, 36)) .addGroup(layout.createSequentialGroup().addGap(75, 75, 75).addGroup(layout .createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addComponent(jButton9) .addGroup(layout .createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING, false) .addComponent(jLabel5, javax.swing.GroupLayout.DEFAULT_SIZE, 116, Short.MAX_VALUE) .addGroup(javax.swing.GroupLayout.Alignment.LEADING, layout .createSequentialGroup().addGap(2, 2, 2) .addGroup(layout .createParallelGroup( javax.swing.GroupLayout.Alignment.LEADING, false) .addComponent(jScrollPane2, javax.swing.GroupLayout.DEFAULT_SIZE, 114, Short.MAX_VALUE) .addComponent(jButton2, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))))) .addContainerGap(javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)) .addGroup(layout.createSequentialGroup().addGroup(layout .createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addGroup(layout.createSequentialGroup().addGap(18, 18, 18).addGroup(layout .createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addGroup(layout.createSequentialGroup() .addComponent(jLabel2, javax.swing.GroupLayout.PREFERRED_SIZE, 115, javax.swing.GroupLayout.PREFERRED_SIZE) .addPreferredGap( javax.swing.LayoutStyle.ComponentPlacement.UNRELATED) .addComponent(jname, javax.swing.GroupLayout.PREFERRED_SIZE, 137, javax.swing.GroupLayout.PREFERRED_SIZE)) .addComponent(jRadioButton3).addComponent(jRadioButton1) .addGroup(layout .createParallelGroup( javax.swing.GroupLayout.Alignment.TRAILING, false) .addComponent(jButton11, javax.swing.GroupLayout.Alignment.LEADING, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE) .addComponent(jButton4, javax.swing.GroupLayout.Alignment.LEADING, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE) .addComponent(jButton6, javax.swing.GroupLayout.Alignment.LEADING, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)))) .addGroup(layout.createSequentialGroup().addGap(53, 53, 53).addComponent( jButton3, javax.swing.GroupLayout.PREFERRED_SIZE, 187, javax.swing.GroupLayout.PREFERRED_SIZE))) .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, 82, Short.MAX_VALUE) .addGroup(layout .createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING) .addComponent(jLabel7, javax.swing.GroupLayout.PREFERRED_SIZE, 193, javax.swing.GroupLayout.PREFERRED_SIZE) .addComponent(jButton5, javax.swing.GroupLayout.Alignment.LEADING, javax.swing.GroupLayout.PREFERRED_SIZE, 168, javax.swing.GroupLayout.PREFERRED_SIZE) .addComponent(jComboBox2, javax.swing.GroupLayout.Alignment.LEADING, javax.swing.GroupLayout.PREFERRED_SIZE, 168, javax.swing.GroupLayout.PREFERRED_SIZE) .addComponent(jButton7, javax.swing.GroupLayout.Alignment.LEADING, javax.swing.GroupLayout.PREFERRED_SIZE, 168, javax.swing.GroupLayout.PREFERRED_SIZE) .addComponent(jTextField3, javax.swing.GroupLayout.Alignment.LEADING, javax.swing.GroupLayout.PREFERRED_SIZE, 168, javax.swing.GroupLayout.PREFERRED_SIZE)) .addContainerGap()))) .addGroup(javax.swing.GroupLayout.Alignment.TRAILING, layout.createSequentialGroup() .addContainerGap(javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE) .addComponent(jButton1).addGap(110, 110, 110))); layout.setVerticalGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addGroup(layout.createSequentialGroup().addContainerGap().addComponent(jButton1).addGap(16, 16, 16) .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addGroup( layout.createSequentialGroup().addComponent(jScrollPane1).addContainerGap()) .addGroup(layout.createSequentialGroup().addComponent(jButton9) .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED) .addGroup(layout .createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addGroup( layout.createSequentialGroup().addGap(0, 0, Short.MAX_VALUE) .addComponent(jLabel5, javax.swing.GroupLayout.PREFERRED_SIZE, 23, javax.swing.GroupLayout.PREFERRED_SIZE) .addGap(18, 18, 18).addComponent(jScrollPane2, javax.swing.GroupLayout.PREFERRED_SIZE, 149, javax.swing.GroupLayout.PREFERRED_SIZE)) .addGroup(layout.createSequentialGroup() .addComponent(jLabel6, javax.swing.GroupLayout.PREFERRED_SIZE, 22, javax.swing.GroupLayout.PREFERRED_SIZE) .addGap(18, 18, 18).addComponent(jButton8) .addGap(13, 13, 13) .addComponent(jComboBox3, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE) .addGap(18, 18, 18) .addComponent(jButton10, javax.swing.GroupLayout.PREFERRED_SIZE, 23, javax.swing.GroupLayout.PREFERRED_SIZE) .addGap(18, 18, 18).addComponent(jTextField4, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))) .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED) .addComponent(jButton2, javax.swing.GroupLayout.PREFERRED_SIZE, 23, javax.swing.GroupLayout.PREFERRED_SIZE) .addGroup(layout .createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addGroup(layout.createSequentialGroup().addGap(57, 57, 57) .addComponent(jLabel7, javax.swing.GroupLayout.PREFERRED_SIZE, 22, javax.swing.GroupLayout.PREFERRED_SIZE) .addPreferredGap( javax.swing.LayoutStyle.ComponentPlacement.UNRELATED) .addComponent(jButton5).addGap(20, 20, 20).addComponent( jComboBox2, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)) .addGroup(layout.createSequentialGroup().addGap(29, 29, 29) .addComponent(jRadioButton1) .addPreferredGap( javax.swing.LayoutStyle.ComponentPlacement.RELATED) .addComponent(jRadioButton3) .addPreferredGap( javax.swing.LayoutStyle.ComponentPlacement.UNRELATED) .addGroup(layout .createParallelGroup( javax.swing.GroupLayout.Alignment.LEADING) .addComponent(jLabel2, javax.swing.GroupLayout.PREFERRED_SIZE, 20, javax.swing.GroupLayout.PREFERRED_SIZE) .addComponent(jname, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)) .addPreferredGap( javax.swing.LayoutStyle.ComponentPlacement.RELATED) .addComponent(jButton3, javax.swing.GroupLayout.PREFERRED_SIZE, 26, javax.swing.GroupLayout.PREFERRED_SIZE))) .addGap(18, 18, 18) .addGroup(layout .createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addGroup(layout.createSequentialGroup().addGroup(layout .createParallelGroup( javax.swing.GroupLayout.Alignment.LEADING) .addGroup(layout.createSequentialGroup() .addComponent(jButton7, javax.swing.GroupLayout.PREFERRED_SIZE, 23, javax.swing.GroupLayout.PREFERRED_SIZE) .addGap(18, 18, 18)) .addGroup(javax.swing.GroupLayout.Alignment.TRAILING, layout.createSequentialGroup() .addComponent(jButton4).addGap(4, 4, 4) .addComponent(jButton6).addGap(1, 1, 1))) .addComponent(jTextField3, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE) .addGap(29, 29, 29)) .addGroup(javax.swing.GroupLayout.Alignment.TRAILING, layout.createSequentialGroup().addComponent(jButton11) .addGap(21, 21, 21))))))); pack(); }// </editor-fold>//GEN-END:initComponents private void jButton9ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jButton9ActionPerformed try { Path_Send p = new Path_Send(); String path = p.sendpath(); DefaultListModel model = new DefaultListModel(); Connection con = null; ResultSet rs1 = null; Statement stmt = null; Class.forName("org.sqlite.JDBC"); con = DriverManager.getConnection("jdbc:sqlite:" + path); DatabaseMetaData meta = con.getMetaData(); rs1 = meta.getTables(null, null, null, new String[] { "TABLE" }); while (rs1.next()) { String tableName = rs1.getString("TABLE_NAME"); if (tableName.equals("PASS")) continue; else if (tableName.equals("Name")) continue; else if (tableName.equals("Amount")) continue; else if (tableName.equals("Category")) continue; else model.addElement(tableName); } jList1.setModel(model); } catch (Exception e) { JOptionPane.showMessageDialog(null, "Error"); } // TODO add your handling code here: }//GEN-LAST:event_jButton9ActionPerformed private void jnameActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jnameActionPerformed // TODO add your handling code here: }//GEN-LAST:event_jnameActionPerformed private void jRadioButton3ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jRadioButton3ActionPerformed if (jRadioButton3.isSelected()) { DefaultTableModel model = (DefaultTableModel) jTable1.getModel(); model.setRowCount(0); jRadioButton1.setSelected(false); jLabel2.setText("CATEGORY"); jButton3.setText("FIND BY CATEGORY"); } // TODO add your handling code here: }//GEN-LAST:event_jRadioButton3ActionPerformed private void jButton3ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jButton3ActionPerformed DefaultTableModel model = (DefaultTableModel) jTable1.getModel(); model.setRowCount(0); Connection con = null; ResultSet rs = null, rs1 = null; Statement stmt = null; String query2 = new String(); try { if (jRadioButton1.isSelected()) { value = "NAME"; } else if (jRadioButton3.isSelected()) { value = "CATEGORY"; } String[] table = new String[1000]; String tables = new String(); String item = new String(); int indices[] = jList1.getSelectedIndices(); for (int i = 0; i < indices.length; i++) { item = (String) jList1.getModel().getElementAt(indices[i]); table[i] = item; } for (int i = 0; i < indices.length; i++) { if (i < indices.length - 1) tables += table[i] + ","; else tables += table[i]; } for (int j = 0; j < indices.length; j++) { if (j < indices.length - 1) { query2 += "SELECT * FROM " + table[j] + " WHERE " + value + " = '" + jname.getText().toUpperCase() + "' \nUNION ALL "; query2 += "\n"; } else query2 += "SELECT * FROM " + table[j] + " WHERE " + value + " = '" + jname.getText().toUpperCase() + "' ;"; } Path_Send p = new Path_Send(); String path = p.sendpath(); Class.forName("org.sqlite.JDBC"); con = DriverManager.getConnection("jdbc:sqlite:" + path); stmt = con.createStatement(); rs = stmt.executeQuery(query2); while (rs.next()) { String name = rs.getString("NAME"); String amount = rs.getString("AMOUNT"); String category = rs.getString("CATEGORY"); String date = rs.getString("DATE"); String type = rs.getString("TYPE"); model.addRow(new Object[] { date, name, amount, category, type }); } } catch (Exception e) { JOptionPane.showMessageDialog(null, "Error in connectivity"); } jname.setText(""); ;// TODO add your handling code here: }//GEN-LAST:event_jButton3ActionPerformed private void jRadioButton1ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jRadioButton1ActionPerformed if (jRadioButton1.isSelected()) { DefaultTableModel model = (DefaultTableModel) jTable1.getModel(); model.setRowCount(0); jRadioButton3.setSelected(false); jLabel2.setText("NAME"); jButton3.setText("FIND BY NAME"); } // TODO add your handling code here: }//GEN-LAST:event_jRadioButton1ActionPerformed private void jButton2ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jButton2ActionPerformed DefaultTableModel model = (DefaultTableModel) jTable1.getModel(); model.setRowCount(0); Connection con = null; ResultSet rs = null; Statement stmt = null; String items = new String(); String query2 = new String(); try { Path_Send p = new Path_Send(); String path = p.sendpath(); String[] table = new String[1000]; String tables = new String(); String item = new String(); int indices[] = jList1.getSelectedIndices(); for (int i = 0; i < indices.length; i++) { item = (String) jList1.getModel().getElementAt(indices[i]); table[i] = item; } for (int i = 0; i < indices.length; i++) { if (i < indices.length - 1) tables += table[i] + ","; else tables += table[i]; } Class.forName("org.sqlite.JDBC"); con = DriverManager.getConnection("jdbc:sqlite:" + path); stmt = con.createStatement(); for (int j = 0; j < indices.length; j++) { if (j < indices.length - 1) { query2 += "SELECT * FROM " + table[j] + " \nUNION ALL "; query2 += "\n"; } else query2 += "SELECT * FROM " + table[j] + " ;"; } rs = stmt.executeQuery(query2); while (rs.next()) { String name = rs.getString("NAME"); String amount = rs.getString("AMOUNT"); String category = rs.getString("CATEGORY"); String date = rs.getString("DATE"); String type = rs.getString("TYPE"); model.addRow(new Object[] { date, name, amount, category, type }); } rs.close(); stmt.close(); con.close(); } catch (Exception e) { JOptionPane.showMessageDialog(null, e); } // TODO add your handling code here: }//GEN-LAST:event_jButton2ActionPerformed private void jComboBox3ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jComboBox3ActionPerformed jButton10.setText("TOTAL FOR " + jComboBox3.getSelectedItem().toString()); // TODO add your handling code here: }//GEN-LAST:event_jComboBox3ActionPerformed private void jButton8ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jButton8ActionPerformed try { Path_Send p = new Path_Send(); String path = p.sendpath(); Connection con = null; ResultSet rs = null; Statement stmt = null; String items = new String(); String query2 = new String(); String[] table = new String[1000]; String tables = new String(); String item = new String(); int indices[] = jList1.getSelectedIndices(); for (int i = 0; i < indices.length; i++) { item = (String) jList1.getModel().getElementAt(indices[i]); table[i] = item; } for (int i = 0; i < indices.length; i++) { if (i < indices.length - 1) tables += table[i] + ","; else tables += table[i]; } Class.forName("org.sqlite.JDBC"); con = DriverManager.getConnection("jdbc:sqlite:" + path); stmt = con.createStatement(); for (int j = 0; j < indices.length; j++) { if (j < indices.length - 1) { query2 += "SELECT DISTINCT NAME FROM " + table[j] + " \nUNION "; query2 += "\n"; } else query2 += "SELECT DISTINCT NAME FROM " + table[j] + " ;"; } rs = stmt.executeQuery(query2); while (rs.next()) { String name = rs.getString("NAME"); jComboBox3.addItem(name); } } catch (Exception e) { e.printStackTrace(); } // TODO add your handling code here: }//GEN-LAST:event_jButton8ActionPerformed private void jButton10ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jButton10ActionPerformed DefaultTableModel mod = (DefaultTableModel) jTable1.getModel(); int sum = 0; String query2 = new String(); String test = jComboBox3.getSelectedItem().toString(); try { Path_Send p = new Path_Send(); String path = p.sendpath(); String[] table = new String[1000]; String tables = new String(); String item = new String(); int indices[] = jList1.getSelectedIndices(); for (int i = 0; i < indices.length; i++) { item = (String) jList1.getModel().getElementAt(indices[i]); table[i] = item; } for (int i = 0; i < indices.length; i++) { if (i < indices.length - 1) tables += table[i] + ","; else tables += table[i]; } for (int j = 0; j < indices.length; j++) { if (j < indices.length - 1) { query2 += "SELECT * FROM " + table[j] + " WHERE NAME = '" + test.toUpperCase() + "' \nUNION "; query2 += "\n"; } else query2 += "SELECT * FROM " + table[j] + " WHERE NAME = '" + test.toUpperCase() + "' ;"; } String value = "AMOUNT"; String cut = "CREDIT"; Connection con = null; ResultSet rs = null; Statement stmt = null; Class.forName("org.sqlite.JDBC"); con = DriverManager.getConnection("jdbc:sqlite:" + path); stmt = con.createStatement(); rs = stmt.executeQuery(query2); while (rs.next()) { String amount = rs.getString("AMOUNT"); sum += Integer.parseInt(amount); } String k = Integer.toString(sum); jTextField4.setText(k); } catch (Exception e) { JOptionPane.showMessageDialog(null, "Error in connectivity"); } // TODO add your handling code here: }//GEN-LAST:event_jButton10ActionPerformed private void jButton5ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jButton5ActionPerformed try { Path_Send p = new Path_Send(); String path = p.sendpath(); Connection con = null; ResultSet rs = null; Statement stmt = null; String query2 = new String(); String[] table = new String[1000]; String tables = new String(); String item = new String(); int indices[] = jList1.getSelectedIndices(); for (int i = 0; i < indices.length; i++) { item = (String) jList1.getModel().getElementAt(indices[i]); table[i] = item; } for (int i = 0; i < indices.length; i++) { if (i < indices.length - 1) tables += table[i] + ","; else tables += table[i]; } Class.forName("org.sqlite.JDBC"); con = DriverManager.getConnection("jdbc:sqlite:" + path); stmt = con.createStatement(); for (int j = 0; j < indices.length; j++) { if (j < indices.length - 1) { query2 += "SELECT CATEGORY FROM " + table[j] + " \nUNION "; query2 += "\n"; } else query2 += "SELECT CATEGORY FROM " + table[j] + " ;"; } rs = stmt.executeQuery(query2); while (rs.next()) { String name = rs.getString("CATEGORY"); jComboBox2.addItem(name); } } catch (Exception e) { e.printStackTrace(); } // TODO add your handling code here: }//GEN-LAST:event_jButton5ActionPerformed private void jButton7ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jButton7ActionPerformed DefaultTableModel mod = (DefaultTableModel) jTable1.getModel(); int sum = 0; String query2 = new String(); String test = jComboBox2.getSelectedItem().toString(); try { Path_Send p = new Path_Send(); String path = p.sendpath(); String value = "AMOUNT"; String cut = "CREDIT"; Connection con = null; ResultSet rs = null; Statement stmt = null; Class.forName("org.sqlite.JDBC"); con = DriverManager.getConnection("jdbc:sqlite:" + path); stmt = con.createStatement(); String[] table = new String[1000]; String tables = new String(); String item = new String(); int indices[] = jList1.getSelectedIndices(); for (int i = 0; i < indices.length; i++) { item = (String) jList1.getModel().getElementAt(indices[i]); table[i] = item; } for (int i = 0; i < indices.length; i++) { if (i < indices.length - 1) tables += table[i] + ","; else tables += table[i]; } for (int j = 0; j < indices.length; j++) { if (j < indices.length - 1) { query2 += "SELECT * FROM " + table[j] + " WHERE CATEGORY = '" + test.toUpperCase() + "' \nUNION "; query2 += "\n"; } else query2 += "SELECT * FROM " + table[j] + " WHERE CATEGORY = '" + test.toUpperCase() + "' ;"; } rs = stmt.executeQuery(query2); while (rs.next()) { String amount = rs.getString("AMOUNT"); sum += Integer.parseInt(amount); } String k = Integer.toString(sum); jTextField3.setText(k); } catch (Exception e) { JOptionPane.showMessageDialog(null, "Error in connectivity"); } // TODO add your handling code here: }//GEN-LAST:event_jButton7ActionPerformed private void jComboBox2ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jComboBox2ActionPerformed jButton7.setText("TOTAL " + jComboBox2.getSelectedItem().toString()); // TODO add your handling code here: }//GEN-LAST:event_jComboBox2ActionPerformed private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jButton1ActionPerformed this.dispose(); // TODO add your handling code here: }//GEN-LAST:event_jButton1ActionPerformed private void jButton4ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jButton4ActionPerformed JFileChooser cho = new JFileChooser(); cho.showSaveDialog(null); File f = cho.getSelectedFile(); String filename = f.getAbsolutePath(); try { DefaultTableModel model = (DefaultTableModel) jTable1.getModel(); FileWriter fw = new FileWriter(filename); BufferedWriter bw = new BufferedWriter(fw); bw = new BufferedWriter(new FileWriter(filename + ".txt", true)); for (int i = 0; i < jTable1.getRowCount(); i++) { bw.newLine(); for (int j = 0; j < jTable1.getColumnCount(); j++) { if (jTable1.getModel().getValueAt(i, j).toString().length() < 20) { bw.write(jTable1.getModel().getValueAt(i, j) + "\t\t"); } else { bw.write(jTable1.getModel().getValueAt(i, j) + " "); } } } bw.close(); fw.close(); JOptionPane.showMessageDialog(null, "Data exported to text file"); } catch (Exception e) { JOptionPane.showMessageDialog(null, "Error"); } }//GEN-LAST:event_jButton4ActionPerformed private void jButton11ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jButton11ActionPerformed getContentPane().setLayout(new BorderLayout()); DefaultTableModel model = (DefaultTableModel) jTable1.getModel(); JFileChooser cho = new JFileChooser(); cho.showSaveDialog(null); File f = cho.getSelectedFile(); String filename = f.getAbsolutePath(); com.itextpdf.text.Document document = new com.itextpdf.text.Document(); try { PdfWriter writer = PdfWriter.getInstance(document, new FileOutputStream(filename + ".pdf")); document.open(); PdfContentByte cb = writer.getDirectContent(); cb.saveState(); PdfTemplate pdfTemplate = cb.createTemplate(jTable1.getWidth(), jTable1.getHeight()); Graphics2D g2 = cb.createGraphicsShapes(800, 500); Shape oldClip = g2.getClip(); g2.clipRect(0, 0, 800, 500); jTable1.print(g2); g2.setClip(oldClip); g2.dispose(); cb.restoreState(); JOptionPane.showMessageDialog(null, "Data Exported to pdf"); } catch (Exception e) { JOptionPane.showMessageDialog(null, "Error"); } document.close(); // TODO add your handling code here: }//GEN-LAST:event_jButton11ActionPerformed private void jButton6ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jButton6ActionPerformed JFileChooser cho = new JFileChooser(); cho.showSaveDialog(null); File f = cho.getSelectedFile(); String filename = f.getAbsolutePath(); DefaultTableModel model = (DefaultTableModel) jTable1.getModel(); XSSFWorkbook workbook = new XSSFWorkbook(); XSSFSheet sheet = workbook.createSheet("New Data"); TreeMap<String, Object[]> data = new TreeMap<String, Object[]>(); data.put("1", new Object[] { "DATE", "NAME", "AMOUNT", "CATEGORY", "TYPE" }); for (int i = 0;;) { if (jTable1.getRowCount() != i) { data.put("2", new Object[] { jTable1.getValueAt(0, 0).toString(), jTable1.getValueAt(0, 1).toString(), jTable1.getValueAt(0, 2).toString(), jTable1.getValueAt(0, 3).toString(), jTable1.getValueAt(0, 4).toString() }); i++; } else break; if (jTable1.getRowCount() != i) { data.put("3", new Object[] { jTable1.getValueAt(1, 0).toString(), jTable1.getValueAt(1, 1).toString(), jTable1.getValueAt(1, 2).toString(), jTable1.getValueAt(1, 3).toString(), jTable1.getValueAt(1, 4).toString() }); i++; } else break; if (jTable1.getRowCount() != i) { data.put("4", new Object[] { jTable1.getValueAt(2, 0).toString(), jTable1.getValueAt(2, 1).toString(), jTable1.getValueAt(2, 2).toString(), jTable1.getValueAt(2, 3).toString(), jTable1.getValueAt(2, 4).toString() }); i++; } else break; if (jTable1.getRowCount() != i) { data.put("5", new Object[] { jTable1.getValueAt(3, 0).toString(), jTable1.getValueAt(3, 1).toString(), jTable1.getValueAt(3, 2).toString(), jTable1.getValueAt(3, 3).toString(), jTable1.getValueAt(3, 4).toString() }); i++; } else break; if (jTable1.getRowCount() != i) { data.put("6", new Object[] { jTable1.getValueAt(4, 0).toString(), jTable1.getValueAt(4, 1).toString(), jTable1.getValueAt(4, 2).toString(), jTable1.getValueAt(4, 3).toString(), jTable1.getValueAt(4, 4).toString() }); i++; } else break; if (jTable1.getRowCount() != i) { data.put("7", new Object[] { jTable1.getValueAt(5, 0).toString(), jTable1.getValueAt(5, 1).toString(), jTable1.getValueAt(5, 2).toString(), jTable1.getValueAt(5, 3).toString(), jTable1.getValueAt(5, 4).toString() }); i++; } else break; if (jTable1.getRowCount() != i) { data.put("8", new Object[] { jTable1.getValueAt(6, 0).toString(), jTable1.getValueAt(6, 1).toString(), jTable1.getValueAt(6, 2).toString(), jTable1.getValueAt(6, 3).toString(), jTable1.getValueAt(6, 4).toString() }); i++; } else break; if (jTable1.getRowCount() != i) { data.put("9", new Object[] { jTable1.getValueAt(7, 0).toString(), jTable1.getValueAt(7, 1).toString(), jTable1.getValueAt(7, 2).toString(), jTable1.getValueAt(7, 3).toString(), jTable1.getValueAt(7, 4).toString() }); i++; } else break; if (jTable1.getRowCount() != i) { data.put("10", new Object[] { jTable1.getValueAt(8, 0).toString(), jTable1.getValueAt(8, 1).toString(), jTable1.getValueAt(8, 2).toString(), jTable1.getValueAt(8, 3).toString(), jTable1.getValueAt(8, 4).toString() }); i++; } else break; if (jTable1.getRowCount() != i) { data.put("11", new Object[] { jTable1.getValueAt(9, 0).toString(), jTable1.getValueAt(9, 1).toString(), jTable1.getValueAt(9, 2).toString(), jTable1.getValueAt(9, 3).toString(), jTable1.getValueAt(9, 4).toString() }); i++; } else break; if (jTable1.getRowCount() != i) { data.put("12", new Object[] { jTable1.getValueAt(10, 0).toString(), jTable1.getValueAt(10, 1).toString(), jTable1.getValueAt(10, 2).toString(), jTable1.getValueAt(10, 3).toString(), jTable1.getValueAt(10, 4).toString() }); i++; } else break; if (jTable1.getRowCount() != i) { data.put("13", new Object[] { jTable1.getValueAt(11, 0).toString(), jTable1.getValueAt(11, 1).toString(), jTable1.getValueAt(11, 2).toString(), jTable1.getValueAt(11, 3).toString(), jTable1.getValueAt(11, 4).toString() }); i++; } else break; if (jTable1.getRowCount() != i) { data.put("14", new Object[] { jTable1.getValueAt(12, 0).toString(), jTable1.getValueAt(12, 1).toString(), jTable1.getValueAt(12, 2).toString(), jTable1.getValueAt(12, 3).toString(), jTable1.getValueAt(12, 4).toString() }); i++; } else break; if (jTable1.getRowCount() != i) { data.put("15", new Object[] { jTable1.getValueAt(13, 0).toString(), jTable1.getValueAt(13, 1).toString(), jTable1.getValueAt(13, 2).toString(), jTable1.getValueAt(13, 3).toString(), jTable1.getValueAt(13, 4).toString() }); i++; } else break; if (jTable1.getRowCount() != i) { data.put("16", new Object[] { jTable1.getValueAt(14, 0).toString(), jTable1.getValueAt(14, 1).toString(), jTable1.getValueAt(14, 2).toString(), jTable1.getValueAt(14, 3).toString(), jTable1.getValueAt(14, 4).toString() }); i++; } else break; if (jTable1.getRowCount() != i) { data.put("17", new Object[] { jTable1.getValueAt(15, 0).toString(), jTable1.getValueAt(15, 1).toString(), jTable1.getValueAt(15, 2).toString(), jTable1.getValueAt(15, 3).toString(), jTable1.getValueAt(15, 4).toString() }); i++; } else break; if (jTable1.getRowCount() != i) { data.put("18", new Object[] { jTable1.getValueAt(16, 0).toString(), jTable1.getValueAt(16, 1).toString(), jTable1.getValueAt(16, 2).toString(), jTable1.getValueAt(16, 3).toString(), jTable1.getValueAt(16, 4).toString() }); i++; } else break; if (jTable1.getRowCount() != i) { data.put("19", new Object[] { jTable1.getValueAt(17, 0).toString(), jTable1.getValueAt(17, 1).toString(), jTable1.getValueAt(17, 2).toString(), jTable1.getValueAt(17, 3).toString(), jTable1.getValueAt(17, 4).toString() }); i++; } else break; if (jTable1.getRowCount() != i) { data.put("20", new Object[] { jTable1.getValueAt(18, 0).toString(), jTable1.getValueAt(18, 1).toString(), jTable1.getValueAt(18, 2).toString(), jTable1.getValueAt(18, 3).toString(), jTable1.getValueAt(18, 4).toString() }); i++; } else break; if (jTable1.getRowCount() != i) { data.put("21", new Object[] { jTable1.getValueAt(19, 0).toString(), jTable1.getValueAt(19, 1).toString(), jTable1.getValueAt(19, 2).toString(), jTable1.getValueAt(19, 3).toString(), jTable1.getValueAt(19, 4).toString() }); i++; } else break; if (jTable1.getRowCount() != i) { data.put("22", new Object[] { jTable1.getValueAt(20, 0).toString(), jTable1.getValueAt(20, 1).toString(), jTable1.getValueAt(20, 2).toString(), jTable1.getValueAt(20, 3).toString(), jTable1.getValueAt(20, 4).toString() }); i++; } else break; if (jTable1.getRowCount() != i) { data.put("23", new Object[] { jTable1.getValueAt(21, 0).toString(), jTable1.getValueAt(21, 1).toString(), jTable1.getValueAt(21, 2).toString(), jTable1.getValueAt(21, 3).toString(), jTable1.getValueAt(21, 4).toString() }); i++; } else break; if (jTable1.getRowCount() != i) { data.put("24", new Object[] { jTable1.getValueAt(22, 0).toString(), jTable1.getValueAt(22, 1).toString(), jTable1.getValueAt(22, 2).toString(), jTable1.getValueAt(22, 3).toString(), jTable1.getValueAt(22, 4).toString() }); i++; } else break; if (jTable1.getRowCount() != i) { data.put("25", new Object[] { jTable1.getValueAt(23, 0).toString(), jTable1.getValueAt(23, 1).toString(), jTable1.getValueAt(23, 2).toString(), jTable1.getValueAt(23, 3).toString(), jTable1.getValueAt(23, 4).toString() }); i++; } else break; if (jTable1.getRowCount() != i) { data.put("26", new Object[] { jTable1.getValueAt(24, 0).toString(), jTable1.getValueAt(24, 1).toString(), jTable1.getValueAt(24, 2).toString(), jTable1.getValueAt(24, 3).toString(), jTable1.getValueAt(24, 4).toString() }); i++; } else break; if (jTable1.getRowCount() != i) { data.put("27", new Object[] { jTable1.getValueAt(25, 0).toString(), jTable1.getValueAt(25, 1).toString(), jTable1.getValueAt(25, 2).toString(), jTable1.getValueAt(25, 3).toString(), jTable1.getValueAt(25, 4).toString() }); i++; } else break; if (jTable1.getRowCount() != i) { data.put("28", new Object[] { jTable1.getValueAt(26, 0).toString(), jTable1.getValueAt(26, 1).toString(), jTable1.getValueAt(26, 2).toString(), jTable1.getValueAt(26, 3).toString(), jTable1.getValueAt(26, 4).toString() }); i++; } else break; if (jTable1.getRowCount() != i) { data.put("29", new Object[] { jTable1.getValueAt(27, 0).toString(), jTable1.getValueAt(27, 1).toString(), jTable1.getValueAt(27, 2).toString(), jTable1.getValueAt(27, 3).toString(), jTable1.getValueAt(27, 4).toString() }); i++; } else break; if (jTable1.getRowCount() != i) { data.put("30", new Object[] { jTable1.getValueAt(28, 0).toString(), jTable1.getValueAt(28, 1).toString(), jTable1.getValueAt(28, 2).toString(), jTable1.getValueAt(28, 3).toString(), jTable1.getValueAt(28, 4).toString() }); i++; } else break; if (jTable1.getRowCount() != i) { data.put("31", new Object[] { jTable1.getValueAt(29, 0).toString(), jTable1.getValueAt(29, 1).toString(), jTable1.getValueAt(29, 2).toString(), jTable1.getValueAt(29, 3).toString(), jTable1.getValueAt(29, 4).toString() }); i++; } else break; if (jTable1.getRowCount() != i) { data.put("32", new Object[] { jTable1.getValueAt(30, 0).toString(), jTable1.getValueAt(30, 1).toString(), jTable1.getValueAt(30, 2).toString(), jTable1.getValueAt(30, 3).toString(), jTable1.getValueAt(30, 4).toString() }); i++; } else break; if (jTable1.getRowCount() != i) { data.put("33", new Object[] { jTable1.getValueAt(31, 0).toString(), jTable1.getValueAt(31, 1).toString(), jTable1.getValueAt(31, 2).toString(), jTable1.getValueAt(31, 3).toString(), jTable1.getValueAt(31, 4).toString() }); i++; } else break; if (jTable1.getRowCount() != i) { data.put("34", new Object[] { jTable1.getValueAt(32, 0).toString(), jTable1.getValueAt(32, 1).toString(), jTable1.getValueAt(32, 2).toString(), jTable1.getValueAt(32, 3).toString(), jTable1.getValueAt(32, 4).toString() }); i++; } else break; if (jTable1.getRowCount() != i) { data.put("35", new Object[] { jTable1.getValueAt(33, 0).toString(), jTable1.getValueAt(33, 1).toString(), jTable1.getValueAt(33, 2).toString(), jTable1.getValueAt(33, 3).toString(), jTable1.getValueAt(33, 4).toString() }); i++; } else break; if (jTable1.getRowCount() != i) { data.put("36", new Object[] { jTable1.getValueAt(34, 0).toString(), jTable1.getValueAt(34, 1).toString(), jTable1.getValueAt(34, 2).toString(), jTable1.getValueAt(34, 3).toString(), jTable1.getValueAt(34, 4).toString() }); i++; } else break; if (jTable1.getRowCount() != i) { data.put("37", new Object[] { jTable1.getValueAt(35, 0).toString(), jTable1.getValueAt(35, 1).toString(), jTable1.getValueAt(35, 2).toString(), jTable1.getValueAt(35, 3).toString(), jTable1.getValueAt(35, 4).toString() }); i++; } else break; if (jTable1.getRowCount() != i) { data.put("38", new Object[] { jTable1.getValueAt(36, 0).toString(), jTable1.getValueAt(36, 1).toString(), jTable1.getValueAt(36, 2).toString(), jTable1.getValueAt(36, 3).toString(), jTable1.getValueAt(36, 4).toString() }); i++; } else break; if (jTable1.getRowCount() != i) { data.put("39", new Object[] { jTable1.getValueAt(37, 0).toString(), jTable1.getValueAt(37, 1).toString(), jTable1.getValueAt(37, 2).toString(), jTable1.getValueAt(37, 3).toString(), jTable1.getValueAt(37, 4).toString() }); i++; } else break; if (jTable1.getRowCount() != i) { data.put("40", new Object[] { jTable1.getValueAt(38, 0).toString(), jTable1.getValueAt(38, 1).toString(), jTable1.getValueAt(38, 2).toString(), jTable1.getValueAt(38, 3).toString(), jTable1.getValueAt(38, 4).toString() }); i++; } else break; if (jTable1.getRowCount() != i) { data.put("41", new Object[] { jTable1.getValueAt(39, 0).toString(), jTable1.getValueAt(39, 1).toString(), jTable1.getValueAt(39, 2).toString(), jTable1.getValueAt(39, 3).toString(), jTable1.getValueAt(39, 4).toString() }); i++; } else break; if (jTable1.getRowCount() != i) { data.put("42", new Object[] { jTable1.getValueAt(40, 0).toString(), jTable1.getValueAt(40, 1).toString(), jTable1.getValueAt(40, 2).toString(), jTable1.getValueAt(40, 3).toString(), jTable1.getValueAt(40, 4).toString() }); i++; } else break; if (jTable1.getRowCount() != i) { data.put("43", new Object[] { jTable1.getValueAt(41, 0).toString(), jTable1.getValueAt(41, 1).toString(), jTable1.getValueAt(41, 2).toString(), jTable1.getValueAt(41, 3).toString(), jTable1.getValueAt(41, 4).toString() }); i++; } else break; if (jTable1.getRowCount() != i) { data.put("44", new Object[] { jTable1.getValueAt(42, 0).toString(), jTable1.getValueAt(42, 1).toString(), jTable1.getValueAt(42, 2).toString(), jTable1.getValueAt(42, 3).toString(), jTable1.getValueAt(42, 4).toString() }); i++; } else break; if (jTable1.getRowCount() != i) { data.put("45", new Object[] { jTable1.getValueAt(43, 0).toString(), jTable1.getValueAt(43, 1).toString(), jTable1.getValueAt(43, 2).toString(), jTable1.getValueAt(43, 3).toString(), jTable1.getValueAt(43, 4).toString() }); i++; } else break; if (jTable1.getRowCount() != i) { data.put("46", new Object[] { jTable1.getValueAt(44, 0).toString(), jTable1.getValueAt(44, 1).toString(), jTable1.getValueAt(44, 2).toString(), jTable1.getValueAt(44, 3).toString(), jTable1.getValueAt(44, 4).toString() }); i++; } else break; if (jTable1.getRowCount() != i) { data.put("47", new Object[] { jTable1.getValueAt(45, 0).toString(), jTable1.getValueAt(45, 1).toString(), jTable1.getValueAt(45, 2).toString(), jTable1.getValueAt(45, 3).toString(), jTable1.getValueAt(45, 4).toString() }); i++; } else break; if (jTable1.getRowCount() != i) { data.put("48", new Object[] { jTable1.getValueAt(46, 0).toString(), jTable1.getValueAt(46, 1).toString(), jTable1.getValueAt(46, 2).toString(), jTable1.getValueAt(46, 3).toString(), jTable1.getValueAt(46, 4).toString() }); i++; } else break; if (jTable1.getRowCount() != i) { data.put("49", new Object[] { jTable1.getValueAt(47, 0).toString(), jTable1.getValueAt(47, 1).toString(), jTable1.getValueAt(47, 2).toString(), jTable1.getValueAt(47, 3).toString(), jTable1.getValueAt(47, 4).toString() }); i++; } else break; if (jTable1.getRowCount() != i) { data.put("50", new Object[] { jTable1.getValueAt(48, 0).toString(), jTable1.getValueAt(48, 1).toString(), jTable1.getValueAt(48, 2).toString(), jTable1.getValueAt(48, 3).toString(), jTable1.getValueAt(48, 4).toString() }); i++; } else break; if (jTable1.getRowCount() != i) { data.put("51", new Object[] { jTable1.getValueAt(49, 0).toString(), jTable1.getValueAt(49, 1).toString(), jTable1.getValueAt(49, 2).toString(), jTable1.getValueAt(49, 3).toString(), jTable1.getValueAt(49, 4).toString() }); i++; } else break; if (jTable1.getRowCount() != i) { data.put("52", new Object[] { jTable1.getValueAt(50, 0).toString(), jTable1.getValueAt(50, 1).toString(), jTable1.getValueAt(50, 2).toString(), jTable1.getValueAt(50, 3).toString(), jTable1.getValueAt(50, 4).toString() }); i++; } else break; if (jTable1.getRowCount() != i) { data.put("53", new Object[] { jTable1.getValueAt(51, 0).toString(), jTable1.getValueAt(51, 1).toString(), jTable1.getValueAt(51, 2).toString(), jTable1.getValueAt(51, 3).toString(), jTable1.getValueAt(51, 4).toString() }); i++; } else break; if (jTable1.getRowCount() != i) { data.put("54", new Object[] { jTable1.getValueAt(52, 0).toString(), jTable1.getValueAt(52, 1).toString(), jTable1.getValueAt(52, 2).toString(), jTable1.getValueAt(52, 3).toString(), jTable1.getValueAt(52, 4).toString() }); i++; } else break; if (jTable1.getRowCount() != i) { data.put("55", new Object[] { jTable1.getValueAt(53, 0).toString(), jTable1.getValueAt(53, 1).toString(), jTable1.getValueAt(53, 2).toString(), jTable1.getValueAt(53, 3).toString(), jTable1.getValueAt(53, 4).toString() }); i++; } else break; if (jTable1.getRowCount() != i) { data.put("56", new Object[] { jTable1.getValueAt(54, 0).toString(), jTable1.getValueAt(54, 1).toString(), jTable1.getValueAt(54, 2).toString(), jTable1.getValueAt(54, 3).toString(), jTable1.getValueAt(54, 4).toString() }); i++; } else break; if (jTable1.getRowCount() != i) { data.put("57", new Object[] { jTable1.getValueAt(55, 0).toString(), jTable1.getValueAt(55, 1).toString(), jTable1.getValueAt(55, 2).toString(), jTable1.getValueAt(55, 3).toString(), jTable1.getValueAt(55, 4).toString() }); i++; } else break; if (jTable1.getRowCount() != i) { data.put("58", new Object[] { jTable1.getValueAt(56, 0).toString(), jTable1.getValueAt(56, 1).toString(), jTable1.getValueAt(56, 2).toString(), jTable1.getValueAt(56, 3).toString(), jTable1.getValueAt(56, 4).toString() }); i++; } else break; if (jTable1.getRowCount() != i) { data.put("59", new Object[] { jTable1.getValueAt(57, 0).toString(), jTable1.getValueAt(57, 1).toString(), jTable1.getValueAt(57, 2).toString(), jTable1.getValueAt(57, 3).toString(), jTable1.getValueAt(57, 4).toString() }); i++; } else break; if (jTable1.getRowCount() != i) { data.put("60", new Object[] { jTable1.getValueAt(58, 0).toString(), jTable1.getValueAt(58, 1).toString(), jTable1.getValueAt(58, 2).toString(), jTable1.getValueAt(58, 3).toString(), jTable1.getValueAt(58, 4).toString() }); i++; } else break; if (jTable1.getRowCount() != i) { data.put("61", new Object[] { jTable1.getValueAt(59, 0).toString(), jTable1.getValueAt(59, 1).toString(), jTable1.getValueAt(59, 2).toString(), jTable1.getValueAt(59, 3).toString(), jTable1.getValueAt(59, 4).toString() }); i++; } else break; if (jTable1.getRowCount() != i) { data.put("62", new Object[] { jTable1.getValueAt(60, 0).toString(), jTable1.getValueAt(60, 1).toString(), jTable1.getValueAt(60, 2).toString(), jTable1.getValueAt(60, 3).toString(), jTable1.getValueAt(60, 4).toString() }); i++; } else break; if (jTable1.getRowCount() != i) { data.put("63", new Object[] { jTable1.getValueAt(61, 0).toString(), jTable1.getValueAt(61, 1).toString(), jTable1.getValueAt(61, 2).toString(), jTable1.getValueAt(61, 3).toString(), jTable1.getValueAt(61, 4).toString() }); i++; } else break; if (jTable1.getRowCount() != i) { data.put("64", new Object[] { jTable1.getValueAt(62, 0).toString(), jTable1.getValueAt(62, 1).toString(), jTable1.getValueAt(62, 2).toString(), jTable1.getValueAt(62, 3).toString(), jTable1.getValueAt(62, 4).toString() }); i++; } else break; if (jTable1.getRowCount() != i) { data.put("65", new Object[] { jTable1.getValueAt(63, 0).toString(), jTable1.getValueAt(63, 1).toString(), jTable1.getValueAt(63, 2).toString(), jTable1.getValueAt(63, 3).toString(), jTable1.getValueAt(63, 4).toString() }); i++; } else break; if (jTable1.getRowCount() != i) { data.put("66", new Object[] { jTable1.getValueAt(64, 0).toString(), jTable1.getValueAt(64, 1).toString(), jTable1.getValueAt(64, 2).toString(), jTable1.getValueAt(64, 3).toString(), jTable1.getValueAt(64, 4).toString() }); i++; } else break; if (jTable1.getRowCount() != i) { data.put("67", new Object[] { jTable1.getValueAt(65, 0).toString(), jTable1.getValueAt(65, 1).toString(), jTable1.getValueAt(65, 2).toString(), jTable1.getValueAt(65, 3).toString(), jTable1.getValueAt(65, 4).toString() }); i++; } else break; if (jTable1.getRowCount() != i) { data.put("68", new Object[] { jTable1.getValueAt(66, 0).toString(), jTable1.getValueAt(66, 1).toString(), jTable1.getValueAt(66, 2).toString(), jTable1.getValueAt(66, 3).toString(), jTable1.getValueAt(66, 4).toString() }); i++; } else break; if (jTable1.getRowCount() != i) { data.put("69", new Object[] { jTable1.getValueAt(67, 0).toString(), jTable1.getValueAt(67, 1).toString(), jTable1.getValueAt(67, 2).toString(), jTable1.getValueAt(67, 3).toString(), jTable1.getValueAt(67, 4).toString() }); i++; } else break; if (jTable1.getRowCount() != i) { data.put("70", new Object[] { jTable1.getValueAt(68, 0).toString(), jTable1.getValueAt(68, 1).toString(), jTable1.getValueAt(68, 2).toString(), jTable1.getValueAt(68, 3).toString(), jTable1.getValueAt(68, 4).toString() }); i++; } else break; if (jTable1.getRowCount() != i) { data.put("71", new Object[] { jTable1.getValueAt(69, 0).toString(), jTable1.getValueAt(69, 1).toString(), jTable1.getValueAt(69, 2).toString(), jTable1.getValueAt(69, 3).toString(), jTable1.getValueAt(69, 4).toString() }); i++; } else break; if (jTable1.getRowCount() != i) { data.put("72", new Object[] { jTable1.getValueAt(70, 0).toString(), jTable1.getValueAt(70, 1).toString(), jTable1.getValueAt(70, 2).toString(), jTable1.getValueAt(70, 3).toString(), jTable1.getValueAt(70, 4).toString() }); i++; } else break; if (jTable1.getRowCount() != i) { data.put("73", new Object[] { jTable1.getValueAt(71, 0).toString(), jTable1.getValueAt(71, 1).toString(), jTable1.getValueAt(71, 2).toString(), jTable1.getValueAt(71, 3).toString(), jTable1.getValueAt(71, 4).toString() }); i++; } else break; if (jTable1.getRowCount() != i) { data.put("74", new Object[] { jTable1.getValueAt(72, 0).toString(), jTable1.getValueAt(72, 1).toString(), jTable1.getValueAt(72, 2).toString(), jTable1.getValueAt(72, 3).toString(), jTable1.getValueAt(72, 4).toString() }); i++; } else break; if (jTable1.getRowCount() != i) { data.put("75", new Object[] { jTable1.getValueAt(73, 0).toString(), jTable1.getValueAt(73, 1).toString(), jTable1.getValueAt(73, 2).toString(), jTable1.getValueAt(73, 3).toString(), jTable1.getValueAt(73, 4).toString() }); i++; } else break; if (jTable1.getRowCount() != i) { data.put("76", new Object[] { jTable1.getValueAt(74, 0).toString(), jTable1.getValueAt(74, 1).toString(), jTable1.getValueAt(74, 2).toString(), jTable1.getValueAt(74, 3).toString(), jTable1.getValueAt(74, 4).toString() }); i++; } else break; if (jTable1.getRowCount() != i) { data.put("77", new Object[] { jTable1.getValueAt(75, 0).toString(), jTable1.getValueAt(75, 1).toString(), jTable1.getValueAt(75, 2).toString(), jTable1.getValueAt(75, 3).toString(), jTable1.getValueAt(75, 4).toString() }); i++; } else break; if (jTable1.getRowCount() != i) { data.put("78", new Object[] { jTable1.getValueAt(76, 0).toString(), jTable1.getValueAt(76, 1).toString(), jTable1.getValueAt(76, 2).toString(), jTable1.getValueAt(76, 3).toString(), jTable1.getValueAt(76, 4).toString() }); i++; } else break; if (jTable1.getRowCount() != i) { data.put("79", new Object[] { jTable1.getValueAt(77, 0).toString(), jTable1.getValueAt(77, 1).toString(), jTable1.getValueAt(77, 2).toString(), jTable1.getValueAt(77, 3).toString(), jTable1.getValueAt(77, 4).toString() }); i++; } else break; if (jTable1.getRowCount() != i) { data.put("80", new Object[] { jTable1.getValueAt(78, 0).toString(), jTable1.getValueAt(78, 1).toString(), jTable1.getValueAt(78, 2).toString(), jTable1.getValueAt(78, 3).toString(), jTable1.getValueAt(78, 4).toString() }); i++; } else break; if (jTable1.getRowCount() != i) { data.put("81", new Object[] { jTable1.getValueAt(79, 0).toString(), jTable1.getValueAt(79, 1).toString(), jTable1.getValueAt(79, 2).toString(), jTable1.getValueAt(79, 3).toString(), jTable1.getValueAt(79, 4).toString() }); i++; } else break; if (jTable1.getRowCount() != i) { data.put("82", new Object[] { jTable1.getValueAt(80, 0).toString(), jTable1.getValueAt(80, 1).toString(), jTable1.getValueAt(80, 2).toString(), jTable1.getValueAt(80, 3).toString(), jTable1.getValueAt(80, 4).toString() }); i++; } else break; if (jTable1.getRowCount() != i) { data.put("83", new Object[] { jTable1.getValueAt(81, 0).toString(), jTable1.getValueAt(81, 1).toString(), jTable1.getValueAt(81, 2).toString(), jTable1.getValueAt(81, 3).toString(), jTable1.getValueAt(81, 4).toString() }); i++; } else break; if (jTable1.getRowCount() != i) { data.put("84", new Object[] { jTable1.getValueAt(82, 0).toString(), jTable1.getValueAt(82, 1).toString(), jTable1.getValueAt(82, 2).toString(), jTable1.getValueAt(82, 3).toString(), jTable1.getValueAt(82, 4).toString() }); i++; } else break; if (jTable1.getRowCount() != i) { data.put("85", new Object[] { jTable1.getValueAt(83, 0).toString(), jTable1.getValueAt(83, 1).toString(), jTable1.getValueAt(83, 2).toString(), jTable1.getValueAt(83, 3).toString(), jTable1.getValueAt(83, 4).toString() }); i++; } else break; if (jTable1.getRowCount() != i) { data.put("86", new Object[] { jTable1.getValueAt(84, 0).toString(), jTable1.getValueAt(84, 1).toString(), jTable1.getValueAt(84, 2).toString(), jTable1.getValueAt(84, 3).toString(), jTable1.getValueAt(84, 4).toString() }); i++; } else break; if (jTable1.getRowCount() != i) { data.put("87", new Object[] { jTable1.getValueAt(85, 0).toString(), jTable1.getValueAt(85, 1).toString(), jTable1.getValueAt(85, 2).toString(), jTable1.getValueAt(85, 3).toString(), jTable1.getValueAt(85, 4).toString() }); i++; } else break; if (jTable1.getRowCount() != i) { data.put("88", new Object[] { jTable1.getValueAt(86, 0).toString(), jTable1.getValueAt(86, 1).toString(), jTable1.getValueAt(86, 2).toString(), jTable1.getValueAt(86, 3).toString(), jTable1.getValueAt(86, 4).toString() }); i++; } else break; if (jTable1.getRowCount() != i) { data.put("89", new Object[] { jTable1.getValueAt(87, 0).toString(), jTable1.getValueAt(87, 1).toString(), jTable1.getValueAt(87, 2).toString(), jTable1.getValueAt(87, 3).toString(), jTable1.getValueAt(87, 4).toString() }); i++; } else break; if (jTable1.getRowCount() != i) { data.put("90", new Object[] { jTable1.getValueAt(88, 0).toString(), jTable1.getValueAt(88, 1).toString(), jTable1.getValueAt(88, 2).toString(), jTable1.getValueAt(88, 3).toString(), jTable1.getValueAt(88, 4).toString() }); i++; } else break; if (jTable1.getRowCount() != i) { data.put("91", new Object[] { jTable1.getValueAt(89, 0).toString(), jTable1.getValueAt(89, 1).toString(), jTable1.getValueAt(89, 2).toString(), jTable1.getValueAt(89, 3).toString(), jTable1.getValueAt(89, 4).toString() }); i++; } else break; if (jTable1.getRowCount() != i) { data.put("92", new Object[] { jTable1.getValueAt(90, 0).toString(), jTable1.getValueAt(90, 1).toString(), jTable1.getValueAt(90, 2).toString(), jTable1.getValueAt(90, 3).toString(), jTable1.getValueAt(90, 4).toString() }); i++; } else break; if (jTable1.getRowCount() != i) { data.put("93", new Object[] { jTable1.getValueAt(91, 0).toString(), jTable1.getValueAt(91, 1).toString(), jTable1.getValueAt(91, 2).toString(), jTable1.getValueAt(91, 3).toString(), jTable1.getValueAt(91, 4).toString() }); i++; } else break; if (jTable1.getRowCount() != i) { data.put("94", new Object[] { jTable1.getValueAt(92, 0).toString(), jTable1.getValueAt(92, 1).toString(), jTable1.getValueAt(92, 2).toString(), jTable1.getValueAt(92, 3).toString(), jTable1.getValueAt(92, 4).toString() }); i++; } else break; if (jTable1.getRowCount() != i) { data.put("95", new Object[] { jTable1.getValueAt(93, 0).toString(), jTable1.getValueAt(93, 1).toString(), jTable1.getValueAt(93, 2).toString(), jTable1.getValueAt(93, 3).toString(), jTable1.getValueAt(93, 4).toString() }); i++; } else break; if (jTable1.getRowCount() != i) { data.put("96", new Object[] { jTable1.getValueAt(94, 0).toString(), jTable1.getValueAt(94, 1).toString(), jTable1.getValueAt(94, 2).toString(), jTable1.getValueAt(94, 3).toString(), jTable1.getValueAt(94, 4).toString() }); i++; } else break; if (jTable1.getRowCount() != i) { data.put("97", new Object[] { jTable1.getValueAt(95, 0).toString(), jTable1.getValueAt(95, 1).toString(), jTable1.getValueAt(95, 2).toString(), jTable1.getValueAt(95, 3).toString(), jTable1.getValueAt(95, 4).toString() }); i++; } else break; if (jTable1.getRowCount() != i) { data.put("98", new Object[] { jTable1.getValueAt(96, 0).toString(), jTable1.getValueAt(96, 1).toString(), jTable1.getValueAt(96, 2).toString(), jTable1.getValueAt(96, 3).toString(), jTable1.getValueAt(96, 4).toString() }); i++; } else break; if (jTable1.getRowCount() != i) { data.put("99", new Object[] { jTable1.getValueAt(97, 0).toString(), jTable1.getValueAt(97, 1).toString(), jTable1.getValueAt(97, 2).toString(), jTable1.getValueAt(97, 3).toString(), jTable1.getValueAt(97, 4).toString() }); i++; } else break; if (jTable1.getRowCount() != i) { data.put("100", new Object[] { jTable1.getValueAt(98, 0).toString(), jTable1.getValueAt(98, 1).toString(), jTable1.getValueAt(98, 2).toString(), jTable1.getValueAt(98, 3).toString(), jTable1.getValueAt(98, 4).toString() }); i++; } else break; if (jTable1.getRowCount() != i) { data.put("101", new Object[] { jTable1.getValueAt(99, 0).toString(), jTable1.getValueAt(99, 1).toString(), jTable1.getValueAt(99, 2).toString(), jTable1.getValueAt(99, 3).toString(), jTable1.getValueAt(99, 4).toString() }); i++; } else break; if (jTable1.getRowCount() != i) { data.put("102", new Object[] { jTable1.getValueAt(100, 0).toString(), jTable1.getValueAt(100, 1).toString(), jTable1.getValueAt(100, 2).toString(), jTable1.getValueAt(100, 3).toString(), jTable1.getValueAt(100, 4).toString() }); i++; } else break; if (jTable1.getRowCount() != i) { data.put("103", new Object[] { jTable1.getValueAt(101, 0).toString(), jTable1.getValueAt(101, 1).toString(), jTable1.getValueAt(101, 2).toString(), jTable1.getValueAt(101, 3).toString(), jTable1.getValueAt(101, 4).toString() }); i++; } else break; if (jTable1.getRowCount() != i) { data.put("104", new Object[] { jTable1.getValueAt(102, 0).toString(), jTable1.getValueAt(102, 1).toString(), jTable1.getValueAt(102, 2).toString(), jTable1.getValueAt(102, 3).toString(), jTable1.getValueAt(102, 4).toString() }); i++; } else break; if (jTable1.getRowCount() != i) { data.put("105", new Object[] { jTable1.getValueAt(103, 0).toString(), jTable1.getValueAt(103, 1).toString(), jTable1.getValueAt(103, 2).toString(), jTable1.getValueAt(103, 3).toString(), jTable1.getValueAt(103, 4).toString() }); i++; } else break; if (jTable1.getRowCount() != i) { data.put("106", new Object[] { jTable1.getValueAt(104, 0).toString(), jTable1.getValueAt(104, 1).toString(), jTable1.getValueAt(104, 2).toString(), jTable1.getValueAt(104, 3).toString(), jTable1.getValueAt(104, 4).toString() }); i++; } else break; if (jTable1.getRowCount() != i) { data.put("107", new Object[] { jTable1.getValueAt(105, 0).toString(), jTable1.getValueAt(105, 1).toString(), jTable1.getValueAt(105, 2).toString(), jTable1.getValueAt(105, 3).toString(), jTable1.getValueAt(105, 4).toString() }); i++; } else break; if (jTable1.getRowCount() != i) { data.put("108", new Object[] { jTable1.getValueAt(106, 0).toString(), jTable1.getValueAt(106, 1).toString(), jTable1.getValueAt(106, 2).toString(), jTable1.getValueAt(106, 3).toString(), jTable1.getValueAt(106, 4).toString() }); i++; } else break; if (jTable1.getRowCount() != i) { data.put("109", new Object[] { jTable1.getValueAt(107, 0).toString(), jTable1.getValueAt(107, 1).toString(), jTable1.getValueAt(107, 2).toString(), jTable1.getValueAt(107, 3).toString(), jTable1.getValueAt(107, 4).toString() }); i++; } else break; if (jTable1.getRowCount() != i) { data.put("110", new Object[] { jTable1.getValueAt(108, 0).toString(), jTable1.getValueAt(108, 1).toString(), jTable1.getValueAt(108, 2).toString(), jTable1.getValueAt(108, 3).toString(), jTable1.getValueAt(108, 4).toString() }); i++; } else break; if (jTable1.getRowCount() != i) { data.put("111", new Object[] { jTable1.getValueAt(109, 0).toString(), jTable1.getValueAt(109, 1).toString(), jTable1.getValueAt(109, 2).toString(), jTable1.getValueAt(109, 3).toString(), jTable1.getValueAt(109, 4).toString() }); i++; } else break; if (jTable1.getRowCount() != i) { data.put("112", new Object[] { jTable1.getValueAt(110, 0).toString(), jTable1.getValueAt(110, 1).toString(), jTable1.getValueAt(110, 2).toString(), jTable1.getValueAt(110, 3).toString(), jTable1.getValueAt(110, 4).toString() }); i++; } else break; if (jTable1.getRowCount() != i) { data.put("113", new Object[] { jTable1.getValueAt(111, 0).toString(), jTable1.getValueAt(111, 1).toString(), jTable1.getValueAt(111, 2).toString(), jTable1.getValueAt(111, 3).toString(), jTable1.getValueAt(111, 4).toString() }); i++; } else break; if (jTable1.getRowCount() != i) { data.put("114", new Object[] { jTable1.getValueAt(112, 0).toString(), jTable1.getValueAt(112, 1).toString(), jTable1.getValueAt(112, 2).toString(), jTable1.getValueAt(112, 3).toString(), jTable1.getValueAt(112, 4).toString() }); i++; } else break; if (jTable1.getRowCount() != i) { data.put("115", new Object[] { jTable1.getValueAt(113, 0).toString(), jTable1.getValueAt(113, 1).toString(), jTable1.getValueAt(113, 2).toString(), jTable1.getValueAt(113, 3).toString(), jTable1.getValueAt(113, 4).toString() }); i++; } else break; if (jTable1.getRowCount() != i) { data.put("116", new Object[] { jTable1.getValueAt(114, 0).toString(), jTable1.getValueAt(114, 1).toString(), jTable1.getValueAt(114, 2).toString(), jTable1.getValueAt(114, 3).toString(), jTable1.getValueAt(114, 4).toString() }); i++; } else break; if (jTable1.getRowCount() != i) { data.put("117", new Object[] { jTable1.getValueAt(115, 0).toString(), jTable1.getValueAt(115, 1).toString(), jTable1.getValueAt(115, 2).toString(), jTable1.getValueAt(115, 3).toString(), jTable1.getValueAt(115, 4).toString() }); i++; } else break; if (jTable1.getRowCount() != i) { data.put("118", new Object[] { jTable1.getValueAt(116, 0).toString(), jTable1.getValueAt(116, 1).toString(), jTable1.getValueAt(116, 2).toString(), jTable1.getValueAt(116, 3).toString(), jTable1.getValueAt(116, 4).toString() }); i++; } else break; if (jTable1.getRowCount() != i) { data.put("119", new Object[] { jTable1.getValueAt(117, 0).toString(), jTable1.getValueAt(117, 1).toString(), jTable1.getValueAt(117, 2).toString(), jTable1.getValueAt(117, 3).toString(), jTable1.getValueAt(117, 4).toString() }); i++; } else break; if (jTable1.getRowCount() != i) { data.put("120", new Object[] { jTable1.getValueAt(118, 0).toString(), jTable1.getValueAt(118, 1).toString(), jTable1.getValueAt(118, 2).toString(), jTable1.getValueAt(118, 3).toString(), jTable1.getValueAt(118, 4).toString() }); i++; } else break; if (jTable1.getRowCount() != i) { data.put("121", new Object[] { jTable1.getValueAt(119, 0).toString(), jTable1.getValueAt(119, 1).toString(), jTable1.getValueAt(119, 2).toString(), jTable1.getValueAt(119, 3).toString(), jTable1.getValueAt(119, 4).toString() }); i++; } else break; if (jTable1.getRowCount() != i) { data.put("122", new Object[] { jTable1.getValueAt(120, 0).toString(), jTable1.getValueAt(120, 1).toString(), jTable1.getValueAt(120, 2).toString(), jTable1.getValueAt(120, 3).toString(), jTable1.getValueAt(120, 4).toString() }); i++; } else break; if (jTable1.getRowCount() != i) { data.put("123", new Object[] { jTable1.getValueAt(121, 0).toString(), jTable1.getValueAt(121, 1).toString(), jTable1.getValueAt(121, 2).toString(), jTable1.getValueAt(121, 3).toString(), jTable1.getValueAt(121, 4).toString() }); i++; } else break; if (jTable1.getRowCount() != i) { data.put("124", new Object[] { jTable1.getValueAt(122, 0).toString(), jTable1.getValueAt(122, 1).toString(), jTable1.getValueAt(122, 2).toString(), jTable1.getValueAt(122, 3).toString(), jTable1.getValueAt(122, 4).toString() }); i++; } else break; if (jTable1.getRowCount() != i) { data.put("125", new Object[] { jTable1.getValueAt(123, 0).toString(), jTable1.getValueAt(123, 1).toString(), jTable1.getValueAt(123, 2).toString(), jTable1.getValueAt(123, 3).toString(), jTable1.getValueAt(123, 4).toString() }); i++; } else break; if (jTable1.getRowCount() != i) { data.put("126", new Object[] { jTable1.getValueAt(124, 0).toString(), jTable1.getValueAt(124, 1).toString(), jTable1.getValueAt(124, 2).toString(), jTable1.getValueAt(124, 3).toString(), jTable1.getValueAt(124, 4).toString() }); i++; } else break; if (jTable1.getRowCount() != i) { data.put("127", new Object[] { jTable1.getValueAt(125, 0).toString(), jTable1.getValueAt(125, 1).toString(), jTable1.getValueAt(125, 2).toString(), jTable1.getValueAt(125, 3).toString(), jTable1.getValueAt(125, 4).toString() }); i++; } else break; if (jTable1.getRowCount() != i) { data.put("128", new Object[] { jTable1.getValueAt(126, 0).toString(), jTable1.getValueAt(126, 1).toString(), jTable1.getValueAt(126, 2).toString(), jTable1.getValueAt(126, 3).toString(), jTable1.getValueAt(126, 4).toString() }); i++; } else break; if (jTable1.getRowCount() != i) { data.put("129", new Object[] { jTable1.getValueAt(127, 0).toString(), jTable1.getValueAt(127, 1).toString(), jTable1.getValueAt(127, 2).toString(), jTable1.getValueAt(127, 3).toString(), jTable1.getValueAt(127, 4).toString() }); i++; } else break; if (jTable1.getRowCount() != i) { data.put("130", new Object[] { jTable1.getValueAt(128, 0).toString(), jTable1.getValueAt(128, 1).toString(), jTable1.getValueAt(128, 2).toString(), jTable1.getValueAt(128, 3).toString(), jTable1.getValueAt(128, 4).toString() }); i++; } else break; if (jTable1.getRowCount() != i) { data.put("131", new Object[] { jTable1.getValueAt(129, 0).toString(), jTable1.getValueAt(129, 1).toString(), jTable1.getValueAt(129, 2).toString(), jTable1.getValueAt(129, 3).toString(), jTable1.getValueAt(129, 4).toString() }); i++; } else break; if (jTable1.getRowCount() != i) { data.put("132", new Object[] { jTable1.getValueAt(130, 0).toString(), jTable1.getValueAt(130, 1).toString(), jTable1.getValueAt(130, 2).toString(), jTable1.getValueAt(130, 3).toString(), jTable1.getValueAt(130, 4).toString() }); i++; } else break; if (jTable1.getRowCount() != i) { data.put("133", new Object[] { jTable1.getValueAt(131, 0).toString(), jTable1.getValueAt(131, 1).toString(), jTable1.getValueAt(131, 2).toString(), jTable1.getValueAt(131, 3).toString(), jTable1.getValueAt(131, 4).toString() }); i++; } else break; if (jTable1.getRowCount() != i) { data.put("134", new Object[] { jTable1.getValueAt(132, 0).toString(), jTable1.getValueAt(132, 1).toString(), jTable1.getValueAt(132, 2).toString(), jTable1.getValueAt(132, 3).toString(), jTable1.getValueAt(132, 4).toString() }); i++; } else break; if (jTable1.getRowCount() != i) { data.put("135", new Object[] { jTable1.getValueAt(133, 0).toString(), jTable1.getValueAt(133, 1).toString(), jTable1.getValueAt(133, 2).toString(), jTable1.getValueAt(133, 3).toString(), jTable1.getValueAt(133, 4).toString() }); i++; } else break; if (jTable1.getRowCount() != i) { data.put("136", new Object[] { jTable1.getValueAt(134, 0).toString(), jTable1.getValueAt(134, 1).toString(), jTable1.getValueAt(134, 2).toString(), jTable1.getValueAt(134, 3).toString(), jTable1.getValueAt(134, 4).toString() }); i++; } else break; if (jTable1.getRowCount() != i) { data.put("137", new Object[] { jTable1.getValueAt(135, 0).toString(), jTable1.getValueAt(135, 1).toString(), jTable1.getValueAt(135, 2).toString(), jTable1.getValueAt(135, 3).toString(), jTable1.getValueAt(135, 4).toString() }); i++; } else break; if (jTable1.getRowCount() != i) { data.put("138", new Object[] { jTable1.getValueAt(136, 0).toString(), jTable1.getValueAt(136, 1).toString(), jTable1.getValueAt(136, 2).toString(), jTable1.getValueAt(136, 3).toString(), jTable1.getValueAt(136, 4).toString() }); i++; } else break; if (jTable1.getRowCount() != i) { data.put("139", new Object[] { jTable1.getValueAt(137, 0).toString(), jTable1.getValueAt(137, 1).toString(), jTable1.getValueAt(137, 2).toString(), jTable1.getValueAt(137, 3).toString(), jTable1.getValueAt(137, 4).toString() }); i++; } else break; if (jTable1.getRowCount() != i) { data.put("140", new Object[] { jTable1.getValueAt(138, 0).toString(), jTable1.getValueAt(138, 1).toString(), jTable1.getValueAt(138, 2).toString(), jTable1.getValueAt(138, 3).toString(), jTable1.getValueAt(138, 4).toString() }); i++; } else break; if (jTable1.getRowCount() != i) { data.put("141", new Object[] { jTable1.getValueAt(139, 0).toString(), jTable1.getValueAt(139, 1).toString(), jTable1.getValueAt(139, 2).toString(), jTable1.getValueAt(139, 3).toString(), jTable1.getValueAt(139, 4).toString() }); i++; } else break; if (jTable1.getRowCount() != i) { data.put("142", new Object[] { jTable1.getValueAt(140, 0).toString(), jTable1.getValueAt(140, 1).toString(), jTable1.getValueAt(140, 2).toString(), jTable1.getValueAt(140, 3).toString(), jTable1.getValueAt(140, 4).toString() }); i++; } else break; if (jTable1.getRowCount() != i) { data.put("143", new Object[] { jTable1.getValueAt(141, 0).toString(), jTable1.getValueAt(141, 1).toString(), jTable1.getValueAt(141, 2).toString(), jTable1.getValueAt(141, 3).toString(), jTable1.getValueAt(141, 4).toString() }); i++; } else break; if (jTable1.getRowCount() != i) { data.put("144", new Object[] { jTable1.getValueAt(142, 0).toString(), jTable1.getValueAt(142, 1).toString(), jTable1.getValueAt(142, 2).toString(), jTable1.getValueAt(142, 3).toString(), jTable1.getValueAt(142, 4).toString() }); i++; } else break; if (jTable1.getRowCount() != i) { data.put("145", new Object[] { jTable1.getValueAt(143, 0).toString(), jTable1.getValueAt(143, 1).toString(), jTable1.getValueAt(143, 2).toString(), jTable1.getValueAt(143, 3).toString(), jTable1.getValueAt(143, 4).toString() }); i++; } else break; if (jTable1.getRowCount() != i) { data.put("146", new Object[] { jTable1.getValueAt(144, 0).toString(), jTable1.getValueAt(144, 1).toString(), jTable1.getValueAt(144, 2).toString(), jTable1.getValueAt(144, 3).toString(), jTable1.getValueAt(144, 4).toString() }); i++; } else break; if (jTable1.getRowCount() != i) { data.put("147", new Object[] { jTable1.getValueAt(145, 0).toString(), jTable1.getValueAt(145, 1).toString(), jTable1.getValueAt(145, 2).toString(), jTable1.getValueAt(145, 3).toString(), jTable1.getValueAt(145, 4).toString() }); i++; } else break; if (jTable1.getRowCount() != i) { data.put("148", new Object[] { jTable1.getValueAt(146, 0).toString(), jTable1.getValueAt(146, 1).toString(), jTable1.getValueAt(146, 2).toString(), jTable1.getValueAt(146, 3).toString(), jTable1.getValueAt(146, 4).toString() }); i++; } else break; if (jTable1.getRowCount() != i) { data.put("149", new Object[] { jTable1.getValueAt(147, 0).toString(), jTable1.getValueAt(147, 1).toString(), jTable1.getValueAt(147, 2).toString(), jTable1.getValueAt(147, 3).toString(), jTable1.getValueAt(147, 4).toString() }); i++; } else break; if (jTable1.getRowCount() != i) { data.put("150", new Object[] { jTable1.getValueAt(148, 0).toString(), jTable1.getValueAt(148, 1).toString(), jTable1.getValueAt(148, 2).toString(), jTable1.getValueAt(148, 3).toString(), jTable1.getValueAt(148, 4).toString() }); i++; } else break; if (jTable1.getRowCount() != i) { data.put("151", new Object[] { jTable1.getValueAt(149, 0).toString(), jTable1.getValueAt(149, 1).toString(), jTable1.getValueAt(149, 2).toString(), jTable1.getValueAt(149, 3).toString(), jTable1.getValueAt(149, 4).toString() }); i++; } else break; if (jTable1.getRowCount() != i) { data.put("152", new Object[] { jTable1.getValueAt(150, 0).toString(), jTable1.getValueAt(150, 1).toString(), jTable1.getValueAt(150, 2).toString(), jTable1.getValueAt(150, 3).toString(), jTable1.getValueAt(150, 4).toString() }); i++; } else break; if (jTable1.getRowCount() != i) { data.put("153", new Object[] { jTable1.getValueAt(151, 0).toString(), jTable1.getValueAt(151, 1).toString(), jTable1.getValueAt(151, 2).toString(), jTable1.getValueAt(151, 3).toString(), jTable1.getValueAt(151, 4).toString() }); i++; } else break; if (jTable1.getRowCount() != i) { data.put("154", new Object[] { jTable1.getValueAt(152, 0).toString(), jTable1.getValueAt(152, 1).toString(), jTable1.getValueAt(152, 2).toString(), jTable1.getValueAt(152, 3).toString(), jTable1.getValueAt(152, 4).toString() }); i++; } else break; if (jTable1.getRowCount() != i) { data.put("155", new Object[] { jTable1.getValueAt(153, 0).toString(), jTable1.getValueAt(153, 1).toString(), jTable1.getValueAt(153, 2).toString(), jTable1.getValueAt(153, 3).toString(), jTable1.getValueAt(153, 4).toString() }); i++; } else break; if (jTable1.getRowCount() != i) { data.put("156", new Object[] { jTable1.getValueAt(154, 0).toString(), jTable1.getValueAt(154, 1).toString(), jTable1.getValueAt(154, 2).toString(), jTable1.getValueAt(154, 3).toString(), jTable1.getValueAt(154, 4).toString() }); i++; } else break; if (jTable1.getRowCount() != i) { data.put("157", new Object[] { jTable1.getValueAt(155, 0).toString(), jTable1.getValueAt(155, 1).toString(), jTable1.getValueAt(155, 2).toString(), jTable1.getValueAt(155, 3).toString(), jTable1.getValueAt(155, 4).toString() }); i++; } else break; if (jTable1.getRowCount() != i) { data.put("158", new Object[] { jTable1.getValueAt(156, 0).toString(), jTable1.getValueAt(156, 1).toString(), jTable1.getValueAt(156, 2).toString(), jTable1.getValueAt(156, 3).toString(), jTable1.getValueAt(156, 4).toString() }); i++; } else break; if (jTable1.getRowCount() != i) { data.put("159", new Object[] { jTable1.getValueAt(157, 0).toString(), jTable1.getValueAt(157, 1).toString(), jTable1.getValueAt(157, 2).toString(), jTable1.getValueAt(157, 3).toString(), jTable1.getValueAt(157, 4).toString() }); i++; } else break; if (jTable1.getRowCount() != i) { data.put("160", new Object[] { jTable1.getValueAt(158, 0).toString(), jTable1.getValueAt(158, 1).toString(), jTable1.getValueAt(158, 2).toString(), jTable1.getValueAt(158, 3).toString(), jTable1.getValueAt(158, 4).toString() }); i++; } else break; if (jTable1.getRowCount() != i) { data.put("161", new Object[] { jTable1.getValueAt(159, 0).toString(), jTable1.getValueAt(159, 1).toString(), jTable1.getValueAt(159, 2).toString(), jTable1.getValueAt(159, 3).toString(), jTable1.getValueAt(159, 4).toString() }); i++; } else break; if (jTable1.getRowCount() != i) { data.put("162", new Object[] { jTable1.getValueAt(160, 0).toString(), jTable1.getValueAt(160, 1).toString(), jTable1.getValueAt(160, 2).toString(), jTable1.getValueAt(160, 3).toString(), jTable1.getValueAt(160, 4).toString() }); i++; } else break; if (jTable1.getRowCount() != i) { data.put("163", new Object[] { jTable1.getValueAt(161, 0).toString(), jTable1.getValueAt(161, 1).toString(), jTable1.getValueAt(161, 2).toString(), jTable1.getValueAt(161, 3).toString(), jTable1.getValueAt(161, 4).toString() }); i++; } else break; if (jTable1.getRowCount() != i) { data.put("164", new Object[] { jTable1.getValueAt(162, 0).toString(), jTable1.getValueAt(162, 1).toString(), jTable1.getValueAt(162, 2).toString(), jTable1.getValueAt(162, 3).toString(), jTable1.getValueAt(162, 4).toString() }); i++; } else break; if (jTable1.getRowCount() != i) { data.put("165", new Object[] { jTable1.getValueAt(163, 0).toString(), jTable1.getValueAt(163, 1).toString(), jTable1.getValueAt(163, 2).toString(), jTable1.getValueAt(163, 3).toString(), jTable1.getValueAt(163, 4).toString() }); i++; } else break; if (jTable1.getRowCount() != i) { data.put("166", new Object[] { jTable1.getValueAt(164, 0).toString(), jTable1.getValueAt(164, 1).toString(), jTable1.getValueAt(164, 2).toString(), jTable1.getValueAt(164, 3).toString(), jTable1.getValueAt(164, 4).toString() }); i++; } else break; if (jTable1.getRowCount() != i) { data.put("167", new Object[] { jTable1.getValueAt(165, 0).toString(), jTable1.getValueAt(165, 1).toString(), jTable1.getValueAt(165, 2).toString(), jTable1.getValueAt(165, 3).toString(), jTable1.getValueAt(165, 4).toString() }); i++; } else break; if (jTable1.getRowCount() != i) { data.put("168", new Object[] { jTable1.getValueAt(166, 0).toString(), jTable1.getValueAt(166, 1).toString(), jTable1.getValueAt(166, 2).toString(), jTable1.getValueAt(166, 3).toString(), jTable1.getValueAt(166, 4).toString() }); i++; } else break; if (jTable1.getRowCount() != i) { data.put("169", new Object[] { jTable1.getValueAt(167, 0).toString(), jTable1.getValueAt(167, 1).toString(), jTable1.getValueAt(167, 2).toString(), jTable1.getValueAt(167, 3).toString(), jTable1.getValueAt(167, 4).toString() }); i++; } else break; if (jTable1.getRowCount() != i) { data.put("170", new Object[] { jTable1.getValueAt(168, 0).toString(), jTable1.getValueAt(168, 1).toString(), jTable1.getValueAt(168, 2).toString(), jTable1.getValueAt(168, 3).toString(), jTable1.getValueAt(168, 4).toString() }); i++; } else break; if (jTable1.getRowCount() != i) { data.put("171", new Object[] { jTable1.getValueAt(169, 0).toString(), jTable1.getValueAt(169, 1).toString(), jTable1.getValueAt(169, 2).toString(), jTable1.getValueAt(169, 3).toString(), jTable1.getValueAt(169, 4).toString() }); i++; } else break; if (jTable1.getRowCount() != i) { data.put("172", new Object[] { jTable1.getValueAt(170, 0).toString(), jTable1.getValueAt(170, 1).toString(), jTable1.getValueAt(170, 2).toString(), jTable1.getValueAt(170, 3).toString(), jTable1.getValueAt(170, 4).toString() }); i++; } else break; if (jTable1.getRowCount() != i) { data.put("173", new Object[] { jTable1.getValueAt(171, 0).toString(), jTable1.getValueAt(171, 1).toString(), jTable1.getValueAt(171, 2).toString(), jTable1.getValueAt(171, 3).toString(), jTable1.getValueAt(171, 4).toString() }); i++; } else break; if (jTable1.getRowCount() != i) { data.put("174", new Object[] { jTable1.getValueAt(172, 0).toString(), jTable1.getValueAt(172, 1).toString(), jTable1.getValueAt(172, 2).toString(), jTable1.getValueAt(172, 3).toString(), jTable1.getValueAt(172, 4).toString() }); i++; } else break; if (jTable1.getRowCount() != i) { data.put("175", new Object[] { jTable1.getValueAt(173, 0).toString(), jTable1.getValueAt(173, 1).toString(), jTable1.getValueAt(173, 2).toString(), jTable1.getValueAt(173, 3).toString(), jTable1.getValueAt(173, 4).toString() }); i++; } else break; if (jTable1.getRowCount() != i) { data.put("176", new Object[] { jTable1.getValueAt(174, 0).toString(), jTable1.getValueAt(174, 1).toString(), jTable1.getValueAt(174, 2).toString(), jTable1.getValueAt(174, 3).toString(), jTable1.getValueAt(174, 4).toString() }); i++; } else break; if (jTable1.getRowCount() != i) { data.put("177", new Object[] { jTable1.getValueAt(175, 0).toString(), jTable1.getValueAt(175, 1).toString(), jTable1.getValueAt(175, 2).toString(), jTable1.getValueAt(175, 3).toString(), jTable1.getValueAt(175, 4).toString() }); i++; } else break; if (jTable1.getRowCount() != i) { data.put("178", new Object[] { jTable1.getValueAt(176, 0).toString(), jTable1.getValueAt(176, 1).toString(), jTable1.getValueAt(176, 2).toString(), jTable1.getValueAt(176, 3).toString(), jTable1.getValueAt(176, 4).toString() }); i++; } else break; if (jTable1.getRowCount() != i) { data.put("179", new Object[] { jTable1.getValueAt(177, 0).toString(), jTable1.getValueAt(177, 1).toString(), jTable1.getValueAt(177, 2).toString(), jTable1.getValueAt(177, 3).toString(), jTable1.getValueAt(177, 4).toString() }); i++; } else break; if (jTable1.getRowCount() != i) { data.put("180", new Object[] { jTable1.getValueAt(178, 0).toString(), jTable1.getValueAt(178, 1).toString(), jTable1.getValueAt(178, 2).toString(), jTable1.getValueAt(178, 3).toString(), jTable1.getValueAt(178, 4).toString() }); i++; } else break; if (jTable1.getRowCount() != i) { data.put("181", new Object[] { jTable1.getValueAt(179, 0).toString(), jTable1.getValueAt(179, 1).toString(), jTable1.getValueAt(179, 2).toString(), jTable1.getValueAt(179, 3).toString(), jTable1.getValueAt(179, 4).toString() }); i++; } else break; if (jTable1.getRowCount() != i) { data.put("182", new Object[] { jTable1.getValueAt(180, 0).toString(), jTable1.getValueAt(180, 1).toString(), jTable1.getValueAt(180, 2).toString(), jTable1.getValueAt(180, 3).toString(), jTable1.getValueAt(180, 4).toString() }); i++; } else break; if (jTable1.getRowCount() != i) { data.put("183", new Object[] { jTable1.getValueAt(181, 0).toString(), jTable1.getValueAt(181, 1).toString(), jTable1.getValueAt(181, 2).toString(), jTable1.getValueAt(181, 3).toString(), jTable1.getValueAt(181, 4).toString() }); i++; } else break; if (jTable1.getRowCount() != i) { data.put("184", new Object[] { jTable1.getValueAt(182, 0).toString(), jTable1.getValueAt(182, 1).toString(), jTable1.getValueAt(182, 2).toString(), jTable1.getValueAt(182, 3).toString(), jTable1.getValueAt(182, 4).toString() }); i++; } else break; if (jTable1.getRowCount() != i) { data.put("185", new Object[] { jTable1.getValueAt(183, 0).toString(), jTable1.getValueAt(183, 1).toString(), jTable1.getValueAt(183, 2).toString(), jTable1.getValueAt(183, 3).toString(), jTable1.getValueAt(183, 4).toString() }); i++; } else break; if (jTable1.getRowCount() != i) { data.put("186", new Object[] { jTable1.getValueAt(184, 0).toString(), jTable1.getValueAt(184, 1).toString(), jTable1.getValueAt(184, 2).toString(), jTable1.getValueAt(184, 3).toString(), jTable1.getValueAt(184, 4).toString() }); i++; } else break; if (jTable1.getRowCount() != i) { data.put("187", new Object[] { jTable1.getValueAt(185, 0).toString(), jTable1.getValueAt(185, 1).toString(), jTable1.getValueAt(185, 2).toString(), jTable1.getValueAt(185, 3).toString(), jTable1.getValueAt(185, 4).toString() }); i++; } else break; if (jTable1.getRowCount() != i) { data.put("188", new Object[] { jTable1.getValueAt(186, 0).toString(), jTable1.getValueAt(186, 1).toString(), jTable1.getValueAt(186, 2).toString(), jTable1.getValueAt(186, 3).toString(), jTable1.getValueAt(186, 4).toString() }); i++; } else break; if (jTable1.getRowCount() != i) { data.put("189", new Object[] { jTable1.getValueAt(187, 0).toString(), jTable1.getValueAt(187, 1).toString(), jTable1.getValueAt(187, 2).toString(), jTable1.getValueAt(187, 3).toString(), jTable1.getValueAt(187, 4).toString() }); i++; } else break; if (jTable1.getRowCount() != i) { data.put("190", new Object[] { jTable1.getValueAt(188, 0).toString(), jTable1.getValueAt(188, 1).toString(), jTable1.getValueAt(188, 2).toString(), jTable1.getValueAt(188, 3).toString(), jTable1.getValueAt(188, 4).toString() }); i++; } else break; if (jTable1.getRowCount() != i) { data.put("191", new Object[] { jTable1.getValueAt(189, 0).toString(), jTable1.getValueAt(189, 1).toString(), jTable1.getValueAt(189, 2).toString(), jTable1.getValueAt(189, 3).toString(), jTable1.getValueAt(189, 4).toString() }); i++; } else break; if (jTable1.getRowCount() != i) { data.put("192", new Object[] { jTable1.getValueAt(190, 0).toString(), jTable1.getValueAt(190, 1).toString(), jTable1.getValueAt(190, 2).toString(), jTable1.getValueAt(190, 3).toString(), jTable1.getValueAt(190, 4).toString() }); i++; } else break; if (jTable1.getRowCount() != i) { data.put("193", new Object[] { jTable1.getValueAt(191, 0).toString(), jTable1.getValueAt(191, 1).toString(), jTable1.getValueAt(191, 2).toString(), jTable1.getValueAt(191, 3).toString(), jTable1.getValueAt(191, 4).toString() }); i++; } else break; if (jTable1.getRowCount() != i) { data.put("194", new Object[] { jTable1.getValueAt(192, 0).toString(), jTable1.getValueAt(192, 1).toString(), jTable1.getValueAt(192, 2).toString(), jTable1.getValueAt(192, 3).toString(), jTable1.getValueAt(192, 4).toString() }); i++; } else break; if (jTable1.getRowCount() != i) { data.put("195", new Object[] { jTable1.getValueAt(193, 0).toString(), jTable1.getValueAt(193, 1).toString(), jTable1.getValueAt(193, 2).toString(), jTable1.getValueAt(193, 3).toString(), jTable1.getValueAt(193, 4).toString() }); i++; } else break; if (jTable1.getRowCount() != i) { data.put("196", new Object[] { jTable1.getValueAt(194, 0).toString(), jTable1.getValueAt(194, 1).toString(), jTable1.getValueAt(194, 2).toString(), jTable1.getValueAt(194, 3).toString(), jTable1.getValueAt(194, 4).toString() }); i++; } else break; if (jTable1.getRowCount() != i) { data.put("197", new Object[] { jTable1.getValueAt(195, 0).toString(), jTable1.getValueAt(195, 1).toString(), jTable1.getValueAt(195, 2).toString(), jTable1.getValueAt(195, 3).toString(), jTable1.getValueAt(195, 4).toString() }); i++; } else break; if (jTable1.getRowCount() != i) { data.put("198", new Object[] { jTable1.getValueAt(196, 0).toString(), jTable1.getValueAt(196, 1).toString(), jTable1.getValueAt(196, 2).toString(), jTable1.getValueAt(196, 3).toString(), jTable1.getValueAt(196, 4).toString() }); i++; } else break; if (jTable1.getRowCount() != i) { data.put("199", new Object[] { jTable1.getValueAt(197, 0).toString(), jTable1.getValueAt(197, 1).toString(), jTable1.getValueAt(197, 2).toString(), jTable1.getValueAt(197, 3).toString(), jTable1.getValueAt(197, 4).toString() }); i++; } else break; if (jTable1.getRowCount() != i) { data.put("200", new Object[] { jTable1.getValueAt(198, 0).toString(), jTable1.getValueAt(198, 1).toString(), jTable1.getValueAt(198, 2).toString(), jTable1.getValueAt(198, 3).toString(), jTable1.getValueAt(198, 4).toString() }); i++; } else break; if (jTable1.getRowCount() != i) { data.put("201", new Object[] { jTable1.getValueAt(199, 0).toString(), jTable1.getValueAt(199, 1).toString(), jTable1.getValueAt(199, 2).toString(), jTable1.getValueAt(199, 3).toString(), jTable1.getValueAt(199, 4).toString() }); i++; } else break; } Set<String> keyset = data.keySet(); int rownum = 0; for (String key : keyset) { Row row = sheet.createRow(rownum++); Object[] objArr = data.get(key); int cellnum = 0; for (Object obj : objArr) { XSSFCell cell = (XSSFCell) row.createCell(cellnum++); if (obj instanceof String) cell.setCellValue((String) obj); else if (obj instanceof Integer) cell.setCellValue((Integer) obj); } } try { //Write the workbook in file system FileOutputStream out = new FileOutputStream(new File(filename + ".xlsx")); workbook.write(out); out.close(); JOptionPane.showMessageDialog(null, "Data exported to excel sheet"); } catch (Exception e) { e.printStackTrace(); } }//GEN-LAST:event_jButton6ActionPerformed /** * @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(Multi_cal.class.getName()).log(java.util.logging.Level.SEVERE, null, ex); } catch (InstantiationException ex) { java.util.logging.Logger.getLogger(Multi_cal.class.getName()).log(java.util.logging.Level.SEVERE, null, ex); } catch (IllegalAccessException ex) { java.util.logging.Logger.getLogger(Multi_cal.class.getName()).log(java.util.logging.Level.SEVERE, null, ex); } catch (javax.swing.UnsupportedLookAndFeelException ex) { java.util.logging.Logger.getLogger(Multi_cal.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 Multi_cal().setVisible(true); } }); } // Variables declaration - do not modify//GEN-BEGIN:variables private javax.swing.JButton jButton1; private javax.swing.JButton jButton10; private javax.swing.JButton jButton11; 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.JComboBox jComboBox2; private javax.swing.JComboBox jComboBox3; private javax.swing.JLabel jLabel2; private javax.swing.JLabel jLabel5; private javax.swing.JLabel jLabel6; private javax.swing.JLabel jLabel7; private javax.swing.JList jList1; private javax.swing.JRadioButton jRadioButton1; private javax.swing.JRadioButton jRadioButton3; private javax.swing.JScrollPane jScrollPane1; private javax.swing.JScrollPane jScrollPane2; private javax.swing.JTable jTable1; private javax.swing.JTextField jTextField3; private javax.swing.JTextField jTextField4; private javax.swing.JTextField jname; // End of variables declaration//GEN-END:variables }