家庭记账本开发笔记

title: 家庭记账本实现笔记
date: 2020-01-31 11:57:26
tags:

预览网址：点我进入预览页面

1、作品展示

1、登陆页面

2、注册页面

点击登陆页面下方的蓝色小字即可进入注册页面

加入了判断，如果账号已注册，会提示账号已注册

3、登陆后主页面

金额：为要记账的金额。
账目类型：可选择支出或收入。
记账日期：当点击时默认选择当日的日期，可以自行更改。
备注：可以为该账目添加备注信息。

4、“我”导航页

1、我的信息

显示当前登陆的人的账号密码姓名信息。

2、修改密码

可以修改登陆密码。

3、月账单查询

可以根据月份查询账单信息。

当点击记账日期时默认选择当前月份，可以根据需要自行更改。
首先显示一个总账单，列出总收入和总支出，已经该月的收支总和。
其他的账目会根据记账顺序列出来。

2、开发笔记

1、框架的选择

首先在网上搜了很多的框架，移动端的优秀前端框架很多，但是大部分都是基于Vue.js来实现的，由于我还未学习Vue，所以就没有选择那些火热的框架，最终选择了一款多年前的框架---SUI Mobile。由于对前端框架不是很熟悉，所以使用起来还是有些不方便，也踩了不少坑，而去网上搜索解决问题时发现能找到的答案很少，由此看来选择一个热门的框架很重要，虽然技术不分好赖，但是使用人数多的技术生态好，解决问题很方便。下面是SUI的一些介绍：

SUI Mobile 是一套基于 Framework7 开发的UI库。它非常轻量、精美，只需要引入我们的CDN文件就可以使用，并且能兼容到 iOS 6.0+ 和 Android 4.0+，非常适合开发跨平台Web App。
轻量的UI库：SUI Mobile 非常轻量，核心库压缩Gzip后的JS、CSS网络传输体积总共只有52K，却提供了20+个常用的组件。对于只有HTML&CSS的组件，你只需要复制HTML代码既可以使用。他的大部分JS组件都是独立的 Zepto 插件，并且提供了 Zepto/jQuery 风格的API，你将会非常熟悉这种方式。
酷炫的IOS风格：我们的组件都是按照iOS风格设计的，所有有很多组件都是iOS独有的炫酷设计。

SUI是阿里巴巴共享业务事业部UED团队维护的，所以我也是相信他的强大并选择了这个框架。

2、页面代码

1、登陆页面

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
  <head>
    <meta charset="utf-8">
    <meta http-equiv="X-UA-Compatible" content="IE=edge">
    <title>记账本</title>
    <meta name="viewport" content="initial-scale=1, maximum-scale=1">
    <link rel="shortcut icon" href="/favicon.ico">
    <meta name="apple-mobile-web-app-capable" content="yes">
    <meta name="apple-mobile-web-app-status-bar-style" content="black">

    <link rel="stylesheet" href="//g.alicdn.com/msui/sm/0.6.2/css/sm.min.css">
    <link rel="stylesheet" href="//g.alicdn.com/msui/sm/0.6.2/css/sm-extend.min.css">
    <script type="text/javascript">
        function validata() {
            var account = document.getElementById("account").value;
            var password = document.getElementById("password").value;
            if(account==""){
                alert("请输入账号!");
                return ;
            }
            if(password==""){
                alert("请输入密码!");
                return ;
            }
            document.formName.submit();
        }
    </script>
  </head>
  <body>
    <div class="page-group">
        <!-- 头部标签 -->
        <header class="bar bar-nav">
          <h1 class='title'>登陆</h1>
        </header>
        
        <!-- 表单 -->
        <div class="content">
          <div class="list-block">
          <form action="${pageContext.request.contextPath }/login" method="post" name="formName">
            <ul>
              <!-- 账号 -->
              <li>
                <div class="item-content">
                  <div class="item-media"><i class="icon icon-form-name"></i></div>
                  <div class="item-inner">
                    <div class="item-title label">账号</div>
                    <div class="item-input">
                      <input type="text" placeholder="请输入账号" name="account" id="account">
                    </div>
                  </div>
                </div>
              </li>
              <!-- 密码 -->
              <li>
                <div class="item-content">
                  <div class="item-media"><i class="icon icon-form-password"></i></div>
                  <div class="item-inner">
                    <div class="item-title label">密码</div>
                    <div class="item-input">
                      <input type="password" placeholder="请输入密码" class="" name="password" id="password">
                    </div>
                  </div>
                </div>
              </li>
            </ul>
           </form>
          </div>
          <div class="content-block">
            <div class="row">
            <div class="col-50"><a href="javascript:alert('暂时还不支持自主找回密码哦，请联系作者!');" class="button button-big button-fill button-danger">忘记密码</a></div>
<div class="col-50"><a href="javascript:void(0);" class="button button-big button-fill button-success" onclick="validata()">登陆</a></div>
        </div>
<p>&nbsp;<a href="${pageContext.request.contextPath }/register.jsp">还没有账号？点我立即注册</a></p>
      </div>
</div>
    </div>

    <script type='text/javascript' src='//g.alicdn.com/sj/lib/zepto/zepto.min.js' charset='utf-8'></script>
    <script type='text/javascript' src='//g.alicdn.com/msui/sm/0.6.2/js/sm.min.js' charset='utf-8'></script>
    <script type='text/javascript' src='//g.alicdn.com/msui/sm/0.6.2/js/sm-extend.min.js' charset='utf-8'></script>

  </body>
