基于javaweb+mysql的ssm校园心理咨询服务系统(java+ssm+jsp+bootstrap+jquery+mysql)
私信源码获取及调试交流
运行环境
Java≥8、MySQL≥5.7、Tomcat≥8
开发工具
eclipse/idea/myeclipse/sts等均可配置运行
适用
课程设计,大作业,毕业设计,项目练习,学习演示等
功能说明
基于javaweb的SSM校园心理咨询服务系统(java+ssm+jsp+bootstrap+jquery+mysql)
功能介绍
基于SSM校园心理咨询服务平台系统分为学生、教师、管理员三种角色。
用户角色主要包括用户注册、用户登录、在线咨询、心理测试、论坛交流、账户维护等功能;
教师角色主要包括教师登录、文章管理、在线回复等功能;
管理员角色主要包括学生管理、教师管理、试题库管理、测试分类管理、试卷管理、新闻管理、系统介绍管理、会员评论管理、轮播图管理、友情链接管理、后台用户管理等功能;
最后根据详细设计的结果,运用JavaEE技术平台,使用更灵活的B/S开发模式和经典的SSM组合框架实现系统的MVC分层架构,并结合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.是否Maven项目: 否;查看源码目录中是否包含pom.xml;若包含,则为maven项目,否则为非maven项目 6.数据库:MySql 5.7版本;
技术栈
- 后端:Spring SpringMVC MyBatis 2. 前端:JSP+bootstrap+jQuery
使用说明
- 使用IDEA/Eclipse/MyEclipse导入项目,Eclipse/MyEclipse导入时,若为maven项目请选择maven; 若为maven项目,导入成功后请执行maven clean;maven install命令,下载所需jar包; 2. 使用Navicat或者其它工具,在mysql中创建对应名称的数据库,并导入项目的sql文件; 3. 将项目中db.properties配置文件中的数据库配置改为自己的配置 4. 配置tomcat,然后运行项目,输入localhost:8080/xxx 登录
String sex=request.getParameter("sex"); String des=request.getParameter("des"); if (huiyuanSrv.isExist("where accountname='" + accountname + "'")) { request.setAttribute("errormsg", "<label class='error'>用户名已经存在</label>"); dispatchParams(request, response); forward("/e/register.jsp"); } Huiyuan huiyuan = new Huiyuan(); huiyuan.setAccountname(accountname == null ? "" : accountname); huiyuan.setPassword(password == null ? "" : password); //初始支付密码为登录密码 huiyuan.setPaypwd(huiyuan.getPassword()); if(mobile!=null) huiyuan.setMobile(mobile); if(address!=null) huiyuan.setAddress(address); if(sex!=null) huiyuan.setSex(sex); else huiyuan.setSex("男"); huiyuan.setNickname(accountname); huiyuan.setName(name); huiyuan.setRegdate(new Date()); huiyuan.setIdcardno(idcardno==null?"":idcardno); huiyuan.setLogtimes(0); if(touxiang!=null) huiyuan.setTouxiang(touxiang); else huiyuan.setTouxiang(request.getContextPath() + "/upload/nopic.jpg"); huiyuan.setEmail(email == null ? "" : email); huiyuan.setStatus(1); huiyuan.setYue(0); huiyuan.setDes(des==null?"":des); huiyuanSrv.save(huiyuan); String forwardurl=request.getParameter("forwardurl"); if (forwardurl == null) { forwardurl = "/admin/huiyuanmanager.do?actiontype=get"; } redirect(forwardurl); } public void delete() { String[] ids = request.getParameterValues("ids"); if (ids == null)
复制
request.getSession().setAttribute("huiyuan", huiyuan); redirect(forwardurl); } } public void modifyPaypw() { String paypwd=request.getParameter("paypwd"); String errorurl=request.getParameter("errorurl"); String forwardurl=request.getParameter("forwardurl"); String repassword1=request.getParameter("repassword1"); String id = request.getParameter("id"); if (id == null||id=="") return; Huiyuan huiyuan =huiyuanSrv.load(new Integer(id)); if(huiyuan!=null) { if(!huiyuan.getPaypwd().equals(paypwd)){ request.setAttribute("errormsg", "<label class='error'>原始支付密码不正确</label>"); forward(errorurl); return ; } huiyuan.setPaypwd(repassword1); huiyuanSrv.update(huiyuan); request.getSession().setAttribute("huiyuan", huiyuan); redirect(forwardurl); } } public void save() { String accountname = request.getParameter("accountname"); String password = request.getParameter("password"); String name = request.getParameter("name"); String idcardno=request.getParameter("idcardno"); String email = request.getParameter("email"); String mobile=request.getParameter("mobile"); String address=request.getParameter("address"); String touxiang=request.getParameter("touxiang"); String sex=request.getParameter("sex"); String des=request.getParameter("des"); if (huiyuanSrv.isExist("where accountname='" + accountname + "'")) { request.setAttribute("errormsg",
复制
String replytime = request.getParameter("replytime"); String replycontent = request.getParameter("replycontent"); String status = request.getParameter("status"); String lyren = request.getParameter("lyren"); String stname = request.getParameter("stname"); SimpleDateFormat sdfleaveword = new SimpleDateFormat("yyyy-MM-dd"); leaveword.setTitle(title); leaveword.setDcontent(dcontent); if (createtime != null) { try { leaveword.setCreatetime(sdfleaveword.parse(createtime)); } catch (ParseException e) { e.printStackTrace(); } } leaveword.setReplyren(replyren); if (replytime != null) { try { leaveword.setReplytime(sdfleaveword.parse(replytime)); } catch (ParseException e) { e.printStackTrace(); } } leaveword.setReplycontent(replycontent); leaveword.setLyren(lyren); leaveword.setStname(stname); lwSrv.update(leaveword); if (forwardurl == null) { forwardurl = "/admin/leavewordmanager.do?actiontype=get"; } redirect(forwardurl); } /****************************************************** *********************** 加载内部支持********************* *******************************************************/ public void load() { // String id = request.getParameter("id"); String actiontype = "save"; dispatchParams(request, response); if (id != null) { Leaveword leaveword =lwSrv.load("where id=" + id); if (leaveword != null) { request.setAttribute("leaveword", leaveword); } actiontype = "update";
复制
} } shijuan.setStatus("组卷完成"); shijuanSrv.update(shijuan); } redirect(forwardurl); } public void zujuanAuto() { String sjid=request.getParameter("sjid"); String forwardurl=request.getParameter("forwardurl"); String errorurl=request.getParameter("errorurl"); Shijuan shijuan=shijuanSrv.load("where id="+sjid); String danxuancount=request.getParameter("danxuancount"); String danxuanfen=request.getParameter("danxuanfen"); String kemu=request.getParameter("kemu"); int totaldanxuancount=ceshitiSrv.getRecordCount("where kemu='"+kemu+"'"); if(totaldanxuancount<Integer.parseInt(danxuancount)){ request.setAttribute("errormsg", MessageFormat.format("<label class='error'>题库单选题只有{0}道,请加入试题</label>",totaldanxuancount)); forward(errorurl); return; } //加入测试题 randomCeshitiToPaper(danxuancount, danxuanfen, sjid); shijuan.setStatus("组卷完成"); shijuanSrv.update(shijuan); redirect(forwardurl); } /** * 把单选题加入试卷 * @param danxuancount 单选题数目
复制
System.out.println("forwardurl=" + forwardurl); if (forwardurl == null) { forwardurl = "/admin/shoucangmanager.jsp"; } forward(forwardurl); } } @Controller public class TeacherController extends SimpleController { @Override @RequestMapping("/admin/teachermanager.do") public void mapping(HttpServletRequest request, HttpServletResponse response) { mappingMethod(request,response); } public void modifyPw() { String password1 = request.getParameter("password1"); String repassword1 = request.getParameter("repassword1"); String forwardurl = request.getParameter("forwardurl"); String errorpageurl = request.getParameter("errorpageurl"); String id = request.getParameter("id");
复制
} } } @Controller public class NoticeController extends SimpleController { @Autowired private NoticeMapper mapper; @Override @RequestMapping("/admin/noticemanager.do") public void mapping(HttpServletRequest request, HttpServletResponse response) { mappingMethod(request,response); } /******************************************************** ****************** 信息注销监听支持***************************** *********************************************************/ public void delete() { String id = request.getParameter("id"); mapper.delete(" where id=" + id); get(); }
复制
if (forwardurl == null) { forwardurl = "/admin/indexcolumnsmanager.do?actiontype=get"; } redirect(forwardurl); } /****************************************************** *********************** 更新内部支持********************* *******************************************************/ public void update() { String forwardurl = request.getParameter("forwardurl"); String id = request.getParameter("id"); if (id == null) return; Indexcolumns indexcolumns = icSrv.load(new Integer(id)); if (indexcolumns == null) return; String coldes = request.getParameter("coldes"); String colid = request.getParameter("colid"); String xtype = request.getParameter("xtype"); String showstyle = request.getParameter("showstyle"); String layout=request.getParameter("layout"); String width=request.getParameter("width"); indexcolumns.setColdes(coldes); indexcolumns.setColid(colid == null ? 0 : new Integer(colid)); indexcolumns.setXtype(xtype); indexcolumns.setShowstyle(showstyle); indexcolumns.setLayout(layout); indexcolumns.setWidth(width); icSrv.update(indexcolumns); if (forwardurl == null) { forwardurl = "/admin/indexcolumnsmanager.do?actiontype=get"; } redirect(forwardurl); } /****************************************************** *********************** 加载内部支持********************* *******************************************************/ public void load() { // String id = request.getParameter("id"); String actiontype = "save"; dispatchParams(request, response); if (id != null) {
复制
List<Topic> listtopic = topicSrv.getPageEntitys(filter, pageindex, pagesize); int recordscount = topicSrv.getRecordCount(filter == null ? "" : filter); request.setAttribute("listtopic", listtopic); PagerMetal pm = new PagerMetal(recordscount); // 设置尺寸 pm.setPagesize(pagesize); // 设置当前显示页 pm.setCurpageindex(pageindex); // 设置分页信息 request.setAttribute("pagermetal", pm); // 分发请求参数 dispatchParams(request, response); String forwardurl = request.getParameter("forwardurl"); System.out.println("forwardurl=" + forwardurl); if (forwardurl == null) { forwardurl = "/admin/topicmanager.jsp"; } try { request.getRequestDispatcher(forwardurl).forward(request, response); } catch (ServletException e) { // TODO Auto-generated catch block e.printStackTrace(); } catch (IOException e) { // TODO Auto-generated catch block e.printStackTrace(); } } }
复制
/************************************************************* **************** 保存动作监听支持****************************** **************************************************************/ public void save() { String forwardurl = request.getParameter("forwardurl"); // 验证错误url String suzuid=request.getParameter("suzuid"); String errorurl = request.getParameter("errorurl"); String xtype=request.getParameter("xtype"); if(suzuid!=null) { Lanmu temspc=lanmuSrv.load("where id="+suzuid); if(temspc!=null&&xtype!=null&&xtype.equals("1")) { Indexcolumns indexcolumns = new Indexcolumns(); indexcolumns.setColdes(temspc.getTitle()); indexcolumns.setColid(temspc.getId()); indexcolumns.setXtype("资讯"); indexcolumns.setShowstyle("图片"); indexcolumns.setLayout("1"); indexcolumns.setWidth("100%"); icSrv.save(indexcolumns); } } if (forwardurl == null) { forwardurl = "/admin/indexcolumnsmanager.do?actiontype=get"; } redirect(forwardurl); } /****************************************************** *********************** 更新内部支持********************* *******************************************************/ public void update() { String forwardurl = request.getParameter("forwardurl"); String id = request.getParameter("id"); if (id == null) return; Indexcolumns indexcolumns = icSrv.load(new Integer(id)); if (indexcolumns == null) return; String coldes = request.getParameter("coldes");
复制
request.setAttribute("pagermetal", pm); // 分发请求参数 dispatchParams(request, response); String forwardurl = request.getParameter("forwardurl"); System.out.println("forwardurl=" + forwardurl); if (forwardurl == null) { forwardurl = "/admin/shijuanmanager.jsp"; } forward(forwardurl); } public void waitExampaper() { String filter=""; String stno=request.getParameter("stno"); String title=request.getParameter("title"); if(stno!=null) filter+=" and stno='"+stno+"'"; if(title!=null) filter+=" and title='"+title+"'"; String nativateSql=" select sj.* from shijuan sj where sj.status='组卷完成' "; List<Shijuan> listshijuan = shijuanSrv.query(nativateSql); request.setAttribute("listshijuan", listshijuan); // 分发请求参数 dispatchParams(request, response); String forwardurl = request.getParameter("forwardurl"); System.out.println("forwardurl=" + forwardurl); if (forwardurl == null) { forwardurl = "/admin/shijuanmanager.jsp"; } forward(forwardurl); } @Autowired private ShijuanService shijuanSrv=null; @Autowired private DajuanService dajuanSrv=null; @Autowired private DajuanitemService djiSrv=null; @Autowired private CeshitiService ceshitiSrv=null;
复制
filter += " and scren='" + scren + "' "; int pageindex = 1; int pagesize = 10; // 获取当前分页 String currentpageindex = request.getParameter("currentpageindex"); // 当前页面尺寸 String currentpagesize = request.getParameter("pagesize"); // 设置当前页 if (currentpageindex != null) pageindex = new Integer(currentpageindex); // 设置当前页尺寸 if (currentpagesize != null) pagesize = new Integer(currentpagesize); List<Shoucang> listshoucang =scSrv.getPageEntitys(filter,pageindex, pagesize); int recordscount = scSrv.getRecordCount(filter == null ? "" : filter); request.setAttribute("listshoucang", listshoucang); PagerMetal pm = new PagerMetal(recordscount); // 设置尺寸 pm.setPagesize(pagesize); // 设置当前显示页 pm.setCurpageindex(pageindex); // 设置分页信息 request.setAttribute("pagermetal", pm); // 分发请求参数 dispatchParams(request, response); String forwardurl = request.getParameter("forwardurl"); System.out.println("forwardurl=" + forwardurl); if (forwardurl == null) { forwardurl = "/admin/shoucangmanager.jsp"; } forward(forwardurl); } }
复制
String shijuanid=request.getParameter("sjid"); String tihao=request.getParameter("tihao"); String forwardurl=request.getParameter("forwardurl"); Shijuanitem sji=new Shijuanitem(); String tixing=request.getParameter("tixing"); if(tixing!=null&&tixing.equals("1")){ tixing="单选题"; } if(shijuanid!=null&&tihao!=null){ sjiSrv.delete(MessageFormat.format("where tihao={0} and shijuanid={1} and tixing=''{2}'' ",tihao,shijuanid,tixing)); } redirect(forwardurl); } /** * 组卷 完成 * */ public void zujuanOver() { String sjid=request.getParameter("sjid"); String forwardurl=request.getParameter("forwardurl"); Shijuan shijuan=shijuanSrv.load("where id="+sjid); String[] shitiids = request.getParameterValues("tihaolist"); if(shijuan!=null){ if (shitiids != null) { for (String shitiid : shitiids) { Shijuanitem shijuanitem =sjiSrv.load(MessageFormat.format("where id={0} ", shitiid)); //获取试题分数 String fenshu = request.getParameter(shitiid); if(shijuanitem!=null){ shijuanitem.setFenshu(Integer.parseInt(fenshu)); sjiSrv.update(shijuanitem);
复制
String zujuanren = request.getParameter("zujuanren"); String kemu = request.getParameter("kemu"); String dajuanren = request.getParameter("dajuanren"); String shijuanid = request.getParameter("shijuanid"); String defen = request.getParameter("defen"); SimpleDateFormat sdfdajuan = new SimpleDateFormat("yyyy-MM-dd"); Dajuan dajuan = new Dajuan(); dajuan.setTitle(title == null ? "" : title); dajuan.setZujuanren(zujuanren == null ? "" : zujuanren); dajuan.setKemu(kemu == null ? "" : kemu); dajuan.setDajuanren(dajuanren == null ? "" : dajuanren); dajuan.setShijuanid(shijuanid == null ? "" : shijuanid); dajuan.setDefen(defen == null ? 0 : new Integer(defen)); dajuanSrv.save(dajuan); if (forwardurl == null) { forwardurl = "/admin/dajuanmanager.do?actiontype=get"; } redirect(forwardurl); } /****************************************************** *********************** 更新内部支持********************* *******************************************************/ public void update() { String forwardurl = request.getParameter("forwardurl"); String id = request.getParameter("id"); if (id == null) return; Dajuan dajuan = dajuanSrv.load(new Integer(id)); if (dajuan == null) return; String title = request.getParameter("title"); String zujuanren = request.getParameter("zujuanren"); String kemu = request.getParameter("kemu"); String dajuanren = request.getParameter("dajuanren"); String shijuanid = request.getParameter("shijuanid"); String defen = request.getParameter("defen"); SimpleDateFormat sdfdajuan = new SimpleDateFormat("yyyy-MM-dd"); dajuan.setTitle(title); dajuan.setZujuanren(zujuanren); dajuan.setKemu(kemu); dajuan.setDajuanren(dajuanren); dajuan.setShijuanid(shijuanid); dajuan.setDefen(defen == null ? 0 : new Integer(defen)); dajuanSrv.update(dajuan); if (forwardurl == null) { forwardurl = "/admin/dajuanmanager.do?actiontype=get"; }
复制
forwardurl = "/admin/shijuanmanager.do?actiontype=get"; } redirect(forwardurl); } /****************************************************** *********************** 更新内部支持********************* *******************************************************/ public void update() { String forwardurl = request.getParameter("forwardurl"); String id = request.getParameter("id"); if (id == null) return; Shijuan shijuan =shijuanSrv.load(new Integer(id)); if (shijuan == null) return; String title = request.getParameter("title"); String zujuanren = request.getParameter("zujuanren"); String zongfen = request.getParameter("zongfen"); String kmid=request.getParameter("kmid"); String kemu = request.getParameter("kemu"); String des = request.getParameter("des"); String tupian=request.getParameter("tupian"); SimpleDateFormat sdfshijuan = new SimpleDateFormat("yyyy-MM-dd"); shijuan.setTitle(title); shijuan.setZujuanren(zujuanren); shijuan.setKmid(kmid==null?0:Integer.parseInt(kmid)); shijuan.setZongfen(zongfen == null ? 0 : new Integer(zongfen)); shijuan.setKemu(kemu); shijuan.setTupian(tupian==null?"":tupian); shijuan.setDes(des); shijuanSrv.update(shijuan); if (forwardurl == null) { forwardurl = "/admin/shijuanmanager.do?actiontype=get"; } redirect(forwardurl); } /****************************************************** *********************** 加载内部支持********************* *******************************************************/
复制
return; String title = request.getParameter("title"); String commenttime = request.getParameter("commenttime"); String commentren = request.getParameter("commentren"); String commentcontent = request.getParameter("commentcontent"); String xtype = request.getParameter("xtype"); String belongid = request.getParameter("belongid"); SimpleDateFormat sdfcomment = new SimpleDateFormat("yyyy-MM-dd"); comment.setCommentren(commentren); comment.setCommentcontent(commentcontent); comment.setXtype(xtype); comment.setBelongid(belongid); commentSrv.update(comment); String forwardurl = request.getParameter("forwardurl"); redirect(forwardurl); } /****************************************************** *********************** 加载内部支持********************* *******************************************************/ public void load() { // String id = request.getParameter("id"); String actiontype = "save"; if (id != null) { Comment comment = commentSrv.load( "where id="+ id); if (comment != null) { request.setAttribute("comment", comment); } actiontype = "update"; } request.setAttribute("id", id); request.setAttribute("actiontype", actiontype); try { request.getRequestDispatcher("commentadd.jsp").forward(request, response); } catch (ServletException e) { // TODO Auto-generated catch block e.printStackTrace(); } catch (IOException e) { // TODO Auto-generated catch block e.printStackTrace(); } } /****************************************************** *********************** 数据绑定内部支持*********************
复制
redirect(forwardurl); } public void load(){ String id = request.getParameter("id"); String actiontype = "save"; if (id != null) { Users users = (Users) usersService.load(new Integer(id)); if (users != null) { request.setAttribute("users", users); } actiontype = "update"; } request.setAttribute("id", id); request.setAttribute("actiontype", actiontype); String forwardurl=request.getParameter("forwardurl"); if (forwardurl == null) { forwardurl = "/admin/usersadd.jsp"; } forward(forwardurl); } public void delete() { String id = request.getParameter("id"); usersService.delete(" where id=" + id); get(); } public void get(){ int pageindex = 1; int pagesize = 10; String filter=""; // 获取当前分页 String currentpageindex = request.getParameter("currentpageindex"); // 当前页面尺寸 String currentpagesize = request.getParameter("pagesize"); // 设置当前页 if (currentpageindex != null) pageindex = new Integer(currentpageindex); // 设置当前页尺寸 if (currentpagesize != null) pagesize = new Integer(currentpagesize); List<Users> usersList=usersService.getPageEntitys(filter,pageindex,pagesize); int recordscount = usersService.getRecordCount(filter); request.setAttribute("usersList", usersList);
复制
teacher.setMobile(mobile); teacher.setLvli(lvli); teacherSrv.update(teacher); if (forwardurl == null) { forwardurl = "/admin/teachermanager.do?actiontype=get"; } redirect(forwardurl); } /****************************************************** *********************** 加载内部支持********************* *******************************************************/ public void load() { // String id = request.getParameter("id"); String actiontype = "save"; String forwardurl = request.getParameter("forwardurl"); dispatchParams(request, response); if (id != null) { Teacher teacher = teacherSrv.load("where id=" + id); if (teacher != null) { request.setAttribute("teacher", teacher); } actiontype = "update"; request.setAttribute("id", id); } request.setAttribute("actiontype", actiontype); if (forwardurl == null) { forwardurl = "/admin/teacheradd.jsp"; } forward(forwardurl); } /****************************************************** *********************** 数据绑定内部支持********************* *******************************************************/ public void get() { String filter = "where 1=1 "; //
复制
/****************************************************** *********************** 更新内部支持********************* *******************************************************/ public void update() { String id = request.getParameter("id"); String forwardurl=request.getParameter("forwardurl"); if (id == null) return; Notice notice =mapper.selectOne(new Integer(id)); if (notice == null) return; String title = request.getParameter("title"); String pubren = request.getParameter("pubren"); String pubtime = request.getParameter("pubtime"); String dcontent = request.getParameter("dcontent"); SimpleDateFormat sdfnotice = new SimpleDateFormat("yyyy-MM-dd"); notice.setTitle(title); notice.setPubren(pubren); notice.setPubtime(new Date()); notice.setDcontent(dcontent); mapper.update(notice); if(forwardurl==null) forwardurl="/admin/noticemanager.do?actiontype=get"; redirect(forwardurl); } /****************************************************** *********************** 加载内部支持********************* *******************************************************/ public void load() { // String id = request.getParameter("id"); String actiontype = "save"; if (id != null) { Notice notice = mapper.load("where id=" + id); if (notice != null) { request.setAttribute("notice", notice); } actiontype = "update"; } request.setAttribute("id", id); request.setAttribute("actiontype", actiontype);
复制