insertion of data in a particular column in a editor table in a database

[monisha kasturi]

Hi All ,
i want to edit particular column in my j table,i used iscelleditable() but if i will select particular column ,row for user input with hardcoded location the value entered into database but if i use loop so that as user select next row the value has to entered into database in next row and so on automatically it is not working out.I am pasting code here,i attached screenshot too ,here i want to enter in column number 3 and value has to entered into database,
My next question Sir,
I want to get value from database here in my stock quantity i want to get a value at a runtime means as user enetered into stockquantity it has to show at that time wether the thing is in stock or not if not it has to cancel.

/*
 * 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 ERP;

import java.awt.Component;
import java.awt.event.ActionListener;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import javax.swing.AbstractCellEditor;
import javax.swing.DefaultCellEditor;
import javax.swing.JComboBox;
import javax.swing.JOptionPane;
import javax.swing.JTable;
import javax.swing.table.TableColumn;
import javax.swing.table.TableModel;
import net.proteanit.sql.DbUtils;
import java.util.ArrayList;
import javax.swing.table.AbstractTableModel;

   import javax.swing.table.*; 
   import javax.swing.event.TableModelListener; 
  import javax.swing.event.TableModelEvent; 

/**
 *
 * @author rohtash
 */
public class SellStock extends javax.swing.JDialog {
   
       Connection conn=null;
    ResultSet rs=null;
    PreparedStatement pt=null;
    int i=0;
    
 

  
      Connection con=new DBConn().connect();



