java like查询 mongodb,如何使用java api查询“like”的mongodb？

this question is very similar to another post

I basically want to use the mongodb version of the sql "like" '%m%' operator

but in my situation i'm using the java api for mongodb, while the other post is using mongodb shell

i tried what was posted in the other thread and it worked fine

db.users.find({"name": /m/})

but in java, i'm using the put method on the BasicDBObject and passing it into the find() method on a DBCollections object

BasicDBObject q = new BasicDBOBject();

q.put("name", "/"+m+"/");

dbc.find(q);

but this doesn't seem to be working.

anyone has any ideas?

解决方案

You need to pass an instance of a Java RegEx (java.util.regex.Pattern):

BasicDBObject q = new BasicDBObject();

q.put("name", java.util.regex.Pattern.compile(m));

dbc.find(q);

This will be converted to a MongoDB regex when sent to the server, as well as any RegEx flags.