需要源码小伙伴可以在我的微信小程序:”MINIIT资源库“获取,作者承诺免费
介绍一下这个简单的项目包含了书籍展示、添加书籍以及删除书籍功能,虽然项目很简单,但是作为小白的我很想和大家分享互动,欢迎大家参考交流大神指教
下面展示我的主要功能代码,Dao模式:
这是Dao层的实现类:
package com.BookManage.Dao.impl;
import com.BookManage.Dao.BaseDao;
import com.BookManage.Dao.BookDao;
import com.BookManage.Entity.Book;
import com.BookManage.Util.ConnectionUtil;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;
public class BookDaoImpl extends BaseDao implements BookDao {
/**
* 通过有参构造传入connection
*
* @param connection
*/
public BookDaoImpl(Connection connection) {
super(connection);
}
@Override
public List<Book> getBook() throws Exception {
//先创建sql语句
String sql="select * from bookmanage";
//创建结果集对象
ResultSet resultSet=null;
try{
resultSet=doQuery(sql);
//创建集合接收封装结果集的Book对象
List<Book> bookList=new ArrayList<>();
//循环读取resultSet,实例一个Book对象接收
while (resultSet.next()){
Book book=new Book();
book.setB_id(resultSet.getInt("b_id"));
book.setB_name(resultSet.getString("b_name"));
book.setB_author(resultSet.getString("b_author"));
book.setB_time(resultSet.getDate("b_time"));
book.setB_type(resultSet.getInt("b_type"));
bookList.add(book);
}
return bookList;
}catch (Exception e){
throw e;
}finally {
ConnectionUtil.closeAll(null,null,resultSet);
}
}
@Override
public int addBook(Book book) throws Exception {
String sql="INSERT INTO `bookmanage` (`b_name`,`b_author`,`b_time`,`b_type`) VALUES(?,?,?,?)";
//创建集合接收前端数据
Object [] params={book.getB_name(),book.getB_author(),book.getB_time(),book.getB_type()};
try {
return doUpdate(sql,params);
} catch (SQLException e) {
throw e;
}
}
@Override
public int delBookById(int bid) throws SQLException {
String sql ="delete from bookmanage where b_id=?";
int result=0;
try {
Object[] params={bid};
result=this.doUpdate(sql,params);
} catch (SQLException e) {
e.printStackTrace();
throw e;
}
return result;
}
}
这是Service层的实现类:
package com.BookManage.Service.impl;
import com.BookManage.Dao.BookDao;
import com.BookManage.Dao.impl.BookDaoImpl;
import com.BookManage.Entity.Book;
import com.BookManage.Service.BookService;
import com.BookManage.Util.ConnectionUtil;
import java.sql.Connection;
import java.sql.SQLException;
import java.util.List;
public class BookServiceImpl implements BookService {
@Override
public List<Book> getBook() {
//获得数据库连接并传入BookDaoImpl
Connection connection=ConnectionUtil.getConnection();
BookDao bookDao=new BookDaoImpl(connection);
try {
return bookDao.getBook();
} catch (Exception e) {
e.printStackTrace();
}finally {
//关闭数据库连接
ConnectionUtil.closeAll(connection,null,null);
}
return null;
}
@Override
public boolean addBook(Book book) {
Connection connection=ConnectionUtil.getConnection();
BookDao bookDao=new BookDaoImpl(connection);
try {
return bookDao.addBook(book)>0;
} catch (Exception e) {
e.printStackTrace();
}finally {
ConnectionUtil.closeAll(connection,null,null);
}
return false;
}
@Override
public boolean delBook(int bid) throws SQLException {
Connection connection=null;
try {
connection=ConnectionUtil.getConnection();
BookDao bd=new BookDaoImpl(connection);
return bd.delBookById(bid)>0;
} catch (SQLException e) {
e.printStackTrace();
throw e;
}finally {
ConnectionUtil.closeAll(connection,null,null);
}
}
}
这是与实现与前端交互的Servlet:
package com.BookManage.Servlet;
import com.BookManage.Entity.Book;
import com.BookManage.Service.BookService;
import com.BookManage.Service.impl.BookServiceImpl;
import com.alibaba.fastjson.JSON;
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 java.io.Console;
import java.io.IOException;
import java.sql.SQLException;
import java.text.SimpleDateFormat;
import java.util.Date;
import java.util.HashMap;
import java.util.List;
import java.util.Map;
@WebServlet(name = "BookServlet",urlPatterns = "/BookServlet")
public class BookServlet extends HttpServlet {
@Override
protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
doGet(req, resp);
}
@Override
protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
//接收操作请求
String opr = req.getParameter("opr");
resp.setContentType("application/json;charset=utf-8");
BookService bookService=new BookServiceImpl();
if ("all".equals(opr)) {
List<Book> book = bookService.getBook();
String json= JSON.toJSONStringWithDateFormat(book,"yyyy-MM-dd");
resp.getWriter().print(json);
}else if("add".equals(opr)){
String bname=req.getParameter("bname");
String bauthor=req.getParameter("bauthor");
String btime=req.getParameter("btime");
String btype=req.getParameter("btype");
SimpleDateFormat formatter = new SimpleDateFormat("yyyy-MM-dd");
Date date=null;
try {
date=formatter.parse(btime);
Book book=new Book(bname,bauthor,date,Integer.parseInt(btype));
boolean result = bookService.addBook(book);
Map<String,Boolean> stringHashMap = new HashMap<String,Boolean>();
stringHashMap.put("result",result);
String json=JSON.toJSONString(stringHashMap);
resp.getWriter().print(json);
} catch (Exception e) {
e.printStackTrace();
}
}else if("deleteBook".equals(opr)){
String bid=req.getParameter("bid");
System.out.print(bid);
try {
boolean result=bookService.delBook(Integer.parseInt(bid));
Map<String,Boolean> stringHashMap = new HashMap<String,Boolean>();
stringHashMap.put("result",result);
String json=JSON.toJSONString(stringHashMap);
resp.getWriter().print(json);
} catch (SQLException e) {
e.printStackTrace();
}
}
}
}
前端用JSON实现前后端交互:
<%--
Created by IntelliJ IDEA.
User: DELL
Date: 2021/7/4
Time: 11:08
To change this template use File | Settings | File Templates.
--%>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
<title>$Title$</title>
</head>
<script src="js/jquery-1.12.4.js"></script>
<body style="margin-left:500px">
<h1>图书信息</h1>
<table border="1" cellpadding="0" cellspacing="0">
<tr>
<th>图书名称</th>
<th>图书作者</th>
<th>购买时间</th>
<th>图书分类</th>
<th>操作</th>
</tr>
<tbody id="myTbody"></tbody>
</table>
<a href="addBook.jsp">新增图书信息</a>
</body>
<script type="text/javascript">
$.getJSON("http://localhost:8080/BookManage/BookServlet","opr=all",function (res) {
console.log(res);
var bookType;
$.each($(res),function () {
if(this.b_type==0){
bookType="计算机/软件"
}else if(this.b_type==1){
bookType="小说/文稿"
}else if(this.b_type==2){
bookType="杂项"
}
$tr=$("<tr></tr>");
$bname=$("<td></td>");
$bname.append(this.b_name);
$bauthor=$("<td></td>");
$bauthor.append(this.b_author);
$btime=$("<td></td>");
$btime.append(this.b_time);
$btype=$("<td></td>");
$btype.append(bookType);
$del=$("<td></td>");
$a=$("<a href='#' class='del'>删除</a>");
$a.attr("id",this.b_id);
$del.append($a);
$tr.append($bname);
$tr.append($bauthor);
$tr.append($btime);
$tr.append($btype);
$tr.append($del);
$("#myTbody").append($tr);
})
$('.del').click(function () {
var bid=$(this).attr('id');
var data={
"opr":"deleteBook",
"bid":bid
}
var result=confirm("确定删除该数据吗?");
if (result==true){
$.getJSON("http://localhost:8080/BookManage/BookServlet",data,function (res) {
if (res.result){
alert('删除成功!');
location.href='showBook.jsp';
}else {
alert('删除失败!');
}
})
}
})
})
</script>
</html>