</html>

2、注册页面

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
  <head>
    <meta charset="utf-8">
    <meta http-equiv="X-UA-Compatible" content="IE=edge">
    <title>记账本</title>
    <meta name="viewport" content="initial-scale=1, maximum-scale=1">
    <link rel="shortcut icon" href="/favicon.ico">
    <meta name="apple-mobile-web-app-capable" content="yes">
    <meta name="apple-mobile-web-app-status-bar-style" content="black">

    <link rel="stylesheet" href="//g.alicdn.com/msui/sm/0.6.2/css/sm.min.css">
    <link rel="stylesheet" href="//g.alicdn.com/msui/sm/0.6.2/css/sm-extend.min.css">
    <script type="text/javascript">
        function validata() {
            var account = document.getElementById("account").value;
            var password = document.getElementById("password").value;
            var username = document.getElementById("username").value;
            if(account==""){
                alert("请输入账号!");
                return ;
            }
            if(password==""){
                alert("请输入密码!");
                return ;
            }
            if(username==""){
                alert("请输入姓名!");
                return ;
            }
            document.formName.submit();
        }
    </script>
  </head>
  <body>
    <div class="page-group">
        <!-- 头部标签 -->
        <header class="bar bar-nav">
            <a class="button button-link button-nav pull-left" href="${pageContext.request.contextPath }/index.jsp" data-transition='slide-out'>
                  <span class="icon icon-left"></span>
                  返回
         </a>
          <h1 class='title'>注册</h1>
        </header>
        
        <!-- 表单 -->
        <div class="content">
          <div class="list-block">
          <form action="${pageContext.request.contextPath }/register" method="post" name="formName">
            <ul>
              <!-- 账号 -->
              <li>
                <div class="item-content">
                  <div class="item-media"><i class="icon icon-form-name"></i></div>
                  <div class="item-inner">
                    <div class="item-title label">账号</div>
                    <div class="item-input">
                      <input type="text" placeholder="请输入账号" name="account" id="account">
                    </div>
                  </div>
                </div>
              </li>
              <!-- 密码 -->
              <li>
                <div class="item-content">
                  <div class="item-media"><i class="icon icon-form-password"></i></div>
                  <div class="item-inner">
                    <div class="item-title label">密码</div>
                    <div class="item-input">
                      <input type="password" placeholder="请输入密码" class="" name="password" id="password">
                </div>
              </div>
            </div>
          </li>
      <!-- 姓名 -->
      <li>
        <div class="item-content">
          <div class="item-media"><i class="icon icon-form-name"></i></div>
          <div class="item-inner">
            <div class="item-title label">姓名</div>
            <div class="item-input">
              <input type="text" placeholder="请输入您的姓名" name="username" id="username">
            </div>
          </div>
        </div>
      </li>
        </ul>
        </form>
      </div>
      <div class="content-block">
        <div class="row">
<div class="col-50" style="margin-left: 110px;"><a href="javascript:void(0);" onclick="validata()" class="button button-big button-fill button-success">立即注册</a></div>
        </div>
      </div>
</div>
    </div>

    <script type='text/javascript' src='//g.alicdn.com/sj/lib/zepto/zepto.min.js' charset='utf-8'></script>
    <script type='text/javascript' src='//g.alicdn.com/msui/sm/0.6.2/js/sm.min.js' charset='utf-8'></script>
    <script type='text/javascript' src='//g.alicdn.com/msui/sm/0.6.2/js/sm-extend.min.js' charset='utf-8'></script>

  </body>
</html>

3、记账页面

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
  <head>
    <meta charset="utf-8">
    <meta http-equiv="X-UA-Compatible" content="IE=edge">
    <title>记账本</title>
    <meta name="viewport" content="initial-scale=1, maximum-scale=1">
    <link rel="shortcut icon" href="/favicon.ico">
    <meta name="apple-mobile-web-app-capable" content="yes">
    <meta name="apple-mobile-web-app-status-bar-style" content="black">

    <link rel="stylesheet" href="//g.alicdn.com/msui/sm/0.6.2/css/sm.min.css">
    <link rel="stylesheet" href="//g.alicdn.com/msui/sm/0.6.2/css/sm-extend.min.css">
    <script>
        day2 = new Date();
        day2.setTime(day2.getTime());
        var s2 = day2.getFullYear()+"-" + (day2.getMonth()+1) + "-" + day2.getDate();
        window.onload=function(){
            $("#money_date").calendar({
                value: [s2]
            });
        }
        
        function validata() {
            var money = document.getElementById("money").value;
            if(money==""){
                alert("请输入金额!");
                return ;
            }
            document.formName.submit();
        }
    </script>
  </head>
  <body>
    <div class="page-group">
        <div class="page page-current">
              <!-- 顶部标签-->
              <header class="bar bar-nav">
                <h1 class="title">记账</h1>
              </header>
              
              <!-- 底部导航栏-->
              <nav class="bar bar-tab">
                <!-- 第一个 -->
                <a class="tab-item active" href="jizhang.jsp">
                  <span class="icon icon-home"></span>
                  <span class="tab-label">记账</span>
                </a>
                <!-- 我的功能页 -->
                <a class="tab-item" href="me.jsp">
                  <span class="icon icon-me"></span>
                  <span class="tab-label">我</span>
                </a>
              </nav>
              <div class="content">
                <!-- 这里是页面内容区 -->
                <!-- 表单 -->
                <div class="list-block">
                    <form action="${pageContext.request.contextPath }/booking" method="post" name="formName">
                        <ul>
                            <li>
                                <div class="item-content">
                                      <div class="item-media"><i class="icon icon-form-name"></i></div>
                                          <div class="item-inner">
