Example usage for com.mongodb DBCursor hasNext

List of usage examples for com.mongodb DBCursor hasNext

  1. HOME
  2. Java
  3. com.mongodb
  4. com.mongodb.*
  5. DBCursor
  6. hasNext

Introduction

In this page you can find the example usage for com.mongodb DBCursor hasNext.

Prototype

@Override
public boolean hasNext()

Source Link

Document

Checks if there is another object available.

Usage

From source file:admin_update_Emp.java

public admin_update_Emp(String userid_new2) {
    initComponents();//  ww  w  .jav a 2 s.  c  o m

    //userid_new = admin_change.userid;
    userid_new = userid_new2;

    try {

        MongoClient mc = new MongoClient("localhost", 27017);
        DB db = mc.getDB("parking_system");
        DBCollection collection = db.getCollection("employee_info");

        BasicDBObject query = new BasicDBObject();
        BasicDBObject field = new BasicDBObject();
        field.put("_id", userid_new);

        DBCursor cursor = collection.find(field);

        while (cursor.hasNext()) {
            DBObject obj = (DBObject) cursor.next();
            userid_db = obj.get("_id").toString();
            System.out.println(userid_db);

            if (userid_db.equals(userid_new)) {
                old_name_field.setText(obj.get("name").toString());
                old_lname_field.setText(obj.get("lname").toString());
                old_mobno_field.setText(obj.get("mobileno").toString());
                old_userid_field.setText(obj.get("_id").toString());
                old_password_field.setText(obj.get("password").toString());
                System.out.println("In if");
                break;

            }

        }

    } catch (Exception e) {

    }

}

From source file:admin_update_Emp.java

private void submit_buttonActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_submit_buttonActionPerformed
    // TODO add your handling code here:

    try {//www  . j av  a2  s  .  c o m
        MongoClient mc = new MongoClient("localhost", 27017);
        DB db = mc.getDB("parking_system");
        DBCollection collection = db.getCollection("employee_info");

        BasicDBObject query = new BasicDBObject();
        BasicDBObject field = new BasicDBObject();
        field.put("_id", userid_new);
        DBCursor cursor = collection.find(query, field);

        while (cursor.hasNext()) {

            DBObject obj = (DBObject) cursor.next();
            userid_db = obj.get("_id").toString();
            System.out.println(userid_db);

            if (userid_new.equals(userid_db)) {
                System.out.println("IN THIS WALA IF");
                /*
                        
                old_name_field.setText(obj.get("name").toString());
                old_lname_field.setText(obj.get("lname").toString());
                        
                System.out.println("name "+obj.get("name").toString());
                System.out.println("name "+obj.get("name").toString());
                        
                old_mobno_field.setText(obj.get("mobileno").toString());
                old_userid_field.setText(userid_new);
                old_password_field.setText(obj.get("password").toString());
                        
                System.out.println("Done IN IF");
                        
                BasicDBObject query = new BasicDBObject();
                BasicDBObject field = new BasicDBObject();
                field.put("wheeler_2", 1);
                        
                DBCursor cursor = collection1.find(query, field);
                   */

                String newname, newmobno, newuserid, newpassword, newlname;

                newname = new_name_field.getText();
                newlname = new_lname_field.getText();
                newmobno = new_mobno_field.getText();

                newpassword = new_password_field.getText();

                BasicDBObject searchUpdate = new BasicDBObject();
                searchUpdate.append("_id", userid_new);/*.
                                                       append("name",old_name_field.getText()).
                                                       append("lname", old_lname_field.getText()).
                                                       append("mobileno", old_mobno_field.getText()).
                                                       append("password", old_password_field.getText());
                                                       */
                BasicDBObject UpdateObject = new BasicDBObject();

                UpdateObject.append("$set", new BasicDBObject("name", newname));
                collection.update(searchUpdate, UpdateObject);

                UpdateObject.append("$set", new BasicDBObject("lname", newlname));
                collection.update(searchUpdate, UpdateObject);

                UpdateObject.append("$set", new BasicDBObject("mobileno", newmobno));
                collection.update(searchUpdate, UpdateObject);

                UpdateObject.append("$set", new BasicDBObject("password", newpassword));
                collection.update(searchUpdate, UpdateObject);

                JOptionPane.showMessageDialog(null, "Entry Updated..!");
                setVisible(false);
                new Admin_rights().setVisible(true);

                break;
            }

        }
        System.out.println("Done OUT IF");
    } catch (Exception e) {
        System.err.println(e);
    }
}

