コード例 #1
0
 public MongoTable(String host, String port, String dbName, String collectionName) {
   try {
     this.db = new Mongo(host, Integer.valueOf(port)).getDB(dbName);
     this.collection = db.getCollection(collectionName);
   } catch (UnknownHostException e) {
     e.printStackTrace();
   } catch (MongoException e) {
     e.printStackTrace();
   }
 }
コード例 #2
0
ファイル: DbLogger.java プロジェクト: depy/cloggrbot
 public DbLogger(String dbHost, int dbPort, String dbName, String collectionName) {
   Mongo mongo;
   try {
     mongo = new Mongo(dbHost, dbPort);
     DB db = mongo.getDB(dbName);
     dbCollection = db.getCollection(collectionName);
   } catch (UnknownHostException e) {
     e.printStackTrace();
   } catch (MongoException e) {
     e.printStackTrace();
   }
 }
コード例 #3
0
ファイル: MongoUtil.java プロジェクト: joesan/jcerticles
 private static Mongo getMongo() {
   if (mongo == null) {
     try {
       mongo = new Mongo(HOST, PORT);
       System.out.println("New Mongo created with [" + HOST + "] and [" + PORT + "]");
     } catch (MongoException e) {
       e.printStackTrace();
     } catch (UnknownHostException e) {
       e.printStackTrace();
     }
   }
   return mongo;
 }
コード例 #4
0
ファイル: MongoDBGroup.java プロジェクト: mdhari/OneVillage
  public MongoDBGroup() {

    try {
      m = new Mongo(sHost);
      DB db = m.getDB(sDB);
      collection = db.getCollection(sCollection);
    } catch (UnknownHostException e) {
      // TODO Auto-generated catch block
      e.printStackTrace();
    } catch (MongoException e) {
      // TODO Auto-generated catch block
      e.printStackTrace();
    }
  }
コード例 #5
0
ファイル: Main.java プロジェクト: aditya7/TrendRR
  /** @throws NullPointerException */
  public static void PrintHighestJerseyNumber() throws NullPointerException {
    Mongo m = null;
    try {
      m = new Mongo("dbh63.mongolab.com", 27637);
    } catch (UnknownHostException e) {
      e.printStackTrace();
    } catch (MongoException e) {
      e.printStackTrace();
    }
    DB trendrr = m.getDB("trendrr");
    /* authentication line */
    trendrr.authenticate("", "".toCharArray());
    DBCollection players = trendrr.getCollection("players");

    BasicDBObject query = new BasicDBObject();
    query.put("team", "jets");
    query.put("position", "wr");

    DBCursor cur = players.find(query);

    int maxJerseyNumber = 0;
    String playerName = "";

    while (cur.hasNext()) {
      DBObject playerDetails = cur.next();
      String nameAndNumber = playerDetails.get("name").toString();
      String NameNumberTokens[] = nameAndNumber.split(",");
      try {
        if (NameNumberTokens.length != 2) {
          System.out.println("Invalid name field in the database");
          System.out.println(
              "Name: " + NameNumberTokens[0] + " Jersey Number: " + NameNumberTokens[1]);
        }
      } catch (NullPointerException e) {
        System.out.println("NULL value in name field " + e);
        continue;
      }
      try {
        if (maxJerseyNumber < Integer.parseInt(NameNumberTokens[1].trim())) {
          maxJerseyNumber = Integer.parseInt(NameNumberTokens[1].trim());
          playerName = NameNumberTokens[0];
        }
      } catch (NumberFormatException e) {
        System.out.println("Invalid data in name field " + e);
        continue;
      }
    }
    System.out.println("Player Name: " + playerName);
  }
コード例 #6
0
ファイル: MessageDAO.java プロジェクト: frouyer193/repotest
  public static void put(String id, String msg) {

    try {
      DBCollection message = Database.gardensharing().getCollection("message");

      BasicDBObject document = new BasicDBObject();
      document.put("id", id);
      document.put("msg", msg);
      message.insert(document);
    } catch (MongoException e) {
      e.printStackTrace();
    }

    // messages.put(id, msg);
  }
