how to insert value from jtable to mysql?

Question

Im trying to insert data from jtable to database!! the first three columns(stafftimetableid,staffname,staffid) are inserted from the jtexfield(no errors found,successfully added) but when im trying to insert from jtable it promts a java.null pointerExcetion error !!

I have no errors in database connection !!

private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {                                         
        if (jComboBox1.getSelectedItem().equals("Staff Time Table"))
        {
            try 
            {
                PreparedStatement pst =null;
                Connection con = clerkpanell.DBConnection.connectDB();
                String data=jTable2.getValueAt(0,1).toString();

                String sql = "insert into stafftimetable      (StaffTimeTableID,StaffName,StaffID,7.50-8.30) values ('"+ttid.getText()+"','"+staffname.getText()+"','"+staffid.getText()+"','"+data+"');";


                 pst=con.prepareStatement(sql);
                 pst.executeUpdate();
             //    JOptionPane.showMessageDialog(null,"Added");
            }
            catch (Exception e)

            {
                JOptionPane.showMessageDialog(null,e);

            }    
        }

Code Geek · Accepted Answer · 2014-08-21 12:36:04Z

1

In this statement String sql = "insert into stafftimetable (StaffTimeTableID,StaffName,StaffID,7.50-8.30) values ('"+ttid.getText()+"','"+staffname.getText()+"','"+staffid.getText()+"','"+data+"');";

Please store the ttid.getText(), staffname.getText(),staffid.getText()into separate variables. Something like this,

String ttid=ttid.getText();
String staffname = staffname.getText();
String staffid = staffid.getText();

and then the insert statement should be something like this

String sql = "insert into stafftimetable      (StaffTimeTableID,StaffName,StaffID,7.50-8.30) values ('"+ttid.+"','"+staffname+"','"+staffid+"','"+data+"');";

answered Aug 21, 2014 at 12:36

Code Geek

5051 gold badge5 silver badges15 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

how to insert value from jtable to mysql?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related