From source file:search.java

/**
 * Processes requests for both HTTP <code>GET</code> and <code>POST</code>
 * methods.// w  w  w .j  a  v a2s  .  c o  m
 *
 * @param request servlet request
 * @param response servlet response
 * @throws ServletException if a servlet-specific error occurs
 * @throws IOException if an I/O error occurs
 */
protected void processRequest(HttpServletRequest request, HttpServletResponse response)
        throws ServletException, IOException {
    response.setContentType("text/html;charset=UTF-8");
    try (PrintWriter out = response.getWriter()) {
        /* TODO output your page here. You may use following sample code. */
        out.println("<!DOCTYPE html>");
        out.println("<html>");
        out.println("<head>");
        out.println("<title>Servlet search</title>");
        out.println("</head>");
        out.println("<body>");
        out.println("<h1>Servlet search at " + request.getContextPath() + "</h1>");
        String srch_id = request.getParameter("search");
        DB db;

        Mongo mongo = new Mongo("LocalHost", 27017);
        db = mongo.getDB("local");
        out.println("db connected is..." + db);
        DBCollection collection = db.getCollection("StartupHun");
        out.println("table used connected is..." + collection);
        BasicDBObject query = new BasicDBObject("founded_year", new BasicDBObject("$gt", 2005));
        BasicDBObject cat = new BasicDBObject();
        //query.put("name", srch_id);
        DBCursor cursor = collection.find();
        // Print out "highest" priority items
        BasicDBObject query1 = null;
        int i = 0;
        while (cursor.hasNext()) {
            //out.println(cursor.next());
            query1 = (BasicDBObject) cursor.next();

            out.println((Integer) query1.get("founded_year") + "  " + i);
            i++;
        }

        out.println("</body>");
        out.println("</html>");
    }
}

From source file:PanModificar.java

public PanModificar() {
    //Conexion a mongoDb
    try {//w  ww .  jav  a  2  s. c  o m
        Mongo mongo = new Mongo("localhost", 27017);
        db = mongo.getDB("Escuela");
        tabla = db.getCollection("Alumnos");

    } catch (UnknownHostException ex) {
        Logger.getLogger(Inicio.class.getName()).log(Level.SEVERE, null, ex);
    }
    DBCursor cursor = tabla.find();

    ArrayList rows = new ArrayList();
    String[] titulos = { "Nombre", "ApPaterno", "ApMaterno", "FechaNac", "Edad", "Sexo", "Matricula",
            "Semestre", "Carrera" };
    ArrayList<String> columndata = new ArrayList<String>(Arrays.asList(titulos));
    while (cursor.hasNext()) {
        BSONObject obj = cursor.next();

        // Obtener variables del JSON
        try {

            String name = (String) obj.get("Nombre");
            String ap = (String) obj.get("ApPaterno");
            String am = (String) obj.get("ApMaterno");
            String fechaNac = (String) obj.get("FechaNac");
            int edad = (int) obj.get("Edad");
            String sex = (String) obj.get("Sexo");
            String mat = (String) obj.get("Matricula");
            int semestre = (int) obj.get("Semestre");
            String carrera = (String) obj.get("Carrera");
            ArrayList<String> row = new ArrayList<String>(Arrays.asList(
                    new String[] { name, ap, am, fechaNac, "" + edad, sex, mat, "" + semestre, carrera }));
            rows.add(row);
        } catch (Exception ex) {
            System.out.println("objeto no completo");
        }

    }

    initComponents();
    jTable1.setModel(new CustomTableModel(columndata, rows, "no hay datos en la bd!!"));
    jTable1.setSelectionMode(ListSelectionModel.SINGLE_SELECTION);
}

From source file:Veehicle_entry.java

