基于javaweb+mysql的个人日记管理系统

基于javaweb+mysql的个人日记管理系统

运行环境

Java≥8、MySQL≥5.7、Tomcat≥8

开发工具

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

适用

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

功能说明

个人日记的增删改查管理

技术框架

JSP Servlet MySQL CSS JavaScript layui

---

  	
    <div class="x-body">
      <div class="layui-row">
        <form class="layui-form layui-col-md12 x-so">
          <input class="layui-input" placeholder="开始日" name="start" id="start">
          <input class="layui-input" placeholder="截止日" name="end" id="end">
          <input type="text" name="keyword"  placeholder="请输入查询关键字" autocomplete="off" class="layui-input">
          <button class="layui-btn"  lay-submit="" lay-filter="sreach"><i class="layui-icon">&#xe615;</i></button>
        </form>
      </div>
      <xblock>
        <button class="layui-btn layui-btn-danger" onclick="delAll()"><i class="layui-icon"></i>批量删除</button>
        <button class="layui-btn" onclick="x_admin_show('添加用户','./daily-record.jsp')"><i class="layui-icon"></i>添加</button>
        <span class="x-right" style="line-height:40px">共有数据：<c:out value="${dailyCustom.count }" default="0"/> 条</span>
      </xblock>

              <div class="">
                  <textarea style="min-width:500px;min-height:200px;max-width:500px;max-height:200px" class="layui-textarea">${descDaily.context }
                  </textarea>
              </div>
          </div>
          <div class="layui-form-item">
              <label for="record" class="layui-form-label">
                  	感言
              </label>
              <div class="layui-input-inline">
                  <input type="text" id="record" name="record" value="${descDaily.records }" style="width:500px"
                  autocomplete="off" class="layui-input" disabled>
              </div>
          </div>

          <div class="layui-form-item">
              <label for="createtime" class="layui-form-label">
                  	发表时间
              </label>
              <div class="layui-input-inline">
              	<input type="text" id="uname" name="uname" value='${descDaily.createtime }'
                  autocomplete="off" class="layui-input" disabled>
                  <p></p>

                                  <option <c:if test="${'读书'==descDaily.type}">selected</c:if>>读书</option>
                                  <option <c:if test="${'学习'==descDaily.type}">selected</c:if>>学习</option>--%>

                <option value="生活">生活</option>
                <option value="电影">电影</option>
                <option value="音乐">音乐</option>
                <option value="读书">读书</option>
                <option value="学习">学习</option>
            </select>
        </div>
    </div>

    <div class="layui-form-item">
        <label class="layui-form-label">内容：</label>
        <div class="layui-input-block">
            <textarea placeholder="请输入内容" class="layui-textarea" name="context"
                      id="context">${descDaily.context }</textarea>
        </div>
    </div>
    <div class="layui-form-item">
        <label class="layui-form-label">总结：</label>
        <div class="layui-input-block">
            <input type="text" name="records" id="records" required
                   autocomplete="off" class="layui-input" value="${descDaily.records }">

import com.alibaba.fastjson.JSON;
import com.alibaba.fastjson.JSONObject;

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 javax.servlet.http.HttpSession;
import java.io.IOException;
import java.util.HashMap;
import java.util.Map;

/**
 * Servlet implementation class DailyAddServlet
 */
@WebServlet("/dailyUpdateServlet")
public class DailyUpdateServlet extends HttpServlet {
	private static final long serialVersionUID = 1L;

    /**
     * @see HttpServlet#HttpServlet()
     */
    public DailyUpdateServlet() {
        super();
        // TODO Auto-generated constructor stub

	}

	public void setDailyList(List<Daily> dailyList) {
		this.dailyList = dailyList;
	}

	@Override
	public String toString() {
		return "DailyCustom [pageIndex=" + pageIndex + ", pageSize=" + pageSize + ", count=" + count + ", dailyList="
				+ dailyList + "]";
	}
	
}
<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
    <%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c" %>
    <%@ taglib uri="http://java.sun.com/jsp/jstl/fmt" prefix="fmt" %>
<!DOCTYPE html>
<html>
  
  <head>
    <meta charset="UTF-8">
    <title>欢迎页面-生活点滴记录系统</title>
    <meta name="renderer" content="webkit">
    <meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1">
    <meta name="viewport" content="width=device-width,user-scalable=yes, minimum-scale=0.4, initial-scale=0.8,target-densitydpi=low-dpi" />
    <link rel="shortcut icon" href="/favicon.ico" type="image/x-icon" />

            session.setAttribute("url", "/login.jsp");
            request.getRequestDispatcher("/forward.jsp").forward(request, response);
        }
    }
}
package cn.demo.servlet;

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

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 cn.demo.vo.Daily;
import cn.demo.vo.DailyCustom;
import cn.demo.service.DailyService;

  </body>

