Servlet数据库管理项目

public class SysInitServlet extends HttpServlet {

	@Override
	public void destroy() {
		// TODO Auto-generated method stub
		super.destroy();
	}

	@Override
	public void init() throws ServletException {
		//读取全局数据
		String ipRange=this.getServletContext().getInitParameter("globalIpRange");
		String encoding=this.getServletContext().getInitParameter("globalEncoding");
		CommonValue.ipRange=ipRange;
		CommonValue.encoding=encoding;
		System.out.println(CommonValue.ipRange);
		System.out.println(CommonValue.encoding);
		//读取局部数据
		/*String ipRange=this.getInitParameter("ipRange");
		String encoding=this.get
		InitParameter("encoding");
		CommonValue.ipRange=ipRange;
		CommonValue.encoding=encoding;
		System.out.println(CommonValue.ipRange);
		System.out.println(CommonValue.encoding);*/
	}

	@Override
	public void init(ServletConfig config) throws ServletException {
		System.out.println("init(ServletConfig)");
				//读取全局数据
				String ipRange=config.getServletContext().getInitParameter("globalIpRange");
				String encoding=config.getServletContext().getInitParameter("globalEncoding");
				CommonValue.ipRange=ipRange;
				CommonValue.encoding=encoding;
				System.out.println(CommonValue.ipRange);
				System.out.println(CommonValue.encoding);
				//读取局部数据
				/*String ipRange=this.getInitParameter("ipRange");
				String encoding=this.getInitParameter("encoding");
				CommonValue.ipRange=ipRange;
				CommonValue.encoding=encoding;
				System.out.println(CommonValue.ipRange);
				System.out.println(CommonValue.encoding);*/
	}
}

public class CommonValue {	
	public static String ipRange="";
	public static String encoding="";

}

@Override
	protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
		String ipRange=CommonValue.ipRange;
		String[] ips=ipRange.split("-");
		int ip1=Integer.parseInt(ips[0].substring(ips[0].lastIndexOf(".")+1));
		int ip2=Integer.parseInt(ips[1].substring(ips[1].lastIndexOf(".")+1));;
		System.out.println(ip1+" "+ip2);
		//获取客户端访问的真实ip
		String realIp=req.getRemoteAddr();
		int clientIp=Integer.parseInt(realIp.substring(realIp.lastIndexOf(".")+1));
		System.out.println("realIp="+realIp);
		if(clientIp>ip1&&clientIp<ip2){
			resp.sendRedirect("login.html");//如果符合就重定向到登录界面
		}else{
			PrintWriter out=resp.getWriter();
			out.append("u r not qulify to read,ur ip="+realIp);
			out.close();
		}
	}

@Override
	protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
		//获取前端提交的数据
		String uname=req.getParameter("userName");
		String upwd=req.getParameter("userPassword");
		User user=new User();
		user.setName(uname);
		user.setPassword(upwd);
		//调用业务
		UserService userService=new UserServiceImpl();
		boolean flag=userService.login(user);
		//根据业务的返回结果做响应
		if(flag){
			resp.sendRedirect("success.jsp");
		}else{
			resp.sendRedirect("login.jsp");
		}
	}

public interface UserService {
	//登录的业务接口方法
	public boolean login(User user);

	public boolean register(User user);

}

public class UserServiceImpl implements UserService {
	private UserDao userDao=new UserDaoImpl();
	@Override
	public boolean login(User user) {
		boolean flag=false;
		int id=userDao.login(user);//调用数据库
		if(id>0){
			flag=true;
		}
		return flag;
	}
}

public interface UserDao {
	//登陆的数据库方法
	public int login(User user);
}

public class UserDaoImpl implements UserDao {

	@Override
	public int login(User user) {
		int id=0;
		try {
			String sql = "select id from t_user where username=? and userpassword=?";
			Object[] params = new Object[] { user.getName(), user.getPassword() };
			List<User> users = CommonDao.executeQuery(User.class, sql, params);
			if (users != null && users.size() == 1) {
				id = users.get(0).getId();
			} 
		} catch (Exception e) {
			e.printStackTrace();
		}
		return id;
	}

protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		//1.获取注册的数据
		String uname=request.getParameter("userName");
		String upwd=request.getParameter("userPassword");
		String uage=request.getParameter("age");
		String uaddress=request.getParameter("address");
		User user=new User();
		user.setName(uname);
		user.setPassword(upwd);
		user.setAddress(uaddress);
		user.setAge(Integer.parseInt(uage));
		//2.注册的业务
		UserService userService=new UserServiceImpl();
		boolean flag=userService.register(user);
		//3.根据业务的返回结果做响应
		if(flag){
			
		}else{
			
		}
	}

