旅遊訂票訂酒店團購(APP,JAVA背景管理,MYSQL)(畢業論文近11000字以上,共39頁, 包含程式代碼,MySql資料庫,資料庫腳本)
【功能描述】
旅遊訂票訂酒店團購(APP,JAVA背景管理,MYSQL)包含【背景管理功能】與【手機app功能】
【背景管理功能】包含登入,使用者資訊管理,酒店訂單管理,車票訂單管理,攻略資料資訊,添加攻略資料,團購資料管理,添加團購資料,
酒店資料管理,添加酒店資料,車票資料管理,添加車票資料等
【App端功能】登入注冊,跟團旅遊,旅遊攻略,線路規劃,酒店清單查詢,酒店詳情檢視,預定酒店,預定酒店資訊檢視,
車票資訊查詢,車票詳情檢視,預定車票,預定車票資訊檢視,景點團購預定,團購預定檢視,個人資料等
代碼下載下傳連結:https://pan.baidu.com/s/1WcArSupuqnMM-UoGnSXSMQ 提取碼:8888
【項目包含内容】
![](https://img.laitimes.com/img/__Qf2AjLwojIjJCLyojI0JCLicmbw5iZ5QGN1AzNhZGM2MGO3MDOzQGN4UmY5EjMmZ2MmRDZ48CX0JXZ252bj91Ztl2Lc52YucWbp5GZzNmLn9Gbi1yZtl2Lc9CX6MHc0RHaiojIsJye.png)
【文檔】
【代碼】
package com.student.data.action;
import java.io.BufferedInputStream;
import java.io.File;
import java.io.FileOutputStream;
import java.io.IOException;
import java.io.InputStream;
import java.io.PrintWriter;
import java.text.SimpleDateFormat;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;
import java.util.Map;
import javax.servlet.ServletConfig;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import net.sf.json.JSONObject;
import org.apache.commons.fileupload.FileItem;
import org.apache.commons.fileupload.FileItemFactory;
import org.apache.commons.fileupload.FileUploadException;
import org.apache.commons.fileupload.disk.DiskFileItemFactory;
import org.apache.commons.fileupload.servlet.ServletFileUpload;
import com.student.data.dao.ForumDao;
public class ForumAction extends HttpServlet {
private static final long serialVersionUID = 1L;
private ServletFileUpload upload;
private final long MAXSize = 4194304 * 2L;// 4*2MB
private String filedir = null;
private ForumDao hobbyDao;
public ForumAction() {
super();
}
public void destroy() {
super.destroy();
}
public void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
doPost(request, response);
}
public void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
String path = request.getContextPath();
response.setContentType("text/html;charset=utf-8");
request.setCharacterEncoding("utf-8");
response.setCharacterEncoding("utf-8");
PrintWriter out = response.getWriter();
String action_flag = request.getParameter("action_flag");
if (action_flag.equals("addMessage")) {
addMessage(request, response);
} else if (action_flag.equals("listMessage")) {
listMessage(request, response);
} else if (action_flag.equals("listPhoneMessage")) {
listPhoneMessage(request, response);
} else if (action_flag.equals("updateReview")) {
updateReview(request, response);
} else if (action_flag.equals("deleteMessage")) {
deleteMessage(request, response);
} else if (action_flag.equals("listMessageChoice")) {
listMessageChoice(request, response);
} else if (action_flag.equals("listSearchMessage")) {
listSearchMessage(request, response);
} else if (action_flag.equals("addAppointment")) {
addAppointment(request, response);
} else if (action_flag.equals("listAppointmentMessage")) {
listAppointmentMessage(request, response);
} else if (action_flag.equals("listDoctorQueryAppointmentMessage")) {
listDoctorQueryAppointmentMessage(request, response);
} else if (action_flag.equals("addMRMessage")) {
addMRMessage(request, response);
} else if (action_flag.equals("queryMRMessage")) {
queryMRMessage(request, response);
} else if (action_flag.equals("addInterest")) {
addInterest(request, response);
} else if (action_flag.equals("listInterestMessage")) {
listInterestMessage(request, response);
} else if (action_flag.equals("listInterestUserMessage")) {
listInterestUserMessage(request, response);
} else if (action_flag.equals("deleteInterest")) {
deleteInterest(request, response);
} else if (action_flag.equals("deletePcInterest")) {
deletePcInterest(request, response);
} else if (action_flag.equals("addCollectMessage")) {
addCollectMessage(request, response);
} else if (action_flag.equals("deleteCollectMessage")) {
//deleteCollectMessage(request, response);
} else if (action_flag.equals("addType")) {
addType(request, response);
} else if (action_flag.equals("listTypeMessage")) {
listTypeMessage(request, response);
} else if (action_flag.equals("deleteType")) {
deleteType(request, response);
} else if (action_flag.equals("addScenery")) {
addScenery(request, response);
} else if (action_flag.equals("listSceneryMessage")) {
listSceneryMessage(request, response);
} else if (action_flag.equals("deleteScenery")) {
deleteScenery(request, response);
} else if (action_flag.equals("listSceneryPhoneMessage")) {
listSceneryPhoneMessage(request, response);
} else if (action_flag.equals("listPhonePlanMessage")) {
listPhonePlanMessage(request, response);
} else if (action_flag.equals("deletePlanMessage")) {
deletePlanMessage(request, response);
} else if (action_flag.equals("listTypePhoneMessage")) {
listTypePhoneMessage(request, response);
} else if (action_flag.equals("deletePlan")) {
deletePlan(request, response);
} else if (action_flag.equals("listPlanMessage")) {
listPlanMessage(request, response);
} else if (action_flag.equals("listPlanMessage")) {
listPlanMessage(request, response);
} else if (action_flag.equals("listTiziMessage")) {
listTiziMessage(request, response);
} else if (action_flag.equals("addLineMessage")) {
addLineMessage(request, response);
} else if (action_flag.equals("listLineMessage")) {
listLineMessage(request, response);
} else if (action_flag.equals("listLinePhoneMessage")) {
listLinePhoneMessage(request, response);
} else if (action_flag.equals("addApply")) {
addApply(request, response);
} else if (action_flag.equals("listPhonePlanUserMessage")) {
listPhonePlanUserMessage(request, response);
} else if (action_flag.equals("listPhoneUserApplyMessage")) {
listPhoneUserApplyMessage(request, response);
} else if (action_flag.equals("addHotel")) {
addHotel(request, response);
} else if (action_flag.equals("listHotelMessage")) {
listHotelMessage(request, response);
} else if (action_flag.equals("listHotelPhoneMessage")) {
listHotelPhoneMessage(request, response);
} else if (action_flag.equals("addOrder")) {
addOrder(request, response);
} else if (action_flag.equals("listPhoneOrder")) {
listPhoneOrder(request, response);
}else if (action_flag.equals("listMessagePcOrder")) {
listMessagePcOrder(request, response);
}else if (action_flag.equals("addTicket")) {
addTicket(request, response);
}else if (action_flag.equals("ListMessageTicket")) {
ListMessageTicket(request, response);
}else if (action_flag.equals("listSearchTicketMessage")) {
listSearchTicketMessage(request, response);
}else if (action_flag.equals("addTicketOrder")) {
addTicketOrder(request, response);
}else if (action_flag.equals("listSearchTicketgOrderMessage")) {
listSearchTicketgOrderMessage(request, response);
}else if (action_flag.equals("listMessagePcTicketOrder")) {
listMessagePcTicketOrder(request, response);
}
}
public void init(ServletConfig config) throws ServletException {
FileItemFactory factory = new DiskFileItemFactory();// Create a factory
this.upload = new ServletFileUpload(factory);// Create a new file upload
this.upload.setSizeMax(this.MAXSize);// Set overall request size
filedir = config.getServletContext().getRealPath("upload");
System.out.println("filedir=" + filedir);
hobbyDao = new ForumDao();
}
private void listMessagePcTicketOrder(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
String path = request.getContextPath();
List<Map<String, Object>> list = hobbyDao.listMessagePcTicketOrder();
request.setAttribute("listMessage", list);
request.getRequestDispatcher("../orderTicketMessage.jsp").forward(request, response);
}
private void listSearchTicketgOrderMessage(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
String orderTicketUserId = request.getParameter("orderTicketUserId");
List<Object> params = new ArrayList<Object>();
params.add(orderTicketUserId);
List<Map<String, Object>> list = hobbyDao.listSearchTicketgOrderMessage(params);
JSONObject jsonmsg = new JSONObject();
jsonmsg.put("repMsg", "請求成功");
jsonmsg.put("repCode", "666");
jsonmsg.put("data", list);
System.out.println(jsonmsg);
response.getWriter().print(jsonmsg);// 将路徑傳回給用戶端
}
private void addTicketOrder(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
String path = request.getContextPath();
String orderTicketUserId = request.getParameter("orderTicketUserId");
String orderTicketUserName = request.getParameter("orderTicketUserName");
String orderTicketMessageId = request.getParameter("orderTicketMessageId");
String orderTicketMessageName = request.getParameter("orderTicketMessageName");
String orderTicketMoney = request.getParameter("orderTicketMoney");
List<Object> params = new ArrayList<Object>();
params.add(orderTicketUserId);
params.add(orderTicketUserName);
params.add(orderTicketMessageId);
params.add(orderTicketMessageName);
params.add(orderTicketMoney);
SimpleDateFormat df = new SimpleDateFormat("yyyy-MM-dd HH:mm");// 設定日期格式
params.add(df.format(new Date()));
boolean flagUpdate = hobbyDao.addTicketOrder(params);
if (flagUpdate) {
JSONObject jsonmsg = new JSONObject();
jsonmsg.put("repMsg", "支付完成");
jsonmsg.put("repCode", "666");
response.getWriter().print(jsonmsg);// 将路徑傳回給用戶端
System.out.println(jsonmsg);
} else {
JSONObject jsonmsg = new JSONObject();
jsonmsg.put("repMsg", "添加失敗");
jsonmsg.put("repCode", "111");
System.out.println(jsonmsg);
response.getWriter().print(jsonmsg);// 将路徑傳回給用戶端
}
}
private void listSearchTicketMessage(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
String path = request.getContextPath();
String ticketStartCity = request.getParameter("ticketStartCity");
String ticketEndCity = request.getParameter("ticketEndCity");
List<Object> params = new ArrayList<Object>();
params.add(ticketStartCity);
params.add(ticketEndCity);
List<Map<String, Object>> list = hobbyDao.listSearchTicketgMessage(params);
JSONObject jsonmsg = new JSONObject();
jsonmsg.put("repMsg", "請求成功");
jsonmsg.put("repCode", "666");
jsonmsg.put("data", list);
System.out.println(jsonmsg);
response.getWriter().print(jsonmsg);// 将路徑傳回給用戶端
}
private void ListMessageTicket(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
String path = request.getContextPath();
List<Map<String, Object>> list = hobbyDao.listMessagePcticketmsg();
request.setAttribute("listMessage", list);
request.getRequestDispatcher("../ticketMessage.jsp").forward(request, response);
}
private void addTicket(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
String path = request.getContextPath();
String ticketStartCity = request.getParameter("ticketStartCity");
String ticketEndCity = request.getParameter("ticketEndCity");
String ticketMoney = request.getParameter("ticketMoney");
List<Object> params = new ArrayList<Object>();
params.add(ticketStartCity);
params.add(ticketEndCity);
params.add(ticketMoney);
SimpleDateFormat df = new SimpleDateFormat("yyyy-MM-dd HH:mm");// 設定日期格式
params.add(df.format(new Date()));
boolean flag = hobbyDao.addTicketmsgMessage(params);
JSONObject jsonmsg = new JSONObject();
if (flag) {
ListMessageTicket(request, response);
} else {
jsonmsg.put("repMsg", "送出失敗");
jsonmsg.put("repCode", "111");
response.getWriter().print(jsonmsg);// 将路徑傳回給用戶端
System.out.println(jsonmsg);
}
}
private void listMessagePcOrder(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
String path = request.getContextPath();
List<Map<String, Object>> list = hobbyDao.listMessagePcOrder();
request.setAttribute("listMessage", list);
request.getRequestDispatcher("../ordermsgMessage.jsp").forward(request, response);
}
private void listPhoneOrder(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
String orderUserId = request.getParameter("orderUserId");
List<Object> params = new ArrayList<Object>();
params.add(orderUserId);
List<Map<String, Object>> list = hobbyDao.listMessageOrder(params);
JSONObject jsonmsg = new JSONObject();
jsonmsg.put("repMsg", "請求成功");
jsonmsg.put("repCode", "666");
jsonmsg.put("data", list);
System.out.println(jsonmsg);
response.getWriter().print(jsonmsg);// 将路徑傳回給用戶端
}
private void addOrder(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
String path = request.getContextPath();
String orderUserId = request.getParameter("orderUserId");
String orderUserName = request.getParameter("orderUserName");
String orderMessageId = request.getParameter("orderMessageId");
String orderMessageName = request.getParameter("orderMessageName");
List<Object> params = new ArrayList<Object>();
params.add(orderUserId);
params.add(orderUserName);
params.add(orderMessageId);
params.add(orderMessageName);
SimpleDateFormat df = new SimpleDateFormat("yyyy-MM-dd HH:mm");// 設定日期格式
params.add(df.format(new Date()));
boolean flagUpdate = hobbyDao.addOrder(params);
if (flagUpdate) {
JSONObject jsonmsg = new JSONObject();
jsonmsg.put("repMsg", "支付完成");
jsonmsg.put("repCode", "666");
response.getWriter().print(jsonmsg);// 将路徑傳回給用戶端
System.out.println(jsonmsg);
} else {
JSONObject jsonmsg = new JSONObject();
jsonmsg.put("repMsg", "添加失敗");
jsonmsg.put("repCode", "111");
System.out.println(jsonmsg);
response.getWriter().print(jsonmsg);// 将路徑傳回給用戶端
}
}
private void listHotelPhoneMessage(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
List<Map<String, Object>> flagFood = hobbyDao.listhotelmsgTypeMessage();
JSONObject jsonmsg = new JSONObject();
jsonmsg.put("repMsg", "請求成功");
jsonmsg.put("repCode", "666");
jsonmsg.put("data", flagFood);
System.out.println(jsonmsg);
response.getWriter().print(jsonmsg);// 将路徑傳回給用戶端
}
private void listHotelMessage(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
String path = request.getContextPath();
List<Map<String, Object>> list = hobbyDao.listhotelmsgTypeMessage();
request.setAttribute("listMessage", list);
request.getRequestDispatcher("../hotelMessage.jsp").forward(request, response);
}
private void addHotel(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
final long MAX_SIZE = 2048 * 1024 * 1024;// 設定上傳檔案最大值為2G,可以改為更大
// 表單含有檔案要送出
String path = request.getContextPath();
DiskFileItemFactory diskFileItemFactory = new DiskFileItemFactory();
// 建構一個檔案上傳類
ServletFileUpload servletFileUpload = new ServletFileUpload(diskFileItemFactory);
// servletFileUpload.setFileSizeMax(3 * 1024 * 1024);
servletFileUpload.setSizeMax(MAX_SIZE);// 上傳檔案總大小
List<FileItem> list = null;
List<Object> params = new ArrayList<Object>();
try {
// 解析request的請求
list = servletFileUpload.parseRequest(request);
// 取出所有表單的值:判斷非文本字段和文本字段
for (FileItem fileItem : list) {
if (fileItem.isFormField()) {
if (fileItem.getFieldName().equals("hotelName")) {
params.add(fileItem.getString("utf-8"));
System.out.println(fileItem.getString("utf-8"));
}
if (fileItem.getFieldName().equals("hotelMoney")) {
params.add(fileItem.getString("utf-8"));
System.out.println(fileItem.getString("utf-8"));
}
if (fileItem.getFieldName().equals("hotelType")) {
params.add(fileItem.getString("utf-8"));
System.out.println(fileItem.getString("utf-8"));
}
if (fileItem.getFieldName().equals("hotelZuoBiao")) {
params.add(fileItem.getString("utf-8"));
System.out.println(fileItem.getString("utf-8"));
}
if (fileItem.getFieldName().equals("hotelMessage")) {
params.add(fileItem.getString("utf-8"));
System.out.println(fileItem.getString("utf-8"));
SimpleDateFormat df = new SimpleDateFormat("yyyy-MM-dd");// 設定日期格式
params.add(df.format(new Date()));
System.out.println(df.format(new Date()));
}
} else {
try {
// String image = fileItem.getName();
// System.out.println("image--->>" + image);
// params.add(image);E:\2017-2018code\A1044VideoCourse\VideoCourseService
// String upload_path = request.getRealPath("/upload");
// System.out.println("--->>" + upload_path);
// File real_path = new File(upload_path + "/" + image);
// fileItem.write(real_path);E:\2018code\A832Tourism\TourismService
String image = fileItem.getName();
System.out.println("image111--->>" + image);
params.add(image);
String upload_path = request.getRealPath("/upload");
System.out.println("--->>" + upload_path);
// E:\2017-2017CDCode\Tourism\TourismService
String imgPath = "E:\\2017-2017CDCode\\Tourism\\TourismService\\WebRoot\\upload";
imgPath = request.getServletContext().getRealPath("/") + "\\upload";
File real_path = new File(imgPath + "/" + image);
fileItem.write(real_path);
// 把資料插入到資料庫中
} catch (Exception e) {
e.printStackTrace();
}
boolean flag = hobbyDao.addHotelMessage(params);
System.out.println(flag);
if (flag) {
listHotelMessage(request, response);
} else {
System.out.println("flag:no");
}
}
}
} catch (FileUploadException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
private void listPhoneUserApplyMessage(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
String applyUserId = request.getParameter("applyUserId");
List<Object> params = new ArrayList<Object>();
params.add(applyUserId);
List<Map<String, Object>> flagFood = hobbyDao.listPhonePlanApplyMessage(params);
JSONObject jsonmsg = new JSONObject();
jsonmsg.put("repMsg", "請求成功");
jsonmsg.put("repCode", "666");
jsonmsg.put("data", flagFood);
System.out.println(jsonmsg);
response.getWriter().print(jsonmsg);// 将路徑傳回給用戶端
}
private void listPhonePlanUserMessage(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
String applyPlanId = request.getParameter("applyPlanId");
List<Object> params = new ArrayList<Object>();
params.add(applyPlanId);
List<Map<String, Object>> flagFood = hobbyDao.listPhonePlanUserMessage(params);
JSONObject jsonmsg = new JSONObject();
jsonmsg.put("repMsg", "請求成功");
jsonmsg.put("repCode", "666");
jsonmsg.put("data", flagFood);
System.out.println(jsonmsg);
response.getWriter().print(jsonmsg);// 将路徑傳回給用戶端
}
private void addApply(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
String path = request.getContextPath();
String applyUserId = request.getParameter("applyUserId");
String applyUserName = request.getParameter("applyUserName");
String applyPlanId = request.getParameter("applyPlanId");
String applyPlanName = request.getParameter("applyPlanName");
List<Object> paramsCheck = new ArrayList<Object>();
paramsCheck.add(applyPlanId);
paramsCheck.add(applyUserId);
boolean flagCheck = hobbyDao.checkPlan(paramsCheck);
if (!flagCheck) {
List<Object> params = new ArrayList<Object>();
params.add(applyUserId);
params.add(applyUserName);
params.add(applyPlanId);
params.add(applyPlanName);
SimpleDateFormat df = new SimpleDateFormat("yyyy-MM-dd HH:mm");// 設定日期格式
params.add(df.format(new Date()));
boolean flag = hobbyDao.addApply(params);
JSONObject jsonmsg = new JSONObject();
if (flag) {
jsonmsg.put("repMsg", "參與成功");
jsonmsg.put("repCode", "666");
response.getWriter().print(jsonmsg);// 将路徑傳回給用戶端
System.out.println(jsonmsg);
} else {
jsonmsg.put("repMsg", "送出失敗");
jsonmsg.put("repCode", "111");
response.getWriter().print(jsonmsg);// 将路徑傳回給用戶端
System.out.println(jsonmsg);
}
} else {
JSONObject jsonmsg = new JSONObject();
jsonmsg.put("repMsg", "親,不要重複參與哦!");
jsonmsg.put("repCode", "1111");
response.getWriter().print(jsonmsg);// 将路徑傳回給用戶端
System.out.println(jsonmsg);
}
}
private void listLinePhoneMessage(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
String userId = request.getParameter("userId");
List<Map<String, Object>> flagFood = hobbyDao.listlinemsgMessage(userId);
JSONObject jsonmsg = new JSONObject();
jsonmsg.put("repMsg", "請求成功");
jsonmsg.put("repCode", "666");
jsonmsg.put("data", flagFood);
System.out.println(jsonmsg);
response.getWriter().print(jsonmsg);// 将路徑傳回給用戶端
}
private void listLineMessage(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
String path = request.getContextPath();
List<Map<String, Object>> list = hobbyDao.listlinemsgTypeMessage();
request.setAttribute("listMessage", list);
request.getRequestDispatcher("../lineMessage.jsp").forward(request, response);
}
private void addLineMessage(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
final long MAX_SIZE = 2048 * 1024 * 1024;// 設定上傳檔案最大值為2G,可以改為更大
// 表單含有檔案要送出
String path = request.getContextPath();
DiskFileItemFactory diskFileItemFactory = new DiskFileItemFactory();
// 建構一個檔案上傳類
ServletFileUpload servletFileUpload = new ServletFileUpload(diskFileItemFactory);
// servletFileUpload.setFileSizeMax(3 * 1024 * 1024);
servletFileUpload.setSizeMax(MAX_SIZE);// 上傳檔案總大小
List<FileItem> list = null;
List<Object> params = new ArrayList<Object>();
try {
// 解析request的請求
list = servletFileUpload.parseRequest(request);
// 取出所有表單的值:判斷非文本字段和文本字段
for (FileItem fileItem : list) {
if (fileItem.isFormField()) {
if (fileItem.getFieldName().equals("lineName")) {
params.add(fileItem.getString("utf-8"));
System.out.println(fileItem.getString("utf-8"));
}
if (fileItem.getFieldName().equals("lineMoney")) {
params.add(fileItem.getString("utf-8"));
System.out.println(fileItem.getString("utf-8"));
}
if (fileItem.getFieldName().equals("lineDay")) {
params.add(fileItem.getString("utf-8"));
System.out.println(fileItem.getString("utf-8"));
}
if (fileItem.getFieldName().equals("lineMessage")) {
params.add(fileItem.getString("utf-8"));
System.out.println(fileItem.getString("utf-8"));
SimpleDateFormat df = new SimpleDateFormat("yyyy-MM-dd");// 設定日期格式
params.add(df.format(new Date()));
System.out.println(df.format(new Date()));
}
} else {
try {
// String image = fileItem.getName();
// System.out.println("image--->>" + image);
// params.add(image);E:\2017-2018code\A1044VideoCourse\VideoCourseService
// String upload_path = request.getRealPath("/upload");
// System.out.println("--->>" + upload_path);
// File real_path = new File(upload_path + "/" + image);
// fileItem.write(real_path);
String image = fileItem.getName();
System.out.println("image111--->>" + image);
params.add(image);
String upload_path = request.getRealPath("/upload");
System.out.println("--->>" + upload_path);
String imgPath = "E:\\2017-2017CDCode\\Tourism\\TourismService\\WebRoot\\upload";
imgPath = request.getServletContext().getRealPath("/") + "\\upload";
File real_path = new File(imgPath + "/" + image);
fileItem.write(real_path);
// 把資料插入到資料庫中
} catch (Exception e) {
e.printStackTrace();
}
boolean flag = hobbyDao.addLineMessage(params);
System.out.println(flag);
if (flag) {
listLineMessage(request, response);
} else {
System.out.println("flag:no");
}
}
}
} catch (FileUploadException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
private void listTiziMessage(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
String path = request.getContextPath();
List<Map<String, Object>> list = hobbyDao.listPhoneTieZiMessage();
request.setAttribute("listMessage", list);
request.getRequestDispatcher("../tieziMessage.jsp").forward(request, response);
}
private void listPlanMessage(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
String path = request.getContextPath();
List<Map<String, Object>> list = hobbyDao.listPlanMessage();
request.setAttribute("listMessage", list);
request.getRequestDispatcher("../planMessage.jsp").forward(request, response);
}
private void deletePlan(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
String planId = request.getParameter("planId");
List<Object> params = new ArrayList<Object>();
params.add(planId);
boolean flag = hobbyDao.deletePlan(params);
if (flag) {
listTypeMessage(request, response);
}
}
private void listTypePhoneMessage(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
String path = request.getContextPath();
List<Map<String, Object>> list = hobbyDao.listTypeMessage();
JSONObject jsonmsg = new JSONObject();
jsonmsg.put("repMsg", "請求成功");
jsonmsg.put("repCode", "666");
jsonmsg.put("data", list);
System.out.println(jsonmsg);
response.getWriter().print(jsonmsg);// 将路徑傳回給用戶端
}
private void deletePlanMessage(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
String path = request.getContextPath();
String planId = request.getParameter("planId");
List<Object> params = new ArrayList<Object>();
params.add(planId);
boolean flag = hobbyDao.deletePlan(params);
if (flag) {
JSONObject jsonmsg = new JSONObject();
jsonmsg.put("repMsg", "删除成功");
jsonmsg.put("repCode", "666");
System.out.println(jsonmsg);
response.getWriter().print(jsonmsg);// 将路徑傳回給用戶端
} else {
JSONObject jsonmsg = new JSONObject();
jsonmsg.put("repMsg", "送出失敗");
jsonmsg.put("repCode", "111");
System.out.println(jsonmsg);
response.getWriter().print(jsonmsg);// 将路徑傳回給用戶端
}
}
private void listPhonePlanMessage(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
String planUserId = request.getParameter("planUserId");
List<Object> params = new ArrayList<Object>();
params.add(planUserId);
List<Map<String, Object>> flagFood = hobbyDao.listPhonePlanMessage(params);
JSONObject jsonmsg = new JSONObject();
jsonmsg.put("repMsg", "請求成功");
jsonmsg.put("repCode", "666");
jsonmsg.put("data", flagFood);
System.out.println(jsonmsg);
response.getWriter().print(jsonmsg);// 将路徑傳回給用戶端
}
private void listSceneryPhoneMessage(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
List<Map<String, Object>> flagFood = hobbyDao.listscenerymsgTypeMessage();
JSONObject jsonmsg = new JSONObject();
jsonmsg.put("repMsg", "請求成功");
jsonmsg.put("repCode", "666");
jsonmsg.put("data", flagFood);
System.out.println(jsonmsg);
response.getWriter().print(jsonmsg);// 将路徑傳回給用戶端
}
private void listSceneryMessage(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
String path = request.getContextPath();
List<Map<String, Object>> list = hobbyDao.listscenerymsgTypeMessage();
request.setAttribute("listMessage", list);
request.getRequestDispatcher("../sceneryMessage.jsp").forward(request, response);
}
private void addScenery(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
final long MAX_SIZE = 2048 * 1024 * 1024;// 設定上傳檔案最大值為2G,可以改為更大
// 表單含有檔案要送出
String path = request.getContextPath();
DiskFileItemFactory diskFileItemFactory = new DiskFileItemFactory();
// 建構一個檔案上傳類
ServletFileUpload servletFileUpload = new ServletFileUpload(diskFileItemFactory);
// servletFileUpload.setFileSizeMax(3 * 1024 * 1024);
servletFileUpload.setSizeMax(MAX_SIZE);// 上傳檔案總大小
List<FileItem> list = null;
List<Object> params = new ArrayList<Object>();
try {
// 解析request的請求
list = servletFileUpload.parseRequest(request);
// 取出所有表單的值:判斷非文本字段和文本字段
for (FileItem fileItem : list) {
if (fileItem.isFormField()) {
if (fileItem.getFieldName().equals("sceneryTitle")) {
params.add(fileItem.getString("utf-8"));
System.out.println(fileItem.getString("utf-8"));
}
if (fileItem.getFieldName().equals("sceneryMoney")) {
params.add(fileItem.getString("utf-8"));
System.out.println(fileItem.getString("utf-8"));
}
if (fileItem.getFieldName().equals("sceneryAddress")) {
params.add(fileItem.getString("utf-8"));
System.out.println(fileItem.getString("utf-8"));
}
if (fileItem.getFieldName().equals("sceneryMessage")) {
params.add(fileItem.getString("utf-8"));
System.out.println(fileItem.getString("utf-8"));
}
if (fileItem.getFieldName().equals("sceneryTraffic")) {
params.add(fileItem.getString("utf-8"));
System.out.println(fileItem.getString("utf-8"));
}
if (fileItem.getFieldName().equals("sceneryHotel")) {
params.add(fileItem.getString("utf-8"));
System.out.println(fileItem.getString("utf-8"));
SimpleDateFormat df = new SimpleDateFormat("yyyy-MM-dd");// 設定日期格式
params.add(df.format(new Date()));
System.out.println(df.format(new Date()));
}
} else {
try {
// String image = fileItem.getName();
// System.out.println("image--->>" + image);
// params.add(image);E:\2017-2018code\A1044VideoCourse\VideoCourseService
// String upload_path = request.getRealPath("/upload");
// System.out.println("--->>" + upload_path);
// File real_path = new File(upload_path + "/" + image);
// fileItem.write(real_path);
String image = fileItem.getName();
System.out.println("image111--->>" + image);
params.add(image);
String upload_path = request.getRealPath("/upload");
System.out.println("--->>" + upload_path);
String imgPath = "E:\\2017-2017CDCode\\Tourism\\TourismService\\WebRoot\\upload";
imgPath = request.getServletContext().getRealPath("/") + "\\upload";
File real_path = new File(imgPath + "/" + image);
fileItem.write(real_path);
// 把資料插入到資料庫中
} catch (Exception e) {
e.printStackTrace();
}
boolean flag = hobbyDao.addSceneryMessage(params);
System.out.println(flag);
if (flag) {
listSceneryMessage(request, response);
} else {
System.out.println("flag:no");
}
}
}
} catch (FileUploadException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
private void deleteType(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
String typeId = request.getParameter("typeId");
List<Object> params = new ArrayList<Object>();
params.add(typeId);
boolean flag = hobbyDao.deleteType(params);
if (flag) {
listTypeMessage(request, response);
}
}
private void deleteScenery(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
String sceneryId = request.getParameter("sceneryId");
List<Object> params = new ArrayList<Object>();
params.add(sceneryId);
boolean flag = hobbyDao.deletescenerymsgType(params);
if (flag) {
listSceneryMessage(request, response);
}
}
private void addType(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
String path = request.getContextPath();
String typeName = request.getParameter("typeName");
List<Object> params = new ArrayList<Object>();
params.add(typeName);
SimpleDateFormat df = new SimpleDateFormat("yyyy-MM-dd HH:mm");// 設定日期格式
params.add(df.format(new Date()));
boolean flag = hobbyDao.addType(params);
if (flag) {
listTypeMessage(request, response);
} else {
JSONObject jsonmsg = new JSONObject();
jsonmsg.put("repMsg", "送出失敗");
jsonmsg.put("repCode", "111");
System.out.println(jsonmsg);
// response.getWriter().print(jsonmsg);// 将路徑傳回給用戶端
}
}
private void listTypeMessage(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
String path = request.getContextPath();
List<Map<String, Object>> list = hobbyDao.listTypeMessage();
request.setAttribute("listMessage", list);
request.getRequestDispatcher("../typeMessage.jsp").forward(request, response);
}
private void deleteCollectMessage(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
String path = request.getContextPath();
String collectUserId = request.getParameter("collectUserId");
String collectMessageId = request.getParameter("collectMessageId");
List<Object> params = new ArrayList<Object>();
params.add(collectUserId);
params.add(collectMessageId);
boolean flag = hobbyDao.deleteCollect(params);
if (flag) {
JSONObject jsonmsg = new JSONObject();
jsonmsg.put("repMsg", "取消成功");
jsonmsg.put("repCode", "666");
System.out.println(jsonmsg);
response.getWriter().print(jsonmsg);// 将路徑傳回給用戶端
} else {
JSONObject jsonmsg = new JSONObject();
jsonmsg.put("repMsg", "取消失敗");
jsonmsg.put("repCode", "111");
System.out.println(jsonmsg);
response.getWriter().print(jsonmsg);// 将路徑傳回給用戶端
}
}
private void addCollectMessage(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
String path = request.getContextPath();
String collectUserId = request.getParameter("collectUserId");
String collectUserName = request.getParameter("collectUserName");
String collectMessageId = request.getParameter("collectMessageId");
List<Object> params = new ArrayList<Object>();
params.add(collectUserId);
params.add(collectUserName);
params.add(collectMessageId);
SimpleDateFormat df = new SimpleDateFormat("yyyy-MM-dd HH:mm");// 設定日期格式
params.add(df.format(new Date()));
boolean flag = hobbyDao.addMusicMessage(params);
if (flag) {
JSONObject jsonmsg = new JSONObject();
jsonmsg.put("repMsg", "收藏成功");
jsonmsg.put("repCode", "666");
System.out.println(jsonmsg);
response.getWriter().print(jsonmsg);// 将路徑傳回給用戶端
} else {
JSONObject jsonmsg = new JSONObject();
jsonmsg.put("repMsg", "收藏失敗");
jsonmsg.put("repCode", "111");
System.out.println(jsonmsg);
response.getWriter().print(jsonmsg);// 将路徑傳回給用戶端
}
}
private void deletePcInterest(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
String interestId = request.getParameter("interestId");
List<Object> params = new ArrayList<Object>();
params.add(interestId);
boolean flag = hobbyDao.deleteInter(params);
if (flag) {
listMessage(request, response);
}
}
private void deleteInterest(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
String path = request.getContextPath();
String interestId = request.getParameter("interestId");
List<Object> params = new ArrayList<Object>();
params.add(interestId);
boolean flag = hobbyDao.deleteInter(params);
if (flag) {
JSONObject jsonmsg = new JSONObject();
jsonmsg.put("repMsg", "删除成功");
jsonmsg.put("repCode", "666");
System.out.println(jsonmsg);
response.getWriter().print(jsonmsg);// 将路徑傳回給用戶端
} else {
JSONObject jsonmsg = new JSONObject();
jsonmsg.put("repMsg", "送出失敗");
jsonmsg.put("repCode", "111");
System.out.println(jsonmsg);
response.getWriter().print(jsonmsg);// 将路徑傳回給用戶端
}
}
private void listInterestUserMessage(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
String interestUserId = request.getParameter("interestUserId");
List<Object> params = new ArrayList<Object>();
params.add(interestUserId);
List<Map<String, Object>> flagFood = hobbyDao.listInterestUserMessage(params);
JSONObject jsonmsg = new JSONObject();
jsonmsg.put("repMsg", "請求成功");
jsonmsg.put("repCode", "666");
jsonmsg.put("data", flagFood);
System.out.println(jsonmsg);
response.getWriter().print(jsonmsg);// 将路徑傳回給用戶端
}
private void listInterestMessage(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
String userId = request.getParameter("userId");
List<Map<String, Object>> flagFood = hobbyDao.listInterestMessage(userId);
JSONObject jsonmsg = new JSONObject();
jsonmsg.put("repMsg", "請求成功");
jsonmsg.put("repCode", "666");
jsonmsg.put("data", flagFood);
System.out.println(jsonmsg);
response.getWriter().print(jsonmsg);// 将路徑傳回給用戶端
}
private void addInterest(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
String interestTitle = request.getParameter("interestTitle");
String interestType = request.getParameter("interestType");
String interestAddress = request.getParameter("interestAddress");
String interestLatLon = request.getParameter("interestLatLon");
String interestTypeId = request.getParameter("interestTypeId");
String interestMessage = request.getParameter("interestMessage");
String interestUserId = request.getParameter("interestUserId");
String interestUserName = request.getParameter("interestUserName");
String interestImage = request.getParameter("interestImage");
String imagePath = null;
if (interestTitle == null) {
try {
List<FileItem> items = this.upload.parseRequest(request);
if (items != null && !items.isEmpty()) {
for (FileItem fileItem : items) {
String filename = fileItem.getName();
// E:\2017-2018code\A432University\UniversityLifeService
String imgPath = "E:\\2017-2018code\\A1328Community\\CommunityService\\WebRoot\\upload";
System.out.println("檔案儲存路徑為:" + imgPath + "/" + filename);
File real_path = new File(imgPath + "/" + filename);
// File file = new File(filepath);
InputStream inputSteam = fileItem.getInputStream();
BufferedInputStream fis = new BufferedInputStream(inputSteam);
FileOutputStream fos = new FileOutputStream(real_path);
int f;
while ((f = fis.read()) != -1) {
fos.write(f);
}
fos.flush();
fos.close();
fis.close();
inputSteam.close();
System.out.println("檔案:" + filename + "上傳成功!");
imagePath = filename;
}
}
} catch (FileUploadException e) {
e.printStackTrace();
}
} else {
List<Object> params = new ArrayList<Object>();
params.add(interestTitle + "");
params.add(interestType + "");
params.add(interestTypeId + "");
params.add(interestAddress + "");
params.add(interestLatLon + "");
params.add(interestMessage + "");
params.add(interestUserId + "");
params.add(interestUserName + "");
SimpleDateFormat df = new SimpleDateFormat("yyyy-MM-dd HH:mm");// 設定日期格式
params.add(df.format(new Date()));
params.add(interestImage + "");
boolean flag = hobbyDao.addInterest(params);
System.out.println(flag + "");
if (flag) {
System.out.println("上傳檔案成功!");
JSONObject jsonmsg = new JSONObject();
jsonmsg.put("repMsg", "處理成功");
jsonmsg.put("repCode", "666");
response.getWriter().print(jsonmsg);// 将路徑傳回給用戶端
} else {
System.out.println("上傳檔案失敗");
}
}
}
private void queryMRMessage(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
String medicalRecordPatientId = request.getParameter("medicalRecordPatientId");
String appointmentId = request.getParameter("appointmentId");
List<Object> params = new ArrayList<Object>();
params.add(medicalRecordPatientId);
params.add(appointmentId);
Map<String, Object> flagFood = hobbyDao.queryMRMessage(params);
JSONObject jsonmsg = new JSONObject();
jsonmsg.put("repMsg", "請求成功");
jsonmsg.put("repCode", "666");
jsonmsg.put("data", flagFood);
System.out.println(jsonmsg);
response.getWriter().print(jsonmsg);// 将路徑傳回給用戶端
}
private void addMRMessage(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
String path = request.getContextPath();
String medicalRecordPatientId = request.getParameter("medicalRecordPatientId");
String medicalRecordPatientName = request.getParameter("medicalRecordPatientName");
String medicalRecordPatientPhone = request.getParameter("medicalRecordPatientPhone");
String medicalRecordPatientTime = request.getParameter("medicalRecordPatientTime");
String medicalRecordPatientMessage = request.getParameter("medicalRecordPatientMessage");
String medicalRecordDoctorId = request.getParameter("medicalRecordDoctorId");
String medicalRecordDoctorName = request.getParameter("medicalRecordDoctorName");
String appointmentId = request.getParameter("appointmentId");
List<Object> params = new ArrayList<Object>();
params.add(medicalRecordPatientId);
params.add(medicalRecordPatientName);
params.add(medicalRecordPatientPhone);
params.add(medicalRecordPatientTime);
params.add(medicalRecordPatientMessage);
params.add(medicalRecordDoctorId);
params.add(medicalRecordDoctorName);
params.add(appointmentId);
boolean flag = hobbyDao.addMRMessage(params);
JSONObject jsonmsg = new JSONObject();
if (flag) {
jsonmsg.put("repMsg", "送出成功");
jsonmsg.put("repCode", "666");
response.getWriter().print(jsonmsg);// 将路徑傳回給用戶端
System.out.println(jsonmsg);
} else {
jsonmsg.put("repMsg", "送出失敗");
jsonmsg.put("repCode", "111");
response.getWriter().print(jsonmsg);// 将路徑傳回給用戶端
System.out.println(jsonmsg);
}
}
private void listDoctorQueryAppointmentMessage(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
String appointmentDoctorId = request.getParameter("appointmentDoctorId");
List<Object> params = new ArrayList<Object>();
params.add(appointmentDoctorId);
List<Map<String, Object>> flagFood = hobbyDao.listDoctorAppointmentmsgMessage(params);
JSONObject jsonmsg = new JSONObject();
jsonmsg.put("repMsg", "請求成功");
jsonmsg.put("repCode", "666");
jsonmsg.put("data", flagFood);
System.out.println(jsonmsg);
response.getWriter().print(jsonmsg);// 将路徑傳回給用戶端
}
private void listAppointmentMessage(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
String appointmentUserId = request.getParameter("appointmentUserId");
List<Object> params = new ArrayList<Object>();
params.add(appointmentUserId);
List<Map<String, Object>> flagFood = hobbyDao.listAppointmentmsgMessage(params);
JSONObject jsonmsg = new JSONObject();
jsonmsg.put("repMsg", "請求成功");
jsonmsg.put("repCode", "666");
jsonmsg.put("data", flagFood);
System.out.println(jsonmsg);
response.getWriter().print(jsonmsg);// 将路徑傳回給用戶端
}
private void addAppointment(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
String path = request.getContextPath();
String appointmentDoctorId = request.getParameter("appointmentDoctorId");
String appointmentDoctorName = request.getParameter("appointmentDoctorName");
String appointmentUserId = request.getParameter("appointmentUserId");
String appointmentUserName = request.getParameter("appointmentUserName");
SimpleDateFormat df = new SimpleDateFormat("yyyy-MM-dd");// 設定日期格式
List<Object> paramsCheck = new ArrayList<Object>();
paramsCheck.add(appointmentDoctorId);
paramsCheck.add(df.format(new Date()));
int appNumber = hobbyDao.getItemCount(paramsCheck);
List<Object> params = new ArrayList<Object>();
params.add(appointmentDoctorId);
params.add(appointmentDoctorName);
params.add(appointmentUserId);
params.add(appointmentUserName);
params.add(df.format(new Date()));
if (appNumber == 0) {
params.add("1");
} else {
params.add(appNumber + 1);
}
boolean flag = hobbyDao.addAppointment(params);
JSONObject jsonmsg = new JSONObject();
if (flag) {
jsonmsg.put("repMsg", "預約成功");
jsonmsg.put("repCode", "666");
response.getWriter().print(jsonmsg);// 将路徑傳回給用戶端
System.out.println(jsonmsg);
} else {
jsonmsg.put("repMsg", "預約失敗");
jsonmsg.put("repCode", "111");
response.getWriter().print(jsonmsg);// 将路徑傳回給用戶端
System.out.println(jsonmsg);
}
}
private void addMessage(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
String path = request.getContextPath();
String planName = request.getParameter("planName");
String planTime = request.getParameter("planTime");
String planUserId = request.getParameter("planUserId");
String planUserName = request.getParameter("planUserName");
List<Object> params = new ArrayList<Object>();
params.add(planName);
params.add(planTime);
params.add(planUserId);
params.add(planUserName);
System.out.println(planName);
System.out.println(planTime);
System.out.println(planUserId);
System.out.println(planUserName);
boolean flag = hobbyDao.addMessage(params);
JSONObject jsonmsg = new JSONObject();
if (flag) {
jsonmsg.put("repMsg", "送出成功");
jsonmsg.put("repCode", "666");
response.getWriter().print(jsonmsg);// 将路徑傳回給用戶端
System.out.println(jsonmsg);
} else {
jsonmsg.put("repMsg", "送出失敗");
jsonmsg.put("repCode", "111");
response.getWriter().print(jsonmsg);// 将路徑傳回給用戶端
System.out.println(jsonmsg);
}
}
private void listSearchMessage(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
String path = request.getContextPath();
String searchMsg = request.getParameter("searchMsg");
List<Map<String, Object>> list = hobbyDao.listSearchMessage(searchMsg);
JSONObject jsonmsg = new JSONObject();
jsonmsg.put("repMsg", "請求成功");
jsonmsg.put("repCode", "666");
jsonmsg.put("data", list);
System.out.println(jsonmsg);
response.getWriter().print(jsonmsg);// 将路徑傳回給用戶端
}
private void deleteMessage(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
String flowerId = request.getParameter("flowerId");
List<Object> params = new ArrayList<Object>();
params.add(flowerId);
boolean flag = hobbyDao.deleteMessage(params);
if (flag) {
listMessage(request, response);
}
}
private void updateReview(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
String rId = request.getParameter("rId");
String replyContent = request.getParameter("replyContent");
List<Object> params = new ArrayList<Object>();
params.add(replyContent);
params.add(rId);
boolean flag = hobbyDao.updateMessage(params);
if (flag) {
List<Map<String, Object>> list = hobbyDao.listReviewMessage();
request.setAttribute("listMessage", list);
request.getRequestDispatcher("../reviewListMessage.jsp").forward(request, response);
}
}
private void listPhoneMessage(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
List<Map<String, Object>> flagFood = hobbyDao.listPhoneMessage();
JSONObject jsonmsg = new JSONObject();
jsonmsg.put("repMsg", "請求成功");
jsonmsg.put("repCode", "666");
jsonmsg.put("data", flagFood);
System.out.println(jsonmsg);
response.getWriter().print(jsonmsg);// 将路徑傳回給用戶端
}
private void listMessageChoice(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
String path = request.getContextPath();
List<Map<String, Object>> list = hobbyDao.listMessage();
request.setAttribute("listMessage", list);
request.getRequestDispatcher("../formJob.jsp").forward(request, response);
}
private void listMessage(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
String path = request.getContextPath();
List<Map<String, Object>> list = hobbyDao.listMessage();
request.setAttribute("listMessage", list);
request.getRequestDispatcher("../interMessage.jsp").forward(request, response);
}
private void addOldMessage(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
String path = request.getContextPath();
String naviName = request.getParameter("naviName");
String naviJD = request.getParameter("naviJD");
String naviWD = request.getParameter("naviWD");
List<Object> params = new ArrayList<Object>();
params.add(naviName);
params.add(naviJD);
params.add(naviWD);
boolean flag = hobbyDao.addMessage(params);
if (flag) {
listMessage(request, response);
} else {
JSONObject jsonmsg = new JSONObject();
jsonmsg.put("repMsg", "送出失敗");
jsonmsg.put("repCode", "111");
System.out.println(jsonmsg);
response.getWriter().print(jsonmsg);// 将路徑傳回給用戶端
}
}
}
【文檔包含内容】
【項目部分運作截圖】