package com.example.springbootdemo.controller;
import com.alibaba.fastjson.JSON;
import com.alibaba.fastjson.JSONArray;
import com.alibaba.fastjson.JSONObject;
import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.core.toolkit.Wrappers;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.example.springbootdemo.dao.TdictsMapper;
import com.example.springbootdemo.entity.Tdicts;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.*;
import java.util.*;
@RestController
@RequestMapping("/tdicts")
public class TdictsController {
@Autowired
private TdictsMapper tdictsMapper;
/**
* 获取前端的json列表查询指定的条件
* @param sort
* @return
*/
@PostMapping("/list")
public List<Tdicts> gettd(@RequestBody Map<String,Object> map){
QueryWrapper<Tdicts> queryWrapper = new QueryWrapper<Tdicts>();
for(String key : map.keySet()){
String value = map.get(key).toString();
if(key.equals("fname")){
queryWrapper.like(key,value);
}else if(key.equals("forder")){
queryWrapper.gt(key,value);
}else{
queryWrapper.eq(key,value);
}
}
return tdictsMapper.selectList(queryWrapper);
}
/**
* 添加产品
* @return 添加是否成功
*/
//localhost:8080/tdicts/saveTdicts?fType=衣服&fName=nk&fValue=好看的衣服&fOrder=11&fStatus=0
@GetMapping("saveTdicts")
public String saveTdicts(Tdicts tdicts){
Tdicts tdicts1 = new Tdicts();
Integer index = tdictsMapper.insert(tdicts1);
if(index>0){
return "新增产品成功。";
}else{
return "新增产品失败。";
}
}
/**
* 删除产品
* @param fId
* @return 删除是否成功
*/
//localhost:8080/tdicts/deleteTdicts?fId=6
@GetMapping("deleteTdicts")
public String deleteTdicts(Integer fId){
/**
* 批量删除
*必须在实体类的id上面加上注解@TableId,否则SQL语句中表示为null
List<Integer> list = new ArrayList<Integer>();
list.add(11);
list.add(12);
list.add(13);
Integer delete = tdictsMapper.deleteBatchIds(list);
return "删除了"+delete+"个产品";
*/
/**
*根据条件来删除
HashMap<String,Object> map = new HashMap<>(16);
map.put("ftype","数码");
map.put("fname","Jone");
Integer num = tdictsMapper.deleteByMap(map);
if(num>0){
return "删除带条件产品成功";
}else{
return "删除带条件产品成功。";
}
*/
/**
* 根据ID删除
*/
Integer index = tdictsMapper.deleteById(fId);
if(index>0){
return "删除产品成功。";
}else{
return "删除产品失败。";
}
}
/**
* 修改产品
* @return 是否修改成功
*/
//localhost:8080/tdicts/updateTdicts?fId=8&fType="衣服"&fName="ad"&fValue="好看的衣服"&fOrder=21&fStatus=1
@GetMapping("updateTdicts")
public String updateTdicts(Tdicts tdicts){
if (tdicts != null && tdicts.getFid()!=null){
Tdicts tdicts1 = tdicts;
Integer index = tdictsMapper.updateById(tdicts);
if(index>0){
return "修改产品成功。";
}else{
return "修改产品失败。";
}
}
return "无参数传入后台";
}
/**
* 根据id查询产品
* @param fId
* @return
*/
//localhost:8080/tdicts/selectTdicts?id=2
@GetMapping("selectTdicts")
public List<Tdicts> select(Integer fId){
Map map = new HashMap();
map.put("fId",fId);
return tdictsMapper.selectByMap(map);
}
/**
* 查询所有用户的数据
* @return
*/
//localhost:8080/tdicts/getTdictsList
@GetMapping("getTdictsList")
public List<Tdicts> getTdictsList(){
QueryWrapper<Tdicts> queryWrapper = new QueryWrapper<Tdicts>();
queryWrapper.eq("ftype","衣服").eq("fstatus",0) //条件查询 type=衣服,fstatus=0 ,forder 大于 1
.gt("forder",1)
//排除掉id和status字段,查询出所有字段
.select(Tdicts.class,info->!info.getColumn().equals("fid")&&!info.getColumn().equals("fstatus"));
return tdictsMapper.selectList(queryWrapper);
}
/**
* 使用lambda条件构造器查询
* @return
*/
//localhost:8080/tdicts/selectLambda
@GetMapping("selectLambda")
public List<Tdicts> selectLambda(){
//创建Lambda条件构造器的三种方式
// LambdaQueryWrapper<Tdicts> lambda = new QueryWrapper<Tdicts>().lambda();
// LambdaQueryWrapper<Tdicts> lambdaQueryWrapper = new LambdaQueryWrapper<Tdicts>();
LambdaQueryWrapper<Tdicts> lambdaQuery = Wrappers.<Tdicts>lambdaQuery();
//查询条件是:名字前面为J并且(order小于130或者status等于0),只查出id和name列的值
lambdaQuery.select(Tdicts::getFid,Tdicts::getFname).like(Tdicts::getFname,"J").and(lqw->lqw.lt(Tdicts::getForder,130).or().eq(Tdicts::getFstatus,0));
List<Tdicts> list = tdictsMapper.selectList(lambdaQuery);
return list;
}
/**
* 分页查询数据
* @return
*/
//localhost:8080/tdicts/selectTdictsPage
@GetMapping("selectTdictsPage")
public List<Tdicts> selectTdictsPage(){
QueryWrapper<Tdicts> queryWrapper = new QueryWrapper<Tdicts>();
//查询条件,根据id分组查询orderByDesc从最新添加的查起,orderByAsc从数据的第一个查起
// queryWrapper.orderByDesc("fid");
queryWrapper.orderByAsc("fid");
//设置查询的页数,也可以在后面加上false表示不查询总数,只用一条SQL语句查询分页中的数据
Page<Tdicts> page = new Page<Tdicts>(1,3);
// 系统的分页方法
IPage<Tdicts> iPage = tdictsMapper.selectPage(page,queryWrapper);
List<Tdicts> tdictsList = iPage.getRecords();
return tdictsList;
}
/**
* 自己定义的分页方法,通过sql语句多表查询
* @return
*/
//localhost:8080/tdicts/selectMyPage
@GetMapping("selectMyPage")
public List<Map<String,Object>> selectMyPage(){
QueryWrapper<Tdicts> queryWrapper = new QueryWrapper<Tdicts>();
//查询条件orderByAsc从数据的第一个查起
queryWrapper.orderByAsc("fid");
//自己定义的分页方法,通过sql语句多表查询
Page<Map<String,Object>> page1 = new Page<Map<String,Object>>(1,2,false);
List<Map<String, Object>> maps = tdictsMapper.selectTdictsPage(page1, queryWrapper);
return maps;
}
}
没有合适的资源?快使用搜索试试~ 我知道了~
资源推荐
资源详情
资源评论
收起资源包目录
水利公司项目Spring+SSH+MYsql (234个子文件)
TdictsController.class 10KB
UsersContrlloer.class 4KB
Tdicts.class 4KB
Users.class 3KB
SpringbootdemoApplicationTests.class 2KB
TdictsMapper.class 1KB
MybaitsPlusConfig.class 984B
SpringbootdemoApplication.class 851B
UsersMapper.class 322B
.classpath 1KB
mvnw.cmd 6KB
wc.db 151KB
entries 3B
format 3B
.gitignore 333B
springbootdemo.iml 9KB
springbootdemo.jar 13.94MB
maven-wrapper.jar 47KB
TdictsController.java 7KB
MavenWrapperDownloader.java 5KB
UsersContrlloer.java 4KB
TdictsMapper.java 799B
SpringbootdemoApplicationTests.java 770B
MybaitsPlusConfig.java 720B
Tdicts.java 498B
SpringbootdemoApplication.java 430B
UsersMapper.java 212B
Users.java 205B
logFile.2019-07-30.log 105KB
logFile.2019-07-29.log 87KB
HELP.md 1KB
MANIFEST.MF 91B
mvnw 9KB
org.eclipse.jdt.core.prefs 243B
org.eclipse.core.resources.prefs 155B
org.eclipse.m2e.core.prefs 90B
.project 566B
maven-wrapper.properties 116B
01782bd3a14794e9e63f8f3468827890cc8f83b0.svn-base 13.94MB
3c881fd182a431498f31678d3befbee26a63fe00.svn-base 105KB
ce5336e8dcd5ab163c27a0c3fbcf0ee824672604.svn-base 87KB
ca0763264dc2e879c0ec8f3460f35d017fd8f61c.svn-base 47KB
8c08c2280c67e458ebbcd2882625f31ef6a12566.svn-base 35KB
e2169d67da7c6697347dba5aebf608e54252f0ac.svn-base 10KB
befed283effea8deb86e9609b2df99c65fe8177a.svn-base 9KB
f1f852c13ea6ee8de6fa3f8e07a8680778c5f197.svn-base 9KB
d2da27d2815f930a505da7b8ce22ea12def91cf2.svn-base 7KB
9c6d2f7349fb906818588a912e7676ba5fa98148.svn-base 6KB
03aa42bb98146abc21ff2ec7cc363b3e26505435.svn-base 5KB
2450134711d3eb7e779346a6d47b56a26230fc2a.svn-base 5KB
7272944dc246ad01597c5733fb62b61e21814860.svn-base 4KB
43440c439aa363f2276197fcce1eba6374fd2247.svn-base 4KB
dbe2c6fe9b61e85ffa04dea0124c5c31733dc8fe.svn-base 4KB
237b3085a4601fa3dac806013c6eeeababa60a36.svn-base 3KB
fb9fea9b27c594201bfe87c60af02c71306908af.svn-base 2KB
49317105a28161640bff0ffaf1b00e6aab53e020.svn-base 2KB
8a71d6775793a7ca3100246218918747891a4cab.svn-base 1KB
2388ab88f16587d5d0bd604f2398033e6826c1e9.svn-base 1KB
0d5a92315ebefaa0bd7ccf47ff0892c9f209d98b.svn-base 984B
3e439d29dd6f91e0d25af16a3b2dbfadea2a6c8d.svn-base 895B
1cfe19822fa901262dd3bc179b12e5aa9177a59b.svn-base 851B
ab00adf01d1052f0260cb0e00ec8e0f68248eb2e.svn-base 799B
644530f7d2a63e4a9b6b319f5fe5911fdf7eda7d.svn-base 770B
692b042183e558e75cfeb579447d68f11e54d980.svn-base 769B
5ac6f7bddef984eadd95b513cb2a3beb22a2d465.svn-base 748B
160abdcaf902ded560fc80bcec9d1d7965b028e0.svn-base 741B
419d2749fceb7c13d83e3c5245727d006ed9c50c.svn-base 734B
f3f985ddb8ab7c7c748967df5c9942d0f9aef278.svn-base 729B
9aa0f30414022fec6b0b47d0dba859be6d7b79cb.svn-base 727B
b5501cadc4ad1c88a198207f344895541fcc31f1.svn-base 727B
9b0828140b0d47dc6bba16bb45273f70b2e45e21.svn-base 727B
a352e757d57baa84884457a2d4c1f47a78962f12.svn-base 720B
12ee623496192360f889789bf780ce266475a5a4.svn-base 720B
cb9cd484a8a5531f81ae35f4979b0fc4d5dd02ec.svn-base 719B
378ee51ad2ce5bccd9037a1efc55298113af722b.svn-base 700B
a0108af2a72839e3466967c7bd2b5d7a0b3bfc5c.svn-base 692B
065aa420a60a1c47fa851f863b861bd318bfeb1d.svn-base 688B
8142c3d09995bc6321f9243d97ee6afae5fb159b.svn-base 681B
d9a1805c333b4b065c1145e0579b76966d33e1f0.svn-base 674B
c01f3198332bd9021757c58613d1d893617bb84d.svn-base 671B
71e884db432c48b3d6fb1e0239dea87b1a2aba62.svn-base 660B
bf89d25c52cfd46f6132021cb0321b673c08e6ea.svn-base 658B
acc144ba538684fdf097833869ccaed097be1f8e.svn-base 644B
7c5e9d3ce5d21b7bb43a74380487142b414f88ef.svn-base 637B
966f77e92209cddf984624008fb6bd94e64e255d.svn-base 636B
66f914c1c61827304b64c346a627e4a00d0b9a60.svn-base 630B
63d89fea35afc55e99e2c3594209a0c224058f6a.svn-base 630B
58e7db94bd63a2490222837468c86a594ef58f78.svn-base 630B
2ac6c08ce6b4b31e83fdac08765e7c319df6701e.svn-base 625B
9065a78675a83c5016e36735a63f1588d6c6ef32.svn-base 623B
56cdb3a97134536244d9aca75e29c4ba44620a1e.svn-base 623B
8b46ce202577e5120c1e893e07572d67c8a7462f.svn-base 616B
a1123e7fb07ef9bf9ca6cb4567c3e9493b74dd4b.svn-base 616B
1649cf9d79ebdf31ee512e1f69ef7681874e7516.svn-base 616B
c64dcf9b2a2c9564987a13d0c996eb7e10568b23.svn-base 616B
c9526f3fa3e6387f5e76608a0d5c507700ce2fee.svn-base 611B
0fff914eb39f569b39c3f925699564d4dc3046ce.svn-base 611B
07c8dd330d20dde7b412a3f384be7355154ced9a.svn-base 611B
1eb7e86873386779f9fd8bb21fe6e75acf6213e2.svn-base 609B
bf48e793db734846a9949d4398d39687da9686b3.svn-base 609B
共 234 条
- 1
- 2
- 3
资源评论
- 秋水小夕2021-03-21适合初学者学习使用
- SingleSickMo402019-09-12非常不错,拿来就可以直接运行和使用了
ruixun8
- 粉丝: 33
- 资源: 17
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功