public interface UserService {
	//登录的业务接口方法
	public boolean login(User user);

	public boolean register(User user);

}

@Override
	public boolean register(User user) {
		boolean flag=false;
		int rowAffect=userDao.register(user);
		if(rowAffect==1){
			flag=true;
		}
		return false;
	}

public interface UserDao {
	//注册的数据库方法
	public int register(User user);
}

@Override
	public int register(User user) {
		int rowAffect=0;
		try {
			String sql = "insert into t_user (username,userpassword,age,address) values(?,?,?,?)";
			rowAffect = CommonDao.executeUpdate(sql,
					new Object[] { user.getName(), user.getPassword(), user.getAge(), user.getAddress() });
		} catch (Exception e) {
			// TODO: handle exception
		}
		return rowAffect;
	}

public class CommonDao {
	private static PropertyUtil pu=new PropertyUtil("mysql.properties");
	private static String driverClass=pu.getProperty("jdbc_driverClass");
	private static String url=pu.getProperty("jdbc_url");
	private static String username=pu.getProperty("jdbc_username");
	private static String userpassword=pu.getProperty("jdbc_userpassword");
	/**
	 * 获取连接的公共方法
	 * @return
	 * @throws Exception
	 */
	public static Connection getConnection()throws Exception{
		Connection con=null;
		Class.forName(driverClass);
		con=DriverManager.getConnection(
				url,
				username,
				userpassword);
		return con;
	}
}

protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		//1.获取数据(无)
		//2.调用查询所有用户信息的业务方法
		List<User> users=new UserServiceImpl().findAllUsers();
		//3.根据业务的返回结果绑定给request对象,把带有数据的request对象转发给usershowall.jsp
		//绑定数据到request对象中
		request.setAttribute("allusers", users);
		//把带有新数据的request对象转发给下一个目的地usershowall.jsp
		RequestDispatcher rd=request.getRequestDispatcher("usershowall.jsp");
		rd.forward(request, response);
		
		
	}

public List<User> findAllUsers();

public List<User> findAllUsers() {
		return userDao.findAllUsers();
	}

public List<User> findAllUsers();

public List<User> findAllUsers() {
		List<User> users=null;
		try {
			String sql = "select id,username name,userpassword password,age,address from t_user";
			users = CommonDao.executeQuery(User.class, sql);
		} catch (Exception e) {
			e.printStackTrace();
		}
		return users;
	}

protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		//1.获取要删除的id
		String id=request.getParameter("uid");
		//2.调用删除用户业务
		boolean flag=new UserServiceImpl().deleteUser(Integer.parseInt(id));
		//3.根据业务的返回结果做跳转响应
		if(flag)
		response.sendRedirect("UserShowAllServlet");
	}

public boolean deleteUser(int id);

public boolean deleteUser(int id) {
		boolean flag=false;
		int rowAffect=userDao.deleteUser(id);
		if(rowAffect==1){
			flag=true;
		}
		return flag;
	}

public int deleteUser(int id);

public int deleteUser(int id) {
		int rowAffect=0;
		try {
			String sql="delete from t_user where id=?";
			rowAffect=CommonDao.executeUpdate(sql, id);
		} catch (Exception e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return rowAffect;
		
	}

protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		request.setCharacterEncoding(CommonValue.encoding);
		//1.获取用户的id
		String id=request.getParameter("uid");
		//2.根据id查询用户信息
		User user=new UserServiceImpl().findUserById(Integer.parseInt(id));
		//3.把查询到的数据转发给update.jsp
		//绑定数据给request
		request.setAttribute("user", user);
		//转发request到新的目标url
		request.getRequestDispatcher("update.jsp").forward(request, response);
	}

public User findUserById(int id);

public User findUserById(int id) {
		User user=userDao.findUserById(id);
		return user;
	}

public User findUserById(int id);