    /**
     * Creates new form SellStock
     */
    public SellStock(java.awt.Frame parent, boolean modal) {
        super(parent, modal);
        initComponents();
SellStocks();
editablecombo();
 Datecombo();
}
    /**
     * 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() {

        jSlider1 = new javax.swing.JSlider();
        jSeparator2 = new javax.swing.JSeparator();
        jSeparator3 = new javax.swing.JSeparator();
        jDesktopPane1 = new javax.swing.JDesktopPane();
        jLabel1 = new javax.swing.JLabel();
        CustomerName_Combo = new javax.swing.JComboBox();
        jLabel2 = new javax.swing.JLabel();
        Date_Combo = new javax.swing.JComboBox();
        jScrollPane1 = new javax.swing.JScrollPane();
        Tableeditor = new javax.swing.JTable();
        addtable = new java.awt.Button();
        button1 = new java.awt.Button();
        button3 = new java.awt.Button();
        button4 = new java.awt.Button();
        jScrollPane2 = new javax.swing.JScrollPane();
        jTextArea1 = new javax.swing.JTextArea();
        checkbox1 = new java.awt.Checkbox();
        jLabel3 = new javax.swing.JLabel();

        setDefaultCloseOperation(javax.swing.WindowConstants.DISPOSE_ON_CLOSE);
        setTitle("SellStock");
        setAlwaysOnTop(true);
        setAutoRequestFocus(false);
        getContentPane().setLayout(new org.netbeans.lib.awtextra.AbsoluteLayout());
        getContentPane().add(jSeparator2, new org.netbeans.lib.awtextra.AbsoluteConstraints(0, 240, -1, -1));
        getContentPane().add(jSeparator3, new org.netbeans.lib.awtextra.AbsoluteConstraints(0, 272, 400, 0));

        jLabel1.setFont(new java.awt.Font("Arial", 1, 12)); // NOI18N
        jLabel1.setForeground(java.awt.Color.white);
        jLabel1.setText("CustomerName");
        jDesktopPane1.add(jLabel1);
        jLabel1.setBounds(30, 20, 100, 20);

        CustomerName_Combo.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                CustomerName_ComboActionPerformed(evt);
            }
        });
        jDesktopPane1.add(CustomerName_Combo);
        CustomerName_Combo.setBounds(370, 20, 160, 22);

        jLabel2.setFont(new java.awt.Font("Arial", 1, 12)); // NOI18N
        jLabel2.setForeground(java.awt.Color.white);
        jLabel2.setText("Date of Sale");
        jDesktopPane1.add(jLabel2);
        jLabel2.setBounds(30, 120, 90, 20);

        jDesktopPane1.add(Date_Combo);
        Date_Combo.setBounds(450, 120, 90, 22);

        Tableeditor.setModel(new javax.swing.table.DefaultTableModel(
            new Object [][] {
                {null, null, null, null, null, null},
                {null, null, null, null, null, null},
                {null, null, null, null, null, null},
                {null, null, null, null, null, null},
                {null, null, null, null, null, null},
                {null, null, null, null, null, null},
                {null, null, null, null, null, null},
                {null, null, null, null, null, null},
                {null, null, null, null, null, null},
                {null, null, null, null, null, null},
                {null, null, null, null, null, null}
            },
            new String [] {
                "Item", "Description", "Location", "SellQuantity", "StockQuantity", "TotalPrice"
            }
        ));
        jScrollPane1.setViewportView(Tableeditor);

        jDesktopPane1.add(jScrollPane1);
        jScrollPane1.setBounds(0, 160, 580, 170);

        addtable.setLabel("ADD");
        addtable.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                addtableActionPerformed(evt);
            }
        });
        jDesktopPane1.add(addtable);
        addtable.setBounds(20, 340, 41, 24);

        button1.setLabel("Sell");
        jDesktopPane1.add(button1);
        button1.setBounds(160, 510, 60, 24);

        button3.setLabel("Cancel");
        button3.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                button3ActionPerformed(evt);
            }
        });
        jDesktopPane1.add(button3);
        button3.setBounds(230, 510, 55, 24);

        button4.setLabel("Help");
        jDesktopPane1.add(button4);
        button4.setBounds(300, 510, 42, 24);

        jTextArea1.setColumns(20);
        jTextArea1.setRows(5);
        jScrollPane2.setViewportView(jTextArea1);

        jDesktopPane1.add(jScrollPane2);
        jScrollPane2.setBounds(20, 410, 520, 96);

        checkbox1.setFont(new java.awt.Font("Arial", 1, 12)); // NOI18N
        checkbox1.setForeground(java.awt.Color.white);
        checkbox1.setLabel("Damaged Item");
        jDesktopPane1.add(checkbox1);
        checkbox1.setBounds(20, 380, 108, 19);

        jLabel3.setFont(new java.awt.Font("Arial", 1, 12)); // NOI18N
        jLabel3.setForeground(java.awt.Color.white);
        jLabel3.setText("Note");
        jDesktopPane1.add(jLabel3);
        jLabel3.setBounds(210, 380, 60, 20);

        getContentPane().add(jDesktopPane1, new org.netbeans.lib.awtextra.AbsoluteConstraints(0, 0, 580, 540));

        pack();
    }// </editor-fold>                        

    private void CustomerName_ComboActionPerformed(java.awt.event.ActionEvent evt) {                                                   
        // TODO add your handling code here:


      
        
        
    }                                                  

    private void addtableActionPerformed(java.awt.event.ActionEvent evt) {                                         
        // TODO add your handling code here
        
          try
        {
       
           
             
             /*String sql="INSERT INTO customerdata (Customer_Name,Date) VALUES (?,?)";
         
            pt=con.prepareStatement(sql);
            pt.setString(1,CustomerName_Combo.getSelectedItem().toString());
            pt.setString(2,Date_Combo.getSelectedItem().toString());
        pt.setString(3,Tableeditor.getValueAt(i, j).toString());*/
         String sql1="INSERT INTO selldata(SellQuantity) VALUES (?)";
           pt=con.prepareStatement(sql1);
         
         
             {
           pt.setString(1,Tableeditor.getValueAt(1,3).toString());
         
        
       fireTableCellUpdated(i, 3);
             }
pt.execute();

          con.close();

        
        } 
        catch (SQLException ex) {
           ex.printStackTrace();
        }
    
         dispose();
                                                   

    }                                        

    private void button3ActionPerformed(java.awt.event.ActionEvent evt) {                                        
        // TODO add your handling code here:
        dispose();
    }                                       