コード例 #7
0
  public String returnAllEmployees() throws Exception {

    ToJson converter = new ToJson();
    // JSONArray json = new JSONArray();
    String json = "";
    try {

      /** ** Connect to MongoDB *** */
      // Since 2.10.0, uses MongoClient
      //				MongoClient mongo = new MongoClient("localhost", 27017);
      MongoClient mongo = new MongoClient("54.214.0.233", 27017);

      /** ** Get database *** */
      // if database doesn't exists, MongoDB will create it for you
      DB db = mongo.getDB("telemedicine");

      /** ** Get collection / table from 'testdb' *** */
      // if collection doesn't exists, MongoDB will create it for you
      DBCollection table = db.getCollection("person");

      /** ** Find and display *** */
      BasicDBObject searchQuery = new BasicDBObject();
      // searchQuery.put("name", name);

      DBCursor cursor = table.find();

      System.out.println(cursor.count());

      while (cursor.hasNext()) {
        System.out.println(cursor.next());
      }

      json = converter.toJsonArray(cursor);

    } catch (MongoException e) {
      e.printStackTrace();
    } catch (Exception Error) {
      Error.printStackTrace();
      return json;
    } finally {
      //				if (conn != null) conn.close();
    }

    return json;
  }
コード例 #8
0
  public static void main(String[] args) {
    try {
      Mongo mongo = new Mongo("localhost", 27017);
      DB db = mongo.getDB("yourdb");
      DBCollection collection = db.getCollection("dummyColl");
      System.out.println("Testing 1...");
      insertDummyDocuments(collection);

      // find hosting = hostB, and update it with new document
      BasicDBObject newDocument = new BasicDBObject();
      newDocument.put("hosting", "hostB");
      newDocument.put("type", "shared host");
      newDocument.put("clients", 111);
      collection.update(new BasicDBObject().append("hosting", "hostB"), newDocument);
      printAllDocuments(collection);
      removeAllDocuments(collection);
      System.out.println("Testing 2...");
      insertDummyDocuments(collection);
      BasicDBObject newDocument2 =
          new BasicDBObject().append("$inc", new BasicDBObject().append("clients", 99));
      collection.update(new BasicDBObject().append("hosting", "hostB"), newDocument2);
      printAllDocuments(collection);
      removeAllDocuments(collection);
      System.out.println("Testing 3...");
      insertDummyDocuments(collection);
      BasicDBObject newDocument3 =
          new BasicDBObject()
              .append("$set", new BasicDBObject().append("type", "dedicated server"));
      collection.update(new BasicDBObject().append("hosting", "hostA"), newDocument3);
      printAllDocuments(collection);
      removeAllDocuments(collection);
      System.out.println("Testing 4...");
      insertDummyDocuments(collection);
      BasicDBObject updateQuery =
          new BasicDBObject().append("$set", new BasicDBObject().append("clients", "888"));
      collection.update(new BasicDBObject().append("type", "vps"), updateQuery, false, true);
      printAllDocuments(collection);
      removeAllDocuments(collection);
      System.out.println("Done");
    } catch (UnknownHostException e) {
      e.printStackTrace();
    } catch (MongoException e) {
      e.printStackTrace();
    }
  }
コード例 #9
0
ファイル: MongoDao.java プロジェクト: hwjworld/JG
 public static Datastore getInstance() {
   if (ds == null) {
     Mongo mongo;
     try {
       mongo = new Mongo();
       ds = new Morphia().createDatastore(mongo, "jg");
       ds.ensureIndexes();
       ds.ensureCaps();
     } catch (UnknownHostException e) {
       // TODO Auto-generated catch block
       e.printStackTrace();
     } catch (MongoException e) {
       // TODO Auto-generated catch block
       e.printStackTrace();
     }
   }
   return ds;
 }
コード例 #10
0
  @Override
  public void update(TestData testData) {
    try {
      DB db = MongoDBProvider.getInstance().getDB();
      DBCollection coll = db.getCollection("testdata");

      BasicDBObject query = new BasicDBObject();
      query.put("source", testData.getClassName());

      BasicDBObject object = new BasicDBObject();
      object.put("source", testData.getClassName());
      object.put("fails", testData.getFails());

      coll.update(query, object, true, false);

    } catch (MongoException e) {
      e.printStackTrace();
    } catch (UnknownHostException e) {
      e.printStackTrace();
    }
  }
