基于javaweb+jsp的高校科研项目管理系统(JavaWeb MySQL JSP Bootstrap Servlet SSM SpringBoot)

基于javaweb+jsp的高校科研项目管理系统(JavaWeb MySQL JSP Bootstrap Servlet SSM SpringBoot)

JavaWeb JavaBean JSP MVC MySQL Tomcat JavaScript Bootstrap.

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

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

适用

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

    }
    public String getXmDate() {
        return xmDate;
    }

    public void setXmDate(String xmDate) {
        this.xmDate = xmDate;
    }
    public String getXmFei() {
        return xmFei;
    }

    public void setXmFei(String xmFei) {
        this.xmFei = xmFei;
    }
    public String getXmStatus() {
        return xmStatus;
    }

        this.userPhone = userPhone;
    }
    public String getUserText() {
        return userText;
    }

    public void setUserText(String userText) {
        this.userText = userText;
    }
    public String getUserType() {
        return userType;
    }

    public void setUserType(String userType) {
        this.userType = userType;
    }
}
package com.demo.vo;

import java.io.Serializable;

/**
 * 项目（t_xm表对应的Java实体类）
 */
public class Xm implements Serializable {

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

    <!--列表-->
    <select id="findAllSplit" parameterType="java.util.Map" resultMap="BaseResultMap">
        SELECT <include refid="Base_Column_List" /> FROM `t_notice`
        <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>
    <!--数量-->

    /**
     * 删除公告
     *
     * @param response
     * @param request
     * @throws IOException
     */
    @RequestMapping("noticeDelete")
    public void delete(HttpServletResponse response, HttpServletRequest request) throws IOException {
        Serializable id = Util.decode(request, "id");
        noticeService.delete(Arrays.asList(id));
        this.redirectList(request, response);
    }

    /**

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

    <!--列表-->
    <select id="findAllSplit" parameterType="java.util.Map" resultMap="BaseResultMap">
        SELECT <include refid="Base_Column_List" /> FROM `t_notice`
        <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>
    <!--数量-->
    <select id="getAllCount" parameterType="java.util.Map" resultType="Integer">
        SELECT COUNT(*) FROM `t_notice`
        <where>
            <if test="searchColumn != null and searchColumn != '' and keyword != null and keyword != ''">
                ${searchColumn} LIKE CONCAT('%',#{keyword},'%')  AND

        <table class="index-content-table-add">
            <tr>
                <td width="12%">人员编号：</td><td><input class="index-content-table-td-add" type="text" id="ryNo" name="ryNo" value="${vo.ryNo}"/></td>
            </tr>
            <tr>
                <td width="12%">姓名：</td><td><input class="index-content-table-td-add" type="text" id="ryName" name="ryName" value="${vo.ryName}"/></td>
            </tr>
            <tr>
                <td width="12%">年龄：</td><td><input class="index-content-table-td-add" type="text" id="ryAge" name="ryAge" value="${vo.ryAge}"/></td>
            </tr>
            <tr>
                <td width="12%">性别：</td>
                <td>
                   <input name="rySex" type="radio" value="男" ${vo.rySex=='男'?'checked':''}/>&nbsp;&nbsp;&nbsp;男&nbsp;&nbsp;&nbsp;&nbsp;
                   <input name="rySex" type="radio" value="女" ${vo.rySex=='女'?'checked':''}/>&nbsp;&nbsp;&nbsp;女&nbsp;&nbsp;&nbsp;&nbsp;
                </td>
            </tr>
            <tr>
                <td width="12%">联系方式：</td><td><input class="index-content-table-td-add" type="text" id="ryPhone" name="ryPhone" value="${vo.ryPhone}"/></td>
            </tr>
            <tr>
                <td width="12%">科研方向：</td><td><input class="index-content-table-td-add" type="text" id="ryTeam" name="ryTeam" value="${vo.ryTeam}"/></td>
            </tr>
            <tr>
                <td width="12%">备注：</td><td><textarea id="ryText" name="ryText" style="width: 60%; height: 100px;padding: 0px 17px;" placeholder="请输入内容......">${vo.ryText}</textarea></td>
            </tr>
        </table>

        }
        return true;
    }

	//@Override
    public void postHandle(HttpServletRequest httpServletRequest, HttpServletResponse httpServletResponse, Object o, ModelAndView modelAndView) throws Exception {

    }

	//@Override
    public void afterCompletion(HttpServletRequest httpServletRequest, HttpServletResponse httpServletResponse, Object o, Exception e) throws Exception {

    }
}
package com.demo.vo;

import java.io.Serializable;

/**
 * 用户（t_user表对应的Java实体类）
 */
public class User implements Serializable {
    private Long id;//主键
    private String username;//用户名

                <if test ='password != null'>`password` = #{password},</if>
                <if test ='realName != null'>`real_name` = #{realName},</if>
                <if test ='userSex != null'>`user_sex` = #{userSex},</if>
                <if test ='userPhone != null'>`user_phone` = #{userPhone},</if>
                <if test ='userText != null'>`user_text` = #{userText},</if>
                <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 != ''">

    public void setXmDate(String xmDate) {
        this.xmDate = xmDate;
    }
    public String getXmFei() {
        return xmFei;
    }

    public void setXmFei(String xmFei) {
        this.xmFei = xmFei;
    }
    public String getXmStatus() {
        return xmStatus;
    }

    public void setXmStatus(String xmStatus) {
        this.xmStatus = xmStatus;
    }

                    <if test ='id != null'>#{id},</if>
                    <if test ='ryNo != null'>#{ryNo},</if>
                    <if test ='ryName != null'>#{ryName},</if>
                    <if test ='ryAge != null'>#{ryAge},</if>
                    <if test ='rySex != null'>#{rySex},</if>
                    <if test ='ryPhone != null'>#{ryPhone},</if>
                    <if test ='ryTeam != null'>#{ryTeam},</if>
                    <if test ='ryText != null'>#{ryText}</if>
        </trim>
    </insert>

    <!--批量删除-->
    <delete id="doRemoveBatch" parameterType="java.util.Collection">
        DELETE FROM `t_renyuan` WHERE `id` IN
        <foreach collection="list" item="id" separator="," open="(" close=")">
            #{id}
        </foreach>
    </delete>

---

运行环境

Java≥6、Tomcat≥7.0、MySQL≥5.5

开发工具

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

技术框架

JavaWeb JavaBean JSP MVC MySQL Tomcat JavaScript Bootstrap.

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

适用

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

功能说明

登录、注册、退出、用户模块、公告模块、项目模块、科研人员模块的增删改查管理