WEB-小项目（关键词）

数据库脚本：

/*
SQLyog Ultimate v12.09 (64 bit)
MySQL - 5.7.27-log 
*********************************************************************
*/
/*!40101 SET NAMES utf8 */;

create table `keyword_copy` (
	`id` int (32),
	`name` varchar (66),
	`type` varchar (96),
	`createDate` date 
); 
insert into `keyword_copy` (`id`, `name`, `type`, `createDate`) values('6','股票','金融','2018-11-23');
insert into `keyword_copy` (`id`, `name`, `type`, `createDate`) values('8','电影票房','娱乐','2001-11-12');
insert into `keyword_copy` (`id`, `name`, `type`, `createDate`) values('9','	金融','123','2000-12-31');
insert into `keyword_copy` (`id`, `name`, `type`, `createDate`) values('10','123','456','2007-08-08');

POJO:(KeyWord):

  private int id;
    private String name;
    private String type;
    private Date createDate;
+get/set方法

Dao：

       KeyWordDao:

public interface KeyWordDao {
    /**
     * 查询全部
     * @return
     */
    List<KeyWord> getAll();

    /**
     * 更具关键字搜索
     * @param name
     * @return
     */
    KeyWord getKeyWordByName(String name);

    /**
     * 添加的接口
     * @param keyWord
     * @return
     */
    int AddKeyWord(KeyWord keyWord);

    /**
     * 删除的接口
     * @param id
     * @return
     */
    int deleteKeyWordById(int id);
}

KeyWordImpl:

public class KeyWordImpl extends BaseDao implements KeyWordDao {
    @Override
    public List<KeyWord> getAll() {
        String sql="SELECT * FROM `keyword` ORDER BY `createDate`";
        List<KeyWord> keyWordList=new ArrayList<>();
        ResultSet rs = this.executeQuery(sql, null);
        try {
            while (rs.next()){
                KeyWord keyword = new KeyWord();
                keyword.setId(rs.getInt("id"));
                keyword.setName(rs.getString("name"));
                keyword.setType(rs.getString("type"));
                keyword.setCreateDate(rs.getDate("createDate"));
                keyWordList.add(keyword);
            }
        } catch (SQLException throwables) {
            throwables.printStackTrace();
        }
        return keyWordList;
    }

    @Override
    public KeyWord getKeyWordByName(String name) {
        String sql="SELECT * FROM `keyword` WHERE `name`=?";
        Object[] objects={name};
        ResultSet rs = this.executeQuery(sql, objects);
         KeyWord keyWord=null;
         try {
             while (rs.next()){
                 keyWord = new KeyWord();
                 keyWord.setId(rs.getInt("id"));
                 keyWord.setName(rs.getString("name"));
                 keyWord.setType(rs.getString("type"));
                 keyWord.setCreateDate(rs.getDate("createDate"));

             }
         } catch (SQLException throwables) {
             throwables.printStackTrace();
         }
        return keyWord;
    }

    @Override
    public int AddKeyWord(KeyWord keyWord) {
        String sql="INSERT INTO `keyword`(`name`,`type`,`createDate`)VALUES(?,?,?)";
        Object[] objects={keyWord.getName(),keyWord.getType(),keyWord.getCreateDate()};
        return this.executeUpdate(sql,objects);
    }

    @Override
    public int deleteKeyWordById(int id) {
        String sql="DELETE FROM `keyword` WHERE id=?";
        Object[] objects={id};
        return this.executeUpdate(sql,objects);
    }
}

  Service：

        KeyWordService：

 /**
     * 查询全部
     * @return
     */
    List<KeyWord> getAll();

    /**
     * 更具关键字搜索
     * @param name
     * @return
     */
    boolean getKeyWordByName(String name);

    /**
     * 添加的接口
     * @param keyWord
     * @return
     */
    boolean AddKeyWord(KeyWord keyWord);

    /**
     * 删除的接口
     * @param id
     * @return
     */
    boolean deleteKeyWordById(int id);
}

      KeyWordServiceimpl：

public class KeyWordServiceimpl implements KeyWordService {
    KeyWordDao ks=new KeyWordImpl();
    @Override
    public List<KeyWord> getAll() {

        return ks.getAll();
    }

    @Override
    public boolean getKeyWordByName(String name) {
        if (ks.getKeyWordByName(name)!=null){
            return true;
        }
        return false;
    }

    @Override
    public boolean AddKeyWord(KeyWord keyWord) {
        if (ks.AddKeyWord(keyWord)>0){
            return true;
        }
        return false;
    }

    @Override
    public boolean deleteKeyWordById(int id) {
        if (ks.deleteKeyWordById(id)>0){
            return true;
        }
        return false;
    }
}

Servlet：
AddServlet：

public class AddServlet extends HttpServlet {
    @Override
    protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        doPost(request, response);
    }

    @Override
    protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        response.setCharacterEncoding("utf-8");
        request.setCharacterEncoding("utf-8");
        KeyWordService keywordService = new KeyWordServiceimpl();
        String name = request.getParameter("name");
        String type = request.getParameter("type");
        String createDate = request.getParameter("createDate");
        KeyWord keyword = new KeyWord();
        keyword.setName(name);
        keyword.setType(type);
        SimpleDateFormat simpleDateFormat = new SimpleDateFormat("yyyy-MM-dd");
        Date date = null;
        try {
            date = simpleDateFormat.parse(createDate);
        } catch (ParseException e) {
            throw new RuntimeException(e);
        }
        keyword.setCreateDate(date);
        response.setContentType("text/html;charset=utf-8");
        boolean flag = keywordService.AddKeyWord(keyword);
        if (flag){
            response.getWriter().print("<script type='text/javascript'> alert('添加成功');window.location='ShowAllServlet';</script>");
        }else {
            response.getWriter().print("<script type='text/javascript'> alert('添加失败');window.location='ShowAllServlet';</script>");
        }
    }
}

CheckServlet：

@WebServlet("/CheckServlet")
public class CheckServlet extends HttpServlet {
    @Override
    protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        doPost(request, response);
    }

    @Override
    protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        response.setCharacterEncoding("utf-8");
        request.setCharacterEncoding("utf-8");
        String name = request.getParameter("name");
        KeyWordService keywordService = new KeyWordServiceimpl();
        boolean keyWordByName = keywordService.getKeyWordByName(name);
        System.out.println(keyWordByName);
        response.getWriter().print(keyWordByName);

    }
}

DeleteServlet：

@WebServlet("/DeleteServlet")
public class DeleteServlet extends HttpServlet {
    @Override
    protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        doPost(request, response);
    }

    @Override
    protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        response.setCharacterEncoding("utf-8");
        request.setCharacterEncoding("utf-8");
        HttpSession session = request.getSession();
        KeyWordService keywordService = new KeyWordServiceimpl();
       // String ids = request.getParameter("id");
        //int id=Integer.valueOf(ids);
        boolean b = keywordService.deleteKeyWordById(Integer.valueOf(request.getParameter("id")));
        List<KeyWord> keywordList = keywordService.getAll();
        session.setAttribute("keywordList",keywordList);
        response.getWriter().print(b);
    }
}

ShowAllServlet：

@WebServlet("/ShowAllServlet")
public class ShowAllServlet extends HttpServlet {
    @Override
    protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        doPost(request, response);
    }

    @Override
    protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        request.setCharacterEncoding("utf-8");
        response.setCharacterEncoding("utf-8");
        HttpSession session = request.getSession();
        KeyWordService keyWordService =new KeyWordServiceimpl();
        List<KeyWord> keyWordList= keyWordService.getAll();
        session.setAttribute("keyWordList",keyWordList);
        response.sendRedirect("index.jsp");
    }
}

jsp页面：

展示区全部的页面：index.jsp：

<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<%@taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<script src="js/jquery-1.8.2.min.js"></script>
<html>
  <head>
    <title>勇士总冠军</title>
  </head>
  <body>
  <form action="">
    <table align="center" border="1">
       <tr>
         <td>编号</td>
         <td>关键词名称</td>
         <td>业务类型</td>
         <td>创建时间</td>
          <td>操作</td>
       </tr>
     <c:forEach items="${keyWordList}" var="keyword">
       <tr class="ghhs" id="${keyword.id}">
          <td>${keyword.id}</td>
         <td>${keyword.name}</td>
         <td>${keyword.type}</td>
         <td>${keyword.createDate}</td>
         <td><a href="#" onclick="del(${keyword.id})">删除</a></td>
       </tr>
     </c:forEach>
         <tr align="center">
           <td colspan="5"><input align="center" type="button" value="添加关键词" onclick="toAdd()"></td>
         </tr>
    </table>>
      <h6 id="text" style="width: 100%; text-align: center"></h6>

  </form>
  <script>
      $(".ghhs:even").css("background","green");
      $(".ghhs:odd").css("background","red");

      function del(id) {
          if (confirm("确定删除吗")){
              $.post("DeleteServlet","id="+id,function (data) {
                  if (data == "true"){
                      $("#"+id).remove();
                      $("#text").html("删除成功");
                  }else {
                      $("#text").html("删除失败");
                  }
              },"text")
          }
      }

    function toAdd() {
      window.location = "Add.jsp";
    }

  </script>
  </body>
</html>

添加的页面：

<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
    <title>勇士总冠军</title>
    <script src="js/jquery-1.8.2.min.js"></script>
</head>
<body>
<form action="AddServlet" method="post">
    <table align="center" border="1px">
        <tr>
            <th colspan="2">添加关键字</th>
        </tr>
        <tr>
            <td>关键词(*)</td>
            <td><input id="name" type="text" name="name" onblur="check()"><p id="text"></p></td>
        </tr>
        <tr>
            <td>业务类型(*)</td>
            <td><input type="text" name="type"></td>
        </tr>
        <tr>
            <td>创建时间(*)</td>
            <td><input type="text" name="createDate"></td>
        </tr>
        <tr>
            <td colspan="2" align="center"><input type="submit" onclick=""></td>
        </tr>
    </table>
</form>
<script>
    function check() {
        alert("进入")
        var name = $("#name").val();
        alert(name)
        $.post("CheckServlet","name="+name,function (data) {
            if (data == "true"){
                alert(data)
                $("#text").html("关键词已经存在");
            }else {
                $("#text").html("可用");
            }
        },"text");
    }
</script>

</body>
</html>