<div class="item-title label">金额</div>
<div class="item-input">
      <input type="text" placeholder="请输入要记入的金额" name="money" id="money">
</div>
              </div>
        </div>
</li>
<!-- 账目类型 -->
<li>
         <div class="item-content">
              <div class="item-media"><i class="icon icon-form-gender"></i></div>
              <div class="item-inner">
                <div class="item-title label">账目类型</div>
                <div class="item-input">
                  <select name="type">
                    <option value="add">收入</option>
                    <option value="down">支出</option>
                  </select>
                </div>
              </div>
        </div>
</li>
<!-- 日期 -->
<li>
        <div class="item-content">
              <div class="item-media"><i class="icon icon-form-calendar"></i></div>
              <div class="item-inner">
                <div class="item-title label">记账日期</div>
                <div class="item-input">
                  <input type="text" data-toggle='date' id="money_date" name="date"/>
                </div>
              </div>
        </div>
</li>
<li>
        <div class="item-content">
              <div class="item-media"><i class="icon icon-form-name"></i></div>
      <div class="item-inner">
<div class="item-title label">备注</div>
<div class="item-input">
      <input type="text" placeholder="请输入备注" name="remarks" id="remarks">
</div>
              </div>
        </div>
</li>
</ul>
</form>
</div>
<div class="content-block">
      <div class="row">
<div class="col-50" style="margin-left: 110px;"><a href="javascript:void(0);" class="button button-big button-fill button-success" onclick="validata()">立即入账</a></div>
      </div>
</div>
      </div>
</div>
       
    </div>

    <script type='text/javascript' src='//g.alicdn.com/sj/lib/zepto/zepto.min.js' charset='utf-8'></script>
    <script type='text/javascript' src='//g.alicdn.com/msui/sm/0.6.2/js/sm.min.js' charset='utf-8'></script>
    <script type='text/javascript' src='//g.alicdn.com/msui/sm/0.6.2/js/sm-extend.min.js' charset='utf-8'></script>

  </body>
</html>

4、“我” 页面

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
  <head>
    <meta charset="utf-8">
    <meta http-equiv="X-UA-Compatible" content="IE=edge">
    <title>记账本</title>
    <meta name="viewport" content="initial-scale=1, maximum-scale=1">
    <link rel="shortcut icon" href="/favicon.ico">
    <meta name="apple-mobile-web-app-capable" content="yes">
    <meta name="apple-mobile-web-app-status-bar-style" content="black">

    <link rel="stylesheet" href="//g.alicdn.com/msui/sm/0.6.2/css/sm.min.css">
    <link rel="stylesheet" href="//g.alicdn.com/msui/sm/0.6.2/css/sm-extend.min.css">
    <script>
        day2 = new Date();
        day2.setTime(day2.getTime());
        var s2 = day2.getFullYear()+"-" + (day2.getMonth()+1) + "-" + day2.getDate();
        window.onload=function(){
            $("#money_date").calendar({
                value: [s2]
            });
        }
    </script>
  </head>
  <body>
    <div class="page-group">
        <div class="page page-current">
              <!-- 顶部标签-->
              <header class="bar bar-nav">
                <h1 class="title">我</h1>
              </header>
              
              <!-- 底部导航栏-->
              <nav class="bar bar-tab">
                <!-- 第一个 -->
                <a class="tab-item" href="jizhang.jsp" external>
                  <span class="icon icon-home"></span>
                  <span class="tab-label">记账</span>
                </a>
                <!-- 我的功能页 -->
                <a class="tab-item active" href="me.jsp" external>
                  <span class="icon icon-me"></span>
                  <span class="tab-label">我</span>
                </a>
              </nav>
              <div class="content">
                <!-- 内容区域 -->
                <div class="list-block">
                    <ul>
                      <li class="item-content">
                        <div class="item-media"><i class="icon icon-f7"></i></div>
                        <div class="item-inner">
                            <a href="${pageContext.request.contextPath }/userUI"><font color="black">我的信息</font></a>
                        </div>
                      </li>
                      <li class="item-content">
                        <div class="item-media"><i class="icon icon-f7"></i></div>
                        <div class="item-inner">
                            <a href="${pageContext.request.contextPath }/fixpassword.jsp"><font color="black">修改密码</font></a>
            </div>
          </li>
          <li class="item-content">
            <div class="item-media"><i class="icon icon-f7"></i></div>
            <div class="item-inner">
<a href="chaxun.jsp" external><font color="black">月账单查询</font></a>
            </div>
          </li>
        </ul>
</div>
<div class="content-block">
      <div class="row">
<div class="col-100" style="margin-top: 90%;"><a href="${pageContext.request.contextPath }/logout" class="button button-big button-fill button-danger">退出登陆</a></div>
      </div>
