小编给大家分享一下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"%>
" rel="external nofollow" >
个人中心
layui/css/layui.css" rel="external nofollow" >
alert("请先登录");
window.location.href="<%=basePath%>login.jsp" rel="external nofollow" ;
校园即时服务平台
