基于javaweb+mysql的jsp+servlet高校学生会社团管理系统(前台、后台)(java+jsp+servlet+javabean+mysql+tomcat)

基于javaweb+mysql的jsp+servlet高校学生会社团管理系统(前台、后台)(java+jsp+servlet+javabean+mysql+tomcat)

运行环境

Java≥8、MySQL≥5.7、Tomcat≥8

开发工具

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

适用

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

功能说明

前台:用户注册登陆、个人中心的管理(成立社团、加入的社团、申请加入社团、申请加入活动等)、社团列表、社团风采、社团活动、新闻列表以及留言板功能;

后台管理页面主要有:注册登陆、个人中心、系统管理(用户管理、角色管理、菜单管理、新闻管理、留言管理)、社团管理(财务管理、社团列表、社团风采、社团活动、活动申请、学生管理、社团申请)等几大块

前台

后台:

技术框架

JSP Servlet MySQL JDBC Tomcat CSS JavaScript jstl

基于javaweb+mysql的JSP+Servlet高校学生会社团管理系统(前台、后台)(java+jsp+servlet+javabean+mysql+tomcat)

					}
					
					if ("createUser".endsWith(name)) {
						siteNews.setCreateUser(item.getString("UTF-8"));
						
					}
					
					if ("createTime".endsWith(name)) {
						if (StringUtils.isNotEmpty(item.getString("UTF-8"))) {
							siteNews.setCreateTime(Timestamp.valueOf(item.getString("UTF-8")));
						}else {
							siteNews.setCreateTime(new Date());
						}
						
					}
					
					if ("isRun".endsWith(name)) {
						siteNews.setIsRun(item.getString("UTF-8"));
						
					}
					
					if ("belonTeam".endsWith(name)) {
						siteNews.setBelonTeam(item.getString("UTF-8"));
						
					}
					
					if ("isAudit".endsWith(name)) {
						siteNews.setIsAudit(item.getString("UTF-8"));
						
					}
					
					if ("acStartTime".endsWith(name)) {
						if (StringUtils.isNotEmpty(item.getString("UTF-8"))) {
							siteNews.setAcStartTime(Timestamp.valueOf(item.getString("UTF-8")));
						}else {
							siteNews.setAcStartTime(new Date());
						}
						
					}
					
					if ("acEndTime".endsWith(name)) {
						if (StringUtils.isNotEmpty(item.getString("UTF-8"))) {
							siteNews.setAcEndTime(Timestamp.valueOf(item.getString("UTF-8")));
						}else {
							siteNews.setAcEndTime(new Date());
						}
						
					}
					
					if ("isCanApply".endsWith(name)) {
						siteNews.setIsCanApply(item.getString("UTF-8"));
						
					}
                    
	}
	
	//列表查询
	private void list(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		System.err.println("---开始查询---");
		Menu menu = new Menu();
		/*//分页有关
		Page<Menu> page = new Page<Menu>();
		//设置查询页
		String pageNoStr = request.getParameter("pageNo");
		if (pageNoStr != null && pageNoStr != "") {
			page.setPageNo(Integer.parseInt(pageNoStr));
		}
		//设置查询条件
		String name = request.getParameter("name");
		if (name != null && name != "") {
			menu.setName(name);
			request.setAttribute("name", name);
		}
		String isShow = request.getParameter("isShow");
		if (isShow != null && isShow != "") {
			menu.setIsShow(isShow);
			request.setAttribute("isShow", isShow);
		}
		
		page = menuService.page(menu, page);
		request.setAttribute("page", page);*/
		
		List<Menu> list = new ArrayList<Menu>();
		List<Menu> list1 = menuService.findAll(menu);
		sortList(list, list1, "0", true);
		request.setAttribute("list", list);
		request.getRequestDispatcher("/views/system/menuList.jsp").forward(request, response);
	}
	
	//form跳转页面
	private void form(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		String id = request.getParameter("id");
		String parentId = request.getParameter("parentId");
		Menu menu = new Menu();
			page.setPageNo(Integer.parseInt(pageNoStr));
		}
		//设置查询条件
		String applayTeam = request.getParameter("applayTeam");
		if (applayTeam != null && applayTeam != "") {
			teamApplay.setApplayTeam(applayTeam);
			request.setAttribute("applayTeam", applayTeam);
		}
		String applayStu = request.getParameter("applayStu");
		if (applayStu != null && applayStu != "") {
			teamApplay.setApplayStu(applayStu);
			request.setAttribute("applayStu", applayStu);
		}
		String applayType = request.getParameter("applayType");
		if (applayType != null && applayType != "") {
			teamApplay.setApplayType(applayType);
			request.setAttribute("applayType", applayType);
		}
		
		//判断提示信息
		Object msg = request.getSession().getAttribute("msg");
		if (msg != null) {
			request.setAttribute("msg", msg.toString());
			request.getSession().removeAttribute("msg");
		}
		
		//根据登录用户查出所有的社团
		User currentUser = CurrentUserUtils.getCurrentUser(request);
		String roleFlag = currentUser.getRole2().getRoleFlag();
		if ("leader".equals(roleFlag)) {
			//如果是社长,查出自己负责的所以社团
			Teams teams = new Teams();
			teams.setBuildStu(currentUser.getId());
			List<Teams> findAll = teamsService.findAll(teams);
			request.setAttribute("teamList", findAll);
			
			StringBuffer stringBuffer = new StringBuffer();
			stringBuffer.append(" and a.applay_team in (");
			for (Teams teams2 : findAll) {
				stringBuffer.append("'"+teams2.getId()+"',");
			}
			stringBuffer.append(" '1')");
			teamApplay.setSqlStr(stringBuffer.toString());
		}else{
			request.setAttribute("teamList", teamsService.findAll(new Teams()));
		}
		
		page = teamApplayService.page(teamApplay, page);
		request.setAttribute("page", page);
		request.getRequestDispatcher("/views/team/teamApplayList.jsp").forward(request, response);
	}
                    //得到上传的文件名称,
                    String filename = item.getName();
                    System.out.println(filename);
                    if(filename==null || filename.trim().equals("")){
                        continue;
                    }
                    //注意:不同的浏览器提交的文件名是不一样的,有些浏览器提交上来的文件名是带有路径的,如:  c:\a\b\1.txt,而有些只是单纯的文件名,如:1.txt
                    //处理获取到的上传文件的文件名的路径部分,只保留文件名部分
                    filename = filename.substring(filename.lastIndexOf("\\")+1);
                    String suffix = filename.substring(filename.lastIndexOf("."));
                    filename=String.valueOf(System.currentTimeMillis()+suffix);
                    
                    
                    //获取item中的上传文件的输入流
                    InputStream in = item.getInputStream();
                    //创建一个文件输出流
                    FileOutputStream out = new FileOutputStream(savePath + "\\" + filename);
                    //创建一个缓冲区
                    byte buffer[] = new byte[1024];
                    //判断输入流中的数据是否已经读完的标识
                    int len = 0;
                    //循环将输入流读入到缓冲区当中,(len=in.read(buffer))>0就表示in里面还有数据
                    while((len=in.read(buffer))>0){
                        //使用FileOutputStream输出流将缓冲区的数据写入到指定的目录(savePath + "\\" + filename)当中
                        out.write(buffer, 0, len);
                    }
                    //关闭输入流
                    in.close();
                    //关闭输出流
                    out.close();
                    //删除处理文件上传时生成的临时文件
                    item.delete();
 					msg = "文件上传成功!";
                    
                    user.setPic(request.getContextPath()+"/upload" + "/" + filename);
                }
            }
            if (user.getId()!=null && !"".equals(user.getId())) {
            	user.setPassword(userService.getById(user.getId()).getPassword());
    			userService.update(user);
    		}else{
    			userService.add(user);
    		}
    		response.sendRedirect(contextPath+"/user?method=list");
        }catch (Exception e) {
            msg= "文件上传失败!";
            e.printStackTrace();
            request.setAttribute("msg",msg);
            request.getRequestDispatcher("/views/system/userForm.jsp").forward(request, response);
        }
		//查出所有社团
		Teams teams = new Teams();
		teams.setAuditType("1");
		List<Teams> teamList = teamsService.findAll(teams);
		request.setAttribute("teams", teamList);
		//查出最新的6条活动内容 2是活动
		SiteNews siteNews = new SiteNews();
		siteNews.setIsAudit("1");
		siteNews.setNewsType("2");
		Page<SiteNews> page = new Page<SiteNews>();
		page.setPageSize(6);
		Page<SiteNews> actives = siteNewsService.page(siteNews, page);
		request.setAttribute("actives", actives);
		//查出最新的6条站内新闻 1是新闻
		siteNews.setNewsType("1");
		Page<SiteNews> pageNews = new Page<SiteNews>();
		page.setPageSize(6);
		Page<SiteNews> news = siteNewsService.page(siteNews, pageNews);
		request.setAttribute("news", news);
		
		//查出最新的6条社团风采
		siteNews.setNewsType("3");
		Page<SiteNews> pageFengcai = new Page<SiteNews>();
		page.setPageSize(6);
		pageFengcai = siteNewsService.page(siteNews, pageFengcai);
		request.setAttribute("pageFengcai", pageFengcai);
		//查出所有的推荐活动
		siteNews.setNewsType("2");
		siteNews.setIsRun("1");
		List<SiteNews> findAll = siteNewsService.findAll(siteNews);
		request.setAttribute("runNews", findAll);
		request.getRequestDispatcher("/front/index.jsp").forward(request, response);
	}
	
	//form跳转页面
	private void login(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		String loginName = request.getParameter("loginName");
		String loginPassword = request.getParameter("loginPassword");
		Student student = new Student();
		student.setLoginName(loginName);
		student.setLoginPassword(loginPassword);
		List<Student> findAll = studentService.findAll(student);
		if (findAll!=null && findAll.size()==1) {
			student = findAll.get(0);
			request.getSession().setAttribute("flogin", student);
			response.sendRedirect(contextPath+"/f");
		}else{
			request.setAttribute("loginPassword", loginPassword);
			request.setAttribute("msg", "登录失败");
			request.getRequestDispatcher("/front/login.jsp").forward(request, response);
        //判断上传文件的保存目录是否存在
        if (!file.exists() && !file.isDirectory()) {
            System.out.println(savePath+"目录不存在,需要创建");
            //创建目录
            file.mkdir();
        }
        //消息提示
        String msg = "";
        try{
            //使用Apache文件上传组件处理文件上传步骤:
            //1、创建一个DiskFileItemFactory工厂
            DiskFileItemFactory factory = new DiskFileItemFactory();
            //2、创建一个文件上传解析器
            ServletFileUpload upload = new ServletFileUpload(factory);
             //解决上传文件名的中文乱码
            upload.setHeaderEncoding("UTF-8"); 
            //3、判断提交上来的数据是否是上传表单的数据
            if(!ServletFileUpload.isMultipartContent(request)){
                //按照传统方式获取数据
                return;
            }
            //4、使用ServletFileUpload解析器解析上传数据,解析结果返回的是一个List<FileItem>集合,每一个FileItem对应一个Form表单的输入项
            List<FileItem> list = upload.parseRequest(request);
            for(FileItem item : list){
                //如果fileitem中封装的是普通输入项的数据
                if(item.isFormField()){
                    String name = item.getFieldName();
                     //解决普通输入项的数据的中文乱码问题
					if ("id".endsWith(name)) {
                    	if (item.getString("UTF-8")!=null && item.getString("UTF-8")!="") {
                    		menu.setId(item.getString("UTF-8"));
						}
					}
					if ("name".endsWith(name)) {
						menu.setName(item.getString("UTF-8"));
					}
					if ("href".endsWith(name)) {
						menu.setHref(item.getString("UTF-8"));
					}
					if ("target".endsWith(name)) {
					}
                    
                }else{//如果fileitem中封装的是上传文件
                    //得到上传的文件名称,
                    String filename = item.getName();
                    System.out.println(filename);
                    if(filename==null || filename.trim().equals("")){
                        continue;
                    }
                    //注意:不同的浏览器提交的文件名是不一样的,有些浏览器提交上来的文件名是带有路径的,如:  c:\a\b\1.txt,而有些只是单纯的文件名,如:1.txt
                    //处理获取到的上传文件的文件名的路径部分,只保留文件名部分
                    filename = filename.substring(filename.lastIndexOf("\\")+1);
                    //获取item中的上传文件的输入流
                    InputStream in = item.getInputStream();
                    //创建一个文件输出流
                    FileOutputStream out = new FileOutputStream(savePath + "\\" + filename);
                    //创建一个缓冲区
                    byte buffer[] = new byte[1024];
                    //判断输入流中的数据是否已经读完的标识
                    int len = 0;
                    //循环将输入流读入到缓冲区当中,(len=in.read(buffer))>0就表示in里面还有数据
                    while((len=in.read(buffer))>0){
                        //使用FileOutputStream输出流将缓冲区的数据写入到指定的目录(savePath + "\\" + filename)当中
                        out.write(buffer, 0, len);
                    }
                    //关闭输入流
                    in.close();
                    //关闭输出流
                    out.close();
                    //删除处理文件上传时生成的临时文件
                    item.delete();
 					msg = "文件上传成功!";
                    
                    student.setPic(request.getContextPath()+"/upload" + "/" + filename);
                }
            }
            if (student.getId()!=null && !"".equals(student.getId())) {
    			studentService.update(student);
    		}else{
    			studentService.add(student);
    		}
    		response.sendRedirect(contextPath+"/student?method=list");
        }catch (Exception e) {
            msg= "文件上传失败!";
            e.printStackTrace();
            request.setAttribute("msg",msg);
            request.getRequestDispatcher("/views/team/studentForm.jsp").forward(request, response);
        }
		}else if ("update".equals(method)) {
			update(request, response);
		}else if ("form".equals(method)) {
			form(request, response);
		}else if ("save".equals(method)) {
			save(request, response);
		}
		
	}
	
	//添加
	private void add(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		
		String contextPath = request.getServletContext().getContextPath();

		String roleName = request.getParameter("roleName");
		String roleFlag = request.getParameter("roleFlag");
		String introduce = request.getParameter("introduce");
		Role role = new Role();
		role.setRoleName(roleName);
		role.setRoleFlag(roleFlag);
		role.setIntroduce(introduce);
		roleService.add(role);
		response.sendRedirect(contextPath+"/role?method=list");
	}
	
	//添加保存
	protected void save(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		String contextPath = request.getServletContext().getContextPath();
		
		Role role = new Role();
		 //得到上传文件的保存目录,将上传的文件存放于WEB-INF目录下,不允许外界直接访问,保证上传文件的安全
        String savePath = this.getServletContext().getRealPath("/upload");
        File file = new File(savePath);
        //判断上传文件的保存目录是否存在
        if (!file.exists() && !file.isDirectory()) {
            System.out.println(savePath+"目录不存在,需要创建");
            //创建目录
            file.mkdir();
        }
        //消息提示
        String msg = "";
        try{
            //使用Apache文件上传组件处理文件上传步骤:
            //1、创建一个DiskFileItemFactory工厂
                    //得到上传的文件名称,
                    String filename = item.getName();
                    System.out.println(filename);
                    if(filename==null || filename.trim().equals("")){
                        continue;
                    }
                    //注意:不同的浏览器提交的文件名是不一样的,有些浏览器提交上来的文件名是带有路径的,如:  c:\a\b\1.txt,而有些只是单纯的文件名,如:1.txt
                    //处理获取到的上传文件的文件名的路径部分,只保留文件名部分
                    filename = filename.substring(filename.lastIndexOf("\\")+1);
                    //获取item中的上传文件的输入流
                    InputStream in = item.getInputStream();
                    //创建一个文件输出流
                    FileOutputStream out = new FileOutputStream(savePath + "\\" + filename);
                    //创建一个缓冲区
                    byte buffer[] = new byte[1024];
                    //判断输入流中的数据是否已经读完的标识
                    int len = 0;
                    //循环将输入流读入到缓冲区当中,(len=in.read(buffer))>0就表示in里面还有数据
                    while((len=in.read(buffer))>0){
                        //使用FileOutputStream输出流将缓冲区的数据写入到指定的目录(savePath + "\\" + filename)当中
                        out.write(buffer, 0, len);
                    }
                    //关闭输入流
                    in.close();
                    //关闭输出流
                    out.close();
                    //删除处理文件上传时生成的临时文件
                    item.delete();
 					msg = "文件上传成功!";
                    
//                    role.setPic("\\upload" + "\\" + filename);
                }
            }
            if (role.getId()!=null && !"".equals(role.getId())) {
    			roleService.update(role);
    		}else{
    			roleService.add(role);
    		}
    		response.sendRedirect(contextPath+"/role?method=list");
        }catch (Exception e) {
            msg= "文件上传失败!";
            e.printStackTrace();
            request.setAttribute("msg",msg);
            request.getRequestDispatcher("/views/system/roleForm.jsp").forward(request, response);
        }
	}
	
	//删除
	private void delete(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		String contextPath = request.getServletContext().getContextPath();
		String id = request.getParameter("id");
		userService.add(user);
		response.sendRedirect(contextPath+"/user?method=list");
	}
	
	//添加保存
	protected void save(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		String contextPath = request.getServletContext().getContextPath();
		
		User user = new User();
		 //得到上传文件的保存目录,将上传的文件存放于WEB-INF目录下,不允许外界直接访问,保证上传文件的安全
        String savePath = this.getServletContext().getRealPath("/upload");
        File file = new File(savePath);
        //判断上传文件的保存目录是否存在
        if (!file.exists() && !file.isDirectory()) {
            System.out.println(savePath+"目录不存在,需要创建");
            //创建目录
            file.mkdir();
        }
        //消息提示
        String msg = "";
        try{
            //使用Apache文件上传组件处理文件上传步骤:
            //1、创建一个DiskFileItemFactory工厂
            DiskFileItemFactory factory = new DiskFileItemFactory();
            //2、创建一个文件上传解析器
            ServletFileUpload upload = new ServletFileUpload(factory);
             //解决上传文件名的中文乱码
            upload.setHeaderEncoding("UTF-8"); 
            //3、判断提交上来的数据是否是上传表单的数据
            if(!ServletFileUpload.isMultipartContent(request)){
                //按照传统方式获取数据
                return;
            }
            //4、使用ServletFileUpload解析器解析上传数据,解析结果返回的是一个List<FileItem>集合,每一个FileItem对应一个Form表单的输入项
            List<FileItem> list = upload.parseRequest(request);
            for(FileItem item : list){
                //如果fileitem中封装的是普通输入项的数据
                if(item.isFormField()){
                    String name = item.getFieldName();
                     //解决普通输入项的数据的中文乱码问题
					if ("id".endsWith(name)) {

	//跳转到个人中心
	private void userInfo(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		 request.getRequestDispatcher("/front/userInfo.jsp").forward(request, response);
	}

	private void applayBuildTeam(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException   {
		response.setCharacterEncoding("GBK");
		Teams teams = new Teams();
		//上传到服务器硬盘上,保证重启tomcat不会丢失文件
        //获取上传文件的路径
		String savePath = this.getServletContext().getRealPath("/upload");
        File file = new File(savePath);
        //判断上传文件的保存目录是否存在
        if (!file.exists() && !file.isDirectory()) {
            System.out.println(savePath+"目录不存在,需要创建");
            //创建目录
            file.mkdir();
        }
        
        
        //消息提示
        String msg = "";
        try{
            //使用Apache文件上传组件处理文件上传步骤:
            //1、创建一个DiskFileItemFactory工厂
            DiskFileItemFactory factory = new DiskFileItemFactory();
            //2、创建一个文件上传解析器
            ServletFileUpload upload = new ServletFileUpload(factory);
             //解决上传文件名的中文乱码
            upload.setHeaderEncoding("UTF-8"); 
            //3、判断提交上来的数据是否是上传表单的数据
            if(!ServletFileUpload.isMultipartContent(request)){
                //按照传统方式获取数据
                return;
            }
            //4、使用ServletFileUpload解析器解析上传数据,解析结果返回的是一个List<FileItem>集合,每一个FileItem对应一个Form表单的输入项
            List<FileItem> list = upload.parseRequest(request);
            for(FileItem item : list){
                //如果fileitem中封装的是普通输入项的数据
                if(item.isFormField()){
                    String name = item.getFieldName();
                     //解决普通输入项的数据的中文乱码问题
					if ("id".endsWith(name)) {
                    	if (item.getString("UTF-8")!=null && item.getString("UTF-8")!="") {
                    		teams.setId(item.getString("UTF-8"));
						}
					}
					
					if ("teamName".endsWith(name)) {
		request.getRequestDispatcher("/views/team/siteNewsForm.jsp").forward(request, response);
	}
	
}

/**
 * 系统用户控制器servlet
 * @version V1.0
 */
@WebServlet("/user")
public class UserController extends HttpServlet {
	private static final long serialVersionUID = 1L;
	
	UserDao userDao=new UserDao();
	UserService userService = new UserServiceImpl();
	RoleService roleService = new RoleServiceImpl();
	MenuRoleDao menuRoleDao = new MenuRoleDao();
	
		doPost(request, response);
	}
	
	protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		contextPath = request.getServletContext().getContextPath();
		String method = request.getParameter("method");
		if ("add".equals(method)) {
			add(request,response);
		}else if ("delete".equals(method)) {
			delete(request, response);
		}else if ("list".equals(method)) {
			list(request, response);
		}else if ("update".equals(method)) {
			update(request, response);
		}else if ("form".equals(method)) {
			form(request, response);
		}else if ("save".equals(method)) {
			save(request, response);
		}
		
	}
	
	//添加
	private void add(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		String activeId = request.getParameter("activeId");
		String stuId = request.getParameter("stuId");
		String stuName = request.getParameter("stuName");
		String phone = request.getParameter("phone");
		String type = request.getParameter("type");
		String isArrive = request.getParameter("isArrive");
		ActiveStu activeStu = new ActiveStu();
		activeStu.setActiveId(activeId);
		activeStu.setStuId(stuId);
		activeStu.setStuName(stuName);
		activeStu.setPhone(phone);
		activeStu.setType(type);
		activeStu.setIsArrive(isArrive);
		activeStuService.add(activeStu);
		response.sendRedirect(contextPath+"/activeStu?method=list");
	}
	
	//添加保存
               //如果fileitem中封装的是普通输入项的数据
               if(item.isFormField()){
                   String name = item.getFieldName();
                    //解决普通输入项的数据的中文乱码问题
					if ("id".endsWith(name)) {
                   	if (item.getString("UTF-8")!=null && item.getString("UTF-8")!="") {
                   		student.setId(item.getString("UTF-8"));
						}
					}
					
					if ("loginName".endsWith(name)) {
						student.setLoginName(item.getString("UTF-8"));
						for (Student s : studentService.findAll(new Student())) {
							if((s.getLoginName()+"").equals(student.getLoginName())){
								System.out.println(msg="帐号已存在!!!");
								System.out.println(msg);
								System.out.println(msg);
								System.out.println(msg);
								System.out.println(msg);
								throw new RuntimeException(msg);
							}
						}
					}
					
					if ("loginPassword".endsWith(name)) {
						student.setLoginPassword(item.getString("UTF-8"));
						
					}
					
					if ("regitTime".endsWith(name)) {
						student.setRegitTime(new Date());
						
					}
					
					if ("auditType".endsWith(name)) {
						student.setAuditType(item.getString("UTF-8"));
						
					}
					
					if ("stuName".endsWith(name)) {
						student.setStuName(item.getString("UTF-8"));
						
					}
		SiteNews siteNews = new SiteNews();
		siteNews.setIsAudit("1");
		siteNews.setNewsType(newsType);
		Page<SiteNews> page = new Page<SiteNews>();
		page.setPageSize(15);
		Page<SiteNews> leftNews = siteNewsService.page(siteNews, page);
		request.setAttribute("leftNews", leftNews);
		request.getRequestDispatcher("/front/detail.jsp").forward(request, response);
	}
	
	//查看社团详情
	protected void teamDetail(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		String id = request.getParameter("id");
		Teams team = teamsService.getById(id);
		request.setAttribute("team", team);
		//查出所有社团
		Teams teams = new Teams();
		teams.setAuditType("1");
		List<Teams> teamList = teamsService.findAll(teams);
		request.setAttribute("teamList", teamList);
		request.getRequestDispatcher("/front/teamDetail.jsp").forward(request, response);
		
	}
	
	//申请社团
	private void applayLeader(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		Object attribute = request.getSession().getAttribute("flogin");
		if (attribute!=null) {
			Student student = new Student();
			student = (Student) attribute;
			TeamApplay teamApplay = new TeamApplay();
			teamApplay.setApplayStu(student.getId());
			String id = request.getParameter("id");
			teamApplay.setApplayTeam(id);
			teamApplay.setApplayType("0");
			List<TeamApplay> findAll = teamApplayService.findAll(teamApplay);
			if (findAll!=null && findAll.size()>0) {
				response.getWriter().print(2);
			}else{
				teamApplay.setApplayContent("申请做社长!");
				teamApplay.setApplayTime(new Date());
				teamApplay.setApplayType("0");//未审核
				teamApplayService.add(teamApplay);
				response.getWriter().print(3);
			}
		}else{
			response.getWriter().print(1);
		}
	}
				teamApplay.setApplayType("0");//未审核
				teamApplayService.add(teamApplay);
				response.getWriter().print(3);
			}
		}else{
			response.getWriter().print(1);
		}
	}
	
	
	private void applayTeam(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		Object attribute = request.getSession().getAttribute("flogin");
		if (attribute!=null) {
			Student student = new Student();
			student = (Student) attribute;
			TeamApplay teamApplay = new TeamApplay();
			teamApplay.setApplayStu(student.getId());
			String id = request.getParameter("id");
			teamApplay.setApplayTeam(id);
			teamApplay.setApplayType("0");
			List<TeamApplay> findAll = teamApplayService.findAll(teamApplay);
			teamApplay.setApplayType("1");
			List<TeamApplay> findAll1 = teamApplayService.findAll(teamApplay);
			if (findAll!=null && findAll.size()>0) {
				response.getWriter().print(2);
			}else if (findAll1!=null && findAll1.size()>0) {
				response.getWriter().print(3);
			}else{
				teamApplay.setApplayContent("申请加入社团!");
				teamApplay.setApplayTime(new Date());
				teamApplay.setApplayType("0");//未审核
				teamApplayService.add(teamApplay);
				response.getWriter().print(3);
			}
		}else{
			response.getWriter().print(1);
		}
	}
	
	
		if (applayStu != null && applayStu != "") {
			teamApplay.setApplayStu(applayStu);
			request.setAttribute("applayStu", applayStu);
		}
		String applayType = request.getParameter("applayType");
		if (applayType != null && applayType != "") {
			teamApplay.setApplayType(applayType);
			request.setAttribute("applayType", applayType);
		}
		
		//判断提示信息
		Object msg = request.getSession().getAttribute("msg");
		if (msg != null) {
			request.setAttribute("msg", msg.toString());
			request.getSession().removeAttribute("msg");
		}
		
		//根据登录用户查出所有的社团
		User currentUser = CurrentUserUtils.getCurrentUser(request);
		String roleFlag = currentUser.getRole2().getRoleFlag();
		if ("leader".equals(roleFlag)) {
			//如果是社长,查出自己负责的所以社团
			Teams teams = new Teams();
			teams.setBuildStu(currentUser.getId());
			List<Teams> findAll = teamsService.findAll(teams);
			request.setAttribute("teamList", findAll);
			
			StringBuffer stringBuffer = new StringBuffer();
			stringBuffer.append(" and a.applay_team in (");
			for (Teams teams2 : findAll) {
				stringBuffer.append("'"+teams2.getId()+"',");
			}
			stringBuffer.append(" '1')");
			teamApplay.setSqlStr(stringBuffer.toString());
		}else{
			request.setAttribute("teamList", teamsService.findAll(new Teams()));
		}
		
		page = teamApplayService.page(teamApplay, page);
		request.setAttribute("page", page);
		request.getRequestDispatcher("/views/team/teamApplayList.jsp").forward(request, response);
	}
	
	//form跳转页面
	private void form(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		String id = request.getParameter("id");
		TeamApplay teamApplay = new TeamApplay();
		if (id!=null && id!="") {
			teamApplay = teamApplayService.getById(id);
		doPost(request, response);
	}
	
	protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		contextPath = request.getServletContext().getContextPath();
		String method = request.getParameter("method");
		if ("add".equals(method)) {
			add(request,response);
		}else if ("delete".equals(method)) {
			delete(request, response);
		}else if ("list".equals(method)) {
			list(request, response);
		}else if ("update".equals(method)) {
			update(request, response);
		}else if ("form".equals(method)) {
			form(request, response);
		}else if ("save".equals(method)) {
			save(request, response);
		}
		
	}
	
	//添加
	private void add(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		

		String content = request.getParameter("content");
		String createTime = request.getParameter("createTime");
		String createStu = request.getParameter("createStu");
		String auditType = request.getParameter("auditType");
		String replay = request.getParameter("replay");
		String replayTime = request.getParameter("replayTime");
		String replayUser = request.getParameter("replayUser");
		Message message = new Message();
		message.setContent(content);
		message.setCreateStu(createStu);
		message.setAuditType(auditType);
		message.setReplay(replay);
		message.setReplayUser(replayUser);
		messageService.add(message);
		response.sendRedirect(contextPath+"/message?method=list");
	}
	
	//添加保存
	protected void save(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		Message message = new Message();
		 //这是上传到tomcat下,文件容易丢失

请添加图片描述

请添加图片描述
请添加图片描述
请添加图片描述
请添加图片描述
请添加图片描述
请添加图片描述
请添加图片描述
请添加图片描述
请添加图片描述
请添加图片描述
请添加图片描述
请添加图片描述
请添加图片描述
请添加图片描述
请添加图片描述
请添加图片描述
请添加图片描述
请添加图片描述
请添加图片描述
请添加图片描述

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
A. 本留言本采用jsp+javabean+servlet+mysql B. 本系统运行环境: windows/linux+ jdk1.4+resin(或tomcat)+jdbc+mysql 5.0 目录结构如下: 本版本数据库采用的是MYSQL,使用JDBC驱动,所以要求有MYSQL的JDBC的驱动程序;将驱动程序放在lib目录下,将WEB-INF目录下的web.xml文件考到你的发布目录下,web.xml是一些servlet的指向 同时将打包的note.jar文件放在lib目录下 本程序的所有的javabeanservlet类文件在src目录下 3、配置文件 修改本软件的数据库连接的配置文件在classes目录下,其中“isLog=on”代表打开日志功能,如果是“isLog=off”的话就表示关闭日志, logPath=D:\\jsp\\com\\ntsky\\log日志路径,logFile=DBConnectionManager.log,日志名相关的请看db.properties(解释得很详细) 不过注意在windows下和linux下路径稍微有点区别,在linux下文档为logPath=/www/log 表示在/www/log目录下。 请填写好你的URL访问路径,比如你的jsp在你的发布目录的note下,就请将你的SiteBaseURL设置成“SiteBaseURL=http://127.0.0.1:8080/note/” 端口号可以改 注意note后还有个/ 4、 数据库 数据库采用mysql 数据库的源文件在sql下的mysql.txt 对应的在sql下还有一份note.sql,你可以通过mysql –u root –p note<note.sql文件路径还原note数据库(前提是你的数据库先有一个空的数据库名为note的库)。 5、 系统初始话 请先运行note目录下的jspInIt.jsp,进行后台密码的初始话,管理后台的密码进行了MD5加密,降低了了秘密被人盗用的几率 6、 此留言本实现了MVC模式,完全是通过servlet控制数据,而且使用了连接池,一些基本的类也是完全提供,对学习jsp的MVC模式有很大的帮助。
基于jsp+javabean+mysql三层结构的动态购物网站。网站用户接口(即界面)由jsp完成,数据和逻辑处理由beans完成,数据储存由mysql完成。因为beans独立负责处理整个网站的全部数据逻辑运算,所以整个网站的负载量和速度都将大大提高,所以基于这种语言和结构开发的购物系统的优势是其它语言没法比尔的。更重要的是,jsp+bean能够在Apache环境下顺畅地运行,这也是其最大优点之一。这就更进一步保证了网站的稳定性和安全性,而这些,对于一个购物网站来说是非常重要的!这个版本让大家期待已久了,主要做了以下一些修正:1.新增产品站内搜索引擎。2.新增人气商品排行。3.新增热评商品排行。4.新增重点推荐产品。5.删除不太需要的新闻频道。6.修正后台管理的一些Nullpointexception错误。7.新增顾客资料修改。8.新增顾客订单查询。9.新增后台超级用户和订单管理管理,方便物流人员独立处理订单。10.完善了一些购物流程。本程序由“城市WebClub”独立自主开发,你可以对整个商城的版面甚至版权作任意修改,但传播本程序时,请保留本站的说明文件。因为开发一个系统真的很痛苦!由于时间和水平关系,本系统还有很多不足和错误的地方,欢迎大家试用并提出意见。安装====1。把myshop直接上传到你的jsp主机。2。把class里的文件上传到你的jsp主机的class目录。3。分别修改myshop下的config.jsp、class/myshop下的config.java文件。4。把所有mysqldata文件倒入你的数据库。

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值