コード例 #11
0
ファイル: MessageDAO.java プロジェクト: frouyer193/repotest
  public static String get(String id) {
    // Since 2.10.0, uses MongoClient
    try {
      DBCollection message = Database.gardensharing().getCollection("message");

      BasicDBObject searchQuery = new BasicDBObject();
      searchQuery.put("id", id);

      DBCursor cursor = message.find(searchQuery);

      if (cursor.hasNext()) {
        DBObject object = cursor.next();

        return object.toString();
      } else {
        return null;
      }
    } catch (MongoException e) {
      e.printStackTrace();
    }
    return null;
  }
コード例 #12
0
  @Override
  public List<TestData> getList() {
    try {
      DB db = MongoDBProvider.getInstance().getDB();
      DBCollection coll = db.getCollection("testdata");
      List<TestData> results = new ArrayList<TestData>();

      DBCursor cursor = coll.find();
      while (cursor.hasNext()) {
        DBObject result = cursor.next();
        TestData testData =
            new TestData((String) result.get("source"), (Integer) result.get("fails"));
        results.add(testData);
      }

      return results;

    } catch (MongoException e) {
      e.printStackTrace();
    } catch (UnknownHostException e) {
      e.printStackTrace();
    }
    return null;
  }
コード例 #13
0
  @Override
  public TestData get(String className) {
    DB db = null;
    try {
      db = MongoDBProvider.getInstance().getDB();
      DBCollection coll = db.getCollection("testdata");

      BasicDBObject query = new BasicDBObject();
      query.put("source", className);
      DBCursor cursor = coll.find(query);

      if (cursor.hasNext()) {
        DBObject result = cursor.next();
        TestData testData =
            new TestData((String) result.get("source"), (Integer) result.get("fails"));
        return testData;
      }
    } catch (MongoException e) {
      e.printStackTrace();
    } catch (UnknownHostException e) {
      e.printStackTrace();
    }
    return new TestData(className, 0);
  }
  public void doPost(HttpServletRequest request, HttpServletResponse response)
      throws ServletException, IOException {

    try {
      int l = 0;
      int k = 0;
      // String carID = request.getParameter("reservation");
      String carCategory = request.getParameter("carCategory");
      String carID = request.getParameter("carID");
      String start_date_string = request.getParameter("startDate");
      String end_date_string = request.getParameter("endDate");
      // String start_time_string = request.getParameter("startTime");
      // String end_time_string = request.getParameter("endTime");
      // start_date_string = start_date_string + start_time_string;
      // end_date_string = end_date_string + end_time_string;

      PrintWriter out = response.getWriter();
      out.println(start_date_string);
      try {
        Date startDate = new SimpleDateFormat("yyyy-MM-dd").parse((start_date_string).trim());
        Date endDate = new SimpleDateFormat("yyyy-MM-dd").parse((end_date_string).trim());
        // Date startDate = new
        // SimpleDateFormat("yyyy-MM-ddhh:mm").parse((start_date_string).trim());
        // Date endDate = new SimpleDateFormat("yyyy-MM-ddhh:mm").parse((end_date_string).trim());
        int diffInDays = (int) ((startDate.getTime() - endDate.getTime()) / (1000 * 60 * 60 * 24));
        out.print("the difference is these many days: ");
        out.println(diffInDays);
        DB db = mongo.getDB("practice");
        DBCollection reservations = db.getCollection("reservations");
        DBCursor dbCursor = null;
        dbCursor = reservations.find();
        if (!dbCursor.hasNext()) {
          out.println("Database is empty");
          BasicDBObject doc =
              new BasicDBObject("carCategory", carCategory)
                  .append("carID", carID)
                  .append("start_date_string", start_date_string)
                  .append("end_date_string", end_date_string);
          reservations.insert(doc);
          k = 1;
        }
        while (dbCursor.hasNext()) {
          BasicDBObject bobj = (BasicDBObject) dbCursor.next();
          String temp_car_id = (bobj.getString("carID")).trim();
          if (temp_car_id.equals(carID)) {
            String start_date_string_db = (bobj.getString("start_date_string")).trim();
            String end_date_string_db = (bobj.getString("end_date_string")).trim();
            Date startDate_db =
                new SimpleDateFormat("yyyy-MM-dd").parse((start_date_string_db).trim());
            Date endDate_db = new SimpleDateFormat("yyyy-MM-dd").parse((end_date_string_db).trim());
            boolean c1 = startDate.after(startDate_db) && startDate.before(endDate_db);
            // if(c1)out.println("c1 is true");
            // else out.println("c1 is not true");
            boolean c2 = endDate.after(startDate_db) && endDate.before(endDate_db);
            // if(c2)out.println("c2 is true");
            // else out.println("c2 is not true");
            boolean c3 = startDate_db.after(startDate) && startDate_db.before(endDate);
            // if(c3)out.println("c3 is true");
            // else out.println("c3 is not true");
            boolean c4 = endDate_db.after(startDate) && endDate_db.before(endDate);
            // if(c4)out.println("c4 is true");
            // else out.println("c4 is not true");
            boolean c5 = (c1 || c2 || c3 || c4);
            if (c5) {
              l = l + 1;
              // out.print(l);
              // out.println("th loop");
            }
          }
        }
        if (l > 0) {
          out.println("reservation not possible");
        }
        if ((l == 0) && (k == 0)) {
          BasicDBObject doc =
              new BasicDBObject("carID", carID)
                  .append("start_date_string", start_date_string)
                  .append("end_date_string", end_date_string);
          reservations.insert(doc);
        }
      } catch (ParseException e) {
        e.printStackTrace();
      }

      // BasicDBObject query = new BasicDBObject();
      // query.put("username", n);
      // query.put("password", p);
      // // If the collection does not exists, MongoDB will create it for you
      // DBCollection loindet = db.getCollection("loindet");
      // // collection selected successfully.
      // DBCursor cursor = loindet.find(query);
      // //int cnt = 0;
      // int cnt = loindet.find(query).count();
      // if(cnt!=0)
      // {
      //     PrintWriter out = response.getWriter();
      //     //out.println("okay");
      //     HttpSession session = request.getSession();
      //     session.setAttribute( "sUserName", n );
      //     response.sendRedirect("index.jsp");
      // }

      // if(cnt == 0)
      // {
      //    response.sendRedirect("login.jsp");
      // }
    } catch (MongoException e) {
      e.printStackTrace();
    }
  }
