基于javaweb+mysql的ssm电器商城系统(java+ssm+jsp+bootstrap+echarts+mysql)
私信源码获取及调试交流
运行环境
Java≥8、MySQL≥5.7、Tomcat≥8
开发工具
eclipse/idea/myeclipse/sts等均可配置运行
适用
课程设计,大作业,毕业设计,项目练习,学习演示等
功能说明
基于javaweb的SSM电器商城系统(java+ssm+jsp+bootstrap+echarts+mysql)
项目介绍
本项目分为前后台,前台为普通用户登录,后台为管理员登录; 管理员角色包含以下功能: 管理员登录,销售统计,商品类目管理,用户管理,商品管理,订单管理,公告管理,留言管理等功能。 用户角色包含以下功能: 浏览所有商品,用户登录注册,查看商品,收藏商品,查看购物车,提交订单并查看,修改个人信息并查看,评价商品,查看公告,留言等功能。
环境需要
1.运行环境:最好是java jdk 1.8,我们在这个平台上运行的。其他版本理论上也可以。 2.IDE环境:IDEA,Eclipse,Myeclipse都可以。推荐IDEA; 3.tomcat环境:Tomcat 7.x,8.x,9.x版本均可 4.硬件环境:windows 7/8/10 1G内存以上;或者 Mac OS; 5.数据库:MySql 5.7版本; 6.是否Maven项目:是;
技术栈
- 后端:Spring+SpringMVC+Mybatis 2. 前端:JSP+CSS+JavaScript+jquery+bootstrap+echarts
使用说明
- 使用Navicat或者其它工具,在mysql中创建对应名称的数据库,并导入项目的sql文件; 2. 使用IDEA/Eclipse/MyEclipse导入项目,Eclipse/MyEclipse导入时,若为maven项目请选择maven; 若为maven项目,导入成功后请执行maven clean;maven install命令,然后运行; 3. 将项目中db.properties配置文件中的数据库配置改为自己的配置; 4. 运行项目,在浏览器中输入http://localhost:8080/shop 登录 用户账号/密码: user/123456 管理员账号/密码:admin/111111
}
if(!isEmpty(comment.getItemId())){
params.put("itemId", comment.getItemId());
}
if(!isEmpty(comment.getContent())){
params.put("content", comment.getContent());
}
if(!isEmpty(comment.getAddTime())){
params.put("addTime", comment.getAddTime());
}
List<Comment> listAll = commentService.listByMap(params);
model.addAttribute("list", listAll);
return "comment/comment";
}
/*********************************查询列表【分页】***********************************************/
/**
* 分页查询 返回list对象(通过对象)
*
* @param request
* @param response
* @return
*/
@RequestMapping(value = "/findByObj")
public String findByObj(Comment comment, Model model, HttpServletRequest request, HttpServletResponse response) {
//分页查询
Pager<Comment> pagers = commentService.findByEntity(comment);
model.addAttribute("pagers", pagers);
//存储查询条件
model.addAttribute("obj", comment);
return "comment/comment";
}
/**
* 分页查询 返回list对象(通过对By Sql)
*
* @param request
* @param response
* @return
*/
@RequestMapping(value = "/findBySql")
public String findBySql(Comment comment, Model model, HttpServletRequest request, HttpServletResponse response) {
//分页查询
String sql = "SELECT * FROM comment WHERE 1=1 ";
if(!isEmpty(comment.getUserId())){
sql += " and userId like '%"+comment.getUserId()+"%'";
}
/**********************************【增删改】******************************************************/
/**
* 跳至添加页面
* @return
*/
@RequestMapping(value = "/add")
public String add() {
return "message/add";
}
/**
* ajax 添加
* @param
* @return
*/
@RequestMapping(value = "/exAdd", method = RequestMethod.POST)
@ResponseBody
public String exAdd(Message message, Model model, HttpServletRequest request, HttpServletResponse response) {
messageService.insert(message);
JSONObject jsonObject = new JSONObject();
jsonObject.put("message", "添加成功");
return jsonObject.toString();
}
/**
* 跳至修改页面
* @return
*/
@RequestMapping(value = "/update")
public String update(Integer id,Model model) {
Message obj = messageService.load(id);
model.addAttribute("obj",obj);
return "message/update";
}
/**
* 添加修改
* @return
*/
@RequestMapping(value = "/exUpdate")
public String exUpdate(Message message, Model model, HttpServletRequest request, HttpServletResponse response) {
//1.通过实体类修改,可以多传修改条件
messageService.update(message);
//2.通过主键id修改
//messageService.updateById(message);
return "redirect:/message/findByObj";
private List<Item> getListByUCF(Integer userId) {
List<Item> returnList = new ArrayList<Item> ();
List<User> listAll = userService.listAll();
List<Integer> userIds = new ArrayList<Integer>();
List<ItemDto> res = new ArrayList<ItemDto>();
//判断这些人,有咩有买过东西
for (User u : listAll){
userIds.add(u.getId());
}
//输入用户总量
int N = userIds.size();
int[][] sparseMatrix = new int[N][N];//建立用户稀疏矩阵,用于用户相似度计算【相似度矩阵】
Map<String, Integer> userItemLength = new HashMap<String, Integer>();//存储每一个用户对应的不同物品总数 eg: A 3
Map<String, Set<String>> itemUserCollection = new HashMap<String, Set<String>>();//建立物品到用户的倒排表 eg: a A B
Set<String> items = new HashSet<String>();//辅助存储物品集合
Map<String, Integer> userID = new HashMap<String, Integer>();//辅助存储每一个用户的用户ID映射
Map<Integer, String> idUser = new HashMap<Integer, String>();//辅助存储每一个ID对应的用户映射
Integer a = 0;
for (User u : listAll){
ItemOrder or = new ItemOrder();
or.setUserId(u.getId());
List<ItemOrder> listAllByEntity = itemOrderService.listAllByEntity(or);
if (!CollectionUtils.isEmpty(listAllByEntity)){
for (ItemOrder ors : listAllByEntity){
OrderDetail de = new OrderDetail();
de.setOrderId(ors.getId());
List<OrderDetail> listAllByEntity2 = orderDetailService.listAllByEntity(de);
if (!CollectionUtils.isEmpty(listAllByEntity2)){
for (OrderDetail dd : listAllByEntity2){
items.add(String.valueOf(dd.getItemId()));
}
}
}
}
String[] user_item = new String[items.size()+1];
List<String> isitems = new ArrayList<String>(items);
//
// commentService.deleteByMap(params);
// //4.状态删除
// Comment load = commentService.getById(comment.getId())
// load.setIsDelete(1);
// commentService.updateById(load);
//5.状态删除
//Comment load = commentService.load(id);
//load.setIsDelete(1);
//commentService.updateById(load);
JSONObject jsonObject = new JSONObject();
jsonObject.put("message", "删除成功");
return jsonObject.toString();
}
/**
* 单文件上传
* @param file
* @param request
* @param model
* @return
*/
@RequestMapping(value = "/saveFile")
public String saveFile(@RequestParam(value = "file", required = false) MultipartFile file, HttpServletRequest request, Model model) {
System.out.println("开始");
String path = request.getSession().getServletContext().getRealPath("/upload");
String fileName = file.getOriginalFilename();
System.out.println(path);
File targetFile = new File(path, fileName);
if(!targetFile.exists()){
targetFile.mkdirs();
}
//保存
try {
file.transferTo(targetFile);
} catch (Exception e) {
e.printStackTrace();
}
return "";
}
@Controller
@RequestMapping("/news")
public class NewsController extends BaseController {
/**
* 依赖注入 start dao/service/===
*/
@Autowired
private NewsService newsService;
// --------------------------------------- 华丽分割线 ------------------------------
/*********************************查询列表【不分页】***********************************************/
/**
* 【不分页 => 查询列表 => 无条件】
* @Title: listAll
* @Description: TODO(这里用一句话描述这个方法的作用)
* @param @return 设定文件
* @return String 返回类型
* @throws
*/
@RequestMapping(value = "/listAll")
public String listAll(News news, Model model, HttpServletRequest request, HttpServletResponse response){
List<News> listAll = newsService.listAll();
model.addAttribute("list", listAll);
return "news/news";
}
/**
* 【不分页=》查询列表=>有条件】
* @Title: listByEntity
* @Description: TODO(这里用一句话描述这个方法的作用)
* @param @return 设定文件
* @return String 返回类型
* @throws
*/
@RequestMapping(value = "/listByEntity")
public String listByEntity(News news, Model model, HttpServletRequest request, HttpServletResponse response){
public String listByEntity(Item item, Model model, HttpServletRequest request, HttpServletResponse response){
List<Item> listAll = itemService.listAllByEntity(item);
model.addAttribute("list", listAll);
return "item/item";
}
/**
* 【不分页=》查询列表=>有条件】
* @Title: listByMap
* @Description: TODO(这里用一句话描述这个方法的作用)
* @param @return 设定文件
* @return String 返回类型
* @throws
*/
@RequestMapping(value = "/listByMap")
public String listByMap(Item item, Model model, HttpServletRequest request, HttpServletResponse response){
//通过map查询
Map<String,Object> params = new HashMap<String,Object>();
if(!isEmpty(item.getName())){
params.put("name", item.getName());
}
if(!isEmpty(item.getPrice())){
params.put("price", item.getPrice());
}
if(!isEmpty(item.getScNum())){
params.put("scNum", item.getScNum());
}
if(!isEmpty(item.getGmNum())){
params.put("gmNum", item.getGmNum());
}
if(!isEmpty(item.getUrl1())){
params.put("url1", item.getUrl1());
}
if(!isEmpty(item.getUrl2())){
params.put("url2", item.getUrl2());
}
if(!isEmpty(item.getUrl3())){
params.put("url3", item.getUrl3());
}
if(!isEmpty(item.getUrl4())){
params.put("url4", item.getUrl4());
}
if(!isEmpty(item.getUrl5())){
params.put("url5", item.getUrl5());
}
if(!isEmpty(item.getMs())){
params.put("ms", item.getMs());
}
if(!isEmpty(comment.getUserId())){
params.put("userId", comment.getUserId());
}
if(!isEmpty(comment.getItemId())){
params.put("itemId", comment.getItemId());
}
if(!isEmpty(comment.getContent())){
params.put("content", comment.getContent());
}
if(!isEmpty(comment.getAddTime())){
params.put("addTime", comment.getAddTime());
}
List<Comment> listAll = commentService.listByMap(params);
JSONObject jsonObject = new JSONObject();
jsonObject.put("list", listAll);
jsonObject.put("obj", comment);
return jsonObject.toString();
}
/**
* 分页查询 返回list json(通过对象)
*
* @param request
* @param response
* @return
*/
@RequestMapping(value = "/findByObjJson", method = RequestMethod.POST)
@ResponseBody
public String findByObjByEntityJson(Comment comment, HttpServletRequest request, HttpServletResponse response) {
//分页查询
Pager<Comment> pagers = commentService.findByEntity(comment);
JSONObject jsonObject = new JSONObject();
jsonObject.put("pagers", pagers);
jsonObject.put("obj", comment);
return jsonObject.toString();
}
/**
* 分页查询 返回list json(通过Map)
*
* @param request
* @param response
if(!isEmpty(news.getAddTime())){
params.put("addTime", news.getAddTime());
}
List<News> listAll = newsService.listByMap(params);
model.addAttribute("list", listAll);
return "news/news";
}
/*********************************查询列表【分页】***********************************************/
/**
* 分页查询 返回list对象(通过对象)
*
* @param request
* @param response
* @return
*/
@RequestMapping(value = "/findByObj")
public String findByObj(News news, Model model, HttpServletRequest request, HttpServletResponse response) {
//分页查询
Pager<News> pagers = newsService.findByEntity(news);
model.addAttribute("pagers", pagers);
//存储查询条件
model.addAttribute("obj", news);
return "news/news";
}
@RequestMapping(value = "/list")
public String list(News news, Model model, HttpServletRequest request, HttpServletResponse response) {
//分页查询
Pager<News> pagers = newsService.findByEntity(news);
model.addAttribute("pagers", pagers);
//存储查询条件
model.addAttribute("obj", news);
return "news/list";
}
/**
* 分页查询 返回list对象(通过Map)
*
* @param request
* @param response
*/
@RequestMapping(value = "/saveFile")
public String saveFile(@RequestParam(value = "file", required = false) MultipartFile file, HttpServletRequest request, Model model) {
System.out.println("开始");
String path = request.getSession().getServletContext().getRealPath("/upload");
String fileName = file.getOriginalFilename();
System.out.println(path);
File targetFile = new File(path, fileName);
if(!targetFile.exists()){
targetFile.mkdirs();
}
//保存
try {
file.transferTo(targetFile);
} catch (Exception e) {
e.printStackTrace();
}
return "";
}
/**
* springMvc多文件上传
* @param files
* @param id
* @return
*/
@RequestMapping(value = "/saveFiles")
public String saveFiles(@RequestParam("file") CommonsMultipartFile[] files,Integer id,HttpServletRequest request){
for(int i = 0;i<files.length;i++){
System.out.println("fileName---------->" + files[i].getOriginalFilename());
if(!files[i].isEmpty()){
int pre = (int) System.currentTimeMillis();
try {
//拿到输出流,同时重命名上传的文件
String filePath = request.getRealPath("/upload");
File f=new File(filePath);
if(!f.exists()){
f.mkdirs();
}
String fileNmae=new Date().getTime() + files[i].getOriginalFilename();
item.setCategoryIdOne(byId.getPid());
itemService.insert(item);
return "redirect:/item/findBySql.action";
}
/**
* 跳至修改页面
* @return
*/
@RequestMapping(value = "/update")
public String update(Integer id,Model model) {
Item obj = itemService.load(id);
String sql = "SELECT * FROM item_category WHERE isDelete = 0 and pid is not null";
List<ItemCategory> listBySqlReturnEntity = itemCategoryService.listBySqlReturnEntity(sql);
model.addAttribute("types",listBySqlReturnEntity);
model.addAttribute("obj",obj);
return "item/update";
}
/**
* 添加修改
* @return
* @throws IOException
* @throws IllegalStateException
*/
@RequestMapping(value = "/exUpdate")
public String exUpdate(Item item, Model model, @RequestParam("file") CommonsMultipartFile[] files, HttpServletRequest request, HttpServletResponse response) throws IllegalStateException, IOException {
//1.通过实体类修改,可以多传修改条件
ItemCategory byId = itemCategoryService.getById(item.getCategoryIdTwo());
item.setCategoryIdOne(byId.getPid());
if (files.length > 0){
// 0 1 2 3 4
for (int s = 0;s < files.length;s++){
System.out.println("开始");
long startTime=System.currentTimeMillis();
System.out.println("fileName:"+files[s].getOriginalFilename());
String n = UUIDUtils.create();
String path="D:/my/upload/"+n+files[s].getOriginalFilename();
System.out.println("===================================================");
System.out.println(path);
File newFile=new File(path);
//通过CommonsMultipartFile的方法直接写文件(注意这个时候)
files[s].transferTo(newFile);
long endTime=System.currentTimeMillis();
System.out.println("方法二的运行时间:"+String.valueOf(endTime-startTime)+"ms");
System.out.println("*********************************************************");
System.out.println("*********************************************************");
}
if(!isEmpty(item.getPam2())){
params.put("pam2", item.getPam2());
}
if(!isEmpty(item.getPam3())){
params.put("pam3", item.getPam3());
}
if(!isEmpty(item.getType())){
params.put("type", item.getType());
}
if(!isEmpty(item.getIsDelete())){
params.put("isDelete", item.getIsDelete());
}
List<Item> listAll = itemService.listByMap(params);
JSONObject jsonObject = new JSONObject();
jsonObject.put("list", listAll);
jsonObject.put("obj", item);
return jsonObject.toString();
}
/**
* 分页查询 返回list json(通过对象)
*
* @param request
* @param response
* @return
*/
@RequestMapping(value = "/findByObjJson", method = RequestMethod.POST)
@ResponseBody
public String findByObjByEntityJson(Item item, HttpServletRequest request, HttpServletResponse response) {
//分页查询
Pager<Item> pagers = itemService.findByEntity(item);
JSONObject jsonObject = new JSONObject();
jsonObject.put("pagers", pagers);
jsonObject.put("obj", item);
return jsonObject.toString();
}
/**
* 分页查询 返回list json(通过Map)
*
* @param request
* @param response
* @return
/**
* 添加修改
* @return
*/
@RequestMapping(value = "/exUpdate")
public String exUpdate(Message message, Model model, HttpServletRequest request, HttpServletResponse response) {
//1.通过实体类修改,可以多传修改条件
messageService.update(message);
//2.通过主键id修改
//messageService.updateById(message);
return "redirect:/message/findByObj";
}
/**
* 删除通过主键
* @return
*/
@RequestMapping(value = "/delete")
public String delete(Integer id, Model model, HttpServletRequest request, HttpServletResponse response) {
///1.通过主键删除
messageService.deleteById(id);
/*以下是多种删除方式*/
// //2.通过实体条件删除
// messageService.deleteByEntity(message);
// //3.通过参数删除
// //通过map查询
// Map<String,Object> params = new HashMap<String,Object>();
//
// if(!isEmpty(message.getName())){
// params.put("name", message.getName());
// }
//
// if(!isEmpty(message.getPhone())){
// params.put("phone", message.getPhone());
// }
//
// if(!isEmpty(message.getContent())){
// params.put("content", message.getContent());
// }
//
// messageService.deleteByMap(params);
// //4.状态删除
// Message load = messageService.getById(message.getId())
// load.setIsDelete(1);
// messageService.update(load);
//5.状态删除
//Message load = messageService.load(id);
//load.setIsDelete(1);
//messageService.update(load);
order.setUserId(userId);
order.setAddTime(new Date());
itemOrderService.insert(order);
//删除购车
if (!CollectionUtils.isEmpty(ids)){
for (CarDto c : list){
Car load = carService.load(c.getId());
OrderDetail de = new OrderDetail();
de.setItemId(load.getItemId());
de.setOrderId(order.getId());
de.setStatus(0);
de.setNum(c.getNum());
de.setTotal(String.valueOf(c.getNum()*c.getNum()));
orderDetailService.insert(de);
//修改成交数
Item load2 = itemService.load(load.getItemId());
load2.setGmNum(load2.getGmNum()+c.getNum());
itemService.updateById(load2);
carService.deleteById(c.getId());
}
}
js.put("res", 1);
js.put("id", order.getId());
js.put("code", order.getCode());
return js.toJSONString();
}
private static String date ;
private static long orderNum = 0l;
public static synchronized String getOrderNo() {
String str = new SimpleDateFormat("yyyyMMddHHmm").format(new Date());
if(date==null||!date.equals(str)){
date = str;
orderNum = 0l;
}
orderNum ++;
long orderNo = Long.parseLong((date)) * 10000;
orderNo += orderNum;;
return orderNo+"";
}
* @return String 返回类型
* @throws
*/
@RequestMapping(value = "/listAll")
public String listAll(ItemCategory itemCategory, Model model, HttpServletRequest request, HttpServletResponse response){
List<ItemCategory> listAll = itemCategoryService.listAll();
model.addAttribute("list", listAll);
return "itemCategory/itemCategory";
}
/**
* 【不分页=》查询列表=>有条件】
* @Title: listByEntity
* @Description: TODO(这里用一句话描述这个方法的作用)
* @param @return 设定文件
* @return String 返回类型
* @throws
*/
@RequestMapping(value = "/listByEntity")
public String listByEntity(ItemCategory itemCategory, Model model, HttpServletRequest request, HttpServletResponse response){
List<ItemCategory> listAll = itemCategoryService.listAllByEntity(itemCategory);
model.addAttribute("list", listAll);
return "itemCategory/itemCategory";
}
/**
* 【不分页=》查询列表=>有条件】
* @Title: listByMap
* @Description: TODO(这里用一句话描述这个方法的作用)
* @param @return 设定文件
* @return String 返回类型
* @throws
*/
@RequestMapping(value = "/listByMap")
public String listByMap(ItemCategory itemCategory, Model model, HttpServletRequest request, HttpServletResponse response){
//通过map查询
Map<String,Object> params = new HashMap<String,Object>();
if(!isEmpty(itemCategory.getName())){
params.put("name", itemCategory.getName());
}
if(!isEmpty(itemCategory.getPid())){
params.put("pid", itemCategory.getPid());
}
if(!isEmpty(itemCategory.getIsDelete())){
params.put("isDelete", itemCategory.getIsDelete());
}
List<ItemCategory> listAll = itemCategoryService.listByMap(params);
model.addAttribute("list", listAll);
File newFile=new File(path);
//通过CommonsMultipartFile的方法直接写文件(注意这个时候)
file.transferTo(newFile);
String visitUrl = "/ueditor/";
visitUrl = visitUrl.concat(n+file.getOriginalFilename());
long endTime=System.currentTimeMillis();
System.out.println("方法二的运行时间:"+String.valueOf(endTime-startTime)+"ms");
System.out.println("*********************************************************");
System.out.println("*********************************************************");
params.put("state", "SUCCESS");
params.put("url", visitUrl);
params.put("size", file.getSize());
params.put("original", file.getOriginalFilename());
params.put("type", file.getContentType());
return params;
}
}
public class SystemContextFilter implements Filter{
private Integer pageSize;
public void destroy() {
@RequestMapping(value = "/tj")
public String tj(ItemCategory itemCategory, Model model, HttpServletRequest request, HttpServletResponse response) {
//分页查询
String sql = "SELECT * FROM item_category WHERE isDelete = 0 and pid is null";
sql += " ORDER BY ID DESC ";
List<ItemCategory> list = itemCategoryService.listBySqlReturnEntity(sql);
List<Map<String,Object>> maps = new ArrayList<Map<String,Object>>();
List<TjDto> res = new ArrayList<TjDto>();
if (!CollectionUtils.isEmpty(list)){
for (ItemCategory c : list){
TjDto td = new TjDto();
int tot = 0;
List<Item> listBySqlReturnEntity = itemService.listBySqlReturnEntity("SELECT * FROM item WHERE 1=1 and isDelete =0 and category_id_one="+c.getId());
if (!CollectionUtils.isEmpty(listBySqlReturnEntity)){
for (Item i : listBySqlReturnEntity){
tot+= i.getGmNum();
}
}
Map<String,Object> map = new HashMap<String,Object>();
map.put("name", c.getName());
map.put("value", tot);
maps.add(map);
}
}
//存储查询条件
model.addAttribute("maps", maps);
return "itemCategory/tj";
}
@RequestMapping(value = "/findBySql2")
public String findBySql2(ItemCategory itemCategory, Model model, HttpServletRequest request, HttpServletResponse response) {
//分页查询
String sql = "SELECT * FROM item_category WHERE isDelete = 0 and pid = "+itemCategory.getPid();
if(!isEmpty(itemCategory.getName())){
sql += " and name like '%"+itemCategory.getName()+"%'";
}
// if(!isEmpty(itemCategory.getPid())){
// sql += " and pid like '%"+itemCategory.getPid()+"%'";
/**
* 添加修改
* @return
*/
@RequestMapping(value = "/exUpdate")
public String exUpdate(Comment comment, Model model, HttpServletRequest request, HttpServletResponse response) {
//1.通过实体类修改,可以多传修改条件
commentService.updateById(comment);
//2.通过主键id修改
//commentService.updateById(comment);
return "redirect:/comment/findBySql.action";
}
/**
* 删除通过主键
* @return
*/
@RequestMapping(value = "/delete")
public String delete(Integer id, Model model, HttpServletRequest request, HttpServletResponse response) {
///1.通过主键删除
commentService.deleteById(id);
/*以下是多种删除方式*/
// //2.通过实体条件删除
// commentService.deleteByEntity(comment);
// //3.通过参数删除
// //通过map查询
// Map<String,Object> params = new HashMap<String,Object>();
//
// if(!isEmpty(comment.getUserId())){
// params.put("userId", comment.getUserId());
// }
//
// if(!isEmpty(comment.getItemId())){
// params.put("itemId", comment.getItemId());
// }
//
// if(!isEmpty(comment.getContent())){
// params.put("content", comment.getContent());
// }
//
// if(!isEmpty(comment.getAddTime())){
// params.put("addTime", comment.getAddTime());
// }
//
// commentService.deleteByMap(params);
// //4.状态删除
*/
@RequestMapping(value = "/listByEntityJson", method = RequestMethod.POST)
@ResponseBody
public String listByEntityJson(News news, HttpServletRequest request, HttpServletResponse response){
List<News> listAll = newsService.listAllByEntity(news);
JSONObject jsonObject = new JSONObject();
jsonObject.put("list", listAll);
jsonObject.put("obj", news);
return jsonObject.toString();
}
/**
* 【不分页=》查询列表=>有条件】
* @Title: listByMap
* @Description: TODO(这里用一句话描述这个方法的作用)
* @param @return 设定文件
* @return String 返回类型
* @throws
*/
@RequestMapping(value = "/listByMapJson", method = RequestMethod.POST)
@ResponseBody
public String listByMapJson(News news,HttpServletRequest request, HttpServletResponse response){
//通过map查询
Map<String,Object> params = new HashMap<String,Object>();
if(!isEmpty(news.getName())){
params.put("name", news.getName());
}
if(!isEmpty(news.getContent())){
params.put("content", news.getContent());
}
if(!isEmpty(news.getAddTime())){
params.put("addTime", news.getAddTime());
}
List<News> listAll = newsService.listByMap(params);
JSONObject jsonObject = new JSONObject();
jsonObject.put("list", listAll);
jsonObject.put("obj", news);
return jsonObject.toString();
}
/**
* 分页查询 返回list json(通过对象)