JavaWeb开发基于ssm的校园服务系统(实例详解)

2023-08-02 10:10:05 83

利用Javaweb开发的一个校园服务系统，通过发布自己的任务并设置悬赏金额，有些类似于赏金猎人，在这里分享给大家，有需要可以联系我:2186527424：
















stuid,studentid,password,schoolid,sex,name,registertime,money,state


select

fromuser
wherestuid=#{stuid,jdbcType=INTEGER}


deletefromuser
wherestuid=#{stuid,jdbcType=INTEGER}


insertintouser(stuid,studentid,password,
schoolid,sex,name,
registertime,money,state
)
values(#{stuid,jdbcType=INTEGER},#{studentid,jdbcType=VARCHAR},#{password,jdbcType=VARCHAR},
#{schoolid,jdbcType=INTEGER},#{sex,jdbcType=INTEGER},#{name,jdbcType=VARCHAR},
#{registertime,jdbcType=TIMESTAMP},#{money,jdbcType=DOUBLE},#{state,jdbcType=INTEGER}
)


insertintouser


stuid,


studentid,


password,


schoolid,


sex,


name,


registertime,


money,


state,




#{stuid,jdbcType=INTEGER},


#{studentid,jdbcType=VARCHAR},


#{password,jdbcType=VARCHAR},


#{schoolid,jdbcType=INTEGER},


#{sex,jdbcType=INTEGER},


#{name,jdbcType=VARCHAR},


#{registertime,jdbcType=TIMESTAMP},


#{money,jdbcType=DOUBLE},


#{state,jdbcType=INTEGER},




updateuser


studentid=#{studentid,jdbcType=VARCHAR},


password=#{password,jdbcType=VARCHAR},


schoolid=#{schoolid,jdbcType=INTEGER},


sex=#{sex,jdbcType=INTEGER},


name=#{name,jdbcType=VARCHAR},


registertime=#{registertime,jdbcType=TIMESTAMP},


money=#{money,jdbcType=DOUBLE},


state=#{state,jdbcType=INTEGER},


wherestuid=#{stuid,jdbcType=INTEGER}


updateuser
setstudentid=#{studentid,jdbcType=VARCHAR},
password=#{password,jdbcType=VARCHAR},
schoolid=#{schoolid,jdbcType=INTEGER},
sex=#{sex,jdbcType=INTEGER},
name=#{name,jdbcType=VARCHAR},
registertime=#{registertime,jdbcType=TIMESTAMP},
money=#{money,jdbcType=DOUBLE},
state=#{state,jdbcType=INTEGER}
wherestuid=#{stuid,jdbcType=INTEGER}



SELECT

from`user`WHERECONCAT(studentid,name)LIKE#{words,jdbcType=VARCHAR}



SELECTCOUNT(*)FROM`user`WHEREstudentid=#{account,jdbcType=VARCHAR};



SELECTFROM`user`WHEREstudentid=#{account,jdbcType=VARCHAR};

注销登录界面

packagecom.ssm.controller;
importjava.io.IOException;
importjava.io.PrintWriter;
importjava.util.List;
importjavax.annotation.Resource;
importjavax.servlet.http.HttpServletRequest;
importjavax.servlet.http.HttpServletResponse;
importorg.springframework.stereotype.Controller;
importorg.springframework.ui.Model;
importorg.springframework.web.bind.annotation.RequestMapping;
importorg.springframework.web.bind.annotation.SessionAttributes;
importcom.ssm.util.JsonUtil;
importcom.ssm.po.School;
importcom.ssm.po.User;
importcom.ssm.service.SchoolService;
importcom.ssm.service.UserService;
/**
*注销登录*
*异步读取院校列表*
*读取一个用户信息*
*@author
*
*/
@Controller
@SessionAttributes({"nowuser","nowadmin"})
@RequestMapping(value="common/")
publicclassCommonController{
@Resource(name="schoolService")
publicSchoolServiceschoolService;

@Resource(name="userService")
publicUserServiceuserService;

//注销
@RequestMapping("logout.do")
publicStringlogout(HttpServletRequestrequest,Modelmodel){
model.addAttribute("msg","已退出");
request.getSession(false).removeAttribute("nowuser");
request.getSession(false).removeAttribute("nowadmin");
return"login";
}

@RequestMapping("getallschools.do")
publicvoidgetallschools(HttpServletResponseresponse)throwsIOException{
System.out.println("000000000000000000000000000000000");
Listlist=schoolService.getAllSchoolsNoState();
response.setCharacterEncoding("UTF-8");
response.setContentType("text/html");
Stringlist_String=JsonUtil.list2json(list);
PrintWriterout=response.getWriter();
out.println(list_String);
out.flush();
out.close();
}

@RequestMapping("getuser.do")
publicStringgetuser(Stringstuidstr,HttpServletRequestrequest,Modelmodel){
intstuid=0;
try{
stuid=Integer.parseInt(stuidstr);
}catch(Exceptione){
model.addAttribute("msg","出现错误");
return"userInfo";
}
if(stuid==0){
model.addAttribute("msg","出现错误");
return"userInfo";
}
Useruser=userService.getByUid(stuid);
model.addAttribute("theuser",user);
return"userInfo";
}
}

用户界面

<%@pagelanguage="java"import="java.util.*"pageEncoding="UTF-8"%>
<%
Stringpath=request.getContextPath();
StringbasePath=request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()
+path+"/";
%>
<%@taglibprefix="c"uri="http://java.sun.com/jsp/jstl/core"%>
<%@taglibprefix="fmt"uri="http://java.sun.com/jsp/jstl/fmt"%>



"rel="externalnofollow">
个人中心





layui/css/layui.css"rel="externalnofollow">


alert("请先登录");
window.location.href="<%=basePath%>login.jsp"rel="externalnofollow";






校园即时服务平台

任务中心个人中心

${nowuser.name}

个人信息

资料修改

安全设置

退了

校园即时服务平台任务管理

已发布任务

已接受任务

发布新任务

个人中心

个人信息

资料修改

安全设置

JavaWeb开发基于ssm的校园服务系统(实例详解)

热门推荐

随机推荐