第一章: MongoDB学习(一) 详细安装教程 win10
第二章:MongoDB学习(二)sql语法
第三章:MongoDB学习(三)SpringBoot整合MongoDB
MongoDB学习(三)SpringBoot整合MongoDB
- MongoDB 学习
- 引入依赖 pom.xml
- 配置文件 application.yml
- 添加实体类
- 添加配置类
- Repository
- Service
- Controller
引入依赖 pom.xml
配置文件 application.ymlorg.springframework.boot spring-boot-starter-data-mongodb
spring:
data:
mongodb:
host: localhost
port: 27017
database: test
添加实体类
@Document 文档
@Id 主键
@Field 域
@Indexed 索引
@Data
@Document(collection = "student")
public class Student implements Serializable {
@Id
private String id;
private String name;
private Integer age;
@Field(name = "class")
private String classes;
private List grade;
}
添加配置类
import org.springframework.beans.factory.annotation.Autowired; import org.springframework.context.ApplicationListener; import org.springframework.context.annotation.Configuration; import org.springframework.context.event.ContextRefreshedEvent; import org.springframework.data.mongodb.core.MongoTemplate; import org.springframework.data.mongodb.core.convert.DefaultMongoTypeMapper; import org.springframework.data.mongodb.core.convert.MappingMongoConverter; import org.springframework.data.mongodb.core.convert.MongoConverter; @Configuration public class ApplicationReadyListener implements ApplicationListenerRepository{ @Autowired MongoTemplate mongoTemplate; private static final String TYPEKEY = "_class"; @Override public void onApplicationEvent(ContextRefreshedEvent contextRefreshedEvent) { MongoConverter converter = mongoTemplate.getConverter(); if (converter.getTypeMapper().isTypeKey(TYPEKEY)) { ((MappingMongoConverter) converter).setTypeMapper(new DefaultMongoTypeMapper(null)); } } }
import com.practice.entity.Student; import org.springframework.data.domain.Page; import org.springframework.data.domain.Pageable; import org.springframework.data.mongodb.repository.MongoRepository; import org.springframework.data.mongodb.repository.Query; import org.springframework.stereotype.Repository; import java.util.List; @Repository public interface StudentRepository extends MongoRepositoryService{ public List findByName(String name); public List findByNameLike(String name); @Query(value = "{id:?0}",fields = "{'name':1,'age':1}") public Student findNameAndAgeById(String id); @Query(value = "{name:{$regex:?0}}",fields = "{'name':1,'age':1}") public Page findByNameLike(String name, Pageable pageRequest); }
public interface StudentService {
void find();
void insert(Student student);
void batchInsert(List students);
void update(Student student);
void batchUpdate(List students);
void delete(String id);
void batchDelete(List ids);
}
@Service
public class StudentServiceImpl implements StudentService {
@Autowired
private StudentRepository studentRepository;
@Autowired
private MongoTemplate mongoTemplate;
@Override
public void find() {
//1. 全部查询
List allList = studentRepository.findAll();
System.out.println("----全部查询----"+allList);
//2. 根据 name = '小红' 查询
List byName = studentRepository.findByName("小红");
System.out.println("----根据 name = '小红' 查询----"+byName);
//3. 根据 name like '小%' 查询
List byNameLike = studentRepository.findByNameLike("小");
System.out.println("----根据 name like '小%' 查询----"+byNameLike);
//4. 根据 age 正序 查询
Sort sort = Sort.by(Sort.Direction.ASC, "age");
List ageSort = studentRepository.findAll(sort);
System.out.println("----根据 age 正序 查询----"+ageSort);
//5. 分页查询
Pageable pageRequest = PageRequest.of(0, 5);
Page page = studentRepository.findAll(pageRequest);
System.out.println("----根据 page=1,size=5 查询----"+page);
//6. 条件查询并分页
Page studentPage = studentRepository.findByNameLike("小",pageRequest);
System.out.println("----只查询name和age并分页----"+studentPage);
//7. 查询总数
long count = studentRepository.count();
System.out.println("----总条数为----"+count);
Student student = new Student();
student.setName("小");
ExampleMatcher matcher = ExampleMatcher.matching()
.withMatcher("name", ExampleMatcher.GenericPropertyMatchers.startsWith());
long count1 = studentRepository.count(Example.of(student, matcher));
System.out.println("----名字以’小‘开头的条数为----"+count1);
//8. 只查询name和age
Student nameAndAgeById = studentRepository.findNameAndAgeById("62a1beb0345f0000ab005e17");
System.out.println("----只查询name和age----"+nameAndAgeById);
//9. 分组查询
Aggregation aggregation = Aggregation.newAggregation(
// Aggregation.match(),
Aggregation.group("classes","age").count().as("count"),
Aggregation.project("count").andInclude("classes","age")
);
List
Controller
@RestController
@RequestMapping("/student")
public class StudentController {
@Autowired
private StudentService studentService;
@GetMapping("/find")
public void find(){
studentService.find();
}
@PostMapping("/insert")
public void insert(@RequestBody Student student){
studentService.insert(student);
}
@PostMapping("/batchInsert")
public void batchInsert(@RequestBody List students){
studentService.batchInsert(students);
}
@PostMapping("/update")
public void update(@RequestBody Student student){
studentService.update(student);
}
@PostMapping("/batchUpdate")
public void batchUpdate(@RequestBody List students){
studentService.batchUpdate(students);
}
@DeleteMapping("/delete/{id}")
public void delete(@PathParam("id") String id){
studentService.delete(id);
}
@DeleteMapping("/batchDelete")
public void batchDelete(@RequestBody List ids){
studentService.batchDelete(ids);
}
}



