基于javaweb+mysql的jsp+servlet旅游管理系统(java+jsp+html5+bootstrap+servlet+mysql)

基于javaweb+mysql的jsp+servlet旅游管理系统(java+jsp+html5+bootstrap+servlet+mysql)

运行环境

Java≥8、MySQL≥5.7、Tomcat≥8

开发工具

eclipse/idea/myeclipse/sts等均可配置运行

适用

课程设计，大作业，毕业设计，项目练习，学习演示等

功能说明

基于javaweb+mysql的JSP+Servlet旅游管理系统(java+jsp+html5+bootstrap+servlet+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项目：否；

技术栈

HTML5+Ajax+CSS+JavaScript+BootStrap+jQuery+servlet+mysql

使用说明

1. 使用Navicat或者其它工具，在mysql中创建对应名称的数据库，并导入项目的sql文件； 2. 使用IDEA/Eclipse/MyEclipse导入项目，Eclipse/MyEclipse导入时，若为maven项目请选择maven; 若为maven项目，导入成功后请执行maven clean;maven install命令，然后运行； 3. 将项目中util/db.properties配置文件中的数据库配置改为自己的配置; 4. 运行项目，前台运行地址输入http://localhost:8080/travel 登录 后台运行地址输入http://localhost:8080/travel/admin 登录 管理员账号/密码：admin/admin

/**
 * Servlet implementation class BannerEdit
 */
@WebServlet("/admin/BannerEdit")
public class BannerEdit extends HttpServlet {
	private static final long serialVersionUID = 1L;
       
	BanOperator banOperator=new BanOperator();
    /**
     * @see HttpServlet#HttpServlet()
     */
    public BannerEdit() {
        super();
        // TODO Auto-generated constructor stub
    }

	/**
	 * @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)
	 */
	protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		// TODO Auto-generated method stub
		doPost(request, response);
	}

	/**
	 * @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)
	 */
	protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		// TODO Auto-generated method stub
		request.setCharacterEncoding("UTF-8");
		response.setContentType("text/html;charset=UTF-8");
		PrintWriter out = response.getWriter();
		
		// 上下文
		PageContext pageContext = JspFactory.getDefaultFactory().getPageContext(this, request, response, null, true, 8*1024, true);
	
		// 上传到目录个数
		int count = 0;
		
		int banid=0;
		String banname=null;
		String bantitle=null;
		String banpath=null;
		Banner banner=null;

				out.flush();// 清空缓存
				out.println("<script>");// 输出script标签
				out.println("alert('删除成功!');");// js语句：输出alert语句
				out.println("history.back();");// js语句：输出网页回退语句
				out.println("</script>");// 输出script结尾标签
			}
			else {				 
				System.out.println("删除失败，文件不存在！");
				out.flush();// 清空缓存
				out.println("<script>");// 输出script标签
				out.println("alert('删除失败，文件不存在！');");// js语句：输出alert语句
				out.println("history.back();");// js语句：输出网页回退语句
				out.println("</script>");// 输出script结尾标签
			}
		}
		out.close();
	}

	/**
	 * @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse
	 *      response)
	 */
	protected void doPost(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {
		// TODO Auto-generated method stub
		doGet(request, response);
	}

}
package com.trav.cms.scen.service;

/**
 * Servlet implementation class ScenList
 */
@WebServlet("/admin/ScenList")
public class ScenList extends HttpServlet {
	private static final long serialVersionUID = 1L;
	ScenOperator scenOperator = new ScenOperator();

public class ScenAdd extends HttpServlet {
	private static final long serialVersionUID = 1L;
	ScenOperator scenOperator=new ScenOperator();
	/**
	 * @see HttpServlet#HttpServlet()
	 */
	public ScenAdd() {
		super();
		// TODO Auto-generated constructor stub
	}

