spring boot——集成mongodb——入门示例

数据库：biancheng

新增集合以及文档：

> db.createCollection("user")
{ "ok" : 1 }
> db.user.insert({name:'ceshi',age:22,sex:'nv'})
WriteResult({ "nInserted" : 1 })
>

=========================================================

pom文件中，主要新增如下依赖：

<dependency>
   <groupId>org.springframework.boot</groupId>
   <artifactId>spring-boot-starter-data-mongodb</artifactId>
</dependency>

下面的pom文件，基于之前的几个项目：

<?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 http://maven.apache.org/xsd/maven-4.0.0.xsd">
  <modelVersion>4.0.0</modelVersion>

  <groupId>org.example</groupId>
  <artifactId>anxinfu</artifactId>
  <version>1.0-SNAPSHOT</version>
  <packaging>war</packaging>

  <name>anxinfu Maven Webapp</name>
  <!-- FIXME change it to the project's website -->
  <url>http://www.example.com</url>

  <properties>
    <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
    <maven.compiler.source>1.7</maven.compiler.source>
    <maven.compiler.target>1.7</maven.compiler.target>
  </properties>

  <parent>
    <groupId>org.springframework.boot</groupId>
    <artifactId>spring-boot-starter-parent</artifactId>
    <version>2.4.5</version>
    <relativePath/> <!-- lookup parent from repository -->
  </parent>


  <dependencies>
    <dependency>
      <groupId>org.springframework.boot</groupId>
      <artifactId>spring-boot-starter-jdbc</artifactId>
    </dependency>
    <dependency>
      <groupId>org.springframework.boot</groupId>
      <artifactId>spring-boot-starter-web</artifactId>
      <!-- 去掉默认的日志配置 -->
      <exclusions>
        <exclusion>
          <groupId>org.springframework.boot</groupId>
          <artifactId>spring-boot-starter-logging</artifactId>
        </exclusion>
      </exclusions>
    </dependency>
    <dependency>
      <groupId>org.mybatis.spring.boot</groupId>
      <artifactId>mybatis-spring-boot-starter</artifactId>
      <version>2.1.1</version>
    </dependency>
    <dependency>
      <groupId>mysql</groupId>
      <artifactId>mysql-connector-java</artifactId>
      <scope>runtime</scope>
    </dependency>
    <!-- 依赖Spring Boot Data Redis -->
    <!-- 依赖Spring Boot Data Redis -->
    <dependency>
      <groupId>org.springframework.boot</groupId>
      <artifactId>spring-boot-starter-data-redis</artifactId>
      <exclusions>
        <exclusion>
          <groupId>io.lettuce</groupId>
          <artifactId>lettuce-core</artifactId>
        </exclusion>
      </exclusions>
    </dependency>

    <!--对象池化组件，配合Java客户端JedisPool使用-->
    <dependency>
      <groupId>org.apache.commons</groupId>
      <artifactId>commons-pool2</artifactId>
    </dependency>

    <!--jedis的jar包-->
    <dependency>
      <groupId>redis.clients</groupId>
      <artifactId>jedis</artifactId>
      <version>3.3.0</version>
    </dependency>


    <!-- 引入log4j2依赖 -->
    <dependency>
      <groupId>org.springframework.boot</groupId>
      <artifactId>spring-boot-starter-log4j2</artifactId>
    </dependency>

    <dependency>
      <groupId>org.springframework.boot</groupId>
      <artifactId>spring-boot-starter-data-mongodb</artifactId>
    </dependency>

  </dependencies>

  <build>
    <finalName>anxinfu</finalName>
    <pluginManagement><!-- lock down plugins versions to avoid using Maven defaults (may be moved to parent pom) -->
      <plugins>
        <plugin>
          <artifactId>maven-clean-plugin</artifactId>
          <version>3.1.0</version>
        </plugin>
        <!-- see http://maven.apache.org/ref/current/maven-core/default-bindings.html#Plugin_bindings_for_war_packaging -->
        <plugin>
          <artifactId>maven-resources-plugin</artifactId>
          <version>3.0.2</version>
        </plugin>
        <plugin>
          <artifactId>maven-compiler-plugin</artifactId>
          <version>3.8.0</version>
        </plugin>
        <plugin>
          <artifactId>maven-surefire-plugin</artifactId>
          <version>2.22.1</version>
        </plugin>
        <plugin>
          <artifactId>maven-war-plugin</artifactId>
          <version>3.2.2</version>
        </plugin>
        <plugin>
          <artifactId>maven-install-plugin</artifactId>
          <version>2.5.2</version>
        </plugin>
        <plugin>
          <artifactId>maven-deploy-plugin</artifactId>
          <version>2.8.2</version>
        </plugin>
      </plugins>
    </pluginManagement>
  </build>
</project>

application.properties文件中新增如下信息：

