• Java项目：SSM网上家具商城网站系统平台

    作者主页：夜未央5788

     简介：Java领域优质创作者、Java项目、学习资料、技术互助

    文末获取源码

    项目介绍

    本项目分为前后台，前台为普通用户登录，后台为管理员登录；

    管理员角色包含以下功能：

    管理员登录,类目管理,用户管理,商品管理,订单管理,发货管理,提交发货,公告管理,留言管理,日志查看等功能。

    用户角色包含以下功能：

    用户登录,用户首页,查看公告,提交留言,查看商品详情,加入购物车,商品结算等功能。

    环境需要

    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项目：是；

    技术栈

    1. 后端：Spring+SpringMVC+Mybatis

    2. 前端：JSP+CSS+JavaScript+jquery+bootstrap+echarts

    使用说明

    1. 使用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/admin

    运行截图

    前台界面

     

     

     

     

     

     

    后台界面

     

     

     

     

    代码相关

    地址管理控制器

    1. @Controller
    2. @RequestMapping("/address")
    3. public class AddressController extends BaseController {
    4. 	
    5. 	
    6. 	/**
    7. 	 * 依赖注入 start dao/service/===
    8. 	 */
    9. 	@Autowired
    10. 	private AddressService addressService;
    11. 	
    12. 	// --------------------------------------- 华丽分割线 ------------------------------
    13. 	
    14. 	/*********************************查询列表【不分页】***********************************************/
    15. 	
    16. 	/**
    17. 	 * 【不分页 => 查询列表 => 无条件】
    18. 	* @Title: listAll 
    19. 	* @Description: TODO(这里用一句话描述这个方法的作用) 
    20. 	* @param @return 设定文件 
    21. 	* @author
    22. 	* @return String 返回类型 
    23. 	* @throws
    24. 	 */
    25. 	@RequestMapping(value = "/listAll")
    26. 	public String listAll(Address address, Model model, HttpServletRequest request, HttpServletResponse response){
    27. 		List
       listAll = addressService.listAll();
    28. 		model.addAttribute("list", listAll);
    29. 		return "address/address";
    30. 	}
    31. 	
    32. 	/**
    33. 	 *  【不分页=》查询列表=>有条件】
    34. 	* @Title: listByEntity 
    35. 	* @Description: TODO(这里用一句话描述这个方法的作用) 
    36. 	* @param @return 设定文件 
    37. 	* @author
    38. 	* @return String 返回类型 
    39. 	* @throws
    40. 	 */
    41. 	@RequestMapping(value = "/listByEntity")
    42. 	public String listByEntity(Address address, Model model, HttpServletRequest request, HttpServletResponse response){
    43. 		List
       listAll = addressService.listAllByEntity(address);
    44. 		model.addAttribute("list", listAll);
    45. 		return "address/address";
    46. 	}
    47. 	
    48. 	/**
    49. 	 *  【不分页=》查询列表=>有条件】
    50. 	* @Title: listByMap 
    51. 	* @Description: TODO(这里用一句话描述这个方法的作用) 
    52. 	* @param @return 设定文件 
    53. 	* @author 
    54. 	* @return String 返回类型 
    55. 	* @throws
    56. 	 */
    57. 	@RequestMapping(value = "/listByMap")
    58. 	public String listByMap(Address address, Model model, HttpServletRequest request, HttpServletResponse response){
    59. 		//通过map查询
    60. 		Map params = new HashMap();
    61. 	        if(!isEmpty(address.getName())){
    62. 	        	params.put("name", address.getName());
    63. 			}
    64. 	        if(!isEmpty(address.getPhone())){
    65. 	        	params.put("phone", address.getPhone());
    66. 			}
    67. 	        if(!isEmpty(address.getArea())){
    68. 	        	params.put("area", address.getArea());
    69. 			}
    70. 	        if(!isEmpty(address.getBm())){
    71. 	        	params.put("bm", address.getBm());
    72. 			}
    73. 	        if(!isEmpty(address.getIsUse())){
    74. 	        	params.put("isUse", address.getIsUse());
    75. 			}
    76. 	    List
       listAll = addressService.listByMap(params);
    77. 		model.addAttribute("list", listAll);
    78. 		return "address/address";
    79. 	}
    80. 	
    81. 	
    82. 	/*********************************查询列表【分页】***********************************************/
    83. 	
    84. 	
    85. 	
    86. 	/**
    87. 	 * 分页查询 返回list对象(通过对象)
    88. 	 * 
    89. 	 * @param request
    90. 	 * @param response
    91. 	 * @return
    92. 	 */
    93. 	@RequestMapping(value = "/findByObj")
    94. 	public String findByObj(Address address, Model model, HttpServletRequest request, HttpServletResponse response) {
    95. 		//分页查询
    96. 		Pager
       pagers = addressService.findByEntity(address);
    97. 		model.addAttribute("pagers", pagers);
    98. 		//存储查询条件
    99. 		model.addAttribute("obj", address);
    100. 		return "address/address";
    101. 	}
    102. 	
    103. 	/**
    104. 	 * 分页查询 返回list对象(通过对By Sql)
    105. 	 * 
    106. 	 * @param request
    107. 	 * @param response
    108. 	 * @return
    109. 	 */
    110. 	@RequestMapping(value = "/findBySql")
    111. 	public String findBySql(Address address, Model model, HttpServletRequest request, HttpServletResponse response) {
    112. 		//分页查询
    113. 		String sql = "SELECT * FROM address WHERE 1=1 ";
    114.         if(!isEmpty(address.getName())){
    115.         	sql += " and name like '%"+address.getName()+"%'";
    116. 		}
    117.         if(!isEmpty(address.getPhone())){
    118.         	sql += " and phone like '%"+address.getPhone()+"%'";
    119. 		}
    120.         if(!isEmpty(address.getArea())){
    121.         	sql += " and area like '%"+address.getArea()+"%'";
    122. 		}
    123.         if(!isEmpty(address.getBm())){
    124.         	sql += " and bm like '%"+address.getBm()+"%'";
    125. 		}
    126.         if(!isEmpty(address.getIsUse())){
    127.         	sql += " and isUse like '%"+address.getIsUse()+"%'";
    128. 		}
    129.        sql += " ORDER BY ID DESC ";
    130. 		Pager
       pagers = addressService.findBySqlRerturnEntity(sql);
    131. 		model.addAttribute("pagers", pagers);
    132. 		//存储查询条件
    133. 		model.addAttribute("obj", address);
    134. 		return "address/address";
    135. 	}
    136. 	
    137. 	
    138. 	
    139. 	@RequestMapping(value = "/my")
    140. 	public String my(Address address, Model model, HttpServletRequest request, HttpServletResponse response) {
    141. 		//分页查询
    142. 		Object attribute = request.getSession().getAttribute("userId");
    143. 		if (attribute == null){
    144. 			return "redirect:/login/uLogin";
    145. 		}
    146. 		JSONObject js = new JSONObject();
    147. 		Integer userId = Integer.valueOf(attribute.toString());
    148. 		String sql = "SELECT * FROM address WHERE 1=1 and userId = "+userId;
    149.         if(!isEmpty(address.getName())){
    150.         	sql += " and name like '%"+address.getName()+"%'";
    151. 		}
    152.         if(!isEmpty(address.getPhone())){
    153.         	sql += " and phone like '%"+address.getPhone()+"%'";
    154. 		}
    155.         if(!isEmpty(address.getArea())){
    156.         	sql += " and area like '%"+address.getArea()+"%'";
    157. 		}
    158.         if(!isEmpty(address.getBm())){
    159.         	sql += " and bm like '%"+address.getBm()+"%'";
    160. 		}
    161.         if(!isEmpty(address.getIsUse())){
    162.         	sql += " and isUse like '%"+address.getIsUse()+"%'";
    163. 		}
    164.        sql += " ORDER BY ID DESC ";
    165. 		Pager
       pagers = addressService.findBySqlRerturnEntity(sql);
    166. 		model.addAttribute("pagers", pagers);
    167. 		//存储查询条件
    168. 		model.addAttribute("obj", address);
    169. 		return "address/my";
    170. 	}
    171. 	
    172. 	/**
    173. 	 * 分页查询 返回list对象(通过Map)
    174. 	 * 
    175. 	 * @param request
    176. 	 * @param response
    177. 	 * @return
    178. 	 */
    179. 	@RequestMapping(value = "/findByMap")
    180. 	public String findByMap(Address address, Model model, HttpServletRequest request, HttpServletResponse response) {
    181. 		//通过map查询
    182. 		Map params = new HashMap();
    183.         if(!isEmpty(address.getName())){
    184.         	params.put("name", address.getName());
    185. 		}
    186.         if(!isEmpty(address.getPhone())){
    187.         	params.put("phone", address.getPhone());
    188. 		}
    189.         if(!isEmpty(address.getArea())){
    190.         	params.put("area", address.getArea());
    191. 		}
    192.         if(!isEmpty(address.getBm())){
    193.         	params.put("bm", address.getBm());
    194. 		}
    195.         if(!isEmpty(address.getIsUse())){
    196.         	params.put("isUse", address.getIsUse());
    197. 		}
    198. 		//分页查询
    199. 		Pager
       pagers = addressService.findByMap(params);
    200. 		model.addAttribute("pagers", pagers);
    201. 		//存储查询条件
    202. 		model.addAttribute("obj", address);
    203. 		return "address/address";
    204. 	}
    205. 	
    206. 	/**********************************【增删改】******************************************************/
    207. 	
    208. 	/**
    209. 	 * 跳至添加页面
    210. 	 * @return
    211. 	 */
    212. 	@RequestMapping(value = "/add")
    213. 	public String add() {
    214. 		return "address/add";
    215. 	}
    216.  
    217. 	/**
    218. 	 * 跳至详情页面
    219. 	 * @return
    220. 	 */
    221. 	@RequestMapping(value = "/view")
    222. 	public String view(Integer id,Model model) {
    223. 		Address obj = addressService.load(id);
    224. 		model.addAttribute("obj",obj);
    225. 		return "address/view";
    226. 	}
    227. 	
    228. 	/**
    229. 	 * 添加执行
    230. 	 * @return
    231. 	 */
    232. 	@RequestMapping(value = "/exAdd")
    233. 	public String exAdd(Address address, Model model, HttpServletRequest request, HttpServletResponse response) {
    234. 		Object attribute = request.getSession().getAttribute("userId");
    235. 		if (attribute == null){
    236. 			return "redirect:/login/uLogin";
    237. 		}
    238. 		Integer userId = Integer.valueOf(attribute.toString());
    239. 		address.setUserId(userId);
    240. 		address.setIsUse(0);
    241. 		addressService.insert(address);
    242. 		
    243. 		return "redirect:/car/view.action";
    244. 	}
    245. 	
    246. 	
    247. 	@RequestMapping(value = "/exAdd1")
    248. 	public String exAdd1(Address address, Model model, HttpServletRequest request, HttpServletResponse response) {
    249. 		Object attribute = request.getSession().getAttribute("userId");
    250. 		if (attribute == null){
    251. 			return "redirect:/login/uLogin";
    252. 		}
    253. 		Integer userId = Integer.valueOf(attribute.toString());
    254. 		address.setUserId(userId);
    255. 		address.setIsUse(0);
    256. 		addressService.insert(address);
    257. 		
    258. 		return "redirect:/address/my.action";
    259. 	}
    260. 	
    261. 	/**
    262. 	 * 跳至修改页面
    263. 	 * @return
    264. 	 */
    265. 	@RequestMapping(value = "/update")
    266. 	public String update(Integer id,Model model) {
    267. 		Address obj = addressService.load(id);
    268. 		model.addAttribute("obj",obj);
    269. 		return "address/update";
    270. 	}
    271. 	
    272. 	/**
    273. 	 * 添加修改
    274. 	 * @return
    275. 	 */
    276. 	@RequestMapping(value = "/exUpdate")
    277. 	public String exUpdate(Address address, Model model, HttpServletRequest request, HttpServletResponse response) {
    278. 		//1.通过实体类修改，可以多传修改条件
    279. 		addressService.updateById(address);
    280. 		//2.通过主键id修改
    281. 		//addressService.updateById(address);
    282. 		return "redirect:/car/view.action";
    283. 	}
    284. 	
    285. 	@RequestMapping(value = "/exUpdate2")
    286. 	public String exUpdate2(Address address, Model model, HttpServletRequest request, HttpServletResponse response) {
    287. 		//1.通过实体类修改，可以多传修改条件
    288. 		addressService.updateById(address);
    289. 		//2.通过主键id修改
    290. 		//addressService.updateById(address);
    291. 		return "redirect:/address/my.action";
    292. 	}
    293. 	@RequestMapping(value = "/delete1")
    294. 	public String delete1(Integer id, Model model, HttpServletRequest request, HttpServletResponse response) {
    295. 		///1.通过主键删除
    296. 		addressService.deleteById(id);
    297. 		/*以下是多种删除方式*/
    298. 		return "redirect:/address/my.action";
    299. 	}
    300. 	@RequestMapping(value = "/mr")
    301. 	public String mr(Integer id, Model model, HttpServletRequest request, HttpServletResponse response) {
    302. 		///1.通过主键删除
    303. 		//分页查询
    304. 	Object attribute = request.getSession().getAttribute("userId");
    305. 	if (attribute == null){
    306. 		return "redirect:/login/uLogin";
    307. 	}
    308. 	JSONObject js = new JSONObject();
    309. 	Integer userId = Integer.valueOf(attribute.toString());
    310. 	String sql = "SELECT * FROM address WHERE 1=1 and userId = "+userId;
    311. 	List
       listBySqlReturnEntity = addressService.listBySqlReturnEntity(sql);
    312. 	if (!CollectionUtils.isEmpty(listBySqlReturnEntity)){
    313. 		for(Address a : listBySqlReturnEntity){
    314. 			a.setIsUse(0);
    315. 			addressService.updateById(a);
    316. 		}
    317. 	}
    318. 	Address load = addressService.load(id);
    319. 	load.setIsUse(1);
    320. 	addressService.updateById(load);
    321. 		/*以下是多种删除方式*/
    322. 		return "redirect:/address/my.action";
    323. 	}
    324. 	/**
    325. 	 * 删除通过主键
    326. 	 * @return
    327. 	 */
    328. 	@RequestMapping(value = "/delete")
    329. 	public String delete(Integer id, Model model, HttpServletRequest request, HttpServletResponse response) {
    330. 		///1.通过主键删除
    331. 		addressService.deleteById(id);
    332. 		/*以下是多种删除方式*/
    333. //		//2.通过实体条件删除
    334. //		addressService.deleteByEntity(address);
    335. //		//3.通过参数删除
    336. //     //通过map查询
    337. //		Map params = new HashMap();
    338. //		
    339. //        if(!isEmpty(address.getName())){
    340. //        	params.put("name", address.getName());
    341. //		}
    342. //       
    343. //        if(!isEmpty(address.getPhone())){
    344. //        	params.put("phone", address.getPhone());
    345. //		}
    346. //       
    347. //        if(!isEmpty(address.getArea())){
    348. //        	params.put("area", address.getArea());
    349. //		}
    350. //       
    351. //        if(!isEmpty(address.getBm())){
    352. //        	params.put("bm", address.getBm());
    353. //		}
    354. //       
    355. //        if(!isEmpty(address.getIsUse())){
    356. //        	params.put("isUse", address.getIsUse());
    357. //		}
    358. //       
    359. //		addressService.deleteByMap(params);
    360. //		//4.状态删除
    361. //		Address load = addressService.getById(address.getId())
    362. //		load.setIsDelete(1);
    363. //		addressService.update(load);
    364. 		//5.状态删除
    365. 		//Address load = addressService.load(id);
    366. 		//load.setIsDelete(1);
    367. 		//addressService.update(load);
    368. 		return "redirect:/address/findBySql.action";
    369. 	}
    370. 	
    371. 	// --------------------------------------- 华丽分割线 ------------------------------
    372. 	// --------------------------------------- 【下面是ajax操作的方法。】 ------------------------------
    373.  
    374. 	/*********************************查询列表【不分页】***********************************************/
    375. 	
    376. 	/**
    377. 	 * 【不分页 => 查询列表 => 无条件】
    378. 	* @Title: listAll 
    379. 	* @Description: TODO(这里用一句话描述这个方法的作用) 
    380. 	* @param @return 设定文件 
    381. 	* @author
    382. 	* @return String 返回类型 
    383. 	* @throws
    384. 	 */
    385. 	@RequestMapping(value = "/listAllJson", method = RequestMethod.POST)
    386. 	@ResponseBody
    387. 	public String listAllJson(Address address, HttpServletRequest request, HttpServletResponse response){
    388. 		List
       listAll = addressService.listAll();
    389. 		JSONObject jsonObject = new JSONObject();
    390. 		jsonObject.put("list", listAll);
    391. 		jsonObject.put("obj", address);
    392. 		return jsonObject.toString();
    393. 	}
    394. 	
    395. 	/**
    396. 	 *  【不分页=》查询列表=>有条件】
    397. 	* @Title: listByEntity 
    398. 	* @Description: TODO(这里用一句话描述这个方法的作用) 
    399. 	* @param @return 设定文件 
    400. 	* @author
    401. 	* @return String 返回类型 
    402. 	* @throws
    403. 	 */
    404. 	@RequestMapping(value = "/listByEntityJson", method = RequestMethod.POST)
    405. 	@ResponseBody
    406. 	public String listByEntityJson(Address address,  HttpServletRequest request, HttpServletResponse response){
    407. 		List
       listAll = addressService.listAllByEntity(address);
    408. 		JSONObject jsonObject = new JSONObject();
    409. 		jsonObject.put("list", listAll);
    410. 		jsonObject.put("obj", address);
    411. 		return jsonObject.toString();
    412. 	}
    413. 	
    414. 	/**
    415. 	 *  【不分页=》查询列表=>有条件】
    416. 	* @Title: listByMap 
    417. 	* @Description: TODO(这里用一句话描述这个方法的作用) 
    418. 	* @param @return 设定文件 
    419. 	* @author 
    420. 	* @return String 返回类型 
    421. 	* @throws
    422. 	 */
    423. 	@RequestMapping(value = "/listByMapJson", method = RequestMethod.POST)
    424. 	@ResponseBody
    425. 	public String listByMapJson(Address address,HttpServletRequest request, HttpServletResponse response){
    426. 		//通过map查询
    427. 		Map params = new HashMap();
    428. 	        if(!isEmpty(address.getName())){
    429. 	        	params.put("name", address.getName());
    430. 			}
    431. 	        if(!isEmpty(address.getPhone())){
    432. 	        	params.put("phone", address.getPhone());
    433. 			}
    434. 	        if(!isEmpty(address.getArea())){
    435. 	        	params.put("area", address.getArea());
    436. 			}
    437. 	        if(!isEmpty(address.getBm())){
    438. 	        	params.put("bm", address.getBm());
    439. 			}
    440. 	        if(!isEmpty(address.getIsUse())){
    441. 	        	params.put("isUse", address.getIsUse());
    442. 			}
    443. 	    List
       listAll = addressService.listByMap(params);
    444. 	    JSONObject jsonObject = new JSONObject();
    445. 		jsonObject.put("list", listAll);
    446. 		jsonObject.put("obj", address);
    447. 		return jsonObject.toString();
    448. 	}
    449. 	
    450. 	
    451. 	/**
    452. 	 * 分页查询 返回list json(通过对象)
    453. 	 * 
    454. 	 * @param request
    455. 	 * @param response
    456. 	 * @return
    457. 	 */
    458. 	@RequestMapping(value = "/findByObjJson", method = RequestMethod.POST)
    459. 	@ResponseBody
    460. 	public String findByObjByEntityJson(Address address, HttpServletRequest request, HttpServletResponse response) {
    461. 		//分页查询
    462. 		Pager
       pagers = addressService.findByEntity(address);
    463. 		JSONObject jsonObject = new JSONObject();
    464. 		jsonObject.put("pagers", pagers);
    465. 		jsonObject.put("obj", address);
    466. 		return jsonObject.toString();
    467. 	}
    468. 	
    469. 	  
    470. 	/**
    471. 	 * 分页查询 返回list json(通过Map)
    472. 	 * 
    473. 	 * @param request
    474. 	 * @param response
    475. 	 * @return
    476. 	 */
    477. 	@RequestMapping(value = "/findByMapJson",  method = RequestMethod.POST)
    478. 	@ResponseBody
    479. 	public String findByMapJson(Address address,HttpServletRequest request, HttpServletResponse response) {
    480. 		//通过map查询
    481. 		Map params = new HashMap();
    482.         if(!isEmpty(address.getName())){
    483.         	params.put("name", address.getName());
    484. 		}
    485.         if(!isEmpty(address.getPhone())){
    486.         	params.put("phone", address.getPhone());
    487. 		}
    488.         if(!isEmpty(address.getArea())){
    489.         	params.put("area", address.getArea());
    490. 		}
    491.         if(!isEmpty(address.getBm())){
    492.         	params.put("bm", address.getBm());
    493. 		}
    494.         if(!isEmpty(address.getIsUse())){
    495.         	params.put("isUse", address.getIsUse());
    496. 		}
    497. 		//分页查询
    498. 		Pager
       pagers = addressService.findByMap(params);
    499. 		JSONObject jsonObject = new JSONObject();
    500. 		jsonObject.put("pagers", pagers);
    501. 		jsonObject.put("obj", address);
    502. 		return jsonObject.toString();
    503. 	}
    504. 	
    505. 	
    506. 	/**
    507. 	 * ajax 添加
    508. 	 * @param 
    509. 	 * @return
    510. 	 */
    511. 	@RequestMapping(value = "/exAddJson", method = RequestMethod.POST)
    512. 	@ResponseBody
    513. 	public String exAddJson(Address address, Model model, HttpServletRequest request, HttpServletResponse response) {
    514. 		addressService.insert(address);
    515. 		JSONObject jsonObject = new JSONObject();
    516. 		jsonObject.put("message", "添加成功");
    517. 		return jsonObject.toString();
    518. 	}
    519. 	
    520.  
    521. 	/**
    522. 	 * ajax 修改
    523. 	 * @param 
    524. 	 * @return
    525. 	 */
    526. 	@RequestMapping(value = "/exUpdate.json", method = RequestMethod.POST)
    527. 	@ResponseBody
    528. 	public String exUpdateJson(Address address, Model model, HttpServletRequest request, HttpServletResponse response) {
    529. 		//1.通过实体类修改，可以多传修改条件
    530. 		addressService.updateById(address);
    531. 		//2.通过主键id修改
    532. 		//addressService.updateById(address);
    533. 		JSONObject jsonObject = new JSONObject();
    534. 		jsonObject.put("message", "修改成功");
    535. 		return jsonObject.toString();
    536. 	}
    537.  
    538. 	/**
    539. 	 * ajax 删除
    540. 	 * @return
    541. 	 */
    542. 	@RequestMapping(value = "/delete.json", method = RequestMethod.POST)
    543. 	@ResponseBody
    544. 	public String exDeleteJson(Integer id, Model model, HttpServletRequest request, HttpServletResponse response) {
    545. 		///1.通过主键删除
    546. 		addressService.deleteById(id);
    547. 		/*以下是多种删除方式*/
    548. //		//2.通过实体条件删除
    549. //		addressService.deleteByEntity(address);
    550. //		//3.通过参数删除
    551. //        //通过map查询
    552. //		Map params = new HashMap();
    553. //		
    554. //        if(!isEmpty(address.getName())){
    555. //        	params.put("name", address.getName());
    556. //		}
    557. //       
    558. //        if(!isEmpty(address.getPhone())){
    559. //        	params.put("phone", address.getPhone());
    560. //		}
    561. //       
    562. //        if(!isEmpty(address.getArea())){
    563. //        	params.put("area", address.getArea());
    564. //		}
    565. //       
    566. //        if(!isEmpty(address.getBm())){
    567. //        	params.put("bm", address.getBm());
    568. //		}
    569. //       
    570. //        if(!isEmpty(address.getIsUse())){
    571. //        	params.put("isUse", address.getIsUse());
    572. //		}
    573. //       
    574. //		addressService.deleteByMap(params);
    575. //		//4.状态删除
    576. //		Address load = addressService.getById(address.getId())
    577. //		load.setIsDelete(1);
    578. //		addressService.updateById(load);
    579. 		//5.状态删除
    580. 		//Address load = addressService.load(id);
    581. 		//load.setIsDelete(1);
    582. 		//addressService.updateById(load);
    583. 		JSONObject jsonObject = new JSONObject();
    584. 		jsonObject.put("message", "删除成功");
    585. 		return jsonObject.toString();
    586. 	}
    587. 	/**
    588. 	 * 单文件上传
    589. 	 * @param file
    590. 	 * @param request
    591. 	 * @param model
    592. 	 * @return
    593. 	 */
    594.     @RequestMapping(value = "/saveFile")  
    595.     public String saveFile(@RequestParam(value = "file", required = false) MultipartFile file, HttpServletRequest request, Model model) {  
    596.   
    597.         System.out.println("开始");  
    598.         String path = request.getSession().getServletContext().getRealPath("/upload");  
    599.         String fileName = file.getOriginalFilename();  
    600.         System.out.println(path);  
    601.         File targetFile = new File(path, fileName);  
    602.         if(!targetFile.exists()){  
    603.             targetFile.mkdirs();  
    604.         }  
    605.         //保存  
    606.         try {  
    607.             file.transferTo(targetFile);  
    608.         } catch (Exception e) {  
    609.             e.printStackTrace();  
    610.         }  
    611.   
    612.         return "";  
    613.     }  
    614. 	
    615. 	
    616. 	/**
    617. 	 * springMvc多文件上传
    618. 	 * @param files
    619. 	 * @param id
    620. 	 * @return
    621. 	 */
    622.     @RequestMapping(value = "/saveFiles")
    623.     public String saveFiles(@RequestParam("file") CommonsMultipartFile[] files,Integer id,HttpServletRequest request){
    624. 		for(int i = 0;i
    625. 	      	System.out.println("fileName---------->" + files[i].getOriginalFilename());
    626. 		  if(!files[i].isEmpty()){
    627.             int pre = (int) System.currentTimeMillis();
    628. 	     	try {
    629. 			//拿到输出流，同时重命名上传的文件
    630. 			 String filePath = request.getRealPath("/upload");
    631. 			 File f=new File(filePath);
    632. 			 if(!f.exists()){
    633. 				f.mkdirs();
    634. 			 }
    635. 		     String fileNmae=new Date().getTime() + files[i].getOriginalFilename();
    636. 		     File file=new File(filePath+"/"+pre + files[i].getOriginalFilename());
    637. 			  if(!file.exists()){
    638. 				  file.createNewFile();
    639. 			 }
    640. 			  files[i].transferTo(file);
    641. 		     } catch (Exception e) {
    642. 				e.printStackTrace();
    643. 				System.out.println("上传出错");
    644. 			 }
    645. 		  }
    646. 		}
    647. 	  return "";
    648. 	}
    649.  // --------------------------------------- 华丽分割线 ------------------------------
    650. 	
    651. 	
    652. }

    管理端控制器

    1. @Controller
    2. @RequestMapping("/manage")
    3. public class ManageController extends BaseController {
    4. 	
    5. 	
    6. 	/**
    7. 	 * 依赖注入 start dao/service/===
    8. 	 */
    9. 	@Autowired
    10. 	private ManageService manageService;
    11. 	
    12. 	// --------------------------------------- 华丽分割线 ------------------------------
    13. 	
    14. 	/*********************************查询列表【不分页】***********************************************/
    15. 	
    16. 	/**
    17. 	 * 【不分页 => 查询列表 => 无条件】
    18. 	* @Title: listAll 
    19. 	* @Description: TODO(这里用一句话描述这个方法的作用) 
    20. 	* @param @return 设定文件 
    21. 	* @author
    22. 	* @return String 返回类型 
    23. 	* @throws
    24. 	 */
    25. 	@RequestMapping(value = "/listAll")
    26. 	public String listAll(Manage manage, Model model, HttpServletRequest request, HttpServletResponse response){
    27. 		List listAll = manageService.listAll();
    28. 		model.addAttribute("list", listAll);
    29. 		return "manage/manage";
    30. 	}
    31. 	
    32. 	/**
    33. 	 *  【不分页=》查询列表=>有条件】
    34. 	* @Title: listByEntity 
    35. 	* @Description: TODO(这里用一句话描述这个方法的作用) 
    36. 	* @param @return 设定文件 
    37. 	* @author
    38. 	* @return String 返回类型 
    39. 	* @throws
    40. 	 */
    41. 	@RequestMapping(value = "/listByEntity")
    42. 	public String listByEntity(Manage manage, Model model, HttpServletRequest request, HttpServletResponse response){
    43. 		List listAll = manageService.listAllByEntity(manage);
    44. 		model.addAttribute("list", listAll);
    45. 		return "manage/manage";
    46. 	}
    47. 	
    48. 	/**
    49. 	 *  【不分页=》查询列表=>有条件】
    50. 	* @Title: listByMap 
    51. 	* @Description: TODO(这里用一句话描述这个方法的作用) 
    52. 	* @param @return 设定文件 
    53. 	* @author 
    54. 	* @return String 返回类型 
    55. 	* @throws
    56. 	 */
    57. 	@RequestMapping(value = "/listByMap")
    58. 	public String listByMap(Manage manage, Model model, HttpServletRequest request, HttpServletResponse response){
    59. 		//通过map查询
    60. 		Map params = new HashMap();
    61. 	        if(!isEmpty(manage.getUserName())){
    62. 	        	params.put("userName", manage.getUserName());
    63. 			}
    64. 	        if(!isEmpty(manage.getPassWord())){
    65. 	        	params.put("passWord", manage.getPassWord());
    66. 			}
    67. 	        if(!isEmpty(manage.getRealName())){
    68. 	        	params.put("realName", manage.getRealName());
    69. 			}
    70. 	    List listAll = manageService.listByMap(params);
    71. 		model.addAttribute("list", listAll);
    72. 		return "manage/manage";
    73. 	}
    74. 	
    75. 	
    76. 	/*********************************查询列表【分页】***********************************************/
    77. 	
    78. 	
    79. 	
    80. 	/**
    81. 	 * 分页查询 返回list对象(通过对象)
    82. 	 * 
    83. 	 * @param request
    84. 	 * @param response
    85. 	 * @return
    86. 	 */
    87. 	@RequestMapping(value = "/findByObj")
    88. 	public String findByObj(Manage manage, Model model, HttpServletRequest request, HttpServletResponse response) {
    89. 		//分页查询
    90. 		Pager pagers = manageService.findByEntity(manage);
    91. 		model.addAttribute("pagers", pagers);
    92. 		//存储查询条件
    93. 		model.addAttribute("obj", manage);
    94. 		return "manage/manage";
    95. 	}
    96. 	
    97. 	/**
    98. 	 * 分页查询 返回list对象(通过对By Sql)
    99. 	 * 
    100. 	 * @param request
    101. 	 * @param response
    102. 	 * @return
    103. 	 */
    104. 	@RequestMapping(value = "/findBySql")
    105. 	public String findBySql(Manage manage, Model model, HttpServletRequest request, HttpServletResponse response) {
    106. 		//分页查询
    107. 		String sql = "SELECT * FROM manage WHERE 1=1 ";
    108.         if(!isEmpty(manage.getUserName())){
    109.         	sql += " and userName like '%"+manage.getUserName()+"%'";
    110. 		}
    111.         if(!isEmpty(manage.getPassWord())){
    112.         	sql += " and passWord like '%"+manage.getPassWord()+"%'";
    113. 		}
    114.         if(!isEmpty(manage.getRealName())){
    115.         	sql += " and realName like '%"+manage.getRealName()+"%'";
    116. 		}
    117.        sql += " ORDER BY ID DESC ";
    118. 		Pager pagers = manageService.findBySqlRerturnEntity(sql);
    119. 		model.addAttribute("pagers", pagers);
    120. 		//存储查询条件
    121. 		model.addAttribute("obj", manage);
    122. 		return "manage/manage";
    123. 	}
    124. 	
    125. 	
    126. 	/**
    127. 	 * 分页查询 返回list对象(通过Map)
    128. 	 * 
    129. 	 * @param request
    130. 	 * @param response
    131. 	 * @return
    132. 	 */
    133. 	@RequestMapping(value = "/findByMap")
    134. 	public String findByMap(Manage manage, Model model, HttpServletRequest request, HttpServletResponse response) {
    135. 		//通过map查询
    136. 		Map params = new HashMap();
    137.         if(!isEmpty(manage.getUserName())){
    138.         	params.put("userName", manage.getUserName());
    139. 		}
    140.         if(!isEmpty(manage.getPassWord())){
    141.         	params.put("passWord", manage.getPassWord());
    142. 		}
    143.         if(!isEmpty(manage.getRealName())){
    144.         	params.put("realName", manage.getRealName());
    145. 		}
    146. 		//分页查询
    147. 		Pager pagers = manageService.findByMap(params);
    148. 		model.addAttribute("pagers", pagers);
    149. 		//存储查询条件
    150. 		model.addAttribute("obj", manage);
    151. 		return "manage/manage";
    152. 	}
    153. 	
    154. 	/**********************************【增删改】******************************************************/
    155. 	
    156. 	/**
    157. 	 * 跳至添加页面
    158. 	 * @return
    159. 	 */
    160. 	@RequestMapping(value = "/add")
    161. 	public String add() {
    162. 		return "manage/add";
    163. 	}
    164.  
    165. 	/**
    166. 	 * 跳至详情页面
    167. 	 * @return
    168. 	 */
    169. 	@RequestMapping(value = "/view")
    170. 	public String view(Integer id,Model model) {
    171. 		Manage obj = manageService.load(id);
    172. 		model.addAttribute("obj",obj);
    173. 		return "manage/view";
    174. 	}
    175. 	
    176. 	/**
    177. 	 * 添加执行
    178. 	 * @return
    179. 	 */
    180. 	@RequestMapping(value = "/exAdd")
    181. 	public String exAdd(Manage manage, Model model, HttpServletRequest request, HttpServletResponse response) {
    182. 		manageService.insert(manage);
    183. 		return "redirect:/manage/findBySql.action";
    184. 	}
    185. 	
    186. 	
    187. 	/**
    188. 	 * 跳至修改页面
    189. 	 * @return
    190. 	 */
    191. 	@RequestMapping(value = "/update")
    192. 	public String update(Integer id,Model model) {
    193. 		Manage obj = manageService.load(id);
    194. 		model.addAttribute("obj",obj);
    195. 		return "manage/update";
    196. 	}
    197. 	
    198. 	/**
    199. 	 * 添加修改
    200. 	 * @return
    201. 	 */
    202. 	@RequestMapping(value = "/exUpdate")
    203. 	public String exUpdate(Manage manage, Model model, HttpServletRequest request, HttpServletResponse response) {
    204. 		//1.通过实体类修改，可以多传修改条件
    205. 		manageService.updateById(manage);
    206. 		//2.通过主键id修改
    207. 		//manageService.updateById(manage);
    208. 		return "redirect:/manage/findBySql.action";
    209. 	}
    210. 	
    211. 	/**
    212. 	 * 删除通过主键
    213. 	 * @return
    214. 	 */
    215. 	@RequestMapping(value = "/delete")
    216. 	public String delete(Integer id, Model model, HttpServletRequest request, HttpServletResponse response) {
    217. 		///1.通过主键删除
    218. 		manageService.deleteById(id);
    219. 		/*以下是多种删除方式*/
    220. //		//2.通过实体条件删除
    221. //		manageService.deleteByEntity(manage);
    222. //		//3.通过参数删除
    223. //     //通过map查询
    224. //		Map params = new HashMap();
    225. //		
    226. //        if(!isEmpty(manage.getUserName())){
    227. //        	params.put("userName", manage.getUserName());
    228. //		}
    229. //       
    230. //        if(!isEmpty(manage.getPassWord())){
    231. //        	params.put("passWord", manage.getPassWord());
    232. //		}
    233. //       
    234. //        if(!isEmpty(manage.getRealName())){
    235. //        	params.put("realName", manage.getRealName());
    236. //		}
    237. //       
    238. //		manageService.deleteByMap(params);
    239. //		//4.状态删除
    240. //		Manage load = manageService.getById(manage.getId())
    241. //		load.setIsDelete(1);
    242. //		manageService.update(load);
    243. 		//5.状态删除
    244. 		//Manage load = manageService.load(id);
    245. 		//load.setIsDelete(1);
    246. 		//manageService.update(load);
    247. 		return "redirect:/manage/findBySql.action";
    248. 	}
    249. 	
    250. 	// --------------------------------------- 华丽分割线 ------------------------------
    251. 	// --------------------------------------- 【下面是ajax操作的方法。】 ------------------------------
    252.  
    253. 	/*********************************查询列表【不分页】***********************************************/
    254. 	
    255. 	/**
    256. 	 * 【不分页 => 查询列表 => 无条件】
    257. 	* @Title: listAll 
    258. 	* @Description: TODO(这里用一句话描述这个方法的作用) 
    259. 	* @param @return 设定文件 
    260. 	* @author
    261. 	* @return String 返回类型 
    262. 	* @throws
    263. 	 */
    264. 	@RequestMapping(value = "/listAllJson", method = RequestMethod.POST)
    265. 	@ResponseBody
    266. 	public String listAllJson(Manage manage, HttpServletRequest request, HttpServletResponse response){
    267. 		List listAll = manageService.listAll();
    268. 		JSONObject jsonObject = new JSONObject();
    269. 		jsonObject.put("list", listAll);
    270. 		jsonObject.put("obj", manage);
    271. 		return jsonObject.toString();
    272. 	}
    273. 	
    274. 	/**
    275. 	 *  【不分页=》查询列表=>有条件】
    276. 	* @Title: listByEntity 
    277. 	* @Description: TODO(这里用一句话描述这个方法的作用) 
    278. 	* @param @return 设定文件 
    279. 	* @author
    280. 	* @return String 返回类型 
    281. 	* @throws
    282. 	 */
    283. 	@RequestMapping(value = "/listByEntityJson", method = RequestMethod.POST)
    284. 	@ResponseBody
    285. 	public String listByEntityJson(Manage manage,  HttpServletRequest request, HttpServletResponse response){
    286. 		List listAll = manageService.listAllByEntity(manage);
    287. 		JSONObject jsonObject = new JSONObject();
    288. 		jsonObject.put("list", listAll);
    289. 		jsonObject.put("obj", manage);
    290. 		return jsonObject.toString();
    291. 	}
    292. 	
    293. 	/**
    294. 	 *  【不分页=》查询列表=>有条件】
    295. 	* @Title: listByMap 
    296. 	* @Description: TODO(这里用一句话描述这个方法的作用) 
    297. 	* @param @return 设定文件 
    298. 	* @author 
    299. 	* @return String 返回类型 
    300. 	* @throws
    301. 	 */
    302. 	@RequestMapping(value = "/listByMapJson", method = RequestMethod.POST)
    303. 	@ResponseBody
    304. 	public String listByMapJson(Manage manage,HttpServletRequest request, HttpServletResponse response){
    305. 		//通过map查询
    306. 		Map params = new HashMap();
    307. 	        if(!isEmpty(manage.getUserName())){
    308. 	        	params.put("userName", manage.getUserName());
    309. 			}
    310. 	        if(!isEmpty(manage.getPassWord())){
    311. 	        	params.put("passWord", manage.getPassWord());
    312. 			}
    313. 	        if(!isEmpty(manage.getRealName())){
    314. 	        	params.put("realName", manage.getRealName());
    315. 			}
    316. 	    List listAll = manageService.listByMap(params);
    317. 	    JSONObject jsonObject = new JSONObject();
    318. 		jsonObject.put("list", listAll);
    319. 		jsonObject.put("obj", manage);
    320. 		return jsonObject.toString();
    321. 	}
    322. 	
    323. 	
    324. 	/**
    325. 	 * 分页查询 返回list json(通过对象)
    326. 	 * 
    327. 	 * @param request
    328. 	 * @param response
    329. 	 * @return
    330. 	 */
    331. 	@RequestMapping(value = "/findByObjJson", method = RequestMethod.POST)
    332. 	@ResponseBody
    333. 	public String findByObjByEntityJson(Manage manage, HttpServletRequest request, HttpServletResponse response) {
    334. 		//分页查询
    335. 		Pager pagers = manageService.findByEntity(manage);
    336. 		JSONObject jsonObject = new JSONObject();
    337. 		jsonObject.put("pagers", pagers);
    338. 		jsonObject.put("obj", manage);
    339. 		return jsonObject.toString();
    340. 	}
    341. 	
    342. 	  
    343. 	/**
    344. 	 * 分页查询 返回list json(通过Map)
    345. 	 * 
    346. 	 * @param request
    347. 	 * @param response
    348. 	 * @return
    349. 	 */
    350. 	@RequestMapping(value = "/findByMapJson",  method = RequestMethod.POST)
    351. 	@ResponseBody
    352. 	public String findByMapJson(Manage manage,HttpServletRequest request, HttpServletResponse response) {
    353. 		//通过map查询
    354. 		Map params = new HashMap();
    355.         if(!isEmpty(manage.getUserName())){
    356.         	params.put("userName", manage.getUserName());
    357. 		}
    358.         if(!isEmpty(manage.getPassWord())){
    359.         	params.put("passWord", manage.getPassWord());
    360. 		}
    361.         if(!isEmpty(manage.getRealName())){
    362.         	params.put("realName", manage.getRealName());
    363. 		}
    364. 		//分页查询
    365. 		Pager pagers = manageService.findByMap(params);
    366. 		JSONObject jsonObject = new JSONObject();
    367. 		jsonObject.put("pagers", pagers);
    368. 		jsonObject.put("obj", manage);
    369. 		return jsonObject.toString();
    370. 	}
    371. 	
    372. 	
    373. 	/**
    374. 	 * ajax 添加
    375. 	 * @param 
    376. 	 * @return
    377. 	 */
    378. 	@RequestMapping(value = "/exAddJson", method = RequestMethod.POST)
    379. 	@ResponseBody
    380. 	public String exAddJson(Manage manage, Model model, HttpServletRequest request, HttpServletResponse response) {
    381. 		manageService.insert(manage);
    382. 		JSONObject jsonObject = new JSONObject();
    383. 		jsonObject.put("message", "添加成功");
    384. 		return jsonObject.toString();
    385. 	}
    386. 	
    387.  
    388. 	/**
    389. 	 * ajax 修改
    390. 	 * @param 
    391. 	 * @return
    392. 	 */
    393. 	@RequestMapping(value = "/exUpdate.json", method = RequestMethod.POST)
    394. 	@ResponseBody
    395. 	public String exUpdateJson(Manage manage, Model model, HttpServletRequest request, HttpServletResponse response) {
    396. 		//1.通过实体类修改，可以多传修改条件
    397. 		manageService.updateById(manage);
    398. 		//2.通过主键id修改
    399. 		//manageService.updateById(manage);
    400. 		JSONObject jsonObject = new JSONObject();
    401. 		jsonObject.put("message", "修改成功");
    402. 		return jsonObject.toString();
    403. 	}
    404.  
    405. 	/**
    406. 	 * ajax 删除
    407. 	 * @return
    408. 	 */
    409. 	@RequestMapping(value = "/delete.json", method = RequestMethod.POST)
    410. 	@ResponseBody
    411. 	public String exDeleteJson(Integer id, Model model, HttpServletRequest request, HttpServletResponse response) {
    412. 		///1.通过主键删除
    413. 		manageService.deleteById(id);
    414. 		/*以下是多种删除方式*/
    415. //		//2.通过实体条件删除
    416. //		manageService.deleteByEntity(manage);
    417. //		//3.通过参数删除
    418. //        //通过map查询
    419. //		Map params = new HashMap();
    420. //		
    421. //        if(!isEmpty(manage.getUserName())){
    422. //        	params.put("userName", manage.getUserName());
    423. //		}
    424. //       
    425. //        if(!isEmpty(manage.getPassWord())){
    426. //        	params.put("passWord", manage.getPassWord());
    427. //		}
    428. //       
    429. //        if(!isEmpty(manage.getRealName())){
    430. //        	params.put("realName", manage.getRealName());
    431. //		}
    432. //       
    433. //		manageService.deleteByMap(params);
    434. //		//4.状态删除
    435. //		Manage load = manageService.getById(manage.getId())
    436. //		load.setIsDelete(1);
    437. //		manageService.updateById(load);
    438. 		//5.状态删除
    439. 		//Manage load = manageService.load(id);
    440. 		//load.setIsDelete(1);
    441. 		//manageService.updateById(load);
    442. 		JSONObject jsonObject = new JSONObject();
    443. 		jsonObject.put("message", "删除成功");
    444. 		return jsonObject.toString();
    445. 	}
    446. 	/**
    447. 	 * 单文件上传
    448. 	 * @param file
    449. 	 * @param request
    450. 	 * @param model
    451. 	 * @return
    452. 	 */
    453.     @RequestMapping(value = "/saveFile")  
    454.     public String saveFile(@RequestParam(value = "file", required = false) MultipartFile file, HttpServletRequest request, Model model) {  
    455.   
    456.         System.out.println("开始");  
    457.         String path = request.getSession().getServletContext().getRealPath("/upload");  
    458.         String fileName = file.getOriginalFilename();  
    459.         System.out.println(path);  
    460.         File targetFile = new File(path, fileName);  
    461.         if(!targetFile.exists()){  
    462.             targetFile.mkdirs();  
    463.         }  
    464.         //保存  
    465.         try {  
    466.             file.transferTo(targetFile);  
    467.         } catch (Exception e) {  
    468.             e.printStackTrace();  
    469.         }  
    470.   
    471.         return "";  
    472.     }  
    473. 	
    474. 	
    475. 	/**
    476. 	 * springMvc多文件上传
    477. 	 * @param files
    478. 	 * @param id
    479. 	 * @return
    480. 	 */
    481.     @RequestMapping(value = "/saveFiles")
    482.     public String saveFiles(@RequestParam("file") CommonsMultipartFile[] files,Integer id,HttpServletRequest request){
    483. 		for(int i = 0;i
    484. 	      	System.out.println("fileName---------->" + files[i].getOriginalFilename());
    485. 		  if(!files[i].isEmpty()){
    486.             int pre = (int) System.currentTimeMillis();
    487. 	     	try {
    488. 			//拿到输出流，同时重命名上传的文件
    489. 			 String filePath = request.getRealPath("/upload");
    490. 			 File f=new File(filePath);
    491. 			 if(!f.exists()){
    492. 				f.mkdirs();
    493. 			 }
    494. 		     String fileNmae=new Date().getTime() + files[i].getOriginalFilename();
    495. 		     File file=new File(filePath+"/"+pre + files[i].getOriginalFilename());
    496. 			  if(!file.exists()){
    497. 				  file.createNewFile();
    498. 			 }
    499. 			  files[i].transferTo(file);
    500. 		     } catch (Exception e) {
    501. 				e.printStackTrace();
    502. 				System.out.println("上传出错");
    503. 			 }
    504. 		  }
    505. 		}
    506. 	  return "";
    507. 	}
    508.  // --------------------------------------- 华丽分割线 ------------------------------
    509. 	
    510. 	
    511. }

    如果也想学习本系统，下面领取。关注并回复：132ssm

  • 相关阅读:
    用户管理系统(五)——删除用户
    Spring Boot开发之Mybatis-Plus、SpringSercurity
    ES6（三）：Iterator、Generator、类的用法、类的继承
    BAT大厂测试架构师如何解读测试平台的各种争议
    [含毕业设计论文+PPT+源码等]ssm校友录网站+Java后台管理系统|前后分离VUE
    在Linux环境中分别使用手动和Shell自动脚本来部署SpringBoot项目
    关于项目、项目集、项目组合以及运营管理之间的关系
    websocket学习笔记1
    六级阅读3大核心技巧-因果关系题：如何识别因果
    基于springboot的药店进销存管理系统
  • 原文地址：https://blog.csdn.net/hanyunlong1989/article/details/126541498