private void Entry_buttonActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_Entry_buttonActionPerformed
    // TODO add your handling code here:

    try {/*from  w ww  .j  av a 2  s  .c  o m*/

        String name, vehno, mobno;

        Random rand = new Random();
        token = rand.nextInt(10000);

        name = Name_field.getText();

        mobno = mobno_field.getText();

        vehno = vehno_strt1.getSelectedItem().toString() + "-" + vehno_strt2.getText() + "-"
                + vehno_strt3.getSelectedItem().toString() + "-" + vehno_strt4.getText();

        //System.out.println(vehno);

        MongoClient mc = new MongoClient("localhost", 27017);
        DB db = mc.getDB("parking_system");
        DBCollection collection = db.getCollection("entry_info");

        DBCollection collection1 = db.getCollection("vehicle_count");
        DBCollection collection2 = db.getCollection("statistics");

        if (veh_count == 2) {

            vehno = vehno + "W2";

            BasicDBObject queryx = new BasicDBObject();
            BasicDBObject fieldx = new BasicDBObject();
            fieldx.put("vehno", 1);
            DBCursor cursorx = collection.find(queryx, fieldx);

            while (cursorx.hasNext()) {

                BasicDBObject objx = (BasicDBObject) cursorx.next();

                String temp;
                temp = objx.getString("vehno");
                if (temp.equals(vehno)) {
                    JOptionPane.showMessageDialog(null, "vehicle number already exits!\n Entry Rejected!");
                    exists = 1;
                    setVisible(false);
                    new Veehicle_entry(veh_count).setVisible(true);

                }
            }

            if (exists == 0) {
                int count_bike;

                BasicDBObject doc = new BasicDBObject("_id", token).append("name", name)
                        .append("mobileno", mobno).append("vehno", vehno).append("intime", time_mills);

                validator = validate(collection, doc);
                if (validator == 1) {
                    //Updating vehicle count....
                    BasicDBObject query = new BasicDBObject();
                    BasicDBObject field = new BasicDBObject();
                    field.put("wheeler_2", 1);
                    DBCursor cursor = collection1.find(query, field);

                    BasicDBObject obj = (BasicDBObject) cursor.next();
                    count_bike = obj.getInt("wheeler_2");
                    System.out.println(count_bike);

                    BasicDBObject searchUpdate = new BasicDBObject();
                    searchUpdate.append("wheeler_2", count_bike);

                    BasicDBObject UpdateObject = new BasicDBObject();
                    UpdateObject.append("$set", new BasicDBObject("wheeler_2", count_bike + 1));

                    collection1.update(searchUpdate, UpdateObject);

                    //updating session...
                    int cnt_bike;
                    BasicDBObject query2 = new BasicDBObject();
                    BasicDBObject field2 = new BasicDBObject();
                    field2.put("2wheeler_count", 1);
                    DBCursor cursor2 = collection2.find(query2, field2);

                    BasicDBObject obj2 = (BasicDBObject) cursor2.next();
                    cnt_bike = obj2.getInt("2wheeler_count");
                    System.out.println(cnt_bike);

                    BasicDBObject searchUpdate2 = new BasicDBObject();
                    searchUpdate2.append("2wheeler_count", cnt_bike);

                    BasicDBObject UpdateObject2 = new BasicDBObject();
                    UpdateObject2.append("$set", new BasicDBObject("2wheeler_count", cnt_bike + 1));

                    collection2.update(searchUpdate2, UpdateObject2);

                    setVisible(false);
                    new Entry_OR_Exit().setVisible(true);
                }
            }
        }

        else if (veh_count == 4) {

            vehno = vehno + "W4";

            BasicDBObject queryx = new BasicDBObject();
            BasicDBObject fieldx = new BasicDBObject();
            fieldx.put("vehno", 1);
            DBCursor cursorx = collection.find(queryx, fieldx);

            while (cursorx.hasNext()) {

                BasicDBObject objx = (BasicDBObject) cursorx.next();

                String temp;
                temp = objx.getString("vehno");
                if (temp.equals(vehno)) {
                    JOptionPane.showMessageDialog(null, "vehicle number already exits!\n Entry Rejected!");
                    exists = 1;
                    setVisible(false);
                    new Veehicle_entry(veh_count).setVisible(true);

                }
            }

            if (exists == 0) {
                int count_car;

                BasicDBObject doc = new BasicDBObject("_id", token).append("name", name)
                        .append("mobileno", mobno).append("vehno", vehno).append("intime", time_mills);

                validator = validate(collection, doc);
                if (validator == 1) {

                    BasicDBObject query = new BasicDBObject();
                    BasicDBObject field = new BasicDBObject();
                    field.put("wheeler_4", 1);
                    DBCursor cursor = collection1.find(query, field);

                    BasicDBObject obj = (BasicDBObject) cursor.next();
                    count_car = obj.getInt("wheeler_4");
                    System.out.println(count_car);

                    BasicDBObject searchUpdate = new BasicDBObject();
                    searchUpdate.append("wheeler_4", count_car);

                    BasicDBObject UpdateObject = new BasicDBObject();
                    UpdateObject.append("$set", new BasicDBObject("wheeler_4", count_car + 1));

                    collection1.update(searchUpdate, UpdateObject);

                    //updating session...
                    int cnt_car;
                    BasicDBObject query2 = new BasicDBObject();
                    BasicDBObject field2 = new BasicDBObject();
                    field2.put("4wheeler_count", 1);
                    DBCursor cursor2 = collection2.find(query2, field2);

                    BasicDBObject obj2 = (BasicDBObject) cursor2.next();
                    cnt_car = obj2.getInt("4wheeler_count");
                    System.out.println(cnt_car);

                    BasicDBObject searchUpdate2 = new BasicDBObject();
                    searchUpdate2.append("4wheeler_count", cnt_car);

                    BasicDBObject UpdateObject2 = new BasicDBObject();
                    UpdateObject2.append("$set", new BasicDBObject("4wheeler_count", cnt_car + 1));

                    collection2.update(searchUpdate2, UpdateObject2);

                    setVisible(false);
                    new Entry_OR_Exit().setVisible(true);
                }
            }
        }

        else {
            vehno = vehno + "W6";

            BasicDBObject queryx = new BasicDBObject();
            BasicDBObject fieldx = new BasicDBObject();
            fieldx.put("vehno", 1);
            DBCursor cursorx = collection.find(queryx, fieldx);

            while (cursorx.hasNext()) {

                BasicDBObject objx = (BasicDBObject) cursorx.next();

                String temp;
                temp = objx.getString("vehno");
                if (temp.equals(vehno)) {
                    JOptionPane.showMessageDialog(null, "vehicle number already exits!\n Entry Rejected!");
                    exists = 1;
                    setVisible(false);
                    new Veehicle_entry(veh_count).setVisible(true);

                }
            }
            if (exists == 0) {

                int count_other;

                BasicDBObject doc = new BasicDBObject("_id", token).append("name", name)
                        .append("mobileno", mobno).append("vehno", vehno).append("intime", time_mills);

                validator = validate(collection, doc);
                if (validator == 1) {

                    System.out.println("Came 1");
                    BasicDBObject query = new BasicDBObject();
                    BasicDBObject field = new BasicDBObject();
                    field.put("other", 1);
                    DBCursor cursor = collection1.find(query, field);

                    BasicDBObject obj = (BasicDBObject) cursor.next();
                    count_other = obj.getInt("other");
                    System.out.println(count_other);

                    BasicDBObject searchUpdate = new BasicDBObject();
                    searchUpdate.append("other", count_other);

                    BasicDBObject UpdateObject = new BasicDBObject();
                    UpdateObject.append("$set", new BasicDBObject("other", count_other + 1));

                    collection1.update(searchUpdate, UpdateObject);

                    //updating session...
                    int cnt_other;
                    BasicDBObject query2 = new BasicDBObject();
                    BasicDBObject field2 = new BasicDBObject();
                    field2.put("other_count", 1);
                    DBCursor cursor2 = collection2.find(query2, field2);

                    BasicDBObject obj2 = (BasicDBObject) cursor2.next();
                    cnt_other = obj2.getInt("other_count");
                    System.out.println(cnt_other);

                    BasicDBObject searchUpdate2 = new BasicDBObject();
                    searchUpdate2.append("other_count", cnt_other);

                    BasicDBObject UpdateObject2 = new BasicDBObject();
                    UpdateObject2.append("$set", new BasicDBObject("other_count", cnt_other + 1));

                    collection2.update(searchUpdate2, UpdateObject2);

                    setVisible(false);
                    new Entry_OR_Exit().setVisible(true);
                }
            }
        }
    } catch (Exception e) {

    }

}

