Java tutorial
/* * 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 mongodb; import com.mongodb.BasicDBObject; import com.mongodb.DB; import com.mongodb.DBCollection; import com.mongodb.DBCursor; import com.mongodb.DBObject; import java.net.UnknownHostException; import java.util.logging.Level; import java.util.logging.Logger; import javax.swing.JFrame; import javax.swing.JOptionPane; import javax.swing.table.DefaultTableModel; /** * * @author Ravimal */ public class View extends javax.swing.JFrame { /** * Creates new form View */ public View() { initComponents(); load(); setDefaultCloseOperation(JFrame.DISPOSE_ON_CLOSE); } public void load() { try { DefaultTableModel model = (DefaultTableModel) jTable1.getModel(); model.setRowCount(0); DB userDB = DBManager.getDatabase(); DBCollection col = userDB.getCollection("user"); DBCursor cursor = col.find(); while (cursor.hasNext()) { DBObject user = (DBObject) cursor.next(); model.addRow(new Object[] { user.get("_id"), user.get("firstName"), user.get("lastName"), user.get("email") }); System.out.println(user); System.out.println(user.get("_id")); } } catch (UnknownHostException ex) { Logger.getLogger(View.class.getName()).log(Level.SEVERE, null, ex); JOptionPane.showMessageDialog(null, ex); } } /** * 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">//GEN-BEGIN:initComponents private void initComponents() { jPanel1 = new javax.swing.JPanel(); jLabel1 = new javax.swing.JLabel(); jScrollPane1 = new javax.swing.JScrollPane(); jTable1 = new javax.swing.JTable(); jTextField1 = new javax.swing.JTextField(); jLabel2 = new javax.swing.JLabel(); jLabel3 = new javax.swing.JLabel(); jTextField2 = new javax.swing.JTextField(); jLabel4 = new javax.swing.JLabel(); jTextField3 = new javax.swing.JTextField(); jButton1 = new javax.swing.JButton(); jButton2 = new javax.swing.JButton(); setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE); getContentPane().setLayout(new org.netbeans.lib.awtextra.AbsoluteLayout()); jPanel1.setLayout(new org.netbeans.lib.awtextra.AbsoluteLayout()); jLabel1.setFont(new java.awt.Font("Tahoma", 1, 14)); // NOI18N jLabel1.setText("View Users"); jPanel1.add(jLabel1, new org.netbeans.lib.awtextra.AbsoluteConstraints(250, 20, -1, -1)); jTable1.setModel( new javax.swing.table.DefaultTableModel( new Object[][] { { null, null, null, null }, { null, null, null, null }, { null, null, null, null }, { null, null, null, null } }, new String[] { "ID", "First name", "Last name", "Email" })); jTable1.addMouseListener(new java.awt.event.MouseAdapter() { public void mouseClicked(java.awt.event.MouseEvent evt) { jTable1MouseClicked(evt); } }); jScrollPane1.setViewportView(jTable1); jPanel1.add(jScrollPane1, new org.netbeans.lib.awtextra.AbsoluteConstraints(80, 60, -1, 130)); jPanel1.add(jTextField1, new org.netbeans.lib.awtextra.AbsoluteConstraints(180, 210, 210, 20)); jLabel2.setText("First name"); jPanel1.add(jLabel2, new org.netbeans.lib.awtextra.AbsoluteConstraints(110, 220, -1, 20)); jLabel3.setText("Last name"); jPanel1.add(jLabel3, new org.netbeans.lib.awtextra.AbsoluteConstraints(110, 280, -1, 20)); jPanel1.add(jTextField2, new org.netbeans.lib.awtextra.AbsoluteConstraints(180, 270, 210, 20)); jLabel4.setText("Email"); jPanel1.add(jLabel4, new org.netbeans.lib.awtextra.AbsoluteConstraints(110, 330, -1, 20)); jPanel1.add(jTextField3, new org.netbeans.lib.awtextra.AbsoluteConstraints(180, 330, 210, 20)); jButton1.setText("Update"); jButton1.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { jButton1ActionPerformed(evt); } }); jPanel1.add(jButton1, new org.netbeans.lib.awtextra.AbsoluteConstraints(160, 390, 110, 30)); jButton2.setText("Delete"); jButton2.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { jButton2ActionPerformed(evt); } }); jPanel1.add(jButton2, new org.netbeans.lib.awtextra.AbsoluteConstraints(290, 390, 110, 30)); getContentPane().add(jPanel1, new org.netbeans.lib.awtextra.AbsoluteConstraints(0, 0, 560, 450)); pack(); }// </editor-fold>//GEN-END:initComponents private void jTable1MouseClicked(java.awt.event.MouseEvent evt) {//GEN-FIRST:event_jTable1MouseClicked try { String val = jTable1.getModel().getValueAt(jTable1.getSelectedRow(), 0).toString(); DB userDB = DBManager.getDatabase(); DBCollection col = userDB.getCollection("user"); BasicDBObject query = new BasicDBObject("_id", new BasicDBObject("$eq", Integer.parseInt(val))); DBCursor cursor = col.find(query); DBObject user = (DBObject) cursor.next(); jTextField1.setText(user.get("firstName").toString()); jTextField2.setText(user.get("lastName").toString()); jTextField3.setText(user.get("email").toString()); /// while (cursor.hasNext()) { // DBObject user = cursor.next(); // jComboBox1.addItem(user.get("_id")); // } // TODO add your handling code here: // int row = jTable1.rowAtPoint(evt.getPoint()); //int col = jTable1.columnAtPoint(evt.getPoint()); // String a= jTable1.getComponentAt(row, 0).toString(); // getval(a); } catch (UnknownHostException ex) { Logger.getLogger(View.class.getName()).log(Level.SEVERE, null, ex); } }//GEN-LAST:event_jTable1MouseClicked private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jButton1ActionPerformed // TODO add your handling code here: String val = jTable1.getModel().getValueAt(jTable1.getSelectedRow(), 0).toString(); try { DB userDB = DBManager.getDatabase(); DBCollection col = userDB.getCollection("user"); BasicDBObject query = new BasicDBObject("_id", new BasicDBObject("$eq", Integer.parseInt(val))); BasicDBObject newDocument = new BasicDBObject(); newDocument.put("firstName", jTextField1.getText()); newDocument.put("lastName", jTextField2.getText()); newDocument.put("email", jTextField3.getText()); BasicDBObject updateObj = new BasicDBObject(); updateObj.put("$set", newDocument); col.update(query, updateObj, false, true); JOptionPane.showMessageDialog(rootPane, "User Update SucessFully...!"); } catch (UnknownHostException ex) { Logger.getLogger(View.class.getName()).log(Level.SEVERE, null, ex); } }//GEN-LAST:event_jButton1ActionPerformed private void jButton2ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jButton2ActionPerformed // TODO add your handling code here: String val = jTable1.getModel().getValueAt(jTable1.getSelectedRow(), 0).toString(); try { DB userDB = DBManager.getDatabase(); DBCollection col = userDB.getCollection("user"); BasicDBObject query = new BasicDBObject("_id", new BasicDBObject("$eq", Integer.parseInt(val))); col.remove(query); // col.D(query, updateObj, false, true); JOptionPane.showMessageDialog(rootPane, "User deleted SucessFully...!"); this.dispose(); new View().setVisible(true); } catch (UnknownHostException ex) { Logger.getLogger(View.class.getName()).log(Level.SEVERE, null, ex); } }//GEN-LAST:event_jButton2ActionPerformed public void getval(String val) { } /** * @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 ex) { java.util.logging.Logger.getLogger(View.class.getName()).log(java.util.logging.Level.SEVERE, null, ex); } catch (InstantiationException ex) { java.util.logging.Logger.getLogger(View.class.getName()).log(java.util.logging.Level.SEVERE, null, ex); } catch (IllegalAccessException ex) { java.util.logging.Logger.getLogger(View.class.getName()).log(java.util.logging.Level.SEVERE, null, ex); } catch (javax.swing.UnsupportedLookAndFeelException ex) { java.util.logging.Logger.getLogger(View.class.getName()).log(java.util.logging.Level.SEVERE, null, ex); } //</editor-fold> /* Create and display the form */ java.awt.EventQueue.invokeLater(new Runnable() { public void run() { new View().setVisible(true); } }); } // Variables declaration - do not modify//GEN-BEGIN:variables private javax.swing.JButton jButton1; private javax.swing.JButton jButton2; private javax.swing.JLabel jLabel1; private javax.swing.JLabel jLabel2; private javax.swing.JLabel jLabel3; private javax.swing.JLabel jLabel4; private javax.swing.JPanel jPanel1; private javax.swing.JScrollPane jScrollPane1; private javax.swing.JTable jTable1; private javax.swing.JTextField jTextField1; private javax.swing.JTextField jTextField2; private javax.swing.JTextField jTextField3; // End of variables declaration//GEN-END:variables }