public void editablecombo(){
    CustomerName_Combo.setEditable(true);
    
  CustomerName_Combo.getSelectedIndex();
    CustomerName_Combo.addActionListener(Date_Combo);
    /* String text1 = (String)CustomerName_Combo.getSelectedItem();*/
     CustomerName_Combo.addItem("hello");
     CustomerName_Combo.addItem("check");
     CustomerName_Combo.addItem("Bye");
     
           String choice = CustomerName_Combo.getSelectedItem().toString();
           
      
           /* CustomerName_Combo.addActionListener(CustomerName_Combo);*/
  

}
    
    
    
    
public void Datecombo(){
    Date_Combo.setEditable(true);

}
   
    
    
    public void  SellStocks(){
        int i=0;
        int j=0;
        TableColumn ItemColumn = Tableeditor.getColumnModel().getColumn(0);
        JComboBox comboBox5 = new JComboBox();
        ItemColumn.setCellEditor(new DefaultCellEditor(comboBox5));
        /* String tableData = new String[row count][column count];

    for(i = 0; i < row count; i++)
    {
        for(j = 0; j < 3; j++)
        {
            tableData[i][j] = table.getValueAt(i, j).toString();
        }
    }*/
        TableColumn Description = Tableeditor.getColumnModel().getColumn(1);
        JComboBox comboBox1 = new JComboBox();
        Description.setCellEditor(new DefaultCellEditor(comboBox1));
        
        TableColumn Location = Tableeditor.getColumnModel().getColumn(2);
        JComboBox comboBox2 = new JComboBox();
        Location.setCellEditor(new DefaultCellEditor(comboBox2));
        
        TableColumn StockQuantity = Tableeditor.getColumnModel().getColumn(4);
        JComboBox comboBox3 = new JComboBox();
   StockQuantity.setCellEditor(new DefaultCellEditor(comboBox3));
  Tableeditor.getValueAt(i, j);
 
  Tableeditor.firePropertyChange(null, i, j);
  
    }
    
        
        
    

    
    /**
     * @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(SellStock.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
        } catch (InstantiationException ex) {
            java.util.logging.Logger.getLogger(SellStock.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
        } catch (IllegalAccessException ex) {
            java.util.logging.Logger.getLogger(SellStock.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
        } catch (javax.swing.UnsupportedLookAndFeelException ex) {
            java.util.logging.Logger.getLogger(SellStock.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
        }
        //</editor-fold>

        /* Create and display the dialog */
        java.awt.EventQueue.invokeLater(new Runnable() {
            public void run() {
                SellStock dialog = new SellStock(new javax.swing.JFrame(), true);
                dialog.addWindowListener(new java.awt.event.WindowAdapter() {
                    @Override
                    public void windowClosing(java.awt.event.WindowEvent e) {
                        System.exit(0);
                    }
                });
                dialog.setVisible(true);
            }
        });
    }

    // Variables declaration - do not modify                     
    private javax.swing.JComboBox CustomerName_Combo;
    private javax.swing.JComboBox Date_Combo;
    private javax.swing.JTable Tableeditor;
    private java.awt.Button addtable;
    private java.awt.Button button1;
    private java.awt.Button button3;
    private java.awt.Button button4;
    private java.awt.Checkbox checkbox1;
    private javax.swing.JDesktopPane jDesktopPane1;
    private javax.swing.JLabel jLabel1;
    private javax.swing.JLabel jLabel2;
    private javax.swing.JLabel jLabel3;
    private javax.swing.JScrollPane jScrollPane1;
    private javax.swing.JScrollPane jScrollPane2;
    private javax.swing.JSeparator jSeparator2;
    private javax.swing.JSeparator jSeparator3;
    private javax.swing.JSlider jSlider1;
    private javax.swing.JTextArea jTextArea1;
    // End of variables declaration                   

    private void fireTableCellUpdated(int i, int i0) {
        throw new UnsupportedOperationException("Not supported yet."); //To change body of generated methods, choose Tools | Templates.
    }

}
    