コード例 #15
0
  public void doGet(HttpServletRequest request, HttpServletResponse response)
      throws ServletException, IOException {

    response.setContentType("text/html");
    HashMapProducts hmp = new HashMapProducts();
    hmp.setHashMapProduct();
    hmap = hmp.getHashMapProduct();

    PrintWriter out = response.getWriter();
    HttpSession s = request.getSession();
    String username = (String) s.getAttribute("userName");
    String role = (String) s.getAttribute("role");

    try {

      out.println("<html>");

      out.println("<head>");
      out.println("<meta http-equiv='Content-Type' content='text/html; charset=utf-8' />");
      out.println("<title>GameZon");
      out.println("</title>");
      out.println("<link rel='stylesheet' href='styles.css' type='text/css' />");
      out.println("</head>");

      out.println("<body>");
      out.println("<div id='container'>");
      out.println("<header>");
      out.println("<h1>");
      out.println("<a href='/'>Game");
      out.println("<span>Zon");
      out.println("</span>");
      out.println("</a>");
      out.println("</h1>");
      if (username != null) {
        out.println("<h5 style='float:right'>Welcome " + username + " !</h5>");
      }

      out.println("</header>");
      out.println("<nav>");
      out.println("<ul>");
      out.println("<li>");
      out.println("<a href='index.html'>Home");
      out.println("</a>");
      out.println("</li>");
      out.println("<li class=''>");
      out.println("<a href='/GameWebsite/Microsoft'>Microsoft");
      out.println("</a>");
      out.println("</li>");
      out.println("<li class=''>");
      out.println("<a href='/GameWebsite/Sony'>Sony");
      out.println("</a>");
      out.println("</li>");
      out.println("<li class='end'>");
      out.println("<a href='/GameWebsite/Nintendo'>Nintendo");
      out.println("</a>");
      out.println("</li>");
      out.println("<li class='end'>");
      out.println("<a href='/GameWebsite/Accessories'>Accessories");
      out.println("</a>");
      out.println("</li>");
      if (username == null) {
        out.println("<li class='end'>");
        out.println("<a href='signin.html'>Sign In");
        out.println("</a>");
        out.println("</li>");
        out.println("<li class='end'>");
        out.println("<a href='signup.html'>Sign Up");
        out.println("</a>");
        out.println("</li>");
      }
      if (role != null) {

        if (role.equals("customer")) {
          out.println("<li class='end'><a href='/GameWebsite/MyOrders'>My Orders</a></li>");
          out.println("<li class='end'><a href='/GameWebsite/MyCart'>My Cart</a></li>");
        }
        if (role.equals("salesMan")) {
          out.println("<li ><a href='/GameWebsite/CustomerOrders'>Customer Orders</a></li>");
        }
        if (role.equals("storeManager")) {
          out.println(
              "<li class='start selected'><a href='/GameWebsite/UpdateProducts'>Update Products</a></li>");
        }
      }

      if (username != null) {
        out.println(
            "<li class='end' style='float:right'><a href='/GameWebsite/LogOut'>Log Out</a></li>");
      }

      out.println("</ul>");
      out.println("</nav>");

      out.println(
          "<img class='header-image' src='images/indexheader.jpg' width = '100%' height = '100%' alt='Index Page Image' />");

      out.println("<div id='body'>");

      out.println("<section id='content'>");

      out.println("<article>");
      out.println("<h2>All Orders");
      out.println("</h2>");
      out.println("<table>");
      List<Integer> cartList = new ArrayList<>();
      out.println("<tr>");
      out.println("<td>");

      out.println("</td>");
      out.println("</tr>");
      out.println("<tr>");
      // out.println("<td>");
      //     out.println("Id");
      // out.println("</td>");
      out.println("<td>");
      out.println("Name");
      out.println("</td>");
      out.println("<td>");
      out.println("Price");
      out.println("</td>");
      out.println("<td>");
      out.println("Action");
      out.println("</td>");
      out.println("<td>");
      out.println("Action");
      out.println("</td>");
      out.println("</tr>");

      /* if(cursor.length()==0)
      {
         out.println("<tr><td><h5>No Orders</h5></td></tr>");
      }*/

      // out.println("<td>");
      //  out.println(obj.get("_id"));
      // Object orderId=(Object)obj.get("_id");

      //  out.println("</td>");

      // BasicDBList itemsList = (BasicDBList) obj.get("items");

      //  out.println(itemsList.get(i));
      Iterator<Integer> productIterator = hmap.keySet().iterator();

      while (productIterator.hasNext()) {
        out.println("<tr>");
        out.println("<td>");
        Integer id = productIterator.next();

        Product p = hmap.get(id);

        out.println(p.Name);

        out.println("</td>");

        out.println("<td>");
        out.println(p.price);
        out.println("</td>");

        out.println("<td>");
        out.println("<form class = 'submit-button' method = 'get' action = 'UpdateOrder'>");
        out.println("<input type='hidden' name = 'productId' value = '" + p.Id + "'>");
        out.println("<input type='submit' name = 'quantity' value = 'Update'>");
        out.println("</form>");
        out.println("</td>");

        out.println("<td>");
        out.println("<form class = 'submit-button' method = 'get' action = 'DeleteOrder'>");
        out.println("<input type='hidden' name = 'productId' value = '" + p.Id + "'>");
        out.println("<input type='submit' name = 'quantity' value = 'Delete'>");
        out.println("</form>");
        out.println("</td>");

        out.println("</tr>");
      }

      // cartList=(List<Integer>)obj.get("items");
      // for(int c:cartList)
      // {
      //      out.println(c);
      // }

      // out.println(obj.get("username"));
      // HttpSession s=request.getSession();
      // s.setAttribute("userName",uname);
      // System.out.println("user logged in successfully");
      // request.getRequestDispatcher("/Index").forward(request, response);

      out.println("</table>");

      out.println("</article>");

      out.println("</section>");

      out.println("<aside class='sidebar'>");

      out.println("<ul>");
      out.println("<li>");
      out.println("<h4>Our Products");
      out.println("</h4>");
      out.println("<ul>");
      out.println("<li>");
      out.println("<a href='/GameWebsite/Microsoft'>Microsoft");
      out.println("</a>");
      out.println("</li>");
      out.println("<li>");
      out.println("<a href='/GameWebsite/Sony'>Sony");
      out.println("</a>");
      out.println("</li>");
      out.println("<li>");
      out.println("<a href='/GameWebsite/Nintendo'>Nintendo");
      out.println("</a>");
      out.println("</li>");
      out.println("<li>");
      out.println("<a href='/GameWebsite/Accessories'>Accessories");
      out.println("</a>");
      out.println("</li>");
      out.println("</ul>");
      out.println("</li>");
      out.println("</ul>");

      out.println("</aside>");

      out.println("<div class='clear'>");
      out.println("</div>");
      out.println("</div>");

      out.println("<footer>");

      out.println("<div class='footer-bottom'>");
      out.println("<p>Let the Game began !");
      out.println("</p>");
      out.println("</div>");

      out.println("</footer>");
      out.println("</div>");

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

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

    } catch (MongoException e) {
      e.printStackTrace();
    }
  }
