数据库脚本:
/*
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>