</html>
<%@ page language="java" contentType="text/html; charset=UTF-8"
         pageEncoding="UTF-8" %>
<!DOCTYPE html>
<html>

<head>
    <meta charset="UTF-8">
    <title>后台管理-生活点滴记录系统</title>
    <meta name="renderer" content="webkit">
    <meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1">
    <meta name="viewport"
          content="width=device-width,user-scalable=yes, minimum-scale=0.4, initial-scale=0.8,target-densitydpi=low-dpi"/>

 */
@WebServlet("/dailyAddServlet")
public class DailyAddServlet extends HttpServlet {
	private static final long serialVersionUID = 1L;
       
    /**
     * @see HttpServlet#HttpServlet()
     */
    public DailyAddServlet() {
        super();
        // TODO Auto-generated constructor stub
    }

	/**
	 * @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)

import java.util.List;

public class DailyImpl implements IDaily {

    @Override
    public int insertDaily(Daily daily) {
        int result = 0;
        try {
            DateFormat df = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
            df.format(new Date());
            String sql = "insert into daily(title,context,recorded,uid,createtime,type) values(?,?,?,?,?,?)";
            Object[] objects = {daily.getTitle(), daily.getContext(), daily.getRecords(), daily.getUid(),
                    new java.sql.Timestamp(df.parse(df.format(new Date())).getTime()), daily.getType()};
            result = Util.method(sql, objects);
        } catch (ParseException e) {
            e.printStackTrace();
        }
        return result;
    }

	}

	public void setUid(int uid) {
		this.uid = uid;
	}

	public String getRecords() {
		return records;
	}

	public void setRecords(String records) {
		this.records = records;
	}

	@Override
	public String toString() {

import cn.demo.vo.Daily;
import cn.demo.vo.User;
import cn.demo.service.DailyService;
import cn.demo.service.impl.DailyServiceImpl;
import com.alibaba.fastjson.JSON;
import com.alibaba.fastjson.JSONObject;

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 javax.servlet.http.HttpSession;
import java.io.IOException;
import java.util.HashMap;
import java.util.Map;

/**
 * Servlet implementation class DailyAddServlet
 */
@WebServlet("/dailyUpdateServlet")
public class DailyUpdateServlet extends HttpServlet {
	private static final long serialVersionUID = 1L;

    /**

                daily.setUid(rs.getInt(5));
                daily.setRecords(rs.getString(6));
                daily.setCreatetime(rs.getDate(7));
                dailyList.add(daily);
            }
        } catch (SQLException e) {
            e.printStackTrace();
        } finally {
            Util.close(conn, ps, rs);
        }
        return dailyList;
    }

    @Override
    public List<Daily> getAllDailyByPage(int pageIndex, int pageSize, String keyword, String start, String end) {
        List<Daily> dailyList = new ArrayList<Daily>();
        Connection conn = null;
        PreparedStatement ps = null;

	private int pageTotal;
	private List<Daily> dailyList;
	
	public DailyCustom() {}

	public DailyCustom(int pageIndex, int pageSize, int count,int pageTotal, List<Daily> dailyList) {
		this.pageIndex = pageIndex;
		this.pageSize = pageSize;
		this.count = count;
		this.pageTotal = pageTotal;
		this.dailyList = dailyList;
	}

	public int getPageIndex() {
		return pageIndex;
	}

	public void setPageIndex(int pageIndex) {
		this.pageIndex = pageIndex;
	}

      </form>
    </div>
    <script>
      layui.use(['form','layer'], function(){
          $ = layui.jquery;
        var form = layui.form
        ,layer = layui.layer;
      
        //自定义验证规则
        form.verify({
          nikename: function(value){
            if(value.length < 5){
              return '昵称至少得5个字符啊';
            }
          }
          ,pass: [/(.+){6,12}$/, '密码必须6到12位']
          ,repass: function(value){
              if($('#L_pass').val()!=$('#L_repass').val()){
                  return '两次密码不一致';
              }
          }
        });

        //监听提交
        form.on('submit(add)', function(data){
          console.log(data);
          //发异步，把数据提交给php

import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;
import java.io.IOException;


@WebServlet("/userServlet")
public class UserServlet extends HttpServlet {
    private static final long serialVersionUID = 1L;
    private UserService userService = null;

    public UserServlet() {
        userService = new UserServiceImpl();
    }

    protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        doPost(request, response);