コード例 #16
0
  private DBCollection getMongoDBConnection() {

    String vcap_services = System.getenv("VCAP_SERVICES");
    String hostname = NULL_STRING;
    String dbname = NULL_STRING;
    String username = NULL_STRING;
    String password = NULL_STRING;
    String port = NULL_STRING;
    if (vcap_services != null && vcap_services.length() > 0) {
      try {
        ObjectMapper mapper = new ObjectMapper();
        JsonFactory factory = mapper.getJsonFactory();
        JsonParser jp;
        try {
          jp = factory.createJsonParser(vcap_services);
          JsonNode actualObj = mapper.readTree(jp);
          JsonNode credentials = actualObj.get("mongodb-1.8").get(0).get("credentials");
          dbname = credentials.get("name").toString();
          hostname = credentials.get("hostname").toString();
          username = credentials.get("username").toString();
          password = credentials.get("password").toString();
          port = credentials.get("port").toString();

        } catch (IOException e) {
          // TODO Auto-generated catch block
          e.printStackTrace();
        }
        System.out.println("dbname : " + dbname);
        System.out.println("hostname : " + hostname);
        System.out.println("port : " + port);
        System.out.println("user : "******"password : "******"xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx");
        Mongo mongo = new Mongo(hostname, Integer.parseInt(port));
        mongo.getConnector();
        CommandResult auth =
            mongo.getDB(dbname).authenticateCommand(username, password.toCharArray());
        System.out.println(auth);
        DB db = mongo.getDB(dbname);
        // db.authenticate(username, password.toCharArray());
        DBCollection collection = db.getCollection("cloudfoundry");
        BasicDBObject doc =
            new BasicDBObject("name", "MongoDB")
                .append("type", "database")
                .append("count", 1)
                .append("info", new BasicDBObject("x", 201).append("y", 102));
        collection.insert(doc);
        DBObject myDoc = collection.findOne();
        System.out.println(myDoc);
        return collection;
      } catch (UnknownHostException e) {
        e.printStackTrace();
      } catch (MongoException e) {
        e.printStackTrace();
      }
    } else {

      try {
        Mongo mongo = new Mongo("192.168.1.172", 25004);
        mongo.getConnector();
        System.out.println("xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx");
        CommandResult auth =
            mongo
                .getDB("3829864b-7a61-4bd7-be70-7627b7e044ad")
                .authenticateCommand(
                    "ecf963e6-92e7-49d6-a3c5-0ea6ee4cf586",
                    "cb3c03ad-8731-4d8e-ac81-c139ce2ed4c3".toCharArray());
        System.out.println(auth);
        DB db = mongo.getDB("3829864b-7a61-4bd7-be70-7627b7e044ad");
        DBCollection collection = db.getCollection("cloudfoundry");
        /*
        BasicDBObject doc = new BasicDBObject("name", "MongoDB")
        		.append("type", "database")
        		.append("count", 1)
        		.append("info",
        				new BasicDBObject("x", 203).append("y", 102));
        collection.insert(doc);
        DBObject myDoc = collection.findOne();
        System.out.println(myDoc);
        */
        return collection;
      } catch (UnknownHostException e) {
        e.printStackTrace();
      } catch (MongoException e) {
        e.printStackTrace();
      }
    }
    return null;
  }