	/**
	 * @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse
	 *      response)
	 */
	protected void doGet(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {
		// TODO Auto-generated method stub

		request.setCharacterEncoding("UTF-8");
		response.setContentType("text/html;charset=UTF-8");
		PrintWriter out = response.getWriter();
		// 上下文
		PageContext pageContext = JspFactory.getDefaultFactory().getPageContext(this, request, response, null, true,
				8 * 1024, true);
		// 上传到目录个数
		int count = 0;
		String scenname = null;// 景点名
		String scenintro = null;// 介绍
		String scenlevel = null;// 星级
		String scentitle = null;// 标题
		String scenfeature = null;// 特色
		String scentraff = null;// 交通
		String scenmap = null;// 地图
		String picpath = null;// 图片
		String scenadd = null;// 地址
		String scennameen = null;// 英文名
		int scenorder=0;
		String scenurl=null;
		// 景点对象
		Scen scen=null;
		System.out.println("景点图片上传");
		// 新建一个SmartUpload对象
		SmartUpload su = new SmartUpload();
		// 上传初始化
		su.initialize(pageContext);
		// 设置上传限制

				String[] userinfo={username,Integer.toString(user.getUser_id())};			
				// 绑定数据
				session.setAttribute("userinfo", userinfo);
				//session.setAttribute("userid", user.getUser_id());
				// 设置失效时间 5分钟
				session.setMaxInactiveInterval(300);
				// 做转发
				request.setAttribute("user", user);
				request.getRequestDispatcher("index.jsp").forward(request, response);
			}

			else {
				System.out.println("-*-*-登录失败！密码不正确!");
				System.out.println("用户名：" + username);
				System.out.println("密    码：" + password);
				 //response.sendRedirect("login.jsp");
				 out.flush();//清空缓存
		         out.println("<script>");//输出script标签
		         out.println("alert('-*-*-登录失败！密码不正确！');");//js语句：输出alert语句
		         out.println("history.back();");//js语句：输出网页回退语句
		         out.println("</script>");//输出script结尾标签

			}
		}

		else {
			System.out.println("-*-*-登录失败！用户名不存在!");
			System.out.println("用户名：" + username);
			System.out.println("密    码：" + password);
			 //response.sendRedirect("login.jsp");
			 out.flush();//清空缓存
	         out.println("<script>");//输出script标签
	         out.println("alert('-*-*-登录失败！用户名不存在!');");//js语句：输出alert语句
	         out.println("history.back();");//js语句：输出网页回退语句
	         out.println("</script>");//输出script结尾标签
			// 做重定向到登录页面
			//response.sendRedirect("login.jsp");
		}
		out.close();

	}

