Databases
StackOverflow2013
Postsdbo
POJTable runtime calculation?
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POJTable runtime calculation?
    primarykey
    data
    text
    <p>This is my group project part. When I enter the customer id and press OK, the customer details appear in tabular format. The table contains columns like: Sunday, rate, Saturday, rate, other, rate like. </p> <p>My problem is I want to enter the integer number, calculate it and then store it in a database. Means run time in table I want to enter the number, calculate and need to be stored in database. What to do? Thanks in advance.</p> <pre><code> import java.awt.BorderLayout; import java.awt.EventQueue; import java.awt.event.ActionEvent; import java.awt.event.ActionListener; import java.sql.*; import javax.swing.*; import javax.swing.event.CellEditorListener; import javax.swing.event.ChangeEvent; import javax.swing.table.DefaultTableModel; public class TestTable { public static void main(String[] args) { TestTable testTable = new TestTable(); } public TestTable() { EventQueue.invokeLater(new Runnable() { @Override public void run() { try { UIManager.setLookAndFeel(UIManager.getSystemLookAndFeelClassName()); } catch (ClassNotFoundException | InstantiationException | IllegalAccessException | UnsupportedLookAndFeelException ex) { } JFrame frame = new JFrame("Testing"); frame.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE); frame.setLayout(new BorderLayout()); frame.add(new TestTable.Bill()); frame.pack(); frame.setLocationRelativeTo(null); frame.setVisible(true); } }); } public class Bill extends JPanel implements ActionListener ,CellEditorListener { JTextField textFieldId; JLabel l1; JLabel l2; JButton b1,b2,b3; JTextField sun,sunr,sat,satr,oth,othr; float sum1,totall; ResultSet rs1 = null; DefaultTableModel model = new DefaultTableModel(); private int rows; Double value; public Bill() { setLayout(new BorderLayout()); JPanel fields = new JPanel(); textFieldId = new JTextField(10); l1 = new JLabel("New Customer Entry :-"); l2 = new JLabel("Customer Id"); b1 = new JButton("OK"); b2 = new JButton("Calculate"); b3 = new JButton("Print"); fields.add(l2); fields.add(textFieldId); fields.add(b1); fields.add(b2); fields.add(b3); add(fields, BorderLayout.NORTH); b1.addActionListener(this); b2.addActionListener(this); b3.addActionListener(this); // Don't forget to add a table. add(new JScrollPane(new JTable(model))); } @Override public void actionPerformed(ActionEvent e) { System.out.println("You clicked the button"); Connection con; if (e.getSource() == b1) { PreparedStatement ps = null; Statement stmt = null; try { Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); con = DriverManager.getConnection("jdbc:odbc:devendra"); ps = con.prepareStatement("SELECT * FROM Customer where Customer_Id = ?"); // You must bind the parameter with a value... ps.setString(1, textFieldId.getText()); rs1 = ps.executeQuery(); model.addColumn("Customer_Id"); model.addColumn("Customer_Name"); model.addColumn("Contact"); model.addColumn("Paper_Name"); model.addColumn("Sunday"); model.addColumn("Rate"); model.addColumn("Satarday"); model.addColumn("Rate"); model.addColumn("Other Day"); model.addColumn("Rate"); model.addColumn("Price"); model.setRowCount(0); while (rs1.next()) { model.addRow(new Object[]{rs1.getString(1),rs1.getString(2),rs1.getString(3),rs1.getString(4),rs1.getString(5), rs1.getString(6),rs1.getString(7),rs1.getString(8),rs1.getString(9),rs1.getString(10)}); } // Vector data = model.getDataVector(); JOptionPane.showMessageDialog(null, "You successfully Enter the Entry"); } catch (SQLException s) { System.out.println("SQL code does not execute."); JOptionPane.showMessageDialog(null, "Please Enter the Detail Correctly"); } catch (Exception exp) { JOptionPane.showMessageDialog(this, "Failed to perform query: " + exp.getMessage()); } finally { try { ps.close(); } catch (Exception ex) { } } } if (e.getSource() == b2) { int rowCount = model.getRowCount(); for(int i =1; i&lt;rowCount;i++) { Double valuea = (Double) model.getValueAt(i, 5 ); Double valueb = (Double) model.getValueAt(i, 6 ); Double valuec = (Double) model.getValueAt(i, 7 ); Double valued = (Double) model.getValueAt(i, 8 ); Double valuee = (Double) model.getValueAt(i, 9 ); Double valuef = (Double) model.getValueAt(i, 10 ); double value; value = Double.parseDouble( String.valueOf( valuea ) ) * Double.parseDouble( String.valueOf( valueb ) ); model.setValueAt( value, i, 10 ); } } </code></pre> <p>}</p> <pre><code> @Override public void editingStopped(ChangeEvent e) { throw new UnsupportedOperationException("Not supported yet."); } @Override public void editingCanceled(ChangeEvent e) { throw new UnsupportedOperationException("Not supported yet."); } } </code></pre> <p>}</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USSmita Parab
    1. USSmita Parab
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POJTable runtime calculation?
      1. This table or related slice is empty.
      1. VTApproveEditSuggestion
    2. VO
      singulars
      1. POJTable runtime calculation?
      1. This table or related slice is empty.
      1. VTDownMod
    3. VO
      singulars
      1. POJTable runtime calculation?
      1. This table or related slice is empty.
      1. VTUpMod
    1. CO_I want to enter the number, calculate [and] store in database._ What's stopping you? Where is your `UPDATE` statement? You're asking someone to debug/revise lengthy code run against an implied schema on an inaccessible database using a poorly supported driver. L&F should be irrelevant, and only one database attribute is required. Please edit your question to include an [sscce](http://sscce.org/) that exhibits the problem.
      singulars
      1. POJTable runtime calculation?
      1. UStrashgod
    2. COi just edited the code.when i run these code it get successfully execution but i not give me proper output as i want it. now what to do please tell me???
      singulars
      1. POJTable runtime calculation?
      1. USSmita Parab
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload