客户关系管理项目——公告模块设计

<p><strong>一模块需求细化</strong></p>
<p>管理员可以负责公告的增删改查。所有的用户都具备公告的查阅功能。</p>
<p>具有公告权限的用户可以负责公告的发布，公告发布后所有的用户都需要查看。</p>
<p>每一个用户后可以显示所有未读公告的数量。</p>
<p><strong>二模块相关数据库实现</strong></p>
<p><img alt="" class="blockcode" src="https://beijingoptbbs.oss-cn-beijing.aliyuncs.com/cs/5606289-2808a9919702f59ef21729f2a774af35.png"></p>
<p>输入表</p>
<p>公告表：news</p>
<p>公告阅读记录：member_news</p>
<p>输出表</p>
<p>公告表：news</p>
<p><strong>三公告管理界面设计</strong></p>
<p>1 添加公告管理页面</p>
<pre class="blockcode"><code class="language-html"><%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>
<%@ taglib prefix="c" uri="http://www.ptpress.com.cn/c" %>
<%
String path = request.getContextPath();
String basePath = request.getScheme() + "://"
      + request.getServerName() + ":" + request.getServerPort()
      + path + "/";
String addUrl = basePath + "pages/back/news/NewsServletBack/add" ;
%>
<html>
<head>
<base href="<%=basePath%>">
<title>CRM管理系统</title>
<jsp:include page="/pages/plugins/import_file.jsp"/>
<link href="css/select.css" rel="stylesheet" type="text/css" />
<script type="text/javascript" src="<%=basePath%>js/jquery.idTabs.min.js"></script>
<script type="text/javascript" src="<%=basePath%>js/select-ui.min.js"></script>
<script type="text/javascript" src="<%=basePath%>js/editor/kindeditor.js"></script>
<script type="text/javascript" src="<%=basePath%>js/pages/back/news/news_add.js"></script>
<script type="text/javascript">
KE.show({
   id : 'news.note'
});
</script>
</head>
<body>
<div class="place">
   <span>位置：</span>
   <ul class="placeul">
      <li><a href="main.html" target="_top">首页</a></li>
      <li><a href="#">系统设置</a></li>
   </ul>
</div>
<div class="formbody">
   <div id="usual1" class="usual">
      <div class="itab">
         <ul>
            <li><a href="#tab1" class="selected">发布公告通知</a></li>
         </ul>
      </div>
      <div id="tab1" class="tabson">
         <div class="formtext">
            Hi，<b>${mid}</b>，欢迎您试用信息发布功能！
         </div>
         <form action="<%=addUrl%>" method="post" id="myform">
         <ul class="forminfo">
            <li><label>公告标题<b>*</b></label>
            <input id="news.title" name="news.title" type="text" class="dfinput" placeholder="请输入公告标题" style="width:518px;" /></li>
            <li><label>公告分类<b>*</b></label>
               <div class="vocation">
                  <select class="select1" id="news.type" name="news.type">
                     <option value="0">普通通知</option>
                     <option value="1">重要通知</option>
                  </select>
               </div></li>
            <li><label>通知内容<b>*</b></label>
               <textarea name="news.note" id="news.note" style="width:700px;height:250px;visibility:hidden;"></textarea>
            </li>
            <li><label>&nbsp;
            </label><input name="" type="submit" class="btn" value="马上发布" /></li>
         </ul>
         </form>
      </div>
   </div>
</div>
</body>
</html></code></pre>
<p>2 公告管理界面设计效果</p>
<p><img alt="" class="blockcode" src="https://beijingoptbbs.oss-cn-beijing.aliyuncs.com/cs/5606289-737234a30ce097fccabf420746e68233.png"></p>
<p>3 公告列表页面</p>
<pre class="blockcode"><code class="language-html"><%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>
<%@ taglib prefix="c" uri="http://www.ptpress.com.cn/c" %>
<%
String path = request.getContextPath();
String basePath = request.getScheme() + "://"
      + request

客户关系管理项目——公告模块设计

浏览过的版块