	/**
	 * @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse

		} catch (SQLException e) {
			// TODO Auto-generated catch block
			System.out.println("不允许上传此类文件");
			e.printStackTrace();
		}
		// 上传文件
		try {
			su.upload();
		} catch (SmartUploadException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		// 将上传的文件全部保存到指定目录
		// 图片轮播的路径
		try {
			count = su.save("/image/scen");

		} catch (SmartUploadException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		System.out.println(count + "个文件上传成功！");

		// 利用Request对象获取参数之值

		// 逐一提取上传文件信息，同时可保存文件
		for (int i = 0; i < su.getFiles().getCount(); i++) {
			File file = su.getFiles().getFile(i);
			// 若文件不存在则继续
			if (file.isMissing()) {
				continue;
			}
			scenname 	= su.getRequest().getParameter("scen-name");
			scenintro	= su.getRequest().getParameter("scen-intro");
			scenlevel	= su.getRequest().getParameter("scen-level");
			scentitle	= su.getRequest().getParameter("scen-title");
			scenfeature	= su.getRequest().getParameter("scen-feature");
			scentraff	= su.getRequest().getParameter("scen-traff");
			scenmap		= su.getRequest().getParameter("scen-map");
			picpath		= "image/scen/" + file.getFileName();
			scenadd		= su.getRequest().getParameter("scen-add");
			scennameen	= su.getRequest().getParameter("scen-name-en");
			scenorder=Integer.parseInt(su.getRequest().getParameter("scen-order"));
			scenurl=su.getRequest().getParameter("scen-url");
			
			scen = new Scen(scenname, scenintro, scenlevel, scentitle, scenfeature, scentraff, scenmap, picpath, scenadd, scennameen, scenorder, scenurl);

		// 上下文
		PageContext pageContext = JspFactory.getDefaultFactory().getPageContext(this, request, response, null, true, 8*1024, true);
	
		// 上传到目录个数
		int count = 0;
		
		int banid=0;
		String banname=null;
		String bantitle=null;
		String banpath=null;
		Banner banner=null;
		
		System.out.println("轮播图片编辑");
		// 新建一个SmartUpload对象
		SmartUpload su = new SmartUpload();
		// 上传初始化
		su.initialize(pageContext);
		
		// 设置上传限制
		// 1.限制每个上传文件的最大长度为10MB
		su.setMaxFileSize(10 * 1024 * 1024);
		// 2.限制总上传文件的长度
		su.setTotalMaxFileSize(30 * 1024 * 1024);
		// 3.设定允许上传的文件
		su.setAllowedFilesList("gif,jpg,png,jpeg,bmp,ico");
		// 4.设定禁止上传的文件
		try {
			su.setDeniedFilesList("exe,bat,jsp,htm,html,,");
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			System.out.println("不允许上传此类文件");
			e.printStackTrace();	
		}
		
		
		// 上传文件
				try {
					su.upload();
				} catch (SmartUploadException e) {
					// TODO Auto-generated catch block
					e.printStackTrace();
				}
				
				// 将上传的文件全部保存到指定目录
				// 图片轮播的路径
				
				try {
					count = su.save("/image/banner");		
					

		int count = 0;
		
		int scenid=0;
		String scenname = null;// 名表横
		String scenintro = null;// 介绍
		String scenlevel = null;// 星级
		String scentitle = null;// 标题
		String scenfeature = null;// 特色
		String scentraff = null;// 交通
		String scenmap = null;// 地图
		String picpath = null;// 图片
		String scenadd = null;// 地址
		String scennameen = null;// 英文名
		int scenorder=0;
		String scenurl=null;
		// 景点对象
		Scen scen=null;
		
		System.out.println("景点图片上传");
		// 新建一个SmartUpload对象
		SmartUpload su = new SmartUpload();
		// 上传初始化
		su.initialize(pageContext);

		// 设置上传限制
		// 1.限制每个上传文件的最大长度为10MB
		su.setMaxFileSize(10 * 1024 * 1024);
		// 2.限制总上传文件的长度
		su.setTotalMaxFileSize(30 * 1024 * 1024);
		// 3.设定允许上传的文件
		su.setAllowedFilesList("gif,jpg,png,jpeg,bmp,ico");
		// 4.设定禁止上传的文件
		try {
			su.setDeniedFilesList("exe,bat,jsp,htm,html,,");
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			System.out.println("不允许上传此类文件");
			e.printStackTrace();
		}

		// 上传文件
		try {
			su.upload();
		} catch (SmartUploadException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}

		// 将上传的文件全部保存到指定目录

				out.flush();// 清空缓存
				out.println("<script>");// 输出script标签
				out.println("alert('资讯图片上传成功!');");// js语句：输出alert语句
				out.println("history.back();");// js语句：输出网页回退语句
				out.println("</script>");// 输出script结尾标签
/*				
				out.println("景点上传成功");
				out.println("<br/>图片名：" + su.getRequest().getParameter("scen-name") + "<br/><br/>");
				out.println("<br/>标题名：" + su.getRequest().getParameter("scen-title") + "<br/><br/>");
				out.println("<br/>标题名：" + "image/scen/" + file.getFileName() + "<br/><br/>");
				

				// 显示当前文件信息

				out.println("<TABLE BORDER=1>");
				out.println("<TR><TD>表单项名(FieldName)</TD><TD>" + file.getFieldName() + "</TD></TR>");
				out.println("<TR><TD>文件长度(Size)</TD><TD>" + file.getSize() + "</TD></TR>");
				out.println("<TR><TD>文件名(FileName)</TD><TD>" + file.getFileName() + "</TD></TR>");
				out.println("<TR><TD>文件扩展名(FileExt)</TD><TD>" + file.getFileExt() + "</TD></TR>");
				out.println("<TR><TD>文件全名(FilePathName)</TD><TD>" + file.getFilePathName() + "</TD></TR>");
				out.println("</TABLE><BR/>");*/
			}

			/*
			 * // 将文件另存为 try { file.saveAs("/image/banner" + file.getFileName(),
			 * SmartUpload.SAVE_VIRTUAL); file.saveAs("E:/Web//" +
			 * file.getFileName(), SmartUpload.SAVE_PHYSICAL); } catch
			 * (SmartUploadException e) { // TODO Auto-generated catch block
			 * e.printStackTrace(); }
			 */

		}
		
		
		
	}

	/**
	 * @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)
	 */
	protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		// TODO Auto-generated method stub
		doGet(request, response);

		String info_txt = null;
		String info_tag = null;
		String info_pic = null;
		String info_url = null;
		int info_order = 0;

		// 资讯实体对象
		Info info = null;
		
		System.out.println("资讯图片上传--/admin/InfoAdd");
		// 新建一个SmartUpload对象
		SmartUpload su = new SmartUpload();
		// 上传初始化
		su.initialize(pageContext);

		// 设置上传限制
		// 1.限制每个上传文件的最大长度为10MB
		su.setMaxFileSize(10 * 1024 * 1024);
		// 2.限制总上传文件的长度
		su.setTotalMaxFileSize(30 * 1024 * 1024);
		// 3.设定允许上传的文件
		su.setAllowedFilesList("gif,jpg,png,jpeg,bmp,ico");
		// 4.设定禁止上传的文件
		try {
			su.setDeniedFilesList("exe,bat,jsp,htm,html,,");
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			System.out.println("不允许上传此类文件");
			e.printStackTrace();
		}

		// 上传文件
		try {
			su.upload();
		} catch (SmartUploadException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}

		// 将上传的文件全部保存到指定目录
		// 图片轮播的路径

		SmartUpload su = new SmartUpload();
		// 上传初始化
		su.initialize(pageContext);

		// 设置上传限制
		// 1.限制每个上传文件的最大长度为10MB
		su.setMaxFileSize(10 * 1024 * 1024);
		// 2.限制总上传文件的长度
		su.setTotalMaxFileSize(30 * 1024 * 1024);
		// 3.设定允许上传的文件
		su.setAllowedFilesList("gif,jpg,png,jpeg,bmp,ico");
		// 4.设定禁止上传的文件
		try {
			su.setDeniedFilesList("exe,bat,jsp,htm,html,,");
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			System.out.println("不允许上传此类文件");
			e.printStackTrace();
		}

		// 上传文件
		try {
			su.upload();
		} catch (SmartUploadException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}

		// 将上传的文件全部保存到指定目录
		// 图片轮播的路径

		try {
			count = su.save("/image/banner");

		} catch (SmartUploadException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		System.out.println(count + "个文件上传成功！");

		// 利用Request对象获取参数之值

/**
 * Servlet implementation class ScenShow
 */
@WebServlet("/ScenShow")
public class ScenShow extends HttpServlet {
	private static final long serialVersionUID = 1L;
	ScenOperator scenOperator = new ScenOperator();

	/**
	 * @see HttpServlet#HttpServlet()
	 */
	public ScenShow() {
		super();
		// TODO Auto-generated constructor stub
	}

	/**
	 * @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse
	 *      response)
	 */
	protected void doGet(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {
		// TODO Auto-generated method stub

		request.setCharacterEncoding("UTF-8");
		response.setContentType("text/html;charset=UTF-8");
		PrintWriter out = response.getWriter();
		System.out.println("*--------------------------------------------------*");
		System.out.println("*---景点图----ScenShow");

		int offset = Integer.parseInt(request.getParameter("offset"));
		int size = Integer.parseInt(request.getParameter("size"));
		
		System.out.println("offset--"+offset+",size---"+size);
		// Json数组
		JSONArray scenMore = new JSONArray();

		try {
			List<Scen> list = scenOperator.listMore(offset, size);

			for (int i = 0; i < list.size(); i++) {
				// Json对象
				JSONObject json = new JSONObject();

				// 查询结果集
				Scen scen = list.get(i);

				/*
				 * json.put("picname", banner.getBanname());

				out.println("<TR><TD>文件扩展名(FileExt)</TD><TD>" + file.getFileExt() + "</TD></TR>");
				out.println("<TR><TD>文件全名(FilePathName)</TD><TD>" + file.getFilePathName() + "</TD></TR>");
				out.println("</TABLE><BR/>");*/
			}

			/*
			 * // 将文件另存为 try { file.saveAs("/image/banner" + file.getFileName(),
			 * SmartUpload.SAVE_VIRTUAL); file.saveAs("E:/Web//" +
			 * file.getFileName(), SmartUpload.SAVE_PHYSICAL); } catch
			 * (SmartUploadException e) { // TODO Auto-generated catch block
			 * e.printStackTrace(); }
			 */

		}
		
		
		
	}

	/**
	 * @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)
	 */
	protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		// TODO Auto-generated method stub
		doGet(request, response);
	}

}
package com.trav.cms.info.service;

/**
 * Servlet implementation class InfoEdit
 */
@WebServlet("/admin/InfoEdit")
public class InfoEdit extends HttpServlet {
	private static final long serialVersionUID = 1L;

			for (int i = 0; i < list.size(); i++) {
				// Json对象	
				JSONObject json=new JSONObject();

				// 查询结果集
				Scen scen = list.get(i);
				//讲遍历对象的值分别放进json对象
				json.put("scenid", scen.getScenid());
				json.put("scenname", scen.getScenname());
				json.put("scenlevel",scen.getScenlevel());
				json.put("scentitle", scen.getScentitle());
				json.put("scenadd", scen.getScenadd());
				json.put("scenurl", scen.getScenurl());
				json.put("scenpic", scen.getPicpath());
				json.put("scenfeature", scen.getScenfeature());
				// 将Json对象放入数组
				scenJson.add(json);
			}

			// 将json数组传到页面
			out.print(scenJson);
		} catch (Exception e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}

		out.close();
	}

	/**
	 * @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)
	 */
	protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		// TODO Auto-generated method stub
		doGet(request, response);
	}

}
package com.trav.cms.scen.service;