From source file:JavaSimpleExample.java

License:MIT License

public static void main(String[] args) throws UnknownHostException {

    // Create seed data

    final BasicDBObject[] seedData = createSeedData();

    // Standard URI format: mongodb://[dbuser:dbpassword@]host:port/dbname

    MongoClientURI uri = new MongoClientURI("mongodb://user:pass@host:port/db");
    MongoClient client = new MongoClient(uri);
    DB db = client.getDB(uri.getDatabase());

    /*/*from w ww. j  a v  a  2s  . com*/
     * First we'll add a few songs. Nothing is required to create the
     * songs collection; it is created automatically when we insert.
     */

    DBCollection songs = db.getCollection("songs");

    // Note that the insert method can take either an array or a document.

    songs.insert(seedData);

    /*
     * Then we need to give Boyz II Men credit for their contribution to
     * the hit "One Sweet Day".
     */

    BasicDBObject updateQuery = new BasicDBObject("song", "One Sweet Day");
    songs.update(updateQuery,
            new BasicDBObject("$set", new BasicDBObject("artist", "Mariah Carey ft. Boyz II Men")));

    /*
     * Finally we run a query which returns all the hits that spent 10 
     * or more weeks at number 1.
     */

    BasicDBObject findQuery = new BasicDBObject("weeksAtOne", new BasicDBObject("$gte", 10));
    BasicDBObject orderBy = new BasicDBObject("decade", 1);

    DBCursor docs = songs.find(findQuery).sort(orderBy);

    while (docs.hasNext()) {
        DBObject doc = docs.next();
        System.out.println("In the " + doc.get("decade") + ", " + doc.get("song") + " by " + doc.get("artist")
                + " topped the charts for " + doc.get("weeksAtOne") + " straight weeks.");
    }

    // Since this is an example, we'll clean up after ourselves.

    songs.drop();

    // Only close the connection when your app is terminating

    client.close();
}

