JavaWeb如何开发基于ssm的校园服务系统

<?xml version="1.0" encoding="UTF-8" ?> <!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd" > <mapper namespace="com.ssm.mapper.UserMapper" > <resultMap id="BaseResultMap" type="com.ssm.po.User" > <id column="stuid" property="stuid" jdbcType="INTEGER" /> <result column="studentid" property="studentid" jdbcType="VARCHAR" /> <result column="password" property="password" jdbcType="VARCHAR" /> <result column="schoolid" property="schoolid" jdbcType="INTEGER" /> <result column="sex" property="sex" jdbcType="INTEGER" /> <result column="name" property="name" jdbcType="VARCHAR" /> <result column="registertime" property="registertime" jdbcType="TIMESTAMP" /> <result column="money" property="money" jdbcType="DOUBLE" /> <result column="state" property="state" jdbcType="INTEGER" /> </resultMap> <sql id="Base_Column_List" > stuid, studentid, password, schoolid, sex, name, registertime, money, state </sql> <select id="selectByPrimaryKey" resultMap="BaseResultMap" parameterType="java.lang.Integer" > select <include refid="Base_Column_List" /> from user where stuid = #{stuid,jdbcType=INTEGER} </select> <delete id="deleteByPrimaryKey" parameterType="java.lang.Integer" > delete from user where stuid = #{stuid,jdbcType=INTEGER} </delete> <insert id="insert" parameterType="com.ssm.po.User" > insert into user (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} ) </insert> <insert id="insertSelective" parameterType="com.ssm.po.User" > insert into user <trim prefix="(" suffix=")" suffixOverrides="," > <if test="stuid != null" > stuid, </if> <if test="studentid != null" > studentid, </if> <if test="password != null" > password, </if> <if test="schoolid != null" > schoolid, </if> <if test="sex != null" > sex, </if> <if test="name != null" > name, </if> <if test="registertime != null" > registertime, </if> <if test="money != null" > money, </if> <if test="state != null" > state, </if> </trim> <trim prefix="values (" suffix=")" suffixOverrides="," > <if test="stuid != null" > #{stuid,jdbcType=INTEGER}, </if> <if test="studentid != null" > #{studentid,jdbcType=VARCHAR}, </if> <if test="password != null" > #{password,jdbcType=VARCHAR}, </if> <if test="schoolid != null" > #{schoolid,jdbcType=INTEGER}, </if> <if test="sex != null" > #{sex,jdbcType=INTEGER}, </if> <if test="name != null" > #{name,jdbcType=VARCHAR}, </if> <if test="registertime != null" > #{registertime,jdbcType=TIMESTAMP}, </if> <if test="money != null" > #{money,jdbcType=DOUBLE}, </if> <if test="state != null" > #{state,jdbcType=INTEGER}, </if> </trim> </insert> <update id="updateByPrimaryKeySelective" parameterType="com.ssm.po.User" > update user <set > <if test="studentid != null" > studentid = #{studentid,jdbcType=VARCHAR}, </if> <if test="password != null" > password = #{password,jdbcType=VARCHAR}, </if> <if test="schoolid != null" > schoolid = #{schoolid,jdbcType=INTEGER}, </if> <if test="sex != null" > sex = #{sex,jdbcType=INTEGER}, </if> <if test="name != null" > name = #{name,jdbcType=VARCHAR}, </if> <if test="registertime != null" > registertime = #{registertime,jdbcType=TIMESTAMP}, </if> <if test="money != null" > money = #{money,jdbcType=DOUBLE}, </if> <if test="state != null" > state = #{state,jdbcType=INTEGER}, </if> </set> where stuid = #{stuid,jdbcType=INTEGER} </update> <update id="updateByPrimaryKey" parameterType="com.ssm.po.User" > update user set 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} where stuid = #{stuid,jdbcType=INTEGER} </update>  <select id="selectByLikeNameAccount" resultMap="BaseResultMap" > SELECT <include refid="Base_Column_List" /> from `user` WHERE CONCAT(studentid,name) LIKE #{words,jdbcType=VARCHAR} </select>  <select id="selectAccountCount" resultType="java.lang.Integer" > SELECT COUNT(*) FROM `user` WHERE studentid = #{account,jdbcType=VARCHAR}; </select>  <select id="selectUserByAccount" resultMap="BaseResultMap" > SELECT <include refid="Base_Column_List" /> FROM `user` WHERE studentid = #{account,jdbcType=VARCHAR}; </select> </mapper>