/**
 * Servlet implementation class ScenList
 */
@WebServlet("/admin/ScenList")
public class ScenList extends HttpServlet {
	private static final long serialVersionUID = 1L;
	ScenOperator scenOperator = new ScenOperator();

	/**
	 * @see HttpServlet#HttpServlet()
	 */
	public ScenList() {
		super();
		// TODO Auto-generated constructor stub
	}

	/**
	 * @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse
	 *      response)
	 */
	protected void doGet(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {
		// TODO Auto-generated method stub

		request.setCharacterEncoding("UTF-8");
		response.setContentType("text/html;charset=UTF-8");
		PrintWriter out = response.getWriter();
		System.out.println("*--------------------------------------------------*");
		System.out.println("*---景点图----ScenList");

		int offset = Integer.parseInt(request.getParameter("offset"));
		int size = Integer.parseInt(request.getParameter("size"));
		
		System.out.println("offset--"+offset+",size---"+size);
		// Json数组
		JSONArray scenMore = new JSONArray();
		try {
			List<Scen> list = scenOperator.listMore(offset, size);

			for (int i = 0; i < list.size(); i++) {

		try {
			//得到模糊查询的结果集
			List<Scen> list = scenOperator.findScenByName(scenname);

			//遍历该集合
			for (int i = 0; i < list.size(); i++) {
				// Json对象	
				JSONObject json=new JSONObject();

				// 查询结果集
				Scen scen = list.get(i);
				//讲遍历对象的值分别放进json对象
				json.put("scenid", scen.getScenid());
				json.put("scenname", scen.getScenname());
				json.put("scenlevel",scen.getScenlevel());
				json.put("scentitle", scen.getScentitle());
				json.put("scenadd", scen.getScenadd());
				json.put("scenurl", scen.getScenurl());
				json.put("scenpic", scen.getPicpath());
				json.put("scenfeature", scen.getScenfeature());
				// 将Json对象放入数组
				scenJson.add(json);
			}

			// 将json数组传到页面
			out.print(scenJson);
		} catch (Exception e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}

		out.close();
	}

	/**
	 * @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)
	 */
	protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		// TODO Auto-generated method stub
		doGet(request, response);
	}

}
package com.trav.cms.scen.service;

 

/**
 * Servlet implementation class InfoAdd
 */
@WebServlet("/admin/InfoAdd")
public class InfoAdd extends HttpServlet {
	private static final long serialVersionUID = 1L;
       InfoOperator infoOperator=new InfoOperator();
    /**
     * @see HttpServlet#HttpServlet()
     */
    public InfoAdd() {
        super();
        // TODO Auto-generated constructor stub
    }

	/**
	 * @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)
	 */
	protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		// TODO Auto-generated method stub

		request.setCharacterEncoding("UTF-8");
		response.setContentType("text/html;charset=UTF-8");
		PrintWriter out = response.getWriter();

		// 上下文
		PageContext pageContext = JspFactory.getDefaultFactory().getPageContext(this, request, response, null, true,
				8 * 1024, true);

		// 上传到目录个数
		int count = 0;
		
		
		String info_title = null;

 * Servlet implementation class ScenDel
 * 删除景点
 */
@WebServlet("/admin/ScenDel")
public class ScenDel extends HttpServlet {
	private static final long serialVersionUID = 1L;
      ScenOperator scenOperator=new ScenOperator();
    /**
     * @see HttpServlet#HttpServlet()
     */
    public ScenDel() {
        super();
        // TODO Auto-generated constructor stub
    }

	/**
	 * @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)
	 */
	protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		// TODO Auto-generated method stub
		request.setCharacterEncoding("UTF-8");
		response.setContentType("text/html;charset=UTF-8");
		PrintWriter out=response.getWriter();
		
		//获取要删除的景点ID
		int scenid=Integer.parseInt(request.getParameter("scenid"));
		//景点图片
		String scenpic=request.getParameter("scenpic");
		System.out.println("/admin/ScenDel");
		
		if (scenOperator.delScen(scenid)) {		
			//获取要删除的图片或者文件的绝对路径
			File file = new File(request.getServletContext().getRealPath(getServletInfo())+"/"+scenpic);	 
			//路径和文件名称
			System.out.println(file.getPath());
			System.out.println(file.getName());
			//如果文件存在
			if (file.exists()) {
				//file.delete();
				System.out.println("删除成功");
				out.flush();// 清空缓存
				out.println("<script>");// 输出script标签
				out.println("alert('删除成功!');");// js语句：输出alert语句
				out.println("history.back();");// js语句：输出网页回退语句
				out.println("</script>");// 输出script结尾标签
			}

				out.println("<TR><TD>文件扩展名(FileExt)</TD><TD>" + file.getFileExt() + "</TD></TR>");
				out.println("<TR><TD>文件全名(FilePathName)</TD><TD>" + file.getFilePathName() + "</TD></TR>");
				out.println("</TABLE><BR/>");*/
			}

			/*
			 * // 将文件另存为 try { file.saveAs("/image/banner" + file.getFileName(),
			 * SmartUpload.SAVE_VIRTUAL); file.saveAs("E:/Web//" +
			 * file.getFileName(), SmartUpload.SAVE_PHYSICAL); } catch
			 * (SmartUploadException e) { // TODO Auto-generated catch block
			 * e.printStackTrace(); }
			 */

		}
		
		
		
	}

	/**
	 * @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)
	 */
	protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		// TODO Auto-generated method stub
		doGet(request, response);
	}

}
package com.trav.cms.info.service;

				8 * 1024, true);

		// 上传到目录个数
		int count = 0;

		int info_id = 0;
		String info_title = null;
		String info_txt = null;
		String info_tag = null;
		String info_pic = null;
		 
		String info_url = null;
		String info_date = null;
		int info_order = 0;

		// 资讯实体对象
		Info info = null;

		System.out.println("资讯图片上传");
		// 新建一个SmartUpload对象
		SmartUpload su = new SmartUpload();
		// 上传初始化
		su.initialize(pageContext);

		// 设置上传限制
		// 1.限制每个上传文件的最大长度为10MB
		su.setMaxFileSize(10 * 1024 * 1024);
		// 2.限制总上传文件的长度
		su.setTotalMaxFileSize(30 * 1024 * 1024);
		// 3.设定允许上传的文件
		su.setAllowedFilesList("gif,jpg,png,jpeg,bmp,ico");
		// 4.设定禁止上传的文件
		try {
			su.setDeniedFilesList("exe,bat,jsp,htm,html,,");
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			System.out.println("不允许上传此类文件");
			e.printStackTrace();
		}

		for (int i = 0; i < su.getFiles().getCount(); i++) {
			File file = su.getFiles().getFile(i);
			// 若文件不存在则继续
			if (file.isMissing()) {
				continue;
			}
			banname = su.getRequest().getParameter("ban-name");
			bantitle = su.getRequest().getParameter("ban-title");
			banpath = "image/banner/" + file.getFileName();
			banner = new Banner(banname, bantitle, banpath);
			if (banOperator.addBan(banner)) {
				System.out.println("getFileName***--" + file.getFilePathName());
				out.flush();// 清空缓存
				out.println("<script>");// 输出script标签
				out.println("alert('轮播图图片上传成功!');");// js语句：输出alert语句
				out.println("history.back();");// js语句：输出网页回退语句
				out.println("</script>");// 输出script结尾标签

				// 显示当前文件信息
				/*out.println("轮播图图片上传成功");
				out.println("<br/>图片名：" + su.getRequest().getParameter("ban-name") + "<br/><br/>");
				out.println("<br/>标题名：" + su.getRequest().getParameter("ban-title") + "<br/><br/>");
				out.println("<br/>标题名：" + "image/banner/" + file.getFileName() + "<br/><br/>");
				

				out.println("<TABLE BORDER=1>");
				out.println("<TR><TD>表单项名(FieldName)</TD><TD>" + file.getFieldName() + "</TD></TR>");
				out.println("<TR><TD>文件长度(Size)</TD><TD>" + file.getSize() + "</TD></TR>");
				out.println("<TR><TD>文件名(FileName)</TD><TD>" + file.getFileName() + "</TD></TR>");
				out.println("<TR><TD>文件扩展名(FileExt)</TD><TD>" + file.getFileExt() + "</TD></TR>");
				out.println("<TR><TD>文件全名(FilePathName)</TD><TD>" + file.getFilePathName() + "</TD></TR>");
				out.println("</TABLE><BR/>");*/
			}

			/*
			 * // 将文件另存为 try { file.saveAs("/image/banner" + file.getFileName(),
			 * SmartUpload.SAVE_VIRTUAL); file.saveAs("E:/Web//" +
			 * file.getFileName(), SmartUpload.SAVE_PHYSICAL); } catch
			 * (SmartUploadException e) { // TODO Auto-generated catch block
			 * e.printStackTrace(); }
			 */

		// 上传初始化
		su.initialize(pageContext);

		// 设置上传限制
		// 1.限制每个上传文件的最大长度为10MB
		su.setMaxFileSize(10 * 1024 * 1024);
		// 2.限制总上传文件的长度
		su.setTotalMaxFileSize(30 * 1024 * 1024);
		// 3.设定允许上传的文件
		su.setAllowedFilesList("gif,jpg,png,jpeg,bmp,ico");
		// 4.设定禁止上传的文件
		try {
			su.setDeniedFilesList("exe,bat,jsp,htm,html,,");
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			System.out.println("不允许上传此类文件");
			e.printStackTrace();
		}

		// 上传文件
		try {
			su.upload();
		} catch (SmartUploadException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}

		// 将上传的文件全部保存到指定目录
		// 图片轮播的路径

		try {
			count = su.save("/image/scen");

		} catch (SmartUploadException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		System.out.println(count + "个文件上传成功！");

		// 利用Request对象获取参数之值

		// 逐一提取上传文件信息，同时可保存文件
		for (int i = 0; i < su.getFiles().getCount(); i++) {
			File file = su.getFiles().getFile(i);
			// 若文件不存在则继续
			if (file.isMissing()) {

			throws ServletException, IOException {
		// TODO Auto-generated method stub
		doGet(request, response);
	}

}
package com.trav.cms.info.service;

 

/**
 * Servlet implementation class InfoAdd
 */
@WebServlet("/admin/InfoAdd")
public class InfoAdd extends HttpServlet {
	private static final long serialVersionUID = 1L;
       InfoOperator infoOperator=new InfoOperator();
    /**
     * @see HttpServlet#HttpServlet()
     */
    public InfoAdd() {
        super();
        // TODO Auto-generated constructor stub
    }

	/**
	 * @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)
	 */
	protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		// TODO Auto-generated method stub

		request.setCharacterEncoding("UTF-8");
		response.setContentType("text/html;charset=UTF-8");
		PrintWriter out = response.getWriter();

/**
 * Servlet implementation class ScenAdd
 * 景点添加
 */
@WebServlet("/admin/ScenAdd")
public class ScenAdd extends HttpServlet {
	private static final long serialVersionUID = 1L;
	ScenOperator scenOperator=new ScenOperator();
	/**
	 * @see HttpServlet#HttpServlet()
	 */
	public ScenAdd() {
		super();
		// TODO Auto-generated constructor stub
	}

	/**
	 * @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse
	 *      response)
	 */
	protected void doGet(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {
		// TODO Auto-generated method stub

		request.setCharacterEncoding("UTF-8");
		response.setContentType("text/html;charset=UTF-8");
		PrintWriter out = response.getWriter();
		// 上下文
		PageContext pageContext = JspFactory.getDefaultFactory().getPageContext(this, request, response, null, true,
				8 * 1024, true);
		// 上传到目录个数
		int count = 0;

		// TODO Auto-generated method stub
		request.setCharacterEncoding("UTF-8");
		response.setContentType("text/html;charset=UTF-8");
		PrintWriter out = response.getWriter();

		// 上下文
		PageContext pageContext = JspFactory.getDefaultFactory().getPageContext(this, request, response, null, true,
				8 * 1024, true);

		// 上传到目录个数
		int count = 0;
		
		int scenid=0;
		String scenname = null;// 名表横
		String scenintro = null;// 介绍
		String scenlevel = null;// 星级
		String scentitle = null;// 标题
		String scenfeature = null;// 特色
		String scentraff = null;// 交通
		String scenmap = null;// 地图
		String picpath = null;// 图片
		String scenadd = null;// 地址
		String scennameen = null;// 英文名
		int scenorder=0;
		String scenurl=null;
		// 景点对象
		Scen scen=null;
		
		System.out.println("景点图片上传");
		// 新建一个SmartUpload对象
		SmartUpload su = new SmartUpload();
		// 上传初始化
		su.initialize(pageContext);

		// 设置上传限制
		// 1.限制每个上传文件的最大长度为10MB
		su.setMaxFileSize(10 * 1024 * 1024);
		// 2.限制总上传文件的长度
		su.setTotalMaxFileSize(30 * 1024 * 1024);
		// 3.设定允许上传的文件

			/*
			 * // 将文件另存为 try { file.saveAs("/image/banner" + file.getFileName(),
			 * SmartUpload.SAVE_VIRTUAL); file.saveAs("E:/Web//" +
			 * file.getFileName(), SmartUpload.SAVE_PHYSICAL); } catch
			 * (SmartUploadException e) { // TODO Auto-generated catch block
			 * e.printStackTrace(); }
			 */

		}

	}

}
package com.trav.cms.user.service;

/**
 * Servlet implementation class UserAdd
 */
@WebServlet("/admin/UserAdd")
public class UserAdd extends HttpServlet {
	private static final long serialVersionUID = 1L;
	UserOperator userOperator = new UserOperator();

	/**
	 * @see HttpServlet#HttpServlet()
	 */
	public UserAdd() {
		super();
		// TODO Auto-generated constructor stub
	}

					File file = su.getFiles().getFile(i);
					// 若文件不存在则继续
					if (file.isMissing()) {
						continue;
					}
					banid=Integer.parseInt(su.getRequest().getParameter("ban-id"));
					banname = su.getRequest().getParameter("ban-name");
					bantitle= su.getRequest().getParameter("ban-title");
					banpath = "image/banner/"+file.getFileName();
					banner=new Banner(banid,banname, bantitle, banpath);
					
					if (banOperator.editBan(banner)) {
						System.out.println("getFileName***--"+file.getFilePathName());
						out.flush();// 清空缓存
						out.println("<script>");// 输出script标签
						out.println("alert('轮播图图片编辑成功!');");// js语句：输出alert语句
						out.println("history.back();");// js语句：输出网页回退语句
						out.println("</script>");// 输出script结尾标签
						 
						
						/*
						
						// 显示当前文件信息
						out.println("<br/>图片名：" + su.getRequest().getParameter("ban-name") + "<br/><br/>");
						out.println("<br/>标题名：" + su.getRequest().getParameter("ban-title") + "<br/><br/>");
						out.println("<br/>标题名：" + "image/banner/"+file.getFileName() + "<br/><br/>");
						out.println("<TABLE BORDER=1>");
						out.println("<TR><TD>表单项名(FieldName)</TD><TD>" + file.getFieldName() + "</TD></TR>");
						out.println("<TR><TD>文件长度(Size)</TD><TD>" + file.getSize() + "</TD></TR>");
						out.println("<TR><TD>文件名(FileName)</TD><TD>" + file.getFileName() + "</TD></TR>");
						out.println("<TR><TD>文件扩展名(FileExt)</TD><TD>" + file.getFileExt() + "</TD></TR>");
						out.println("<TR><TD>文件全名(FilePathName)</TD><TD>" + file.getFilePathName() + "</TD></TR>");
						out.println("</TABLE><BR/>");*/
					}
					
					
/*
					// 将文件另存为
					try {
						file.saveAs("/image/banner" + file.getFileName(), SmartUpload.SAVE_VIRTUAL);
						file.saveAs("E:/Web//" + file.getFileName(), SmartUpload.SAVE_PHYSICAL);
					} catch (SmartUploadException e) {
						// TODO Auto-generated catch block
						e.printStackTrace();
					}*/
					
				}
		
	}