基于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等均可配置运行

适用

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

    /**
     * 删除企业资产
     *
     * @param response
     * @param request
     * @throws IOException
     */
    @RequestMapping("zicanDelete")
    public void delete(HttpServletResponse response, HttpServletRequest request) throws IOException {
        Serializable id = Util.decode(request, "id");
        zicanService.delete(Arrays.asList(id));
        this.redirectList(request, response);
    }

    /**
     * 编辑企业资产
     *
     * @param response
     * @param request
     * @throws IOException
     */
    @RequestMapping("zicanEdit")
    public void edit(HttpServletResponse response, HttpServletRequest request) throws IOException {

                    <if test ='noticeText != null'>#{noticeText},</if>
                    <if test ='noticeType != null'>#{noticeType},</if>
                    <if test ='createDate != null'>#{createDate}</if>
        </trim>
    </insert>

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

    <!--修改-->
    <update id="doUpdate" parameterType="com.demo.vo.Notice">
        UPDATE `t_notice`
        <set>
                <if test ='id != null'>`id` = #{id},</if>
                <if test ='noticeName != null'>`notice_name` = #{noticeName},</if>

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

    <!--修改-->
    <update id="doUpdate" parameterType="com.demo.vo.User">
        UPDATE `t_user`
        <set>
                <if test ='id != null'>`id` = #{id},</if>
                <if test ='username != null'>`username` = #{username},</if>
                <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>

    public void edit(HttpServletResponse response, HttpServletRequest request) throws IOException {
        Salary vo = new Salary();
        vo.setId(Long.valueOf(Util.decode(request, "id")));
        vo.setSalaryName(Util.decode(request, "salaryName"));
        vo.setSalaryNo(Util.decode(request, "salaryNo"));
        vo.setSalaryDept(Util.decode(request, "salaryDept"));
        vo.setSalaryMoney(Util.decode(request, "salaryMoney"));
        vo.setSalaryText(Util.decode(request, "salaryText"));
        salaryService.update(vo);
        this.redirectList(request, response);
    }

    /**
     * 获取职工工资的详细信息（详情页面与编辑页面要显示该职工工资的详情）并跳转回页面
     *
     * @param response
     * @param request
     * @throws IOException
     */
    @RequestMapping({"salaryGet", "salaryEditPre"})
    public void get(HttpServletResponse response, HttpServletRequest request) throws IOException {
        Serializable id = Util.decode(request, "id");//取出主键id
        Salary vo = salaryService.get(id);
        request.getSession().setAttribute("vo", vo);

        <table class="index-content-table-add">
            <tr>
                <td width="12%">项目名称：</td><td><input class="index-content-table-td-add" type="text" id="jingyinName" name="jingyinName" value="${vo.jingyinName}"/></td>
            </tr>
            <tr>
                <td width="12%">时间：</td><td><input class="index-content-table-td-add" type="text" id="jingyinDate" name="jingyinDate" value="${vo.jingyinDate}"/></td>
            </tr>
            <tr>
                <td width="12%">投入(万元)：</td><td><input class="index-content-table-td-add" type="text" id="jingyinTou" name="jingyinTou" value="${vo.jingyinTou}"/></td>
            </tr>
            <tr>
                <td width="12%">收入(万元)：</td><td><input class="index-content-table-td-add" type="text" id="jingyinShou" name="jingyinShou" value="${vo.jingyinShou}"/></td>
            </tr>
            <tr>
                <td width="12%">利润(万元)：</td><td><input class="index-content-table-td-add" type="text" id="jingyinLirun" name="jingyinLirun" value="${vo.jingyinLirun}"/></td>
            </tr>
            <tr>
                <td width="12%">盈亏：</td>
                <td>
                   <input name="jingyinStatus" type="radio" value="盈利" ${vo.jingyinStatus=='盈利'?'checked':''}/>&nbsp;&nbsp;&nbsp;盈利&nbsp;&nbsp;&nbsp;&nbsp;
                   <input name="jingyinStatus" type="radio" value="亏损" ${vo.jingyinStatus=='亏损'?'checked':''}/>&nbsp;&nbsp;&nbsp;亏损&nbsp;&nbsp;&nbsp;&nbsp;
                </td>
            </tr>
            <tr>
                <td width="12%">备注：</td><td><textarea id="jingyinText" name="jingyinText" style="width: 60%; height: 100px;padding: 0px 17px;" placeholder="请输入内容......">${vo.jingyinText}</textarea></td>
            </tr>
        </table>

            response.sendRedirect("login.jsp");
            return false;
        }
        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 {

    }
}
<%@ page contentType="text/html; charset=UTF-8" pageEncoding="UTF-8" %>

        Map<String, Object> params = new HashMap();
        params.put("searchColumn", "username");//使用`username`字段进行模糊查询
        params.put("keyword", username);
        List<User> list = (List<User>) userService.list(params).get("list");
        for (User user : list) {
            if (user.getUsername().equals(username) && user.getPassword().equals(password)) {//找到这个管理员了
                request.getSession().setAttribute("loginUser", user);
                request.getRequestDispatcher("userList").forward(request, response);
                return;
            }
        }
        request.getSession().setAttribute("alert_msg", "错误：用户名或密码错误！");
        request.getRequestDispatcher("login.jsp").forward(request, response);
    }

    @RequestMapping("authRegister")
    public void register(HttpServletResponse response, HttpServletRequest request) throws IOException, ServletException {

     * @throws IOException
     */
    @RequestMapping("jingyinDelete")
    public void delete(HttpServletResponse response, HttpServletRequest request) throws IOException {
        Serializable id = Util.decode(request, "id");
        jingyinService.delete(Arrays.asList(id));
        this.redirectList(request, response);
    }

    /**
     * 编辑项目经营
     *
     * @param response
     * @param request
     * @throws IOException

                <if test ='jingyinName != null'>`jingyin_name` = #{jingyinName},</if>
                <if test ='jingyinDate != null'>`jingyin_date` = #{jingyinDate},</if>
                <if test ='jingyinTou != null'>`jingyin_tou` = #{jingyinTou},</if>
                <if test ='jingyinShou != null'>`jingyin_shou` = #{jingyinShou},</if>
                <if test ='jingyinLirun != null'>`jingyin_lirun` = #{jingyinLirun},</if>
                <if test ='jingyinStatus != null'>`jingyin_status` = #{jingyinStatus},</if>
                <if test ='jingyinText != null'>`jingyin_text` = #{jingyinText}</if>
        </set>
        WHERE `id` = #{id}
    </update>

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

    <!--列表-->
    <select id="findAllSplit" parameterType="java.util.Map" resultMap="BaseResultMap">
        SELECT <include refid="Base_Column_List" /> FROM `t_jingyin`
        <where>
            <if test="searchColumn != null and searchColumn != '' and keyword != null and keyword != ''">
                ${searchColumn} LIKE CONCAT('%',#{keyword},'%')  AND
            </if>
            1=1
        </where>

        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">
            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.

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

适用

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

功能说明

登录、注册、退出、用户模块、公告模块、职工工资模块、企业资产模块、项目经营模块的增删改查管理