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

     stuid, studentid, password, schoolid, sex, name, registertime, money, state  select  from user where stuid = #{stuid,jdbcType=INTEGER}  delete from user where stuid = #{stuid,jdbcType=INTEGER}  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 into user   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},  update user   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 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}  SELECT  from `user` WHERE CONCAT(studentid,name) LIKE #{words,jdbcType=VARCHAR}  SELECT COUNT(*) FROM `user` WHERE studentid = #{account,jdbcType=VARCHAR};  SELECT  FROM `user` WHERE studentid = #{account,jdbcType=VARCHAR}; 

 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 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"%>    
 
 
校园即时服务平台
 
任务中心
个人中心
 
 ${nowuser.name } 
 
 个人信息
 资料修改
 安全设置
退了
 
 
 
校园即时服务平台
任务管理
 
 已发布任务
 已接受任务
 发布新任务
个人中心
 
 个人信息
 资料修改
 安全设置
 
 
 
 
 
个人信息
 
 
 
 
信息
  
 
 
 
 
 
 
用户编号
${nowuser.stuid }
 
用户学号
${nowuser.studentid }
 
用户姓名
${nowuser.name }
 
学校编号
${nowuser.schoolid }
 
用户性别
 男  女 
 
注册时间
 
用户余额
${nowuser.money }
 
用户状态
 正常  被限制 
 
 
  © - 校园即时服务平台办公电话：6666666