springboot+mongodb整合

实体类代码

package com.scz.biz.controller.assetsController.bean;

import com.fasterxml.jackson.annotation.JsonProperty;
import com.scz.biz.common.bean.DBBaseBean;
import lombok.Data;
import org.springframework.data.mongodb.core.mapping.Document;
import org.springframework.data.mongodb.core.mapping.Field;

import java.util.ArrayList;

@Data
@Document(collection = "biz_order")
public class DBorderBean {

    private String c_belong_to;

    private String c_belong_to_subject;
}

下面是controller类代码，注入工具类

@Autowired
private ToolBean toolBean;

/**
     * 查询  返回第一条记录
     * @return
     */
    @RequestMapping("/ceshi_query")
    public DBorderBean ceshi_query(){
        DBorderBean c_belong_to = toolBean.query("_id", "5fb24c");
        return c_belong_to ;
    }

    /**
     * 修改
     * @return
     * @throws Exception
     */
    @RequestMapping("/ceshi_update")
    public UpdateResult ceshi_update() throws Exception {
        DBorderBean dBorderBean = new DBorderBean();
        dBorderBean.setO_addr_phone("122");
        dBorderBean.setO_addr("");
        UpdateResult result = toolBean.update("_id", "06d29de14ac8894b6aa37",dBorderBean);
        return result ;
    }

    /**
     * 根据条件查询全部
     * @return
     */
    @RequestMapping("/query_list")
    public List<DBorderBean> query_list(){
        List<DBorderBean> querylist = toolBean.querylist("c_belong_to", "01aacbc81b244e");
        return querylist ;
    }

    /**
     * 新增
     */
    @RequestMapping("/save_one")
    public DBorderBean save_list(@RequestBody JSONObject jsonObject){
        DBorderBean dBorderBean =new DBorderBean();
        String c_belong_to = jsonObject.getString("c_belong_to");
        String c_belong_to_subject = jsonObject.getString("c_belong_to_subject");
        dBorderBean.setBelongTo(c_belong_to);
        dBorderBean.setBelongToSubject(c_belong_to_subject);
        
        return toolBean.save(dBorderBean);
    }

    /**
     * 删除
     */
    @RequestMapping("/del_one")
    public DeleteResult del_one(){
        DeleteResult result = toolBean.del("c_belong_to", "111");
        return result ;
    }

工具类代码

package com.scz.biz.controller.assetsController.bean;

import com.jfinal.plugin.activerecord.Db;
import com.mongodb.client.result.DeleteResult;
import com.mongodb.client.result.UpdateResult;
import com.sun.org.apache.regexp.internal.REUtil;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.beans.factory.annotation.Value;
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.Repository;


import java.lang.reflect.Field;
import java.sql.Savepoint;
import java.util.List;
import java.util.Objects;
@Repository
public class ToolBean {
    @Autowired
    private MongoTemplate mongoTemplate;

    /**
     * 查询 订单表 满足条件的第一个对象
     * @param canshu
     * @param zhi
     * @return
     */
    public DBorderBean query(String canshu,String zhi){
        Query query=new Query(Criteria.where(canshu).is(zhi));
        DBorderBean mgt =  mongoTemplate.findOne(query , DBorderBean.class);
        return mgt;
    }

    /**
     *查询 订单表 满足条件的集合
     */
    public List<DBorderBean> querylist(String canshu,String zhi){
        Query query=new Query(Criteria.where(canshu).is(zhi));
        List<DBorderBean> dBorderBeans = mongoTemplate.find(query, DBorderBean.class);
        return dBorderBeans;
    }

    /**
     * 修改
     * @param canshu
     * @param zhi
     * @return
     */
    public UpdateResult update(String canshu,String zhi,DBorderBean db) throws Exception {
        Query query=new Query(Criteria.where(canshu).is(zhi));
        //findOne()返回一个文档满足指定的查询条件。如果多个文档满足查询,该方法返回第一个文档根据自然秩序反映了磁盘上文件的顺序
        DBorderBean mgt =  mongoTemplate.findOne(query , DBorderBean.class);
        Update update= new Update();
        //
        Field[] fields = db.getClass().getDeclaredFields();
        for (Field field : fields) {
            field.setAccessible(true);
            if(field.get(db)!=null){
                update.set(field.getName(),field.get(db));
            }
        }
        UpdateResult result =mongoTemplate.updateFirst(query,update,DBorderBean.class);

        return result;
    }

    /**
     * 新增
     */
    public DBorderBean save(DBorderBean dBorderBean){
        DBorderBean result = mongoTemplate.save(dBorderBean);
        return result;
    }

    /**
     * 删除
     * @param canshu
     * @param zhi
     * @return
     */
    public DeleteResult del(String canshu,String zhi ){
        Query query=new Query(Criteria.where(canshu).is(zhi));
        DeleteResult result = mongoTemplate.remove(query,DBorderBean.class);
        return result;
    }
}