List of usage examples for com.mongodb DBCursor next
@Override
public DBObject next()
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(); }