[Campbell Ritchie]

Welcome to the Ranch

You have found the wrong forum; this one is for discussing the Ranch itself. I shall move you.
You are going to make life difficult for yourself if you try insertion into the database and updating the column simultaneously. Do one or the other. In fact I think you should remove all your GUI code and not add a GUI until you can reliably show all the database operations at a terminal/command line. Let's get the database operation working first, so I shall move you to the databases forum.

Why are you writing null 36 times? If you want 36 nulls you can simply write new Object[6][6].

[Swastik Dey]

As suggested by Campbell, you first need to make sure that your db operations are perfect. Then it would be nice if you could please elaborate little more on your UI functionality as per the screen design.

[monisha kasturi]

Hi i am able to connect with database and the values are going properly now next thing is jcombos linking,suppose if i user will select the any value from jcombo then this value will trigger rest two combos that is description and the location as show in fig,As the values are in the databse but i am not getting the logoic how can i solve this issue, here what i have done liitle code by this iam able to called values in the jcombos but how can i do this ,that if we select one value in jcombo1(main combo) the rest other have to select automatically this is the method i have prepared inside class as shown above
thankyou so much all

public void ItemCombo(){
    
     TableColumn ItemColumn = Tableeditor.getColumnModel().getColumn(0);
        JComboBox comboBox5 = new JComboBox();
        ItemColumn.setCellEditor(new DefaultCellEditor(comboBox5));
        
    TableColumn Description = Tableeditor.getColumnModel().getColumn(1);
        JComboBox comboBox1 = new JComboBox();
        Description.setCellEditor(new DefaultCellEditor(comboBox1));
        
         TableColumn Location = Tableeditor.getColumnModel().getColumn(2);
        JComboBox comboBox2 = new JComboBox();
        Location.setCellEditor(new DefaultCellEditor(comboBox2));
         
        
  try
    {
     
         String sql="select * from Itemdetails";
        pt=con.prepareStatement(sql);
  rs=pt.executeQuery();
      while(rs.next())
      {
          String Item=rs.getString("ItemCode");
          comboBox5.addItem(Item);
          comboBox5.addActionListener(comboBox1);
          comboBox5.addItemListener(null);
          
  String Descriptions=rs.getString("ItemDescription");
       comboBox1.addItem(Descriptions);
       comboBox1.addActionListener(comboBox5);
       
          String items = (String) comboBox5.getSelectedItem();
         Object o =comboBox1.getAction();
        if (o == null) {
            comboBox1.setModel(new DefaultComboBoxModel());
        } else {
            comboBox1.setModel(new DefaultComboBoxModel((String[]) o));
        }
    }
       /*String Locat=rs.getString("Location");
          comboBox2.addItem(Locat);*/
          
          
          
       }
 catch(Exception ex)
              {
          JOptionPane.showMessageDialog(null,ex);
    }
 
  
}{

[Swastik Dey]

Monisha

I think you should use ItemLister with JComboBox and on itemStateChanged event perform the necessary action.

[monisha kasturi]

Hi Swastik ,
I know i should have to use itemlistener or action listener but how should i use into my jdialog where to put this method because thsese are to extend from classes but i already have one class of jdialog now where should i put it,if you have any dummy code please forword me just for understanding.

[Swastik Dey]

It could be somewhat like this

public class MyDialog extends JDialog{
	JComboBox jb=null;
	public MyDialog(){
		super.setSize(300, 300);
		jb=new JComboBox();
		jb.addItem("A");
		jb.addItem("B");
		jb.addItem("C");
		//super.setVisible(true);
		jb.addItemListener(new ComboBoxHandler());
		add(jb);
	}
	
	class ComboBoxHandler implements ItemListener{

		@Override
		public void itemStateChanged(ItemEvent e) {
			// TODO Auto-generated method stub
			System.out.println("selected item is :"+jb.getSelectedItem());
		}
		
	}
}