Dinesh_Raja

HomeJFrame.java

Feb 1st, 2014
129
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Java 17.01 KB | None | 0 0
  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 itb;
  7.  
  8. import java.sql.*;
  9.  
  10. /**
  11.  *
  12.  * @author dinesh
  13.  */
  14. public class HomeJFrame extends javax.swing.JFrame {
  15.  
  16.     /**
  17.      * Creates new form HomeJFrame
  18.      */
  19.     public HomeJFrame() {
  20.         initComponents();
  21.     }
  22.  
  23.    
  24.  
  25.     /**
  26.      * This method is called from within the constructor to initialize the form.
  27.      * WARNING: Do NOT modify this code. The content of this method is always
  28.      * regenerated by the Form Editor.
  29.      */
  30.     @SuppressWarnings("unchecked")
  31.     // <editor-fold defaultstate="collapsed" desc="Generated Code">                          
  32.     private void initComponents() {
  33.         bindingGroup = new org.jdesktop.beansbinding.BindingGroup();
  34.  
  35.         entityManager = java.beans.Beans.isDesignTime() ? null : javax.persistence.Persistence.createEntityManagerFactory("itbd?zeroDateTimeBehavior=convertToNullPU").createEntityManager();
  36.         customersQuery = java.beans.Beans.isDesignTime() ? null : entityManager.createQuery("SELECT c FROM Customers c");
  37.         customersList = java.beans.Beans.isDesignTime() ? java.util.Collections.emptyList() : customersQuery.getResultList();
  38.         customersQuery1 = java.beans.Beans.isDesignTime() ? null : entityManager.createQuery("SELECT c FROM Customers c");
  39.         customersList1 = java.beans.Beans.isDesignTime() ? java.util.Collections.emptyList() : customersQuery1.getResultList();
  40.         itemlistQuery = java.beans.Beans.isDesignTime() ? null : entityManager.createQuery("SELECT i FROM Itemlist i");
  41.         itemlistList = java.beans.Beans.isDesignTime() ? java.util.Collections.emptyList() : itemlistQuery.getResultList();
  42.         customersQuery2 = java.beans.Beans.isDesignTime() ? null : entityManager.createQuery("SELECT c FROM Customers c");
  43.         customersList2 = java.beans.Beans.isDesignTime() ? java.util.Collections.emptyList() : customersQuery2.getResultList();
  44.         jTabbedPane1 = new javax.swing.JTabbedPane();
  45.         jLayeredPane1 = new javax.swing.JLayeredPane();
  46.         jPanel1 = new javax.swing.JPanel();
  47.         jScrollPane1 = new javax.swing.JScrollPane();
  48.         jTable1 = new javax.swing.JTable();
  49.         jButton1 = new javax.swing.JButton();
  50.         jLabel1 = new javax.swing.JLabel();
  51.         jTextField1 = new javax.swing.JTextField();
  52.         jLayeredPane2 = new javax.swing.JLayeredPane();
  53.         jPanel2 = new javax.swing.JPanel();
  54.         jScrollPane2 = new javax.swing.JScrollPane();
  55.         jTable2 = new javax.swing.JTable();
  56.         jLayeredPane3 = new javax.swing.JLayeredPane();
  57.         jLayeredPane4 = new javax.swing.JLayeredPane();
  58.  
  59.         setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE);
  60.  
  61.         org.jdesktop.swingbinding.JTableBinding jTableBinding = org.jdesktop.swingbinding.SwingBindings.createJTableBinding(org.jdesktop.beansbinding.AutoBinding.UpdateStrategy.READ_WRITE, customersList2, jTable1);
  62.         org.jdesktop.swingbinding.JTableBinding.ColumnBinding columnBinding = jTableBinding.addColumnBinding(org.jdesktop.beansbinding.ELProperty.create("${id}"));
  63.         columnBinding.setColumnName("Id");
  64.         columnBinding.setColumnClass(Integer.class);
  65.         columnBinding = jTableBinding.addColumnBinding(org.jdesktop.beansbinding.ELProperty.create("${name}"));
  66.         columnBinding.setColumnName("Name");
  67.         columnBinding.setColumnClass(String.class);
  68.         bindingGroup.addBinding(jTableBinding);
  69.  
  70.         jTable1.addContainerListener(new java.awt.event.ContainerAdapter() {
  71.             public void componentAdded(java.awt.event.ContainerEvent evt) {
  72.                 jTable1ComponentAdded(evt);
  73.             }
  74.         });
  75.         jScrollPane1.setViewportView(jTable1);
  76.  
  77.         jButton1.setText("Add Customer");
  78.         jButton1.addActionListener(new java.awt.event.ActionListener() {
  79.             public void actionPerformed(java.awt.event.ActionEvent evt) {
  80.                 jButton1ActionPerformed(evt);
  81.             }
  82.         });
  83.  
  84.         jLabel1.setText("Customer Name:");
  85.  
  86.         javax.swing.GroupLayout jPanel1Layout = new javax.swing.GroupLayout(jPanel1);
  87.         jPanel1.setLayout(jPanel1Layout);
  88.         jPanel1Layout.setHorizontalGroup(
  89.             jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  90.             .addGroup(jPanel1Layout.createSequentialGroup()
  91.                 .addContainerGap()
  92.                 .addComponent(jScrollPane1, javax.swing.GroupLayout.PREFERRED_SIZE, 232, javax.swing.GroupLayout.PREFERRED_SIZE)
  93.                 .addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  94.                     .addGroup(jPanel1Layout.createSequentialGroup()
  95.                         .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, 100, Short.MAX_VALUE)
  96.                         .addComponent(jButton1)
  97.                         .addGap(33, 33, 33))
  98.                     .addGroup(jPanel1Layout.createSequentialGroup()
  99.                         .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
  100.                         .addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  101.                             .addComponent(jTextField1)
  102.                             .addGroup(jPanel1Layout.createSequentialGroup()
  103.                                 .addComponent(jLabel1)
  104.                                 .addGap(0, 0, Short.MAX_VALUE)))
  105.                         .addContainerGap())))
  106.         );
  107.         jPanel1Layout.setVerticalGroup(
  108.             jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  109.             .addGroup(jPanel1Layout.createSequentialGroup()
  110.                 .addContainerGap()
  111.                 .addComponent(jScrollPane1, javax.swing.GroupLayout.PREFERRED_SIZE, 181, javax.swing.GroupLayout.PREFERRED_SIZE)
  112.                 .addContainerGap(97, Short.MAX_VALUE))
  113.             .addGroup(javax.swing.GroupLayout.Alignment.TRAILING, jPanel1Layout.createSequentialGroup()
  114.                 .addGap(36, 36, 36)
  115.                 .addComponent(jLabel1, javax.swing.GroupLayout.PREFERRED_SIZE, 39, javax.swing.GroupLayout.PREFERRED_SIZE)
  116.                 .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
  117.                 .addComponent(jTextField1, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
  118.                 .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
  119.                 .addComponent(jButton1)
  120.                 .addGap(52, 52, 52))
  121.         );
  122.  
  123.         javax.swing.GroupLayout jLayeredPane1Layout = new javax.swing.GroupLayout(jLayeredPane1);
  124.         jLayeredPane1.setLayout(jLayeredPane1Layout);
  125.         jLayeredPane1Layout.setHorizontalGroup(
  126.             jLayeredPane1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  127.             .addGroup(jLayeredPane1Layout.createSequentialGroup()
  128.                 .addContainerGap()
  129.                 .addComponent(jPanel1, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
  130.                 .addContainerGap())
  131.         );
  132.         jLayeredPane1Layout.setVerticalGroup(
  133.             jLayeredPane1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  134.             .addGroup(jLayeredPane1Layout.createSequentialGroup()
  135.                 .addContainerGap()
  136.                 .addComponent(jPanel1, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
  137.                 .addContainerGap())
  138.         );
  139.         jLayeredPane1.setLayer(jPanel1, javax.swing.JLayeredPane.DEFAULT_LAYER);
  140.  
  141.         jTabbedPane1.addTab("Customers Info", jLayeredPane1);
  142.  
  143.         jTableBinding = org.jdesktop.swingbinding.SwingBindings.createJTableBinding(org.jdesktop.beansbinding.AutoBinding.UpdateStrategy.READ_WRITE, itemlistList, jTable2);
  144.         columnBinding = jTableBinding.addColumnBinding(org.jdesktop.beansbinding.ELProperty.create("${id}"));
  145.         columnBinding.setColumnName("Id");
  146.         columnBinding.setColumnClass(Integer.class);
  147.         columnBinding = jTableBinding.addColumnBinding(org.jdesktop.beansbinding.ELProperty.create("${productName}"));
  148.         columnBinding.setColumnName("Product Name");
  149.         columnBinding.setColumnClass(String.class);
  150.         columnBinding = jTableBinding.addColumnBinding(org.jdesktop.beansbinding.ELProperty.create("${ppp}"));
  151.         columnBinding.setColumnName("Ppp");
  152.         columnBinding.setColumnClass(Integer.class);
  153.         columnBinding = jTableBinding.addColumnBinding(org.jdesktop.beansbinding.ELProperty.create("${price}"));
  154.         columnBinding.setColumnName("Price");
  155.         columnBinding.setColumnClass(Integer.class);
  156.         bindingGroup.addBinding(jTableBinding);
  157.  
  158.         jScrollPane2.setViewportView(jTable2);
  159.  
  160.         javax.swing.GroupLayout jPanel2Layout = new javax.swing.GroupLayout(jPanel2);
  161.         jPanel2.setLayout(jPanel2Layout);
  162.         jPanel2Layout.setHorizontalGroup(
  163.             jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  164.             .addGroup(javax.swing.GroupLayout.Alignment.TRAILING, jPanel2Layout.createSequentialGroup()
  165.                 .addContainerGap(15, Short.MAX_VALUE)
  166.                 .addComponent(jScrollPane2, javax.swing.GroupLayout.PREFERRED_SIZE, 452, javax.swing.GroupLayout.PREFERRED_SIZE)
  167.                 .addContainerGap())
  168.         );
  169.         jPanel2Layout.setVerticalGroup(
  170.             jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  171.             .addGroup(javax.swing.GroupLayout.Alignment.TRAILING, jPanel2Layout.createSequentialGroup()
  172.                 .addContainerGap(javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
  173.                 .addComponent(jScrollPane2, javax.swing.GroupLayout.PREFERRED_SIZE, 275, javax.swing.GroupLayout.PREFERRED_SIZE)
  174.                 .addContainerGap())
  175.         );
  176.  
  177.         javax.swing.GroupLayout jLayeredPane2Layout = new javax.swing.GroupLayout(jLayeredPane2);
  178.         jLayeredPane2.setLayout(jLayeredPane2Layout);
  179.         jLayeredPane2Layout.setHorizontalGroup(
  180.             jLayeredPane2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  181.             .addGroup(javax.swing.GroupLayout.Alignment.TRAILING, jLayeredPane2Layout.createSequentialGroup()
  182.                 .addContainerGap()
  183.                 .addComponent(jPanel2, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
  184.                 .addContainerGap())
  185.         );
  186.         jLayeredPane2Layout.setVerticalGroup(
  187.             jLayeredPane2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  188.             .addGroup(jLayeredPane2Layout.createSequentialGroup()
  189.                 .addContainerGap()
  190.                 .addComponent(jPanel2, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
  191.                 .addContainerGap())
  192.         );
  193.         jLayeredPane2.setLayer(jPanel2, javax.swing.JLayeredPane.DEFAULT_LAYER);
  194.  
  195.         jTabbedPane1.addTab("Item List", jLayeredPane2);
  196.  
  197.         javax.swing.GroupLayout jLayeredPane3Layout = new javax.swing.GroupLayout(jLayeredPane3);
  198.         jLayeredPane3.setLayout(jLayeredPane3Layout);
  199.         jLayeredPane3Layout.setHorizontalGroup(
  200.             jLayeredPane3Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  201.             .addGap(0, 503, Short.MAX_VALUE)
  202.         );
  203.         jLayeredPane3Layout.setVerticalGroup(
  204.             jLayeredPane3Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  205.             .addGap(0, 314, Short.MAX_VALUE)
  206.         );
  207.  
  208.         jTabbedPane1.addTab("Bill", jLayeredPane3);
  209.  
  210.         javax.swing.GroupLayout jLayeredPane4Layout = new javax.swing.GroupLayout(jLayeredPane4);
  211.         jLayeredPane4.setLayout(jLayeredPane4Layout);
  212.         jLayeredPane4Layout.setHorizontalGroup(
  213.             jLayeredPane4Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  214.             .addGap(0, 503, Short.MAX_VALUE)
  215.         );
  216.         jLayeredPane4Layout.setVerticalGroup(
  217.             jLayeredPane4Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  218.             .addGap(0, 314, Short.MAX_VALUE)
  219.         );
  220.  
  221.         jTabbedPane1.addTab("Stock", jLayeredPane4);
  222.  
  223.         javax.swing.GroupLayout layout = new javax.swing.GroupLayout(getContentPane());
  224.         getContentPane().setLayout(layout);
  225.         layout.setHorizontalGroup(
  226.             layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  227.             .addGroup(layout.createSequentialGroup()
  228.                 .addContainerGap()
  229.                 .addComponent(jTabbedPane1)
  230.                 .addContainerGap())
  231.         );
  232.         layout.setVerticalGroup(
  233.             layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  234.             .addGroup(layout.createSequentialGroup()
  235.                 .addContainerGap()
  236.                 .addComponent(jTabbedPane1, javax.swing.GroupLayout.PREFERRED_SIZE, 349, javax.swing.GroupLayout.PREFERRED_SIZE)
  237.                 .addContainerGap(21, Short.MAX_VALUE))
  238.         );
  239.  
  240.         bindingGroup.bind();
  241.  
  242.         pack();
  243.     }// </editor-fold>                        
  244.  
  245.     private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {                                        
  246.         // TODO add your handling code here:
  247.         String cust_name = jTextField1.getText();
  248.         try {
  249.             Connection con;
  250.             Class.forName("com.mysql.jdbc.Driver");
  251.             con = DriverManager.getConnection("jdbc:mysql://localhost:3306/itbd?zeroDateTimeBehavior=convertToNull", "root", "root");
  252.             PreparedStatement ps = con.prepareStatement("Insert into customers values(default,?)");
  253.             ps.setString(1, cust_name);
  254.             ps.executeUpdate();
  255.             jTable1.addAncestorListener(null);
  256.             con.close();
  257.  
  258.         } catch (ClassNotFoundException | SQLException e) {
  259.             System.out.println("ERROR  " + e);
  260.         }
  261.     }                                        
  262.  
  263.     private void jTable1ComponentAdded(java.awt.event.ContainerEvent evt) {                                      
  264.         // TODO add your handling code here:
  265.     }                                      
  266.  
  267.     /**
  268.      * @param args the command line arguments
  269.      */
  270.     public static void main(String args[]) {
  271.         /* Set the Nimbus look and feel */
  272.         //<editor-fold defaultstate="collapsed" desc=" Look and feel setting code (optional) ">
  273.         /* If Nimbus (introduced in Java SE 6) is not available, stay with the default look and feel.
  274.          * For details see http://download.oracle.com/javase/tutorial/uiswing/lookandfeel/plaf.html
  275.          */
  276.         try {
  277.             for (javax.swing.UIManager.LookAndFeelInfo info : javax.swing.UIManager.getInstalledLookAndFeels()) {
  278.                 if ("Nimbus".equals(info.getName())) {
  279.                     javax.swing.UIManager.setLookAndFeel(info.getClassName());
  280.                     break;
  281.                 }
  282.             }
  283.         } catch (ClassNotFoundException | InstantiationException | IllegalAccessException | javax.swing.UnsupportedLookAndFeelException ex) {
  284.             java.util.logging.Logger.getLogger(HomeJFrame.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
  285.         }
  286.         //</editor-fold>
  287.  
  288.         /* Create and display the form */
  289.         java.awt.EventQueue.invokeLater(new Runnable() {
  290.             @Override
  291.             public void run() {
  292.                 new HomeJFrame().setVisible(true);
  293.             }
  294.         });
  295.     }
  296.  
  297.     // Variables declaration - do not modify                    
  298.     private java.util.List<itb.Customers> customersList;
  299.     private java.util.List<itb.Customers> customersList1;
  300.     private java.util.List<itb.Customers> customersList2;
  301.     private javax.persistence.Query customersQuery;
  302.     private javax.persistence.Query customersQuery1;
  303.     private javax.persistence.Query customersQuery2;
  304.     private javax.persistence.EntityManager entityManager;
  305.     private java.util.List<itb.Itemlist> itemlistList;
  306.     private javax.persistence.Query itemlistQuery;
  307.     private javax.swing.JButton jButton1;
  308.     private javax.swing.JLabel jLabel1;
  309.     private javax.swing.JLayeredPane jLayeredPane1;
  310.     private javax.swing.JLayeredPane jLayeredPane2;
  311.     private javax.swing.JLayeredPane jLayeredPane3;
  312.     private javax.swing.JLayeredPane jLayeredPane4;
  313.     private javax.swing.JPanel jPanel1;
  314.     private javax.swing.JPanel jPanel2;
  315.     private javax.swing.JScrollPane jScrollPane1;
  316.     private javax.swing.JScrollPane jScrollPane2;
  317.     private javax.swing.JTabbedPane jTabbedPane1;
  318.     private javax.swing.JTable jTable1;
  319.     private javax.swing.JTable jTable2;
  320.     private javax.swing.JTextField jTextField1;
  321.     private org.jdesktop.beansbinding.BindingGroup bindingGroup;
  322.     // End of variables declaration                  
  323. }
Advertisement
Add Comment
Please, Sign In to add comment