package com.ssm.controller; import java.io.IOException; import java.io.PrintWriter; import java.util.List; import javax.annotation.Resource; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import org.springframework.stereotype.Controller; import org.springframework.ui.Model; import org.springframework.web.bind.annotation.RequestMapping; import org.springframework.web.bind.annotation.SessionAttributes; import com.ssm.util.JsonUtil; import com.ssm.po.School; import com.ssm.po.User; import com.ssm.service.SchoolService; import com.ssm.service.UserService; /** * 注销登录* * 异步读取院校列表* * 读取一个用户信息* * @author * */ @Controller @SessionAttributes({ "nowuser","nowadmin"}) @RequestMapping(value = "common/") public class CommonController { @Resource(name = "schoolService") public SchoolService schoolService; @Resource(name = "userService") public UserService userService; // 注销 @RequestMapping("logout.do") public String logout(HttpServletRequest request, Model model) { model.addAttribute("msg", "已退出"); request.getSession(false).removeAttribute("nowuser"); request.getSession(false).removeAttribute("nowadmin"); return "login"; } @RequestMapping("getallschools.do") public void getallschools(HttpServletResponse response) throws IOException{ System.out.println("000000000000000000000000000000000"); List<School> list = schoolService.getAllSchoolsNoState(); response.setCharacterEncoding("UTF-8"); response.setContentType("text/html"); String list_String = JsonUtil.list2json(list); PrintWriter out = response.getWriter(); out.println(list_String); out.flush(); out.close(); } @RequestMapping("getuser.do") public String getuser(String stuidstr,HttpServletRequest request,Model model) { int stuid = 0; try { stuid = Integer.parseInt(stuidstr); } catch (Exception e) { model.addAttribute("msg", "出现错误"); return "userInfo"; } if (stuid==0) { model.addAttribute("msg", "出现错误"); return "userInfo"; } User user = userService.getByUid(stuid); model.addAttribute("theuser", user); return "userInfo"; } }

<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%> <% String path = request.getContextPath(); String basePath = request.getScheme() + "://" + request.getServerName() + ":" + request.getServerPort() + path + "/"; %> <%@taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core"%> <%@taglib prefix="fmt" uri="http://java.sun.com/jsp/jstl/fmt"%> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> <html> <head> <base href="<%=basePath%>" rel="external nofollow" > <title>个人中心</title> <meta http-equiv="pragma" content="no-cache"> <meta http-equiv="cache-control" content="no-cache"> <meta http-equiv="expires" content="0"> <meta http-equiv="keywords" content="keyword1,keyword2,keyword3"> <meta http-equiv="description" content="This is my page"> <link rel="stylesheet" href="<%=basePath%>layui/css/layui.css" rel="external nofollow" > <c:if test="${empty nowuser }"> <script type="text/javascript"> alert("请先登录"); window.location.href="<%=basePath%>login.jsp" rel="external nofollow" ; </script> </c:if> </head> <body class="layui-layout-body"> <div class="layui-layout layui-layout-admin"> <div class="layui-header"> <div class="layui-logo">校园即时服务平台</div>  <ul class="layui-nav layui-layout-left"> <li class="layui-nav-item"><a href="">任务中心</a></li> <li class="layui-nav-item"><a href="userIndex.jsp" rel="external nofollow" rel="external nofollow" rel="external nofollow" >个人中心</a></li> </ul> <ul class="layui-nav layui-layout-right"> <li class="layui-nav-item"><a href="javascript:;" rel="external nofollow" rel="external nofollow" rel="external nofollow" > ${nowuser.name } </a> <dl class="layui-nav-child"> <dd> <a href="userIndex.jsp" rel="external nofollow" rel="external nofollow" rel="external nofollow" >个人信息</a> </dd> <dd> <a href="userUpdate.jsp" rel="external nofollow" rel="external nofollow" >资料修改</a> </dd> <dd> <a href="userPassword.jsp" rel="external nofollow" rel="external nofollow" >安全设置</a> </dd> </dl></li> <li class="layui-nav-item"><a href="common/logout.do" rel="external nofollow" >退了</a></li> </ul> </div> <div class="layui-side layui-bg-black"> <div class="layui-side-scroll">  <ul class="layui-nav layui-nav-tree" lay-filter="test"> <li class="layui-nav-item"><a href="">校园即时服务平台</a></li> <li class="layui-nav-item layui-nav-itemed"><a href="javascript:;" rel="external nofollow" rel="external nofollow" rel="external nofollow" >任务管理</a> <dl class="layui-nav-child"> <dd> <a href="task/getusertask.do" rel="external nofollow" >已发布任务</a> </dd> <dd> <a href="task/getuseratask.do" rel="external nofollow" >已接受任务</a> </dd> <dd> <a href="userNewtask.jsp" rel="external nofollow" >发布新任务</a> </dd> </dl></li> <li class="layui-nav-item layui-nav-itemed"><a class="" href="javascript:;" rel="external nofollow" rel="external nofollow" rel="external nofollow" >个人中心</a> <dl class="layui-nav-child"> <dd class="layui-this"> <a href="userIndex.jsp" rel="external nofollow" rel="external nofollow" rel="external nofollow" >个人信息</a> </dd> <dd> <a href="userUpdate.jsp" rel="external nofollow" rel="external nofollow" >资料修改</a> </dd> <dd> <a href="userPassword.jsp" rel="external nofollow" rel="external nofollow" >安全设置</a> </dd> </dl></li> </ul> </div> </div>  <div class="layui-body"> <div class="layui-fluid"> <div class="layui-row"> <div class="layui-col-md12"> <span class="layui-badge-dot"></span> <span class="layui-badge-dot layui-bg-orange"></span> <span class="layui-badge-dot layui-bg-green"></span> <span class="layui-badge-dot layui-bg-cyan"></span> <span class="layui-badge-dot layui-bg-blue"></span> <span class="layui-badge-dot layui-bg-black"></span> <span class="layui-badge-dot layui-bg-gray"></span> <fieldset class="layui-elem-field layui-field-title" > <legend>个人信息</legend> </fieldset> </div> </div> <div class="layui-row"> <div class="layui-col-md1"> </div> <div class="layui-col-md10"> <fieldset class="layui-elem-field"> <legend>信息</legend>  <table class="layui-table" lay-size="lg" lay-skin="line" > <colgroup> <col width="150"> <col width="200"> <col> </colgroup> <thead> <tr> <th> </th> <th> </th> </tr> </thead> <tbody> <tr> <td>用户编号</td> <td>${nowuser.stuid }</td> </tr> <tr> <td>用户学号</td> <td>${nowuser.studentid }</td> </tr> <tr> <td>用户姓名</td> <td>${nowuser.name }</td> </tr> <tr> <td>学校编号</td> <td>${nowuser.schoolid }</td> </tr> <tr> <td>用户性别</td> <td><c:if test="${nowuser.sex==0 }"> 男 </c:if> <c:if test="${nowuser.sex!=0 }"> 女 </c:if></td> </tr> <tr> <td>注册时间</td> <td><fmt:formatDate value="${nowuser.registertime }" pattern=" yyyy-MM-dd HH:mm:ss" /></td> </tr> <tr> <td>用户余额</td> <td>${nowuser.money }</td> </tr> <tr> <td>用户状态</td> <td><c:if test="${nowuser.state==0 }"> 正常 </c:if> <c:if test="${nowuser.state!=0 }"> 被限制 </c:if></td> </tr> </tbody> </table>  </fieldset> </div> <div class="layui-col-md1"> </div> </div> </div> </div> <c:if test="${!empty msg }"> <script type="text/javascript"> alert("${msg }"); </script> </c:if> <div class="layui-footer">  © - 校园即时服务平台办公电话：6666666 </div> </div> <script src="${pageContext.request.contextPath }/layui/layui.all.js"></script> <script> //JavaScript代码区域 layui.use('element', function() { var element = layui.element; //监听导航点击 element.on('nav(test)', function(elem) { //console.log(elem) layer.msg(elem.text()); }); }); </script> </body> </html>

相关阅读