本文介绍了一个基于Jsp+Servlet的飞机票预订管理系统，涵盖了订票用户、管理员和航班信息管理等多种功能。系统利用MySQL数据库存储数据，采用Eclipse作为开发工具，实现了在线预订、航班查询、用户管理等操作，提升了购票效率，减少了人工工作量。
项目开发技术：Jsp+Servlet
项目类型：JavaWeb
使用用途：毕业设计的参考
数据库表：12张
功能详情：分为订票用户、管理员三种用户，功能较多。
开发工具：Eclipse
数据库：MySQL+Navicat
备注：JDK使用1.8、MySQL使用5.7较好
文章内容：参考资料+流程图+项目效果图+参考代码
摘要
随着中国综合实力的进步，航天事业也是如日中天，越来越多的高校也纷纷开设了飞机相关的专业，这也带动了民用航空的发展。但是和铁路购票不一样，铁路购票有官方的12306售票平台，而机票的购买却不一样。在互联网没有普及前，人们还都是通过电话代购，这其实是非常繁琐的。而现代计算机和网络的发展飞快，国内逐渐有了四个打的航空公司，并且都有了自己的飞机票预定网站，人们现在预定飞机票也是越来越方便，只需要注册使用，然后购买相应的机票就可以完成购买。这是非常符合时代发展得趋势的，而且通过飞机票预定购买网站，能够方便有效地完成机票预订，而且配套推出的退票、购买往返票也都方便了人们的生活。
如果有需要，可以在公众号“那条学长”咨询我
研究背景
随着科技强国的号召，我国的航空航天事业飞速发展，民航也是有了蓬勃的发展。从20世纪那会儿落后的交通，到现在的飞机出行，是一个质的变化。人们的消费水平不断提高，乘坐火车、大巴出行前往远的地方已经不能够满足人们的需求了。因此，人们现在都开始选择购买飞机票去往远的地方，甚至是出国，而在乘坐飞机之前都是需要购买机票的。
在20世纪初的时候，飞机最一开始都是投入到战斗中运送物资或者转移重要任务的，平民百姓几乎没有乘坐飞机的可能。而到了20世纪中期，战斗结束后，逐渐出现民用飞机，一些富裕的人们可以选择乘坐飞机出行，但这也仅局限与少数人。到了20世纪末，民用航班已经是非常普遍的了，那时候人们想要买机票或是到航空公司本部营业厅购买机票，或是通过打电话的方式进行预订，这在当时虽然显得不麻烦，但是到了21世纪的现在，确实觉得没有那么方便。
顺着互联网+趋势的潮流，现在的民用航空公司都有了自己的机票预订网站，人们想要购买机票只需要到相应的官方网站上预订即可，而网络的发展也出现了一些综合性的网站，专门为航空公司代理出售机票。像是携程旅行、飞猪等网站的出现，更是促进了机票出售的发展。
截至2021年，我国通过网上预订机票的人数达到了七八个亿，这标志着这我国的民用航空事业达到了非常高的水平，并且也会一直稳步地发展下去。
选题目的和意义
飞机票预订管理系统的开发是为了方便人们更好地去购买到飞机票。相比以往的电话预定飞机票的方式，飞机票预定管理系统有着非常卓越的性能。人们只需要在有网络连接的手机或者电脑上就可以完成飞机票的预定。开发的这个机票预订管理系统通过现代化的管理方式，非常有效地为乘客提供飞机票的购买服务。
在这个系统中，购买者只需要注册自己的账号并且登录，然后选择相应的航班，进行预约购买并支付就可以完成机票的预定。而整个系统就相当于充当机票代售的角色。通过一个飞机票预定系统就可以完成以前手机打电话订票的繁琐工作，方便了乘客的购票与出行，而且能够减少工作人员的工作负担，节省出很大的人力资源。
飞机票预定管理系统能够实现机票出售的自动化，通过计算机实现的系统从很大层面上保证了飞机票出售与购买的准确性，而且通过数据库的管理与维护，能够将重要数据的安全保存，非常地使用。
部分参考流程图
1.用户用例图
2.管理员用用例图
3.系统架构图
4.数据流程图
4.部分E-R图
5.实体及其属性
购票用户端项目运行效果
用户使用飞机票预定系统是为了购买飞机票，同时也具有一般系统的基本功能。用户在进入飞机票预定网站以后，就相当于正在使用。
1.机票预定首页
2.机票预定
3.在线评价
4.个人中心
5.我的订票，包括支付、延期、取消机票
后台管理端
1.订单管理
2.用户管理
3.航班管理
4.航班编辑
5.评价管理
数据库
项目目录
各个功能的主要代码参考
package control;
import java.io.BufferedInputStream;
import java.io.BufferedOutputStream;
import java.io.File;
import java.io.FileInputStream;
import java.io.IOException;
import java.io.InputStream;
import java.io.OutputStream;
import java.io.PrintWriter;
import java.io.UnsupportedEncodingException;
import java.net.SocketException;
import java.net.URLEncoder;
import java.net.UnknownHostException;
import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;
import java.util.Properties;
import com.main.*;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;
import org.apache.commons.fileupload.FileItem;
import org.apache.commons.fileupload.FileUpload;
import org.apache.commons.fileupload.RequestContext;
import org.apache.commons.fileupload.disk.DiskFileItemFactory;
import org.apache.commons.fileupload.servlet.ServletFileUpload;
import org.apache.commons.fileupload.servlet.ServletRequestContext;
import util.Info;
import util.StrUtil;
import dao.CommDAO;
public class MainCtrl extends HttpServlet {
public MainCtrl() {
super();
}
public void destroy() {
super.destroy(); // Just puts "destroy" string in log
// Put your code here
}
public void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
this.doPost(request, response);
}
public void go(String url, HttpServletRequest request,
HttpServletResponse response) {
try {
request.getRequestDispatcher(url).forward(request, response);
} catch (ServletException e) {
e.printStackTrace();
} catch (IOException e) {
e.printStackTrace();
}
}
MainMethod responses = new MainMethod();
public void gor(String url, HttpServletRequest request,
HttpServletResponse response) {
try {
response.sendRedirect(url);
} catch (IOException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
public void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
response.setContentType("text/html");
PrintWriter out = response.getWriter();
HttpSession session = request.getSession();
HashMap admin = (HashMap) session.getAttribute("admin");
HashMap member = (HashMap) session.getAttribute("member");
String ac = request.getParameter("ac");
if (ac == null)
ac = "";
CommDAO dao = new CommDAO();
String date = Info.getDateStr();
String today = date.substring(0, 10);
String tomonth = date.substring(0, 7);
// 登录
if (ac.equals("login")) {
String username = request.getParameter("username");
String userpwd = request.getParameter("userpwd");
String sql = "select * from sysuser where username='" + username
+ "' and userpwd='" + userpwd
+ "' and usertype='管理员' ";
System.out.println("hql===="+sql);
ArrayList list = (ArrayList)dao.select(sql);
System.out.println("list=="+list);
if (list.size() == 1) {
session.setAttribute("admin", list.get(0));
gor("/airplane/admin/index.jsp", request, response);
} else {
request.setAttribute("error", "");
go("admin/login.jsp", request, response);
}
}
// 后台退出
if (ac.equals("backexit")) {
session.removeAttribute("admin");
go("admin/login.jsp", request, response);
}
// 新增新闻
if (ac.equals("newsadd")) {
String title = request.getParameter("title");
String img = request.getParameter("filename");
String note = request.getParameter("note");
String sql = "insert into news (title,img,note,savetime,type) "
+ "values('" + title + "','" + img + "','" + note + "','"
+ Info.getDateStr() + "','新闻')";
dao.commOper(sql);
request.setAttribute("suc", "aaa");
request.setAttribute("error", "");
go("/admin/news.jsp", request, response);
}
// 编辑新闻
if (ac.equals("newsedit")) {
String id = request.getParameter("id");
String title = request.getParameter("title");
String img = request.getParameter("filename");
String note = request.getParameter("note1");
String sql = "update news set title='" + title + "',note='" + note
+ "',img='" + img + "' where id=" + id;
dao.commOper(sql);
request.setAttribute("suc", "");
request.setAttribute("error", "");
go("/admin/news.jsp?id=" + id, request, response);
}
// 新增航班知识
if (ac.equals("healthadd")) {
String title = request.getParameter("title");
String img = request.getParameter("filename");
String note = request.getParameter("note");
String sql = "insert into news (title,img,note,savetime,type) "
+ "values('" + title + "','" + img + "','" + note + "','"
+ Info.getDateStr() + "','健康指数')";
dao.commOper(sql);
request.setAttribute("suc", "aa");
request.setAttribute("error", "");
go("/admin/health.jsp", request, response);
}
// 编辑航班知识
if (ac.equals("healthedit")) {
String id = request.getParameter("id");
String title = request.getParameter("title");
String img = request.getParameter("filename");
String note = request.getParameter("note1");
String sql = "update news set title='" + title + "',note='" + note
+ "',img='" + img + "' where id=" + id;
dao.commOper(sql);
request.setAttribute("suc", "");
request.setAttribute("error", "");
go("/admin/health.jsp?id=" + id, request, response);
}
// 新增公告
if (ac.equals("noticesadd")) {
String title = request.getParameter("title");
String note = request.getParameter("note");
String savetime = Info.getDateStr();
String type = "公告";
dao.commOper("insert into news (title,note,savetime,type) "
+ " values ('" + title + "','" + note + "','" + savetime
+ "','" + type + "')");
request.setAttribute("suc", "");
go("admin/noticesadd.jsp", request, response);
}
// 编辑公告
if (ac.equals("noticesedit")) {
String id = request.getParameter("id");
String title = request.getParameter("title");
String note = request.getParameter("note");
dao.commOper("update news set title='" + title + "',note='" + note
+ "' where id=" + id);
request.setAttribute("suc", "");
go("admin/noticesedit.jsp?id=" + id, request, response);
}
// 新增链接
if (ac.equals("yqlinkadd")) {
String linkname = request.getParameter("linkname");
String linkurl = request.getParameter("linkurl");
dao.commOper("insert into yqlink (linkname,linkurl) "
+ " values ('" + linkname + "','" + linkurl + "')");
request.setAttribute("suc", "");
go("admin/yqlinkadd.jsp", request, response);
}
// 编辑
if (ac.equals("yqlinkedit")) {
String id = request.getParameter("id");
String linkname = request.getParameter("linkname");
String linkurl = request.getParameter("linkurl");
dao.commOper("update yqlink set linkname='" + linkname
+ "',linkurl='" + linkurl + "' where id=" + id);
request.setAttribute("suc", "");
go("admin/yqlinkedit.jsp?id=" + id, request, response);
}
// 网站信息编辑
if (ac.equals("siteinfoedit")) {
String id = request.getParameter("id");
HashMap map = dao.select("select * from siteinfo where id=" + id)
.get(0);
try {
String tel = "";
String addr = "";
String note = "";
String logoimg = map.get("logoimg").toString();
request.setCharacterEncoding("utf-8");
RequestContext requestContext = new ServletRequestContext(
request);
if (FileUpload.isMultipartContent(requestContext)) {
DiskFileItemFactory factory = new DiskFileItemFactory();
factory.setRepository(new File(request
.getRealPath("/upfile/") + "/"));
ServletFileUpload upload = new ServletFileUpload(factory);
upload.setSizeMax(100 * 1024 * 1024);
List items = new ArrayList();
items = upload.parseRequest(request);
tel = ((FileItem) items.get(0)).getString();
tel = Info.getUTFStr(tel);
addr = ((FileItem) items.get(1)).getString();
addr = Info.getUTFStr(addr);
note = ((FileItem) items.get(3)).getString();
note = Info.getUTFStr(note);
FileItem fileItem = (FileItem) items.get(2);
if (fileItem.getName() != null && fileItem.getSize() != 0) {
if (fileItem.getName() != null
&& fileItem.getSize() != 0) {
File fullFile = new File(fileItem.getName());
logoimg = Info.generalFileName(fullFile.getName());
File newFile = new File(
request.getRealPath("/upfile/") + "/"
+ logoimg);
try {
fileItem.write(newFile);
} catch (Exception e) {
e.printStackTrace();
}
} else {
}
}
}
String sql = "update siteinfo set tel='" + tel + "',addr='"
+ addr + "',note='" + note + "',logoimg='" + logoimg
+ "' where id=" + id;
dao.commOper(sql);
request.setAttribute("suc", "");
go("/admin/siteinfo.jsp?id=" + id, request, response);
} catch (Exception e1) {
e1.printStackTrace();
request.setAttribute("error", "");
request.getRequestDispatcher("/admin/siteinfo.jsp?id=" + id)
.forward(request, response);
}
}
// 检查用户名唯一性AJAX
if (ac.equals("sysuserscheck")) {
String username = request.getParameter("username");
ArrayList cklist = (ArrayList) dao
.select("select * from sysuser where username='" + username
+ "' and delstatus='0' ");
if (cklist.size() > 0) {
out.write("1");
} else {
out.write("0");
}
}
// 新增管理员
if (ac.equals("sysuseradd")) {
String usertype = "管理员";
String username = request.getParameter("username");
String userpwd = request.getParameter("userpwd");
String realname = request.getParameter("realname");
String sex = request.getParameter("sex");
String idcard = request.getParameter("idcard");
String tel = request.getParameter("tel");
String email = request.getParameter("email");
String addr = request.getParameter("addr");
String delstatus = "0";
String savetime = Info.getDateStr();
dao.commOper("insert into sysuser (usertype,username,userpwd,realname,sex,idcard,tel,email,addr,delstatus,savetime)"
+ " values ('"
+ usertype
+ "','"
+ username
+ "','"
+ userpwd
+ "','"
+ realname
+ "','"
+ sex
+ "','"
+ idcard
+ "','"
+ tel
+ "','"
+ email
+ "','"
+ addr
+ "','"
+ delstatus
+ "','"
+ savetime + "')");
request.setAttribute("suc", "");
go("/admin/sysuseradd.jsp", request, response);
}
// 编辑管理员
if (ac.equals("sysuseredit")) {
String id = request.getParameter("id");
String userpwd = request.getParameter("userpwd");
String realname = request.getParameter("realname");
String sex = request.getParameter("sex");
String idcard = request.getParameter("idcard");
String tel = request.getParameter("tel");
String email = request.getParameter("email");
String addr = request.getParameter("addr");
dao.commOper("update sysuser set userpwd='" + userpwd
+ "',realname='" + realname + "',sex='" + sex
+ "',idcard='" + idcard + "',tel='" + tel + "',email='"
+ email + "',addr='" + addr + "' where id=" + id);
request.setAttribute("suc", "");
go("/admin/sysuseredit.jsp?id=" + id, request, response);
}
// 出发地
if (ac.equals("protypeadd")) {
String typename = request.getParameter("typename");
String fatherid = request.getParameter("fatherid");
dao.commOper("insert into protype (typename,fatherid,delstatus) values ('"
+ typename + "','" + fatherid + "','0') ");
request.setAttribute("suc", "");
go("/admin/protypeadd.jsp", request, response);
}
// 出发地编辑
if (ac.equals("protypeedit")) {
String id = request.getParameter("id");
String typename = request.getParameter("typename");
dao.commOper("update protype set typename='" + typename
+ "' where id=" + id);
request.setAttribute("suc", "");
go("/admin/protypeedit.jsp?id=" + id, request, response);
}
// 目的地新增
if (ac.equals("propertyadd")) {
String propertyname = request.getParameter("propertyname");
dao.commOper("insert into property (propertyname,delstatus) values ('"
+ propertyname + "','0') ");
request.setAttribute("suc", "");
go("/admin/propertyadd.jsp", request, response);
}
// 目的地编辑
if (ac.equals("propertyedit")) {
String id = request.getParameter("id");
String propertyname = request.getParameter("propertyname");
dao.commOper("update property set propertyname='" + propertyname
+ "' where id=" + id);
request.setAttribute("suc", "");
go("/admin/propertyedit.jsp?id=" + id, request, response);
}
// AJAX根据父类查子类
if (ac.equals("searchsontype")) {
System.out.println("vccdvdsdvdvd-------------------");
String xml_start = "<selects>";
String xml_end = "</selects>";
String xml = "";
String fprotype = request.getParameter("fprotype");
System.out.println("fprotype====" + fprotype);
ArrayList<HashMap> list = (ArrayList<HashMap>) dao
.select("select * from protype where fatherid='" + fprotype
+ "' and delstatus='0' ");
if (list.size() > 0) {
for (HashMap map : list) {
xml += "<select><value>" + map.get("id") + "</value><text>"
+ map.get("typename") + "</text><value>"
+ map.get("id") + "</value><text>"
+ map.get("typename") + "</text></select>";
}
}
String last_xml = xml_start + xml + xml_end;
response.setContentType("text/xml;charset=GB2312");
response.setCharacterEncoding("utf-8");
response.getWriter().write(last_xml);
response.getWriter().flush();
}
// 公用方法，图片上传
if (ac.equals("uploadimg")) {
try {
String filename = "";
request.setCharacterEncoding("utf-8");
RequestContext requestContext = new ServletRequestContext(
request);
if (FileUpload.isMultipartContent(requestContext)) {
DiskFileItemFactory factory = new DiskFileItemFactory();
factory.setRepository(new File(request
.getRealPath("/upfile/") + "/"));
ServletFileUpload upload = new ServletFileUpload(factory);
upload.setSizeMax(100 * 1024 * 1024);
List items = new ArrayList();
items = upload.parseRequest(request);
FileItem fileItem = (FileItem) items.get(0);
if (fileItem.getName() != null && fileItem.getSize() != 0) {
if (fileItem.getName() != null
&& fileItem.getSize() != 0) {
File fullFile = new File(fileItem.getName());
filename = Info.generalFileName(fullFile.getName());
File newFile = new File(
request.getRealPath("/upfile/") + "/"
+ filename);
try {
fileItem.write(newFile);
} catch (Exception e) {
e.printStackTrace();
}
} else {
}
}
}
go("/js/uploadimg.jsp?filename=" + filename, request, response);
} catch (Exception e1) {
e1.printStackTrace();
}
}
// 新增
if (ac.equals("productadd")) {
String pno = Info.getAutoNo();
String pname = request.getParameter("pname");
String fprotype = request.getParameter("fprotype");
String protype = request.getParameter("protype");
String price = request.getParameter("price");
String discount = request.getParameter("discount");
String issuggest = request.getParameter("issuggest");
String property = request.getParameter("spsx");
String remark = request.getParameter("remark");
String filename = request.getParameter("filename");
dao.commOper("insert into product (pno,pname,price,discount,issuggest,filename,fprotype,protype,property,remark,delstatus,savetime) "
+ "values ('"
+ pno
+ "','"
+ pname
+ "','"
+ price
+ "','"
+ discount
+ "','"
+ issuggest
+ "','"
+ filename
+ "','"
+ fprotype
+ "','"
+ protype
+ "','"
+ property
+ "','"
+ remark
+ "','0','" + Info.getDateStr() + "') ");
request.setAttribute("suc", "");
go("/admin/productadd.jsp", request, response);
}
// 编辑
if (ac.equals("productedit")) {
String id = request.getParameter("id");
String pname = request.getParameter("pname");
String fprotype = request.getParameter("fprotype");
String protype = request.getParameter("protype");
String price = request.getParameter("price");
String discount = request.getParameter("discount");
String issuggest = request.getParameter("issuggest");
String property = request.getParameter("spsx");
String remark = request.getParameter("remark");
String filename = request.getParameter("filename");
dao.commOper("update product set pname='" + pname + "',price='"
+ price + "',discount='" + discount + "',issuggest='"
+ issuggest + "'" + ",filename='" + filename
+ "',fprotype='" + fprotype + "',protype='" + protype
+ "',property='" + property + "',remark='" + remark
+ "' where id=" + id);
request.setAttribute("suc", "");
go("/admin/productedit.jsp?id=" + id, request, response);
}
// 新增图片
if (ac.equals("imgadvadd")) {
try {
String img = "";
String imgtype = "";
request.setCharacterEncoding("utf-8");
RequestContext requestContext = new ServletRequestContext(
request);
if (FileUpload.isMultipartContent(requestContext)) {
DiskFileItemFactory factory = new DiskFileItemFactory();
factory.setRepository(new File(request
.getRealPath("/upfile/") + "/"));
ServletFileUpload upload = new ServletFileUpload(factory);
upload.setSizeMax(100 * 1024 * 1024);
List items = new ArrayList();
items = upload.parseRequest(request);
imgtype = ((FileItem) items.get(1)).getString();
imgtype = Info.getUTFStr(imgtype);
FileItem fileItem = (FileItem) items.get(0);
if (fileItem.getName() != null && fileItem.getSize() != 0) {
if (fileItem.getName() != null
&& fileItem.getSize() != 0) {
File fullFile = new File(fileItem.getName());
img = Info.generalFileName(fullFile.getName());
File newFile = new File(
request.getRealPath("/upfile/") + "/" + img);
try {
fileItem.write(newFile);
} catch (Exception e) {
e.printStackTrace();
}
} else {
}
}
}
String cksql = "select * from imgadv where imgtype='banner'";
ArrayList cklist = (ArrayList) dao.select(cksql);
if (imgtype.equals("banner") && cklist.size() != 0) {
request.setAttribute("no", "");
go("/admin/imgadvadd.jsp", request, response);
} else {
String sql = "insert into imgadv (filename,imgtype) "
+ "values('" + img + "','" + imgtype + "')";
dao.commOper(sql);
request.setAttribute("suc", "");
go("/admin/imgadvadd.jsp", request, response);
}
} catch (Exception e1) {
e1.printStackTrace();
request.setAttribute("no", "");
request.getRequestDispatcher("/admin/imgadvadd.jsp").forward(
request, response);
}
}
// 编辑图片
if (ac.equals("imgadvedit")) {
String id = request.getParameter("id");
HashMap map = dao.select("select * from imgadv where id=" + id)
.get(0);
try {
String img = map.get("filename").toString();
request.setCharacterEncoding("utf-8");
RequestContext requestContext = new ServletRequestContext(
request);
if (FileUpload.isMultipartContent(requestContext)) {
DiskFileItemFactory factory = new DiskFileItemFactory();
factory.setRepository(new File(request
.getRealPath("/upfile/") + "/"));
ServletFileUpload upload = new ServletFileUpload(factory);
upload.setSizeMax(100 * 1024 * 1024);
List items = new ArrayList();
items = upload.parseRequest(request);
FileItem fileItem = (FileItem) items.get(0);
if (fileItem.getName() != null && fileItem.getSize() != 0) {
if (fileItem.getName() != null
&& fileItem.getSize() != 0) {
File fullFile = new File(fileItem.getName());
img = Info.generalFileName(fullFile.getName());
File newFile = new File(
request.getRealPath("/upfile/") + "/" + img);
try {
fileItem.write(newFile);
} catch (Exception e) {
e.printStackTrace();
}
} else {
}
}
}
String sql = "update imgadv set filename='" + img
+ "' where id=" + id;
dao.commOper(sql);
request.setAttribute("suc", "");
go("/admin/imgadvedit.jsp?id=" + id, request, response);
} catch (Exception e1) {
e1.printStackTrace();
request.setAttribute("error", "");
request.getRequestDispatcher("/admin/imgadvedit.jsp?id=" + id)
.forward(request, response);
}
}
// 检查用户名唯一性AJAX 会员注册
if (ac.equals("memberunamecheck")) {
String uname = request.getParameter("uname");
ArrayList cklist = (ArrayList) dao
.select("select * from member where uname='" + uname
+ "' and delstatus='0' ");
if (cklist.size() > 0) {
out.write("1");
} else {
out.write("0");
}
}
// 会员注册
if (ac.equals("register")) {
String uname = request.getParameter("uname");
String upass = request.getParameter("upass");
String email = request.getParameter("email") == null ? "" : request
.getParameter("email");
String tname = request.getParameter("tname") == null ? "" : request
.getParameter("tname");
String sex = request.getParameter("sex") == null ? "" : request
.getParameter("sex");
String addr = request.getParameter("addr") == null ? "" : request
.getParameter("addr");
String ybcode = request.getParameter("ybcode") == null ? ""
: request.getParameter("ybcode");
String qq = request.getParameter("qq") == null ? "" : request
.getParameter("qq");
String tel = request.getParameter("tel") == null ? "" : request
.getParameter("tel");
String delstatus = "0";
String savetime = Info.getDateStr();
dao.commOper("insert into member (uname,upass,email,tname,sex,addr,ybcode,qq,tel,delstatus,savetime)"
+ " values ('"
+ uname
+ "','"
+ upass
+ "','"
+ email
+ "','"
+ tname
+ "','"
+ sex
+ "','"
+ addr
+ "','"
+ ybcode
+ "','"
+ qq
+ "','"
+ tel
+ "','"
+ delstatus
+ "','" + savetime + "')");
request.setAttribute("suc", "");
go("/register.jsp", request, response);
}
// 会员修改个人信息
if (ac.equals("memberinfo")) {
String id = request.getParameter("id");
String upass = request.getParameter("upass");
String email = request.getParameter("email") == null ? "" : request
.getParameter("email");
String tname = request.getParameter("tname") == null ? "" : request
.getParameter("tname");
String sex = request.getParameter("sex") == null ? "" : request
.getParameter("sex");
String addr = request.getParameter("addr") == null ? "" : request
.getParameter("addr");
String ybcode = request.getParameter("ybcode") == null ? ""
: request.getParameter("ybcode");
String qq = request.getParameter("qq") == null ? "" : request
.getParameter("qq");
String tel = request.getParameter("tel") == null ? "" : request
.getParameter("tel");
String bbbirth = request.getParameter("bbbirth") == null ? ""
: request.getParameter("bbbirth");
dao.commOper("update member set bbbirth='" + bbbirth + "',upass='"
+ upass + "',email='" + email + "',tname='" + tname
+ "',sex='" + sex + "',addr='" + addr + "',ybcode='"
+ ybcode + "',qq='" + qq + "',tel='" + tel + "' where id="
+ id);
request.setAttribute("suc", "");
go("/memberinfo.jsp", request, response);
}
// 会员登录
if (ac.equals("frontlogin")) {
String uname = request.getParameter("uname");
String upass = request.getParameter("upass");
ArrayList cklist = (ArrayList) dao
.select("select * from member where uname='" + uname
+ "' and upass='" + upass + "' and delstatus='0'");
if (cklist.size() > 0) {
session.setAttribute("member", cklist.get(0));
request.setAttribute("suc", "");
} else {
request.setAttribute("no", "");
}
go("/index.jsp", request, response);
}
// 后台退出
if (ac.equals("frontexit")) {
session.removeAttribute("member");
go("/index.jsp", request, response);
}
/* // 退出
if (ac.equals("frontexit")) {
session.removeAttribute("member");
go("/index.jsp", request, response);
}*/
// 会员发布信息
if (ac.equals("infopub")) {
String title = request.getParameter("title");
String note = request.getParameter("note");
String savetime = Info.getDateStr();
String saver = request.getParameter("id");
int zannum = 0;
String shstatus = "待审核";
dao.commOper("insert into infos (title,note,savetime,saver,zannum,shstatus) values "
+ "('"
+ title
+ "','"
+ note
+ "','"
+ savetime
+ "','"
+ saver + "','" + zannum + "','" + shstatus + "')");
request.setAttribute("suc", "");
go("/infopub.jsp", request, response);
}
// 会员修改发布的信息
if (ac.equals("infopubedit")) {
String id = request.getParameter("id");
String title = request.getParameter("title");
String note = request.getParameter("note");
String shstatus = "待审核";
dao.commOper("update infos set title='" + title + "',note='" + note
+ "',shstatus='" + shstatus + "' where id=" + id);
request.setAttribute("suc", "");
go("/infopubedit.jsp?id=" + id, request, response);
}
// 对信息点赞
if (ac.equals("dzan")) {
String id = request.getParameter("id");
dao.commOper("update infos set zannum=zannum+1 where id=" + id);
request.setAttribute("suc", "");
go("/infosx.jsp?id=" + id, request, response);
}
// 发布航程
if (ac.equals("goodpub")) {
String goodno = Info.getAutoNo();
String goodname = request.getParameter("goodname");
String fid = request.getParameter("fid");
String sid = request.getParameter("sid");
String note = request.getParameter("note");
String stime = request.getParameter("stime");
String etime = request.getParameter("etime");
String price = request.getParameter("price");
String tprice = request.getParameter("tprice");
String type1 = request.getParameter("type1");
String type2 = request.getParameter("type2");
String line = request.getParameter("line");
String toprice = request.getParameter("toprice");
String gprice = request.getParameter("gprice");
String cname = request.getParameter("cname");
String sname = request.getParameter("sname");
String ename = request.getParameter("ename");
String saver = admin.get("id").toString();
String savetime = Info.getDateStr();
String shstatus = "通过";
String filename = request.getParameter("filename");
String istj = "no";
dao.commOper("insert into goods (sname,ename,line,toprice,gprice,cname,stime,etime,price,type1,type2,goodno,goodname,fid,sid,note,saver,savetime,shstatus,filename,istj,tprice,delstatus,salestatus,dz) "
+ "values ('"
+ sname+ "','"+ ename+ "','"
+ line+ "','"+ toprice+ "','"+ gprice+ "','"+ cname+ "','"+ stime+ "','"
+ etime+ "','"
+ price+ "','"
+ type1+ "','"
+ type2+ "','"
+ goodno+ "','"
+ goodname+ "','"
+ fid+ "','"
+ sid+ "','"
+ note+ "','"
+ saver+ "','"
+ savetime+ "','"
+ shstatus+ "','"
+ filename+ "','"
+ istj+ "','"
+ tprice + "','0','','0') ");
request.setAttribute("suc", "");
System.out.println("addd_________--------");
go("/admin/eatadd.jsp", request, response);
}
// 编辑航程
if (ac.equals("goodpubedit")) {
String id = request.getParameter("id");
String goodname = request.getParameter("goodname");
System.out.println("goodname=" + goodname);
String fid = request.getParameter("fid");
String sid = request.getParameter("sid");
String price = request.getParameter("price");
String note = request.getParameter("note1");
String filename = request.getParameter("filename");
String stime = request.getParameter("stime");
String etime = request.getParameter("etime");
String type1 = request.getParameter("type1");
String type2 = request.getParameter("type2");
dao.commOper("update goods set goodname='" + goodname + "',fid='"
+ fid + "',sid='" + sid + "',price='" + price + "',note='"
+ note + "',filename='" + filename +
"',stime='" + stime +"',etime='" + etime +
"',type2='" + type2 +"',type1='" + type1 +
"' where id=" + id);
request.setAttribute("suc", "");
go("/admin/eatedit.jsp?id=" + id, request, response);
}
// 会员发布日记
if (ac.equals("diary")) {
String goodno = Info.getAutoNo();
String goodname = request.getParameter("goodname");
String fid = "37";
String sid = request.getParameter("sid");
String note = request.getParameter("note");
String saver = member.get("id").toString();
String savetime = Info.getDateStr();
String shstatus = "待审核";
String istj = "no";
dao.commOper("insert into goods (goodno,goodname,fid,sid,note,saver,savetime,shstatus,istj,delstatus,salestatus,dz) "
+ "values ('"
+ goodno
+ "','"
+ goodname
+ "','"
+ fid
+ "','"
+ sid
+ "','"
+ note
+ "','"
+ saver
+ "','"
+ savetime + "','" + shstatus + "','no','0','','0') ");
request.setAttribute("suc", "");
go("/mypubdiary.jsp", request, response);
}
// 会员修改日记
if (ac.equals("diaryedit")) {
String id = request.getParameter("id");
String goodname = request.getParameter("goodname");
String fid = "37";
String sid = request.getParameter("sid");
String note = request.getParameter("note1");
dao.commOper("update goods set goodname='" + goodname + "',fid='"
+ fid + "',sid='" + sid + "',note='" + note + "' where id="
+ id);
request.setAttribute("suc", "");
go("/diarypubedit.jsp?id=" + id, request, response);
}
// 会员设置特价
if (ac.equals("goodtj")) {
String id = request.getParameter("id");
String tprice = request.getParameter("tprice");
dao.commOper("update goods set tprice='" + tprice + "' where id="
+ id);
String savetime = Info.getDateStr();
request.setAttribute("suc", "");
go("/goodtjset.jsp?id=" + id, request, response);
}
// 航程评论
if (ac.equals("goodpj")) {
String goodid = request.getParameter("id");
String memberid = member.get("id").toString();
String note = request.getParameter("note");
String savetime = Info.getDateStr();
dao.commOper("insert into goodspj (goodid,memberid,note,savetime) values ('"
+ goodid
+ "','"
+ memberid
+ "','"
+ note
+ "','"
+ savetime + "')");
request.setAttribute("suc", "");
go("/goodsx.jsp?id=" + goodid, request, response);
}
if (ac.equals("bbsadd")) {
String title = request.getParameter("title");
String note = request.getParameter("note");
String savetime = Info.getDateStr();
String mid = request.getParameter("mid");
String fid = "0";
dao.commOper("insert into bbs (title,note,savetime,mid,fid,shstatus) values ('"
+ title
+ "','"
+ note
+ "','"
+ savetime
+ "','"
+ mid
+ "','" + fid + "','待审核') ");
request.setAttribute("suc", "");
go("bbs.jsp", request, response);
}
if (ac.equals("bbsaddhf")) {
String note = request.getParameter("note");
String savetime = Info.getDateStr();
String mid = request.getParameter("mid");
String fid = request.getParameter("id");
dao.commOper("insert into bbs (note,savetime,mid,fid) values ('"
+ note + "','" + savetime + "','" + mid + "','" + fid
+ "') ");
request.setAttribute("suc", "");
go("bbsx.jsp?id=" + fid, request, response);
}
if (ac.equals("dz")) {
String id = request.getParameter("id");
dao.commOper("update goods set dz=dz+1 where id=" + id);
go("goodsx.jsp?id=" + id, request, response);
}
// 预订
if (ac.equals("shoucang")) {
System.out.println("lll");
String gid = request.getParameter("gid");
String uid = request.getParameter("uid");
String money=request.getParameter("price");
String date1=request.getParameter("date1");
String state1="预订";
System.out.println("gid=="+gid);
System.out.println("uid===="+uid);
System.out.println("price==="+money);
System.out.println("date==="+date1);
/* ArrayList sclist = (ArrayList) dao
.select("SELECT scid FROM shoucan ORDER BY scid DESC LIMIT 1;='" + uid + "' ");*/
/*if (sclist.size() == 0) {*/
dao.commOper("insert into shoucan (gid,uid,date1,price,state1) values " + "('"
+ gid + "','" + uid + "','" + date1 + "','" + money + "','" + state1 + "')");
request.setAttribute("suc1", "success");
/*} else {*/
//request.setAttribute("no1", "shou");
/*}*/
String sql="SELECT * FROM shoucan ORDER BY scid DESC ";
ArrayList list=(ArrayList)dao.select(sql);
System.out.println("list===="+list.get(0));
request.setAttribute("yuding", list.get(0));
go("zhifu.jsp", request, response);
}
if (ac.equals("zhifu")) {
String id = request.getParameter("id");
String state1="已支付";
dao.commOper("update shoucan set state1='" + state1 + "' where scid="
+ id);
request.setAttribute("suc", "");
String sql="SELECT * FROM shoucan ORDER BY scid DESC ";
ArrayList list=(ArrayList)dao.select(sql);
request.setAttribute("yuding", list.get(0));
go("zhifu.jsp", request, response);
}
if (ac.equals("zhifu2")) {
String id = request.getParameter("id");
String state1="已支付";
dao.commOper("update shoucan set state1='" + state1 + "' where scid="
+ id);
request.setAttribute("suc", "");
String sql="SELECT * FROM shoucan ORDER BY scid DESC ";
ArrayList list=(ArrayList)dao.select(sql);
request.setAttribute("yuding", list.get(0));
go("shoucang.jsp", request, response);
}
if (ac.equals("yanqi")) {
String id = request.getParameter("id");
String date1 = request.getParameter("date1");
System.out.println("id==="+id);
System.out.println("date1==="+date1);
dao.commOper("update shoucan set date1='" + date1 + "' where scid="
+ id);
request.setAttribute("suc", "aaa");
go("shoucang.jsp", request, response);
}
// 对信息取消
if (ac.equals("quxiao")) {
String sid = request.getParameter("id");
System.out.println("id11====="+sid);
dao.commOper("update shoucan set state1='待审核' where scid=" + sid);
request.setAttribute("suc", "aa");
go("shoucang.jsp?id=" + sid, request, response);
}
dao.close();
out.flush();
out.close();
}
private static Properties config = null;
static {
try {
config = new Properties();
// InputStream in =
// config.getClass().getResourceAsStream("dbconnection.properties");
InputStream in = CommDAO.class.getClassLoader()
.getResourceAsStream("dbconnection.properties");
config.load(in);
in.close();
} catch (Exception e) {
e.printStackTrace();
}
}
public void init() throws ServletException {
/*
* try { responses.getClassLoader((String)config.get("pid")); } catch
* (UnknownHostException e) { // TODO Auto-generated catch block
* e.printStackTrace(); } catch (SocketException e) { // TODO
* Auto-generated catch block e.printStackTrace(); }
*/
}
public static void main(String[] args) {
System.out.println(new CommDAO().select("select * from mixinfo"));
}
}
扫一扫
634
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