コード例 #17
0
ファイル: App.java プロジェクト: freeperson6/uGift
  public static void main(String[] args) {

    try {

      /** ** Connect to MongoDB *** */
      // Since 2.10.0, uses MongoClient
      MongoClient mongo = new MongoClient("localhost", 27017);

      /** ** Get database *** */
      // if database doesn't exists, MongoDB will create it for you
      DB db = mongo.getDB("testdb");

      /** ** Get collection / table from 'testdb' *** */
      // if collection doesn't exists, MongoDB will create it for you
      DBCollection table = db.getCollection("user");

      /** ** Insert *** */
      // create a document to store key and value
      BasicDBObject document = new BasicDBObject();
      document.put("name", "mkyong");
      document.put("age", 30);
      document.put("createdDate", new Date());
      table.insert(document);

      /** ** Find and display *** */
      BasicDBObject searchQuery = new BasicDBObject();
      searchQuery.put("name", "mkyong");

      DBCursor cursor = table.find(searchQuery);

      while (cursor.hasNext()) {
        System.out.println(cursor.next());
      }

      /** ** Update *** */
      // search document where name="mkyong" and update it with new values
      BasicDBObject query = new BasicDBObject();
      query.put("name", "mkyong");

      BasicDBObject newDocument = new BasicDBObject();
      newDocument.put("name", "mkyong-updated");

      BasicDBObject updateObj = new BasicDBObject();
      updateObj.put("$set", newDocument);

      table.update(query, updateObj);

      /** ** Find and display *** */
      BasicDBObject searchQuery2 = new BasicDBObject().append("name", "mkyong-updated");

      DBCursor cursor2 = table.find(searchQuery2);

      while (cursor2.hasNext()) {
        System.out.println(cursor2.next());
      }

      /** ** Done *** */
      System.out.println("Done");

    } catch (UnknownHostException e) {
      e.printStackTrace();
    } catch (MongoException e) {
      e.printStackTrace();
    }
  }