</div>
      
</div> 
</div>
    </div>

    <script type='text/javascript' src='//g.alicdn.com/sj/lib/zepto/zepto.min.js' charset='utf-8'></script>
    <script type='text/javascript' src='//g.alicdn.com/msui/sm/0.6.2/js/sm.min.js' charset='utf-8'></script>
    <script type='text/javascript' src='//g.alicdn.com/msui/sm/0.6.2/js/sm-extend.min.js' charset='utf-8'></script>

  </body>
</html>

5、我的信息页面

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<%@taglib uri="http://java.sun.com/jsp/jstl/core"  prefix="c"%>
<!DOCTYPE html>
<html>
  <head>
    <meta charset="utf-8">
    <meta http-equiv="X-UA-Compatible" content="IE=edge">
    <title>我的生活</title>
    <meta name="viewport" content="initial-scale=1, maximum-scale=1">
    <link rel="shortcut icon" href="/favicon.ico">
    <meta name="apple-mobile-web-app-capable" content="yes">
    <meta name="apple-mobile-web-app-status-bar-style" content="black">

    <link rel="stylesheet" href="//g.alicdn.com/msui/sm/0.6.2/css/sm.min.css">
    <link rel="stylesheet" href="//g.alicdn.com/msui/sm/0.6.2/css/sm-extend.min.css">
    <script>
        day2 = new Date();
        day2.setTime(day2.getTime());
        var s2 = day2.getFullYear()+"-" + (day2.getMonth()+1) ;
        window.onload=function(){
            $("#chaxun_date").calendar({
                value: [s2],
                dateFormat: "yyyy-mm"
            });
        }
    </script>
  </head>
  <body>
    <div class="page-group">
        <div class="page page-current">
        <!-- 你的html代码 -->
            <header class="bar bar-nav">
                <a class="button button-link button-nav pull-left" href="${pageContext.request.contextPath }/me.jsp" data-transition='slide-out'>
                  <span class="icon icon-left"></span>
                  返回
                </a>
                <h1 class="title">我的信息</h1>
              </header>
              <div class="content">
                <!-- 这里是页面内容区 -->
                <div class="list-block">
                    <ul>
                      <li class="item-content">
                        <div class="item-media"><i class="icon icon-f7"></i></div>
                        <div class="item-inner">
                          <div class="item-title">账号</div>
                          <div class="item-after">${user.account }</div>
                        </div>
                      </li>
                      <li class="item-content">
                        <div class="item-media"><i class="icon icon-f7"></i></div>
                        <div class="item-inner">
                          <div class="item-title">密码</div>
                          <div class="item-after">${user.password }</div>
                        </div>
                      </li>
                      <li class="item-content">
                        <div class="item-media"><i class="icon icon-f7"></i></div>
                        <div class="item-inner">
                          <div class="item-title">姓名</div>
                          <div class="item-after">${user.username }</div>
            </div>
          </li>
        </ul>
      </div>

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

    <script type='text/javascript' src='//g.alicdn.com/sj/lib/zepto/zepto.min.js' charset='utf-8'></script>
    <script type='text/javascript' src='//g.alicdn.com/msui/sm/0.6.2/js/sm.min.js' charset='utf-8'></script>
    <script type='text/javascript' src='//g.alicdn.com/msui/sm/0.6.2/js/sm-extend.min.js' charset='utf-8'></script>

  </body>
</html>

6、修改密码页面

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<%@taglib uri="http://java.sun.com/jsp/jstl/core"  prefix="c"%>
<!DOCTYPE html>
<html>
  <head>
    <meta charset="utf-8">
    <meta http-equiv="X-UA-Compatible" content="IE=edge">
    <title>修改密码</title>
    <meta name="viewport" content="initial-scale=1, maximum-scale=1">
    <link rel="shortcut icon" href="/favicon.ico">
    <meta name="apple-mobile-web-app-capable" content="yes">
    <meta name="apple-mobile-web-app-status-bar-style" content="black">

    <link rel="stylesheet" href="//g.alicdn.com/msui/sm/0.6.2/css/sm.min.css">
    <link rel="stylesheet" href="//g.alicdn.com/msui/sm/0.6.2/css/sm-extend.min.css">
    <script type="text/javascript">
        function validata() {
            var repassword = document.getElementById("repassword").value;
            var password = document.getElementById("password").value;
            if(password!=repassword){
                alert("两次密码不一致!");
                return ;
            }
            document.formName.submit();
        }
    </script>
  </head>
  <body>
    <div class="page-group">
        <div class="page page-current">
        <!-- 你的html代码 -->
            <header class="bar bar-nav">
                <a class="button button-link button-nav pull-left" href="${pageContext.request.contextPath }/me.jsp" data-transition='slide-out'>
                  <span class="icon icon-left"></span>
                  返回
                </a>
                <h1 class="title">修改密码</h1>
              </header>
              <div class="content">
                <!-- 这里是页面内容区 -->
                <div class="list-block">
                    <form action="${pageContext.request.contextPath }/fixPassword" method="post" name="formName">
                        <ul>
                            <li>
                                <div class="item-content">
                                      <div class="item-media"><i class="icon icon-form-calendar"></i></div>
                                      <div class="item-inner">
                                        <div class="item-title label">新密码</div>
                                        <div class="item-input">
                                          <input type="password" placeholder="请输入密码" class="" name="password" id="password">
                                        </div>
                                      </div>
                                </div>
                            </li>
                            <li>
                                <div class="item-content">
                                      <div class="item-media"><i class="icon icon-form-calendar"></i></div>
          <div class="item-inner">
            <div class="item-title label">重复密码</div>
            <div class="item-input">
              <input type="password" placeholder="再次输入密码" class=""  id="repassword">
            </div>
          </div>