From source file:ReadOplog.java

License:Apache License

public static void main(String[] args) throws Exception {

    MongoClient mongoClient = new MongoClient();
    DB local = mongoClient.getDB("local");

    DBCollection oplog = local.getCollection("oplog.$main");

    DBCursor lastCursor = oplog.find().sort(new BasicDBObject("$natural", -1)).limit(1);
    if (!lastCursor.hasNext()) {
        System.out.println("no oplog!");
        return;//from ww w. jav  a2s.c o  m
    }
    DBObject last = lastCursor.next();

    BSONTimestamp ts = (BSONTimestamp) last.get("ts");
    System.out.println("starting point: " + ts);

    while (true) {
        System.out.println("starting at ts: " + ts);
        DBCursor cursor = oplog.find(new BasicDBObject("ts", new BasicDBObject("$gt", ts)));
        cursor.addOption(Bytes.QUERYOPTION_TAILABLE);
        cursor.addOption(Bytes.QUERYOPTION_AWAITDATA);
        while (cursor.hasNext()) {
            DBObject x = cursor.next();
            ts = (BSONTimestamp) x.get("ts");
            System.out.println("\t" + x);
        }

        Thread.sleep(1000);
    }
}

From source file:Welcome.java

private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jButton1ActionPerformed
    String accno = JOptionPane.showInputDialog(this, "Enter Your Account Number");
    if (isInteger(accno)) {

        int value = JOptionPane.showConfirmDialog(this, "Do You Want to add Account No. " + accno);
        if (value == 0) {
            String Banks[] = { "", "Allahabad Bank", "Andhra Bank", "Bank of Baroda", "Bank of India",
                    "Bank of Maharashtra", "Canara Bank", "Central Bank of India", "Corporation Bank",
                    "Dena Bank", "Indian Bank", "Indian Overseas Bank", "Oriental Bank of Commerce",
                    "Punjab & Sind Bank", "Punjab National Bank", "Syndicate Bank", "UCO Bank",
                    "Union Bank of India", "United Bank of India", "Vijaya Bank", "Axis Bank",
                    "City Union Bank", "Dhanlaxmi Bank", "Federal Bank", "HDFC Bank", "ICICI Bank", "IDFC Bank",
                    "Karnataka Bank", "IndusInd Bank", "ING Vysya Bank", "Jammu and Kashmir Bank",
                    "Karur Vysya Bank", "Kotak Mahindra Bank", "Yes bank", "Citi Bank", "State Bank of India",
                    "State Bank of Patiala", "State Bank of Mysore", "State Bank of Travancore",
                    "State Bank of Bikaner and Jaipur", "State Bank of Hyderabad", "State Bank Of Saurashtra"

            };/*from   w  w  w. j  a va  2 s.  c  om*/
            Arrays.sort(Banks);
            JComboBox jcb = new JComboBox(Banks);
            jcb.setEditable(true);
            JOptionPane.showMessageDialog(this, jcb, "Select Your Bank", JOptionPane.QUESTION_MESSAGE);
            while (jcb.getSelectedItem().equals("")) {
                JOptionPane.showMessageDialog(this, "Please Select the Bank");
                JOptionPane.showMessageDialog(this, jcb, "Select Your Bank", JOptionPane.QUESTION_MESSAGE);
            }
            String money = JOptionPane.showInputDialog(this,
                    "Enter the amount present in " + accno + " account");
            String Bank = (String) jcb.getSelectedItem();
            while (!isInteger(money)) {
                JOptionPane.showMessageDialog(this, "You entered a Wrong Value. Please Enter Correct Value");
                money = JOptionPane.showInputDialog(this, "Enter the amount present in " + accno + " account");
            }
            MongoClient client = new MongoClient("localhost", 27017);
            DB db;
            db = client.getDB("ExpenseManager");
            DBCollection reg = (DBCollection) db.getCollection("Registration");
            DBObject query = new BasicDBObject("unm", unm);
            DBObject update = new BasicDBObject();

            DBCursor find = reg.find(query);
            while (find.hasNext()) {
                DBObject next = find.next();
                int count = 1;
                for (int i = 1; i <= 5; i++) {
                    String str1 = "Account" + i;
                    String str2 = "Bank" + i;
                    String str3 = "Money" + i;
                    System.out.println(str1);
                    if (!(next.containsField(str1))) {
                        update.put("$set",
                                new BasicDBObject(str1, accno).append(str2, Bank).append(str3, money));
                        WriteResult result = reg.update(query, update);
                        setListVal();
                        break;
                    }
                }
            }

        }

    } else {
        JOptionPane.showMessageDialog(this, "You Entered a wrong Number");
    }

    // TODO add your handling code here:
}

