目录
效果如图所示:
1.存放entity的文件夹
book.java
package com.zking.entity;
import com.zking.util.PinYinUtil;
public class Book {
private int bookid;
private String bookname;
private String bookprice;
private String booktype;
private String booknamepinyin;
public Book(int bookid) {
super();
this.bookid = bookid;
}
public Book(String bookname, String bookprice, String booktype, String booknamepinyin) {
super();
this.bookname = bookname;
this.bookprice = bookprice;
this.booktype = booktype;
this.booknamepinyin = booknamepinyin;
}
public Book(int bookid,String bookname, String bookprice, String booktype) {
super();
this.bookid = bookid;
this.setBookname(bookname);
this.bookprice = bookprice;
this.booktype = booktype;
}
public String getBooknamepinyin() {
return booknamepinyin;
}
public void setBooknamepinyin(String booknamepinyin) {
this.booknamepinyin = booknamepinyin;
}
public int getBookid() {
return bookid;
}
public void setBookid(int bookid) {
this.bookid = bookid;
}
public String getBookname() {
return bookname;
}
//给书本名称bookname属性赋值
public void setBookname(String bookname) {
this.bookname = bookname;
//调用给书本名称拼音属性赋值的方法
this.setBooknamepinyin(PinYinUtil.toPinyin(bookname));//转换成拼音首字母然后赋值给bookname属性
}
public String getBookprice() {
return bookprice;
}
public void setBookprice(String bookprice) {
this.bookprice = bookprice;
}
public String getBooktype() {
return booktype;
}
public void setBooktype(String booktype) {
this.booktype = booktype;
}
public Book(int bookid, String bookname, String bookprice, String booktype, String booknamepinyin) {
super();
this.bookid = bookid;
this.bookname = bookname;
this.bookprice = bookprice;
this.booktype = booktype;
this.booknamepinyin = booknamepinyin;
}
public Book(String bookname, String bookprice, String booktype) {
// this.bookname = bookname;//书名拼音赋值不了
this.setBookname(bookname);
this.bookprice = bookprice;
this.booktype = booktype;
}
public Book() {
// TODO Auto-generated constructor stub
}
@Override
public String toString() {
return "Book [bookid=" + bookid + ", bookname=" + bookname + ", bookprice=" + bookprice + ", booktype="
+ booktype + ", booknamepinyin=" + booknamepinyin + "]";
}
}
2.存放Dao的系列文件夹:Dao,DaoImpl
bookDao.java
package com.zking.dao.impl;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;
import com.zking.dao.IBookDao;
import com.zking.entity.Book;
import com.zking.util.DBAccess;
public class BookDao implements IBookDao{
private List<Book> listBook;
private PreparedStatement ps;
private Connection con;
private Book book;
private ResultSet rs;
private String sql;
private int n;
@Override
public List<Book> query(String bookName,int pageIndex,int pageSize) throws Exception{
listBook = new ArrayList<>();
con = DBAccess.getConnection();
//计算每页开始 的数据条数
int startIndex = (pageIndex - 1)* pageSize;
//分页的SQL语句
sql="select bookId,bookName,bookPrice,bookType,bookNamePinYin from t_book limit ?,?";
//如果书本的关键字不为null和空白关键字
if(null != bookName && !"".equals(bookName)) {
sql = "select bookId,bookName,bookPrice,bookType,bookNamePinYin from t_book where bookName like ? or bookNamePinYin like ? limit ?,? ";
}
System.out.println("模糊查询sql语句="+sql);
ps = con.prepareStatement(sql);
//给占位符赋值
if(null != bookName && !"".equals(bookName)) {
ps.setString(1, "%"+bookName+"%");//书本名称
ps.setString(2, "%"+bookName+"%");//书本名称拼音
ps.setInt(3, startIndex);//开始页数
ps.setInt(4, pageSize);//页大小
}else {
ps.setInt(1, startIndex);//开始页数
ps.setInt(2, pageSize);//页大小
}
ps.setInt(1, startIndex);
rs = ps.executeQuery();
while(rs.next()) {
book = new Book();
book.setBookid(rs.getInt("bookId"));
book.setBookname(rs.getString("bookname"));
book.setBookprice(rs.getString("bookprice"));
book.setBooktype(rs.getString("bookType"));
book.setBooknamepinyin(rs.getString("booknamepinyin"));
listBook.add(book);
}
DBAccess.close(con, ps, rs);
return listBook;
}
@Override
public int getTotalRow(String bookName) throws Exception{
int TotalRow=0;//数据总条数
con = DBAccess.getConnection();
sql = "select count(0) from t_book where 1=1";
//如果书本的关键字不为null或者空白关键字
if(null != bookName && !"".equals(bookName)) {
sql += " and bookName like ? or bookNamePinYin like ?";
}
ps = con.prepareStatement(sql);
//给占位符赋值
if(null != bookName && !"".equals(bookName)) {
ps.setString(1, "%"+bookName+"%");//书本名称
ps.setString(2, "%"+bookName+"%");//书本名称拼音
}
System.out.println("查询数据总条数:"+sql);
rs = ps.executeQuery();
if(rs.next()) {
TotalRow = rs.getInt(1);
}
DBAccess.close(con, ps, rs);
return TotalRow;
}
/**
* 增加书本
*/
@Override
public void insert(Book book) throws Exception {
con = DBAccess.getConnection();
sql = "insert into t_book(bookName,bookPrice,bookType,bookNamePinYin)values(?,?,?,?)";
ps = con.prepareStatement(sql);
ps.setString(1, book.getBookname());//书本名称
ps.setString(2, book.getBookprice());//书本价格
ps.setString(3, book.getBooktype());//书本名称类型
ps.setString(4, book.getBooknamepinyin());//书本名称拼音
n = ps.executeUpdate();
DBAccess.close(con, ps, rs);
}
/**
* 修改书本
*/
@Override
public void update(Book book) throws Exception {
con = DBAccess.getConnection();
sql = "update t_book set bookName=?,bookPrice=?,bookType=?where bookId=?";
ps = con.prepareStatement(sql);
ps.setString(1, book.getBookname());//书本名称
ps.setString(2, book.getBookprice());//书本名称拼音
ps.setString(3, book.getBooktype());//书本名称拼音
ps.setInt(4, book.getBookid());//书本编号
System.out.println(book.getBookid());
ps.executeUpdate();
DBAccess.close(con, ps, rs);
}
/**
* 删除书本
*/
@Override
public void delete(int bookId) throws Exception {
con = DBAccess.getConnection();
sql = "delete from t_book where bookId=?";
ps = con.prepareStatement(sql);
ps.setInt(1, bookId);//书本名称拼音
ps.executeUpdate();
DBAccess.close(con, ps, rs);
}
}
3.存放Servlet的文件夹。
UpdateBookServlet
package com.zking.servlet;
import java.io.IOException;
import java.io.PrintWriter;
import java.util.HashMap;
import java.util.Map;
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 com.alibaba.fastjson.JSON;
import com.zking.biz.IBookBiz;
import com.zking.biz.impl.BookBiz;
import com.zking.entity.Book;
/**
* 修改书本
* @author jin
*
*/
@WebServlet("/UpdateBookServlet")
public class UpdateBookServlet extends HttpServlet{
@Override
protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
doPost(req, resp);
}
@Override
protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
req.setCharacterEncoding("utf-8");
resp.setContentType("text/html;charset=utf-8");
IBookBiz ibb = new BookBiz();
PrintWriter out = resp.getWriter();
Map<String,Object> data = new HashMap<>();
try {
//获取前端的关键字
int bookId = Integer.parseInt(req.getParameter("bookid"));
System.out.println("bookid="+bookId);
String bookName = req.getParameter("bookname");
System.out.println("bookBName="+bookName);
String bookPrice = req.getParameter("bookprice");
System.out.println("bookPrice=" + bookPrice);
String bookType = req.getParameter("booktype");
System.out.println("bookType=" + bookType);
// Book book = new Book(bookName,bookPrice,bookType,bookId);//①
//第二种
Book book = new Book();
book.setBookid(bookId);
book.setBookname(bookName);
book.setBookprice(bookPrice);
book.setBooktype(bookType);
//调用修改的方法
ibb.update(book);
System.out.println(book);
//往map集合里面赋值
data.put("sucess", true);
data.put("msg", "书本修改成功!");
}catch (Exception e) {
data.put("sucess", false);
data.put("msg", "书本修改失败!");
// TODO: handle exception
e.printStackTrace();
}
//将map集合data装换成JSON字符串
String jsonString = JSON.toJSONString(data);
out.write(jsonString);
out.flush();
out.close();
}
}
deleteBookServlet.java
package com.zking.servlet;
import java.io.IOException;
import java.io.PrintWriter;
import java.util.HashMap;
import java.util.Map;
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 com.alibaba.fastjson.JSON;
import com.zking.biz.IBookBiz;
import com.zking.biz.impl.BookBiz;
/**
* 删除书本
* @author jin
*
*/
@WebServlet("/deleteBookServlet")
public class deleteBookServlet extends HttpServlet{
@Override
protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
doPost(req, resp);
}
@Override
protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
req.setCharacterEncoding("utf-8");
resp.setContentType("text/html;charset=utf-8");
IBookBiz ibb = new BookBiz();
PrintWriter out = resp.getWriter();
Map<String,Object> data = new HashMap<>();
try {
//获取前端的关键字
int bookId = Integer.parseInt(req.getParameter("bookid"));
System.out.println("bookid="+bookId);
//调用修改的方法
ibb.delete(bookId);
System.out.println(bookId);
//往map集合里面赋值
data.put("sucess", true);
data.put("msg", "书本删除成功!");
}catch (Exception e) {
data.put("sucess", false);
data.put("msg", "书本删除失败!");
// TODO: handle exception
e.printStackTrace();
}
//将map集合data装换成JSON字符串
String jsonString = JSON.toJSONString(data);
out.write(jsonString);
out.flush();
out.close();
}
}
4.存放js的文件夹。
bookList.js
$(function(){
//获取表格
$("#myTable").datagrid({
//绑定表头:columns列/字段
//第一个参数
columns:[[
{field:'bookid',title:'书本编号',width:100},
{field:'bookname',title:'书本名称',width:100},
{field:'bookprice',title:'书本单价',width:100},
{field:'booktype',title:'书本类型',width:100}
]],
//向后台发送ajax请求
url:ctx+"/BookServlet",
//分页
pagination: true,// 设置是否显示分页标签
singleSelect:true,// 如果为true,则只允许选择一行(否则点一行选择一行,很丑)
loadMsg:"正在加载数据...",//加载数据的时候显示提示消息。
toolbar:'#tableToolbar',//通过id获取工具栏
});
//给查询按钮添加事件
$("#btn_search").click(function(){
console.info("关键字:"+$("#bookName").val());
query();
})
//给增加工具条添加点击事件
$('#addBook').click(function(){
openDialog();
})
//给修改按钮添加事件
$('#editBook').click(function(){
///获取当前所选中的数据行
let row = $('#myTable').datagrid('getSelected');
console.log(row);
if(row == null){//没有选择行。不能删除,并且给予警告
$.messager.alert("警告!","请选择要修改的行");
return row;
}
openDialog(row);
query();
})
//给删除按钮添加事件
$('#deleteBook').click(function(){
///获取当前所选中的数据行
let row = $('#myTable').datagrid('getSelected');
if(row == null){//没有选择行。不能删除,并且给予警告
$.messager.alert("警告!","请选择要删除的行");
return ;
}
//询问是否删除
$.messager.confirm("警告!","确定删除?",function(f){//f:讯问框返回的值
if(f){//确定删除
//发送ajax请求
$.ajax({
url:ctx+'/deleteBookServlet',//请求地址
data: {'bookid':row.bookid},//向后台返回的数据类型
dataType:'JSON',//后台返回数据类型
type:'post',//发送ajax请求方式类型
success:function(data){
if(data.success == true){//删除成功
$.messager.alert('消息',data.msg);
//删除成功,重新绑定数据
query();
}else{//删除失败
$.messager.alert('警告!',data.msg);
}
}
})
}
});
})
/* 设置分页组件的文字描述 */
var p = $('#myTable').datagrid('getPager');
$(p).pagination({
pageSize: 5,//每页显示的记录条数,默认为10
pageList: [5,10,20,30,50,60,70,80,90,100],//可以设置可以选择的页大小(下拉框的内容)
beforePageText: '第',//页数文本框前显示的汉字
afterPageText: '页 共 {pages} 页',
displayMsg: '当前显示 {from} - {to} 条记录 共 {total} 条记录',
});
})
//向后台发送模糊查询关键字方法
function query(){
console.info($("#bookName").val());
$('#myTable').datagrid('load',{
bookName:$("#bookName").val(),
});
}
//打开对话框(修改和删除)
function openDialog(row){
//标题默认是增加
let title='添加';
//请求地址默认是增加书本的servlet
let servlet='/AddBookServlet';
if(row!=null){//行被选中,修改
title='编辑';
servlet='/UpdateBookServlet';
}
//给div添加对话框
$('#bookDialog').dialog({
title: title,
width: 400,
height: 200,
closed: false,
cache: false,
href: ctx+'/static/jsp/book/editBook.jsp',
modal: true,
//给对话框添加按钮组
buttons:[{
text:'保存',
handler:function(){
//像后台发送ajax请求
$.ajax({
url:ctx+servlet,//请求地址
data: $("#bookForm").serialize(),//表单数据
dataType:'JSON',//后台返回数据类型
type:'post',//发送ajax请求方式类型
success:function(data){
if(data.success == true){//增加成功
$.messager.alert('消息',data.msg);
//增加成功,重新绑定数据
query();
}else{//增加失败
$.messager.alert('警告!',data.msg);
}
}
})
}
},{
text:'关闭',
handler:function(){
//获取到对话框的id
$('#bookDialog').dialog('close');
}
}],
//绑定要修改的书本数据
onLoad:function(){
if(row!=null){//如果row里面有数据,不为空
console.log(row)
$('#bookForm').form("load",row);
}
}
});
}