List of usage examples for com.mongodb DBCursor next
@Override
public DBObject next()
From source file:Vehicle_type_check.java
private void car_buttonActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_car_buttonActionPerformed // TODO add your handling code here: try {/* w w w .j av a 2 s. c om*/ int count_car; MongoClient mc = new MongoClient("localhost", 27017); DB db = mc.getDB("parking_system"); DBCollection collection = db.getCollection("vehicle_count"); BasicDBObject query = new BasicDBObject(); BasicDBObject field = new BasicDBObject(); field.put("wheeler_4", 1); DBCursor cursor = collection.find(query, field); BasicDBObject obj = (BasicDBObject) cursor.next(); count_car = obj.getInt("wheeler_4"); System.out.println(count_car); if (count_car < 50) { BasicDBObject searchUpdate = new BasicDBObject(); searchUpdate.append("wheeler_4", count_car); BasicDBObject UpdateObject = new BasicDBObject(); UpdateObject.append("$set", new BasicDBObject("wheeler_4", count_car + 1)); collection.update(searchUpdate, UpdateObject); setVisible(false); new Veehicle_entry().setVisible(true); } else { JOptionPane.showMessageDialog(null, "No Available Space For Parking 2 Wheelers"); } } catch (Exception e) { } }
From source file:Ventana.java
public void consultar() { DBCursor cursor = coleccion.find(); jFrame1.setVisible(true);/*w w w . j a v a2 s .c om*/ jFrame1.setBounds(463, 0, 850, 650); jTextArea1.setText(" "); while (cursor.hasNext()) { jTextArea1.setText(jTextArea1.getText() + cursor.next() + "\n"); } }
From source file:PanBorrar.java
private void jButton2ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jButton2ActionPerformed // TODO add your handling code here: int num = 1;//ww w . j av a 2 s.co m DBCursor cursor = tabla.find(); DefaultListModel model = new DefaultListModel(); 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"); // Imprimir todo /*Mostrar.setText(Mostrar.getText() + "\n" + name + " " + ap + " " + am + " " + fechaNac + " " + edad + " " + sex + " " + mat + " " + semestre + " " + carrera);*/ model.addElement(num + " " + name + " " + ap + " " + am + " " + fechaNac + " " + edad + " " + sex + " " + mat + " " + semestre + " " + carrera); num++; } catch (Exception ex) { System.out.println("objeto no completo"); } Lista.setModel(model); } }
From source file:NewJFrame.java
@Override public void actionPerformed(ActionEvent ae) { // TODO Auto-generated method stub add(jLabel5);// w w w . j av a 2 s .com String user = jTextField1.getText().toString(); @SuppressWarnings("deprecation") String pass = jPassword1.getText().toString(); jLabel5.setText(""); if (ae.getSource() == jButton1) { if ((String) jComboBox1.getSelectedItem() == "Admin") { if (user.equals("admin") && pass.equals("admin123")) { this.setVisible(false); new Admin().setVisible(true); } else { jLabel5.setFont(new java.awt.Font("SansSerif", 3, 14)); // NOI18N jLabel5.setForeground(new java.awt.Color(25, 25, 112)); jLabel5.setHorizontalAlignment(javax.swing.SwingConstants.RIGHT); jLabel5.setText("Login Not Successful "); jTextField1.setText(""); jPassword1.setText(""); jLabel5.setBounds(120, 245, 170, 50); } } else if ((String) jComboBox1.getSelectedItem() == "Trainer") { try { MongoClient mongo = new MongoClient("localhost", 27017); DB db = mongo.getDB("Gym"); DBCollection Gym_Collection = db.getCollection("trainer"); BasicDBObject fields = new BasicDBObject("Username", user).append("Password", pass); String s; DBCursor cursor1 = Gym_Collection.find(fields); if (cursor1.hasNext()) { cursor1.next(); s = cursor1.curr().get("First_Name").toString(); new Receptionist(s); this.setVisible(false); new Receptionist().setVisible(true); } else { jLabel5.setFont(new java.awt.Font("SansSerif", 3, 14)); // NOI18N jLabel5.setForeground(new java.awt.Color(25, 25, 112)); jLabel5.setHorizontalAlignment(javax.swing.SwingConstants.RIGHT); jLabel5.setText("Login Not Successful "); jTextField1.setText(""); jPassword1.setText(""); jLabel5.setBounds(120, 245, 170, 50); } } catch (UnknownHostException e) { // TODO Auto-generated catch block e.printStackTrace(); } } } }
From source file:RestrictedService.java
License:Open Source License
/** * @param textToAnalize/*from w w w .jav a 2s .co m*/ * @param collectionName * @return * @throws Exception */ public static HttpEntity callANEW(String textToAnalize, String collectionName) throws Exception { String[] wordsInText = (textToAnalize + " ").split(" "); String wordAndValues[][] = new String[wordsInText.length][5]; //initialize the wordAndValues int position = 0; //Aux variable to see the position of each word inside the document String polarityAndValue[] = new String[2]; DBCollection coll = db.getCollection(collectionName); Double positive = 0.0; Double negative = 0.0; for (int i = 0; i < wordsInText.length; i++) { //For each word wordAndValues[i][0] = wordsInText[i]; //We save the word wordAndValues[i][1] = Integer.toString(position); //add its initial position += (wordsInText[i].length() - 1); wordAndValues[i][2] = Integer.toString(position);//and final position position += 2; //This is where the next word starts //We check if this word has a positive or negative annotation and set its value and polarity. BasicDBObject query = new BasicDBObject("Word", wordsInText[i].toLowerCase()); DBCursor cursor = coll.find(query); Double value = 5.0; try { while (cursor.hasNext()) { value = (Double) cursor.next().get("ValMn"); } } finally { cursor.close(); } if (value > 5) { wordAndValues[i][3] = "1.0"; wordAndValues[i][4] = "Positive"; positive++; } else if (value < 5) { wordAndValues[i][3] = "-1.0"; wordAndValues[i][4] = "Negative"; negative++; } else { wordAndValues[i][3] = "0.0"; wordAndValues[i][4] = "Neutral"; } polarityAndValue[0] = Double.toString(0); if ((positive + negative) != 0) { polarityAndValue[0] = Double.toString((positive - negative) / (positive + negative)); } if (new Double(polarityAndValue[0]) > 0) { polarityAndValue[1] = "Positive"; } else if (new Double(polarityAndValue[0]) < 0) { polarityAndValue[1] = "Negative"; } else { polarityAndValue[1] = "Neutral"; } } return callMarl(textToAnalize, wordAndValues, polarityAndValue); }
From source file:gMIRC_server.java
public static void cleaner() { try {/*from ww w . j a va2 s. c om*/ boolean hard_clean = false; MongoClient mongoClient = new MongoClient(); DB db = mongoClient.getDB("mirc"); DBCollection coll = db.getCollection("activeUser"); DBCursor cursor = coll.find(); try { Date now = new Date(); long timestamp_now = now.getTime(); long treshold = timestamp_now - (1000 * 60 * 5); //5 minutes while (cursor.hasNext()) { hard_clean = true; BasicDBObject temp = (BasicDBObject) cursor.next(); Date time_temp = (Date) temp.get("timestamp"); long timestamp_temp = time_temp.getTime(); if (timestamp_temp < treshold) { String target = temp.getString("username"); gMIRC_handler.SoftDelete(target); } } HardClean(); } finally { cursor.close(); } } catch (UnknownHostException ex) { Logger.getLogger(gMIRC_server.class.getName()).log(Level.SEVERE, null, ex); } }
From source file:gMIRC_server.java
public static void HardClean() { try {/*from w w w. jav a2 s . c o m*/ MongoClient mongoClient = new MongoClient(); DB db = mongoClient.getDB("mirc"); DBCollection coll[] = new DBCollection[4]; coll[0] = db.getCollection("channelCollection"); coll[1] = db.getCollection("inbox"); coll[2] = db.getCollection("activeUser"); coll[3] = db.getCollection("passiveUser"); DBCursor cursor = coll[3].find(); try { while (cursor.hasNext()) { BasicDBObject temp = (BasicDBObject) cursor.next(); String username = temp.getString("username"); BasicDBObject query = new BasicDBObject("username", username); System.out.println("cleaning " + username); for (int i = 0; i < 4; i++) { DBCursor cursor2 = coll[i].find(query); try { while (cursor2.hasNext()) { DBObject temp2 = cursor2.next(); coll[i].remove(temp2); } } finally { cursor2.close(); } } } } finally { cursor.close(); } } catch (UnknownHostException ex) { Logger.getLogger(gMIRC_server.class.getName()).log(Level.SEVERE, null, ex); } }
From source file:Proj.java
public static void main(String[] args) { System.out.println("Enter your choice do you want to work with 1.postgre 2.Redis 3.Mongodb"); InputStreamReader input = new InputStreamReader(System.in); BufferedReader data = new BufferedReader(input); String choice = null;//w w w . j a v a 2 s. co m try { choice = data.readLine(); } catch (Exception Eex) { System.out.println(Eex.getMessage()); } // loading data from the CSV file CsvReader Details = null; try { Details = new CsvReader("folder\\dataset.csv"); } catch (FileNotFoundException EB) { System.out.println(EB.getMessage()); } int ColumnCount = 3; int RowCount = 100; int k = 0; try { Details = new CsvReader("folder\\dataset.csv"); } catch (FileNotFoundException E) { System.out.println(E.getMessage()); } String[][] Dataarray = new String[RowCount][ColumnCount]; try { while (Details.readRecord()) { String v; String[] x; v = Details.getRawRecord(); x = v.split(","); for (int j = 0; j < ColumnCount; j++) { String value = null; int z = j; value = x[z]; try { Dataarray[k][j] = value; } catch (Exception E) { System.out.println(E.getMessage()); } // System.out.println(Dataarray[iloop][j]); } k = k + 1; } } catch (IOException Em) { System.out.println(Em.getMessage()); } Details.close(); // connection to Database switch (choice) { // postgre code goes here case "1": Connection Conn = null; Statement Stmt = null; URI dbUri = null; InputStreamReader in = new InputStreamReader(System.in); BufferedReader out = new BufferedReader(in); try { Class.forName("org.postgresql.Driver"); } catch (Exception E1) { System.out.println(E1.getMessage()); } String username = "ejepndckpvzvrj"; String password = "uBq0RRYh47bRt_vxrZZDC14ois"; String dbUrl = "postgres://ejepndckpvzvrj:uBq0RRYh47bRt_vxrZZDC14ois@ec2-54-83-53-120.compute-1.amazonaws.com:5432/d1b2vsoh5fhl6n"; // now update data in the postgress Database for (int i = 0; i < RowCount; i++) { try { Conn = DriverManager.getConnection(dbUrl, username, password); Stmt = Conn.createStatement(); String Connection_String = "insert into Details (first_name,last_name,county) values (' " + Dataarray[i][0] + " ',' " + Dataarray[i][1] + " ',' " + Dataarray[i][2] + " ')"; Stmt.executeUpdate(Connection_String); } catch (SQLException E4) { System.out.println(E4.getMessage()); } } // Quering with the Database System.out.println("1. Display Data "); System.out.println("2. Select data based on Other attributes e.g Name"); System.out.println("Enter your Choice "); try { choice = out.readLine(); } catch (IOException E) { System.out.println(E.getMessage()); } switch (choice) { case "1": try { Conn = DriverManager.getConnection(dbUrl, username, password); Stmt = Conn.createStatement(); String Connection_String = " Select * from Details;"; ResultSet objRS = Stmt.executeQuery(Connection_String); while (objRS.next()) { System.out.println("First name " + objRS.getInt("First_name")); System.out.println("Last name " + objRS.getString("Last_name")); System.out.println("COunty " + objRS.getString("County")); } } catch (Exception E2) { System.out.println(E2.getMessage()); } break; case "2": String Name = null; System.out.println("Enter First Name to find the record"); InputStreamReader obj = new InputStreamReader(System.in); BufferedReader bur = new BufferedReader(obj); try { Name = (bur.readLine()).toString(); } catch (IOException E) { System.out.println(E.getMessage()); } try { Conn = DriverManager.getConnection(dbUrl, username, password); Stmt = Conn.createStatement(); String Connection_String = " Select * from Details Distinct where Name=" + "'" + Name + "'" + ";"; ResultSet objRS = Stmt.executeQuery(Connection_String); while (objRS.next()) { System.out.println("First name: " + objRS.getInt("First_name")); System.out.println("Last name " + objRS.getString("Last_name")); System.out.println("County " + objRS.getString("County")); } } catch (Exception E2) { System.out.println(E2.getMessage()); } break; } try { Conn.close(); } catch (SQLException E6) { System.out.println(E6.getMessage()); } break; // Redis code goes here case "2": int Length = 0; String ID = null; Length = 100; // Connection to Redis Jedis jedis = new Jedis("pub-redis-15228.us-east-1-2.1.ec2.garantiadata.com", 15228); jedis.auth("redis-cse-axt3229-2-7825704"); System.out.println("Connected to Redis"); // Storing values in the database System.out.println("Storing values in the Database "); for (int i = 0; i < Length; i++) { int j = i + 1; jedis.hset("DEtail:" + j, "First_name", Dataarray[i][0]); jedis.hset("Detail:" + j, "Last_name ", Dataarray[i][1]); jedis.hset("Detail:" + j, "Count", Dataarray[i][2]); } System.out.println("Search by First Name"); InputStreamReader inob = new InputStreamReader(System.in); BufferedReader buob = new BufferedReader(inob); String ID2 = null; try { ID2 = buob.readLine(); } catch (IOException E3) { System.out.println(E3.getMessage()); } for (int i = 0; i < 100; i++) { Map<String, String> properties3 = jedis.hgetAll("Deatails:" + i); for (Map.Entry<String, String> entry : properties3.entrySet()) { String value = entry.getValue(); if (entry.getValue().equals(ID2)) { System.out.println(jedis.hget("Detials:" + i, "First_name")); } } } //for (Map.Entry<String, String> entry : properties1.entrySet()) //{ //System.out.println(entry.getKey() + "---" + entry.getValue()); // } // mongo db code goes here case "3": MongoClient mongo = new MongoClient( new MongoClientURI("mongodb://ank:123@ds055574.mongolab.com:55574/heroku_h7mxqs7l")); DB db; db = mongo.getDB("heroku_h7mxqs7l"); // storing values in the database for (int i = 0; i < 100; i++) { BasicDBObject document = new BasicDBObject(); document.put("_id", i + 1); document.put("First_name", Dataarray[i][0]); document.put("Last_name", Dataarray[i][1]); document.put("County", Dataarray[i][2]); db.getCollection("DetailsRaw").insert(document); } System.out.println("Search by Name"); InputStreamReader inobj = new InputStreamReader(System.in); BufferedReader objname = new BufferedReader(inobj); String Name = null; try { Name = objname.readLine(); } catch (IOException E) { System.out.println(E.getMessage()); } BasicDBObject inQuery1 = new BasicDBObject(); inQuery1.put("first Name", Name); DBCursor cursor1 = db.getCollection("DetailsRaw").find(inQuery1); while (cursor1.hasNext()) { // System.out.println(cursor.next()); System.out.println(cursor1.next()); } } }
From source file:Highscores.java
private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jButton1ActionPerformed // TODO add your handling code here: try {//w ww .j a va2 s. c o m String user; int count = 1; String highscore; jTextArea2.append("SR No.\tUSERNAME\tHIGHSCORE\n"); int high; MongoClient mc = new MongoClient("localhost", 27017); DB db = mc.getDB("Classic_Hangman"); System.out.println("Connected to database successfully!!"); DBCollection coll = db.getCollection("high_score"); System.out.println("Collection Retrieved"); DBCursor cursor = coll.find(); cursor.sort(new BasicDBObject("value", -1)); while (cursor.hasNext() && count < 4) { DBObject result = cursor.next(); high = ((Number) result.get("value")).intValue(); highscore = Integer.toString(high); user = (String) result.get("_id"); jTextArea2.append(count + "\t" + user + "\t" + highscore + "\n"); count++; } } catch (UnknownHostException ex) { Logger.getLogger(Highscores.class.getName()).log(Level.SEVERE, null, ex); } }
From source file:Add_cust.java
@Override /* Check The code below for insertion of values */ public void actionPerformed(ActionEvent ae) { // TODO Auto-generated method stub add(jLabel9);// w w w. ja va 2s . co m String History = jComboBox3.getSelectedItem().toString(); if (ae.getSource() == jButton1) { try { MongoClient mongo = new MongoClient("localhost", 27017); DB db = mongo.getDB("Gym"); DBCollection Gym_Collection = db.getCollection("Customers"); DBCollection Allot = db.getCollection("Batch"); //Declaration of collection for Batch DBCursor cursor = Allot.find(); float Slots, Morning, Evening, Night; cursor.next(); Slots = Float.parseFloat(cursor.curr().get("Slots").toString()); Morning = Float.parseFloat(cursor.curr().get("Morning").toString()); Evening = Float.parseFloat(cursor.curr().get("Evening").toString()); Night = Float.parseFloat(cursor.curr().get("Night").toString()); String first_name = jTextField1.getText(); String last_name = jTextField2.getText(); float weight = Float.parseFloat(jTextField6.getText().toString()); float height = Float.parseFloat(jTextField5.getText().toString()); String address = jTextArea1.getText(); int age = Integer.parseInt(jComboBox1.getSelectedItem().toString()); String Subs = jComboBox2.getSelectedItem().toString(); String Batches = jComboBox5.getSelectedItem().toString(); String phone_number = jTextField3.getText().toString(); if (!isAlpha(first_name) || !isAlpha(last_name)) { JOptionPane.showMessageDialog(this, "Enter a valid name"); jTextField1.setText(""); jTextField2.setText(""); } else if (weight > 150 || weight < 40) { JOptionPane.showMessageDialog(this, "Please add weight between 40 and 150"); jTextField6.setText(""); } else if (height > 250 || height < 50) { JOptionPane.showMessageDialog(this, "Please add height between 100 and 250"); jTextField5.setText(""); } else if (phone_number.length() < 8 || phone_number.length() > 11) { JOptionPane.showMessageDialog(this, "Enter a valid Phone no."); jTextField3.setText(""); } else { int random_1, random_2, sub_sum = 0, days = 0; if (Subs.equals("1 Month")) { sub_sum = 1000; days = 30; } else if (Subs.equals("2 Months")) { sub_sum = 1500; days = 60; } else if (Subs.equals("3 Months")) { sub_sum = 2250; days = 90; } else if (Subs.equals("1 YEAR")) { sub_sum = 6000; days = 360; } int flag = 0, flag1 = 0, flag2 = 0, flag3 = 0; if (Batches.equals("Morning")) { Morning += 1; flag1 = 1; } else if (Batches.equals("Evening")) { Evening += 1; flag2 = 1; } else if (Batches.equals("Night")) { Night += 1; flag3 = 1; } if (Morning > Slots || Evening > Slots || Night > Slots) { if (flag1 == 1) { Morning -= 1; } else if (flag2 == 1) { Evening -= 1; } else if (flag3 == 1) { Night -= 1; } flag = 1; } if (flag == 1) { float temp1, temp2; if (flag1 == 1) { temp1 = Slots - Evening; temp2 = Slots - Night; JOptionPane.showMessageDialog(this, "This time slot slot is full. Evening has " + temp1 + " Slots. Night has " + temp2 + " Slots."); } else if (flag2 == 1) { temp1 = Slots - Morning; temp2 = Slots - Night; JOptionPane.showMessageDialog(this, "This time slot slot is full. Morning has " + temp1 + " Slots. Night has " + temp2 + " Slots."); } else { temp1 = Slots - Morning; temp2 = Slots - Evening; JOptionPane.showMessageDialog(this, "This time slot slot is full. Morning has " + temp1 + " Slots. Evening has " + temp2 + " Slots."); } } else { do { random_1 = (int) Math.floor(Math.random() * 360); random_2 = (int) Math.floor(Math.random() * 360); } while (random_1 >= random_2 || days <= random_2); BasicDBObject doc = new BasicDBObject("First_Name", first_name.toLowerCase()) .append("Last_Name", last_name.toLowerCase()).append("Phone_Number", phone_number) .append("Age", age).append("Height", height).append("History", History) .append("Subscribe", days).append("Batch", Batches).append("Weight", weight) .append("Attended", random_1).append("Total", random_2).append("Fees", sub_sum) .append("Address", address); Gym_Collection.insert(doc); jTextField1.setText(""); jTextField2.setText(""); jTextField3.setText(""); jTextField5.setText(""); jTextField6.setText(""); jTextArea1.setText(""); BasicDBObject newDocument = new BasicDBObject(); newDocument.append("$set", new BasicDBObject().append("Morning", Morning) .append("Evening", Evening).append("Night", Night)); BasicDBObject searchQuery = new BasicDBObject().append("Slots", Slots); Allot.update(searchQuery, newDocument); this.setVisible(false); new work(History, first_name.toLowerCase(), last_name.toLowerCase()); this.setVisible(false); new work().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(""); jTextField2.setText(""); jTextField3.setText(""); jTextField5.setText(""); jTextField6.setText(""); jTextArea1.setText(""); } } else if (ae.getSource() == jButton2) { this.setVisible(false); new Receptionist().setVisible(true); } }