public User findUserById(int id) {
		User user=null;
		try {
			String sql="select id,username name,userpassword password,age,address from t_user where id=?";
			List<User> users=CommonDao.executeQuery(User.class, sql,id);
			if(users!=null&&users.size()==1){
				user=users.get(0);
			}
		} catch (Exception e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return user;
	}

protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		request.setCharacterEncoding(CommonValue.encoding);
		String uid=request.getParameter("userId");
		String uname=request.getParameter("userName");
		String upwd=request.getParameter("userPassword");
		String uage=request.getParameter("age");
		String uaddress=request.getParameter("address");
		User user=new User();
		user.setId(Integer.parseInt(uid));
		user.setAddress(uaddress);
		user.setName(uname);
		user.setPassword(upwd);
		user.setAge(Integer.parseInt(uage));
		boolean flag=new UserServiceImpl().updateUser(user);
		if(flag)
		response.sendRedirect("UserShowAllServlet");
	}

public boolean updateUser(User user);

public boolean updateUser(User user) {
		boolean flag=false;
		int rowAffect=userDao.updateUser(user);
		if(rowAffect==1){
			flag=true;
		}
		return flag;
	}

public int updateUser(User user);

public int updateUser(User user) {
		int rowAffect=0;
		try {
			String sql="update t_user set username=?,userpassword=?,age=?,address=? where id=?";
			rowAffect=CommonDao.executeUpdate(sql, user.getName(),user.getPassword(),user.getAge(),user.getAddress(),user.getId());
		} catch (Exception e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return rowAffect;
	}

protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		//1.获取数据(当前页码,模糊条件用户名和地址)
		//获取currentPage
		int currentPage=1;
		String currentPage_String=request.getParameter("currentPage");
		if(currentPage_String!=null){
			currentPage=Integer.parseInt(currentPage_String);
		}
		//获取模糊关键字
		String keyword1=request.getParameter("keyword1");
		String keyword2=request.getParameter("keyword2");
		String kw1=(keyword1==null)? "":keyword1;
		String kw2=(keyword2==null)? "":keyword2;
		String[] keywords=new String[]{kw1,kw2};
		//获取每一页显示记录的条数PageSize(page.properties)
		int pageSize=Integer.parseInt(new PropertyUtil("page.properties").getProperty("pageSize"));
		
		
		//2.调用分页的业务
		UserService userService=new UserServiceImpl();
		Page page=userService.findUserByPage(currentPage,pageSize,keywords);
		
		//3.把查询到的分页信息绑定给request,转发给usershowbypage.jsp
		request.setAttribute("page", page);
		request.getRequestDispatcher("usershowbypage.jsp").forward(request, response);
		
	}

public Page findUserByPage(int currentPage, int pageSize, String[] keywords);

public Page findUserByPage(int currentPage, int pageSize, String[] keywords) {
		Page page=new Page();
		page.setCurrentPage(currentPage);
		page.setPageSize(pageSize);
		page.setKeywords(keywords);
		//查询数据库获取带有模糊条件的总记录数
		int totalCount=userDao.getCount(keywords);
		page.setTotalCount(totalCount);
		//计算总页数
		int totalPage=(totalCount%pageSize==0)? (totalCount/pageSize):(totalCount/pageSize)+1;
		page.setTotalPage(totalPage);
		//计算前一页
		if(currentPage==1){
			page.setPreviousPage(1);
		}else{
			page.setPreviousPage(currentPage-1);
		}
		//计算下一页
		if(currentPage==totalPage){
			page.setNextPage(totalPage);
		}else{
			page.setNextPage(currentPage+1);
		}
		//从数据库获取当前页的数据
		List<User> users=userDao.getUsersByPage(currentPage,pageSize,keywords);
		page.setData(users);
		return page;
	}

//分页+模糊
	public int getCount(String[] keywords);
	public List<User> getUsersByPage(int currentPage, int pageSize, String[] keywords);

