#拉取镜像
docker pull mongo:latest
#创建和启动容器
docker run -d --restart=always -p 27017:27017 --name mymongo -v /data/db:/data/db -d mongo
配置文件
spring.data.mongodb.uri=mongodb://192.168.56.10:27017/test
实体类
@Data
@Document("User")
public class User {
@Id//自动生成_id
private String id;
private String name;
private Integer age;
private String email;
private String createDate;
}
代码操作第一种方法
@SpringBootTest
class MongodbApplicationTests {
//注入mongoTemplate
@Autowired
private MongoTemplate mongoTemplate ;
@Test
void contextLoads() {
}
@Test
public void create(){
User user = new User() ;
user.setAge(20);
user.setName("test");
user.setEmail("123@qq..com");
User insert = mongoTemplate.insert(user);
System.out.println(insert);
}
@Test
public void findAll(){
List<User> all = mongoTemplate.findAll(User.class);
System.err.println(all);
}
//id查询你
@Test
public void findId(){
User byId = mongoTemplate.findById("61e4297b6428a43fc0e64185", User.class);
System.out.println("byId:"+byId);
}
//条件查询
@Test
public void findUserList(){
Query query = new Query(Criteria.where("name").is("test").and("age").is(20)) ;
List<User> list = mongoTemplate.find(query, User.class);
System.err.println(list);
}
//模糊查询
@Test
public void findLikeUserList(){
String name = "est";
String regex = String.format("%s%s%s", "^.*", name, ".*$");
Pattern pattern = Pattern.compile(regex,Pattern.CASE_INSENSITIVE);
Query query = new Query(Criteria.where("name").regex(pattern)) ;
List<User> list = mongoTemplate.find(query, User.class);
System.err.println(list);
}
//分页查询
@Test
public void findPageUserList(){
int pageNum = 1 ;
int pageSize = 3 ;
String name = "";
//条件构建
String regex = String.format("%s%s%s", "^.*", name, ".*$");
Pattern pattern = Pattern.compile(regex,Pattern.CASE_INSENSITIVE);
Query query = new Query(
Criteria.where("name").regex(pattern)) ;
// 分页构建
// 查询记录数
long count = mongoTemplate.count(query, User.class);
List<User> users = mongoTemplate.find(query.skip((pageNum - 1) * pageSize).limit(pageSize), User.class);
System.err.println(count);
System.err.println(users);
}
//修改
@Test
public void updateUser(){
//根据id查询
User user = mongoTemplate.findById("61e2eb3d56ed8ef9c55a308f", User.class);
//设置修改值
// user.setName("list");
user.setAge(50);
user.setEmail("971572657@qq.com");
Query query = new Query(Criteria.where("_id").is(user.getId()));
Update update = new Update();
// update.set("name", user.getName());
update.set("age", user.getAge());
update.set("email", user.getEmail());
UpdateResult result = mongoTemplate.upsert(query, update, User.class);
long count = result.getModifiedCount();
System.out.println(count);
}
//删除操作
@Test
public void delete() {
Query query =
new Query(Criteria.where("_id").is("61e2eb3d56ed8ef9c55a308f"));
DeleteResult result = mongoTemplate.remove(query, User.class);
long count = result.getDeletedCount();
System.out.println(count);
}
}
第二中方法
public interface UserRepository extends MongoRepository<User,String> {
}
@SpringBootTest
class MongodbApplicationTests1 {
//注入mongoTemplate
@Autowired
private UserRepository userRepository;
@Test
void contextLoads() {
}
//添加操作
@Test
public void create(){
User user = new User() ;
user.setAge(30);
user.setName("mary");
user.setEmail("123@qq..com");
User insert = userRepository.save(user);
System.out.println(insert);
}
@Test
public void findAll(){
List<User> all = userRepository.findAll();
System.out.println(all);
}
//id查询你
@Test
public void findId(){
User user = userRepository.findById("61e43d1b105ed67beeab5cf9").get();
System.out.println(user);
}
//条件查询
@Test
public void findUserList(){
User user = new User() ;
user.setAge(20);
// user.setName();
Example<User> userExample = Example.of(user);
List<User> all = userRepository.findAll(userExample);
System.out.println(all);
}
//模糊查询
@Test
public void findLikeUserList(){
//设置模糊查询匹配规则
ExampleMatcher matcher = ExampleMatcher.matching()
.withStringMatcher(ExampleMatcher.StringMatcher.CONTAINING)
.withIgnoreCase(true);
User user = new User() ;
// user.setAge(20);
user.setName("m");
Example<User> userExample = Example.of(user,matcher);
List<User> all = userRepository.findAll(userExample);
System.out.println(all);
}
//分页查询
@Test
public void findPageUserList(){
// 设置分页参数
// 0代表第一页
Pageable pageable = PageRequest.of(0,3) ;
User user = new User();
user.setName("mary");
Example<User> userExample = Example.of(user);
Page<User> page = userRepository.findAll(userExample, pageable);
System.out.println(page);
}
//修改
@Test
public void updateUser(){
//根据id查询
User user = userRepository.findById("61e4297b6428a43fc0e64185").get();
//设置修改值
// user.setName("list");
user.setAge(500);
user.setEmail("971572657@qq.com");
User save = userRepository.save(user);
System.out.println(save);
}
//删除操作
@Test
public void delete() {
userRepository.deleteById("61e4297b6428a43fc0e64185");
}
}