• Java项目：SSM电器商城系统

    作者主页：源码空间站2022

     简介：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/111111

    运行截图

    前台界面

    后台界面

    代码相关

    地址管理控制器

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

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

  • 相关阅读:
    优彩云采集器下载-免费优彩云采集器下载地址
    硅谷15菜单权限
    pytorch环境搭建到pycharm项目映射配置（成功后回顾性记录/自用）
    docker基于debian11基础环境安装libreoffice
    【Maven教程】（八）：使用 Nexus 创建私服 ~
    linux基础IO
    【Python零基础入门篇 · 28】：os模块的使用
    牛客网《剑指offer》专栏刷题练习|锻炼递归思想|练习栈的使用
    vscode 打开后 默认terminal power shell 报错 名为“.C”的驱动器不存在。
    hist转xlsx和txt
  • 原文地址：https://blog.csdn.net/m0_74967853/article/details/128179160