</div>
</li>
</ul>
</form>
</div>
<!-- 查询按钮 -->
<div class="content-block">
      <div class="row">
<div class="col-50" style="margin-left: 110px;"><a href="javascript:void(0);" class="button button-big button-fill button-success" onclick="validata()" >修改密码</a></div>
      </div>
</div>

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

    <script type='text/javascript' src='//g.alicdn.com/sj/lib/zepto/zepto.min.js' charset='utf-8'></script>
    <script type='text/javascript' src='//g.alicdn.com/msui/sm/0.6.2/js/sm.min.js' charset='utf-8'></script>
    <script type='text/javascript' src='//g.alicdn.com/msui/sm/0.6.2/js/sm-extend.min.js' charset='utf-8'></script>

  </body>
</html>

7、月账单查询页面

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<%@taglib uri="http://java.sun.com/jsp/jstl/core"  prefix="c"%>
<!DOCTYPE html>
<html>
  <head>
    <meta charset="utf-8">
    <meta http-equiv="X-UA-Compatible" content="IE=edge">
    <title>我的生活</title>
    <meta name="viewport" content="initial-scale=1, maximum-scale=1">
    <link rel="shortcut icon" href="/favicon.ico">
    <meta name="apple-mobile-web-app-capable" content="yes">
    <meta name="apple-mobile-web-app-status-bar-style" content="black">

    <link rel="stylesheet" href="//g.alicdn.com/msui/sm/0.6.2/css/sm.min.css">
    <link rel="stylesheet" href="//g.alicdn.com/msui/sm/0.6.2/css/sm-extend.min.css">
    <script>
        day2 = new Date();
        day2.setTime(day2.getTime());
        var s2 = day2.getFullYear()+"-" + (day2.getMonth()+1) ;
        window.onload=function(){
            $("#chaxun_date").calendar({
                value: [s2],
                dateFormat: "yyyy-mm"
            });
        }
    </script>
  </head>
  <body>
    <div class="page-group">
        <div class="page page-current">
        <!-- 你的html代码 -->
            <header class="bar bar-nav">
                <a class="button button-link button-nav pull-left" href="${pageContext.request.contextPath }/me.jsp" data-transition='slide-out'>
                  <span class="icon icon-left"></span>
                  返回
                </a>
                <h1 class="title">月账单查询</h1>
              </header>
              <div class="content">
                <!-- 这里是页面内容区 -->
                <div class="list-block">
                    <form action="${pageContext.request.contextPath }/inquire" method="post" name="formName">
                        <ul>
                            <li>
                                <div class="item-content">
                                      <div class="item-media"><i class="icon icon-form-calendar"></i></div>
                                      <div class="item-inner">
                                        <div class="item-title label">记账日期</div>
                                        <div class="item-input">
                                          <input type="text" data-toggle='date' id="chaxun_date" name="date_chaxun"/>
                                        </div>
                                      </div>
                                </div>
                            </li>
                        </ul>
                    </form>
                </div>
                <!-- 查询按钮 -->
                <div class="content-block">
      <div class="row">
<div class="col-50" style="margin-left: 110px;"><a href="javascript:document.formName.submit();" class="button button-big button-fill button-success">立即查询</a></div>
      </div>
</div>


<c:if test="${msg=='y' }">
<!-- 显示详细项目列表区域 -->
<div class="list-block media-list inset">
          <ul>
            <li>
              <a href="#" class="item-link item-content">
                <div class="item-media"><img src="http://gqianniu.alicdn.com/bao/uploaded/i4//tfscom/i3/TB10LfcHFXXXXXKXpXXXXXXXXXX_!!0-item_pic.jpg_250x250q60.jpg" width="44"></div>
                <div class="item-inner">
                  <div class="item-title-row">
                    <div class="item-title">总账单</div>
                  </div>
                  <div class="item-subtitle">总支出&nbsp;&nbsp;&nbsp;${downSum }元</div>
      <div class="item-subtitle">总收入&nbsp;&nbsp;&nbsp;${addSum }元</div>
      <div class="item-subtitle">收支总和&nbsp;&nbsp;&nbsp;${sum }元</div>
                </div>
              </a>
            </li>

<c:forEach items="${allList }" var="list">
<li>
      <a href="#" class="item-link item-content">
        <div class="item-media"><img src="http://gqianniu.alicdn.com/bao/uploaded/i4//tfscom/i3/TB10LfcHFXXXXXKXpXXXXXXXXXX_!!0-item_pic.jpg_250x250q60.jpg" width="44"></div>
        <div class="item-inner">
          <div class="item-title-row">
            <div class="item-title">${list.type}</div>
          </div>
          <c:if test="${list.type=='收入'}">
         <div class="item-subtitle"><font color="red">${list.money}元</font></div>
          </c:if>
          <c:if test="${list.type=='支出'}">
         <div class="item-subtitle"><font color="green">${list.money}元</font></div>
          </c:if>
          <div class="item-subtitle">备注:${list.remarks}</div>
        </div>
      </a>
