mongodb和java
加依赖
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-data-mongodb</artifactId>
</dependency>
加配置
spring:
data:
mongodb:
host: 127.0.0.1
database: haozidb
port: 27017
#也可以使用uri
#uri: mongodb://127.0.0.1:27017/haozidb
代码
由于mongodb结构是松散的,所以存在一个集合对应多个实体类的情况。按需创建就行。
//collection:集合名字
@Document(collection = "eat") //可省略,省略就默认使用类名小写映射集合
//添加一个复合索引(最好用mongo命令行的方式创建
@CompoundIndex(def = "{'foodid': 1, 'name': -1}")
@Data
public class HaoziEat {
@Id //主键,如果字段属性名就叫id,也可省略
private String id;
private String name;
private Integer num;
@Field("eattime") //对应mongodb字段的名字,如果一致可不写
private LocalDateTime eatTime;
private Double price;
@Field("islike")
private Boolean isLike;
private String content;
@Indexed //添加一个单字段索引
private String foodid;
private Date createtime;
}
public interface EatRepository extends MongoRepository<HaoziEat , String> {
}
@Service
public class EatService {
@Autowired
private EatRepository eatRepository;
public void saveEatList(List<HaoziEat> eatList){
eatRepository.saveAll(eatList);
}
//保存或更新
//需要注意的是,如果是修改,这里是覆盖修改。因此如果要修改某一个值,最好先全部查出来,再去改
public void saveEat(HaoziEat eat){
eatRepository.save(eat);
}
public void deleteById(String id){
eatRepository.deleteById(id);
}
public List<HaoziEat> findAll(){
return eatRepository.findAll();
}
public HaoziEat findById(String id){
return eatRepository.findById(id).get();
}
}
@RunWith(SpringRunner.class)
@SpringBootTest
public class EatServiceTest {
@Autowired
private EatService eatService;
@Test
public void save(){
HaoziEat haoziEat1 = HaoziEat.builder()
.name("蛋糕1")
.num(1)
.price(88.88)
.isLike(true)
.content("好吃")
.foodid("1")
.createtime(new Date())
.build();
HaoziEat haoziEat2 = HaoziEat.builder()
.name("蛋糕2")
.num(2)
.price(33.2)
.isLike(true)
.content("好吃")
.foodid("2")
.createtime(new Date())
.build();
HaoziEat haoziEat3 = HaoziEat.builder()
.name("蛋糕3")
.num(3)
.price(55.3)
.isLike(false)
.content("难吃")
.foodid("3")
.createtime(new Date())
.build();
HaoziEat haoziEat4 = HaoziEat.builder()
.name("蛋糕4")
.num(4)
.price(77.7)
.isLike(true)
.content("好吃")
.foodid("4")
.createtime(new Date())
.build();
List<HaoziEat> haoziEatList = new ArrayList<>();
haoziEatList.add(haoziEat1);
haoziEatList.add(haoziEat2);
haoziEatList.add(haoziEat3);
haoziEatList.add(haoziEat4);
eatService.saveEatList(haoziEatList);
}
@Test
public void testFindAll(){
System.out.println(eatService.findAll());
}
@Test
public void testUpdate(){
HaoziEat haoziEat4 = HaoziEat.builder()
.id("60dee0e311707237937eb9b6")
.name("蛋糕7")
.num(47)
.eatTime(LocalDateTime.now())
.build();
eatService.saveEat(haoziEat4);
}
@Test
public void getOne(){
System.out.println(eatService.findById("60dee0e311707237937eb9b3"));
}
}
关于service做了简化,且还有很多接口没有写进去,可以自己去看CrudRepository
上述是一些基本的介绍,如果想用条件查询,需要自己写下:
EatRepository中
public interface EatRepository extends MongoRepository<HaoziEat , String> {
//注意findByFoodid,查询哪个字段就要这么写
Page<HaoziEat> findByFoodid(String foodid, Pageable pageable);
}
service的方法:
public Page<HaoziEat> findFoodListById(String foodid, int page , int size){
return eatRepository.findByFoodid(foodid , PageRequest.of(page - 1, size));
}
测试一下:
@Test
public void getByFoodid(){
Page<HaoziEat> page = eatService.findFoodListById("1", 1, 2);
System.out.println(page.getContent());
}
在前面我们知道,mongodb支持自增
需要引入MongoTemplate,这是一个包装工具类,里面有很多包括增删改查在内的方法可使用,详细的自己去看。
service中添加
@Autowired
private MongoTemplate mongoTemplate;
public void updateFoodNum(String id){
//查询条件
Query query = Query.query(Criteria.where("_id").is(id));
//更新条件
Update update = new Update();
update.inc("num");
mongoTemplate.updateFirst(query , update , HaoziEat.class);
}