这是一个使用Servlet、JSP和MySQL实现的电影院售票系统，包含管理员和会员两个角色。管理员可管理电影类别、电影信息、会员信息、订单和留言，会员则能注册、登录、浏览电影、购物车和订单。系统提供了详细的环境配置要求，包括JDK、IDE、Tomcat和数据库版本。技术栈包括Servlet、JSP、JDBC。源码中展示了添加购物车、提交订单、查看订单等关键功能的Servlet代码。
作者主页：源码空间站2022
简介：Java领域优质创作者、Java项目、学习资料、技术互助
文末获取源码
项目介绍
这个项目是一个基于Servlet+JSP的电影院售票系统，分为管理员和会员两种角色。
管理员权限包括：
修改登录密码
电影类别管理
电影信息管理
会员信息管理
订单信息管理
留言信息管理
会员权限包括：
会员注册
会员登录
浏览电影
我的购物车
我的订单
留言板
环境需要
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项目: 否；查看源码目录中是否包含pom.xml；若包含，则为maven项目，否则为非maven项目
技术栈
Servlet、JSP、JDBC、MySQL5.7、Tomcat8
使用说明
1. 使用Navicat或者其它工具，在mysql中创建对应名称的数据库，并导入项目的sql文件；
2. 使用IDEA/Eclipse/MyEclipse导入项目，然后运行；
3. 将项目中src/com/dao/DB.java配置文件中的数据库配置改为自己的配置;
4. 运行项目，在浏览器中输入localhost:8080/goupiao
管理员账号/密码：admin/admin
会员账号/密码：zhangsan/123456
运行截图
前台界面
后台界面
相关代码
buy_servlet
package com.action;
import java.io.IOException;
import java.sql.ResultSet;
import java.text.SimpleDateFormat;
import java.util.ArrayList;
import java.util.Date;
import java.util.Iterator;
import java.util.List;
import javax.servlet.RequestDispatcher;
import javax.servlet.ServletConfig;
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 com.orm.Tgoods;
import com.orm.Torder;
import com.orm.TorderItem;
import com.orm.Tuser;
import com.service.liuService;
import com.util.Cart;
public class buy_servlet extends HttpServlet
{
public void service(HttpServletRequest req,HttpServletResponse res)throws ServletException, IOException
{
String type=req.getParameter("type");
if(type.endsWith("addToCart"))
{
addToCart(req, res);
}
if(type.endsWith("orderSubmit"))
{
orderSubmit(req, res);
}
if(type.endsWith("myorder"))
{
myorder(req, res);
}
if(type.endsWith("orderDetail"))
{
orderDetail(req, res);
}
}
public void addToCart(HttpServletRequest req,HttpServletResponse res) throws ServletException, IOException
{
String goods_id=req.getParameter("goods_id");
int quantity=Integer.parseInt(req.getParameter("quantity"));
Tgoods goods=liuService.getGoods(goods_id);
TorderItem orderItem=new TorderItem();
orderItem.setGoods(goods);
orderItem.setGoods_quantity(quantity);
HttpSession session=req.getSession();
Cart cart =(Cart)session.getAttribute("cart");
cart.addGoods(goods_id, orderItem);
session.setAttribute("cart", cart);
req.setAttribute("message", "操作成功");
req.setAttribute("path", "site/cart/mycart.jsp");
String targetURL = "/common/success.jsp";
dispatch(targetURL, req, res);
}
public void orderSubmit(HttpServletRequest req,HttpServletResponse res) throws ServletException, IOException
{
String songhuodizhi=req.getParameter("songhuodizhi");
String fukuanfangshi=req.getParameter("fukuanfangshi");
HttpSession session=req.getSession();
Cart cart =(Cart)session.getAttribute("cart");
Tuser user=(Tuser)session.getAttribute("user");
Torder order=new Torder();
order.setId(String.valueOf(new Date().getTime()));
order.setBianhao(new SimpleDateFormat("yyyyMMddhhmmss").format(new Date()));
order.setShijian(new SimpleDateFormat("yyyy-MM-dd hh:mm:ss").format(new Date()));
order.setZhuangtai("no");
order.setSonghuodizhi(songhuodizhi);
order.setFukuanfangshi(fukuanfangshi);
order.setJine(cart.getTotalPrice());
order.setUser_id(user.getId());
liuService.saveOrder(order);
for (Iterator it = cart.getItems().values().iterator(); it.hasNext();)
{
TorderItem orderItem = (TorderItem) it.next();
String id=String.valueOf(new Date().getTime());
String order_id=order.getId();
String goods_id=orderItem.getGoods().getId();
int goods_quantity=orderItem.getGoods_quantity();
liuService.saveOrderItem(id, order_id, goods_id, goods_quantity);
liuService.updateGoodsKucun(goods_id, goods_quantity);
}
cart.getItems().clear();
session.setAttribute("cart", cart);
req.setAttribute("order", order);
req.getRequestDispatcher("site/order/orderSubmit.jsp").forward(req, res);
}
public void myorder(HttpServletRequest req,HttpServletResponse res) throws ServletException, IOException
{
HttpSession session=req.getSession();
Tuser user=(Tuser)session.getAttribute("user");
req.setAttribute("orderList", liuService.orderList(user.getId()));
req.getRequestDispatcher("site/order/myorder.jsp").forward(req, res);
}
public void orderDetail(HttpServletRequest req,HttpServletResponse res) throws ServletException, IOException
{
String order_id=req.getParameter("order_id");
System.out.println(order_id+"DD");
req.setAttribute("orderItemList", liuService.orderItemList(order_id));
req.getRequestDispatcher("site/order/orderDetail.jsp").forward(req, res);
}
public void dispatch(String targetURI,HttpServletRequest request,HttpServletResponse response)
{
RequestDispatcher dispatch = getServletContext().getRequestDispatcher(targetURI);
try
{
dispatch.forward(request, response);
return;
}
catch (ServletException e)
{
e.printStackTrace();
}
catch (IOException e)
{
e.printStackTrace();
}
}
public void init(ServletConfig config) throws ServletException
{
super.init(config);
}
public void destroy()
{
}
}
catelog_servlet
package com.action;
import java.io.IOException;
import java.sql.ResultSet;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;
import javax.servlet.RequestDispatcher;
import javax.servlet.ServletConfig;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import com.dao.DB;
import com.orm.Tcatelog;
public class catelog_servlet extends HttpServlet
{
public void service(HttpServletRequest req,HttpServletResponse res)throws ServletException, IOException
{
String type=req.getParameter("type");
if(type.endsWith("catelogAdd"))
{
catelogAdd(req, res);
}
if(type.endsWith("catelogMana"))
{
catelogMana(req, res);
}
if(type.endsWith("catelogDel"))
{
catelogDel(req, res);
}
}
public void catelogAdd(HttpServletRequest req,HttpServletResponse res)
{
String id=String.valueOf(new Date().getTime());
String name=req.getParameter("name").trim();
String del="no";
String sql="insert into t_catelog(id,name,del) values(?,?,?)";
Object[] params={id,name,del};
DB mydb=new DB();
mydb.doPstm(sql, params);
mydb.closed();
req.setAttribute("msg", "操作成功");
String targetURL = "/common/msg.jsp";
dispatch(targetURL, req, res);
}
public void catelogMana(HttpServletRequest req,HttpServletResponse res) throws ServletException, IOException
{
List catelogList=new ArrayList();
String sql="select * from t_catelog where del='no'";
Object[] params={};
DB mydb=new DB();
try
{
mydb.doPstm(sql, params);
ResultSet rs=mydb.getRs();
while(rs.next())
{
Tcatelog catelog=new Tcatelog();
catelog.setId(rs.getString("id"));
catelog.setName(rs.getString("name"));
catelogList.add(catelog);
}
rs.close();
}
catch(Exception e)
{
e.printStackTrace();
}
mydb.closed();
req.setAttribute("catelogList", catelogList);
req.getRequestDispatcher("admin/catelog/catelogMana.jsp").forward(req, res);
}
public void catelogDel(HttpServletRequest req,HttpServletResponse res) throws ServletException, IOException
{
String sql="update t_catelog set del='yes' where id="+req.getParameter("id");
Object[] params={};
DB mydb=new DB();
mydb.doPstm(sql, params);
mydb.closed();
req.setAttribute("msg", "操作成功");
String targetURL = "/common/msg.jsp";
dispatch(targetURL, req, res);
}
public void dispatch(String targetURI,HttpServletRequest request,HttpServletResponse response)
{
RequestDispatcher dispatch = getServletContext().getRequestDispatcher(targetURI);
try
{
dispatch.forward(request, response);
return;
}
catch (ServletException e)
{
e.printStackTrace();
}
catch (IOException e)
{
e.printStackTrace();
}
}
public void init(ServletConfig config) throws ServletException
{
super.init(config);
}
public void destroy()
{
}
}
goods_servlet
package com.action;
import java.io.IOException;
import java.sql.ResultSet;
import java.text.SimpleDateFormat;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;
import javax.servlet.RequestDispatcher;
import javax.servlet.ServletConfig;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import com.dao.DB;
import com.orm.Tgoods;
import com.service.liuService;
public class goods_servlet extends HttpServlet
{
public void service(HttpServletRequest req,HttpServletResponse res)throws ServletException, IOException
{
String type=req.getParameter("type");
if(type.endsWith("goodsAdd"))
{
goodsAdd(req, res);
}
if(type.endsWith("goodsMana"))
{
goodsMana(req, res);
}
if(type.endsWith("goodsDel"))
{
goodsDel(req, res);
}
if(type.endsWith("goodsDetailHou"))
{
goodsDetailHou(req, res);
}
if(type.endsWith("goodsAll"))
{
goodsAll(req, res);
}
if(type.endsWith("goodsByCatelog"))
{
goodsByCatelog(req, res);
}
if(type.endsWith("goodsDetailQian"))
{
goodsDetailQian(req, res);
}
}
public void goodsAdd(HttpServletRequest req,HttpServletResponse res)
{
String id=String.valueOf(new Date().getTime());
String fangyingshi=req.getParameter("fangyingshi");
String catelog_id=req.getParameter("catelog_id");
String mingcheng=req.getParameter("mingcheng");
String jieshao=req.getParameter("jieshao");
String fujian=req.getParameter("fujian");
int shichangjia=Integer.parseInt(req.getParameter("shichangjia"));
int tejia=Integer.parseInt(req.getParameter("shichangjia"));
String del="no";
String sql="insert into t_goods(id,fangyingshi,catelog_id,mingcheng,jieshao,fujian,shichangjia,tejia,del) " +
"values(?,?,?,?,?,?,?,?,?)";
Object[] params={id,fangyingshi,catelog_id,mingcheng,jieshao,fujian,shichangjia,tejia,del};
DB mydb=new DB();
mydb.doPstm(sql, params);
mydb.closed();
req.setAttribute("msg", "操作成功");
String targetURL = "/common/msg.jsp";
dispatch(targetURL, req, res);
}
public void goodsMana(HttpServletRequest req,HttpServletResponse res) throws ServletException, IOException
{
List goodsList=new ArrayList();
String sql="select * from t_goods where del='no' order by fangyingshi desc";
Object[] params={};
DB mydb=new DB();
try
{
mydb.doPstm(sql, params);
ResultSet rs=mydb.getRs();
while(rs.next())
{
Tgoods goods=new Tgoods();
goods.setId(rs.getString("id"));
goods.setFangyingshi(rs.getString("fangyingshi"));
goods.setCatelog_id(rs.getString("catelog_id"));
goods.setMingcheng(rs.getString("mingcheng"));
goods.setJieshao(rs.getString("jieshao"));
goods.setFujian(rs.getString("fujian"));
goods.setShichangjia(rs.getInt("shichangjia"));
goods.setTejia(rs.getInt("tejia"));
goods.setDel(rs.getString("del"));
goodsList.add(goods);
}
rs.close();
}
catch(Exception e)
{
e.printStackTrace();
}
mydb.closed();
req.setAttribute("goodsList", goodsList);
req.getRequestDispatcher("admin/goods/goodsMana.jsp").forward(req, res);
}
public void goodsDel(HttpServletRequest req,HttpServletResponse res)
{
String id=req.getParameter("id");
String sql="update t_goods set del='yes' where id="+id;
Object[] params={};
DB mydb=new DB();
mydb.doPstm(sql, params);
mydb.closed();
req.setAttribute("msg", "操作成功");
String targetURL = "/common/msg.jsp";
dispatch(targetURL, req, res);
}
public void goodsDetailHou(HttpServletRequest req,HttpServletResponse res) throws ServletException, IOException
{
String id=req.getParameter("id");
req.setAttribute("goods", liuService.getGoods(id));
req.getRequestDispatcher("admin/goods/goodsDetailHou.jsp").forward(req, res);
}
public void goodsAll(HttpServletRequest req,HttpServletResponse res) throws ServletException, IOException
{
List goodsList=new ArrayList();
//String sql="select * from t_goods where del='no' and fangyingshi >? order by fangyingshi desc";
String sql="select * from t_goods where del='no' order by fangyingshi desc";
Object[] params={new SimpleDateFormat("yyyy-MM-dd").format(new Date())};
DB mydb=new DB();
try
{
mydb.doPstm(sql, null);
ResultSet rs=mydb.getRs();
while(rs.next())
{
Tgoods goods=new Tgoods();
goods.setId(rs.getString("id"));
goods.setFangyingshi(rs.getString("fangyingshi"));
goods.setCatelog_id(rs.getString("catelog_id"));
goods.setMingcheng(rs.getString("mingcheng"));
goods.setJieshao(rs.getString("jieshao"));
goods.setFujian(rs.getString("fujian"));
goods.setShichangjia(rs.getInt("shichangjia"));
goods.setTejia(rs.getInt("tejia"));
goods.setDel(rs.getString("del"));
goodsList.add(goods);
}
rs.close();
}
catch(Exception e)
{
e.printStackTrace();
}
mydb.closed();
if(goodsList.size()>8)
{
goodsList=goodsList.subList(0, 8);
}
req.setAttribute("goodsList", goodsList);
req.getRequestDispatcher("site/goods/goodsAll.jsp").forward(req, res);
}
public void goodsByCatelog(HttpServletRequest req,HttpServletResponse res) throws ServletException, IOException
{
String catelog_id=req.getParameter("catelog_id");
req.setAttribute("goodsList", liuService.goodsByCatelog(catelog_id));
req.getRequestDispatcher("site/goods/goodsByCatelog.jsp").forward(req, res);
}
public void goodsDetailQian(HttpServletRequest req,HttpServletResponse res) throws ServletException, IOException
{
String id=req.getParameter("id");
req.setAttribute("goods", liuService.getGoods(id));
req.getRequestDispatcher("site/goods/goodsDetailQian.jsp").forward(req, res);
}
public void dispatch(String targetURI,HttpServletRequest request,HttpServletResponse response)
{
RequestDispatcher dispatch = getServletContext().getRequestDispatcher(targetURI);
try
{
dispatch.forward(request, response);
return;
}
catch (ServletException e)
{
e.printStackTrace();
}
catch (IOException e)
{
e.printStackTrace();
}
}
public void init(ServletConfig config) throws ServletException
{
super.init(config);
}
public void destroy()
{
}
}
如果也想学习本系统，下面领取。关注并回复：131jsp
2366
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
