API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Dec 15th, 2017
112
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Java 43.03 KB | None | 0 0
raw download clone embed print report
  1. /*
  2.  * To change this license header, choose License Headers in Project Properties.
  3.  * To change this template file, choose Tools | Templates
  4.  * and open the template in the editor.
  5.  */
  6. package techtight;
  7.  
  8. import java.net.UnknownHostException;
  9. import java.sql.Connection;
  10. import java.sql.DriverManager;
  11. import java.sql.PreparedStatement;
  12. import javax.swing.JOptionPane;
  13. import java.sql.*;
  14. import java.util.logging.Level;
  15. import java.util.logging.Logger;
  16. import javax.swing.DefaultCellEditor;
  17. import javax.swing.JComboBox;
  18. import javax.swing.JTextField;
  19. import javax.swing.table.DefaultTableModel;
  20. import javax.swing.table.TableColumn;
  21.  
  22. /**
  23.  *
  24.  * @author java
  25.  */
  26. public class newclient extends javax.swing.JFrame {
  27.    
  28.    
  29.  
  30.     /**
  31.      * Creates new form newclient
  32.      */
  33.     public newclient() {
  34.         initComponents();
  35.        
  36.        
  37.        
  38.        
  39.            //JOptionPane.showMessageDialog(rootPane, "wow");
  40.           try {
  41.                  Connection conn;
  42.                  String dbuser = "root";
  43.                  String dbpassw = "King@123";
  44.                  String databasename = "taxi";
  45.                  String url = "jdbc:mysql://localhost/dbtec";
  46.                  Class.forName("com.mysql.jdbc.Driver");
  47.                  conn = DriverManager.getConnection(url,dbuser,dbpassw);
  48.                  Statement st = conn.createStatement();
  49.              
  50.                 ////  Try combo box
  51.                 TableColumn suppliercolumn = tblsales.getColumnModel().getColumn(2);
  52.                  JComboBox cbosupplier = new JComboBox();
  53.                  
  54.                 suppliercolumn.setCellEditor(new DefaultCellEditor(cbosupplier));
  55.                 ///end it
  56.                  
  57.             ResultSet rs = st.executeQuery("SELECT supliername  FROM  tblsuppliers");        
  58.  
  59.            
  60.                    while(rs.next()){
  61.                        
  62.                        //String id = rs.getString("memberid");
  63.                      String supplier_name = rs.getString("supliername");
  64.                     cbosupplier.addItem(supplier_name);
  65.                      String clientName = rs.getString("supliername");
  66.                      cboclients.addItem(clientName);
  67.                        
  68.              
  69.                    }
  70.                 //JOptionPane.showMessageDialog(null, "okay");
  71.            
  72.             } catch (SQLException ex) {
  73.                 Logger.getLogger(myLogin.class.getName()).log(Level.SEVERE, null, ex);
  74.             } catch (ClassNotFoundException ex) {
  75.                 Logger.getLogger(myLogin.class.getName()).log(Level.SEVERE, null, ex);
  76.             }            
  77.          
  78.        
  79.             // ANOTHER QUERY  // txtdatechooser
  80.      
  81.                    
  82.        
  83.         /////////End combo////////
  84.     }
  85.  
  86.     /**
  87.      * This method is called from within the constructor to initialize the form.
  88.      * WARNING: Do NOT modify this code. The content of this method is always
  89.      * regenerated by the Form Editor.
  90.      */
  91.     @SuppressWarnings("unchecked")
  92.     // <editor-fold defaultstate="collapsed" desc="Generated Code">                          
  93.     private void initComponents() {
  94.  
  95.         jTextField1 = new javax.swing.JTextField();
  96.         jCalModel1 = new com.jcalendar.model.JCalModel();
  97.         jCalModel2 = new com.jcalendar.model.JCalModel();
  98.         cbods = new javax.swing.JComboBox<>();
  99.         cbocas = new javax.swing.JComboBox<>();
  100.         jLabel15 = new javax.swing.JLabel();
  101.         jPanel2 = new javax.swing.JPanel();
  102.         jLabel2 = new javax.swing.JLabel();
  103.         jLabel10 = new javax.swing.JLabel();
  104.         cbocpsotype = new javax.swing.JComboBox<>();
  105.         cboprobability = new javax.swing.JComboBox<>();
  106.         txtdatechooser = new com.toedter.calendar.JDateChooser();
  107.         jLabel13 = new javax.swing.JLabel();
  108.         jPanel3 = new javax.swing.JPanel();
  109.         jLabel19 = new javax.swing.JLabel();
  110.         jLabel8 = new javax.swing.JLabel();
  111.         jLabel3 = new javax.swing.JLabel();
  112.         jLabel7 = new javax.swing.JLabel();
  113.         jLabel20 = new javax.swing.JLabel();
  114.         jLabel21 = new javax.swing.JLabel();
  115.         cbosalesperson = new javax.swing.JComboBox<>();
  116.         txtclientdescription = new javax.swing.JTextField();
  117.         txtclientpo = new javax.swing.JTextField();
  118.         txtattention = new javax.swing.JTextField();
  119.         txtbranchdev = new javax.swing.JTextField();
  120.         cboclients = new javax.swing.JComboBox<>();
  121.         jPanel5 = new javax.swing.JPanel();
  122.         jLabel29 = new javax.swing.JLabel();
  123.         jLabel30 = new javax.swing.JLabel();
  124.         jLabel31 = new javax.swing.JLabel();
  125.         txttotalsum = new javax.swing.JTextField();
  126.         jTextField45 = new javax.swing.JTextField();
  127.         jTextField46 = new javax.swing.JTextField();
  128.         jPanel6 = new javax.swing.JPanel();
  129.         jButton3 = new javax.swing.JButton();
  130.         jButton2 = new javax.swing.JButton();
  131.         btnsave = new javax.swing.JButton();
  132.         jLabel32 = new javax.swing.JLabel();
  133.         jScrollPane1 = new javax.swing.JScrollPane();
  134.         tblrevenue1 = new javax.swing.JTable();
  135.         jScrollPane2 = new javax.swing.JScrollPane();
  136.         tblsales = new javax.swing.JTable();
  137.         btnaddsalesrow = new javax.swing.JButton();
  138.         btndeleterowrevenue = new javax.swing.JButton();
  139.         jButton5 = new javax.swing.JButton();
  140.         btnaddrowrevenue = new javax.swing.JButton();
  141.  
  142.         cbods.setModel(new javax.swing.DefaultComboBoxModel<>(new String[] { "IT", "Mnagement", "HR", "Maketing" }));
  143.  
  144.         cbocas.setModel(new javax.swing.DefaultComboBoxModel<>(new String[] { "Account", "Amount", "All", "Suprer" }));
  145.  
  146.         setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE);
  147.         setResizable(false);
  148.         setSize(new java.awt.Dimension(1200, 1000));
  149.  
  150.         jLabel15.setText("Client PO");
  151.  
  152.         jPanel2.setBorder(javax.swing.BorderFactory.createMatteBorder(4, 4, 4, 4, new java.awt.Color(0, 0, 0)));
  153.         jPanel2.setPreferredSize(new java.awt.Dimension(1000, 100));
  154.  
  155.         jLabel2.setText("Cposo Type:");
  156.  
  157.         jLabel10.setText("Probabilty: ");
  158.  
  159.         cbocpsotype.setModel(new javax.swing.DefaultComboBoxModel<>(new String[] { "Actual", "Forcast", "Budget" }));
  160.  
  161.         cboprobability.setModel(new javax.swing.DefaultComboBoxModel<>(new String[] { "High", "Med", "Low", "Lost", "" }));
  162.  
  163.         txtdatechooser.setDateFormatString("yyyy-MM-dd");
  164.  
  165.         jLabel13.setText("Date:");
  166.  
  167.         javax.swing.GroupLayout jPanel2Layout = new javax.swing.GroupLayout(jPanel2);
  168.         jPanel2.setLayout(jPanel2Layout);
  169.         jPanel2Layout.setHorizontalGroup(
  170.             jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  171.             .addGroup(jPanel2Layout.createSequentialGroup()
  172.                 .addContainerGap()
  173.                 .addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  174.                     .addGroup(jPanel2Layout.createSequentialGroup()
  175.                         .addComponent(jLabel13)
  176.                         .addGap(55, 55, 55)
  177.                         .addComponent(txtdatechooser, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
  178.                     .addGroup(jPanel2Layout.createSequentialGroup()
  179.                         .addComponent(jLabel2, javax.swing.GroupLayout.PREFERRED_SIZE, 95, javax.swing.GroupLayout.PREFERRED_SIZE)
  180.                         .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, 98, Short.MAX_VALUE)
  181.                         .addComponent(cbocpsotype, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
  182.                     .addGroup(jPanel2Layout.createSequentialGroup()
  183.                         .addComponent(jLabel10)
  184.                         .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
  185.                         .addComponent(cboprobability, 0, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)))
  186.                 .addContainerGap())
  187.         );
  188.         jPanel2Layout.setVerticalGroup(
  189.             jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  190.             .addGroup(jPanel2Layout.createSequentialGroup()
  191.                 .addContainerGap()
  192.                 .addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
  193.                     .addComponent(jLabel2)
  194.                     .addComponent(cbocpsotype, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
  195.                 .addGap(18, 18, 18)
  196.                 .addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
  197.                     .addComponent(jLabel10)
  198.                     .addComponent(cboprobability, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
  199.                 .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
  200.                 .addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  201.                     .addComponent(jLabel13)
  202.                     .addComponent(txtdatechooser, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
  203.                 .addContainerGap(javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
  204.         );
  205.  
  206.         jPanel3.setBorder(javax.swing.BorderFactory.createMatteBorder(4, 4, 4, 4, new java.awt.Color(255, 204, 51)));
  207.         jPanel3.setPreferredSize(new java.awt.Dimension(1000, 125));
  208.  
  209.         jLabel19.setText("Description:");
  210.  
  211.         jLabel8.setText("Attention: ");
  212.  
  213.         jLabel3.setText("Branch/DIV:");
  214.  
  215.         jLabel7.setText("Client PO:");
  216.  
  217.         jLabel20.setText("Client:");
  218.  
  219.         jLabel21.setText("Sales Person:");
  220.  
  221.         cbosalesperson.setModel(new javax.swing.DefaultComboBoxModel<>(new String[] { "Item 1", "Item 2", "Item 3", "Item 4" }));
  222.  
  223.         cboclients.setModel(new javax.swing.DefaultComboBoxModel<>(new String[] { "Select Client" }));
  224.  
  225.         javax.swing.GroupLayout jPanel3Layout = new javax.swing.GroupLayout(jPanel3);
  226.         jPanel3.setLayout(jPanel3Layout);
  227.         jPanel3Layout.setHorizontalGroup(
  228.             jPanel3Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  229.             .addGroup(javax.swing.GroupLayout.Alignment.TRAILING, jPanel3Layout.createSequentialGroup()
  230.                 .addContainerGap()
  231.                 .addGroup(jPanel3Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  232.                     .addComponent(jLabel21)
  233.                     .addComponent(jLabel20)
  234.                     .addComponent(jLabel7)
  235.                     .addComponent(jLabel19))
  236.                 .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
  237.                 .addGroup(jPanel3Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  238.                     .addComponent(txtclientdescription, javax.swing.GroupLayout.PREFERRED_SIZE, 117, javax.swing.GroupLayout.PREFERRED_SIZE)
  239.                     .addGroup(jPanel3Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING, false)
  240.                         .addComponent(cbosalesperson, javax.swing.GroupLayout.Alignment.LEADING, 0, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
  241.                         .addComponent(cboclients, javax.swing.GroupLayout.Alignment.LEADING, 0, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
  242.                         .addComponent(txtclientpo, javax.swing.GroupLayout.Alignment.LEADING)))
  243.                 .addGap(977, 977, 977)
  244.                 .addGroup(jPanel3Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  245.                     .addComponent(jLabel8)
  246.                     .addComponent(jLabel3))
  247.                 .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
  248.                 .addGroup(jPanel3Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  249.                     .addComponent(txtattention, javax.swing.GroupLayout.Alignment.TRAILING, javax.swing.GroupLayout.PREFERRED_SIZE, 200, javax.swing.GroupLayout.PREFERRED_SIZE)
  250.                     .addComponent(txtbranchdev, javax.swing.GroupLayout.Alignment.TRAILING, javax.swing.GroupLayout.PREFERRED_SIZE, 200, javax.swing.GroupLayout.PREFERRED_SIZE))
  251.                 .addGap(28, 28, 28))
  252.         );
  253.         jPanel3Layout.setVerticalGroup(
  254.             jPanel3Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  255.             .addGroup(jPanel3Layout.createSequentialGroup()
  256.                 .addGroup(jPanel3Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING, false)
  257.                     .addGroup(jPanel3Layout.createSequentialGroup()
  258.                         .addGap(21, 21, 21)
  259.                         .addGroup(jPanel3Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
  260.                             .addComponent(jLabel8, javax.swing.GroupLayout.PREFERRED_SIZE, 37, javax.swing.GroupLayout.PREFERRED_SIZE)
  261.                             .addComponent(txtattention, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)))
  262.                     .addGroup(jPanel3Layout.createSequentialGroup()
  263.                         .addContainerGap()
  264.                         .addGroup(jPanel3Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
  265.                             .addComponent(jLabel19)
  266.                             .addComponent(txtclientdescription, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
  267.                         .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
  268.                         .addGroup(jPanel3Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
  269.                             .addComponent(jLabel20)
  270.                             .addComponent(cboclients, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))))
  271.                 .addGap(18, 18, 18)
  272.                 .addGroup(jPanel3Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  273.                     .addGroup(jPanel3Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
  274.                         .addComponent(jLabel3)
  275.                         .addComponent(txtbranchdev, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
  276.                     .addGroup(jPanel3Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
  277.                         .addComponent(jLabel21)
  278.                         .addComponent(cbosalesperson, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)))
  279.                 .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
  280.                 .addGroup(jPanel3Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  281.                     .addComponent(txtclientpo, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
  282.                     .addComponent(jLabel7))
  283.                 .addContainerGap(javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
  284.         );
  285.  
  286.         jPanel5.setBackground(new java.awt.Color(102, 0, 51));
  287.         jPanel5.setPreferredSize(new java.awt.Dimension(800, 59));
  288.  
  289.         jLabel29.setFont(new java.awt.Font("Dialog", 2, 18)); // NOI18N
  290.         jLabel29.setForeground(new java.awt.Color(255, 255, 255));
  291.         jLabel29.setText("Gross Profit R:");
  292.  
  293.         jLabel30.setFont(new java.awt.Font("Dialog", 2, 18)); // NOI18N
  294.         jLabel30.setForeground(new java.awt.Color(255, 255, 255));
  295.         jLabel30.setText("GP Margin (%)");
  296.  
  297.         jLabel31.setFont(new java.awt.Font("Dialog", 2, 18)); // NOI18N
  298.         jLabel31.setForeground(new java.awt.Color(255, 255, 255));
  299.         jLabel31.setText("Markup (%)");
  300.  
  301.         javax.swing.GroupLayout jPanel5Layout = new javax.swing.GroupLayout(jPanel5);
  302.         jPanel5.setLayout(jPanel5Layout);
  303.         jPanel5Layout.setHorizontalGroup(
  304.             jPanel5Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  305.             .addGroup(javax.swing.GroupLayout.Alignment.TRAILING, jPanel5Layout.createSequentialGroup()
  306.                 .addGroup(jPanel5Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  307.                     .addGroup(jPanel5Layout.createSequentialGroup()
  308.                         .addGap(143, 143, 143)
  309.                         .addComponent(jTextField45, javax.swing.GroupLayout.PREFERRED_SIZE, 90, javax.swing.GroupLayout.PREFERRED_SIZE))
  310.                     .addGroup(jPanel5Layout.createSequentialGroup()
  311.                         .addGap(128, 128, 128)
  312.                         .addComponent(jLabel30)))
  313.                 .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
  314.                 .addGroup(jPanel5Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  315.                     .addGroup(jPanel5Layout.createSequentialGroup()
  316.                         .addComponent(jLabel31)
  317.                         .addGap(142, 142, 142)
  318.                         .addComponent(jLabel29))
  319.                     .addGroup(jPanel5Layout.createSequentialGroup()
  320.                         .addComponent(jTextField46, javax.swing.GroupLayout.PREFERRED_SIZE, 90, javax.swing.GroupLayout.PREFERRED_SIZE)
  321.                         .addGap(171, 171, 171)
  322.                         .addComponent(txttotalsum, javax.swing.GroupLayout.PREFERRED_SIZE, 90, javax.swing.GroupLayout.PREFERRED_SIZE)))
  323.                 .addGap(66, 66, 66))
  324.         );
  325.         jPanel5Layout.setVerticalGroup(
  326.             jPanel5Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  327.             .addGroup(javax.swing.GroupLayout.Alignment.TRAILING, jPanel5Layout.createSequentialGroup()
  328.                 .addContainerGap(25, Short.MAX_VALUE)
  329.                 .addGroup(jPanel5Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
  330.                     .addComponent(jLabel30)
  331.                     .addComponent(jLabel29)
  332.                     .addComponent(jLabel31))
  333.                 .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
  334.                 .addGroup(jPanel5Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING, false)
  335.                     .addComponent(jTextField45, javax.swing.GroupLayout.DEFAULT_SIZE, 33, Short.MAX_VALUE)
  336.                     .addComponent(txttotalsum)
  337.                     .addComponent(jTextField46))
  338.                 .addContainerGap())
  339.         );
  340.  
  341.         jPanel6.setBackground(new java.awt.Color(51, 51, 255));
  342.         jPanel6.setBorder(javax.swing.BorderFactory.createLineBorder(new java.awt.Color(0, 0, 0)));
  343.         jPanel6.setPreferredSize(new java.awt.Dimension(800, 62));
  344.  
  345.         jButton3.setBackground(new java.awt.Color(255, 255, 0));
  346.         jButton3.setText("Clear ");
  347.         jButton3.addActionListener(new java.awt.event.ActionListener() {
  348.             public void actionPerformed(java.awt.event.ActionEvent evt) {
  349.                 jButton3ActionPerformed(evt);
  350.             }
  351.         });
  352.  
  353.         jButton2.setBackground(new java.awt.Color(255, 0, 0));
  354.         jButton2.setForeground(new java.awt.Color(255, 255, 255));
  355.         jButton2.setText("Close");
  356.  
  357.         btnsave.setBackground(new java.awt.Color(0, 204, 0));
  358.         btnsave.setText("Save");
  359.         btnsave.addActionListener(new java.awt.event.ActionListener() {
  360.             public void actionPerformed(java.awt.event.ActionEvent evt) {
  361.                 btnsaveActionPerformed(evt);
  362.             }
  363.         });
  364.  
  365.         javax.swing.GroupLayout jPanel6Layout = new javax.swing.GroupLayout(jPanel6);
  366.         jPanel6.setLayout(jPanel6Layout);
  367.         jPanel6Layout.setHorizontalGroup(
  368.             jPanel6Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  369.             .addGroup(javax.swing.GroupLayout.Alignment.TRAILING, jPanel6Layout.createSequentialGroup()
  370.                 .addGap(81, 81, 81)
  371.                 .addComponent(btnsave, javax.swing.GroupLayout.PREFERRED_SIZE, 137, javax.swing.GroupLayout.PREFERRED_SIZE)
  372.                 .addGap(40, 40, 40)
  373.                 .addComponent(jButton2, javax.swing.GroupLayout.PREFERRED_SIZE, 137, javax.swing.GroupLayout.PREFERRED_SIZE)
  374.                 .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, 92, Short.MAX_VALUE)
  375.                 .addComponent(jButton3, javax.swing.GroupLayout.PREFERRED_SIZE, 137, javax.swing.GroupLayout.PREFERRED_SIZE)
  376.                 .addContainerGap())
  377.         );
  378.         jPanel6Layout.setVerticalGroup(
  379.             jPanel6Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  380.             .addGroup(jPanel6Layout.createSequentialGroup()
  381.                 .addGap(0, 15, Short.MAX_VALUE)
  382.                 .addGroup(jPanel6Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
  383.                     .addComponent(jButton2, javax.swing.GroupLayout.PREFERRED_SIZE, 48, javax.swing.GroupLayout.PREFERRED_SIZE)
  384.                     .addComponent(btnsave, javax.swing.GroupLayout.PREFERRED_SIZE, 48, javax.swing.GroupLayout.PREFERRED_SIZE)))
  385.             .addGroup(jPanel6Layout.createSequentialGroup()
  386.                 .addContainerGap()
  387.                 .addComponent(jButton3, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
  388.         );
  389.  
  390.         jLabel32.setFont(new java.awt.Font("DialogInput", 3, 36)); // NOI18N
  391.         jLabel32.setForeground(new java.awt.Color(0, 0, 0));
  392.         jLabel32.setText("Super System ");
  393.         jLabel32.setMaximumSize(new java.awt.Dimension(200, 150));
  394.  
  395.         tblrevenue1.setBorder(new javax.swing.border.LineBorder(new java.awt.Color(0, 0, 0), 1, true));
  396.         tblrevenue1.setModel(new javax.swing.table.DefaultTableModel(
  397.             new Object [][] {
  398.                 {null, null, null, null, null, null}
  399.             },
  400.             new String [] {
  401.                 "Divsion", "Rev Account", "Description", "Qty", "UnitPrice", "Total"
  402.             }
  403.         ));
  404.         tblrevenue1.setToolTipText("");
  405.         jScrollPane1.setViewportView(tblrevenue1);
  406.  
  407.         tblsales.setModel(new javax.swing.table.DefaultTableModel(
  408.             new Object [][] {
  409.                 {null, null, null, null, null, null}
  410.             },
  411.             new String [] {
  412.                 "Division", "Cos Account", "Supplier", "Description", "Quote Ref", "Price"
  413.             }
  414.         ));
  415.         jScrollPane2.setViewportView(tblsales);
  416.         if (tblsales.getColumnModel().getColumnCount() > 0) {
  417.             tblsales.getColumnModel().getColumn(0).setCellEditor(new DefaultCellEditor(cbods));
  418.             tblsales.getColumnModel().getColumn(1).setCellEditor(new DefaultCellEditor(cbocas));
  419.         }
  420.  
  421.         btnaddsalesrow.setText("Add Row");
  422.         btnaddsalesrow.addActionListener(new java.awt.event.ActionListener() {
  423.             public void actionPerformed(java.awt.event.ActionEvent evt) {
  424.                 btnaddsalesrowActionPerformed(evt);
  425.             }
  426.         });
  427.  
  428.         btndeleterowrevenue.setText("Delete Row");
  429.         btndeleterowrevenue.addActionListener(new java.awt.event.ActionListener() {
  430.             public void actionPerformed(java.awt.event.ActionEvent evt) {
  431.                 btndeleterowrevenueActionPerformed(evt);
  432.             }
  433.         });
  434.  
  435.         jButton5.setText("Delete Row");
  436.         jButton5.addActionListener(new java.awt.event.ActionListener() {
  437.             public void actionPerformed(java.awt.event.ActionEvent evt) {
  438.                 jButton5ActionPerformed(evt);
  439.             }
  440.         });
  441.  
  442.         btnaddrowrevenue.setText("Add Row");
  443.         btnaddrowrevenue.addActionListener(new java.awt.event.ActionListener() {
  444.             public void actionPerformed(java.awt.event.ActionEvent evt) {
  445.                 btnaddrowrevenueActionPerformed(evt);
  446.             }
  447.         });
  448.  
  449.         javax.swing.GroupLayout layout = new javax.swing.GroupLayout(getContentPane());
  450.         getContentPane().setLayout(layout);
  451.         layout.setHorizontalGroup(
  452.             layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  453.             .addGroup(layout.createSequentialGroup()
  454.                 .addGap(0, 0, Short.MAX_VALUE)
  455.                 .addComponent(jLabel15)
  456.                 .addGap(689, 689, 689))
  457.             .addGroup(layout.createSequentialGroup()
  458.                 .addGap(47, 47, 47)
  459.                 .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  460.                     .addGroup(layout.createSequentialGroup()
  461.                         .addGap(11, 11, 11)
  462.                         .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING)
  463.                             .addComponent(jScrollPane2, javax.swing.GroupLayout.PREFERRED_SIZE, 638, javax.swing.GroupLayout.PREFERRED_SIZE)
  464.                             .addGroup(layout.createSequentialGroup()
  465.                                 .addComponent(jPanel2, javax.swing.GroupLayout.PREFERRED_SIZE, 306, javax.swing.GroupLayout.PREFERRED_SIZE)
  466.                                 .addGap(28, 28, 28)
  467.                                 .addComponent(jPanel3, javax.swing.GroupLayout.PREFERRED_SIZE, 298, javax.swing.GroupLayout.PREFERRED_SIZE))
  468.                             .addComponent(jPanel5, javax.swing.GroupLayout.PREFERRED_SIZE, 638, javax.swing.GroupLayout.PREFERRED_SIZE)
  469.                             .addComponent(jPanel6, javax.swing.GroupLayout.PREFERRED_SIZE, 638, javax.swing.GroupLayout.PREFERRED_SIZE)
  470.                             .addComponent(jScrollPane1, javax.swing.GroupLayout.PREFERRED_SIZE, 638, javax.swing.GroupLayout.PREFERRED_SIZE))
  471.                         .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
  472.                         .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  473.                             .addGroup(javax.swing.GroupLayout.Alignment.TRAILING, layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  474.                                 .addComponent(btndeleterowrevenue, javax.swing.GroupLayout.PREFERRED_SIZE, 134, javax.swing.GroupLayout.PREFERRED_SIZE)
  475.                                 .addComponent(btnaddrowrevenue, javax.swing.GroupLayout.PREFERRED_SIZE, 134, javax.swing.GroupLayout.PREFERRED_SIZE))
  476.                             .addComponent(btnaddsalesrow, javax.swing.GroupLayout.Alignment.TRAILING, javax.swing.GroupLayout.PREFERRED_SIZE, 140, javax.swing.GroupLayout.PREFERRED_SIZE)
  477.                             .addComponent(jButton5, javax.swing.GroupLayout.Alignment.TRAILING, javax.swing.GroupLayout.PREFERRED_SIZE, 140, javax.swing.GroupLayout.PREFERRED_SIZE))
  478.                         .addContainerGap(22, Short.MAX_VALUE))
  479.                     .addGroup(layout.createSequentialGroup()
  480.                         .addComponent(jLabel32, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
  481.                         .addGap(0, 0, Short.MAX_VALUE))))
  482.         );
  483.         layout.setVerticalGroup(
  484.             layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  485.             .addGroup(layout.createSequentialGroup()
  486.                 .addGap(28, 28, 28)
  487.                 .addComponent(jLabel32, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
  488.                 .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
  489.                 .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING, false)
  490.                     .addComponent(jPanel3, javax.swing.GroupLayout.DEFAULT_SIZE, 154, Short.MAX_VALUE)
  491.                     .addComponent(jPanel2, javax.swing.GroupLayout.DEFAULT_SIZE, 154, Short.MAX_VALUE))
  492.                 .addGap(18, 18, 18)
  493.                 .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  494.                     .addGroup(layout.createSequentialGroup()
  495.                         .addComponent(btnaddrowrevenue)
  496.                         .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
  497.                         .addComponent(btndeleterowrevenue))
  498.                     .addComponent(jScrollPane1, javax.swing.GroupLayout.PREFERRED_SIZE, 75, javax.swing.GroupLayout.PREFERRED_SIZE))
  499.                 .addGap(65, 65, 65)
  500.                 .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  501.                     .addGroup(layout.createSequentialGroup()
  502.                         .addComponent(jScrollPane2, javax.swing.GroupLayout.PREFERRED_SIZE, 79, javax.swing.GroupLayout.PREFERRED_SIZE)
  503.                         .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, 45, Short.MAX_VALUE)
  504.                         .addComponent(jPanel5, javax.swing.GroupLayout.PREFERRED_SIZE, 104, javax.swing.GroupLayout.PREFERRED_SIZE)
  505.                         .addGap(31, 31, 31)
  506.                         .addComponent(jPanel6, javax.swing.GroupLayout.PREFERRED_SIZE, 65, javax.swing.GroupLayout.PREFERRED_SIZE)
  507.                         .addGap(184, 184, 184)
  508.                         .addComponent(jLabel15, javax.swing.GroupLayout.PREFERRED_SIZE, 0, javax.swing.GroupLayout.PREFERRED_SIZE)
  509.                         .addGap(128, 128, 128))
  510.                     .addGroup(layout.createSequentialGroup()
  511.                         .addComponent(btnaddsalesrow)
  512.                         .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
  513.                         .addComponent(jButton5)
  514.                         .addContainerGap(javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))))
  515.         );
  516.  
  517.         pack();
  518.     }// </editor-fold>                        
  519.  
  520.     private void btnsaveActionPerformed(java.awt.event.ActionEvent evt) {                                        
  521.  
  522.         // Connect to the database
  523.     Connection conn;
  524.           String userdb="root";
  525.           String pass="King@123";
  526.  
  527.                  //  String selectedSupplier = (String)cbosupplier.getSelectedItem();
  528.                    String selectedClient =(String)cboclients.getSelectedItem();
  529.                   // int idclient = selectedClient.getId();
  530.                    String cboprobalitydb = (String)cboprobability.getSelectedItem();
  531.                    String txtAtt = txtattention.getText();
  532.                    String txtDescr    = txtclientdescription.getText();
  533.                    String codeuser = "1000";
  534.                    String cpsostypedb = (String) cbocpsotype.getSelectedItem();
  535.                    java.util.Date invoicedate = txtdatechooser.getDate();            
  536.                    //date_of_invoice      
  537.      try {  
  538.          
  539.          
  540.           String url ="jdbc:mysql://localhost/dbtec";          
  541.          
  542.      Class.forName("com.mysql.jdbc.Driver");
  543.      conn = DriverManager.getConnection(url,userdb,pass);
  544.              
  545.          PreparedStatement statement = (PreparedStatement) conn.prepareStatement(" INSERT INTO tblcposo(client_id,cposo_type,usercode,probability,attension,description,date_of_invoice) VALUES(?,?,?,?,?,?,?)", Statement.RETURN_GENERATED_KEYS);
  546.          statement.setString(1,"7");
  547.          statement.setString(2,cpsostypedb);
  548.          statement.setString(3,"1000");
  549.         statement.setString(4,cboprobalitydb);
  550.         statement.setString(5,txtAtt);
  551.          statement.setString(6,txtDescr);
  552.          statement.setString(7,((JTextField) txtdatechooser.getDateEditor().getUiComponent()).getText());
  553.        //  statement.setString(5,txtDescr);
  554.        
  555.  
  556. ////////////No delete
  557.          statement.executeUpdate();
  558.          
  559.          
  560.          /// get key
  561.          ResultSet keys = statement.getGeneratedKeys();    
  562. keys.next();
  563. int last_id = keys.getInt(1);
  564.          JOptionPane.showMessageDialog(null, last_id);
  565.  
  566.  
  567.          // get  key
  568.                   statement.close();
  569.  
  570.          
  571.          /// Insert into another tblcost_of_sell table
  572.          int costrows = tblsales.getRowCount();
  573.          
  574.          String  statementSell= ("INSERT  INTO tblcost_of_sell(client_id,divisiuon,usercode,suppliername,cost_of_account,quote_ref,invoice_ref,price,description) VALUES (?,?,?,?,?,?,?,?,?) ");
  575.          
  576.          PreparedStatement  statement2 = conn.prepareStatement(statementSell);
  577.          
  578.          for(int indexsales = 0 ; indexsales < costrows;indexsales++){
  579.          String tbldivisiuon= (String)tblsales.getValueAt(indexsales, 0);
  580.          String tblcost_of_account = (String)tblsales.getValueAt(indexsales, 1);
  581.          String suppliername = (String)tblsales.getValueAt(indexsales, 2);
  582.          String tbldescription = (String)tblsales.getValueAt(indexsales, 3);
  583.          String tblquote_ref = (String)tblsales.getValueAt(indexsales, 4);
  584.          String tblprice = (String)tblsales.getValueAt(indexsales, 5);
  585. //////////////////////////////////////////////////////////////////
  586.          
  587.          statement2.setString(1,"7");
  588.          statement2.setString(2,tbldivisiuon);
  589.         // statement2.setString(3, Integer.toString(last_id)); //forein key
  590.           statement2.setString(3,"1000");
  591.          statement2.setString(4,suppliername);
  592.            statement2.setString(5,tblcost_of_account);
  593.            statement2.setString(6,tblquote_ref);
  594.            statement2.setString(7,"Wedelete");
  595.            statement2.setString(8,tblprice);
  596.            statement2.setString(9,tbldescription);
  597.  
  598. statement2.executeUpdate();
  599. statement2.addBatch();
  600.  
  601.          }
  602. statement2.executeBatch();
  603. statement2.close();
  604.          // insert into tblcost_of_sell ends here
  605.              DefaultTableModel model = (DefaultTableModel)tblrevenue1.getModel();
  606.              
  607.  
  608.                   int rowsRevenue = tblrevenue1.getRowCount();
  609.  
  610. String  StatementRev = ("INSERT   INTO  tblrevenue(client_id , divisiuon,usercode,rev_account,qunatity,unit_price,total_price,description)VALUES(?,?,?,?,?,?,?,?)");
  611. PreparedStatement     Statement3 = conn.prepareStatement(StatementRev);
  612. for(int i= 0; i< rowsRevenue; i++){
  613.    // tblrevenue.removeRow(this);
  614.                   String itdivisiuon = (String)tblrevenue1.getValueAt(i, 0);
  615.                   String itrev_account  = (String)tblrevenue1.getValueAt(i, 1);
  616.                   String  itdescription = (String)tblrevenue1.getValueAt(i, 2);
  617.                   String   itqunatity = (String)tblrevenue1.getValueAt(i, 3);
  618.                   String  itunit_price  = (String)tblrevenue1.getValueAt(i, 4);
  619.                   String   ittotal_price  = (String)tblrevenue1.getValueAt(i, 5);
  620.                
  621.                   ///Start Count
  622.                  
  623.                   /// This  ends the count
  624.                        
  625. //Insert into the Third table
  626. Statement3.setString(1,"7");
  627. Statement3.setString(2,itdivisiuon);
  628. Statement3.setString(3,"1000");
  629. //Statement3.setString(4, Integer.toString(last_id)); //forein key
  630. Statement3.setString(4,itrev_account);
  631. Statement3.setString(5,itqunatity);
  632. Statement3.setString(6,itunit_price);
  633. Statement3.setString(7,ittotal_price);
  634. Statement3.setString(8,itdescription);
  635.  
  636.  
  637. Statement3.executeUpdate();
  638. Statement3.addBatch();
  639.                  
  640.                   }
  641. Statement3.executeBatch();
  642. Statement3.close();
  643.  
  644. //Bound array
  645.  
  646.                   conn.close();  
  647.      
  648.      }
  649.      catch(SQLException e){
  650.          e.printStackTrace();
  651.          
  652.      }  catch (ClassNotFoundException ex) {
  653.             Logger.getLogger(newclient.class.getName()).log(Level.SEVERE, null, ex);
  654.         }
  655.      //JOptionPane.showMessageDialog(null, cposo1);
  656.      ///////end
  657.  
  658.         // TODO add your handling code here:
  659.     }                                      
  660.  
  661.     private void jButton3ActionPerformed(java.awt.event.ActionEvent evt) {                                        
  662.  
  663. // Do Clculatiosn
  664.  
  665. double total =0;
  666. for (int index = 0 ; index<tblrevenue1.getRowCount(); index++){
  667.     int amount = Integer.parseInt((String)tblrevenue1.getValueAt(index,5));
  668.   total +=amount;
  669. }
  670. txttotalsum.setText(String.valueOf(total));
  671. try{ String update ="";
  672. }catch(Exception e){
  673.    
  674. }
  675. // will transfar cods
  676.        
  677.     }                                        
  678.  
  679.     private void btndeleterowrevenueActionPerformed(java.awt.event.ActionEvent evt) {                                                    
  680.         // Delete row for revenue table
  681.         DefaultTableModel model = (DefaultTableModel) tblrevenue1.getModel();
  682.         try{
  683.         int SelectedRowIndex = tblrevenue1.getSelectedRow();
  684.         if(SelectedRowIndex == -1 ){
  685.             JOptionPane.showMessageDialog(null, "Please Select a row to delele");
  686.            
  687.         }
  688.        
  689.         model.removeRow(SelectedRowIndex);
  690.         }catch (Exception ex){
  691.            // JOptionPane.showMessageDialog(null, ex);
  692.            
  693.         }
  694.         //nd your delete
  695.     }                                                  
  696.  
  697.     private void jButton5ActionPerformed(java.awt.event.ActionEvent evt) {                                        
  698. // Delete row for revenue table
  699.         DefaultTableModel model2 = (DefaultTableModel) tblsales.getModel();
  700.         try{
  701.         int SelectedRowIndex1 = tblsales.getSelectedRow();
  702.         if(SelectedRowIndex1 == -1 ){
  703.             JOptionPane.showMessageDialog(null, "Please Select a row to delele");
  704.            
  705.         }
  706.         model2.removeRow(SelectedRowIndex1);
  707.         }catch (Exception ex){
  708.             //JOptionPane.showMessageDialog(null, ex);
  709.            
  710.         }
  711.         //nd your delete         // TODO add your handling code here:
  712.     }                                        
  713.  
  714.     private void btnaddrowrevenueActionPerformed(java.awt.event.ActionEvent evt) {                                                
  715.         // TODO add your handling code here:
  716.        
  717.        
  718.         // Add row row for revenue table
  719.         DefaultTableModel modeladd = (DefaultTableModel) tblrevenue1.getModel();
  720.         try{
  721.         modeladd.addRow(new Object[]{});
  722.         }
  723.         catch(Exception exaddpr){
  724.             JOptionPane.showConfirmDialog(null, exaddpr);
  725.         }
  726.      
  727.         //nd your delete         //
  728.     }                                                
  729.  
  730.     private void btnaddsalesrowActionPerformed(java.awt.event.ActionEvent evt) {                                              
  731.   // Add row row for revenue table
  732.         DefaultTableModel modeladdsalesrow = (DefaultTableModel) tblsales.getModel();
  733.         try{
  734.         modeladdsalesrow.addRow(new Object[]{});
  735.         }
  736.         catch(Exception exaddpr){
  737.             JOptionPane.showConfirmDialog(null, exaddpr);
  738.         }
  739.      
  740.         //nd your add         //        // TODO add your handling code here:
  741.     }                                              
  742.  
  743.     /**
  744.      * @param args the command line arguments
  745.      */
  746.     public static void main(String args[]) throws ClassNotFoundException {
  747.      
  748.      /////////combo
  749.      
  750.             java.net.InetAddress localMachine = null;
  751.         try {
  752.             localMachine = java.net.InetAddress.getLocalHost();
  753.         } catch (UnknownHostException ex) {
  754.             Logger.getLogger(newclient.class.getName()).log(Level.SEVERE, null, ex);
  755.         }
  756. System.out.println("Hostname of local machine: " + localMachine.getHostName());
  757.    
  758.      ////////
  759.      
  760.         try {
  761.             for (javax.swing.UIManager.LookAndFeelInfo info : javax.swing.UIManager.getInstalledLookAndFeels()) {
  762.                 if ("Nimbus".equals(info.getName())) {
  763.                     javax.swing.UIManager.setLookAndFeel(info.getClassName());
  764.                     break;
  765.                 }
  766.             }
  767.         } catch (ClassNotFoundException ex) {
  768.             java.util.logging.Logger.getLogger(newclient.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
  769.         } catch (InstantiationException ex) {
  770.             java.util.logging.Logger.getLogger(newclient.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
  771.         } catch (IllegalAccessException ex) {
  772.             java.util.logging.Logger.getLogger(newclient.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
  773.         } catch (javax.swing.UnsupportedLookAndFeelException ex) {
  774.             java.util.logging.Logger.getLogger(newclient.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
  775.         }
  776.         //</editor-fold>
  777.  
  778.         /* Create and display the form */
  779.         java.awt.EventQueue.invokeLater(new Runnable() {
  780.             public void run() {
  781.                 new newclient().setVisible(true);
  782.             }
  783.         });
  784.     }
  785.  
  786.     // Variables declaration - do not modify                    
  787.     private javax.swing.JButton btnaddrowrevenue;
  788.     private javax.swing.JButton btnaddsalesrow;
  789.     private javax.swing.JButton btndeleterowrevenue;
  790.     private javax.swing.JButton btnsave;
  791.     private javax.swing.JComboBox<String> cbocas;
  792.     private javax.swing.JComboBox<String> cboclients;
  793.     private javax.swing.JComboBox<String> cbocpsotype;
  794.     private javax.swing.JComboBox<String> cbods;
  795.     private javax.swing.JComboBox<String> cboprobability;
  796.     private javax.swing.JComboBox<String> cbosalesperson;
  797.     private javax.swing.JButton jButton2;
  798.     private javax.swing.JButton jButton3;
  799.     private javax.swing.JButton jButton5;
  800.     private com.jcalendar.model.JCalModel jCalModel1;
  801.     private com.jcalendar.model.JCalModel jCalModel2;
  802.     private javax.swing.JLabel jLabel10;
  803.     private javax.swing.JLabel jLabel13;
  804.     private javax.swing.JLabel jLabel15;
  805.     private javax.swing.JLabel jLabel19;
  806.     private javax.swing.JLabel jLabel2;
  807.     private javax.swing.JLabel jLabel20;
  808.     private javax.swing.JLabel jLabel21;
  809.     private javax.swing.JLabel jLabel29;
  810.     private javax.swing.JLabel jLabel3;
  811.     private javax.swing.JLabel jLabel30;
  812.     private javax.swing.JLabel jLabel31;
  813.     private javax.swing.JLabel jLabel32;
  814.     private javax.swing.JLabel jLabel7;
  815.     private javax.swing.JLabel jLabel8;
  816.     private javax.swing.JPanel jPanel2;
  817.     private javax.swing.JPanel jPanel3;
  818.     private javax.swing.JPanel jPanel5;
  819.     private javax.swing.JPanel jPanel6;
  820.     private javax.swing.JScrollPane jScrollPane1;
  821.     private javax.swing.JScrollPane jScrollPane2;
  822.     private javax.swing.JTextField jTextField1;
  823.     private javax.swing.JTextField jTextField45;
  824.     private javax.swing.JTextField jTextField46;
  825.     private javax.swing.JTable tblrevenue1;
  826.     private javax.swing.JTable tblsales;
  827.     private javax.swing.JTextField txtattention;
  828.     private javax.swing.JTextField txtbranchdev;
  829.     private javax.swing.JTextField txtclientdescription;
  830.     private javax.swing.JTextField txtclientpo;
  831.     private com.toedter.calendar.JDateChooser txtdatechooser;
  832.     private javax.swing.JTextField txttotalsum;
  833.     // End of variables declaration                  
  834. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!