</li>
</c:forEach>

          </ul>
        </div>
</c:if>

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

    <script type='text/javascript' src='//g.alicdn.com/sj/lib/zepto/zepto.min.js' charset='utf-8'></script>
    <script type='text/javascript' src='//g.alicdn.com/msui/sm/0.6.2/js/sm.min.js' charset='utf-8'></script>
    <script type='text/javascript' src='//g.alicdn.com/msui/sm/0.6.2/js/sm-extend.min.js' charset='utf-8'></script>

  </body>
</html>

3、servlet代码

1、记账servlet

package com.cashbook.web;

import java.io.IOException;
import java.sql.SQLException;

import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.Cookie;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import com.cashbook.dao.NoteDao;
import com.cashbook.domain.NotesBean;

/**
 * Servlet implementation class BookingServlet
 */
@WebServlet("/booking")
public class BookingServlet extends HttpServlet {
    protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        
        request.setCharacterEncoding("UTF-8");
        response.setContentType("text/html;charset=utf-8");
        //获取记录的金额
        String moneyString = request.getParameter("money");
        int money =Integer.valueOf(moneyString);
        
        //获取记录的类型
        String type = request.getParameter("type");
        String typeString = null;
        if(type.equals("add")) {
            typeString = "收入";
        }else {
            typeString = "支出";
        }
        //获取记录的时间
        String date = request.getParameter("date");
        //获取记录的人
        Cookie[] cookies = request.getCookies();
        String useraccount = null;
        for (Cookie cookie : cookies) {
            if(cookie.getName().equals("account")) {
                useraccount = cookie.getValue();
                break;
            }
        }
        //获取备注
        String remarks = request.getParameter("remarks");
        NotesBean note = new NotesBean();
        note.setDate(date);
        note.setMoney(money);
        note.setType(typeString);
        note.setUseraccount(useraccount);
        note.setRemarks(remarks);
        try {
            NoteDao.addNote(note);
        } catch (SQLException e) {
            response.getWriter().write("<script>alert('入账失败！');window.location.href='"+request.getContextPath()+"/jizhang.jsp'</script>");
            e.printStackTrace();
        }
        response.getWriter().write("<script>alert('入账成功！');window.location.href='"+request.getContextPath()+"/jizhang.jsp'</script>");
    }

    /**
     * @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)
     */
    protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        // TODO Auto-generated method stub
        doGet(request, response);
    }

}

2、修改密码servlet

package com.cashbook.web;

import java.io.IOException;
import java.sql.SQLException;

import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.Cookie;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import com.cashbook.dao.UserDao;

/**
 * Servlet implementation class FixPasswordServlet
 */
@WebServlet("/fixPassword")
public class FixPasswordServlet extends HttpServlet {
    
    protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        
        request.setCharacterEncoding("UTF-8");
        response.setContentType("text/html;charset=utf-8");
        Cookie[] cookies = request.getCookies();
        String useraccount = null;
        for (Cookie cookie : cookies) {
            if(cookie.getName().equals("account")) {
                useraccount = cookie.getValue();
                break;
            }
        }
        String password = request.getParameter("password");
        try {
            UserDao.fixPassword(useraccount,password);
        } catch (SQLException e) {
            response.getWriter().write("<script>alert('密码修改失败！');window.location.href='"+request.getContextPath()+"/me.jsp'</script>");
            e.printStackTrace();
        }
        response.getWriter().write("<script>alert('密码修改成功！请牢记新密码:"+password+"');window.location.href='"+request.getContextPath()+"/me.jsp'</script>");
    }

    /**
     * @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)
     */
    protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        // TODO Auto-generated method stub
        doGet(request, response);
    }

}

3、月账单查询servlet

package com.cashbook.web;

import java.io.IOException;
import java.sql.SQLException;
import java.util.List;

import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.Cookie;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import com.cashbook.dao.NoteDao;
import com.cashbook.domain.NotesBean;

/**
 * Servlet implementation class InquireServlet
 */
@WebServlet("/inquire")
public class InquireServlet extends HttpServlet {
    
    protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {

        request.setCharacterEncoding("UTF-8");
        response.setContentType("text/html;charset=utf-8");
        String date_chaxun = request.getParameter("date_chaxun");
        Cookie[] cookies = request.getCookies();
        String useraccount = null;
        for (Cookie cookie : cookies) {
            if(cookie.getName().equals("account")) {
                useraccount = cookie.getValue();
                break;
            }
        }
        List<NotesBean> addList = null;
        List<NotesBean> downList = null;
        List<NotesBean> allList = null;
        //获取所有列表
        try {
            allList = NoteDao.inquire_all(useraccount,date_chaxun);
        } catch (SQLException e) {
            e.printStackTrace();
        }       
        //获取收入列表
        try {
            addList = NoteDao.inquire_add(useraccount,date_chaxun);
        } catch (SQLException e) {
            e.printStackTrace();
        }
        //获取收入列表
        try {
            downList = NoteDao.inquire_down(useraccount,date_chaxun);
        } catch (SQLException e) {
            e.printStackTrace();
        }
        int addSum=0,downSum=0,sum=0;
        //获取总支出
        if(downList!=null) {
            for (NotesBean notesBean : downList) {
                downSum+=notesBean.getMoney();
            }
        }
        //获取总收入
        if (downList != null) {
            for (NotesBean notesBean : addList) {
                addSum += notesBean.getMoney();
            }
        }
        sum=addSum-downSum;
        String sumString = String.valueOf(sum);
        String addString = String.valueOf(addSum);
        String downString = String.valueOf(downSum);
        request.setAttribute("sum",sumString);
        request.setAttribute("addSum",addString);
        request.setAttribute("downSum",downString);
        request.setAttribute("allList",allList);
        request.setAttribute("msg","y");
        request.getRequestDispatcher("/chaxun.jsp").forward(request, response);
    }

