Example usage for com.mongodb DBCursor next

List of usage examples for com.mongodb DBCursor next

Introduction

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

Prototype

@Override
public DBObject next() 

Source Link

Document

Returns the object the cursor is at and moves the cursor ahead by one.

Usage

From source file:Session_details.java

public Session_details() {
    initComponents();/*w ww. j  av  a  2s . c om*/

    try {

        String str = "stats", str2;
        MongoClient mc = new MongoClient("localhost", 27017);
        DB db = mc.getDB("parking_system");
        DBCollection collection = db.getCollection("statistics");

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

        DBCursor cursor = collection.find(field);

        while (cursor.hasNext()) {
            DBObject obj = (DBObject) cursor.next();
            str2 = obj.get("_id").toString();

            if (str2.equals(str)) {
                wheeler2_cnt_field.setText(obj.get("2wheeler_count").toString());
                wheeler2_income_field.setText(obj.get("2wheeler_income").toString());
                wheeler4_cnt_field.setText(obj.get("4wheeler_count").toString());
                wheeler4_income_field.setText(obj.get("4wheeler_income").toString());
                other_cnt_field.setText(obj.get("other_count").toString());
                other_income_field.setText(obj.get("other_income").toString());
                time_field.setText(obj.get("time").toString());

                break;

            }

        }

    } catch (Exception e) {
        System.err.println(e);
    }

}

From source file:Session_details.java

public void updateSession(String s1)//, String s2)
{
    try {//from ww  w . j av  a2 s .  co  m

        int count;
        MongoClient mc = new MongoClient("localhost", 27017);
        DB db = mc.getDB("parking_system");
        DBCollection collection2 = db.getCollection("statistics");

        BasicDBObject query = new BasicDBObject();
        BasicDBObject field = new BasicDBObject();
        field.put(s1, 1);

        DBCursor cursor = collection2.find(query, field);

        BasicDBObject obj = (BasicDBObject) cursor.next();
        count = obj.getInt(s1);
        System.out.println(count);

        BasicDBObject searchUpdate = new BasicDBObject();
        searchUpdate.append(s1, count);

        BasicDBObject UpdateObject = new BasicDBObject();
        UpdateObject.append("$set", new BasicDBObject(s1, 0));

        collection2.update(searchUpdate, UpdateObject);

    } catch (Exception e) {

    }
}

From source file:Session_details.java

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

    updateSession("2wheeler_count");//, "2wheeler_count" );

    updateSession("2wheeler_income");// , "2wheeler_income");

    updateSession("4wheeler_count");// , "4wheeler_count");

    updateSession("4wheeler_income");// , "4wheeler_income");

    updateSession("other_count");//, "other_count");

    updateSession("other_income");//, "other_income");

    Calendar cal = Calendar.getInstance();
    SimpleDateFormat dt = new SimpleDateFormat("HH:mm:ss");
    time_str = cal.getTime().toString();

    try {/*from  w w  w .j  a va2 s .  c o m*/
        String s;

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

        BasicDBObject query = new BasicDBObject();
        BasicDBObject field = new BasicDBObject();
        field.put("time", 1);

        DBCursor cursor = collection2.find(query, field);

        BasicDBObject obj = (BasicDBObject) cursor.next();
        s = obj.getString("time");
        System.out.println(s);

        BasicDBObject searchUpdate = new BasicDBObject();
        searchUpdate.append("time", s);

        BasicDBObject UpdateObject = new BasicDBObject();
        UpdateObject.append("$set", new BasicDBObject("time", time_str));

        collection2.update(searchUpdate, UpdateObject);

    } catch (Exception e) {

    }
    JOptionPane.showMessageDialog(null, "Session Details Cleared!");

    setVisible(false);
    new Admin_rights().setVisible(true);

}

From source file:admin_update_Emp.java

public admin_update_Emp(String userid_new2) {
    initComponents();/*from   w  w w  .j a  v a2  s . c om*/

    //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 {/*from  w w  w .  j a  va 2 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./*from w  w  w. ja  v a  2 s  . 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 w  w.  j av a  2  s  . co 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:QuestionGUI.java

private JSONObject getCurrentDoc() throws ParseException {
    db = mongo.getDatabase();//  w ww . ja v  a  2  s  . c  o  m
    collection = db.getCollection("Users");

    DBObject query = new BasicDBObject();
    query.put("Info.Username", username);

    DBObject fields = new BasicDBObject();
    fields.put(d, 1);

    JSONParser parser = new JSONParser();

    DBCursor cursor = collection.find(query, fields);
    String json = cursor.next().toString();
    JSONObject jsonFile = (JSONObject) parser.parse(json);
    return jsonFile;
}

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 {//w  w  w. j av a2  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 .  java 2 s.  c  o  m*/
     * 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();
}