public int getCount(String[] keywords) {
		int count=0;
		try {
			String sql="select count(id) geshu from t_user "
					+ "where username like ? and address like ?";
			Object[] params=new Object[]{"%"+keywords[0]+"%","%"+keywords[1]+"%"};
			List<CountVO> counts=CommonDao.executeQuery(CountVO.class, sql, params);
			if(counts!=null&&counts.size()==1){
				count=counts.get(0).getGeshu();
			}
		} catch (Exception e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return count;
	}

	@Override
	public List<User> getUsersByPage(int currentPage, int pageSize, String[] keywords) {
		List<User> users=null;
		try {
			String sql="select id,username name,userpassword password,age,address from t_user where username like ? and address like ? limit ?,?";
			Object[] params=new Object[]{"%"+keywords[0]+"%","%"+keywords[1]+"%",(currentPage-1)*pageSize,pageSize};
			users=CommonDao.executeQuery(User.class, sql, params);
		} catch (Exception e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return users;
	}

public class CountVO {
	private int geshu;
	public int getGeshu() {
		return geshu;
	}
	public void setGeshu(int geshu) {
		this.geshu = geshu;
	}
}

protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		HttpSession session=request.getSession();
		//session对象存在,session对象中的userName的数据被移除
		session.removeAttribute("userName");
		//另一种写法(不推荐)
		//session.setAttribute("userName", null);
		//session对象不存在了
		session.invalidate();
		response.sendRedirect("login.jsp");
		
	}

//获取前端提交的数据
String uname=req.getParameter("userName");
session.setAttribute("userName", uname);//给session对象存uname值

protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		//此do方法生成一张图片
		Random r=new Random();
		//0.创建空白图片
		BufferedImage image=new BufferedImage(100,30,BufferedImage.TYPE_INT_RGB);
		//1.获取图片的画笔
		Graphics g=image.getGraphics();
		//2.设置画笔的颜色
		g.setColor(new Color(r.nextInt(255),r.nextInt(255),r.nextInt(255)));
		//3.绘制矩形背景
		g.fillRect(0, 0, 100, 30);
		//4.调用一个自定义的方法,获取长度为5的字母和数字的字符串
		String number=this.getNumber(5);
		//5.随机生成的验证码存储在session中
		HttpSession session=request.getSession();
		session.setAttribute("code", number);
		//6.重新设置画笔,准备画验证码
		g.setColor(new Color(0,0,0));
		g.setFont(new Font(null,Font.BOLD,24));
		//7.绘制验证码
		g.drawString(number, 5, 25);
		//8.绘制8条干扰线
		for(int i=0;i<8;i++){
			g.setColor(new Color(r.nextInt(255),r.nextInt(255),r.nextInt(255)));
			g.drawLine(r.nextInt(100),r.nextInt(30),r.nextInt(100),r.nextInt(30));
		}
		//9.设置响应的内容
		response.setContentType("image/jpeg");
		OutputStream os=response.getOutputStream();
		//10.把image图片写出到响应中(写道网络输出流上)
		ImageIO.write(image, "jpeg", os);
		os.flush();
		os.close();
	}
	private String getNumber(int size){
		String str="ABCDEFGHIGKLMNOPQRSTUVWXYZ1234567890";
		String number="";
		Random r= new Random();
		for(int i=0;i<size;i++){
			number+=str.charAt(r.nextInt(str.length()));
		}
		return number;
	}

//获取用户数据的验证码
		String validateCode=req.getParameter("validateCode");
		//获取前端提交的数据
		String uname=req.getParameter("userName");
		String upwd=req.getParameter("userPassword");
		System.out.println(uname+" "+upwd);
		User user=new User();
		user.setName(uname);
		user.setPassword(upwd);
		//从session中获取系统生成的验证码
		HttpSession session=req.getSession();
		String code=session.getAttribute("code").toString();
//从session中获取系统生成的验证码
		HttpSession session=req.getSession();
		String code=session.getAttribute("code").toString();
		session.setAttribute("userName", uname);
		if(validateCode.equalsIgnoreCase(code)){
			//调用业务
			UserService userService=new UserServiceImpl();
			
			boolean flag=userService.login(user);
			//根据业务的返回结果做响应
			if(flag){
				//重定向到分页+模糊
				resp.sendRedirect("FindUserByPageServlet");
			}else{
				resp.sendRedirect("login.jsp");
			}
		}else{
			req.setAttribute("messagecode", "验证码错误");
			req.getRequestDispatcher("login.jsp").forward(req, resp);
		}

protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		request.setCharacterEncoding(CommonValue.encoding);
		//获取用户名信息
		String uname=request.getParameter("uname");
		//调用查询用户名是否存在的业务方法
		boolean flag=new UserServiceImpl().findUserByName(uname);
		//根据业务的返回结果做相应的信息响应
		String responseText="";
		if(flag){
			responseText="用户名被占用";
		}else{
			responseText="用户名可用";
		}
		//把信息响应给客户端js
		response.setContentType("text/html;charset=utf-8");
		PrintWriter out=response.getWriter();
		out.print(responseText);
		out.flush();
		out.close();
		
	}

public boolean findUserByName(String uname) {
		boolean flag=false;
		int id=userDao.findUserByName(uname);
		if(id>0){
			flag=true;
		}
		return flag;
	}

