• Java项目：JSP中华传统美食网站平台管理系统

    作者主页：源码空间站2022

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

    文末获取源码

     

    作者主页：夜未央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项目：否；

    技术栈

    JSP+CSS+JavaScript+jQuery+Bootstrap+mysql

    使用说明

    1. 使用Navicat或者其它工具，在mysql中创建对应名称的数据库，并导入项目的sql文件；

    2. 使用IDEA/Eclipse/MyEclipse导入项目，Eclipse/MyEclipse导入时，若为maven项目请选择maven;

    若为maven项目，导入成功后请执行maven clean;maven install命令，然后运行；

    3. 将项目中util/SimpleDataSource.java配置文件中的数据库配置改为自己的配置;
    4. 运行项目，输入localhost:8080/jsp_zhctms_site 登录 注：tomcat中配置项目路径必须为jsp_zhctms_site
    用户账号/密码： user/123456

    管理员账号/密码：admin/admin

    运行截图

    前台界面-用户角色

    后台界面

    相关代码 

    MainCtrl

    1. package control;
    2.  
    3. import java.io.File;
    4. import java.io.IOException;
    5. import java.io.InputStream;
    6. import java.io.PrintWriter;
    7. import java.net.SocketException;
    8. import java.net.UnknownHostException;
    9. import java.util.ArrayList;
    10. import java.util.HashMap;
    11. import java.util.List;
    12. import java.util.Properties;
    13.  
    14. import javax.servlet.ServletException;
    15. import javax.servlet.http.HttpServlet;
    16. import javax.servlet.http.HttpServletRequest;
    17. import javax.servlet.http.HttpServletResponse;
    18. import javax.servlet.http.HttpSession;
    19.  
    20. import org.apache.commons.fileupload.FileItem;
    21. import org.apache.commons.fileupload.FileUpload;
    22. import org.apache.commons.fileupload.RequestContext;
    23. import org.apache.commons.fileupload.disk.DiskFileItemFactory;
    24. import org.apache.commons.fileupload.servlet.ServletFileUpload;
    25. import org.apache.commons.fileupload.servlet.ServletRequestContext;
    26.  
    27. import util.Info;
    28.  
    29. import com.main.MainMethod;
    30.  
    31. import dao.CommDAO;
    32.  
    33. public class MainCtrl extends HttpServlet {
    34.  
    35. 	public MainCtrl() {
    36. 		super();
    37. 	}
    38.  
    39. 	public void destroy() {
    40. 		super.destroy(); // Just puts "destroy" string in log
    41. 		// Put your code here
    42. 	}
    43.  
    44. 	public void doGet(HttpServletRequest request, HttpServletResponse response)
    45. 			throws ServletException, IOException {
    46. 		this.doPost(request, response);
    47. 	}
    48.  
    49. 	MainMethod responses = new MainMethod();
    50.  
    51. 	public void go(String url, HttpServletRequest request,
    52. 			HttpServletResponse response) {
    53. 		try {
    54. 			request.getRequestDispatcher(url).forward(request, response);
    55. 		} catch (ServletException e) {
    56. 			e.printStackTrace();
    57. 		} catch (IOException e) {
    58. 			e.printStackTrace();
    59. 		}
    60. 	}
    61.  
    62. 	public void gor(String url, HttpServletRequest request,
    63. 			HttpServletResponse response) {
    64. 		try {
    65. 			response.sendRedirect(url);
    66. 		} catch (IOException e) {
    67. 			// TODO Auto-generated catch block
    68. 			e.printStackTrace();
    69. 		}
    70.  
    71. 	}
    72.  
    73. 	public void doPost(HttpServletRequest request, HttpServletResponse response)
    74. 			throws ServletException, IOException {
    75. 		response.setContentType("text/html");
    76. 		PrintWriter out = response.getWriter();
    77. 		HttpSession session = request.getSession();
    78. 		HashMap admin = (HashMap) session.getAttribute("admin");
    79. 		HashMap member = (HashMap) session.getAttribute("member");
    80. 		String ac = request.getParameter("ac");
    81. 		if (ac == null)
    82. 			ac = "";
    83. 		CommDAO dao = new CommDAO();
    84. 		String date = Info.getDateStr();
    85. 		String today = date.substring(0, 10);
    86. 		String tomonth = date.substring(0, 7);
    87.  
    88. 		// 登录
    89. 		if (ac.equals("login")) {
    90. 			String username = request.getParameter("username");
    91. 			String userpwd = request.getParameter("userpwd");
    92. 			String sql = "select * from sysuser where username='" + username
    93. 					+ "' and userpwd='" + userpwd
    94. 					+ "' and usertype in ('管理员') ";
    95.  
    96. 			List list = dao.select(sql);
    97. 			if (list.size() == 1) {
    98. 				session.setAttribute("admin", list.get(0));
    99. 				gor("/jsp_zhctms_site/admin/index.jsp", request, response);
    100. 			} else {
    101. 				request.setAttribute("error", "");
    102. 				go("admin/login.jsp", request, response);
    103. 			}
    104. 		}
    105. 		// 后台退出
    106. 		if (ac.equals("backexit")) {
    107. 			session.removeAttribute("admin");
    108. 			go("admin/login.jsp", request, response);
    109. 		}
    110.  
    111. 		// 新增新闻
    112. 		if (ac.equals("newsadd")) {
    113. 			try {
    114. 				String title = "";
    115. 				String img = "";
    116. 				String note = "";
    117. 				request.setCharacterEncoding("utf-8");
    118. 				RequestContext requestContext = new ServletRequestContext(
    119. 						request);
    120. 				if (FileUpload.isMultipartContent(requestContext)) {
    121. 					DiskFileItemFactory factory = new DiskFileItemFactory();
    122. 					factory.setRepository(new File(request
    123. 							.getRealPath("/upfile/") + "/"));
    124. 					ServletFileUpload upload = new ServletFileUpload(factory);
    125. 					upload.setSizeMax(100 * 1024 * 1024);
    126. 					List items = new ArrayList();
    127. 					items = upload.parseRequest(request);
    128.  
    129. 					title = ((FileItem) items.get(0)).getString();
    130. 					title = Info.getUTFStr(title);
    131.  
    132. 					note = ((FileItem) items.get(2)).getString();
    133. 					note = Info.getUTFStr(note);
    134.  
    135. 					FileItem fileItem = (FileItem) items.get(1);
    136. 					if (fileItem.getName() != null && fileItem.getSize() != 0) {
    137. 						if (fileItem.getName() != null
    138. 								&& fileItem.getSize() != 0) {
    139. 							File fullFile = new File(fileItem.getName());
    140. 							img = Info.generalFileName(fullFile.getName());
    141. 							File newFile = new File(
    142. 									request.getRealPath("/upfile/") + "/" + img);
    143. 							try {
    144. 								fileItem.write(newFile);
    145. 							} catch (Exception e) {
    146. 								e.printStackTrace();
    147. 							}
    148. 						} else {
    149. 						}
    150. 					}
    151. 				}
    152.  
    153. 				String sql = "insert into news (title,img,note,savetime,type) "
    154. 						+ "values('" + title + "','" + img + "','" + note
    155. 						+ "','" + Info.getDateStr() + "','新闻')";
    156. 				dao.commOper(sql);
    157.  
    158. 				request.setAttribute("suc", "操作成功!");
    159. 				go("/admin/newslist.jsp", request, response);
    160.  
    161. 			} catch (Exception e1) {
    162. 				e1.printStackTrace();
    163. 				request.setAttribute("error", "");
    164. 				request.getRequestDispatcher("/admin/newsadd.jsp").forward(
    165. 						request, response);
    166. 			}
    167. 		}
    168. 		// 编辑新闻
    169. 		if (ac.equals("newsedit")) {
    170. 			String id = request.getParameter("id");
    171. 			HashMap map = dao.select("select * from news where id=" + id)
    172. 					.get(0);
    173. 			try {
    174. 				String title = "";
    175. 				String note = "";
    176. 				String img = map.get("img").toString();
    177. 				request.setCharacterEncoding("utf-8");
    178. 				RequestContext requestContext = new ServletRequestContext(
    179. 						request);
    180. 				if (FileUpload.isMultipartContent(requestContext)) {
    181.  
    182. 					DiskFileItemFactory factory = new DiskFileItemFactory();
    183. 					factory.setRepository(new File(request
    184. 							.getRealPath("/upfile/") + "/"));
    185. 					ServletFileUpload upload = new ServletFileUpload(factory);
    186. 					upload.setSizeMax(100 * 1024 * 1024);
    187. 					List items = new ArrayList();
    188. 					items = upload.parseRequest(request);
    189. 					title = ((FileItem) items.get(0)).getString();
    190. 					title = Info.getUTFStr(title);
    191.  
    192. 					note = ((FileItem) items.get(2)).getString();
    193. 					note = Info.getUTFStr(note);
    194.  
    195. 					FileItem fileItem = (FileItem) items.get(1);
    196. 					if (fileItem.getName() != null && fileItem.getSize() != 0) {
    197. 						if (fileItem.getName() != null
    198. 								&& fileItem.getSize() != 0) {
    199. 							File fullFile = new File(fileItem.getName());
    200. 							img = Info.generalFileName(fullFile.getName());
    201. 							File newFile = new File(
    202. 									request.getRealPath("/upfile/") + "/" + img);
    203. 							try {
    204. 								fileItem.write(newFile);
    205. 							} catch (Exception e) {
    206. 								e.printStackTrace();
    207. 							}
    208. 						} else {
    209. 						}
    210. 					}
    211. 				}
    212. 				String sql = "update news set title='" + title + "',note='"
    213. 						+ note + "',img='" + img + "' where id=" + id;
    214. 				dao.commOper(sql);
    215. 				request.setAttribute("suc", "操作成功!");
    216. 				go("/admin/newslist.jsp?id=" + id, request, response);
    217. 			} catch (Exception e1) {
    218. 				e1.printStackTrace();
    219. 				request.setAttribute("error", "");
    220. 				request.getRequestDispatcher("/admin/newsedit.jsp?id=" + id)
    221. 						.forward(request, response);
    222. 			}
    223. 		}
    224. 		// 新增公告
    225. 		if (ac.equals("noticesadd")) {
    226. 			String title = request.getParameter("title");
    227. 			String note = request.getParameter("note");
    228. 			String savetime = Info.getDateStr();
    229. 			String type = "公告";
    230. 			dao.commOper("insert into news (title,note,savetime,type) "
    231. 					+ " values ('" + title + "','" + note + "','" + savetime
    232. 					+ "','" + type + "')");
    233. 			request.setAttribute("suc", "");
    234. 			go("admin/noticesadd.jsp", request, response);
    235. 		}
    236. 		// 编辑公告
    237. 		if (ac.equals("noticesedit")) {
    238. 			String id = request.getParameter("id");
    239. 			String title = request.getParameter("title");
    240. 			String note = request.getParameter("note");
    241. 			dao.commOper("update news set title='" + title + "',note='" + note
    242. 					+ "' where id=" + id);
    243. 			request.setAttribute("suc", "");
    244. 			go("admin/noticesedit.jsp?id=" + id, request, response);
    245. 		}
    246. 		// 新增链接
    247. 		if (ac.equals("yqlinkadd")) {
    248. 			String linkname = request.getParameter("linkname");
    249. 			String linkurl = request.getParameter("linkurl");
    250. 			dao.commOper("insert into yqlink (linkname,linkurl) "
    251. 					+ " values ('" + linkname + "','" + linkurl + "')");
    252. 			request.setAttribute("suc", "操作成功!");
    253. 			go("admin/yqlink.jsp", request, response);
    254. 		}
    255. 		// 编辑公告
    256. 		if (ac.equals("yqlinkedit")) {
    257. 			String id = request.getParameter("id");
    258. 			String linkname = request.getParameter("linkname");
    259. 			String linkurl = request.getParameter("linkurl");
    260. 			dao.commOper("update yqlink set linkname='" + linkname
    261. 					+ "',linkurl='" + linkurl + "' where id=" + id);
    262. 			request.setAttribute("suc", "操作成功!");
    263. 			go("admin/yqlink.jsp", request, response);
    264. 		}
    265. 		// 网站信息编辑
    266. 		if (ac.equals("siteinfoedit")) {
    267. 			String id = request.getParameter("id");
    268. 			HashMap map = dao.select("select * from siteinfo where id=" + id)
    269. 					.get(0);
    270. 			try {
    271. 				String tel = "";
    272. 				String addr = "";
    273. 				String note = "";
    274. 				String logoimg = map.get("logoimg").toString();
    275. 				request.setCharacterEncoding("utf-8");
    276. 				RequestContext requestContext = new ServletRequestContext(
    277. 						request);
    278. 				if (FileUpload.isMultipartContent(requestContext)) {
    279.  
    280. 					DiskFileItemFactory factory = new DiskFileItemFactory();
    281. 					factory.setRepository(new File(request
    282. 							.getRealPath("/upfile/") + "/"));
    283. 					ServletFileUpload upload = new ServletFileUpload(factory);
    284. 					upload.setSizeMax(100 * 1024 * 1024);
    285. 					List items = new ArrayList();
    286. 					items = upload.parseRequest(request);
    287. 					tel = ((FileItem) items.get(0)).getString();
    288. 					tel = Info.getUTFStr(tel);
    289. 					addr = ((FileItem) items.get(1)).getString();
    290. 					addr = Info.getUTFStr(addr);
    291. 					note = ((FileItem) items.get(3)).getString();
    292. 					note = Info.getUTFStr(note);
    293.  
    294. 					FileItem fileItem = (FileItem) items.get(2);
    295. 					if (fileItem.getName() != null && fileItem.getSize() != 0) {
    296. 						if (fileItem.getName() != null
    297. 								&& fileItem.getSize() != 0) {
    298. 							File fullFile = new File(fileItem.getName());
    299. 							logoimg = Info.generalFileName(fullFile.getName());
    300. 							File newFile = new File(
    301. 									request.getRealPath("/upfile/") + "/"
    302. 											+ logoimg);
    303. 							try {
    304. 								fileItem.write(newFile);
    305. 							} catch (Exception e) {
    306. 								e.printStackTrace();
    307. 							}
    308. 						} else {
    309. 						}
    310. 					}
    311. 				}
    312. 				String sql = "update siteinfo set tel='" + tel + "',addr='"
    313. 						+ addr + "',note='" + note + "',logoimg='" + logoimg
    314. 						+ "' where id=" + id;
    315. 				dao.commOper(sql);
    316. 				request.setAttribute("suc", "");
    317. 				go("/admin/siteinfo.jsp?id=" + id, request, response);
    318. 			} catch (Exception e1) {
    319. 				e1.printStackTrace();
    320. 				request.setAttribute("error", "");
    321. 				request.getRequestDispatcher("/admin/siteinfo.jsp?id=" + id)
    322. 						.forward(request, response);
    323. 			}
    324. 		}
    325. 		// 检查用户名唯一性AJAX
    326. 		if (ac.equals("sysuserscheck")) {
    327. 			String username = request.getParameter("username");
    328. 			ArrayList cklist = (ArrayList) dao
    329. 					.select("select * from sysuser where username='" + username
    330. 							+ "' and delstatus='0' ");
    331. 			if (cklist.size() > 0) {
    332. 				out.write("1");
    333. 			} else {
    334. 				out.write("0");
    335. 			}
    336. 		}
    337. 		// 新增管理员
    338. 		if (ac.equals("sysuseradd")) {
    339. 			String usertype = "管理员";
    340. 			String username = request.getParameter("username");
    341. 			String userpwd = request.getParameter("userpwd");
    342. 			String realname = request.getParameter("realname");
    343. 			String sex = request.getParameter("sex");
    344. 			String idcard = request.getParameter("idcard");
    345. 			String tel = request.getParameter("tel");
    346. 			String email = request.getParameter("email");
    347. 			String addr = request.getParameter("addr");
    348. 			String delstatus = "0";
    349. 			String savetime = Info.getDateStr();
    350. 			dao.commOper("insert into sysuser (usertype,username,userpwd,realname,sex,idcard,tel,email,addr,delstatus,savetime)"
    351. 					+ " values ('"
    352. 					+ usertype
    353. 					+ "','"
    354. 					+ username
    355. 					+ "','"
    356. 					+ userpwd
    357. 					+ "','"
    358. 					+ realname
    359. 					+ "','"
    360. 					+ sex
    361. 					+ "','"
    362. 					+ idcard
    363. 					+ "','"
    364. 					+ tel
    365. 					+ "','"
    366. 					+ email
    367. 					+ "','"
    368. 					+ addr
    369. 					+ "','"
    370. 					+ delstatus
    371. 					+ "','"
    372. 					+ savetime + "')");
    373. 			request.setAttribute("suc", "");
    374. 			go("/admin/sysuseradd.jsp", request, response);
    375. 		}
    376. 		// 编辑管理员
    377. 		if (ac.equals("sysuseredit")) {
    378. 			String id = request.getParameter("id");
    379. 			String userpwd = request.getParameter("userpwd");
    380. 			String realname = request.getParameter("realname");
    381. 			String sex = request.getParameter("sex");
    382. 			String idcard = request.getParameter("idcard");
    383. 			String tel = request.getParameter("tel");
    384. 			String email = request.getParameter("email");
    385. 			String addr = request.getParameter("addr");
    386. 			dao.commOper("update sysuser set userpwd='" + userpwd
    387. 					+ "',realname='" + realname + "',sex='" + sex
    388. 					+ "',idcard='" + idcard + "',tel='" + tel + "',email='"
    389. 					+ email + "',addr='" + addr + "' where id=" + id);
    390. 			request.setAttribute("suc", "");
    391. 			go("/admin/sysuseredit.jsp?id=" + id, request, response);
    392. 		}
    393. 		// 美食类别新增
    394. 		if (ac.equals("protypeadd")) {
    395. 			String typename = request.getParameter("typename");
    396. 			String fatherid = request.getParameter("fatherid");
    397. 			dao.commOper("insert into protype (typename,fatherid,delstatus) values ('"
    398. 					+ typename + "','" + fatherid + "','0') ");
    399. 			request.setAttribute("suc", "操作成功!");
    400. 			go("/admin/protype.jsp", request, response);
    401. 		}
    402. 		// 美食类别编辑
    403. 		if (ac.equals("protypeedit")) {
    404. 			String id = request.getParameter("id");
    405. 			String typename = request.getParameter("typename");
    406. 			dao.commOper("update protype set typename='" + typename
    407. 					+ "' where id=" + id);
    408. 			request.setAttribute("suc", "操作成功!");
    409. 			go("/admin/protype.jsp?id=" + id, request, response);
    410. 		}
    411. 		// 美食属性新增
    412. 		if (ac.equals("propertyadd")) {
    413. 			String propertyname = request.getParameter("propertyname");
    414. 			dao.commOper("insert into property (propertyname,delstatus) values ('"
    415. 					+ propertyname + "','0') ");
    416. 			request.setAttribute("suc", "");
    417. 			go("/admin/propertyadd.jsp", request, response);
    418. 		}
    419. 		// 美食属性编辑
    420. 		if (ac.equals("propertyedit")) {
    421. 			String id = request.getParameter("id");
    422. 			String propertyname = request.getParameter("propertyname");
    423. 			dao.commOper("update property set propertyname='" + propertyname
    424. 					+ "' where id=" + id);
    425. 			request.setAttribute("suc", "");
    426. 			go("/admin/propertyedit.jsp?id=" + id, request, response);
    427. 		}
    428. 		// AJAX根据父类查子类
    429. 		if (ac.equals("searchsontype")) {
    430. 			String xml_start = "";
    431. 			String xml_end = "";
    432. 			String xml = "";
    433. 			String fprotype = request.getParameter("fprotype");
    434. 			ArrayList list = (ArrayList) dao
    435. 					.select("select * from protype where fatherid='" + fprotype
    436. 							+ "' and delstatus='0' ");
    437. 			if (list.size() > 0) {
    438. 				for (HashMap map : list) {
    439. 					xml += "";
    440. 				}
    441. 			}
    442. 			String last_xml = xml_start + xml + xml_end;
    443. 			response.setContentType("text/xml;charset=GB2312");
    444. 			response.setCharacterEncoding("utf-8");
    445. 			response.getWriter().write(last_xml);
    446. 			response.getWriter().flush();
    447.  
    448. 		}
    449. 		// 公用方法，图片上传
    450. 		if (ac.equals("uploadimg")) {
    451. 			try {
    452. 				String filename = "";
    453. 				request.setCharacterEncoding("utf-8");
    454. 				RequestContext requestContext = new ServletRequestContext(
    455. 						request);
    456. 				if (FileUpload.isMultipartContent(requestContext)) {
    457.  
    458. 					DiskFileItemFactory factory = new DiskFileItemFactory();
    459. 					factory.setRepository(new File(request
    460. 							.getRealPath("/upfile/") + "/"));
    461. 					ServletFileUpload upload = new ServletFileUpload(factory);
    462. 					upload.setSizeMax(100 * 1024 * 1024);
    463. 					List items = new ArrayList();
    464. 					items = upload.parseRequest(request);
    465. 					FileItem fileItem = (FileItem) items.get(0);
    466. 					if (fileItem.getName() != null && fileItem.getSize() != 0) {
    467. 						if (fileItem.getName() != null
    468. 								&& fileItem.getSize() != 0) {
    469. 							File fullFile = new File(fileItem.getName());
    470. 							filename = Info.generalFileName(fullFile.getName());
    471. 							File newFile = new File(
    472. 									request.getRealPath("/upfile/") + "/"
    473. 											+ filename);
    474. 							try {
    475. 								fileItem.write(newFile);
    476. 							} catch (Exception e) {
    477. 								e.printStackTrace();
    478. 							}
    479. 						} else {
    480. 						}
    481. 					}
    482. 				}
    483.  
    484. 				go("/js/uploadimg.jsp?filename=" + filename, request, response);
    485. 			} catch (Exception e1) {
    486. 				e1.printStackTrace();
    487. 			}
    488. 		}
    489.  
    490. 		// 库存预警数值设置
    491. 		if (ac.equals("kcwarningset")) {
    492. 			String num = request.getParameter("num");
    493. 			String id = request.getParameter("id");
    494. 			dao.commOper("update kcwarnning set num=" + Integer.parseInt(num)
    495. 					+ " where id=" + id);
    496. 			request.setAttribute("suc", "");
    497. 			go("/admin/kcwarningset.jsp", request, response);
    498. 		}
    499. 		// 美食入库
    500. 		if (ac.equals("kcinto")) {
    501. 			String pid = request.getParameter("pid");
    502. 			String num = request.getParameter("num");
    503. 			String type = request.getParameter("type");
    504. 			String reason = request.getParameter("reason");
    505. 			String savetime = Info.getDateStr();
    506. 			dao.commOper("insert into kcrecord (pid,num,type,reason,savetime) values"
    507. 					+ " ('"
    508. 					+ pid
    509. 					+ "','"
    510. 					+ Integer.parseInt(num)
    511. 					+ "','"
    512. 					+ type + "','" + reason + "','" + savetime + "') ");
    513. 			request.setAttribute("suc", "");
    514. 			go("/admin/kcinto.jsp", request, response);
    515. 		}
    516. 		// 美食出库
    517. 		if (ac.equals("kcout")) {
    518. 			String pid = request.getParameter("pid");
    519. 			String num = request.getParameter("num");
    520. 			String type = request.getParameter("type");
    521. 			String reason = request.getParameter("reason");
    522. 			String savetime = Info.getDateStr();
    523.  
    524. 			int znum = 0;
    525. 			int innum = 0;
    526. 			int outnum = 0;
    527. 			ArrayList inlist = (ArrayList) dao
    528. 					.select("select * from kcrecord where  type='in' and pid='"
    529. 							+ pid + "' ");
    530. 			ArrayList outlist = (ArrayList) dao
    531. 					.select("select * from kcrecord where  type='out' and pid='"
    532. 							+ pid + "' ");
    533. 			if (inlist.size() > 0) {
    534. 				for (HashMap inmap : inlist) {
    535. 					innum += Integer.parseInt(inmap.get("num").toString());// 总入库量
    536. 				}
    537. 			}
    538. 			if (outlist.size() > 0) {
    539. 				for (HashMap outmap : outlist) {
    540. 					outnum += Integer.parseInt(outmap.get("num").toString());// 总出库量
    541. 				}
    542. 			}
    543. 			znum = innum - outnum;// 库存量
    544. 			if (Integer.parseInt(num) > znum) {
    545. 				request.setAttribute("no", "");
    546. 				go("/admin/kcout.jsp", request, response);
    547. 			} else {
    548. 				dao.commOper("insert into kcrecord (pid,num,type,reason,savetime) values"
    549. 						+ " ('"
    550. 						+ pid
    551. 						+ "','"
    552. 						+ Integer.parseInt(num)
    553. 						+ "','"
    554. 						+ type + "','" + reason + "','" + savetime + "') ");
    555. 				request.setAttribute("suc", "");
    556. 				go("/admin/kcout.jsp", request, response);
    557. 			}
    558. 		}
    559.  
    560. 		// 新增图片
    561. 		if (ac.equals("imgadvaddold")) {
    562. 			try {
    563. 				String img = "";
    564. 				String imgtype = "";
    565. 				request.setCharacterEncoding("utf-8");
    566. 				RequestContext requestContext = new ServletRequestContext(
    567. 						request);
    568. 				if (FileUpload.isMultipartContent(requestContext)) {
    569. 					DiskFileItemFactory factory = new DiskFileItemFactory();
    570. 					factory.setRepository(new File(request
    571. 							.getRealPath("/upfile/") + "/"));
    572. 					ServletFileUpload upload = new ServletFileUpload(factory);
    573. 					upload.setSizeMax(100 * 1024 * 1024);
    574. 					List items = new ArrayList();
    575. 					items = upload.parseRequest(request);
    576.  
    577. 					imgtype = ((FileItem) items.get(1)).getString();
    578. 					imgtype = Info.getUTFStr(imgtype);
    579.  
    580. 					FileItem fileItem = (FileItem) items.get(0);
    581. 					if (fileItem.getName() != null && fileItem.getSize() != 0) {
    582. 						if (fileItem.getName() != null
    583. 								&& fileItem.getSize() != 0) {
    584. 							File fullFile = new File(fileItem.getName());
    585. 							img = Info.generalFileName(fullFile.getName());
    586. 							File newFile = new File(
    587. 									request.getRealPath("/upfile/") + "/" + img);
    588. 							try {
    589. 								fileItem.write(newFile);
    590. 							} catch (Exception e) {
    591. 								e.printStackTrace();
    592. 							}
    593. 						} else {
    594. 						}
    595. 					}
    596. 				}
    597.  
    598. 				String cksql = "select * from imgadv where imgtype='banner'";
    599. 				ArrayList cklist = (ArrayList) dao.select(cksql);
    600. 				if (imgtype.equals("banner") && cklist.size() != 0) {
    601. 					request.setAttribute("no", "");
    602. 					go("/admin/imgadvadd.jsp", request, response);
    603. 				} else {
    604. 					String sql = "insert into imgadv (filename,imgtype) "
    605. 							+ "values('" + img + "','" + imgtype + "')";
    606. 					dao.commOper(sql);
    607. 					request.setAttribute("suc", "");
    608. 					go("/admin/imgadvadd.jsp", request, response);
    609. 				}
    610. 			} catch (Exception e1) {
    611. 				e1.printStackTrace();
    612. 				request.setAttribute("no", "");
    613. 				request.getRequestDispatcher("/admin/imgadvadd.jsp").forward(
    614. 						request, response);
    615. 			}
    616. 		}
    617. 		// 编辑图片
    618. 		if (ac.equals("imgadvedit")) {
    619. 			String id = request.getParameter("id");
    620. 			HashMap map = dao.select("select * from imgadv where id=" + id)
    621. 					.get(0);
    622. 			try {
    623. 				String img = map.get("filename").toString();
    624. 				request.setCharacterEncoding("utf-8");
    625. 				RequestContext requestContext = new ServletRequestContext(
    626. 						request);
    627. 				if (FileUpload.isMultipartContent(requestContext)) {
    628.  
    629. 					DiskFileItemFactory factory = new DiskFileItemFactory();
    630. 					factory.setRepository(new File(request
    631. 							.getRealPath("/upfile/") + "/"));
    632. 					ServletFileUpload upload = new ServletFileUpload(factory);
    633. 					upload.setSizeMax(100 * 1024 * 1024);
    634. 					List items = new ArrayList();
    635. 					items = upload.parseRequest(request);
    636.  
    637. 					FileItem fileItem = (FileItem) items.get(0);
    638. 					if (fileItem.getName() != null && fileItem.getSize() != 0) {
    639. 						if (fileItem.getName() != null
    640. 								&& fileItem.getSize() != 0) {
    641. 							File fullFile = new File(fileItem.getName());
    642. 							img = Info.generalFileName(fullFile.getName());
    643. 							File newFile = new File(
    644. 									request.getRealPath("/upfile/") + "/" + img);
    645. 							try {
    646. 								fileItem.write(newFile);
    647. 							} catch (Exception e) {
    648. 								e.printStackTrace();
    649. 							}
    650. 						} else {
    651. 						}
    652. 					}
    653. 				}
    654. 				String sql = "update imgadv set filename='" + img
    655. 						+ "' where id=" + id;
    656. 				dao.commOper(sql);
    657. 				request.setAttribute("suc", "");
    658. 				go("/admin/imgadvedit.jsp?id=" + id, request, response);
    659. 			} catch (Exception e1) {
    660. 				e1.printStackTrace();
    661. 				request.setAttribute("error", "");
    662. 				request.getRequestDispatcher("/admin/imgadvedit.jsp?id=" + id)
    663. 						.forward(request, response);
    664. 			}
    665. 		}
    666.  
    667. 		// 检查用户名唯一性AJAX 会员注册
    668. 		if (ac.equals("memberunamecheck")) {
    669. 			String uname = request.getParameter("username");
    670. 			ArrayList cklist = (ArrayList) dao
    671. 					.select("select * from member where uname='" + uname
    672. 							+ "' and delstatus='0' ");
    673. 			if (cklist.size() > 0) {
    674. 				out.print("false");
    675.  
    676. 			} else {
    677. 				out.print("true");
    678. 			}
    679. 		}
    680.  
    681. 		// 检查美食的库存
    682. 		if (ac.equals("checkgoodkc")) {
    683. 			String gid = request.getParameter("gid");
    684. 			String sl = request.getParameter("sl");
    685. 			if (Integer.valueOf(sl) > Info.getkc(gid)) {
    686. 				out.write("1");
    687. 			} else {
    688. 				out.write("0");
    689. 			}
    690. 		}
    691. 		// 美食加入购物车
    692. 		if (ac.equals("tocar")) {
    693. 			String gid = request.getParameter("gid");
    694. 			int sl = Integer.valueOf(request.getParameter("sl"));
    695. 			if (member != null) {
    696. 				String mid = member.get("id").toString();
    697. 				// 检查该人的购物车是否有该物品
    698. 				ArrayList cklist = (ArrayList) dao
    699. 						.select("select * from car where mid='" + mid
    700. 								+ "' and gid='" + gid + "'");
    701. 				if (cklist.size() > 0) {
    702. 					dao.commOper("update car set sl=sl+" + sl + " where mid='"
    703. 							+ mid + "' and gid='" + gid + "' ");
    704. 				} else {
    705. 					dao.commOper("insert into car (gid,sl,mid) values ('" + gid
    706. 							+ "','" + sl + "','" + mid + "')");
    707. 				}
    708. 				out.print("true");
    709. 			} else {
    710. 				out.print("false");
    711. 			}
    712. 			// request.setAttribute("suc", "");
    713. 			// go("/tocar.jsp?gid="+gid, request, response);
    714. 		}
    715.  
    716. 		// 直接购买
    717. 		if (ac.equals("tobuy")) {
    718. 			String gid = request.getParameter("gid");
    719. 			int sl = Integer.valueOf(request.getParameter("sl"));
    720. 			String ddno = Info.getAutoNo();
    721. 			String shrname = "";
    722. 			String shrtel = "";
    723. 			String shraddr = request.getParameter("addr");
    724. 			double ddprice = 0.0;
    725. 			String fhstatus = "待发货";
    726. 			String shstatus = "待收货";
    727. 			String fkstatus = "待付款";
    728. 			String wlinfo = "暂无物流信息";
    729. 			String savetime = Info.getDateStr();
    730.  
    731. 			if (member != null) {
    732. 				String memberid = member.get("id").toString();
    733. 				ArrayList addrlist = (ArrayList) dao
    734. 						.select("select * from addr where delstatus='0' and memberid="
    735. 								+ member.get("id"));
    736. 				if (addrlist.size() == 0) {
    737. 					out.print("false");
    738. 				} else {
    739. 					shraddr = addrlist.get(0).get("id").toString();
    740. 					HashMap gmap = dao.select(
    741. 							"select * from goods where id=" + gid).get(0);
    742. 					String price = gmap.get("price").toString();
    743. 					if (gmap.get("tprice") != null
    744. 							&& !gmap.get("tprice").equals("")) {
    745. 						price = gmap.get("tprice").toString();
    746. 					}
    747. 					ddprice = Double.valueOf(price) * sl;
    748. 					// 直接生成订单
    749. 					dao.commOper("insert into ddinfo (ddno,memberid,ddprice,fhstatus,savetime,shstatus,wlinfo,fkstatus,shrname,shrtel,shraddr) values "
    750. 							+ "('"
    751. 							+ ddno
    752. 							+ "','"
    753. 							+ memberid
    754. 							+ "','"
    755. 							+ ddprice
    756. 							+ "','"
    757. 							+ fhstatus
    758. 							+ "','"
    759. 							+ savetime
    760. 							+ "','"
    761. 							+ shstatus
    762. 							+ "','"
    763. 							+ wlinfo
    764. 							+ "','"
    765. 							+ fkstatus
    766. 							+ "','"
    767. 							+ shrname + "','" + shrtel + "','" + shraddr + "')");
    768. 					dao.commOper("insert into dddetail (ddno,goodid,sl) values ('"
    769. 							+ ddno + "','" + gid + "','" + sl + "') ");
    770.  
    771. 					out.print("true");
    772. 				}
    773. 			} else {
    774. 				out.print("false");
    775. 			}
    776. 			// request.setAttribute("suc", "");
    777. 			// go("/tocar.jsp?gid="+gid, request, response);
    778. 		}
    779.  
    780. 		// 购物车内美食数量修改
    781. 		if (ac.equals("updatecart")) {
    782. 			String id = request.getParameter("carid");
    783. 			int sl = Integer.valueOf(request.getParameter("sl"));
    784. 			dao.commOper("update car set sl=" + sl + " where id=" + id);
    785. 			out.print("true");
    786. 		}
    787.  
    788. 		// 购物车内美食总价
    789. 		if (ac.equals("updatetprice")) {
    790. 			ArrayList goodlist = (ArrayList) dao
    791. 					.select("select *,a.id as aid,b.id as bid from car a,goods b where a.gid=b.id and a.mid='"
    792. 							+ member.get("id")
    793. 							+ "' and b.delstatus='0' order by a.id desc");
    794. 			double totalprice = 0.0;
    795. 			for (HashMap carmap : goodlist) {
    796. 				if (carmap.get("tprice") != null
    797. 						&& !carmap.get("tprice").equals("")) {
    798. 					totalprice += Double.valueOf(carmap.get("tprice")
    799. 							.toString())
    800. 							* Integer.valueOf(carmap.get("sl").toString());
    801. 				} else {
    802. 					totalprice += Double
    803. 							.valueOf(carmap.get("price").toString())
    804. 							* Integer.valueOf(carmap.get("sl").toString());
    805. 				}
    806. 			}
    807. 			out.print(totalprice);
    808. 		}
    809.  
    810. 		// 提交生成订单 填写收货信息
    811. 		if (ac.equals("submitorder")) {
    812. 			String memberid = member.get("id").toString();
    813. 			// 生成订单号
    814. 			String ddno = Info.getAutoNo();
    815. 			String shrname = "";
    816. 			String shrtel = "";
    817. 			String shraddr = request.getParameter("addr");
    818. 			double ddprice = 0.0;
    819. 			String fhstatus = "待发货";
    820. 			String shstatus = "待收货";
    821. 			String fkstatus = "待付款";
    822. 			String wlinfo = "暂无物流信息";
    823. 			String savetime = Info.getDateStr();
    824. 			// 查询该会员的购物车所有美食
    825. 			ArrayList carlist = (ArrayList) dao
    826. 					.select("select * from car where mid=" + memberid);
    827. 			for (HashMap carmap : carlist) {
    828. 				HashMap goodmap = dao.select(
    829. 						"select * from goods where id=" + carmap.get("gid"))
    830. 						.get(0);
    831. 				if (goodmap.get("tprice") != null
    832. 						&& !goodmap.get("tprice").equals("")) {
    833. 					ddprice += Double.valueOf(goodmap.get("tprice").toString())
    834. 							* Integer.valueOf(carmap.get("sl").toString());
    835. 				} else {
    836. 					ddprice += Double.valueOf(goodmap.get("price").toString())
    837. 							* Integer.valueOf(carmap.get("sl").toString());
    838. 				}
    839.  
    840. 				dao.commOper("insert into dddetail (ddno,goodid,sl) values ('"
    841. 						+ ddno + "','" + carmap.get("gid") + "','"
    842. 						+ carmap.get("sl") + "') ");
    843. 			}
    844. 			dao.commOper("insert into ddinfo (ddno,memberid,ddprice,fhstatus,savetime,shstatus,wlinfo,fkstatus,shrname,shrtel,shraddr) values "
    845. 					+ "('"
    846. 					+ ddno
    847. 					+ "','"
    848. 					+ memberid
    849. 					+ "','"
    850. 					+ ddprice
    851. 					+ "','"
    852. 					+ fhstatus
    853. 					+ "','"
    854. 					+ savetime
    855. 					+ "','"
    856. 					+ shstatus
    857. 					+ "','"
    858. 					+ wlinfo
    859. 					+ "','"
    860. 					+ fkstatus
    861. 					+ "','"
    862. 					+ shrname
    863. 					+ "','"
    864. 					+ shrtel + "','" + shraddr + "')");
    865. 			// 删除购物车下的美食
    866. 			dao.commOper("delete from car where mid=" + memberid);
    867. 			request.setAttribute("suc", "订单生成成功!");
    868. 			go("/mydd.jsp", request, response);
    869. 		}
    870.  
    871. 		//
    872. 		if (ac.equals("pay")) {
    873. 			String ddid = request.getParameter("ddid");
    874. 			String fkstatus = "已付款";
    875. 			String fhstatus = "待发货";
    876. 			String shstatus = "待收货";
    877. 			dao.commOper("update ddinfo set fkstatus='" + fkstatus
    878. 					+ "',fhstatus='" + fhstatus + "',shstatus='" + shstatus
    879. 					+ "' where id=" + ddid);
    880. 			request.setAttribute("suc", "支付成功!");
    881. 			go("/mydd.jsp?ddid=" + ddid, request, response);
    882. 		}
    883. 		// 订单发货
    884. 		if (ac.equals("ddfh")) {
    885. 			String ddid = request.getParameter("ddid");
    886. 			String wlcompany = request.getParameter("wlcompany");
    887. 			String wlno = request.getParameter("wlno");
    888. 			String wlinfo = wlcompany + "
      "       + wlno;
    889. 			// 查询订单及订单详情表
    890. 			HashMap ddmap = dao.select("select * from ddinfo where id=" + ddid)
    891. 					.get(0);
    892. 			ArrayList dddetaillist = (ArrayList) dao
    893. 					.select("select * from dddetail where ddno="
    894. 							+ ddmap.get("ddno"));
    895. 			boolean flag = true;// 用作订单美食库存校验结果
    896. 			for (HashMap dddetailmap : dddetaillist) {
    897. 				// 如果其中某个美食的数量大于其库存量 则置 FLASE标识
    898. 				if (Integer.valueOf(dddetailmap.get("sl").toString()) > Info
    899. 						.getkc(dddetailmap.get("goodid").toString())) {
    900. 					flag = false;
    901. 				}
    902. 			}
    903. 			if (flag) {
    904. 				dao.commOper("update ddinfo set fhstatus='已发货',wlinfo='"
    905. 						+ wlinfo + "' where id=" + ddid);
    906. 				// 发货后减库存
    907. 				for (HashMap dddetailmap : dddetaillist) {
    908. 					dao.commOper("insert into kcrecord (gid,happennum,type,savetime) values "
    909. 							+ "('"
    910. 							+ dddetailmap.get("goodid")
    911. 							+ "','"
    912. 							+ dddetailmap.get("sl")
    913. 							+ "','out','"
    914. 							+ Info.getDateStr() + "')");
    915. 				}
    916.  
    917. 				request.setAttribute("info", "订单已发货!");
    918. 				go("/admin/ddgl.jsp", request, response);
    919. 			} else {
    920. 				request.setAttribute("info", "订单中美食库存不足，发货失败!");
    921. 				go("/admin/ddgl.jsp", request, response);
    922. 			}
    923. 		}
    924.  
    925. 		// 会员注册
    926. 		if (ac.equals("register")) {
    927. 			String uname = request.getParameter("username");
    928. 			String upass = request.getParameter("upass");
    929. 			String email = request.getParameter("email") == null ? "" : request
    930. 					.getParameter("email");
    931. 			String tname = request.getParameter("tname") == null ? "" : request
    932. 					.getParameter("tname");
    933. 			String sex = request.getParameter("sex") == null ? "" : request
    934. 					.getParameter("sex");
    935. 			String addr = request.getParameter("addr") == null ? "" : request
    936. 					.getParameter("addr");
    937. 			String ybcode = request.getParameter("ybcode") == null ? ""
    938. 					: request.getParameter("ybcode");
    939. 			String qq = request.getParameter("qq") == null ? "" : request
    940. 					.getParameter("qq");
    941. 			String tel = request.getParameter("tel") == null ? "" : request
    942. 					.getParameter("tel");
    943. 			String delstatus = "0";
    944. 			String savetime = Info.getDateStr();
    945. 			dao.commOper("insert into member (uname,upass,email,tname,sex,addr,ybcode,qq,tel,delstatus,savetime)"
    946. 					+ " values ('"
    947. 					+ uname
    948. 					+ "','"
    949. 					+ upass
    950. 					+ "','"
    951. 					+ email
    952. 					+ "','"
    953. 					+ tname
    954. 					+ "','"
    955. 					+ sex
    956. 					+ "','"
    957. 					+ addr
    958. 					+ "','"
    959. 					+ ybcode
    960. 					+ "','"
    961. 					+ qq
    962. 					+ "','" + tel + "','" + delstatus + "','" + savetime + "')");
    963. 			request.setAttribute("suc", "注册成功");
    964. 			go("/reg.jsp", request, response);
    965. 		}
    966.  
    967. 		// 会员修改个人信息
    968. 		if (ac.equals("memberinfo")) {
    969. 			String id = request.getParameter("id");
    970. 			String upass = request.getParameter("upass");
    971. 			String email = request.getParameter("email") == null ? "" : request
    972. 					.getParameter("email");
    973. 			String tname = request.getParameter("tname") == null ? "" : request
    974. 					.getParameter("tname");
    975. 			String sex = request.getParameter("sex") == null ? "" : request
    976. 					.getParameter("sex");
    977. 			String addr = request.getParameter("addr") == null ? "" : request
    978. 					.getParameter("addr");
    979. 			String ybcode = request.getParameter("ybcode") == null ? ""
    980. 					: request.getParameter("ybcode");
    981. 			String qq = request.getParameter("qq") == null ? "" : request
    982. 					.getParameter("qq");
    983. 			String tel = request.getParameter("tel") == null ? "" : request
    984. 					.getParameter("tel");
    985. 			dao.commOper("update member set upass='" + upass + "',email='"
    986. 					+ email + "',tname='" + tname + "',sex='" + sex
    987. 					+ "',addr='" + addr + "',ybcode='" + ybcode + "',qq='" + qq
    988. 					+ "',tel='" + tel + "' where id=" + id);
    989. 			request.setAttribute("suc", "会员信息修改成功!");
    990. 			go("/grinfo.jsp", request, response);
    991. 		}
    992.  
    993. 		// 会员登录
    994. 		if (ac.equals("frontlogin")) {
    995. 			String uname = request.getParameter("uname");
    996. 			String upass = request.getParameter("upass");
    997. 			ArrayList cklist = (ArrayList) dao
    998. 					.select("select * from member where uname='" + uname
    999. 							+ "' and upass='" + upass + "' and delstatus='0'");
    1000. 			if (cklist.size() > 0) {
    1001. 				session.setAttribute("member", cklist.get(0));
    1002. 				go("/index.jsp", request, response);
    1003. 			} else {
    1004. 				request.setAttribute("no", "用户名或密码错误!");
    1005. 				go("/login.jsp", request, response);
    1006. 			}
    1007.  
    1008. 		}
    1009.  
    1010. 		// 前台退出
    1011. 		if (ac.equals("frontexit")) {
    1012. 			session.removeAttribute("member");
    1013. 			go("/index.jsp", request, response);
    1014. 		}
    1015.  
    1016. 		// 发布美食
    1017. 		if (ac.equals("goodsadd")) {
    1018. 			try {
    1019. 				String goodno = Info.getAutoNo();
    1020. 				String goodname = "";
    1021. 				String fid = "";
    1022. 				String sid = "";
    1023. 				String goodpp = "";
    1024. 				String price = "";
    1025. 				String filename = "";
    1026. 				String note = "";
    1027. 				String shstatus = "通过";
    1028. 				String istj = "no";
    1029. 				String savetime = Info.getDateStr();
    1030. 				String tprice = "";
    1031. 				request.setCharacterEncoding("utf-8");
    1032. 				RequestContext requestContext = new ServletRequestContext(
    1033. 						request);
    1034. 				if (FileUpload.isMultipartContent(requestContext)) {
    1035. 					DiskFileItemFactory factory = new DiskFileItemFactory();
    1036. 					factory.setRepository(new File(request
    1037. 							.getRealPath("/upfile/") + "/"));
    1038. 					ServletFileUpload upload = new ServletFileUpload(factory);
    1039. 					upload.setSizeMax(100 * 1024 * 1024);
    1040. 					List items = new ArrayList();
    1041. 					items = upload.parseRequest(request);
    1042. 					goodname = ((FileItem) items.get(0)).getString();
    1043. 					goodname = Info.getUTFStr(goodname);
    1044. 					fid = ((FileItem) items.get(1)).getString();
    1045. 					fid = Info.getUTFStr(fid);
    1046. 					sid = ((FileItem) items.get(2)).getString();
    1047. 					sid = Info.getUTFStr(sid);
    1048. 					goodpp = ((FileItem) items.get(3)).getString();
    1049. 					goodpp = Info.getUTFStr(goodpp);
    1050. 					price = ((FileItem) items.get(4)).getString();
    1051. 					price = Info.getUTFStr(price);
    1052. 					note = ((FileItem) items.get(6)).getString();
    1053. 					note = Info.getUTFStr(note);
    1054. 					FileItem fileItem = (FileItem) items.get(5);
    1055. 					if (fileItem.getName() != null && fileItem.getSize() != 0) {
    1056. 						if (fileItem.getName() != null
    1057. 								&& fileItem.getSize() != 0) {
    1058. 							File fullFile = new File(fileItem.getName());
    1059. 							filename = Info.generalFileName(fullFile.getName());
    1060. 							File newFile = new File(
    1061. 									request.getRealPath("/upfile/") + "/"
    1062. 											+ filename);
    1063. 							try {
    1064. 								fileItem.write(newFile);
    1065. 							} catch (Exception e) {
    1066. 								e.printStackTrace();
    1067. 							}
    1068. 						} else {
    1069. 						}
    1070. 					}
    1071. 				}
    1072. 				dao.commOper("insert into goods (goodno,goodname,fid,sid,price,note,savetime,shstatus,filename,istj,tprice,delstatus,salestatus,goodpp) "
    1073. 						+ "values ('"
    1074. 						+ goodno
    1075. 						+ "','"
    1076. 						+ goodname
    1077. 						+ "','"
    1078. 						+ fid
    1079. 						+ "','"
    1080. 						+ sid
    1081. 						+ "','"
    1082. 						+ price
    1083. 						+ "','"
    1084. 						+ note
    1085. 						+ "','"
    1086. 						+ savetime
    1087. 						+ "','通过','"
    1088. 						+ filename
    1089. 						+ "','"
    1090. 						+ istj
    1091. 						+ "','"
    1092. 						+ tprice
    1093. 						+ "','0','在售','" + goodpp + "') ");
    1094. 				request.setAttribute("suc", "操作成功!");
    1095. 				go("/admin/goodsgl.jsp", request, response);
    1096.  
    1097. 			} catch (Exception e1) {
    1098. 				e1.printStackTrace();
    1099. 				request.setAttribute("error", "");
    1100. 				request.getRequestDispatcher("/admin/goodsgl.jsp").forward(
    1101. 						request, response);
    1102. 			}
    1103.  
    1104. 		}
    1105. 		// 会员修改美食
    1106. 		if (ac.equals("goodsedit")) {
    1107. 			String id = request.getParameter("id");
    1108. 			HashMap map = dao.select("select * from goods where id=" + id).get(
    1109. 					0);
    1110. 			try {
    1111. 				String goodname = "";
    1112. 				String fid = "";
    1113. 				String sid = "";
    1114. 				String goodpp = "";
    1115. 				String price = "";
    1116. 				String note = "";
    1117. 				String filename = map.get("filename").toString();
    1118. 				request.setCharacterEncoding("utf-8");
    1119. 				RequestContext requestContext = new ServletRequestContext(
    1120. 						request);
    1121. 				if (FileUpload.isMultipartContent(requestContext)) {
    1122.  
    1123. 					DiskFileItemFactory factory = new DiskFileItemFactory();
    1124. 					factory.setRepository(new File(request
    1125. 							.getRealPath("/upfile/") + "/"));
    1126. 					ServletFileUpload upload = new ServletFileUpload(factory);
    1127. 					upload.setSizeMax(100 * 1024 * 1024);
    1128. 					List items = new ArrayList();
    1129. 					items = upload.parseRequest(request);
    1130. 					goodname = ((FileItem) items.get(0)).getString();
    1131. 					goodname = Info.getUTFStr(goodname);
    1132. 					fid = ((FileItem) items.get(1)).getString();
    1133. 					fid = Info.getUTFStr(fid);
    1134. 					sid = ((FileItem) items.get(2)).getString();
    1135. 					sid = Info.getUTFStr(sid);
    1136. 					goodpp = ((FileItem) items.get(3)).getString();
    1137. 					goodpp = Info.getUTFStr(goodpp);
    1138. 					price = ((FileItem) items.get(4)).getString();
    1139. 					price = Info.getUTFStr(price);
    1140. 					note = ((FileItem) items.get(6)).getString();
    1141. 					note = Info.getUTFStr(note);
    1142. 					FileItem fileItem = (FileItem) items.get(5);
    1143. 					if (fileItem.getName() != null && fileItem.getSize() != 0) {
    1144. 						if (fileItem.getName() != null
    1145. 								&& fileItem.getSize() != 0) {
    1146. 							File fullFile = new File(fileItem.getName());
    1147. 							filename = Info.generalFileName(fullFile.getName());
    1148. 							File newFile = new File(
    1149. 									request.getRealPath("/upfile/") + "/"
    1150. 											+ filename);
    1151. 							try {
    1152. 								fileItem.write(newFile);
    1153. 							} catch (Exception e) {
    1154. 								e.printStackTrace();
    1155. 							}
    1156. 						} else {
    1157. 						}
    1158. 					}
    1159. 				}
    1160. 				dao.commOper("update goods set goodname='" + goodname
    1161. 						+ "',fid='" + fid + "',sid='" + sid + "',price='"
    1162. 						+ price + "',note='" + note + "',filename='" + filename
    1163. 						+ "',goodpp='" + goodpp + "' where id=" + id);
    1164. 				request.setAttribute("suc", "操作成功!");
    1165. 				go("/admin/goodsgl.jsp?id=" + id, request, response);
    1166. 			} catch (Exception e1) {
    1167. 				e1.printStackTrace();
    1168. 				request.setAttribute("error", "");
    1169. 				request.getRequestDispatcher("/admin/goodsgl.jsp").forward(
    1170. 						request, response);
    1171. 			}
    1172.  
    1173. 		}
    1174. 		// 美食入库
    1175. 		if (ac.equals("goodskcadd")) {
    1176. 			String gid = request.getParameter("gid");
    1177. 			String happennum = request.getParameter("happennum");
    1178. 			String type = "in";
    1179. 			String savetime = Info.getDateStr();
    1180. 			dao.commOper("insert into kcrecord (gid,happennum,type,savetime) values "
    1181. 					+ "('"
    1182. 					+ gid
    1183. 					+ "','"
    1184. 					+ happennum
    1185. 					+ "','"
    1186. 					+ type
    1187. 					+ "','"
    1188. 					+ savetime + "') ");
    1189. 			request.setAttribute("suc", "操作成功!");
    1190. 			go("/admin/goodskc.jsp", request, response);
    1191. 		}
    1192.  
    1193. 		// 美食评论
    1194. 		if (ac.equals("goodpj")) {
    1195. 			String goodid = request.getParameter("id");
    1196. 			String memberid = member.get("id").toString();
    1197. 			String note = request.getParameter("note");
    1198. 			String savetime = Info.getDateStr();
    1199. 			dao.commOper("insert into goodspj (goodid,memberid,note,savetime) values ('"
    1200. 					+ goodid
    1201. 					+ "','"
    1202. 					+ memberid
    1203. 					+ "','"
    1204. 					+ note
    1205. 					+ "','"
    1206. 					+ savetime + "')");
    1207. 			request.setAttribute("suc", "");
    1208. 			go("/goodsx.jsp?id=" + goodid, request, response);
    1209. 		}
    1210.  
    1211. 		// 美食购买成功后的评价
    1212. 		if (ac.equals("pj")) {
    1213. 			String goodid = request.getParameter("goodid");
    1214. 			String memberid = member.get("id").toString();
    1215. 			String jb = request.getParameter("jb");
    1216. 			String msg = request.getParameter("msg");
    1217. 			String savetime = Info.getDateStr();
    1218. 			HashMap mm = dao.select("select * from goods where id=" + goodid)
    1219. 					.get(0);
    1220. 			dao.commOper("insert into pj (goodid,goodsaver,memberid,jb,msg,savetime,hf) values "
    1221. 					+ "('"
    1222. 					+ goodid
    1223. 					+ "','"
    1224. 					+ mm.get("saver")
    1225. 					+ "','"
    1226. 					+ memberid
    1227. 					+ "','"
    1228. 					+ jb
    1229. 					+ "','"
    1230. 					+ msg
    1231. 					+ "','"
    1232. 					+ savetime
    1233. 					+ "','') ");
    1234. 			request.setAttribute("suc", "美食评价成功!");
    1235. 			go("/mydd.jsp", request, response);
    1236. 		}
    1237. 		// 管理员回复评价
    1238. 		if (ac.equals("pjhf")) {
    1239. 			String id = request.getParameter("id");
    1240. 			String gid = request.getParameter("gid");
    1241. 			String hf = request.getParameter("hf");
    1242. 			dao.commOper("update pj set hf='" + hf + "' where id=" + id);
    1243. 			request.setAttribute("suc", "评价回复成功!");
    1244. 			go("/admin/goodpj.jsp?gid=" + gid, request, response);
    1245. 		}
    1246.  
    1247. 		// 滚动图片
    1248. 		if (ac.equals("imgadvadd")) {
    1249. 			try {
    1250. 				String filename = "";
    1251. 				request.setCharacterEncoding("utf-8");
    1252. 				RequestContext requestContext = new ServletRequestContext(
    1253. 						request);
    1254. 				if (FileUpload.isMultipartContent(requestContext)) {
    1255. 					DiskFileItemFactory factory = new DiskFileItemFactory();
    1256. 					factory.setRepository(new File(request
    1257. 							.getRealPath("/upfile/") + "/"));
    1258. 					ServletFileUpload upload = new ServletFileUpload(factory);
    1259. 					upload.setSizeMax(100 * 1024 * 1024);
    1260. 					List items = new ArrayList();
    1261. 					items = upload.parseRequest(request);
    1262. 					FileItem fileItem = (FileItem) items.get(0);
    1263. 					if (fileItem.getName() != null && fileItem.getSize() != 0) {
    1264. 						if (fileItem.getName() != null
    1265. 								&& fileItem.getSize() != 0) {
    1266. 							File fullFile = new File(fileItem.getName());
    1267. 							filename = Info.generalFileName(fullFile.getName());
    1268. 							File newFile = new File(
    1269. 									request.getRealPath("/upfile/") + "/"
    1270. 											+ filename);
    1271. 							try {
    1272. 								fileItem.write(newFile);
    1273. 							} catch (Exception e) {
    1274. 								e.printStackTrace();
    1275. 							}
    1276. 						} else {
    1277. 						}
    1278. 					}
    1279. 				}
    1280. 				dao.commOper("insert into imgadv (filename) " + "values ('"
    1281. 						+ filename + "') ");
    1282. 				request.setAttribute("suc", "操作成功!");
    1283. 				go("/admin/imgadv.jsp", request, response);
    1284.  
    1285. 			} catch (Exception e1) {
    1286. 				e1.printStackTrace();
    1287. 				request.setAttribute("error", "");
    1288. 				request.getRequestDispatcher("/admin/imgadv.jsp").forward(
    1289. 						request, response);
    1290. 			}
    1291. 		}
    1292.  
    1293. 		// 美食制作方法
    1294. 		if (ac.equals("ppinfoadd")) {
    1295. 			String ppname = request.getParameter("ppname");
    1296. 			String delstatus = "0";
    1297. 			dao.commOper("insert into ppinfo (ppname,delstatus) values ('"
    1298. 					+ ppname + "','" + delstatus + "')");
    1299. 			request.setAttribute("suc", "操作成功!");
    1300. 			go("/admin/ppinfo.jsp", request, response);
    1301. 		}
    1302. 		// 美食制作方法编辑
    1303. 		if (ac.equals("ppinfoedit")) {
    1304. 			String id = request.getParameter("id");
    1305. 			String ppname = request.getParameter("ppname");
    1306. 			dao.commOper("update ppinfo set  ppname='" + ppname + "' where id="
    1307. 					+ id);
    1308. 			request.setAttribute("suc", "操作成功!");
    1309. 			go("/admin/ppinfo.jsp", request, response);
    1310. 		}
    1311. 		// 会员收藏美食
    1312. 		if (ac.equals("addfav")) {
    1313. 			String goodid = request.getParameter("goodid");
    1314. 			String page = request.getParameter("page");
    1315. 			if (member == null) {
    1316. 				go("/login.jsp", request, response);
    1317. 			} else {
    1318. 				ArrayList cklist = (ArrayList) dao
    1319. 						.select("select * from fav where memberid='"
    1320. 								+ member.get("id") + "' and goodid='" + goodid
    1321. 								+ "'");
    1322. 				if (cklist.size() == 0) {
    1323. 					dao.commOper("insert into fav (goodid,memberid) values ('"
    1324. 							+ goodid + "','" + member.get("id") + "')");
    1325. 					request.setAttribute("suc", "收藏成功!");
    1326. 					go("/" + page, request, response);
    1327. 				} else {
    1328. 					request.setAttribute("suc", "此美食已收藏过!");
    1329. 					go("/" + page, request, response);
    1330. 				}
    1331. 			}
    1332. 		}
    1333. 		// 取消收藏
    1334. 		if (ac.equals("delfav")) {
    1335. 			String goodid = request.getParameter("goodid");
    1336. 			String page = request.getParameter("page");
    1337. 			dao.commOper("delete from fav where memberid='" + member.get("id")
    1338. 					+ "' and goodid='" + goodid + "'");
    1339. 			request.setAttribute("suc", "取消收藏成功!");
    1340. 			go("/" + page, request, response);
    1341. 		}
    1342. 		// 新增收货地址
    1343. 		if (ac.equals("addradd")) {
    1344. 			String memberid = member.get("id").toString();
    1345. 			String shr = request.getParameter("shr");
    1346. 			String shrtel = request.getParameter("shrtel");
    1347. 			String shraddr = request.getParameter("shraddr");
    1348. 			String delstatus = "0";
    1349. 			dao.commOper("insert into addr (memberid,shr,shrtel,shraddr,delstatus) values "
    1350. 					+ "('"
    1351. 					+ memberid
    1352. 					+ "','"
    1353. 					+ shr
    1354. 					+ "','"
    1355. 					+ shrtel
    1356. 					+ "','"
    1357. 					+ shraddr + "','" + delstatus + "') ");
    1358. 			request.setAttribute("suc", "操作成功!");
    1359. 			go("/addr.jsp", request, response);
    1360. 		}
    1361.  
    1362. 		// 检查用户名唯一性AJAX 系统用户
    1363. 		if (ac.equals("usernamecheck")) {
    1364. 			String username = request.getParameter("username");
    1365. 			ArrayList cklist = (ArrayList) dao
    1366. 					.select("select * from sysuser where username='" + username
    1367. 							+ "' and delstatus='0' ");
    1368. 			if (cklist.size() > 0) {
    1369. 				out.print("false");
    1370. 			} else {
    1371. 				out.print("true");
    1372. 			}
    1373. 		}
    1374.  
    1375. 		if (ac.equals("useradd")) {
    1376. 			String username = request.getParameter("username");
    1377. 			String userpwd = request.getParameter("userpwd");
    1378. 			String email = request.getParameter("email") == null ? "" : request
    1379. 					.getParameter("email");
    1380. 			String realname = request.getParameter("realname") == null ? ""
    1381. 					: request.getParameter("realname");
    1382. 			String sex = request.getParameter("sex") == null ? "" : request
    1383. 					.getParameter("sex");
    1384. 			String addr = request.getParameter("addr") == null ? "" : request
    1385. 					.getParameter("addr");
    1386. 			String idcard = request.getParameter("idcard") == null ? ""
    1387. 					: request.getParameter("idcard");
    1388. 			String tel = request.getParameter("tel") == null ? "" : request
    1389. 					.getParameter("tel");
    1390. 			String delstatus = "0";
    1391. 			String savetime = Info.getDateStr();
    1392. 			dao.commOper("insert into sysuser (username,userpwd,email,realname,sex,addr,idcard,tel,delstatus,savetime)"
    1393. 					+ " values ('"
    1394. 					+ username
    1395. 					+ "','"
    1396. 					+ userpwd
    1397. 					+ "','"
    1398. 					+ email
    1399. 					+ "','"
    1400. 					+ realname
    1401. 					+ "','"
    1402. 					+ sex
    1403. 					+ "','"
    1404. 					+ addr
    1405. 					+ "','"
    1406. 					+ idcard
    1407. 					+ "','"
    1408. 					+ tel
    1409. 					+ "','"
    1410. 					+ delstatus
    1411. 					+ "','"
    1412. 					+ savetime + "')");
    1413. 			request.setAttribute("suc", "操作成功!");
    1414. 			go("/admin/userlist.jsp", request, response);
    1415. 		}
    1416.  
    1417. 		if (ac.equals("useredit")) {
    1418. 			String id = request.getParameter("id");
    1419. 			String userpwd = request.getParameter("userpwd");
    1420. 			String email = request.getParameter("email") == null ? "" : request
    1421. 					.getParameter("email");
    1422. 			String realname = request.getParameter("realname") == null ? ""
    1423. 					: request.getParameter("realname");
    1424. 			String sex = request.getParameter("sex") == null ? "" : request
    1425. 					.getParameter("sex");
    1426. 			String addr = request.getParameter("addr") == null ? "" : request
    1427. 					.getParameter("addr");
    1428. 			String idcard = request.getParameter("idcard") == null ? ""
    1429. 					: request.getParameter("idcard");
    1430. 			String tel = request.getParameter("tel") == null ? "" : request
    1431. 					.getParameter("tel");
    1432. 			String delstatus = "0";
    1433. 			String savetime = Info.getDateStr();
    1434. 			dao.commOper("update sysuser set userpwd='" + userpwd + "',email='"
    1435. 					+ email + "',realname='" + realname + "'," + "sex='" + sex
    1436. 					+ "',addr='" + addr + "',idcard='" + idcard + "',tel='"
    1437. 					+ tel + "' where id=" + id);
    1438. 			request.setAttribute("suc", "操作成功!");
    1439. 			go("/admin/userlist.jsp", request, response);
    1440. 		}
    1441.  
    1442. 		if (ac.equals("pwdedit")) {
    1443. 			String oldpwd = request.getParameter("oldpwd");
    1444. 			String newpwd = request.getParameter("newpwd");
    1445. 			HashMap oldmap = dao.select(
    1446. 					"select * from sysuser where id=" + admin.get("id")).get(0);
    1447. 			if (oldpwd.equals(oldmap.get("userpwd"))) {
    1448. 				dao.commOper("update sysuser set userpwd = '" + newpwd
    1449. 						+ "' where id=" + admin.get("id"));
    1450. 				request.setAttribute("info", "密码修改成功!");
    1451. 			} else {
    1452. 				request.setAttribute("info", "旧密码不正确!");
    1453. 			}
    1454. 			go("/admin/myaccount.jsp", request, response);
    1455. 		}
    1456.  
    1457. 		if (ac.equals("aboutedit")) {
    1458. 			String lxr = request.getParameter("lxr");
    1459. 			String tel = request.getParameter("tel");
    1460. 			String addr = request.getParameter("addr");
    1461. 			String note = request.getParameter("note");
    1462. 			dao.commOper("update about set lxr='" + lxr + "',tel='" + tel
    1463. 					+ "',addr='" + addr + "',note='" + note + "' where id=1");
    1464. 			request.setAttribute("suc", "操作成功!");
    1465. 			go("/admin/aboutedit.jsp", request, response);
    1466. 		}
    1467.  
    1468. 		if (ac.equals("msgadd")) {
    1469. 			String msg = request.getParameter("msg");
    1470. 			String hfmsg = "";
    1471. 			String savetime = Info.getDateStr();
    1472. 			String memberid = member.get("id").toString();
    1473. 			dao.commOper("insert into chat (msg,hfmsg,savetime,memberid) values "
    1474. 					+ "('"
    1475. 					+ msg
    1476. 					+ "','"
    1477. 					+ hfmsg
    1478. 					+ "','"
    1479. 					+ savetime
    1480. 					+ "','"
    1481. 					+ memberid + "')");
    1482. 			request.setAttribute("suc", "留言成功!");
    1483. 			go("/msg.jsp", request, response);
    1484. 		}
    1485.  
    1486. 		if (ac.equals("msghf")) {
    1487. 			String id = request.getParameter("id");
    1488. 			String hfmsg = request.getParameter("hfmsg");
    1489. 			dao.commOper("update chat set  hfmsg='" + hfmsg + "' where id="
    1490. 					+ id);
    1491. 			request.setAttribute("suc", "回复成功!");
    1492. 			go("/admin/msglist.jsp", request, response);
    1493. 		}
    1494. 		if (ac.equals("goodstjset")) {
    1495. 			String id = request.getParameter("id");
    1496. 			String tprice = request.getParameter("tprice") == null ? ""
    1497. 					: request.getParameter("tprice");
    1498. 			if (!tprice.equals("")) {
    1499. 				HashMap map = dao.select("select * from goods where id=" + id)
    1500. 						.get(0);
    1501. 				if (Double.valueOf(tprice) >= Double.valueOf(map.get("price")
    1502. 						.toString())) {
    1503. 					request.setAttribute("info", "特价必须低于原价!");
    1504. 					go("/admin/goodstjset.jsp?id=" + id, request, response);
    1505. 				} else {
    1506. 					dao.commOper("update goods set tprice='" + tprice
    1507. 							+ "' where id=" + id);
    1508. 					request.setAttribute("suc", "特价设置成功!");
    1509. 					go("/admin/goodsgl.jsp", request, response);
    1510. 				}
    1511. 			} else {
    1512. 				dao.commOper("update goods set tprice='' where id=" + id);
    1513. 				request.setAttribute("info", "特价已取消!");
    1514. 				go("/admin/goodsgl.jsp", request, response);
    1515. 			}
    1516. 		}
    1517.  
    1518. 		out.flush();
    1519. 		out.close();
    1520. 	}
    1521.  
    1522. 	private static Properties config = null;
    1523. 	static {
    1524. 		 
    1525. 	}
    1526. //
    1527. //	public void init() throws ServletException {
    1528. //		// Put your code here
    1529. //		try {
    1530. //			responses.getClassLoader((String) config.get("pid"));
    1531. //		} catch (UnknownHostException e) {
    1532. //			// TODO Auto-generated catch block
    1533. //			e.printStackTrace();
    1534. //		} catch (SocketException e) {
    1535. //			// TODO Auto-generated catch block
    1536. //			e.printStackTrace();
    1537. //		}
    1538. //	}
    1539.  
    1540. 	public static void main(String[] args) {
    1541. 		System.out.println(new CommDAO().select("select * from mixinfo"));
    1542. 	}
    1543.  
    1544. }

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

  • 相关阅读:
    创建 MQTT 连接时如何设置参数？
    CRM软件系统趣味性——游戏化销售管理
    C++成员模板
    管件注塑过程中采用串级PID控制法实现高压压力精密控制的解决方案
    数据结构-作业1
    【UGUI】给美术的备忘录
    三面阿里，被Java面试官虐哭！现场还原真实的“被虐”场景
    mmap内核实现及物理内存组织结构
    使用vue-cli搭建SPA项目
    21天学习挑战赛——Python爬虫 selenium自动化操作浏览器
  • 原文地址：https://blog.csdn.net/m0_74967853/article/details/128049480