基于javaweb+jsp的运动会体育比赛管理系统(JavaWeb JSP MySQL Servlet SSM SpringBoot Bootstrap Ajax)

基于javaweb+jsp的运动会体育比赛管理系统(JavaWeb JSP MySQL Servlet SSM SpringBoot Bootstrap Ajax)

JavaWeb JavaBean JSP MVC MySQL Tomcat JavaScript Bootstrap Ajax

基础JSP+Servlet或JSP+SSM(Spring、SpringMVC、MyBatis)框架或JSP+SSM+Maven(pom.xml)框架或SpringBoot…均可

开发工具：eclipse/idea/myeclipse/sts等均可配置运行

适用

课程设计，大作业，毕业设计，项目练习，学习演示等

                </div>
                <div class="modal-body">
                    确认要删除该参赛记录吗？
                    <div class="form-group hidden">
                        <label class="control-label">(hidden)</label>
                        <input type="hidden" class="form-control" name="action" value="delete">
                        <input type="text" class="form-control" name="id" id="delete-id">
                    </div>
                </div>
                <div class="modal-footer">
                    <button type="button" class="btn btn-rect btn-grad btn-success" data-dismiss="modal">取消</button>
                    <button type="submit" class="btn btn-rect btn-grad btn-primary">删除</button>
                </div>
            </form>
        </div>
    </div>
</div>