    /**
     * @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)
     */
    protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        // TODO Auto-generated method stub
        doGet(request, response);
    }

}

4、登陆servlet

package com.cashbook.web;

import java.io.IOException;
import java.sql.SQLException;

import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.Cookie;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import com.cashbook.dao.UserDao;

/**
 * Servlet implementation class LoginServlet
 */
@WebServlet("/login")
public class LoginServlet extends HttpServlet {
    protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        
        request.setCharacterEncoding("UTF-8");
        response.setContentType("text/html;charset=utf-8"); 
        String account = request.getParameter("account");
        String password = request.getParameter("password");
        boolean pd = false;
        try {
            pd = UserDao.login(account,password);
        } catch (SQLException e) {
            e.printStackTrace();
        }
        if(!pd) {
            response.getWriter().write("<script>alert('账号或密码错误！');window.location.href='"+request.getContextPath()+"/index.jsp'</script>");
        }else {
            //存下用户信息
            Cookie cookie = new Cookie("account", account);
            response.addCookie(cookie);
            request.getRequestDispatcher("/jizhang.jsp").forward(request, response);
        }
    }

    /**
     * @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)
     */
    protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        // TODO Auto-generated method stub
        doGet(request, response);
    }

}

5、退出登陆servlet

package com.cashbook.web;

import java.io.IOException;
import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.Cookie;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

/**
 * Servlet implementation class LogoutServlet
 */
@WebServlet("/logout")
public class LogoutServlet extends HttpServlet {
    protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        Cookie cookie = new Cookie("account", "");
        cookie.setMaxAge(0);
        response.addCookie(cookie);
        response.sendRedirect(request.getContextPath()+"/index.jsp");
    }

    /**
     * @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)
     */
    protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        // TODO Auto-generated method stub
        doGet(request, response);
    }

}

6、注册servlet

package com.cashbook.web;

import java.io.IOException;
import java.lang.reflect.InvocationTargetException;
import java.sql.SQLException;
import java.util.Map;
import java.util.UUID;

import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import org.apache.commons.beanutils.BeanUtils;

import com.cashbook.dao.UserDao;
import com.cashbook.domain.UserBean;
import com.cashbook.utils.MyException;

/**
 * Servlet implementation class RegisterServlet
 */
@WebServlet("/register")
public class RegisterServlet extends HttpServlet {
    protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {

        request.setCharacterEncoding("UTF-8");
        response.setContentType("text/html;charset=utf-8"); 
        Map<String, String[]> parameterMap = request.getParameterMap();
        UserBean user = new UserBean();
        
        //获取账号密码等注册信息
        user.setAccount(request.getParameter("account"));
        user.setPassword(request.getParameter("password"));
        user.setUsername(request.getParameter("username"));
        //生成用户的id
        try {
            user.setId(UUID.randomUUID().toString());
        } catch (Exception e1) {
            e1.printStackTrace();
        }
        
        //注册
        try {
            UserDao.addUser(user);
        } catch (SQLException e) {
            //运行异常
            response.getWriter().write("<script>alert('注册失败！');window.location.href='"+request.getContextPath()+"/register.jsp'</script>");
            e.printStackTrace();
        } catch (MyException e) {
            //账号已存在的异常
            response.getWriter().write("<script>alert('该账号已存在！');window.location.href='"+request.getContextPath()+"/register.jsp'</script>");
            e.printStackTrace();
        }
        response.getWriter().write("<script>alert('注册成功！');window.location.href='"+request.getContextPath()+"/index.jsp'</script>");
    }

    /**
     * @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)
     */
    protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        // TODO Auto-generated method stub
        doGet(request, response);
    }

}

7、展示用户信息界面servlet

package com.cashbook.web;

import java.io.IOException;
import java.sql.SQLException;

import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.Cookie;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import com.cashbook.dao.UserDao;
import com.cashbook.domain.UserBean;

/**
 * Servlet implementation class UserUIServlet
 */
@WebServlet("/userUI")
public class UserUIServlet extends HttpServlet {
    
    protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        
        Cookie[] cookies = request.getCookies();
        String useraccount = null;
        for (Cookie cookie : cookies) {
            if(cookie.getName().equals("account")) {
                useraccount = cookie.getValue();
                break;
            }
        }
        UserBean user = null;
        try {
            user = UserDao.userUI(useraccount);
        } catch (SQLException e) {
            e.printStackTrace();
        }
        request.setAttribute("user", user);
        request.getRequestDispatcher("/aboutme.jsp").forward(request, response);
        
    }

    /**
     * @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)
     */
    protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        // TODO Auto-generated method stub
        doGet(request, response);
    }

}