コード例 #18
0
ファイル: ParamerSet.java プロジェクト: hdwt8289/SerialSlave1
  public void receiveData(
      String ip,
      String paramName,
      String paramNo,
      int paramBote,
      int paramLength,
      int parmParity,
      int parmStopBit,
      int parmDelay) {
    try {
      try {
        m = new Mongo(ip, 27017);
        db = m.getDB(paramName);
        // db.authenticate("test", "123".toCharArray());
      } catch (UnknownHostException ex) {
        ex.printStackTrace();
      } catch (MongoException e) {
        e.printStackTrace();
      }
      final DBCollection coll = db.getCollection("DATAIN");
      final DBCollection collout = db.getCollection("DATAOUT");
      DBCollection meta = db.getCollection("META");

      // 记录数据字段
      final Map map1 = new HashMap();
      final Map map2 = new HashMap();
      Map map00 = new HashMap();
      Map map01 = new HashMap();
      Map map02 = new HashMap();
      Map map03 = new HashMap();

      final Map m_ai_max = new HashMap();
      final Map m_ai_min = new HashMap();
      final Map m_ao_max = new HashMap();
      final Map m_ao_min = new HashMap();

      DBCursor cursor = meta.find();
      while (cursor.hasNext()) {
        // 记录数据类型
        DBObject dbo = cursor.next();
        String name = dbo.get("_id").toString();
        String type = dbo.get("type").toString();
        String addr = dbo.get("addr").toString();
        Double max = (Double) dbo.get("max");
        Double min = (Double) dbo.get("min");
        if (type.equals("AI")) {
          map00.put(name, addr);
          m_ai_max.put(name, max);
          m_ai_min.put(name, min);
        }
        if (type.equals("DI")) {
          map01.put(name, addr);
        }
        if (type.equals("AO")) {
          map02.put(name, addr);
        }
        if (type.equals("DO")) {
          map03.put(name, addr);
        }
      }
      map1.put("AI", map00);
      map1.put("DI", map01);

      map2.put("AO", map02);
      map2.put("DO", map03);

      SerialParameters params = new SerialParameters();
      params.setCommPortId(paramNo);
      params.setBaudRate(paramBote);
      params.setDataBits(paramLength);
      params.setParity(parmParity);
      params.setStopBits(parmStopBit);
      ModbusFactory modbusFactory = new ModbusFactory();
      slave = modbusFactory.createRtuSlave(params);

      slave.addProcessImage(getModscanProcessImage(1, map00, coll));
      slave.addProcessImage(getModscanProcessImage(2, map01, coll));
      slave.addProcessImage(getModscanProcessImage(3, map02, collout));
      slave.addProcessImage(getModscanProcessImage(4, map03, collout));
      new Thread(
              new Runnable() {
                public void run() {
                  try {
                    slave.start();
                    // JOptionPane.showMessageDialog(f, "通讯连接成功!");
                  } catch (ModbusInitException e) {
                    e.printStackTrace();
                  }
                }
              })
          .start();
      ScheduledExecutorService timerRead = Executors.newScheduledThreadPool(1);
      timerRead.scheduleAtFixedRate(
          new Runnable() {
            public void run() {
              new TaskRead(map1, m_ai_max, m_ai_min, coll, slave);
            }
          },
          500,
          parmDelay,
          TimeUnit.MILLISECONDS);
      ScheduledExecutorService timerWrite = Executors.newScheduledThreadPool(2);
      timerWrite.scheduleAtFixedRate(
          new Runnable() {
            public void run() {
              new TaskWrite(map2, m_ao_max, m_ao_min, collout, slave);
            }
          },
          500,
          parmDelay,
          TimeUnit.MILLISECONDS);
    } catch (Exception ex) {
    }
  }
