Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- /*
- * 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 itb;
- import java.sql.*;
- /**
- *
- * @author dinesh
- */
- public class HomeJFrame extends javax.swing.JFrame {
- /**
- * Creates new form HomeJFrame
- */
- public HomeJFrame() {
- initComponents();
- }
- /**
- * 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() {
- bindingGroup = new org.jdesktop.beansbinding.BindingGroup();
- entityManager = java.beans.Beans.isDesignTime() ? null : javax.persistence.Persistence.createEntityManagerFactory("itbd?zeroDateTimeBehavior=convertToNullPU").createEntityManager();
- customersQuery = java.beans.Beans.isDesignTime() ? null : entityManager.createQuery("SELECT c FROM Customers c");
- customersList = java.beans.Beans.isDesignTime() ? java.util.Collections.emptyList() : customersQuery.getResultList();
- customersQuery1 = java.beans.Beans.isDesignTime() ? null : entityManager.createQuery("SELECT c FROM Customers c");
- customersList1 = java.beans.Beans.isDesignTime() ? java.util.Collections.emptyList() : customersQuery1.getResultList();
- itemlistQuery = java.beans.Beans.isDesignTime() ? null : entityManager.createQuery("SELECT i FROM Itemlist i");
- itemlistList = java.beans.Beans.isDesignTime() ? java.util.Collections.emptyList() : itemlistQuery.getResultList();
- customersQuery2 = java.beans.Beans.isDesignTime() ? null : entityManager.createQuery("SELECT c FROM Customers c");
- customersList2 = java.beans.Beans.isDesignTime() ? java.util.Collections.emptyList() : customersQuery2.getResultList();
- jTabbedPane1 = new javax.swing.JTabbedPane();
- jLayeredPane1 = new javax.swing.JLayeredPane();
- jPanel1 = new javax.swing.JPanel();
- jScrollPane1 = new javax.swing.JScrollPane();
- jTable1 = new javax.swing.JTable();
- jButton1 = new javax.swing.JButton();
- jLabel1 = new javax.swing.JLabel();
- jTextField1 = new javax.swing.JTextField();
- jLayeredPane2 = new javax.swing.JLayeredPane();
- jPanel2 = new javax.swing.JPanel();
- jScrollPane2 = new javax.swing.JScrollPane();
- jTable2 = new javax.swing.JTable();
- jLayeredPane3 = new javax.swing.JLayeredPane();
- jLayeredPane4 = new javax.swing.JLayeredPane();
- setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE);
- org.jdesktop.swingbinding.JTableBinding jTableBinding = org.jdesktop.swingbinding.SwingBindings.createJTableBinding(org.jdesktop.beansbinding.AutoBinding.UpdateStrategy.READ_WRITE, customersList2, jTable1);
- org.jdesktop.swingbinding.JTableBinding.ColumnBinding columnBinding = jTableBinding.addColumnBinding(org.jdesktop.beansbinding.ELProperty.create("${id}"));
- columnBinding.setColumnName("Id");
- columnBinding.setColumnClass(Integer.class);
- columnBinding = jTableBinding.addColumnBinding(org.jdesktop.beansbinding.ELProperty.create("${name}"));
- columnBinding.setColumnName("Name");
- columnBinding.setColumnClass(String.class);
- bindingGroup.addBinding(jTableBinding);
- jTable1.addContainerListener(new java.awt.event.ContainerAdapter() {
- public void componentAdded(java.awt.event.ContainerEvent evt) {
- jTable1ComponentAdded(evt);
- }
- });
- jScrollPane1.setViewportView(jTable1);
- jButton1.setText("Add Customer");
- jButton1.addActionListener(new java.awt.event.ActionListener() {
- public void actionPerformed(java.awt.event.ActionEvent evt) {
- jButton1ActionPerformed(evt);
- }
- });
- jLabel1.setText("Customer Name:");
- javax.swing.GroupLayout jPanel1Layout = new javax.swing.GroupLayout(jPanel1);
- jPanel1.setLayout(jPanel1Layout);
- jPanel1Layout.setHorizontalGroup(
- jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
- .addGroup(jPanel1Layout.createSequentialGroup()
- .addContainerGap()
- .addComponent(jScrollPane1, javax.swing.GroupLayout.PREFERRED_SIZE, 232, javax.swing.GroupLayout.PREFERRED_SIZE)
- .addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
- .addGroup(jPanel1Layout.createSequentialGroup()
- .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, 100, Short.MAX_VALUE)
- .addComponent(jButton1)
- .addGap(33, 33, 33))
- .addGroup(jPanel1Layout.createSequentialGroup()
- .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
- .addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
- .addComponent(jTextField1)
- .addGroup(jPanel1Layout.createSequentialGroup()
- .addComponent(jLabel1)
- .addGap(0, 0, Short.MAX_VALUE)))
- .addContainerGap())))
- );
- jPanel1Layout.setVerticalGroup(
- jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
- .addGroup(jPanel1Layout.createSequentialGroup()
- .addContainerGap()
- .addComponent(jScrollPane1, javax.swing.GroupLayout.PREFERRED_SIZE, 181, javax.swing.GroupLayout.PREFERRED_SIZE)
- .addContainerGap(97, Short.MAX_VALUE))
- .addGroup(javax.swing.GroupLayout.Alignment.TRAILING, jPanel1Layout.createSequentialGroup()
- .addGap(36, 36, 36)
- .addComponent(jLabel1, javax.swing.GroupLayout.PREFERRED_SIZE, 39, javax.swing.GroupLayout.PREFERRED_SIZE)
- .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
- .addComponent(jTextField1, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
- .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
- .addComponent(jButton1)
- .addGap(52, 52, 52))
- );
- javax.swing.GroupLayout jLayeredPane1Layout = new javax.swing.GroupLayout(jLayeredPane1);
- jLayeredPane1.setLayout(jLayeredPane1Layout);
- jLayeredPane1Layout.setHorizontalGroup(
- jLayeredPane1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
- .addGroup(jLayeredPane1Layout.createSequentialGroup()
- .addContainerGap()
- .addComponent(jPanel1, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
- .addContainerGap())
- );
- jLayeredPane1Layout.setVerticalGroup(
- jLayeredPane1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
- .addGroup(jLayeredPane1Layout.createSequentialGroup()
- .addContainerGap()
- .addComponent(jPanel1, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
- .addContainerGap())
- );
- jLayeredPane1.setLayer(jPanel1, javax.swing.JLayeredPane.DEFAULT_LAYER);
- jTabbedPane1.addTab("Customers Info", jLayeredPane1);
- jTableBinding = org.jdesktop.swingbinding.SwingBindings.createJTableBinding(org.jdesktop.beansbinding.AutoBinding.UpdateStrategy.READ_WRITE, itemlistList, jTable2);
- columnBinding = jTableBinding.addColumnBinding(org.jdesktop.beansbinding.ELProperty.create("${id}"));
- columnBinding.setColumnName("Id");
- columnBinding.setColumnClass(Integer.class);
- columnBinding = jTableBinding.addColumnBinding(org.jdesktop.beansbinding.ELProperty.create("${productName}"));
- columnBinding.setColumnName("Product Name");
- columnBinding.setColumnClass(String.class);
- columnBinding = jTableBinding.addColumnBinding(org.jdesktop.beansbinding.ELProperty.create("${ppp}"));
- columnBinding.setColumnName("Ppp");
- columnBinding.setColumnClass(Integer.class);
- columnBinding = jTableBinding.addColumnBinding(org.jdesktop.beansbinding.ELProperty.create("${price}"));
- columnBinding.setColumnName("Price");
- columnBinding.setColumnClass(Integer.class);
- bindingGroup.addBinding(jTableBinding);
- jScrollPane2.setViewportView(jTable2);
- javax.swing.GroupLayout jPanel2Layout = new javax.swing.GroupLayout(jPanel2);
- jPanel2.setLayout(jPanel2Layout);
- jPanel2Layout.setHorizontalGroup(
- jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
- .addGroup(javax.swing.GroupLayout.Alignment.TRAILING, jPanel2Layout.createSequentialGroup()
- .addContainerGap(15, Short.MAX_VALUE)
- .addComponent(jScrollPane2, javax.swing.GroupLayout.PREFERRED_SIZE, 452, javax.swing.GroupLayout.PREFERRED_SIZE)
- .addContainerGap())
- );
- jPanel2Layout.setVerticalGroup(
- jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
- .addGroup(javax.swing.GroupLayout.Alignment.TRAILING, jPanel2Layout.createSequentialGroup()
- .addContainerGap(javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
- .addComponent(jScrollPane2, javax.swing.GroupLayout.PREFERRED_SIZE, 275, javax.swing.GroupLayout.PREFERRED_SIZE)
- .addContainerGap())
- );
- javax.swing.GroupLayout jLayeredPane2Layout = new javax.swing.GroupLayout(jLayeredPane2);
- jLayeredPane2.setLayout(jLayeredPane2Layout);
- jLayeredPane2Layout.setHorizontalGroup(
- jLayeredPane2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
- .addGroup(javax.swing.GroupLayout.Alignment.TRAILING, jLayeredPane2Layout.createSequentialGroup()
- .addContainerGap()
- .addComponent(jPanel2, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
- .addContainerGap())
- );
- jLayeredPane2Layout.setVerticalGroup(
- jLayeredPane2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
- .addGroup(jLayeredPane2Layout.createSequentialGroup()
- .addContainerGap()
- .addComponent(jPanel2, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
- .addContainerGap())
- );
- jLayeredPane2.setLayer(jPanel2, javax.swing.JLayeredPane.DEFAULT_LAYER);
- jTabbedPane1.addTab("Item List", jLayeredPane2);
- javax.swing.GroupLayout jLayeredPane3Layout = new javax.swing.GroupLayout(jLayeredPane3);
- jLayeredPane3.setLayout(jLayeredPane3Layout);
- jLayeredPane3Layout.setHorizontalGroup(
- jLayeredPane3Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
- .addGap(0, 503, Short.MAX_VALUE)
- );
- jLayeredPane3Layout.setVerticalGroup(
- jLayeredPane3Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
- .addGap(0, 314, Short.MAX_VALUE)
- );
- jTabbedPane1.addTab("Bill", jLayeredPane3);
- javax.swing.GroupLayout jLayeredPane4Layout = new javax.swing.GroupLayout(jLayeredPane4);
- jLayeredPane4.setLayout(jLayeredPane4Layout);
- jLayeredPane4Layout.setHorizontalGroup(
- jLayeredPane4Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
- .addGap(0, 503, Short.MAX_VALUE)
- );
- jLayeredPane4Layout.setVerticalGroup(
- jLayeredPane4Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
- .addGap(0, 314, Short.MAX_VALUE)
- );
- jTabbedPane1.addTab("Stock", jLayeredPane4);
- javax.swing.GroupLayout layout = new javax.swing.GroupLayout(getContentPane());
- getContentPane().setLayout(layout);
- layout.setHorizontalGroup(
- layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
- .addGroup(layout.createSequentialGroup()
- .addContainerGap()
- .addComponent(jTabbedPane1)
- .addContainerGap())
- );
- layout.setVerticalGroup(
- layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
- .addGroup(layout.createSequentialGroup()
- .addContainerGap()
- .addComponent(jTabbedPane1, javax.swing.GroupLayout.PREFERRED_SIZE, 349, javax.swing.GroupLayout.PREFERRED_SIZE)
- .addContainerGap(21, Short.MAX_VALUE))
- );
- bindingGroup.bind();
- pack();
- }// </editor-fold>
- private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {
- // TODO add your handling code here:
- String cust_name = jTextField1.getText();
- try {
- Connection con;
- Class.forName("com.mysql.jdbc.Driver");
- con = DriverManager.getConnection("jdbc:mysql://localhost:3306/itbd?zeroDateTimeBehavior=convertToNull", "root", "root");
- PreparedStatement ps = con.prepareStatement("Insert into customers values(default,?)");
- ps.setString(1, cust_name);
- ps.executeUpdate();
- jTable1.addAncestorListener(null);
- con.close();
- } catch (ClassNotFoundException | SQLException e) {
- System.out.println("ERROR " + e);
- }
- }
- private void jTable1ComponentAdded(java.awt.event.ContainerEvent evt) {
- // TODO add your handling code here:
- }
- /**
- * @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 | InstantiationException | IllegalAccessException | javax.swing.UnsupportedLookAndFeelException ex) {
- java.util.logging.Logger.getLogger(HomeJFrame.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
- }
- //</editor-fold>
- /* Create and display the form */
- java.awt.EventQueue.invokeLater(new Runnable() {
- @Override
- public void run() {
- new HomeJFrame().setVisible(true);
- }
- });
- }
- // Variables declaration - do not modify
- private java.util.List<itb.Customers> customersList;
- private java.util.List<itb.Customers> customersList1;
- private java.util.List<itb.Customers> customersList2;
- private javax.persistence.Query customersQuery;
- private javax.persistence.Query customersQuery1;
- private javax.persistence.Query customersQuery2;
- private javax.persistence.EntityManager entityManager;
- private java.util.List<itb.Itemlist> itemlistList;
- private javax.persistence.Query itemlistQuery;
- private javax.swing.JButton jButton1;
- private javax.swing.JLabel jLabel1;
- private javax.swing.JLayeredPane jLayeredPane1;
- private javax.swing.JLayeredPane jLayeredPane2;
- private javax.swing.JLayeredPane jLayeredPane3;
- private javax.swing.JLayeredPane jLayeredPane4;
- private javax.swing.JPanel jPanel1;
- private javax.swing.JPanel jPanel2;
- private javax.swing.JScrollPane jScrollPane1;
- private javax.swing.JScrollPane jScrollPane2;
- private javax.swing.JTabbedPane jTabbedPane1;
- private javax.swing.JTable jTable1;
- private javax.swing.JTable jTable2;
- private javax.swing.JTextField jTextField1;
- private org.jdesktop.beansbinding.BindingGroup bindingGroup;
- // End of variables declaration
- }
Advertisement
Add Comment
Please, Sign In to add comment