基于javaweb+mysql的ssm博物馆售票管理系统(java+ssm+jsp+jquery+ajax+mysql)
私信源码获取及调试交流
运行环境
Java≥8、MySQL≥5.7、Tomcat≥8
开发工具
eclipse/idea/myeclipse/sts等均可配置运行
适用
课程设计,大作业,毕业设计,项目练习,学习演示等
功能说明
基于javaweb的SSM博物馆售票管理系统(java+ssm+jsp+jquery+ajax+mysql)
项目介绍
本项目分为前后台,前台为普通用户登录,后台为管理员登录; 管理员角色包含以下功能: 管理员登录,系统用户管理,游客用户查询,新闻管理,场馆信息管理,门票管理,订单管理,订单统计,留言信息查看,留言回复等功能。 用户角色包含以下功能: 用户首页,查看某一展品,用户登录注册,加入购物车,查看我的订单,修改个人信息等功能。
环境需要
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项目:否;
技术栈
- 后端:Spring+SpringMVC+Mybatis 2. 前端:JSP+css+javascript+jQuery+Ajax
使用说明
- 使用Navicat或者其它工具,在mysql中创建对应名称的数据库,并导入项目的sql文件; 2. 使用IDEA/Eclipse/MyEclipse导入项目,Eclipse/MyEclipse导入时,若为maven项目请选择maven; 若为maven项目,导入成功后请执行maven clean;maven install命令,然后运行; 3. 将项目中springmvc-servlet.xml配置文件中的数据库配置改为自己的配置; 4. 运行项目,在浏览器中输入http://localhost:8080/ssm_bwgsp_sys 登录
return "users/cart";
}
// 删除购物车中的产品
@RequestMapping("deletecart.action")
public String deletecart(String id) {
this.front();
if (this.getSession().getAttribute("userid") == null) {
return "redirect:/index/preLogin.action";
}
this.cartService.deleteCart(id);
return "redirect:/index/cart.action";
}
// 准备结算
@RequestMapping("preCheckout.action")
public String preCheckout() {
this.front();
if (this.getSession().getAttribute("userid") == null) {
return "redirect:/index/preLogin.action";
}
String userid = (String) this.getSession().getAttribute("userid");
Cart cart = new Cart();
cart.setUsersid(userid);
List<Cart> cartList = this.cartService.getCartByCond(cart);
if (cartList.size() == 0) {
this.getRequest().setAttribute("message", "请选购商品");
return "redirect:/index/cart.action";
}
return "users/checkout";
}
// 结算
@RequestMapping("checkout.action")
public String checkout() {
this.front();
if (this.getSession().getAttribute("userid") == null) {
return "redirect:/index/preLogin.action";
}
String userid = (String) this.getSession().getAttribute("userid");
Cart cart1 = new Cart();
cart1.setUsersid(userid);
List<Cart> cartList = this.cartService.getCartByCond(cart1);
if (cartList.size() == 0) {
this.getRequest().setAttribute("message", "请选购商品");
return "redirect:/index/cart.action";
if (!targetFile.exists()) {
targetFile.mkdirs();
}
// 保存
try {
file.transferTo(targetFile);
} catch (Exception e) {
e.printStackTrace();
}
model.addAttribute("imageFileName", fileName);
return "savefile";
}
}
/**
* Action 基类
*/
@Controller
public class BaseAction {
/* 日志 */
protected final Log log = LogFactory.getLog(getClass());
/* 获取基本环境 */
public Map<String, String[]> getParameters() {// 封装为Map的requestParameters
ServletRequestAttributes attrs = (ServletRequestAttributes) RequestContextHolder.getRequestAttributes();
return attrs.getRequest().getParameterMap();
}
public HttpServletRequest getRequest() {
ServletRequestAttributes attrs = (ServletRequestAttributes) RequestContextHolder.getRequestAttributes();
return attrs.getRequest();
@RequestMapping("deleteCartByIds.action")
public String deleteCartByIds() {
String[] ids = this.getRequest().getParameterValues("cartid");
for (String cartid : ids) {
this.cartService.deleteCart(cartid);
}
return "redirect:/cart/getAllCart.action";
}
// 更新数据
@RequestMapping("updateCart.action")
public String updateCart(Cart cart) {
this.cartService.updateCart(cart);
return "redirect:/cart/getAllCart.action";
}
// 显示全部数据
@RequestMapping("getAllCart.action")
public String getAllCart(String number) {
List<Cart> cartList = this.cartService.getAllCart();
PageHelper.getPage(cartList, "cart", null, null, 10, number, this.getRequest(), null);
return "admin/listcart";
}
// 按条件查询数据 (模糊查询)
@RequestMapping("queryCartByCond.action")
public String queryCartByCond(String cond, String name, String number) {
Cart cart = new Cart();
if (cond != null) {
if ("usersid".equals(cond)) {
cart.setUsersid(name);
}
if ("venueid".equals(cond)) {
cart.setVenueid(name);
}
if ("ticketid".equals(cond)) {
cart.setTicketid(name);
}
if ("num".equals(cond)) {
cart.setNum(name);
}
if ("price".equals(cond)) {
cart.setPrice(name);
}
if ("addtime".equals(cond)) {
cart.setAddtime(name);
}
}
if ("contents".equals(cond)) {
article.setContents(name);
}
if ("addtime".equals(cond)) {
article.setAddtime(name);
}
if ("hits".equals(cond)) {
article.setHits(name);
}
}
List<String> nameList = new ArrayList<String>();
List<String> valueList = new ArrayList<String>();
nameList.add(cond);
valueList.add(name);
PageHelper.getPage(this.articleService.getArticleByLike(article), "article", nameList, valueList, 10, number, this.getRequest(),
"query");
name = null;
cond = null;
return "admin/queryarticle";
}
// 按主键查询数据
@RequestMapping("getArticleById.action")
public String getArticleById(String id) {
Article article = this.articleService.getArticleById(id);
this.getRequest().setAttribute("article", article);
return "admin/editarticle";
}
public ArticleService getArticleService() {
return articleService;
}
public void setArticleService(ArticleService articleService) {
this.articleService = articleService;
}
}
int i = 0;
for (String key : map.keySet()) {
count.put(map.get(key));
day.put(key);
i++;
if(i>10) {
break;
}
}
json.put("count", count);
json.put("days", day);
return json.toString();
}
// 添加数据
@RequestMapping("addOrders.action")
public String addOrders(Orders orders) {
this.ordersService.insertOrders(orders);
return "redirect:/orders/createOrders.action";
}
// 通过主键删除数据
@RequestMapping("deleteOrders.action")
public String deleteOrders(String id) {
this.ordersService.deleteOrders(id);
return "redirect:/orders/getAllOrders.action";
}
// 批量删除数据
@RequestMapping("deleteOrdersByIds.action")
public String deleteOrdersByIds() {
String[] ids = this.getRequest().getParameterValues("ordersid");
for (String ordersid : ids) {
this.ordersService.deleteOrders(ordersid);
}
return "redirect:/orders/getAllOrders.action";
}
// 更新数据
@RequestMapping("updateOrders.action")
return "redirect:/index/cart.action";
}
// 准备结算
@RequestMapping("preCheckout.action")
public String preCheckout() {
this.front();
if (this.getSession().getAttribute("userid") == null) {
return "redirect:/index/preLogin.action";
}
String userid = (String) this.getSession().getAttribute("userid");
Cart cart = new Cart();
cart.setUsersid(userid);
List<Cart> cartList = this.cartService.getCartByCond(cart);
if (cartList.size() == 0) {
this.getRequest().setAttribute("message", "请选购商品");
return "redirect:/index/cart.action";
}
return "users/checkout";
}
// 结算
@RequestMapping("checkout.action")
public String checkout() {
this.front();
if (this.getSession().getAttribute("userid") == null) {
return "redirect:/index/preLogin.action";
}
String userid = (String) this.getSession().getAttribute("userid");
Cart cart1 = new Cart();
cart1.setUsersid(userid);
List<Cart> cartList = this.cartService.getCartByCond(cart1);
if (cartList.size() == 0) {
this.getRequest().setAttribute("message", "请选购商品");
return "redirect:/index/cart.action";
} else {
// 获取一个1000-9999的随机数 防止同时提交
String ordercode = "TD" + VeDate.getStringDatex();
double total = 0;
for (Cart cart : cartList) {
Items details = new Items();
details.setItemsid(VeDate.getStringDatex() + (Math.random() * 9 + 1) * 1000);
details.setVenueid(cart.getVenueid());
details.setTicketid(cart.getTicketid());
details.setNum(cart.getNum());
details.setOrdercode(ordercode);
details.setPrice(cart.getPrice());
this.itemsService.insertItems(details);
total += Double.parseDouble(cart.getPrice()) * Double.parseDouble(cart.getNum());
this.cartService.deleteCart(cart.getCartid());
}
Orders orders = new Orders();
orders.setAddtime(VeDate.getStringDateShort());
public static void getPage(String name, List<?> list, String path, int pageSize, String number, HttpServletRequest request) {
StringBuffer buffer = new StringBuffer();
List<Object> objList = new ArrayList<Object>();
int pageNumber = list.size();
int maxPage = pageNumber;
if (maxPage % 10 == 0) {
maxPage = maxPage / 10;
} else {
maxPage = maxPage / 10 + 1;
}
if (number == null) {
number = "0";
}
int start = Integer.parseInt(number) * 10;
int over = (Integer.parseInt(number) + 1) * 10;
int count = pageNumber - over;
if (count <= 0) {
over = pageNumber;
}
for (int i = start; i < over; i++) {
Object obj = list.get(i);
objList.add(obj);
}
buffer.append(" 共为");
buffer.append(maxPage);
buffer.append("页 共有");
buffer.append(pageNumber);
buffer.append("条 当前为第");
buffer.append((Integer.parseInt(number) + 1));
buffer.append("页 ");
if ((Integer.parseInt(number) + 1) == 1) {
buffer.append("首页");
} else {
buffer.append("<a href=\"" + path + "?number=0\">首页</a>");
}
buffer.append(" ");
if ((Integer.parseInt(number) + 1) == 1) {
buffer.append("上一页");
} else {
buffer.append("<a href=\"" + path + "?number=" + (Integer.parseInt(number) - 1) + "\">上一页</a>");
}
buffer.append(" ");
if (maxPage <= (Integer.parseInt(number) + 1)) {
// 准备添加数据
@RequestMapping("createAdmin.action")
public String createAdmin() {
return "admin/addadmin";
}
// 添加数据
@RequestMapping("addAdmin.action")
public String addAdmin(Admin admin) {
admin.setAddtime(VeDate.getStringDateShort());
this.adminService.insertAdmin(admin);
return "redirect:/admin/createAdmin.action";
}
// 通过主键删除数据
@RequestMapping("deleteAdmin.action")
public String deleteAdmin(String id) {
this.adminService.deleteAdmin(id);
return "redirect:/admin/getAllAdmin.action";
}
// 批量删除数据
@RequestMapping("deleteAdminByIds.action")
public String deleteAdminByIds() {
String[] ids = this.getRequest().getParameterValues("adminid");
for (String adminid : ids) {
this.adminService.deleteAdmin(adminid);
}
return "redirect:/admin/getAllAdmin.action";
}
// 更新数据
@RequestMapping("updateAdmin.action")
public String updateAdmin(Admin admin) {
this.adminService.updateAdmin(admin);
return "redirect:/admin/getAllAdmin.action";
}
// 显示全部数据
@RequestMapping("getAllAdmin.action")
public String getAllAdmin(String number) {
List<Admin> adminList = this.adminService.getAllAdmin();
}
String userid = (String) this.getSession().getAttribute("userid");
Orders orders = new Orders();
orders.setUsersid(userid);
PageHelper.getPage("orders", this.ordersService.getOrdersByCond(orders), "index/showOrders.action", 10, number,
this.getRequest());
return "users/orderlist";
}
// 准备付款
@RequestMapping("prePay.action")
public String prePay(String id) {
this.front();
if (this.getSession().getAttribute("userid") == null) {
return "redirect:/index/preLogin.action";
}
this.getRequest().setAttribute("id", id);
return "users/pay";
}
// 付款
@RequestMapping("pay.action")
public String pay(String id) {
this.front();
if (this.getSession().getAttribute("userid") == null) {
return "redirect:/index/preLogin.action";
}
Orders orders = this.ordersService.getOrdersById(this.getRequest().getParameter("id"));
orders.setStatus("已付款");
this.ordersService.updateOrders(orders);
return "redirect:/index/showOrders.action";
}
//
@RequestMapping("cancle.action")
public String cancle(String id) {
this.front();
if (this.getSession().getAttribute("userid") == null) {
return "redirect:/index/preLogin.action";
}
Orders orders = this.ordersService.getOrdersById(this.getRequest().getParameter("id"));
orders.setStatus("已退票");
this.ordersService.updateOrders(orders);
return "redirect:/index/showOrders.action";
}
// 确认收货
@Resource
private BbsService bbsService;
@Autowired
@Resource
private RebbsService rebbsService;
// 公共方法 提供公共查询数据
private void front() {
this.getRequest().setAttribute("title", "陕西历史博物馆票务管理系统");
List<Venue> hotList = this.venueService.getHotVenue();
this.getRequest().setAttribute("hotList", hotList);
}
// 首页显示
@RequestMapping("index.action")
public String index() {
this.front();
List<Venue> goodsList = this.venueService.getHotVenue();
this.getRequest().setAttribute("goodsList", goodsList);
return "users/index";
}
// 全部产品
@RequestMapping("all.action")
public String all(String number) {
this.front();
PageHelper.getPage("goods", this.venueService.getAllVenue(), "index/all.action", 9, number, this.getRequest());
return "users/list";
}
// 查询商品
@RequestMapping("query.action")
public String query(String name, String number) {
this.front();
Venue venue = new Venue();
venue.setVenuename(name);
PageHelper.getPage("goods", this.venueService.getVenueByLike(venue), "index/query.action", 9, number,
this.getRequest());
return "users/list";
}
// 商品详情
@RequestMapping("detail.action")
public String detail(String id) {
this.front();
Venue venue = this.venueService.getVenueById(id);
venue.setHits("" + (Integer.parseInt(venue.getHits()) + 1));
this.venueService.updateVenue(venue);
//定义为控制器
@Controller
// 设置路径
@RequestMapping(value = "/rebbs", produces = "text/plain;charset=utf-8")
public class RebbsAction extends BaseAction {
// 注入Service 由于标签的存在 所以不需要getter setter
@Autowired
@Resource
private RebbsService rebbsService;
@Autowired
@Resource
private UsersService usersService;
@Autowired
@Resource
private BbsService bbsService;
// 准备添加数据
@RequestMapping("createRebbs.action")
public String createRebbs() {
List<Users> usersList = this.usersService.getAllUsers();
this.getRequest().setAttribute("usersList", usersList);
List<Bbs> bbsList = this.bbsService.getAllBbs();
this.getRequest().setAttribute("bbsList", bbsList);
return "admin/addrebbs";
}
// 添加数据
@RequestMapping("addRebbs.action")
public String addRebbs(Rebbs rebbs) {
this.rebbsService.insertRebbs(rebbs);
return "redirect:/rebbs/createRebbs.action";
}
// 通过主键删除数据
@RequestMapping("deleteRebbs.action")
public String deleteRebbs(String id) {
this.rebbsService.deleteRebbs(id);
return "redirect:/rebbs/getAllRebbs.action";
List<Venue> venueList = this.venueService.getAllVenue();
this.getRequest().setAttribute("venueList", venueList);
List<Ticket> ticketList = this.ticketService.getAllTicket();
this.getRequest().setAttribute("ticketList", ticketList);
return "admin/additems";
}
// 添加数据
@RequestMapping("addItems.action")
public String addItems(Items items) {
this.itemsService.insertItems(items);
return "redirect:/items/createItems.action";
}
// 通过主键删除数据
@RequestMapping("deleteItems.action")
public String deleteItems(String id) {
this.itemsService.deleteItems(id);
return "redirect:/items/getAllItems.action";
}
// 批量删除数据
@RequestMapping("deleteItemsByIds.action")
public String deleteItemsByIds() {
String[] ids = this.getRequest().getParameterValues("itemsid");
for (String itemsid : ids) {
this.itemsService.deleteItems(itemsid);
}
return "redirect:/items/getAllItems.action";
}
// 更新数据
@RequestMapping("updateItems.action")
public String updateItems(Items items) {
this.itemsService.updateItems(items);
return "redirect:/items/getAllItems.action";
}
// 显示全部数据
@RequestMapping("getAllItems.action")
public String getAllItems(String number) {
List<Items> itemsList = this.itemsService.getAllItems();
PageHelper.getPage(itemsList, "items", null, null, 10, number, this.getRequest(), null);
return "admin/listitems";
}
// 按条件查询数据 (模糊查询)
@RequestMapping("queryItemsByCond.action")
public String queryItemsByCond(String cond, String name, String number) {
Items items = new Items();
if (cond != null) {
if ("ordercode".equals(cond)) {
items.setOrdercode(name);
/**
* Action 基类
*/
@Controller
public class BaseAction {
/* 日志 */
protected final Log log = LogFactory.getLog(getClass());
/* 获取基本环境 */
public Map<String, String[]> getParameters() {// 封装为Map的requestParameters
ServletRequestAttributes attrs = (ServletRequestAttributes) RequestContextHolder.getRequestAttributes();
return attrs.getRequest().getParameterMap();
}
public HttpServletRequest getRequest() {
ServletRequestAttributes attrs = (ServletRequestAttributes) RequestContextHolder.getRequestAttributes();
return attrs.getRequest();
}
public HttpSession getSession() {
HttpSession session = null;
try {
session = this.getRequest().getSession();
} catch (Exception e) {
}
return session;
}
/* 向客户端输出操作成功或失败信息 */
public void writeJsonResponse(String success) throws IOException, JSONException {
ServletRequestAttributes attrs = (ServletRequestAttributes) RequestContextHolder.getRequestAttributes();
HttpServletResponse response = attrs.getResponse();
// 注入Service 由于标签的存在 所以不需要getter setter
@Autowired
@Resource
private TicketService ticketService;
@Autowired
@Resource
private VenueService venueService;
// 准备添加数据
@RequestMapping("createTicket.action")
public String createTicket() {
List<Venue> venueList = this.venueService.getAllVenue();
this.getRequest().setAttribute("venueList", venueList);
return "admin/addticket";
}
// 添加数据
@RequestMapping("addTicket.action")
public String addTicket(Ticket ticket) {
ticket.setAddtime(VeDate.getStringDateShort());
this.ticketService.insertTicket(ticket);
return "redirect:/ticket/createTicket.action";
}
// 通过主键删除数据
@RequestMapping("deleteTicket.action")
public String deleteTicket(String id) {
this.ticketService.deleteTicket(id);
return "redirect:/ticket/getAllTicket.action";
}
// 批量删除数据
@RequestMapping("deleteTicketByIds.action")
public String deleteTicketByIds() {
String[] ids = this.getRequest().getParameterValues("ticketid");
for (String ticketid : ids) {
this.ticketService.deleteTicket(ticketid);
}
return "redirect:/ticket/getAllTicket.action";
}
// 更新数据
@RequestMapping("updateTicket.action")
}
//定义为控制器
@Controller
// 设置路径
@RequestMapping(value = "/article", produces = "text/plain;charset=utf-8")
public class ArticleAction extends BaseAction {
// 注入Service 由于标签的存在 所以不需要getter setter
@Autowired
@Resource
private ArticleService articleService;
// 准备添加数据
@RequestMapping("createArticle.action")
public String createArticle() {
return "admin/addarticle";
}
// 添加数据
@RequestMapping("addArticle.action")
public String addArticle(Article article) {
article.setAddtime(VeDate.getStringDateShort());
article.setHits("0");
this.articleService.insertArticle(article);
return "redirect:/article/createArticle.action";
}
// 通过主键删除数据
@RequestMapping("deleteArticle.action")
public String deleteArticle(String id) {
this.articleService.deleteArticle(id);
return "redirect:/article/getAllArticle.action";
}
// 批量删除数据
@RequestMapping("deleteArticleByIds.action")
public String deleteArticleByIds() {
String[] ids = this.getRequest().getParameterValues("articleid");
for (String articleid : ids) {
this.articleService.deleteArticle(articleid);
}
return "redirect:/venue/getAllVenue.action";
}
// 显示全部数据
@RequestMapping("getAllVenue.action")
public String getAllVenue(String number) {
List<Venue> venueList = this.venueService.getAllVenue();
PageHelper.getPage(venueList, "venue", null, null, 10, number, this.getRequest(), null);
return "admin/listvenue";
}
// 按条件查询数据 (模糊查询)
@RequestMapping("queryVenueByCond.action")
public String queryVenueByCond(String cond, String name, String number) {
Venue venue = new Venue();
if (cond != null) {
if ("venuename".equals(cond)) {
venue.setVenuename(name);
}
if ("image".equals(cond)) {
venue.setImage(name);
}
if ("contents".equals(cond)) {
venue.setContents(name);
}
if ("hits".equals(cond)) {
venue.setHits(name);
}
}
List<String> nameList = new ArrayList<String>();
List<String> valueList = new ArrayList<String>();
nameList.add(cond);
valueList.add(name);
PageHelper.getPage(this.venueService.getVenueByLike(venue), "venue", nameList, valueList, 10, number, this.getRequest(), "query");
name = null;
cond = null;
return "admin/queryvenue";
}
// 按主键查询数据
@RequestMapping("getVenueById.action")
public String getVenueById(String id) {
Venue venue = this.venueService.getVenueById(id);
// 按条件查询数据 (模糊查询)
@RequestMapping("queryVenueByCond.action")
public String queryVenueByCond(String cond, String name, String number) {
Venue venue = new Venue();
if (cond != null) {
if ("venuename".equals(cond)) {
venue.setVenuename(name);
}
if ("image".equals(cond)) {
venue.setImage(name);
}
if ("contents".equals(cond)) {
venue.setContents(name);
}
if ("hits".equals(cond)) {
venue.setHits(name);
}
}
List<String> nameList = new ArrayList<String>();
List<String> valueList = new ArrayList<String>();
nameList.add(cond);
valueList.add(name);
PageHelper.getPage(this.venueService.getVenueByLike(venue), "venue", nameList, valueList, 10, number, this.getRequest(), "query");
name = null;
cond = null;
return "admin/queryvenue";
}
// 按主键查询数据
@RequestMapping("getVenueById.action")
public String getVenueById(String id) {
Venue venue = this.venueService.getVenueById(id);
this.getRequest().setAttribute("venue", venue);
return "admin/editvenue";
}
public VenueService getVenueService() {
return venueService;
}
public void setVenueService(VenueService venueService) {
this.venueService = venueService;
}
}