4、dao层代码

1、账目记录操作的dao

package com.cashbook.dao;

import java.sql.SQLException;
import java.util.List;

import org.apache.commons.dbutils.QueryRunner;
import org.apache.commons.dbutils.handlers.BeanListHandler;

import com.cashbook.domain.NotesBean;
import com.cashbook.utils.MyDataSoureUtils;

public class NoteDao {

    public static void addNote(NotesBean note) throws SQLException {
        QueryRunner qr = new QueryRunner(MyDataSoureUtils.getDataSource());
        String sql = "insert into notes values(?,?,?,?,?)";
        qr.update(sql, note.getUseraccount(),note.getMoney(),note.getType(),note.getDate(),note.getRemarks());
    }


    public static List<NotesBean> inquire_add(String useraccount, String date_chaxun) throws SQLException {
        QueryRunner qr = new QueryRunner(MyDataSoureUtils.getDataSource());
        String sql = "select * from notes where useraccount=? and type=? and date between ? and ?";
        List<NotesBean> query = qr.query(sql, new BeanListHandler<NotesBean>(NotesBean.class), useraccount,"收入",date_chaxun+"-01",date_chaxun+"-31");
        return query;
    }


    public static List<NotesBean> inquire_down(String useraccount, String date_chaxun) throws SQLException {
        QueryRunner qr = new QueryRunner(MyDataSoureUtils.getDataSource());
        String sql = "select * from notes where useraccount=? and type=? and date between ? and ?";
        List<NotesBean> query = qr.query(sql, new BeanListHandler<NotesBean>(NotesBean.class), useraccount,"支出",date_chaxun+"-01",date_chaxun+"-31");
        return query;
    }


    public static List<NotesBean> inquire_all(String useraccount, String date_chaxun) throws SQLException {
        QueryRunner qr = new QueryRunner(MyDataSoureUtils.getDataSource());
        String sql = "select * from notes where useraccount=? and date between ? and ?";
        List<NotesBean> query = qr.query(sql, new BeanListHandler<NotesBean>(NotesBean.class), useraccount,date_chaxun+"-01",date_chaxun+"-31");
        return query;
    }

}

2、用户操作的dao

package com.cashbook.dao;

import java.sql.SQLException;

import org.apache.commons.dbutils.QueryRunner;
import org.apache.commons.dbutils.handlers.BeanHandler;
import org.apache.commons.dbutils.handlers.ScalarHandler;

import com.cashbook.domain.UserBean;
import com.cashbook.utils.MyDataSoureUtils;
import com.cashbook.utils.MyException;

public class UserDao {
    
    public static void addUser(UserBean user) throws SQLException, MyException {
        QueryRunner qr = new QueryRunner(MyDataSoureUtils.getDataSource());
        String sql = "insert into user values(?,?,?,?)";
        String sql2 = "select count(*) from user where account=?";
        Long query = (Long) qr.query(sql2, new ScalarHandler(), user.getAccount());
        int num = query.intValue();
        if(num!=0) {
            throw new MyException("该账号已存在!");
        }
        qr.update(sql, user.getId(),user.getAccount(),user.getPassword(),user.getUsername());
    }

    public static boolean login(String account, String password) throws SQLException {
        QueryRunner qr = new QueryRunner(MyDataSoureUtils.getDataSource());
        boolean pd = false;
        String sql = "select * from user where account=? and password=?";
        UserBean query = null;
        query = qr.query(sql, new BeanHandler<UserBean>(UserBean.class), account,password);
        if(query!=null) {
            pd = true;
        }
        return pd;
    }

    public static UserBean userUI(String useraccount) throws SQLException {
        QueryRunner qr = new QueryRunner(MyDataSoureUtils.getDataSource());
        String sql = "select * from user where account=?";
        UserBean query = qr.query(sql, new BeanHandler<UserBean>(UserBean.class), useraccount);
        return query;
    }

    public static void fixPassword(String useraccount, String password) throws SQLException {
        QueryRunner qr = new QueryRunner(MyDataSoureUtils.getDataSource());
        String sql = "update user set password=? where account=?";
        qr.update(sql, password,useraccount);
    }

}

3、总结

框架的选择比较重要。
长时间没写web以致开发过程中有些小问题都看不出来，果然还是要每天都学习。
开发难度并不大，处理好业务逻辑很重要，而我需要这方面的大量练习。

posted @ 2020-01-31 12:41 Nevesettle 阅读(438) 评论(0) 编辑收藏举报

刷新页面返回顶部

无人i

家庭记账本开发笔记

1、作品展示

1、登陆页面

2、注册页面

3、登陆后主页面

4、“我”导航页

1、我的信息

2、修改密码

3、月账单查询

2、开发笔记

1、框架的选择

2、页面代码

1、登陆页面

2、注册页面

3、记账页面

4、“我” 页面

5、我的信息页面

6、修改密码页面

7、月账单查询页面

3、servlet代码

1、记账servlet

2、修改密码servlet

3、月账单查询servlet

4、登陆servlet

5、退出登陆servlet

6、注册servlet

7、展示用户信息界面servlet

4、dao层代码

1、账目记录操作的dao

2、用户操作的dao

3、总结

公告