admin 管理员组文章数量: 1184232
基于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 登录
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")
public String updateOrders(Orders orders) {
this.ordersService.updateOrders(orders);
return "redirect:/orders/getAllOrders.action";
}
// 显示全部数据
@RequestMapping("getAllOrders.action")
public String getAllOrders(String number) {
List<Orders> ordersList = this.ordersService.getAllOrders();
PageHelper.getPage(ordersList, "orders", null, null, 10, number, this.getRequest(), null);
return "admin/listorders";
}
// 按条件查询数据 (模糊查询)
@RequestMapping("queryOrdersByCond.action")
public String queryOrdersByCond(String cond, String name, String number) {
Orders orders = new Orders();
if (cond != null) {
if ("ordercode".equals(cond)) {
orders.setOrdercode(name);
}
if ("usersid".equals(cond)) {
orders.setUsersid(name);
}
if ("total".equals(cond)) {
orders.setTotal(name);
}
if ("status".equals(cond)) {
orders.setStatus(name);
}
private VenueService venueService;
// 准备添加数据
@RequestMapping("createVenue.action")
public String createVenue() {
return "admin/addvenue";
}
// 添加数据
@RequestMapping("addVenue.action")
public String addVenue(Venue venue) {
venue.setHits("0");
this.venueService.insertVenue(venue);
return "redirect:/venue/createVenue.action";
}
// 通过主键删除数据
@RequestMapping("deleteVenue.action")
public String deleteVenue(String id) {
this.venueService.deleteVenue(id);
return "redirect:/venue/getAllVenue.action";
}
// 批量删除数据
@RequestMapping("deleteVenueByIds.action")
public String deleteVenueByIds() {
String[] ids = this.getRequest().getParameterValues("venueid");
for (String venueid : ids) {
this.venueService.deleteVenue(venueid);
}
return "redirect:/venue/getAllVenue.action";
}
// 更新数据
@RequestMapping("updateVenue.action")
public String updateVenue(Venue venue) {
this.venueService.updateVenue(venue);
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")
//定义为控制器
@Controller
// 设置路径
@RequestMapping(value = "/bbs", produces = "text/plain;charset=utf-8")
public class BbsAction extends BaseAction {
// 注入Service 由于标签的存在 所以不需要getter setter
@Autowired
@Resource
private BbsService bbsService;
@Autowired
@Resource
private UsersService usersService;
// 准备添加数据
@RequestMapping("createBbs.action")
public String createBbs() {
List<Users> usersList = this.usersService.getAllUsers();
this.getRequest().setAttribute("usersList", usersList);
return "admin/addbbs";
}
// 添加数据
@RequestMapping("addBbs.action")
public String addBbs(Bbs bbs) {
this.bbsService.insertBbs(bbs);
return "redirect:/bbs/createBbs.action";
}
// 通过主键删除数据
@RequestMapping("deleteBbs.action")
public String deleteBbs(String id) {
this.bbsService.deleteBbs(id);
return "redirect:/bbs/getAllBbs.action";
}
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)) {
buffer.append("下一页");
} else {
buffer.append("<a href=\"" + path + "?number=" + (Integer.parseInt(number) + 1) + "\">下一页</a>");
}
buffer.append(" ");
if (maxPage <= (Integer.parseInt(number) + 1)) {
buffer.append("尾页");
} else {
buffer.append("<a href=\"" + path + "?number=" + (maxPage - 1) + "\">尾页</a>");
}
String html = buffer.toString();
request.setAttribute("html", html);
request.setAttribute(name + "List", objList);
}
}
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)) {
buffer.append("下一页");
} else {
buffer.append("<a href=\"" + path + "?number=" + (Integer.parseInt(number) + 1) + "\">下一页</a>");
}
buffer.append(" ");
if (maxPage <= (Integer.parseInt(number) + 1)) {
buffer.append("尾页");
} else {
buffer.append("<a href=\"" + path + "?number=" + (maxPage - 1) + "\">尾页</a>");
}
String html = buffer.toString();
request.setAttribute("html", html);
request.setAttribute(name + "List", objList);
}
}
// 设置路径
@RequestMapping(value = "/cart", produces = "text/plain;charset=utf-8")
public class CartAction extends BaseAction {
// 注入Service 由于标签的存在 所以不需要getter setter
@Autowired
@Resource
private CartService cartService;
@Autowired
@Resource
private UsersService usersService;
@Autowired
@Resource
private VenueService venueService;
@Autowired
@Resource
private TicketService ticketService;
// 准备添加数据
@RequestMapping("createCart.action")
public String createCart() {
List<Users> usersList = this.usersService.getAllUsers();
this.getRequest().setAttribute("usersList", usersList);
List<Venue> venueList = this.venueService.getAllVenue();
this.getRequest().setAttribute("venueList", venueList);
List<Ticket> ticketList = this.ticketService.getAllTicket();
this.getRequest().setAttribute("ticketList", ticketList);
return "admin/addcart";
}
// 添加数据
@RequestMapping("addCart.action")
public String addCart(Cart cart) {
this.cartService.insertCart(cart);
return "redirect:/cart/createCart.action";
}
// 通过主键删除数据
@RequestMapping("deleteCart.action")
public String deleteCart(String id) {
this.cartService.deleteCart(id);
return "redirect:/cart/getAllCart.action";
}
// 批量删除数据
@RequestMapping("deleteCartByIds.action")
@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();
PageHelper.getPage(adminList, "admin", null, null, 10, number, this.getRequest(), null);
return "admin/listadmin";
}
// 按条件查询数据 (模糊查询)
@RequestMapping("queryAdminByCond.action")
public String queryAdminByCond(String cond, String name, String number) {
Admin admin = new Admin();
if (cond != null) {
this.ordersService = ordersService;
}
}
public class PageHelper {
public static void getPage(List<?> list, String name, List<String> nameList, List<String> valueList, int pageSize, String number,
HttpServletRequest request, String method) {
StringBuffer buffer = new StringBuffer();
String name2 = name.substring(0, 1).toUpperCase() + name.substring(1);
String path = "";
String action = "getAll" + name2 + ".action";
if (method != null) {
action = "query" + name2 + "ByCond.action";
}
List<Object> objList = new ArrayList<Object>();
if (nameList != null && valueList != null) {
for (int i = 0; i < nameList.size(); i++) {
path += "&" + nameList.get(i) + "=" + valueList.get(i);
}
}
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;
return "admin/addusers";
}
// 添加数据
@RequestMapping("addUsers.action")
public String addUsers(Users users) {
this.usersService.insertUsers(users);
return "redirect:/users/createUsers.action";
}
// 通过主键删除数据
@RequestMapping("deleteUsers.action")
public String deleteUsers(String id) {
this.usersService.deleteUsers(id);
return "redirect:/users/getAllUsers.action";
}
// 批量删除数据
@RequestMapping("deleteUsersByIds.action")
public String deleteUsersByIds() {
String[] ids = this.getRequest().getParameterValues("usersid");
for (String usersid : ids) {
this.usersService.deleteUsers(usersid);
}
return "redirect:/users/getAllUsers.action";
}
// 更新数据
@RequestMapping("updateUsers.action")
public String updateUsers(Users users) {
this.usersService.updateUsers(users);
return "redirect:/users/getAllUsers.action";
}
// 显示全部数据
@RequestMapping("getAllUsers.action")
public String getAllUsers(String number) {
List<Users> usersList = this.usersService.getAllUsers();
PageHelper.getPage(usersList, "users", null, null, 10, number, this.getRequest(), null);
return "admin/listusers";
}
//定义为控制器
@Controller
// 设置路径
@RequestMapping(value = "/items", produces = "text/plain;charset=utf-8")
public class ItemsAction extends BaseAction {
// 注入Service 由于标签的存在 所以不需要getter setter
@Autowired
@Resource
private ItemsService itemsService;
@Autowired
@Resource
private VenueService venueService;
@Autowired
@Resource
private TicketService ticketService;
// 准备添加数据
@RequestMapping("createItems.action")
public String createItems() {
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);
}
// 取消订单
@RequestMapping("cancel.action")
public String cancel(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("orderdetail.action")
public String orderdetail(String id) {
this.front();
if (this.getSession().getAttribute("userid") == null) {
return "redirect:/index/preLogin.action";
}
Items details = new Items();
details.setOrdercode(id);
List<Items> detailsList = this.itemsService.getItemsByCond(details);
for(Items items:detailsList) {
items.setOrdercode(id);
}
this.getRequest().setAttribute("detailsList", detailsList);
return "users/orderdetail";
}
}
if ("price".equals(cond)) {
cart.setPrice(name);
}
if ("addtime".equals(cond)) {
cart.setAddtime(name);
}
}
List<String> nameList = new ArrayList<String>();
List<String> valueList = new ArrayList<String>();
nameList.add(cond);
valueList.add(name);
PageHelper.getPage(this.cartService.getCartByLike(cart), "cart", nameList, valueList, 10, number, this.getRequest(), "query");
name = null;
cond = null;
return "admin/querycart";
}
// 按主键查询数据
@RequestMapping("getCartById.action")
public String getCartById(String id) {
Cart cart = this.cartService.getCartById(id);
this.getRequest().setAttribute("cart", cart);
List<Users> usersList = this.usersService.getAllUsers();
this.getRequest().setAttribute("usersList", usersList);
List<Venue> venueList = this.venueService.getAllVenue();
this.getRequest().setAttribute("venueList", venueList);
List<Ticket> ticketList = this.ticketService.getAllTicket();
this.getRequest().setAttribute("ticketList", ticketList);
return "admin/editcart";
}
public CartService getCartService() {
return cartService;
}
public void setCartService(CartService cartService) {
this.cartService = cartService;
}
}
// 批量删除数据
@RequestMapping("deleteVenueByIds.action")
public String deleteVenueByIds() {
String[] ids = this.getRequest().getParameterValues("venueid");
for (String venueid : ids) {
this.venueService.deleteVenue(venueid);
}
return "redirect:/venue/getAllVenue.action";
}
// 更新数据
@RequestMapping("updateVenue.action")
public String updateVenue(Venue venue) {
this.venueService.updateVenue(venue);
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");
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;
}
}
//定义为控制器
@Controller
// 设置路径
@RequestMapping(value = "/bbs", produces = "text/plain;charset=utf-8")
public class BbsAction extends BaseAction {
// 注入Service 由于标签的存在 所以不需要getter setter
@Autowired
@Resource
private BbsService bbsService;
// 订单明细
@RequestMapping("orderdetail.action")
public String orderdetail(String id) {
this.front();
if (this.getSession().getAttribute("userid") == null) {
return "redirect:/index/preLogin.action";
}
Items details = new Items();
details.setOrdercode(id);
List<Items> detailsList = this.itemsService.getItemsByCond(details);
for(Items items:detailsList) {
items.setOrdercode(id);
}
this.getRequest().setAttribute("detailsList", detailsList);
return "users/orderdetail";
}
}
//定义为控制器
@Controller
// 设置路径
@RequestMapping(value = "/admin", produces = "text/plain;charset=utf-8")
public class AdminAction extends BaseAction {
// 注入Service 由于标签的存在 所以不需要getter setter
@Autowired
@Resource
private AdminService adminService;
// 管理员登录 1 验证用户名是否存在 2 验证密码是否正确
@RequestMapping("login.action")
public String login() {
String username = this.getRequest().getParameter("username");
@RequestMapping("chartbar.action")
@ResponseBody
public String chartbar() throws JSONException {
String start = this.getRequest().getParameter("start");
String end = this.getRequest().getParameter("end");
Map<String, Integer> map = new HashMap<String, Integer>();
List<Orders> ordersList = this.ordersService.getOrdersByTime(start, end);
for (Orders order : ordersList) {
System.out.println(map.get(order.getAddtime()));
Integer count = map.get(order.getAddtime());
if(count==null) {
map.put(order.getAddtime(), 1);
}else {
map.put(order.getAddtime(), count+1);
}
System.out.println(order.getAddtime());
}
JSONArray count = new JSONArray();
JSONArray day = new JSONArray(); // 存放名称
JSONObject json = new JSONObject();
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";
}
buffer.append("上一页");
} else {
buffer.append("<a href=\"" + path + "?number=" + (Integer.parseInt(number) - 1) + "\">上一页</a>");
}
buffer.append(" ");
if (maxPage <= (Integer.parseInt(number) + 1)) {
buffer.append("下一页");
} else {
buffer.append("<a href=\"" + path + "?number=" + (Integer.parseInt(number) + 1) + "\">下一页</a>");
}
buffer.append(" ");
if (maxPage <= (Integer.parseInt(number) + 1)) {
buffer.append("尾页");
} else {
buffer.append("<a href=\"" + path + "?number=" + (maxPage - 1) + "\">尾页</a>");
}
String html = buffer.toString();
request.setAttribute("html", html);
request.setAttribute(name + "List", objList);
}
}
//定义为控制器
@Controller
// 设置路径
@RequestMapping(value = "/cart", produces = "text/plain;charset=utf-8")
public class CartAction extends BaseAction {
// 注入Service 由于标签的存在 所以不需要getter setter
@Autowired
@Resource
private CartService cartService;
@Autowired
@Resource
private UsersService usersService;
//定义为控制器
@Controller
// 设置路径
@RequestMapping(value = "/cart", produces = "text/plain;charset=utf-8")
public class CartAction extends BaseAction {
// 注入Service 由于标签的存在 所以不需要getter setter
@Autowired
@Resource
private CartService cartService;
@Autowired
@Resource
private UsersService usersService;
@Autowired
@Resource
private VenueService venueService;
@Autowired
@Resource
private TicketService ticketService;
// 准备添加数据
@RequestMapping("createCart.action")
public String createCart() {
List<Users> usersList = this.usersService.getAllUsers();
this.getRequest().setAttribute("usersList", usersList);
List<Venue> venueList = this.venueService.getAllVenue();
this.getRequest().setAttribute("venueList", venueList);
List<Ticket> ticketList = this.ticketService.getAllTicket();
this.getRequest().setAttribute("ticketList", ticketList);
return "admin/addcart";
}
// 添加数据
@RequestMapping("addCart.action")
本文标签: 管理系统 博物馆 MySQL SSM JavaWeb
版权声明:本文标题:基于javaweb和mysql的ssm博物馆售票管理系统(java+ssm+jsp+jquery+ajax+mysql) 内容由网友自发贡献,该文观点仅代表作者本人, 转载请联系作者并注明出处:http://www.roclinux.cn/b/1759991653a3143499.html, 本站仅提供信息存储空间服务,不拥有所有权,不承担相关法律责任。如发现本站有涉嫌抄袭侵权/违法违规的内容,一经查实,本站将立刻删除。
发表评论