# mongodb\u914D\u7F6E
spring.data.mongodb.uri=mongodb://localhost/biancheng
spring.data.mongodb.database=biancheng

注意：本机安装的数据库。biancheng是数据库名

domain包中新增：

UserDTO

package com.test.domain;


import com.fasterxml.jackson.annotation.JsonFormat;
import org.bson.types.ObjectId;
import org.springframework.data.annotation.Id;
import org.springframework.data.mongodb.core.mapping.Document;
import org.springframework.data.mongodb.core.mapping.Field;

import java.io.Serializable;
import java.util.Date;


@Document()
public class UserDTO implements Serializable {

    //标识集合中的“_id”字段
    @Id
    private ObjectId _id;
    //指定自定义文档的字段名
    @Field("name")
    private String name;
    @Field("age")
    private int age;
    @Field("sex")
    private String sex;

    public ObjectId getId() {
        return _id;
    }

    public void setId(ObjectId id) {
        this._id = id;
    }

    public String getName() {
        return name;
    }

    public void setName(String name) {
        this.name = name;
    }

    public int getAge() {
        return age;
    }

    public void setAge(int age) {
        this.age = age;
    }

    public String getSex() {
        return sex;
    }

    public void setSex(String sex) {
        this.sex = sex;
    }


}

服务层，新增：

UserService2

package com.test.service;

import com.mongodb.client.result.DeleteResult;
import com.mongodb.client.result.UpdateResult;
import com.test.domain.UserDTO;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.data.mongodb.core.MongoTemplate;
import org.springframework.data.mongodb.core.query.Criteria;
import org.springframework.data.mongodb.core.query.Query;
import org.springframework.data.mongodb.core.query.Update;
import org.springframework.stereotype.Service;

import java.util.List;


@Service
public class UserService2 {

    @Autowired
    private MongoTemplate mongoTemplate;

    /**
     * 新增
     * @param userDTO
     * @return
     */
    public UserDTO insert(UserDTO userDTO){
        //insert方法并不提供级联类的保存，所以级联类需要先自己先保存
        return mongoTemplate.insert(userDTO,"user");
    }

    /**
     * 修改
     * @param userDTO
     * @return
     */
    public UpdateResult updateResult(UserDTO userDTO){
        //构造更新条件，根据主键id更新
        Query query = new Query();
        query.addCriteria(Criteria.where("id").is(userDTO.getId()));
        //设置更新内容
        Update update = new Update();
        update.set("name",userDTO.getName());
        update.set("age",userDTO.getAge());
        update.set("sex",userDTO.getSex());
        //指定查询collectionName集合中的记录，相当于表名区分大小写，然后根据id更新数据
        return mongoTemplate.updateFirst(query,update,UserDTO.class,"user");
    }

    /**
     * 删除
     * @param id
     * @return
     */
    public DeleteResult deleteResult(Integer id){
        Query query = new Query();
        query.addCriteria(Criteria.where("id").is(id));
        //指定查询collectionName集合中的记录，相当于表名区分大小写，然后根据id删除数据
        return mongoTemplate.remove(query,UserDTO.class,"user");
    }

    /**
     * 查询所有
     * @return
     */
    public List<UserDTO> findAll() {
        //指定查询collectionName集合中的记录，相当于表名区分大小写
        //如果没有collectionName会先到缓存中根据classname获取集合名，如果还没有则新建一个集合名（类名首字母小写）
        return mongoTemplate.findAll(UserDTO.class,"user");
    }

    /**
     * 获取单条
     * @param id
     * @return
     */
    public UserDTO getOneById(Integer id) {
        return mongoTemplate.findById(id,UserDTO.class,"user");
    }
}

访问控制层：

UserController

package com.test.controller;

import com.mongodb.client.result.DeleteResult;
import com.mongodb.client.result.UpdateResult;
import com.test.domain.UserDTO;
import com.test.service.UserService;
import com.test.service.UserService2;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.*;

import java.util.List;


@RestController
public class UserController {

    @Autowired
    private UserService2 userService;

    @GetMapping("/findAll")
    public List<UserDTO> findAll(){
        return userService.findAll();
    }

    @GetMapping("/get/{id}")
    public UserDTO getOne(@PathVariable Integer id){
        return userService.getOneById(id);
    }

    @PostMapping("/save")
    public UserDTO save(@RequestBody UserDTO userDTO){
        return userService.insert(userDTO);
    }

    @PostMapping("/update")
    public UpdateResult update(@RequestBody UserDTO userDTO){
        return userService.updateResult(userDTO);
    }

    @DeleteMapping("/delete/{id}")
    public DeleteResult update(@PathVariable Integer id){
        return userService.deleteResult(id);
    }

}

http://localhost:8080/findAll

posted @ 2022-05-28 19:27 小白龙白龙马阅读(167) 评论(0) 收藏举报

刷新页面返回顶部