public int findUserByName(String uname) {
		int id=0;
		try {
			String sql="select id from t_user where username=?";
			List<User> users=CommonDao.executeQuery(User.class, sql, uname);
			if(users!=null&&users.size()==1){
				id=users.get(0).getId();
			}
		} catch (Exception e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return id;
	}

//根据业务的返回结果做相应的信息响应
		String responseText="";
		if(flag){
			responseText="用户名被占用";
		}else{
			responseText="用户名可用";
		}

public class Result implements Serializable{
	/**
	 * 0:失败
	 * 1:成功
	 */
	private int status;
	/**
	 * 存储提示消息
	 */
	private String message;
	/**
	 * 存储数据
	 */
	private Object data;
	public int getStatus() {
		return status;
	}
	public void setStatus(int status) {
		this.status = status;
	}
	public String getMessage() {
		return message;
	}
	public void setMessage(String message) {
		this.message = message;
	}
	public Object getData() {
		return data;
	}
	public void setData(Object data) {
		this.data = data;
	}
	
}

String responseText="";
		Result result=new Result();
		if(flag){
			//responseText="{\"msg\":\"用户名被占用\"}";
			result.setStatus(0);
			result.setMessage("用户名被占用");
		}else{
			//responseText="{\"msg\":\"用户名可用\"}";
			result.setStatus(1);
			result.setMessage("用户名可以用");
		}

responseText=JSON.toJSONString(result);

//获取记住用户名
String rememberName=req.getParameter("remembername");

//记住用户名功能代码
	if("true".equals(rememberName)){
		System.out.println("选中记住用户名项");
		//开始记住用户名
		Cookie cookie=new Cookie("remname",URLEncoder.encode(uname,"utf-8"));
		cookie.setPath(req.getContextPath()+"/");//把cookie存进根节点
		cookie.setMaxAge(3600*5);//设置cookie存活时间是5个小时
		resp.addCookie(cookie);
}

//获取10天自动登录是否打勾
		String autologin=req.getParameter("autologin");

if("true".equals(autologin)){
	//创建cookie,key是autologin value是用户名#密码
	Cookie cookie=new Cookie("autologin",URLEncoder.encode(uname,"utf-8")+"#"+Base64.getEncoder().encodeToString(upwd.getBytes()));
	cookie.setPath(req.getContextPath()+"/");//把cookie存进根节点
	cookie.setMaxAge(3600*24*10);//设置cookie存活时间是10天
	resp.addCookie(cookie);
}

//获取从客户端发送过来的所有的cookie
		boolean f=false;
		Cookie[] cookies=req.getCookies();
		if(cookies!=null){
			for(Cookie c:cookies){
				if("autologin".equals(c.getName())){
					//说明autologin的cookie是存在的,自动登录
					f=true;
				}
			}
		}
		
		if(f || validateCode.equalsIgnoreCase(code)){
//调用业务
			UserService userService=new UserServiceImpl();
			
			boolean flag=userService.login(user);
			//根据业务的返回结果做响应
			if(flag){
				//记住用户名功能代码
				if("true".equals(rememberName)){
					System.out.println("选中记住用户名项");
					//开始记住用户名
					Cookie cookie=new Cookie("remname",URLEncoder.encode(uname,"utf-8"));
					cookie.setPath(req.getContextPath()+"/");//把cookie存进根节点
					cookie.setMaxAge(3600*5);//设置cookie存活时间是5个小时
					resp.addCookie(cookie);
				}
				if("true".equals(autologin)){
					//创建cookie,key是autologin value是用户名#密码
					Cookie cookie=new Cookie("autologin",URLEncoder.encode(uname,"utf-8")+"#"+Base64.getEncoder().encodeToString(upwd.getBytes()));
					cookie.setPath(req.getContextPath()+"/");//把cookie存进根节点
					cookie.setMaxAge(3600*24*10);//设置cookie存活时间是10天
					resp.addCookie(cookie);
				}
		
		}

protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		//登出后删除自动登录的cookie
		Cookie[] c=request.getCookies();
		if(c!=null){
		for(Cookie cookie:c){
			if("autologin".equals(cookie.getName())||"remname".equals(cookie.getName())){
				cookie.setMaxAge(0);//清除指定的cookie
				cookie.setPath(request.getContextPath()+"/");
				response.addCookie(cookie);
			}
		}
	}
		//另一种删除cookie(不推荐),给autologin设置了一个错误的value(账号密码信息),		//登录失败后自动跳到登录页面
		/*Cookie cookie=new Cookie("autologin","aa");
		cookie.setMaxAge(0);//销毁cookie
		cookie.setPath(request.getContextPath()+"/");
		response.addCookie(cookie);
		response.sendRedirect("login.jsp");*/
		
		//删除session信息
		HttpSession session=request.getSession();
		//session对象存在,session对象中的userName的数据被移除
		session.removeAttribute("userName");
		//另一种写法(不推荐)
		//session.setAttribute("userName", null);
		//session对象不存在了
		session.invalidate();
		response.sendRedirect("login.jsp");	
	}

public void doFilter(ServletRequest servletRequest, ServletResponse servletResponse, FilterChain chain) throws IOException, ServletException {
		HttpServletRequest request=(HttpServletRequest)servletRequest;
		HttpServletResponse reponse=(HttpServletResponse)servletResponse;
		request.setCharacterEncoding("utf-8");
		reponse.setCharacterEncoding("utf-8");
		chain.doFilter(servletRequest, servletResponse);
	}

//如果没有登录,访问其他资源就跳转到登录页面
	private String redirectURL;
	//session中是否存储用户,如果session中存储了用户名,说明已经登录了
	private String sessionKey=null;
	//所有资源都拦截/过滤,但下面集合中的url是可以通过的
	private List<String> notCheckURLList=new ArrayList<String>();

public void doFilter(ServletRequest servletRequest, ServletResponse servletResponse, FilterChain chain) throws IOException, ServletException {
		//1.强制类型转换
		HttpServletRequest request=(HttpServletRequest)servletRequest;
		HttpServletResponse response=(HttpServletResponse)servletResponse;
		//2.获取当前浏览器对应的session对象
		HttpSession session=request.getSession();
		//3.如果sessionKey=null,表示直接访问下一个过滤器
		//或者直接请求资源,相当于空走了一个过滤器
		if(this.sessionKey==null||this.sessionKey.equals("")){
			chain.doFilter(servletRequest, servletResponse);
			return;
		}
		//4.检查是否登陆过
		//只要是免检列表之外的和session对象中的以userName为key中没有存用户名
		if(!checkRequestURLNotFilterList(request) && session.getAttribute(sessionKey)==null){
			//能进此处,相当于要调转到login.jsp
			//http://localhost:8080/twp/login.jsp
			response.sendRedirect(request.getContextPath()+this.redirectURL);
			return;
		}
		//5.上面两个if的条件都没有成立,需要访问下一个过滤器
		//可能是登陆过的,也有可能是免检列表之内的
		chain.doFilter(servletRequest, servletResponse);
	}
	private boolean checkRequestURLNotFilterList(HttpServletRequest request ){
		String uri=request.getServletPath()+(request.getPathInfo()==null? "":request.getPathInfo());
		System.out.println(uri);
		return this.notCheckURLList.contains(uri);
	}

	/**
	 * @see Filter#init(FilterConfig)
	 */
	public void init(FilterConfig fConfig) throws ServletException {
		//在此init方法中获取初始化的参数
		//login.jsp
		this.redirectURL=fConfig.getInitParameter("redirectURL");
		//userName
		this.sessionKey=fConfig.getInitParameter("checkSessionKey");
		String notCheckURL=fConfig.getInitParameter("notCheckURL");
		if(notCheckURL!=null){
			//标准写法
			//String[] urls=notCheckURLList.split(";");
			//另一种写法
			StringTokenizer st=new StringTokenizer(notCheckURL,";");
			this.notCheckURLList.clear();
			while(st.hasMoreElements()){
				this.notCheckURLList.add(st.nextToken());
			}
		}
		System.out.println(redirectURL);
		System.out.println(sessionKey);
		System.out.println(this.notCheckURLList);
	}

if(!checkRequestURLNotFilterList(request) && session.getAttribute(sessionKey)==null)

public class OnLineListener implements HttpSessionListener {
	private int count=0;
    /**
     * Default constructor. 
     */
    public OnLineListener() {
       System.out.println("统计在线人数的监听器生命周期开始");
    }

	/**
	 * 只有session创建后才会自动调用此方法
	 * 每执行一次此方法,就要给一个变量累加1
     * @see HttpSessionListener#sessionCreated(HttpSessionEvent)
     */
    public void sessionCreated(HttpSessionEvent se)  { 
        count++;
        //把count的值传送给页面显示,跨浏览器显示,所以要借助application/servletContext
        HttpSession session=se.getSession();
        ServletContext application=session.getServletContext();
        application.setAttribute("onLine", count);
    }

	/**
	 * 只有session销毁才会自动调用此方法
	 * 每执行一次此方法,就要给变量累减1
     * @see HttpSessionListener#sessionDestroyed(HttpSessionEvent)
     */
    public void sessionDestroyed(HttpSessionEvent se)  { 
    	count--;
    	 //把count的值传送给页面显示,跨浏览器显示,所以要借助application/servletContext
        HttpSession session=se.getSession();
        ServletContext application=session.getServletContext();
        application.setAttribute("onLine", count);
        
    }
	
}

protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		//1.获取数据
		//2.调用查询所有数据的业务
		UserService userService=new UserServiceImpl();
		byte[] excelData=userService.exportUser();
		//3.相应数据给excel表格
		//把excel的字节数据响应给客户端并下载
		response.setContentType("application/x-msdownload");
		response.setHeader("Content-Disposition", "attachment;filename=alluser.xls");
		response.setContentLength(excelData.length);
		OutputStream os=response.getOutputStream();
		os.write(excelData);
		os.flush();
		os.close();
	}

