JavaWeb開發(fā)基于ssm的校園服務(wù)系統(tǒng)(實(shí)例詳解)
利用Javaweb開發(fā)的一個(gè)校園服務(wù)系統(tǒng),通過發(fā)布自己的任務(wù)并設(shè)置懸賞金額,有些類似于賞金獵人,在這里分享給大家,有需要可以聯(lián)系我:2186527424:



<?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>
<!-- 根據(jù)賬號(hào)或昵稱查找返回user -->
<select id="selectByLikeNameAccount" resultMap="BaseResultMap" >
SELECT
<include refid="Base_Column_List" />
from `user` WHERE CONCAT(studentid,name) LIKE #{words,jdbcType=VARCHAR}
</select>
<!-- 查找賬號(hào)個(gè)數(shù) -->
<select id="selectAccountCount" resultType="java.lang.Integer" >
SELECT COUNT(*) FROM `user` WHERE studentid = #{account,jdbcType=VARCHAR};
</select>
<!-- 根據(jù)賬號(hào)查找返回user -->
<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;
/**
* 注銷登錄*
* 異步讀取院校列表*
* 讀取一個(gè)用戶信息*
* @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", "出現(xiàn)錯(cuò)誤");
return "userInfo";
}
if (stuid==0) {
model.addAttribute("msg", "出現(xiàn)錯(cuò)誤");
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>個(gè)人中心</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("請(qǐng)先登錄");
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">校園即時(shí)服務(wù)平臺(tái)</div>
<!-- 頭部區(qū)域(可配合layui已有的水平導(dǎo)航) -->
<ul class="layui-nav layui-layout-left">
<li class="layui-nav-item"><a href="">任務(wù)中心</a></li>
<li class="layui-nav-item"><a href="userIndex.jsp" rel="external nofollow" rel="external nofollow" rel="external nofollow" >個(gè)人中心</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" >個(gè)人信息</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" >安全設(shè)置</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">
<!-- 左側(cè)導(dǎo)航區(qū)域(可配合layui已有的垂直導(dǎo)航) -->
<ul class="layui-nav layui-nav-tree" lay-filter="test">
<li class="layui-nav-item"><a href="">校園即時(shí)服務(wù)平臺(tái)</a></li>
<li class="layui-nav-item layui-nav-itemed"><a
href="javascript:;" rel="external nofollow" rel="external nofollow" rel="external nofollow" >任務(wù)管理</a>
<dl class="layui-nav-child">
<dd>
<a href="task/getusertask.do" rel="external nofollow" >已發(fā)布任務(wù)</a>
</dd>
<dd>
<a href="task/getuseratask.do" rel="external nofollow" >已接受任務(wù)</a>
</dd>
<dd>
<a href="userNewtask.jsp" rel="external nofollow" >發(fā)布新任務(wù)</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" >個(gè)人中心</a>
<dl class="layui-nav-child">
<dd class="layui-this">
<a href="userIndex.jsp" rel="external nofollow" rel="external nofollow" rel="external nofollow" >個(gè)人信息</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" >安全設(shè)置</a>
</dd>
</dl></li>
</ul>
</div>
</div>
<!-- 內(nèi)容主體區(qū)域-->
<div class="layui-body">
<div style="padding: 30px;" 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"
style="margin-top: 30px;">
<legend>個(gè)人信息</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>
<!-- <div class="layui-field-box">-->
<table class="layui-table" lay-size="lg" lay-skin="line"
style="margin-bottom: 0px;">
<colgroup>
<col width="150">
<col width="200">
<col>
</colgroup>
<thead>
<tr>
<th> </th>
<th> </th>
</tr>
</thead>
<tbody>
<tr>
<td>用戶編號(hào)</td>
<td>${nowuser.stuid }</td>
</tr>
<tr>
<td>用戶學(xué)號(hào)</td>
<td>${nowuser.studentid }</td>
</tr>
<tr>
<td>用戶姓名</td>
<td>${nowuser.name }</td>
</tr>
<tr>
<td>學(xué)校編號(hào)</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>注冊(cè)時(shí)間</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>用戶狀態(tài)</td>
<td><c:if test="${nowuser.state==0 }">
正常
</c:if> <c:if test="${nowuser.state!=0 }">
被限制
</c:if></td>
</tr>
</tbody>
</table>
<!--</div>-->
</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">
<!-- 底部固定區(qū)域 -->
© - 校園即時(shí)服務(wù)平臺(tái)辦公電話:6666666
</div>
</div>
<script src="${pageContext.request.contextPath }/layui/layui.all.js"></script>
<script>
//JavaScript代碼區(qū)域
layui.use('element', function() {
var element = layui.element;
//監(jiān)聽導(dǎo)航點(diǎn)擊
element.on('nav(test)', function(elem) {
//console.log(elem)
layer.msg(elem.text());
});
});
</script>
</body>
</html>
總結(jié)
以上所述是小編給大家介紹的JavaWeb開發(fā)基于ssm的校園服務(wù)系統(tǒng),希望對(duì)大家有所幫助!
- Java畢業(yè)設(shè)計(jì)實(shí)戰(zhàn)之校園一卡通系統(tǒng)的實(shí)現(xiàn)
- Java實(shí)戰(zhàn)項(xiàng)目之校園跑腿管理系統(tǒng)的實(shí)現(xiàn)
- Java?實(shí)戰(zhàn)范例之校園二手市場(chǎng)系統(tǒng)的實(shí)現(xiàn)
- Java 實(shí)戰(zhàn)練手項(xiàng)目之校園超市管理系統(tǒng)的實(shí)現(xiàn)流程
- Java 實(shí)戰(zhàn)項(xiàng)目錘煉之校園宿舍管理系統(tǒng)的實(shí)現(xiàn)流程
- Java實(shí)現(xiàn)的具有GUI的校園導(dǎo)航系統(tǒng)的完整代碼
- Java模擬HTTP Get Post請(qǐng)求 輕松實(shí)現(xiàn)校園BBS自動(dòng)回帖
- Java基于Dijkstra算法實(shí)現(xiàn)校園導(dǎo)游程序
相關(guān)文章
深入分析Comparable與Comparator及Clonable三個(gè)Java接口
接口不是類,而是對(duì)類的一組需求描述,這些類要遵從接口描述的統(tǒng)一格式進(jìn)行定義,這篇文章主要為大家詳細(xì)介紹了Java的Comparable,Comparator和Cloneable的接口,文中示例代碼介紹的非常詳細(xì),具有一定的參考價(jià)值,感興趣的小伙伴們可以參考一下,希望能夠給你帶來幫助2022-05-05
使用springboot 獲取控制器參數(shù)的幾種方法小結(jié)
這篇文章主要介紹了使用springboot 獲取控制器參數(shù)的幾種方法小結(jié),具有很好的參考價(jià)值,希望對(duì)大家有所幫助。如有錯(cuò)誤或未考慮完全的地方,望不吝賜教2021-12-12
Java數(shù)據(jù)敏感詞轉(zhuǎn)換成符號(hào)的方法詳解
在某個(gè)論壇下用戶可以隨意留言,為了防止不法分子在網(wǎng)上任意沖浪,需要對(duì)一些敏感詞匯進(jìn)行一些校驗(yàn),所以這篇文章給大家介紹了Java數(shù)據(jù)敏感詞轉(zhuǎn)換成符號(hào)的方法,需要的朋友可以參考下2024-03-03
Java selenium處理極驗(yàn)滑動(dòng)驗(yàn)證碼示例
本篇文章主要介紹了Java selenium處理極驗(yàn)滑動(dòng)驗(yàn)證碼示例,小編覺得挺不錯(cuò)的,現(xiàn)在分享給大家,也給大家做個(gè)參考。一起跟隨小編過來看看吧2017-10-10
使用vue3.x+vite+element-ui+vue-router+vuex+axios搭建項(xiàng)目
因?yàn)関ue3出了一段時(shí)間了,element也出了基于vue3.x版本的element-plus,這篇文章就拿他們搭建一個(gè)項(xiàng)目,希望能給你帶來幫助2021-08-08
詳解Java字節(jié)碼編程之非常好用的javassist
這篇文章主要介紹了詳解Java字節(jié)碼編程之非常好用的javassist,文中通過示例代碼介紹的非常詳細(xì),對(duì)大家的學(xué)習(xí)或者工作具有一定的參考學(xué)習(xí)價(jià)值,需要的朋友們下面隨著小編來一起學(xué)習(xí)學(xué)習(xí)吧2021-04-04

