基于javaweb+jsp的企业车辆管理系统(JavaWeb JSP MySQL Servlet SSM SpringBoot Layui Ajax)
JavaWeb JavaBean JSP MVC MySQL Tomcat JavaScript Layui Ajax
基础JSP+Servlet或JSP+SSM(Spring、SpringMVC、MyBatis)框架或JSP+SSM+Maven(pom.xml)框架或SpringBoot…均可
开发工具：eclipse/idea/myeclipse/sts等均可配置运行
适用
课程设计，大作业，毕业设计，项目练习，学习演示等
let flag1 = ${loginUser.id} == vo.id;let flag2 = ${loginUser.userType == '管理员'};return ((flag1 || flag2) ? '<a class="layui-btn layui-btn-xs" lay-event="edit">编辑</a>' : '') + ((flag2) ? '<a class="layui-btn layui-btn-danger layui-btn-xs" lay-event="del">删除</a>' : '');}}]],});//监听工具条table.on('tool(myTable)', function (obj) { //注：tool 是工具条事件名，myTable 是 table 原始容器的属性 lay-filter="对应的值"let data = obj.data; //获得当前行数据let layEvent = obj.event; //获得 lay-event 对应的值（也可以是表头的 event 参数对应的值）if (layEvent === 'del') { //删除// layer.confirm('删除' + data.realName + "?", function (index) {$.ajax({type: "GET",dataType: "text",url: "userDelete?id=" + data.id,success: function () {console.log("已删除！");}
<if test ='userType != null'>`user_type` = #{userType}</if></set>WHERE `id` = #{id}</update><!--获取--><select id="findById" resultMap="BaseResultMap">SELECT <include refid="Base_Column_List" /> FROM `t_user` WHERE `id` = #{id}</select><!--列表--><select id="findAllSplit" parameterType="java.util.Map" resultMap="BaseResultMap">SELECT <include refid="Base_Column_List" /> FROM `t_user`<where><if test="searchColumn != null and searchColumn != '' and keyword != null and keyword != ''">${searchColumn} LIKE CONCAT('%',#{keyword},'%') AND</if>1=1</where>ORDER BY id ASC<if test="startIndex != null and pageSize != null">
public void delete(HttpServletResponse response, HttpServletRequest request) throws IOException {Serializable id = Util.decode(request, "id");noticeService.delete(Arrays.asList(id));this.redirectList(request, response);}/*** 编辑公告** @param response* @param request* @throws IOException*/@RequestMapping("noticeEdit")public void edit(HttpServletResponse response, HttpServletRequest request) throws IOException {Notice vo = new Notice();vo.setId(Long.valueOf(Util.decode(request, "id")));vo.setNoticeName(Util.decode(request, "noticeName"));vo.setNoticeText(Util.decode(request, "noticeText"));vo.setNoticeType(Util.decode(request, "noticeType"));vo.setCreateDate(Util.decode(request, "createDate"));noticeService.update(vo);this.redirectList(request, response);
});</script></body></html><%@ page contentType="text/html; charset=UTF-8" pageEncoding="UTF-8" %><%@ taglib uri="/jsp/jstl/core" prefix="c" %><%@ taglib prefix="fn" uri="/jsp/jstl/functions" %><%@ taglib prefix="fmt" uri="/jsp/jstl/fmt" %><html><head><meta http-equiv="Content-Type" content="text/html; charset=UTF-8"><title>注册</title><script type="text/javascript">let alert_msg = '${alert_msg}';if (alert_msg != null && alert_msg.trim() != '') {window.alert(alert_msg);}
import java.io.IOException;import java.io.Serializable;import java.util.Arrays;import java.util.HashMap;import java.util.List;import java.util.Map;@Controller@RequestMappingpublic class CarController {@Autowiredprivate CarService carService;
Map<String, Object> params = new HashMap();//用来保存控制层传进来的参数(查询条件)params.put("searchColumn", searchColumn);//要查询的列params.put("keyword", keyword);//查询的关键字response.getWriter().println(com.alibaba.fastjson.JSONObject.toJSONString(carService.list(params).get("list")));}}package com.demo.controller;import com.demo.util.Util;import com.demo.service.UserService;import com.demo.vo.User;import org.springframework.beans.factory.annotation.Autowired;import org.springframework.stereotype.Controller;import org.springframework.web.bind.annotation.RequestMapping;import javax.servlet.http.HttpServletRequest;import javax.servlet.http.HttpServletResponse;import javax.servlet.http.HttpSession;import java.io.IOException;import java.io.Serializable;import java.util.Arrays;import java.util.HashMap;import java.util.List;import java.util.Map;@Controller
<sql id="Base_Column_List">`id`,`notice_name`,`notice_text`,`notice_type`,`create_date`</sql><!--新增--><insert id="doCreate" useGeneratedKeys="true" keyColumn="id" keyProperty="id" parameterType="com.demo.vo.Notice">INSERT INTO `t_notice`<trim prefix="(" suffix=")" suffixOverrides=","><if test ='id != null'>`id`,</if><if test ='noticeName != null'>`notice_name`,</if><if test ='noticeText != null'>`notice_text`,</if><if test ='noticeType != null'>`notice_type`,</if><if test ='createDate != null'>`create_date`</if></trim><trim prefix="values (" suffix=")" suffixOverrides=","><if test ='id != null'>#{id},</if><if test ='noticeName != null'>#{noticeName},</if><if test ='noticeText != null'>#{noticeText},</if><if test ='noticeType != null'>#{noticeType},</if><if test ='createDate != null'>#{createDate}</if>
request.getSession().setAttribute("vo", vo);String to = request.getRequestURI().toLowerCase().contains("get") ? "info" : "edit";//判断是去详情显示页面还是编辑页面response.sendRedirect("car_" + to + ".jsp");}/*** 根据条件查询车辆的列表并跳转回页面** @param response* @param request* @throws IOException*/@RequestMapping("carList")public void list(HttpServletResponse response, HttpServletRequest request) throws IOException {this.redirectList(request, response);
<if test ='realName != null'>`real_name`,</if><if test ='userSex != null'>`user_sex`,</if><if test ='userPhone != null'>`user_phone`,</if><if test ='userText != null'>`user_text`,</if><if test ='userType != null'>`user_type`</if></trim><trim prefix="values (" suffix=")" suffixOverrides=","><if test ='id != null'>#{id},</if><if test ='username != null'>#{username},</if><if test ='password != null'>#{password},</if><if test ='realName != null'>#{realName},</if><if test ='userSex != null'>#{userSex},</if><if test ='userPhone != null'>#{userPhone},</if><if test ='userText != null'>#{userText},</if><if test ='userType != null'>#{userType}</if></trim></insert><!--批量删除--><delete id="doRemoveBatch" parameterType="java.util.Collection">
vo.setId(Long.valueOf(Util.decode(request, "id")));vo.setUsername(Util.decode(request, "username"));vo.setPassword(Util.decode(request, "password"));vo.setRealName(Util.decode(request, "realName"));vo.setUserSex(Util.decode(request, "userSex"));vo.setUserPhone(Util.decode(request, "userPhone"));vo.setUserText(Util.decode(request, "userText"));vo.setUserType(Util.decode(request, "userType"));userService.update(vo);this.redirectList(request, response);}/*** 获取用户的详细信息（详情页面与编辑页面要显示该用户的详情）并跳转回页面** @param response* @param request* @throws IOException*/@RequestMapping({"userGet", "userEditPre"})public void get(HttpServletResponse response, HttpServletRequest request) throws IOException {Serializable id = Util.decode(request, "id");//取出主键id
});</script></body></html><%@ page contentType="text/html; charset=UTF-8" pageEncoding="UTF-8" %><%@ taglib uri="/jsp/jstl/core" prefix="c" %><%@ taglib prefix="fn" uri="/jsp/jstl/functions" %><%@ taglib prefix="fmt" uri="/jsp/jstl/fmt" %><html><head><meta charset="UTF-8"><meta name="viewport" content="width=device-width, initial-scale=1.0"><title>修改车辆</title><script src="js/jquery.js"></script><link rel="stylesheet" href="js/layui/css/layui.css"></head><body style="padding: 20px"><form class="layui-form" action=""><input type="hidden" name="id" class="layui-input" value="${vo.id}"><div class="layui-form-item"><label class="layui-form-label">车牌：</label><div class="layui-input-block">
运行环境
Java≥6、Tomcat≥7.0、MySQL≥5.5
开发工具
eclipse/idea/myeclipse/sts等均可配置运行
技术框架
JavaWeb JavaBean JSP MVC MySQL Tomcat JavaScript Layui Ajax
基础JSP+Servlet或JSP+SSM(Spring、SpringMVC、MyBatis)框架或JSP+SSM+Maven(pom.xml)框架或SpringBoot…均可
适用
课程设计，大作业，毕业设计，项目练习，学习演示等
功能说明
登录、注册、退出、用户模块、公告模块、车辆模块的增删改查管理
![[2024年]我的新伙伴700字左右](https://700zi.400zi.cn/uploadfile/img/2024/05/27/491e93cbce6fcb5ff02d42fc921785ea.jpg)
![[2024年]探寻张孝祥诗意之美：宋词鉴赏与深度解读](https://700zi.400zi.cn/uploadfile/img/2024/05/27/8850b384962229189271533b3974c63a.jpg)