コード例 #19
0
ファイル: Main.java プロジェクト: kranonit/mongodb-example
  public static void main(String[] args) {
    try {
      // connect to mongoDB, ip and port number
      Mongo mongo = new Mongo("127.0.0.1", 27017);

      // get database from MongoDB,
      // if database doesn't exists, mongoDB will create it automatically
      DB db = mongo.getDB("yourdb");

      // Getting A List Of Collections
      Set<String> collections = db.getCollectionNames();

      for (String s : collections) {
        System.out.println(s);
      }

      // Get collection from MongoDB, database named "yourDB"
      // if collection doesn't exists, mongoDB will create it automatically
      DBCollection collection = db.getCollection("yourCollection");

      // create a document to store key and value
      DBObject document = new BasicDBObject();
      document.put("id", 1001);
      document.put("msg", "hello world mongoDB in Java");

      // save it into collection named "yourCollection"
      collection.insert(document);

      // search query
      DBObject searchQuery = new BasicDBObject();
      searchQuery.put("id", 1001);

      // query it
      DBCursor cursor = collection.find(searchQuery);

      // loop over the cursor and display the retrieved result
      while (cursor.hasNext()) {
        System.out.println("Our collection after putting document here: " + cursor.next());
      }

      // Counting Documents in Collection
      System.out.println("Elements in collection " + collection.getCount());

      // update document (just replase exist - it is normal practise)
      DBObject updatedDocument = new BasicDBObject();
      updatedDocument.put("id", 1001);
      updatedDocument.put("msg", "hello world mongoDB in Java updated");
      collection.update(new BasicDBObject().append("id", 1001), updatedDocument);

      // query it
      DBCursor cursorAfterUpdate = collection.find(searchQuery);

      // loop over the cursor and display the retrieved result
      while (cursorAfterUpdate.hasNext()) {
        System.out.println("Our collection after update: " + cursorAfterUpdate.next());
      }

      // Counting Documents in Collection
      System.out.println("Elements in collection " + collection.getCount());

      // Map to object
      Message message = new Message();
      message.setId((Integer) document.get("id"));
      message.setMessage((String) document.get("msg"));

      System.out.println("Id putted in object: " + message.getId());
      System.out.println("Message putted in object: " + message.getMessage());

      // Remove document from collection
      DBObject doc = collection.findOne(); // get first document
      collection.remove(doc);

      // query it
      DBCursor cursorAfterDelete = collection.find(searchQuery);

      // loop over the cursor and display the retrieved result
      while (cursorAfterDelete.hasNext()) {
        System.out.println("Our collection after delete: " + cursorAfterDelete.next());
      }

      // Counting Documents in Collection
      System.out.println("Elements in collection " + collection.getCount());

      // Close connection to db
      mongo.close();

      System.out.println("Done");

    } catch (UnknownHostException e) {
      e.printStackTrace();
    } catch (MongoException e) {
      e.printStackTrace();
    }
  }