From source file:Search_trainer.java

@Override
public void actionPerformed(ActionEvent ae) {
    // TODO Auto-generated method stub
    add(jLabel3);/*from  ww w . j  av a  2  s .  c  o  m*/
    add(jTextField1);
    add(jButton1);

    if (ae.getSource() == jComboBox1) {
        String Variable = jComboBox1.getSelectedItem().toString();
        jLabel3.setText("");
        jTextField1.setText("");

        if (Variable == "All_Trainers") {
            try {
                MongoClient mongo = new MongoClient("localhost", 27017);
                DB db = mongo.getDB("Gym");
                DBCollection Gym_Collection = db.getCollection("trainer");
                DBCursor cursor1 = Gym_Collection.find();
                int i = 0;
                String[][] s = new String[20][10];
                while (cursor1.hasNext()) {
                    cursor1.next();
                    s[i][0] = cursor1.curr().get("First_Name").toString();
                    s[i][1] = cursor1.curr().get("Last_Name").toString();
                    s[i][2] = cursor1.curr().get("Batch").toString();
                    s[i][3] = cursor1.curr().get("Age").toString();
                    s[i][4] = cursor1.curr().get("Username").toString();
                    s[i][5] = cursor1.curr().get("Password").toString();
                    s[i][6] = cursor1.curr().get("Phone_Number").toString();
                    s[i][7] = cursor1.curr().get("Address").toString();
                    i++;
                }

                JFrame frame = new JFrame("Resulted Trainers");
                frame.setDefaultCloseOperation(DISPOSE_ON_CLOSE);
                Trainer_Table ne = new Trainer_Table(s);
                ne.setOpaque(true);
                frame.setContentPane(ne);
                frame.pack();
                frame.setVisible(true);
            } catch (UnknownHostException e) {
                // TODO Auto-generated catch block
                e.printStackTrace();
            }
        } else {
            jLabel3.setFont(new java.awt.Font("SansSerif", 3, 14)); // NOI18N
            jLabel3.setForeground(new java.awt.Color(204, 255, 204));
            jLabel3.setHorizontalAlignment(javax.swing.SwingConstants.RIGHT);
            jLabel3.setText("Enter " + Variable + ": ");
            jLabel3.setBounds(55, 230, 200, 40);

            jTextField1.setBounds(267, 230, 200, 40);

            jButton1.setBackground(new java.awt.Color(51, 0, 51));
            jButton1.setFont(new java.awt.Font("SansSerif", 3, 12)); // NOI18N
            jButton1.setForeground(new java.awt.Color(255, 255, 255));
            jButton1.setText("Search Trainer");
            jButton1.setBounds(160, 300, 300, 40);
            setVisible(true);
        }
    } else if (ae.getSource() == jButton1) {

        try {

            String Variable = jComboBox1.getSelectedItem().toString();
            MongoClient mongo = new MongoClient("localhost", 27017);
            DB db = mongo.getDB("Gym");
            DBCollection Gym_Collection = db.getCollection("trainer");
            BasicDBObject fields;
            if (Variable == "First_Name" || Variable == "Last_Name" || Variable == "Username"
                    || Variable == "Batch") {
                fields = new BasicDBObject(Variable, jTextField1.getText().toString());
            } else {
                fields = new BasicDBObject(Variable, Integer.parseInt(jTextField1.getText().toString()));
            }
            DBCursor cursor1 = Gym_Collection.find(fields);
            int i = 0;
            String[][] s = new String[20][10];
            while (cursor1.hasNext()) {
                cursor1.next();
                s[i][0] = cursor1.curr().get("First_Name").toString();
                s[i][1] = cursor1.curr().get("Last_Name").toString();
                s[i][2] = cursor1.curr().get("Batch").toString();
                s[i][3] = cursor1.curr().get("Age").toString();
                s[i][4] = cursor1.curr().get("Username").toString();
                s[i][5] = cursor1.curr().get("Password").toString();
                s[i][6] = cursor1.curr().get("Phone_Number").toString();
                s[i][7] = cursor1.curr().get("Address").toString();
                i++;
            }

            JFrame frame = new JFrame("Resulted Trainers");
            frame.setDefaultCloseOperation(DISPOSE_ON_CLOSE);
            Trainer_Table ne = new Trainer_Table(s);
            ne.setOpaque(true);
            frame.setContentPane(ne);
            frame.pack();
            frame.setVisible(true);
        } catch (UnknownHostException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        } catch (NumberFormatException e) {// To validate for data types
            JOptionPane.showMessageDialog(this, "Please Check the Data types");
            jTextField1.setText("");
        }
    } else if (ae.getSource() == jButton2) {
        this.setVisible(false);
        new Admin().setVisible(true);
    }
}

From source file:Slots.java

String GetSlots() {
    DBCollection coll = db.getCollection("Slots");
    DBCursor cursor = coll.find();
    String s = " ";
    int i = 0;/*from   www  .j  a v a  2 s  .  co  m*/
    while (cursor.hasNext()) {
        System.out.println(cursor.next());
        i = 1;
        s = s + "....." + cursor.next();

    }
    return s;

}