@Override
	public byte[] exportUser() {
		byte[] data=null;
		//获取所有的用户数据
		List<User> users=userDao.findAllUsers();
		if(users!=null && users.size()>0){
			data=ExportUtil.write2Excel(users);
		}
		return data;
	}

/**
 * 导出的工具类
 * @author PC
 *
 */
public class ExportUtil {

	public static byte[] write2Excel(List<User> users) {
		byte[] data=null;
		//创建一个内存字节流,因为wb.write(OutputStream)
		ByteArrayOutputStream out=null;
		try{
			out=new ByteArrayOutputStream();
			//创建工作簿的对象(老版本.xls)
			Workbook wb=new HSSFWorkbook();
			//创建sheet对象
			Sheet sheet=wb.createSheet("allUsers");
			//创建行对象
			Row row=sheet.createRow(0);
			//创建一个字符串数组,用于存储列头信息
			String[] columns=new String[]{"id","用户名","密码","年龄","地址","头像"};
			//给第一行添加列头信息
			for(int i=0;i<6;i++){
				Cell cell=row.createCell(i);
				//设置样式
				cell.setCellType(HSSFCell.CELL_TYPE_STRING);
				sheet.setColumnWidth(i, 6000);
				CellStyle style=wb.createCellStyle();
				Font font=wb.createFont();
				font.setBold(true);
				font.setColor(HSSFColor.RED.index);
				style.setFont(font);
				cell.setCellStyle(style);
				//给单元格添加文字数据
				cell.setCellValue(columns[i]);
			}
			//循环数据,创建excel表格的行
			for(int j=0;j<users.size();j++){
				User user=users.get(j);
				Row r=sheet.createRow(j+1);
				//给当前行的若干添加数据
				r.createCell(0).setCellValue(user.getId());;
				r.createCell(1).setCellValue(user.getName());;
				r.createCell(2).setCellValue(user.getPassword());;
				r.createCell(3).setCellValue(user.getAge());;
				r.createCell(4).setCellValue(user.getAddress());;
				r.createCell(5).setCellValue(user.getHeadimage());;
			}
			wb.write(out);
		}catch(Exception e){
			e.printStackTrace();
		}finally{
			if(out!=null){
				try {
					out.close();
				} catch (IOException e) {
					// TODO Auto-generated catch block
					e.printStackTrace();
				}
			}
		}
		//把内存流中的数据转换成字节数组
		data=out.toByteArray();
		return data;
	}
	

}

protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		//获取要下载的文件名
				String fileName=request.getParameter("fileName");
				//检测文件在服务器中是否存在
				String realPath=this.getServletContext().getRealPath("/images");
				//拼装一个完整的路径
				String allPath=realPath+File.separator+fileName;
				System.out.println("allPath="+allPath);
				File file=new File(allPath);
				if(file.exists()){
					//文件存在可以下载
					//要想下载文件,必须给response对象设置一个消息头
					response.setHeader("Content-Disposition", "attachment;filename="+new String(fileName.getBytes("utf-8"),"ISO8859-1"));
					//开始下载文件
					OutputStream os=response.getOutputStream();
					//先从服务器本地把文件读入到内存中
					InputStream is=new FileInputStream(file);
					byte[] buf=new byte[1024];
					int len=-1;
					while((len=is.read(buf))!=-1){
						os.write(buf,0,len);
					}
					os.flush();
					os.close();
					is.close();
				}
	}

//1.获取注册的数据
		User user=new UploadUtil().uploadFile(request, response);
		//2.注册的业务
		UserService userService=new UserServiceImpl();
		boolean flag=userService.register(user);
		//3.根据业务的返回结果做响应
		if(flag){
			response.sendRedirect("login.jsp");
		}else{
			//删除上传的文件
			String realPath=request.getServletContext().getRealPath("/images");
			File file = new File(realPath,user.getHeadimage());
			if(file.exists()){
				file.delete();
			}
			response.sendRedirect("register.jsp");
		}