</body>
<script>
    $('#modal-delete').on('show.bs.modal', function (event) {
        let button = $(event.relatedTarget);
        let id = button.data('id');
        let modal = $(this);
        modal.find('#delete-id').val(id);

        }
        if (document.getElementById("add-xiangmuDidian").value.trim().length == 0) {
            alert("举办地点不能为空");
            return false;
        }
        if (document.getElementById("add-xiangmuSijian").value.trim().length == 0) {
            alert("比赛时间不能为空");
            return false;
        }
        return true;
    }
    //编辑表单提交之前进行检查，如果return false，则不允许提交
    function editCheck() {
        //根据ID获取值
        if (document.getElementById("edit-xiangmuName").value.trim().length == 0) {
            alert("名称不能为空");
            return false;
        }
        if (document.getElementById("edit-xiangmuDidian").value.trim().length == 0) {
            alert("举办地点不能为空");
            return false;
        }
        if (document.getElementById("edit-xiangmuSijian").value.trim().length == 0) {

            <result column="xiangmu_text" property="xiangmuText" />
    </resultMap>

    <sql id="Base_Column_List">
        `id`,`xiangmu_name`,`xiangmu_sex`,`xiangmu_didian`,`xiangmu_sijian`,`xiangmu_text`
    </sql>

    <!--新增-->
    <insert id="doCreate" useGeneratedKeys="true" keyColumn="id" keyProperty="id" parameterType="com.demo.vo.Xiangmu">
        INSERT INTO `t_xiangmu`
        <trim prefix="(" suffix=")" suffixOverrides=",">
                    <if test ='id != null'>`id`,</if>
                    <if test ='xiangmuName != null'>`xiangmu_name`,</if>
                    <if test ='xiangmuSex != null'>`xiangmu_sex`,</if>
                    <if test ='xiangmuDidian != null'>`xiangmu_didian`,</if>
                    <if test ='xiangmuSijian != null'>`xiangmu_sijian`,</if>
                    <if test ='xiangmuText != null'>`xiangmu_text`</if>
        </trim>
        <trim prefix="values (" suffix=")" suffixOverrides=",">
                    <if test ='id != null'>#{id},</if>

            success: function (voString) {
                let vo = eval('(' + voString + ')');
                modal.find('#info-xiangmuName').text(vo.xiangmuName);
                modal.find('#info-xiangmuSex').text(vo.xiangmuSex);
                modal.find('#info-xiangmuDidian').text(vo.xiangmuDidian);
                modal.find('#info-xiangmuSijian').text(vo.xiangmuSijian);
                modal.find('#info-xiangmuText').text(vo.xiangmuText);
            }
        })
    })
    function searchList() {
        window.location.href = "xiangmuList?searchColumn="+document.getElementById("searchColumn").value+"&keyword=" + document.getElementById("search_keyword").value;
    }
    //增加表单提交之前进行检查，如果return false，则不允许提交
    function addCheck() {
        //根据ID获取值
        if (document.getElementById("add-xiangmuName").value.trim().length == 0) {

                        <tr>
                            <td style="width: 15%;">用户名:</td>
                            <td><b id="info-username"></b></td>
                        </tr>
                        <tr>
                            <td style="width: 15%;">姓名:</td>
                            <td><b id="info-realName"></b></td>
                        </tr>
                        <tr>
                            <td style="width: 15%;">性别:</td>
                            <td><b id="info-userSex"></b></td>
                        </tr>
                        <tr>
                            <td style="width: 15%;">手机:</td>
                            <td><b id="info-userPhone"></b></td>
                        </tr>
                        <tr>
                            <td style="width: 15%;">备注:</td>
                            <td><b id="info-userText"></b></td>
                        </tr>
                        <tr>
                            <td style="width: 15%;">类型:</td>
                            <td><b id="info-userType"></b></td>
                        </tr>
                    </table>
                    <br>

<!-- info -->
<div class="modal fade" id="modal-info" tabindex="-1" role="dialog"
     aria-labelledby="myModalLabel">
    <div class="modal-dialog" role="document">
        <div class="modal-content">
            <form>
                <div class="modal-header">
                    <button type="button" class="close" data-dismiss="modal" aria-label="Close">
                        <span aria-hidden="true">&times;</span>
                    </button>
                    <h4 class="modal-title">用户</h4>
                </div>
                <div class="modal-body">
                    <table class="table table-striped table-hover" style="font-size: 15px;">
                        <tr>
                            <td style="width: 15%;">用户名:</td>
                            <td><b id="info-username"></b></td>
                        </tr>
                        <tr>
                            <td style="width: 15%;">姓名:</td>
                            <td><b id="info-realName"></b></td>

                <td>${vo.xiangmuDidian}</td>
                <td>${vo.xiangmuSijian}</td>
                <td title="${vo.xiangmuText}">
                <c:choose>
                    <c:when test="${fn:length(vo.xiangmuText) > 19}">
                        <c:out value="${fn:substring(vo.xiangmuText, 0, 19)}..."/>
                    </c:when>
                    <c:otherwise>
                        <c:out value="${vo.xiangmuText}"/>
                    </c:otherwise>
                </c:choose>
                </td>
                            <th style="text-align: center;">
                                <button class="btn btn-rect btn-grad btn-warning btn-sm" data-id="${vo.id}"
                                        data-toggle="modal" data-target="#modal-info">详情
                                </button>
                                <button class="btn btn-rect btn-grad btn-default btn-sm"
                                                <c:if test="${loginUser.userType != '管理员'}">disabled="disabled" title="没有权限！！！"</c:if>
                                        data-id="${vo.id}"
                                        data-toggle="modal" data-target="#modal-edit">编辑
                                </button>
                                <button class="btn btn-rect btn-grad btn-primary btn-sm" <c:if test="${loginUser.userType != '管理员'}">disabled="disabled" title="没有权限！！！"</c:if> data-id="${vo.id}"
                                        data-toggle="modal" data-target="#modal-delete">删除
                                </button>

            </form>
        </div>
    </div>
</div>

<!-- info -->
<div class="modal fade" id="modal-info" tabindex="-1" role="dialog"
     aria-labelledby="myModalLabel">
    <div class="modal-dialog" role="document">
        <div class="modal-content">
            <form>
                <div class="modal-header">
                    <button type="button" class="close" data-dismiss="modal" aria-label="Close">

        let id = button.data('id');
        let modal = $(this);
        modal.find('#delete-id').val(id);
    })

    $('#modal-edit').on('show.bs.modal', function (event) {
        let button = $(event.relatedTarget);
        let id = button.data('id');
        let modal = $(this);
        $.ajax({
            url: 'userGet?id=' + id,
            type: "get",
            success: function (voString) {
                let vo = eval('(' + voString + ')');
                        modal.find('#edit-id').val(vo.id);
                        modal.find('#edit-username').val(vo.username);
                        modal.find('#edit-password').val(vo.password);
                        modal.find('#edit-realName').val(vo.realName);
                        for (let val of "男/女".split('/')) {
                            if (val == vo.userSex) {
                                modal.find('#edit-userSex_' + vo.userSex).prop("checked", true);
                            } else {
                                modal.find('#edit-userSex_' + vo.userSex).removeAttr("checked");
                            }
                        };

                <if test ='xiangmuSijian != null'>`xiangmu_sijian` = #{xiangmuSijian},</if>
                <if test ='xiangmuText != null'>`xiangmu_text` = #{xiangmuText}</if>
        </set>
        WHERE `id` = #{id}
    </update>

    <!--获取-->
    <select id="findById" resultMap="BaseResultMap">
        SELECT <include refid="Base_Column_List" /> FROM `t_xiangmu` WHERE `id` = #{id}
    </select>

    <!--列表-->
    <select id="findAllSplit" parameterType="java.util.Map" resultMap="BaseResultMap">
        SELECT <include refid="Base_Column_List" /> FROM `t_xiangmu`
        <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">
            LIMIT #{startIndex},#{pageSize};
        </if>
    </select>
    <!--数量-->

---

运行环境

Java≥6、Tomcat≥7.0、MySQL≥5.5

开发工具

eclipse/idea/myeclipse/sts等均可配置运行

技术框架

JavaWeb JavaBean JSP MVC MySQL Tomcat JavaScript Bootstrap Ajax

基础JSP+Servlet或JSP+SSM(Spring、SpringMVC、MyBatis)框架或JSP+SSM+Maven(pom.xml)框架或SpringBoot…均可

适用

课程设计，大作业，毕业设计，项目练习，学习演示等

功能说明

登录、注册、退出、用户模块、公告模块、参赛模块、成绩模块、开幕模块、项目模块的增删改查管理