基于javaweb+mysql的ssm校园心理咨询服务系统(java+ssm+jsp+bootstrap+jquery+mysql)
私信源码获取及调试交流
运行环境
Java≥8、MySQL≥5.7、Tomcat≥8
开发工具
eclipse/idea/myeclipse/sts等均可配置运行
适用
课程设计,大作业,毕业设计,项目练习,学习演示等
功能说明
基于javaweb+mysql的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 登录
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);
PagerMetal pm = new PagerMetal(recordscount);
// 设置尺寸
pm.setPagesize(pagesize);
// 设置当前显示页
pm.setCurpageindex(pageindex);
// 设置分页信息
request.setAttribute("pagermetal", pm);
try {
request.getRequestDispatcher("/admin/usersmanager.jsp").forward(request,response);
} catch (ServletException | IOException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
int recordscount = teacherSrv.getRecordCount(filter == null ? "" : filter);
request.setAttribute("listteacher", listteacher);
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/teachermanager.jsp";
}
forward(forwardurl);
}
@Autowired
private TeacherService teacherSrv=null;
}
String forwardurl = request.getParameter("forwardurl");
System.out.println("forwardurl=" + forwardurl);
if (forwardurl == null) {
forwardurl = "/admin/indexcolumnsmanager.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();
}
}
}
@Controller
public class CeshitiController extends SimpleController {
@Override
@RequestMapping("/admin/ceshitimanager.do")
public void mapping(HttpServletRequest request, HttpServletResponse response) {
mappingMethod(request,response);
}
public void delete() {
xinxi.setDcontent(dcontent);
xinxi.setHot(hot!=null?1:0);
xinxi.setTuijian(tuijian!=null?1:0);
xinxi.setZuixin(zuixin!=null?1:0);
xinxi.setTupian2(tupian2);
xinxi.setLanmuid(new Integer(lanmuid));
xinxi.setLanmuming(lanmuming);
xinxiSrv.update(xinxi);
String forwardurl = request.getParameter("forwardurl");
if (forwardurl == null) {
forwardurl = "/admin/xinximanager.do?actiontype=get";
}
try {
response.sendRedirect(request.getContextPath() + forwardurl);
} catch (Exception e) {
e.printStackTrace();
}
}
/******************************************************
*********************** 加载内部支持*********************
*******************************************************/
public void load() {
//
String id = request.getParameter("id");
String actiontype = "save";
String style=request.getParameter("style");
if (id != null) {
Xinxi xinxi = xinxiSrv.load("where id=" + id);
if (xinxi != null) {
request.setAttribute("xinxi", xinxi);
}
actiontype = "update";
}
request.setAttribute("id", id);
request.setAttribute("actiontype", actiontype);
String forwardurl = request.getParameter("forwardurl");
System.out.println("forwardurl=" + forwardurl);
if (forwardurl == null) {
forwardurl = "/admin/xinxiadd.jsp";
}
@RequestMapping("/admin/topicmanager.do")
public void mapping(HttpServletRequest request, HttpServletResponse response) {
mappingMethod(request,response);
}
/********************************************************
****************** 信息注销监听支持*****************************
*********************************************************/
public void delete() {
String id = request.getParameter("id");
topicSrv.delete(" where id=" + id);
get();
}
/*************************************************************
**************** 保存动作监听支持******************************
**************************************************************/
public void save() {
String forwardurl = request.getParameter("forwardurl");
// 验证错误url
String errorurl = request.getParameter("errorurl");
String title = request.getParameter("title");
String pubren = request.getParameter("pubren");
String pubtime = request.getParameter("pubtime");
String bkid = request.getParameter("bkid");
String bkname = request.getParameter("bkname");
String fee=request.getParameter("fee");
String clickcount = request.getParameter("clickcount");
String istopic = request.getParameter("istopic");
String lastreplyor = request.getParameter("lastreplyor");
String lastreplytime = request.getParameter("lastreplytime");
String replycount = request.getParameter("replycount");
String replyid = request.getParameter("replyid");
String tupian=request.getParameter("tupian");
String dcontent = request.getParameter("dcontent");
SimpleDateFormat sdftopic = new SimpleDateFormat("yyyy-MM-dd");
Topic topic = new Topic();
topic.setTitle(title == null ? "" : title);
topic.setPubren(pubren == null ? "" : pubren);
if (pubtime != null) {
try {
topic.setPubtime(sdftopic.parse(pubtime));
} catch (ParseException e) {
e.printStackTrace();
}
} else {
topic.setPubtime(new Date());
}
topic.setBkid(bkid == null ? 0 : new Integer(bkid));
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";
request.setAttribute("id", id);
}
request.setAttribute("actiontype", actiontype);
String forwardurl = request.getParameter("forwardurl");
System.out.println("forwardurl=" + forwardurl);
if (forwardurl == null) {
forwardurl = "/admin/leavewordadd.jsp";
}
forward(forwardurl);
}
/******************************************************
}
/********************************************************
****************** 信息注销监听支持*****************************
*********************************************************/
public void delete() {
String id = request.getParameter("id");
scSrv.delete(" where id=" + id);
get();
}
/*************************************************************
**************** 保存动作监听支持******************************
**************************************************************/
public void save() {
String forwardurl = request.getParameter("forwardurl");
// 验证错误url
String errorurl = request.getParameter("errorurl");
String bookid = request.getParameter("bookid");
String bookname = request.getParameter("bookname");
String tupian = request.getParameter("tupian");
String scren = request.getParameter("scren");
String sctime = request.getParameter("sctime");
String href = request.getParameter("href");
SimpleDateFormat sdfshoucang = new SimpleDateFormat("yyyy-MM-dd");
Shoucang shoucang = new Shoucang();
shoucang.setBookid(bookid == null ? 0 : new Integer(bookid));
shoucang.setBookname(bookname == null ? "" : bookname);
shoucang.setTupian(tupian == null ? "" : tupian);
shoucang.setScren(scren == null ? "" : scren);
if (sctime != null) {
try {
shoucang.setSctime(sdfshoucang.parse(sctime));
} catch (ParseException e) {
e.printStackTrace();
}
} else {
shoucang.setSctime(new Date());
}
shoucang.setHref(href==null?"":href);
// 产生验证
Boolean validateresult = saveValidate(MessageFormat.format(
"where bookid=''{0}'' and scren=''{1}'' ", bookid, scren));
if (validateresult) {
// 设置当前页尺寸
if (currentpagesize != null)
pagesize = new Integer(currentpagesize);
List<Comment> listcomment = commentSrv.getPageEntitys(filter,pageindex, pagesize);
int recordscount = commentSrv.getRecordCount(filter == null ? "" : filter);
request.setAttribute("listcomment", listcomment);
PagerMetal pm = new PagerMetal(recordscount);
// 设置尺寸
pm.setPagesize(pagesize);
// 设置当前显示页
pm.setCurpageindex(pageindex);
// 设置分页信息
request.setAttribute("pagermetal", pm);
// 分发请求参数
dispatchParams(request, response);
try {
request.getRequestDispatcher("/admin/commentmanager.jsp").forward(
request, response);
} catch (ServletException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (IOException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
@Controller
*******************************************************/
public void get() {
String filter = "where 1=1 ";
//
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<Dajuanitem> listdajuanitem = djiSrv.getPageEntitys(filter, pageindex, pagesize);
int recordscount = djiSrv.getRecordCount(filter == null ? "" : filter);
request.setAttribute("listdajuanitem", listdajuanitem);
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/dajuanitemmanager.jsp";
}
forward(forwardurl);
}
@Autowired
private DajuanitemService djiSrv=null;
}
@Autowired
private ShijuanitemService sjiSrv=null;
@Autowired
private KechengService kechengSrv=null;
}
@Controller
public class XinxiController extends SimpleController {
@Autowired
private XinxiService xinxiSrv=null;
@Override
@RequestMapping("/admin/xinximanager.do")
public void mapping(HttpServletRequest request, HttpServletResponse response) {
mappingMethod(request,response);
}
public void agree() {
String id=request.getParameter("id");
if (id == null)
return;
Xinxi xinxi = (Xinxi)xinxiSrv.load(new Integer(id));
if (xinxi == null)
return;
xinxi.setAgreecount(xinxi.getAgreecount()+1);
xinxiSrv.update(xinxi);
try {
response.getWriter().write(new Integer(xinxi.getAgreecount()).toString());
} catch (IOException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
public void against() {
scSrv.save(shoucang);
if (forwardurl == null) {
forwardurl = "/admin/shoucangmanager.do?actiontype=get";
}
try {
request.setAttribute("sctip",
"<i class='fa fa-check'></i>成功收藏该信息");
request.getRequestDispatcher(forwardurl).forward(request, response);
} catch (Exception e) {
e.printStackTrace();
}
}
// 新增验证
private boolean saveValidate(String filter) {
return scSrv.isExist(filter);
}
/******************************************************
*********************** 更新内部支持*********************
*******************************************************/
public void update() {
String forwardurl = request.getParameter("forwardurl");
String id = request.getParameter("id");
if (id == null)
return;
Shoucang shoucang = (Shoucang)scSrv.load(new Integer(id));
if (shoucang == null)
return;
String bookid = request.getParameter("bookid");
String bookname = request.getParameter("bookname");
String tupian = request.getParameter("tupian");
String scren = request.getParameter("scren");
String sctime = request.getParameter("sctime");
String href = request.getParameter("href");
SimpleDateFormat sdfshoucang = new SimpleDateFormat("yyyy-MM-dd");
shoucang.setBookid(bookid == null ? 0 : new Integer(bookid));
return;
Huiyuan huiyuan = huiyuanSrv.load(new Integer(id));
if (huiyuan == null)
return;
String accountname = request.getParameter("accountname");
String nickname = request.getParameter("nickname");
String forwardurl = request.getParameter("forwardurl");
String touxiang = request.getParameter("touxiang");
String email = request.getParameter("email");
String mobile = request.getParameter("mobile");
String sex = request.getParameter("sex");
String address = request.getParameter("address");
String name = request.getParameter("name");
String idcardno=request.getParameter("idcardno");
if(accountname!=null)
huiyuan.setAccountname(accountname);
huiyuan.setNickname(nickname==null?"":nickname);
huiyuan.setTouxiang(touxiang==null?"":touxiang);
huiyuan.setEmail(email==null?"":email);
huiyuan.setMobile(mobile==null?"":mobile);
huiyuan.setIdcardno(idcardno==null?"":idcardno);
huiyuan.setSex(sex==null?"":sex);
huiyuan.setAddress(address==null?"":address);
huiyuan.setName(name==null?"":name);
huiyuanSrv.update(huiyuan);
request.getSession().setAttribute("huiyuan", huiyuan);
if (forwardurl == null) {
forwardurl = "/admin/huiyuanmanager.do?actiontype=get";
}
redirect(forwardurl);
}
public void modifyPw() {
String password=request.getParameter("password");
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.getPassword().equals(password)){
request.setAttribute("errormsg",
"<label class='error'>原始密码不正确</label>");
dispatchParams(request, response);
@Controller
public class ShijuanController extends SimpleController {
@Override
@RequestMapping("/admin/shijuanmanager.do")
public void mapping(HttpServletRequest request, HttpServletResponse response) {
mappingMethod(request,response);
}
public void exam() {
String sjid = request.getParameter("sjid");
String kemu = request.getParameter("kemu");
String title = request.getParameter("title");
String dajuanren = request.getParameter("dajuanren");
String stname = request.getParameter("stname");
String forwardurl = request.getParameter("forwardurl");
String[] shitiids = request.getParameterValues("tihaolist");
Dajuan dajuan = new Dajuan();
String choiceb = request.getParameter("choiceb");
String choicec = request.getParameter("choicec");
String choiced = request.getParameter("choiced");
String kmid = request.getParameter("kmid");
String daan = request.getParameter("daan");
String kemu = request.getParameter("kemu");
SimpleDateFormat sdfceshiti = new SimpleDateFormat("yyyy-MM-dd");
ceshiti.setTitle(title);
ceshiti.setChoicea(choicea);
ceshiti.setChoiceb(choiceb);
ceshiti.setChoicec(choicec);
ceshiti.setChoiced(choiced);
ceshiti.setDaan(daan);
ceshiti.setKmid(kmid == null ? 0 : Integer.parseInt(kmid));
ceshiti.setKemu(kemu);
ceshitiSrv.update(ceshiti);
if (forwardurl == null) {
forwardurl = "/admin/ceshitimanager.do?actiontype=get";
}
redirect(forwardurl);
}
/******************************************************
*********************** 加载内部支持*********************
*******************************************************/
public void load() {
//
String id = request.getParameter("id");
String actiontype = "save";
dispatchParams(request, response);
if (id != null) {
Ceshiti ceshiti =ceshitiSrv.load("where id="+ id);
if (ceshiti != null) {
request.setAttribute("ceshiti", ceshiti);
}
actiontype = "update";
request.setAttribute("id", id);
}
request.setAttribute("actiontype", actiontype);
List<Object> kemu_datasource = kechengSrv.getEntity("");
request.setAttribute("kemu_datasource", kemu_datasource);
String forwardurl = request.getParameter("forwardurl");
System.out.println("forwardurl=" + forwardurl);
if (forwardurl == null) {
forwardurl = "/admin/ceshitiadd.jsp";
} catch (ParseException e) {
e.printStackTrace();
}
} else {
topic.setPubtime(new Date());
}
topic.setBkid(bkid == null ? 0 : new Integer(bkid));
topic.setBkname(bkname == null ? "" : bkname);
topic.setClickcount(clickcount == null ? 0 : new Integer(clickcount));
topic.setIstopic(istopic == null ? 0 : new Integer(istopic));
topic.setLastreplyor(lastreplyor == null ? "" : lastreplyor);
if (lastreplytime != null) {
try {
topic.setLastreplytime(sdftopic.parse(lastreplytime));
} catch (ParseException e) {
e.printStackTrace();
}
} else {
topic.setLastreplytime(new Date());
}
topic.setTupian(tupian==null?"":tupian);
if(fee!=null)
topic.setFee(Integer.parseInt(fee));
else
topic.setFee(0);
topic.setReplycount(replycount == null ? 0 : new Integer(replycount));
topic.setReplyid(replyid == null ? 0 : new Integer(replyid));
topic.setDcontent(dcontent == null ? "" : dcontent);
topicSrv.save(topic);
if (forwardurl == null) {
forwardurl = "/admin/topicmanager.do?actiontype=get";
}
redirect(forwardurl);
}
/******************************************************
*********************** 更新内部支持*********************
*******************************************************/
public void update() {
String forwardurl = request.getParameter("forwardurl");
String id = request.getParameter("id");
if (id == null)
return;
teacher.setPassword("123456");
teacher.setZhicheng(zhicheng == null ? "" : zhicheng);
teacher.setXueli(xueli == null ? "" : xueli);
teacher.setJiguan(jiguan == null ? "" : jiguan);
teacher.setAge(40);
teacher.setEmail(email == null ? "" : email);
teacher.setMobile(mobile == null ? "" : mobile);
teacher.setJiaoyanshi(jiaoyanshi == null ? "" : jiaoyanshi);
teacher.setLvli(lvli == null ? "" : lvli);
teacherSrv.save(teacher);
String forwardurl = request.getParameter("forwardurl");
if (forwardurl == null) {
forwardurl = "/admin/teachermanager.do?actiontype=get";
}
redirect(forwardurl);
}
/******************************************************
*********************** 更新内部支持*********************
*******************************************************/
public void update() {
String id = request.getParameter("id");
String forwardurl = request.getParameter("forwardurl");
if (id == null)
return;
Teacher teacher =teacherSrv.load(new Integer(id));
if (teacher == null)
return;
String tno = request.getParameter("tno");
String name = request.getParameter("name");
String sex = request.getParameter("sex");
String xiangpian = request.getParameter("xiangpian");
String hyid = request.getParameter("hyid");
String hyname = request.getParameter("hyname");
String zhicheng = request.getParameter("zhicheng");
String xueli = request.getParameter("xueli");
String email = request.getParameter("email");
String mobile = request.getParameter("mobile");
String lvli = request.getParameter("lvli");
SimpleDateFormat sdfteacher = new SimpleDateFormat("yyyy-MM-dd");
if(tno!=null)
teacher.setTno(tno);
teacher.setName(name);
teacher.setSex(sex);
teacher.setXiangpian(xiangpian);
teacher.setZhicheng(zhicheng);
teacher.setXueli(xueli);
teacher.setEmail(email);
pagesize = new Integer(currentpagesize);
List<Shijuan> listshijuan = shijuanSrv.getPageEntitys( filter,pageindex, pagesize);
int recordscount = shijuanSrv.getRecordCount(filter == null ? "" : filter);
request.setAttribute("listshijuan", listshijuan);
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/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);
@Controller
public class JiaodiantuController extends SimpleController {
@Autowired
private JiaodiantuService focusSrv=null;
@Override
@RequestMapping("/admin/jiaodiantumanager.do")
public void mapping(HttpServletRequest request, HttpServletResponse response) {
// TODO Auto-generated method stub
mappingMethod(request,response);
}
/********************************************************
****************** 信息注销监听支持*****************************
*********************************************************/
public void delete() {
String id = request.getParameter("id");
focusSrv.delete(" where id=" + id);
get();
}
/*************************************************************
**************** 保存动作监听支持******************************
**************************************************************/