public class UploadUtil {

	private List<String> fileTypes = new ArrayList<String>();

	public User uploadFile(HttpServletRequest request, HttpServletResponse response) {
		User user = new User();

		try {
			String fileName = "";
			//手动添加可接受的文件类型
			fileTypes.add("image/png");
			fileTypes.add("image/jpg");
			fileTypes.add("image/jpeg");
			fileTypes.add("image/bmp");
			response.setContentType("text/html;charset=utf-8");
			PrintWriter out = response.getWriter();
			// Check that we have a file upload request
			// 检查我们有一个文件上传请求
			boolean isMultipart = ServletFileUpload.isMultipartContent(request);
			System.out.println(isMultipart);
			if (isMultipart) {
				// 说明request中有一个文件
				// Create a factory for disk-based file items
				// 创建一个磁盘文件条目工厂,工厂生产对象
				DiskFileItemFactory factory = new DiskFileItemFactory();
				// Create a new file upload handler
				ServletFileUpload upload = new ServletFileUpload(factory);
				// Parse the request
				// 把request中的数据,转换成list集合,元素类型为fileItem
				List<FileItem> items = upload.parseRequest(request);
				// Process the uploaded items
				// 处理上传的条目
				Iterator<FileItem> iter = items.iterator();
				while (iter.hasNext()) {
					FileItem item = iter.next();

					if (item.isFormField()) {
						// 是非文件域,除了文件之外的input
						String name = item.getFieldName();// <input name>
						String value = item.getString();// <input value>
						value = new String(value.getBytes("ISO8859-1"), "utf-8");
						System.out.println(name + " " + value);
						if ("userName".equals(name)) {
							user.setName(value);
						}
						if ("userPassword".equals(name)) {
							user.setPassword(value);
						}
						if ("age".equals(name)) {
							user.setAge(Integer.parseInt(value));
						}
						if ("address".equals(name)) {
							user.setAddress(value);
						}
					} else {
						// 是文件域<input type="file"processUploadFile(item)
						String fieldName = item.getFieldName();
						fileName = item.getName();// 获取真实文件名
						System.out.println(fileName);
						String contentType = item.getContentType();// 获取文件内容类型
						boolean isInMemory = item.isInMemory();// 是否在内存中
						long sizeInBytes = item.getSize();// 获取文件的长度
						System.out.println(
								fieldName + " " + fileName + " " + contentType + " " + isInMemory + " " + sizeInBytes);
						// 处理获取真实的文件名,因为浏览器的差异,导致文件名前带有路径,用此功能去掉路径
						if (fileName != null && fileName != "") {
							fileName = FilenameUtils.getName(fileName);
							fileName = user.getName() + "_headimage." + fileName.split("\\.")[1];
							user.setHeadimage(fileName);
						}
						if (sizeInBytes != 0) {
							if (fileTypes.contains(contentType)) {
								if (sizeInBytes < 4194304) {
									// 准备上传文件在服务器的存储路径
									String realPath = request.getServletContext().getRealPath("/images");
									System.out.println(realPath);
									File file = new File(realPath);
									if (!file.exists()) {
										file.mkdir();
									}
									// 把文件上传到upload文件夹
									File uploadFile = new File(file, fileName);
									item.write(uploadFile);// 把文件写到具体路径
								} else {
									out.println("<div sty='color:red;'>文件太大</div>");
									out.flush();
									out.close();
								}
							} else {
								out.println("<div sty='color:red;'>文件类型不匹配</div>");
								out.flush();
								out.close();
							}
						} else {
							fileName = "default.png";
						}

					}

				}
			}

		} catch (Exception e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return user;
	}
}