溫馨提示×
您好，登錄后才能下訂單哦！
點(diǎn)擊 登錄注冊(cè) 即表示同意《億速云用戶服務(wù)條款》
您好，登錄后才能下訂單哦！
SpringBoot中怎么對(duì)MongoDB 進(jìn)行增刪改查操作，針對(duì)這個(gè)問題，這篇文章詳細(xì)介紹了相對(duì)應(yīng)的分析和解答，希望可以幫助更多想解決這個(gè)問題的小伙伴找到更簡(jiǎn)單易行的方法。
引入MongoDB
<?xml version="1.0" encoding="UTF-8"?> <project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 https://maven.apache.org/xsd/maven-4.0.0.xsd"> <modelVersion>4.0.0</modelVersion> <parent> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter-parent</artifactId> <version>2.3.2.RELEASE</version> <relativePath/> <!-- lookup parent from repository --> </parent> <groupId>com.kailo</groupId> <artifactId>kailo-mongodb</artifactId> <version>0.0.1-SNAPSHOT</version> <name>kailo-mongodb</name> <description>MongoDB</description> <properties> <java.version>1.8</java.version> </properties> <dependencies> <dependency> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter</artifactId> </dependency> <dependency> <groupId>org.projectlombok</groupId> <artifactId>lombok</artifactId> <optional>true</optional> </dependency> <dependency> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter-web</artifactId> </dependency> <dependency> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter-test</artifactId> <scope>test</scope> <exclusions> <exclusion> <groupId>org.junit.vintage</groupId> <artifactId>junit-vintage-engine</artifactId> </exclusion> </exclusions> </dependency> <!-- https://mvnrepository.com/artifact/org.springframework.boot/spring-boot-starter-data-mongodb --> <dependency> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter-data-mongodb</artifactId> <version>2.3.2.RELEASE</version> </dependency> <dependency> <groupId>com.alibaba</groupId> <artifactId>fastjson</artifactId> <version>1.2.61</version> </dependency> </dependencies> <build> <plugins> <plugin> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-maven-plugin</artifactId> </plugin> </plugins> </build> </project>
添加配置文件：application.properties
server.port=8080 spring.data.mongodb.uri=mongodb://127.0.0.1:27017/xxx #spring.data.mongodb.host=127.0.0.1 #spring.data.mongodb.port=27017 #spring.data.mongodb.database=xxx # 默認(rèn)沒有賬號(hào)密碼 #spring.data.mongodb.username= #spring.data.mongodb.password=
增刪改查代碼：ProductController
@Log4j2
@RequestMapping("/product")
@RestController
public class ProductController {
private final ProductRepository productRepository;
private final MongoTemplate mongoTemplate;
@Autowired
public ProductController(ProductRepository productRepository, MongoTemplate mongoTemplate) {
this.productRepository = productRepository;
this.mongoTemplate = mongoTemplate;
}
// 增
@PostMapping("save")
public ResponseEntity<Result<Product>> save(Product product) {
if (!StringUtils.isEmpty(product.get_id())) {
return ResultUtils.error();
}
productRepository.save(product);
return ResultUtils.ok(product);
}
// 刪 單個(gè)刪除
@GetMapping("deleteById")
public ResponseEntity<Result<String>> deleteById(String id) {
if (StringUtils.isEmpty(id)) {
return ResultUtils.error();
}
productRepository.deleteById(id);
return ResultUtils.ok();
}
// 刪 批量刪除
@DeleteMapping("deleteByIds")
public ResponseEntity<Result<String>> deleteByIds(@RequestBody String[] ids) {
if (ids == null) {
return ResultUtils.error();
}
List<String> idList = Arrays.asList(ids);
Iterable<Product> deleteProducts = productRepository.findAllById((Iterable<String>) idList.iterator());
productRepository.deleteAll(deleteProducts);
return ResultUtils.ok();
}
// 改 單個(gè)
@PostMapping("update")
public ResponseEntity<Result<Product>> update(Product product) {
if (StringUtils.isEmpty(product.get_id())) {
return ResultUtils.error();
}
product = productRepository.save(product);
return ResultUtils.ok(product, "更新成功");
}
// 查 查單個(gè)
@GetMapping("findById")
public ResponseEntity<Result<Product>> findById(String id) {
Product product = productRepository.findById(id).get();
return ResultUtils.ok(product);
}
// 查 查全部列表
@GetMapping("findAll")
public ResponseEntity<Result<List<Product>>> findAll() {
List<Product> products = productRepository.findAll();
return ResultUtils.ok(products);
}
// 查 分頁(yè)查詢
@GetMapping("findPage")
public ResponseEntity<Result<Pagination<Product>>> findPage(int page, int size) {
PageRequest pageRequest = PageRequest.of(page, size, Sort.unsorted());
Page<Product> productPage = productRepository.findAll(pageRequest);
log.error(productPage.getClass());
log.error(productPage.getPageable().getClass());
return ResultUtils.ok(Pagination.from(productPage));
}
// 查 模糊查詢
@GetMapping("findByNameLike")
public ResponseEntity<Result<List<Product>>> findByNameLike(String name) {
List<Product> products = null;
if (StringUtils.isEmpty(name)) {
products = productRepository.findAll();
} else {
products = productRepository.findByNameLike(name);
}
return ResultUtils.ok(products);
}
@GetMapping("findPageByNameMongoTemplate")
public ResponseEntity<Result<List<Product>>> findPageByNameMongoTemplate(int page, int size, String name) {
Query query = new Query();
query.addCriteria(Criteria.where("name").regex(name));
List<Product> products = mongoTemplate.find(query, Product.class);
return ResultUtils.ok(products);
}
// 查 根據(jù)條件過濾
@GetMapping("findPageByNameLike")
public ResponseEntity<Result<Pagination<Product>>> findPageByNameLike(int page, int size, String name) {
if (StringUtils.isEmpty(name)) {
return ResultUtils.error();
}
PageRequest pageRequest = PageRequest.of(page, size, Sort.unsorted());
Query query = new Query();
query.addCriteria(Criteria.where("name").regex(name));
List<Product> products = mongoTemplate.find(query, Product.class);
long total = mongoTemplate.count(query, Product.class);
return ResultUtils.ok(Pagination.build(products, total, pageRequest));
}
}相關(guān)代碼
@Data
@Document(value = "xxx")
public class Product implements Serializable {
@Id
@JSONField(name="_id") // fastjson 會(huì)過濾 _
private String _id;
@Field
private String name;
@Field
private String user;
@Field
private Double ccc;
}public interface ProductRepository extends MongoRepository<Product, String> {
List<Product> findByNameLike(String name);
}分頁(yè)相關(guān)：不用自帶的Page，自定義Pagination，解決序列化和反序列化問題
@Data
public class Pagination<T> implements Serializable {
private long total;
private List<T> content = new ArrayList();
private PaginationRequest pageable;
public Pagination() {
}
public long getTotal() {
return this.total;
}
/**
* 根據(jù)Page，轉(zhuǎn)化成 Pagination
*
* @param page
* @param <T>
* @return
*/
public static <T> Pagination<T> from(Page<T> page) {
if (page == null) {
return new Pagination<>();
}
return build(page.getContent(), page.getTotalElements(), page.getPageable());
}
/**
* 根據(jù)參數(shù)，初始化 Pagination
*
* @param content
* @param totalElements
* @param pageable
* @param <T>
* @return
*/
public static <T> Pagination<T> build(List<T> content, long totalElements, Pageable pageable) {
Pagination<T> pageResult = new Pagination<>();
pageResult.setTotal(totalElements);
pageResult.setContent(content);
pageResult.setPageable(PaginationRequest.from(pageable));
return pageResult;
}
public int getTotalPages() {
return this.getSize() == 0 ? 1 : (int) Math.ceil((double) this.total / (double) this.getSize());
}
public long getTotalElements() {
return this.total;
}
public boolean hasNext() {
return this.getNumber() + 1 < this.getTotalPages();
}
public int getNumber() {
return this.pageable.getPageNumber();
}
public int getSize() {
return this.pageable.getPageSize();
}
public int getNumberOfElements() {
return this.content.size();
}
public boolean hasPrevious() {
return this.getNumber() > 0;
}
public boolean isFirst() {
return !this.hasPrevious();
}
public boolean isLast() {
return !this.hasNext();
}
public PaginationRequest nextPageable() {
return this.hasNext() ? this.pageable.next() : null;
}
public PaginationRequest previousPageable() {
return this.hasPrevious() ? this.pageable.previousOrFirst() : null;
}
public boolean hasContent() {
return !this.content.isEmpty();
}
public List<T> getContent() {
return Collections.unmodifiableList(this.content);
}
public Iterator<T> iterator() {
return this.content.iterator();
}
}@Data
public class PaginationRequest implements Serializable {
private int page;
private int size;
public PaginationRequest() {}
public PaginationRequest(int page, int size) {
this.page = page;
this.size = size;
}
public static PaginationRequest from(Pageable pageable) {
Sort sort = pageable.getSort();
return new PaginationRequest(pageable.getPageNumber(), pageable.getPageSize() );
}
public PaginationRequest next() {
return new PaginationRequest(this.getPageNumber() + 1, this.getPageSize());
}
public PaginationRequest previous() {
return this.getPageNumber() == 0 ? this : new PaginationRequest(this.getPageNumber() - 1, this.getPageSize());
}
public PaginationRequest first() {
return new PaginationRequest(0, this.getPageSize());
}
public int getPageSize() {
return this.size;
}
public int getPageNumber() {
return this.page;
}
public long getOffset() {
return (long)this.page * (long)this.size;
}
public boolean hasPrevious() {
return this.page > 0;
}
public PaginationRequest previousOrFirst() {
return this.hasPrevious() ? this.previous() : this.first();
}
}@Data
public class Result<T> implements Serializable {
private int code;
private String message;
private T data;
private long timestamp = Date.from(Instant.now()).getTime();
}@Data
public class ResultUtils implements Serializable {
public static final int SUCCESS = 200;
public static final int NOT_FOUND = 404;
public static final int ERROR = 500;
public static final String OPT_SUCCESS_LANG = "操作成功";
public static final String OPT_ERROR_LANG = "操作失敗";
public static <T> ResponseEntity<Result<T>> ok() {
return ok(OPT_SUCCESS_LANG);
}
public static <T> ResponseEntity<Result<T>> ok(String message) {
return ok(null, message);
}
public static <T> ResponseEntity<Result<T>> ok(T data) {
return ok(data, null);
}
public static <T> ResponseEntity<Result<T>> ok(T data, String message) {
Result<T> result = new Result<>();
result.setCode(SUCCESS);
result.setMessage(message);
result.setData(data);
return ResponseEntity.ok(result);
}
public static <T> ResponseEntity<Result<T>> error() {
return ok(OPT_ERROR_LANG);
}
public static <T> ResponseEntity<Result<T>> error(String message) {
return ok(null, message);
}
public static <T> ResponseEntity<Result<T>> error(T data) {
return ok(data, null);
}
public static <T> ResponseEntity<Result<T>> error(T data, String message) {
Result<T> result = new Result<>();
result.setCode(ERROR);
result.setMessage(message);
result.setData(data);
return ResponseEntity.ok(result);
}
}關(guān)于SpringBoot中怎么對(duì)MongoDB 進(jìn)行增刪改查操作問題的解答就分享到這里了，希望以上內(nèi)容可以對(duì)大家有一定的幫助，如果你還有很多疑惑沒有解開，可以關(guān)注億速云行業(yè)資訊頻道了解更多相關(guān)知識(shí)。
免責(zé)聲明：本站發(fā)布的內(nèi)容（圖片、視頻和文字）以原創(chuàng)、轉(zhuǎn)載和分享為主，文章觀點(diǎn)不代表本網(wǎng)站立場(chǎng)，如果涉及侵權(quán)請(qǐng)聯(lián)系站長(zhǎng)郵箱：is@yisu.com進(jìn)行舉報(bào)，并提供相關(guān)證據(jù)，一經(jīng)查實(shí)，將立刻刪除涉嫌侵權(quán)內(nèi)容。
億速云公眾號(hào)
手機(jī)網(wǎng)站二維碼