• EasyUI后台管理系统

    目录

    1. 引入EasyUI文件

    2. 网站首页布局 

    2.1 前端代码

    2.2 Servlet代码 

    2.3 dao层接口代码

    2.4 dao层实现类代码

    2.5 biz层接口代码

    2.6 biz层实现类代码 

    3. 书本展示模块 

    展示全部书本 and 模糊查询

    增加书本

    编辑书本 

    删除书本 

    3.1 前端代码

    3.2 js代码

    3.3 点击编辑or增加按钮打开的页面 

    3.4 查询and模糊查询Servlet代码 

    3.5 增加书本Servlet代码

    3.6 编辑书本Servlet代码

    3.7 删除书本Servlet代码

    3.8 dao层接口代码

    3.9 dao层实现类代码

     4.0 biz层接口代码

     4.1 biz层实现类代码

    项目使用:毕业设计、课程设计、大作业、项目练习、学习演示等...

    想要源码的童鞋可以+本人QQ:203114746、QQ邮箱:203114746@qq.com、想学习的童鞋或者对IT行业感兴趣的也可以找我请教哦！！！本人是一个很热情的男孩子喔 

    1. 引入EasyUI文件

    1. <%@ page language="java" contentType="text/html; charset=UTF-8"
    2.     pageEncoding="UTF-8"%>
    4. <%
    5. request.setAttribute("cxt", request.getContextPath());
    6. %>
    8. <script type="text/javascript">
    9. var cxt="${cxt}";
    10. script>
    12. <link rel="stylesheet" type="text/css" href="${pageContext.request.contextPath }/static/js/jquery-easyui-1.5.5.2/themes/default/easyui.css">   
    13. <link rel="stylesheet" type="text/css" href="${pageContext.request.contextPath }/static/js/jquery-easyui-1.5.5.2/themes/icon.css">   
    14. <script type="text/javascript" src="${pageContext.request.contextPath }/static/js/jquery-easyui-1.5.5.2/jquery.min.js">script>   
    15. <script type="text/javascript" src="${pageContext.request.contextPath }/static/js/jquery-easyui-1.5.5.2/jquery.easyui.min.js">script>

    2. 网站首页布局 

    2.1 前端代码

    1. <%@ page language="java" contentType="text/html; charset=UTF-8"
    2.     pageEncoding="UTF-8"%>
    3. html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
    4. <html>
    5. <head>
    7. <%@ include file="head.jsp" %>
    8. <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
    9. <title>平台首页title>
    10. <script type="text/javascript">
    11. 	$(function(){
    12. 	/* 给树形菜单添加数据 */
    13. 		$('#myUl').tree({    
    14. 		    url: cxt+"/queryModuleServlet.do",
    15. 		    /* 给树标签添加双击 */
    16. 		    onDblClick: function(node){
    17. 		    	/* 判断如果是父标签就不增加 */
    18. 		    	var nodes = $('#myUl').tree('getChildren', node.target);// 获取未选择节点
    19. 				if(nodes<=0){
    20. 					/* 判断是否重复 */
    21. 					var index = $('#myTb').tabs('exists',node.text);
    22. 					if(!index){
    23. 						/* 增加表格 */
    24. 				    	$('#myTb').tabs('add',{    
    25. 				    	    title:node.text,    
    26. 				    	    content:'',    //内容、跳转指定的页面
    27. 				    	    closable:true,    
    28. 				    	}); 
    29. 					}else{//不存在
    30. 						$('#myTb').tabs('select',node.text);
    31. 					}
    32. 					
    33. 				}
    34. 			}
    35. 		});  
    36.  
    37. 	})
    38. script>
    39. head>
    40. <body class="easyui-layout">   
    42.     <div data-options="region:'north',title:'上',split:true" style="height:100px;">
    43.     <center><h1 style="font-family: '华文行楷'">蒋明辉工作室后台管理h1>center>
    44.     div>   
    45.     <div data-options="region:'south',title:'下',split:true" style="height:100px;">
    46.     <h2>©所有权限归蒋明辉工作室h2>
    47.     div>   
    48.     <div data-options="region:'west',title:'左',split:true" style="width:200px;">
    49.     
    50.     <ul id="myUl" class="easyui-tree">   
    51. ul>  
    52.     
    53.     div>   
    54.     <div data-options="region:'center',title:'中间 '" style="padding:5px;background:#eee;">
    55.     <div id="myTb" class="easyui-tabs" style="width:100%;height:100%;">   
    56.     <div title="首页" style="padding:0px;display:none;" >   
    57.         <img style="width:100%;height:100%;" title="我好喜欢你" alt="加载失败" src="${cxt }/static/images/6.webp">
    58.     div>    
    59. div>  
    60.     
    61.     div>   
    62. body>  
    63. html>

    2.2 Servlet代码 

    1. package com.jmh.servlet;
    2.  
    3. import java.io.IOException;
    4. import java.io.PrintWriter;
    5. import java.sql.SQLException;
    6. import java.util.List;
    7.  
    8. import javax.servlet.ServletException;
    9. import javax.servlet.annotation.WebServlet;
    10. import javax.servlet.http.HttpServlet;
    11. import javax.servlet.http.HttpServletRequest;
    12. import javax.servlet.http.HttpServletResponse;
    13.  
    14. import com.alibaba.fastjson.JSON;
    15. import com.jmh.biz.IModuleBiz;
    16. import com.jmh.biz.imp.ModuleBiz;
    17. import com.jmh.entity.Module;
    18.  
    19. /**
    20.  * 绑定左侧Tree
    21.  * @author 蒋明辉
    22.  *
    23.  */
    24. @WebServlet("/queryModuleServlet.do")
    25. public class QueryModuleServlet extends HttpServlet{
    26. 	@Override
    27. 	protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
    28. 		doGet(req, resp);
    29. 	}
    30. 	@Override
    31. 	protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
    32. 		try {
    33. 		//设置编码
    34. 		req.setCharacterEncoding("utf-8");
    35. 		resp.setContentType("text/html;charset=utf-8");
    36. 		//获取对象
    37. 		PrintWriter out = resp.getWriter();
    38. 		//处理业务逻辑代码
    39. 		IModuleBiz imb=new ModuleBiz();
    40. 		//查询
    41. 		List queryPid = imb.queryPid(-1);
    42. 		//转换JSon格式
    43. 		String jsonString = JSON.toJSONString(queryPid);
    44. 		out.print(jsonString);
    45. 		out.flush();
    46. 		out.close();
    47. 		} catch (SQLException e) {
    48. 			e.printStackTrace();
    49. 		}
    50. 	}
    51.  
    52. }

     2.3 dao层接口代码

    1. package com.jmh.dao;
    2.  
    3. import java.sql.SQLException;
    4. import java.util.List;
    5.  
    6. import com.jmh.entity.Module;
    7.  
    8. /**
    9.  * 接口
    10.  * @author 蒋明辉
    11.  *
    12.  */
    13. public interface IModuleDao {
    14. 	/**
    15. 	 * 绑定数据
    16. 	 * @param pid 父节点编号
    17. 	 * @return
    18. 	 * @throws SQLException
    19. 	 */
    20. 	List queryPid(Integer pid) throws SQLException;
    21.  
    22. }

     2.4 dao层实现类代码

    1. package com.jmh.dao.imp;
    2.  
    3. import java.sql.Connection;
    4. import java.sql.PreparedStatement;
    5. import java.sql.ResultSet;
    6. import java.sql.SQLException;
    7. import java.util.ArrayList;
    8. import java.util.List;
    9.  
    10. import com.jmh.dao.IModuleDao;
    11. import com.jmh.entity.Module;
    12. import com.jmh.util.DBAccess;
    13.  
    14. /**
    15.  * 实现类
    16.  * @author 蒋明辉
    17.  *
    18.  */
    19. public class ModuleDao implements IModuleDao{
    20. 	private Connection con;
    21. 	private PreparedStatement ps;
    22. 	private ResultSet rs;
    23. 	private List modulels;
    24. 	private Module module;
    25. 	private String sql;
    26. 	private int n;
    27. 	/**
    28. 	 * 绑定数据
    29. 	 * @param pid 父节点编号
    30. 	 * @return
    31. 	 * @throws SQLException
    32. 	 */
    33. 	@Override
    34. 	public List queryPid(Integer pid) throws SQLException {
    35. 		modulels=new ArrayList<>();
    36. 		con=DBAccess.getConnection();
    37. 		sql="select id,pid,text,icon,url,sort from t_module where pid=? order by sort asc";
    38. 		ps=con.prepareStatement(sql);
    39. 		ps.setInt(1, pid);
    40. 		rs=ps.executeQuery();
    41. 		while(rs.next()) {
    42. 			module=new Module(rs.getInt("id"), rs.getInt("pid"), rs.getString("text"), rs.getString("icon"), rs.getString("url"), rs.getInt("sort"), null);
    43. 			modulels.add(module);
    44. 		}
    45. 		return modulels;
    46. 	}
    47. }

     2.5 biz层接口代码

    1. package com.jmh.biz;
    2. import java.sql.SQLException;
    3. import java.util.List;
    4.  
    5. import com.jmh.entity.Module;
    6. /**
    7.  * 接口
    8.  * @author 蒋明辉
    9.  *
    10.  */
    11. public interface IModuleBiz {
    12. 	/**
    13. 	 * 绑定数据
    14. 	 * @param pid 父节点编号
    15. 	 * @return
    16. 	 * @throws SQLException
    17. 	 */
    18. 	List queryPid(Integer pid) throws SQLException;
    19. }

    2.6 biz层实现类代码 

    1. package com.jmh.biz.imp;
    2.  
    3. import java.sql.SQLException;
    4. import java.util.List;
    5.  
    6. import com.jmh.biz.IModuleBiz;
    7. import com.jmh.dao.IModuleDao;
    8. import com.jmh.dao.imp.ModuleDao;
    9. import com.jmh.entity.Module;
    10.  
    11. public class ModuleBiz implements IModuleBiz{
    12. 	IModuleDao imd=new ModuleDao();
    13. 	@Override
    14. 	public List queryPid(Integer pid) throws SQLException {
    15. 		List queryPid = imd.queryPid(pid);
    16. 		for (Module module : queryPid) {
    17. 			if(null==module.getUrl()||"".equals(module.getUrl())) {
    18. 				List queryPid2 = queryPid(module.getId());
    19. 				module.setChildren(queryPid2);
    20. 			}
    21. 			
    22. 		}
    23. 		return queryPid;
    24. 	}
    25. }

    3. 书本展示模块 

    • 展示全部书本 and 模糊查询

    •  增加书本

    • 编辑书本 

    • 删除书本 

    3.1 前端代码

    1. <%@ page language="java" contentType="text/html; charset=UTF-8"
    2.     pageEncoding="UTF-8"%>
    3. html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
    4. <html>
    5. <head>
    7. <%@ include file="../../home/head.jsp" %>
    8. <script type="text/javascript" src="${cxt }/static/js/bookList.js">script>
    9. <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
    10. <title>Insert title heretitle>
    11. head>
    12. <body>
    14. <div style="padding: 20px">
    15. <span style="font-weight: bolder;font-size: 15px">书本名称：span><input id="bookName" class="easyui-textbox" data-options="iconCls:'icon-search'" style="width:300px;"> 
    16. <a id="search" class="easyui-linkbutton" data-options="iconCls:'icon-search'">查询a> 
    17. div>
    19.  <div class="easyui-panel" style="padding:10px" data-options="fit:true, border:false">
    20.  <table class="easyui-datagrid" id="myTable" style="width: 100%;height: 80%;">table>  
    21.  div>
    22.  
    23. <div id="toolbar" style="text-align: right;">
    24. <a id="editBook" class="easyui-linkbutton" data-options="iconCls:'icon-edit',plain:true" /a>
    25. <a id="addBook" class="easyui-linkbutton" data-options="iconCls:'icon-add',plain:true" /a>
    26. <a id="removeBook" class="easyui-linkbutton" data-options="iconCls:'icon-remove',plain:true" /a>
    27. div>
    29. <div id="myToolbar">div> 
    30. body>
    31. html>

     3.2 js代码

    1. $(function(){
    2. 	// 通过 id选择器获取表格
    3. $("#myTable").datagrid({
    4. 	// 绑定表头
    5. 	columns:[[
    6. 	{field:'bookId',title:'书本ID',width:100,align:'center'},    
    7. 	{field:'bookName',title:'名称',width:100,align:'center'},    
    8. 	{field:'bookPrice',title:'价格',width:100,align:'center'},
    9. 	{field:'bookType',title:'类型',width:100,align:'center'}
    10.     ]],
    11. 	// 向后台发送 ajax请求
    12. 	url: cxt+'/queryBookServlet.do',
    13. 	pagination: true,// 设置是否显示分页标签
    14.     singleSelect:true,// 如果为true，则只允许选择一行(否则点一行选择一行，很丑)
    15.     loadMsg:"正在加载数据...",//加载数据的时候显示提示消息
    16.     toolbar: '#toolbar'
    17. });
    18. /* 设置分页组件的文字描述  */
    19. var p = $('#myTable').datagrid('getPager'); 
    20. $(p).pagination({ 
    21. 	pageSize: 10,//每页显示的记录条数，默认为10 
    22. 	pageList: [10,20,30,50,60,70,80,90,100],//可以设置可以选择的页大小(下拉框的内容)
    23. 	beforePageText: '第',//页数文本框前显示的汉字 
    24. 	afterPageText: '页    共 {pages} 页', 
    25. 	displayMsg: '当前显示 {from} - {to} 条记录   共 {total} 条记录', 
    26. }); 
    27. //加载数据的方法
    28. function query(){
    29. 	$("#myTable").datagrid('load',{
    30. 		"bookName":$("#bookName").val()
    31. 	})
    32. }
    33. //给查询按钮添加点击事件
    34. $("#search").click(function(){
    35. 	query();
    36. })
    37. //给增加按钮添加点击事件
    38. $("#addBook").click(function(){
    39. 	open();
    40. })
    41. //给修改按钮添加点击事件
    42. $("#editBook").click(function(){
    43. 	var row=$("#myTable").datagrid("getSelected");
    44. 	if(null==row){//为空
    45. 		$.messager.alert("警告","请选中你要修改的行");
    46. 		return;
    47. 	}
    48. 	open(row);
    49. })
    50. //给删除按钮添加点击事件
    51. $("#removeBook").click(function(){
    52. 	var row=$("#myTable").datagrid("getSelected");
    53. 	if(null!=row){//选中的行不为空
    54. 		$.messager.confirm('确认','您确认想要删除记录吗？',function(r){    
    55. 		    if (r){//确认删除   
    56. 	    		//使用无刷新跳转页面
    57. 	    		$.ajax({
    58. 	    			url:cxt+'/deleteBookServlet.do',//拿数据的地址
    59. 	    			data:{
    60. 	    				"bookId":row.bookId
    61. 	    				},//很重要
    62. 	    			type:'post',//类型
    63. 	    			dataType:'JSON',//前端希望后端所返回的数据格式
    64. 	    			success:function(data){
    65. 	    				if(data.s){//删除成功
    66. 	    					$.messager.alert("消息",data.m);
    67. 	    					//调用刷新的方法 实现实时刷新
    68. 	    					query();
    69. 	    				}else{//删除失败
    70. 	    					$.messager.alert("警告",data.m);
    71. 	    				}
    72. 	    			}
    73. 	    		})
    74. 		    }    
    75. 		}); 
    76. 	}else{//选中的行为空
    77. 		$.messager.alert('警告','请选中你要删除的行!'); 
    78. 	}
    79. })
    80. //共用方法
    81. function open(row){
    82. 	//初始
    83. 	title='增加书本';
    84. 	reqServlet='/insertBookServlet.do';
    85. 	if(null!=row){//row有值
    86. 		title='修改书本';
    87. 		reqServlet='/updateBookServlet.do';
    88. 	}
    89. 	$('#myToolbar').dialog({    
    90. 	    title: title,    
    91. 	    width: 400,    
    92. 	    height: 251,    
    93. 	    closed: false,    
    94. 	    cache: false,    
    95. 	    href: cxt+'/jsp/book/editBook.jsp',  //跳转页面表单页面
    96. 	    modal: true ,
    97. 	    //添加按钮组
    98. 	    buttons:[{
    99. 	    	text:'提交',
    100. 	    	handler:function(){
    101. 	    		//无刷新
    102. 	    		$.ajax({
    103. 	    			url:cxt+reqServlet,//拿数据的地址
    104. 	    			data:$("#bookForm").serialize(),//很重要
    105. 	    			type:'post',//类型
    106. 	    			dataType:'JSON',//前端希望后端所返回的数据格式
    107. 	    			success:function(data){
    108. 	    				if(data.s){//增加/修改成功
    109. 	    					$.messager.alert("消息",data.m);
    110. 	    					//调用刷新的方法 实现实时刷新
    111. 	    					query();
    112. 	    					//隐藏弹出框
    113. 	    					$('#myToolbar').dialog('close');
    114. 	    				}else{//增加/修改失败
    115. 	    					$.messager.alert("警告",data.m);
    116. 	    				}
    117. 	    			}
    118. 	    		})
    119. 	    	}
    120. 	    },{
    121. 	    	text:'关闭',
    122. 	    	handler:function(){
    123. 	    		$('#myToolbar').dialog('close'); 
    124. 	    	}
    125. 	    }],
    126. 	    onLoad:function(){
    127. 	    	//如果row有值就绑定数据
    128. 	    	if(row){
    129. 	    		$('#bookForm').form('load',row);// 读取表单的URL
    130. 	    	}
    131. 	    }
    132. 	}) 
    133. }
    134.  
    135. });

    3.3 点击编辑or增加按钮打开的页面 

    1. <%@ page language="java" contentType="text/html; charset=UTF-8"
    2.     pageEncoding="UTF-8"%>
    3. html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
    4. <html>
    5. <head>
    7. <%@ include file="../../home/head.jsp" %>
    8. <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
    9. <title>Insert title heretitle>
    10. head>
    11. <body>
    12. 	<div>
    13. 		<form id="bookForm">   
    14. 		<input name="bookId"  type="hidden"/>
    15. 		
    16. 		    <div style="margin: 15px;">   
    17. 		        <label for="name">书名:label>   
    18. 		        <input class="easyui-textbox" name="bookName"  style="width:300px" 
    19. 		        				data-options="required:true"> 
    20. 		    div>   
    21. 		    
    22. 		    <div style="margin: 15px;">   
    23. 		        <label for="price">价格:label>   
    24. 		        <input class="easyui-textbox" name="bookPrice"  style="width:300px" 
    25. 		        				data-options="required:true"> 
    26. 		    div>
    27. 		    
    28. 		    <div style="margin: 15px;">   
    29. 		        <label for="type">类型:label>   
    30. 		        <input class="easyui-textbox"  name="bookType" style="width:300px" data-options="required:true"> 
    31. 		    div>  
    32. 		form>
    33. 	div>
    34. body>
    35. html>

    3.4 查询and模糊查询Servlet代码 

    1. package com.jmh.servlet;
    2.  
    3. import java.io.IOException;
    4. import java.io.PrintWriter;
    5. import java.sql.SQLException;
    6. import java.util.HashMap;
    7. import java.util.List;
    8. import java.util.Map;
    9.  
    10. import javax.servlet.ServletException;
    11. import javax.servlet.annotation.WebServlet;
    12. import javax.servlet.http.HttpServlet;
    13. import javax.servlet.http.HttpServletRequest;
    14. import javax.servlet.http.HttpServletResponse;
    15. import javax.servlet.http.HttpSession;
    16.  
    17. import com.alibaba.fastjson.JSON;
    18. import com.jmh.biz.IBookBiz;
    19. import com.jmh.biz.imp.BookBiz;
    20. import com.jmh.entity.Book;
    21.  
    22. /**
    23.  * 查询所有t_book表数据
    24.  * @author 蒋明辉
    25.  *
    26.  */
    27. @WebServlet("/queryBookServlet.do")
    28. public class QueryBookServlet extends HttpServlet{
    29. 	@Override
    30. 	protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
    31. 		this.doGet(req, resp);
    32. 	}
    33. 	@Override
    34. 	protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
    35. 		try {
    36. 		//设置编码
    37. 		req.setCharacterEncoding("utf-8");
    38. 		resp.setContentType("text/html;charset=utf-8");
    39. 		//获取对象
    40. 		HttpSession session = req.getSession();
    41. 		PrintWriter out = resp.getWriter();
    42. 		//设置当前页码的参数
    43. 		Integer pageIndex=1;
    44. 		//获取前端传来的参数
    45. 		String bookName = req.getParameter("bookName");//书本名称关键字
    46. 		String page = req.getParameter("page");//页码
    47. 		String rows = req.getParameter("rows");//页大小
    48. 		//判断如果前端传来的页码有值就赋给页码变量
    49. 		if(null!=page&&!"".equals(page)) {
    50. 			pageIndex=Integer.parseInt(page);
    51. 		}
    52. 		//处理业务逻辑层代码
    53. 		IBookBiz ibb=new BookBiz();
    54. 		//查询全部方法
    55. 		List query = ibb.query(bookName, pageIndex, Integer.parseInt(rows));
    56. 		//查询总数据量方法
    57. 		Integer sumCount = ibb.sumCount(bookName);
    58. 		//将获取到的数据保存到map集合里面
    59. 		Map m=new HashMap();
    60. 		m.put("rows", query);//总数据
    61. 		m.put("total", sumCount);//总数据量
    62. 		//转换为JOSN格式
    63. 		String jsonString = JSON.toJSONString(m);
    64. 		//输送到前端
    65. 		out.print(jsonString);
    66. 		out.flush();
    67. 		out.close();
    68. 		} catch (NumberFormatException | SQLException e) {
    69. 			e.printStackTrace();
    70. 		}
    71. 	}
    72.  
    73. }

     3.5 增加书本Servlet代码

    1. package com.jmh.servlet;
    2.  
    3. import java.io.IOException;
    4. import java.io.PrintWriter;
    5. import java.sql.SQLException;
    6. import java.util.HashMap;
    7. import java.util.Map;
    8.  
    9. import javax.servlet.ServletException;
    10. import javax.servlet.annotation.WebServlet;
    11. import javax.servlet.http.HttpServlet;
    12. import javax.servlet.http.HttpServletRequest;
    13. import javax.servlet.http.HttpServletResponse;
    14. import javax.servlet.http.HttpSession;
    15.  
    16. import com.alibaba.fastjson.JSON;
    17. import com.jmh.biz.IBookBiz;
    18. import com.jmh.biz.imp.BookBiz;
    19. import com.jmh.entity.Book;
    20.  
    21. /**
    22.  * 增加书本
    23.  * @author 蒋明辉
    24.  *
    25.  */
    26. @WebServlet("/insertBookServlet.do")
    27. public class InsertBookServlet extends HttpServlet{
    28. 	@Override
    29. 	protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
    30. 		doGet(req, resp);
    31. 	}
    32. 	@Override
    33. 	protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
    34. 		//设置编码
    35. 		req.setCharacterEncoding("utf-8");
    36. 		resp.setContentType("text/html;charset=utf-8");
    37. 		//获取对象
    38. 		HttpSession session = req.getSession();
    39. 		PrintWriter out=resp.getWriter();
    40. 		//获取前端获取来的参数
    41. 		String bookName=req.getParameter("bookName");//书本名称
    42. 		String bookPrice=req.getParameter("bookPrice");//书本价格
    43. 		String bookType=req.getParameter("bookType");//书本类型
    44. 		//实例化对象
    45. 		Book book=new Book();
    46. 		book.setBookName(bookName);
    47. 		book.setBookPrice(Double.parseDouble(bookPrice));
    48. 		book.setBookType(bookType);
    49. 		//处理业务逻辑代码
    50. 		IBookBiz ibb=new BookBiz();
    51. 		Map m=new HashMap<>();
    52. 		try {
    53. 			ibb.insert(book);
    54. 			//没有进入SQLException代表增加成功
    55. 			m.put("s", true);
    56. 			m.put("m", "增加成功");
    57. 		} catch (SQLException e) {
    58. 			//代表失败
    59. 			m.put("s", false);
    60. 			m.put("m", "增加失败");
    61. 			e.printStackTrace();
    62. 		}
    63. 		String jsonString = JSON.toJSONString(m);
    64. 		out.print(jsonString);
    65. 		out.flush();
    66. 		out.close();
    67. 	}
    68.  
    69. }

     3.6 编辑书本Servlet代码

    1. package com.jmh.servlet;
    2.  
    3. import java.io.IOException;
    4. import java.io.PrintWriter;
    5. import java.sql.SQLException;
    6. import java.util.HashMap;
    7. import java.util.Map;
    8.  
    9. import javax.servlet.ServletException;
    10. import javax.servlet.annotation.WebServlet;
    11. import javax.servlet.http.HttpServlet;
    12. import javax.servlet.http.HttpServletRequest;
    13. import javax.servlet.http.HttpServletResponse;
    14.  
    15. import com.alibaba.fastjson.JSON;
    16. import com.jmh.biz.IBookBiz;
    17. import com.jmh.biz.imp.BookBiz;
    18. import com.jmh.entity.Book;
    19.  
    20. /**
    21.  * 修改书本
    22.  * @author 蒋明辉
    23.  *
    24.  */
    25. @WebServlet("/updateBookServlet.do")
    26. public class UpdateBookServlet extends HttpServlet{
    27. 	@Override
    28. 	protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
    29. 		doGet(req, resp);
    30. 	}
    31. 	@Override
    32. 	protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
    33. 			//设置编码
    34. 			req.setCharacterEncoding("utf-8");
    35. 			resp.setContentType("text/html;charset=utf-8");
    36. 			//获取对象
    37. 			PrintWriter out = resp.getWriter();
    38. 			//获取前端传送的参数
    39. 			String bookId=req.getParameter("bookId");
    40. 			String bookName=req.getParameter("bookName");
    41. 			String bookPrice=req.getParameter("bookPrice");
    42. 			String bookType=req.getParameter("bookType");
    43. 			/*System.out.println(bookId);
    44. 			System.out.println(bookName);
    45. 			System.out.println(bookPrice);
    46. 			System.out.println(bookType);*/
    47. 			//处理业务逻辑代码
    48. 			IBookBiz ibb=new BookBiz();
    49. 			//实例化一个书本对象
    50. 			Book book=new Book();
    51. 			book.setBookId(Integer.parseInt(bookId));
    52. 			book.setBookName(bookName);
    53. 			book.setBookPrice(Double.parseDouble(bookPrice));
    54. 			book.setBookType(bookType);
    55. 			//定义map集合
    56. 			Map m=new HashMap<>();
    57. 			try {
    58. 				ibb.update(book);
    59. 				//成功
    60. 				m.put("s", true);
    61. 				m.put("m", "修改成功");
    62. 			} catch (SQLException e) {
    63. 				//失败
    64. 				m.put("s", false);
    65. 				m.put("m", "修改失败");
    66. 				e.printStackTrace();
    67. 			}
    68. 			//转换为json格式 并输出到前端
    69. 			String jsonString = JSON.toJSONString(m);
    70. 			out.print(jsonString);
    71. 			out.flush();
    72. 			out.close();
    73.  
    74. }
    75. }

     3.7 删除书本Servlet代码

    1. package com.jmh.servlet;
    2.  
    3. import java.io.IOException;
    4. import java.io.PrintWriter;
    5. import java.sql.SQLException;
    6. import java.util.HashMap;
    7. import java.util.Map;
    8.  
    9. import javax.servlet.ServletException;
    10. import javax.servlet.annotation.WebServlet;
    11. import javax.servlet.http.HttpServlet;
    12. import javax.servlet.http.HttpServletRequest;
    13. import javax.servlet.http.HttpServletResponse;
    14. import javax.servlet.http.HttpSession;
    15.  
    16. import com.alibaba.fastjson.JSON;
    17. import com.alibaba.fastjson.support.hsf.HSFJSONUtils;
    18. import com.jmh.biz.IBookBiz;
    19. import com.jmh.biz.imp.BookBiz;
    20.  
    21. /**
    22.  * 删除书本
    23.  * @author 蒋明辉
    24.  *
    25.  */
    26. @WebServlet("/deleteBookServlet.do")
    27. public class DeleteBookServlet extends HttpServlet{
    28. 	@Override
    29. 	protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
    30. 	doGet(req, resp);
    31. 	}
    32. 	@Override
    33. 	protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
    34. 		//设置编码
    35. 		req.setCharacterEncoding("utf-8");
    36. 		resp.setContentType("text/html;charset=utf-8");
    37. 		//获取对象
    38. 		HttpSession session = req.getSession();
    39. 		PrintWriter out=resp.getWriter();
    40. 		//获取前端传来的参数
    41. 		String bookId = req.getParameter("bookId");
    42. 		System.out.println("要删除的编号"+bookId);
    43. 		//处理业务逻辑代码
    44. 		IBookBiz ibb=new BookBiz();
    45. 		//定义map集合
    46. 		Map m=new HashMap<>();
    47. 		try {
    48. 			ibb.delete(bookId);
    49. 			m.put("s", true);
    50. 			m.put("m", "删除成功!");
    51. 		} catch (SQLException e) {
    52. 			//删除失败
    53. 			m.put("s", false);
    54. 			m.put("m", "删除失败!");
    55. 			e.printStackTrace();
    56. 		}
    57. 		//输送到前端
    58. 		String jsonString = JSON.toJSONString(m);
    59. 		//输送到前端
    60. 		out.print(jsonString);
    61. 		out.flush();
    62. 		out.close();
    63. 	}
    64.  
    65. }

     3.8 dao层接口代码

    1. package com.jmh.dao;
    2.  
    3. import java.sql.SQLException;
    4. import java.util.List;
    5.  
    6. import com.jmh.entity.Book;
    7.  
    8. public interface IBookDao {
    9. 	/**
    10. 	 * 带有模糊查询的分页方法
    11. 	 * @param bookName 模糊查询关键字
    12. 	 * @param pageIndex 当前开始的条数
    13. 	 * @param pageSize 页大小
    14. 	 * @return 结果集对象
    15. 	 * @throws SQLException 异常
    16. 	 */
    17. 	List query(String bookName, Integer pageIndex, Integer pageSize) throws SQLException;
    18. 	/**
    19. 	 * 带有模糊查询的分页方法
    20. 	 * @param bookName 模糊查询关键字
    21. 	 * @param pageIndex 当前开始的条数
    22. 	 * @param pageSize 页大小
    23. 	 * @return 结果集对象
    24. 	 * @throws SQLException 异常
    25. 	 */
    26. 	Integer sumCount(String bookName) throws SQLException;
    27. 	/**
    28. 	 * 增加书本的方法
    29. 	 * @param b 书本对象
    30. 	 * @throws SQLException 异常
    31. 	 */
    32. 	void insert(Book b) throws SQLException;
    33. 	/**
    34. 	 * 根据书本编号删除书本的方法
    35. 	 * @param bookid 书本编号
    36. 	 * @throws SQLException
    37. 	 */
    38. 	void delete(String bookid) throws SQLException;
    39. 	/**
    40. 	 * 根据书本编号修改书本信息的方法
    41. 	 * @param book 书本对象
    42. 	 * @throws SQLException
    43. 	 */
    44. 	void update(Book book) throws SQLException;
    45.  
    46. }

     3.9 dao层实现类代码

    1. package com.jmh.dao.imp;
    2.  
    3. import java.sql.Connection;
    4. import java.sql.PreparedStatement;
    5. import java.sql.ResultSet;
    6. import java.sql.SQLException;
    7. import java.util.ArrayList;
    8. import java.util.List;
    9.  
    10. import com.jmh.dao.IBookDao;
    11. import com.jmh.entity.Book;
    12. import com.jmh.entity.Module;
    13. import com.jmh.util.DBAccess;
    14.  
    15. public class BookDao implements IBookDao{
    16. 	private Connection con;
    17. 	private PreparedStatement ps;
    18. 	private ResultSet rs;
    19. 	private List bookls;
    20. 	private Book book;
    21. 	private String sql;
    22. 	private Integer n;
    23. 	private Integer sumCount;//总数据量
    24. 	/**
    25. 	 * 带有模糊查询的分页方法
    26. 	 * @param bookName 模糊查询关键字
    27. 	 * @param pageIndex 当前开始的条数
    28. 	 * @param pageSize 页大小
    29. 	 * @return 结果集对象
    30. 	 * @throws SQLException 异常
    31. 	 */
    32. 	@Override
    33. 	public List query(String bookName,Integer pageIndex,Integer pageSize) throws SQLException {//模糊查询关键字、最大页码、页大小
    34. 		Integer begin=(pageIndex-1)*pageSize;
    35. 		bookls=new ArrayList<>();
    36. 		con=DBAccess.getConnection();
    37. 		//纯纯的分页查询
    38. 		sql="select bookId,bookName,bookPrice,bookType,bookNamePinYin from t_book where bookId limit ?,? ";
    39. 		if(null!=bookName&&!"".equals(bookName)) {//带模糊查询的分页
    40. 			sql="select bookId,bookName,bookPrice,bookType,bookNamePinYin from t_book where bookName like ? or bookNamePinYin like ? and bookId limit ?,?";
    41. 		}
    42. 		ps=con.prepareStatement(sql);
    43. 		//判断进入了哪一个程序就给哪一个程序赋值
    44. 		if(null!=bookName&&!"".equals(bookName)) {
    45. 			ps.setString(1, "%"+bookName+"%");//模糊查询关键字
    46. 			ps.setString(2, "%"+bookName+"%");//拼音模糊查询关键字
    47. 			ps.setInt(3, begin);//每页开始的条数
    48. 			ps.setInt(4, pageSize);//页大小
    49. 		}else {//分页字段赋值
    50. 			ps.setInt(1, begin);//每页开始的条数
    51. 			ps.setInt(2, pageSize);//页大小
    52. 		}
    53. 		rs=ps.executeQuery();
    54. 		while(rs.next()) {
    55. 			book=new Book(rs.getInt("bookId"), rs.getString("bookName"), rs.getDouble("bookPrice"), rs.getString("bookType"), rs.getString("bookNamePinYin"));
    56. 			bookls.add(book);
    57. 		}
    58. 		DBAccess.close(con, ps, rs);
    59. 		return bookls;
    60. 	}
    61. 	/**
    62. 	 * 总数据量的方法
    63. 	 * @param bookName 模糊查询关键字
    64. 	 * @return 影响条数
    65. 	 * @throws SQLException 异常
    66. 	 */
    67. 	@Override
    68. 	public Integer sumCount(String bookName) throws SQLException {
    69. 		con=DBAccess.getConnection();
    70. 		sql="select count(0) from t_book";
    71. 		//判断如果是模糊查询就追加sql语句
    72. 		if(null!=bookName&&!"".equals(bookName)) {
    73. 			sql+=" where bookName like ? or bookNamePinYin like ?";
    74. 		}
    75. 		ps=con.prepareStatement(sql);
    76. 		//如果是模糊查询就给字段赋值
    77. 		if(null!=bookName&&!"".equals(bookName)) {
    78. 			ps.setString(1, "%"+bookName+"%");//模糊查询关键字
    79. 			ps.setString(2, "%"+bookName+"%");//拼音模糊查询关键字
    80. 		}
    81. 		rs=ps.executeQuery();
    82. 		if(rs.next()) {
    83. 			//给素=所有影响条数赋给定义的变量
    84. 			sumCount=rs.getInt(1);
    85. 		}
    86. 		DBAccess.close(con, ps, rs);
    87. 		return sumCount;
    88. 	}
    89. 	/**
    90. 	 * 增加书本的方法
    91. 	 * @param b 书本对象
    92. 	 * @throws SQLException 异常
    93. 	 */
    94. 	@Override
    95. 	public void insert(Book b) throws SQLException {
    96. 		con=DBAccess.getConnection();
    97. 		sql="insert into t_book(bookName,bookPrice,bookType,BookNamePinYin) values"
    98. 				+ "(?,?,?,?)";
    99. 		ps=con.prepareStatement(sql);
    100. 		ps.setString(1, b.getBookName());
    101. 		ps.setDouble(2, b.getBookPrice());
    102. 		ps.setString(3, b.getBookType());
    103. 		ps.setString(4, b.getBookNamePinYin());
    104. 		n=ps.executeUpdate();
    105. 		DBAccess.close(con, ps, rs);
    106. 	}
    107. 	/**
    108. 	 * 根据书本编号删除书本的方法
    109. 	 * @param bookid 书本编号
    110. 	 * @throws SQLException
    111. 	 */
    112. 	@Override
    113. 	public void delete(String bookid) throws SQLException {
    114. 		con=DBAccess.getConnection();
    115. 		sql="delete from t_book where bookId=?";
    116. 		ps=con.prepareStatement(sql);
    117. 		ps.setString(1, bookid);
    118. 		ps.executeUpdate();
    119. 		DBAccess.close(con, ps, rs);
    120. 	}
    121. 	/**
    122. 	 * 根据书本编号修改书本信息的方法
    123. 	 * @param book 书本对象
    124. 	 * @throws SQLException
    125. 	 */
    126. 	@Override
    127. 	public void update(Book book) throws SQLException {
    128. 		con=DBAccess.getConnection();
    129. 		sql="update t_book set bookName=?,bookPrice=?,bookType=? where bookId=?";
    130. 		ps=con.prepareStatement(sql);
    131. 		//给占位符赋值
    132. 		ps.setString(1, book.getBookName());
    133. 		ps.setDouble(2, book.getBookPrice());
    134. 		ps.setString(3, book.getBookType());
    135. 		ps.setInt(4, book.getBookId());
    136. 		ps.executeUpdate();
    137. 		DBAccess.close(con, ps, rs);
    138. 	}
    139. }

     4.0 biz层接口代码

    1. package com.jmh.biz;
    2.  
    3. import java.sql.SQLException;
    4. import java.util.List;
    5.  
    6. import com.jmh.entity.Book;
    7.  
    8. public interface IBookBiz {
    9. 	/**
    10. 	 * 带有模糊查询的分页方法
    11. 	 * @param bookName 模糊查询关键字
    12. 	 * @param pageIndex 当前开始的条数
    13. 	 * @param pageSize 页大小
    14. 	 * @return 结果集对象
    15. 	 * @throws SQLException 异常
    16. 	 */
    17. 	List query(String bookName, Integer pageIndex, Integer pageSize) throws SQLException;
    18. 	/**
    19. 	 * 带有模糊查询的分页方法
    20. 	 * @param bookName 模糊查询关键字
    21. 	 * @param pageIndex 当前开始的条数
    22. 	 * @param pageSize 页大小
    23. 	 * @return 结果集对象
    24. 	 * @throws SQLException 异常
    25. 	 */
    26. 	Integer sumCount(String bookName) throws SQLException;
    27. 	/**
    28. 	 * 增加书本的方法
    29. 	 * @param b 书本对象
    30. 	 * @throws SQLException 异常
    31. 	 */
    32. 	void insert(Book b) throws SQLException;
    33. 	/**
    34. 	 * 根据书本编号删除书本的方法
    35. 	 * @param bookid 书本编号
    36. 	 * @throws SQLException
    37. 	 */
    38. 	void delete(String bookid) throws SQLException;
    39. 	/**
    40. 	 * 根据书本编号修改书本信息的方法
    41. 	 * @param book 书本对象
    42. 	 * @throws SQLException
    43. 	 */
    44. 	void update(Book book) throws SQLException;
    45. 	
    46. }

     4.1 biz层实现类代码

    1. package com.jmh.biz.imp;
    2.  
    3. import java.sql.SQLException;
    4. import java.util.List;
    5.  
    6. import com.jmh.biz.IBookBiz;
    7. import com.jmh.dao.IBookDao;
    8. import com.jmh.dao.imp.BookDao;
    9. import com.jmh.entity.Book;
    10.  
    11. public class BookBiz implements IBookBiz{
    12. 		IBookDao ibd=new BookDao();
    13. 	@Override
    14. 	public List query(String bookName, Integer pageIndex, Integer pageSize) throws SQLException {
    15. 		// TODO Auto-generated method stub
    16. 		return ibd.query(bookName, pageIndex, pageSize);
    17. 	}
    18.  
    19. 	@Override
    20. 	public Integer sumCount(String bookName) throws SQLException {
    21. 		// TODO Auto-generated method stub
    22. 		return ibd.sumCount(bookName);
    23. 	}
    24.  
    25. 	@Override
    26. 	public void insert(Book b) throws SQLException {
    27. 			ibd.insert(b);
    28. 	}
    29.  
    30. 	@Override
    31. 	public void delete(String bookid) throws SQLException {
    32. 		ibd.delete(bookid);
    33. 	}
    34.  
    35. 	@Override
    36. 	public void update(Book book) throws SQLException {
    37. 		ibd.update(book);
    38. 	}
    39.  
    40. }

                                                

  • 相关阅读:
    代码随想录算法训练营完结篇 ★★★
    HarmonyOS开发云工程与开发云函数
    【人生苦短，我学 Python】（15）迭代器、生成器
    什么是MVC-02
    小程序源码：王者荣耀吃鸡气泡等等头像框DIY在线生成N种风格-多玩法安装简单
    竞速榜实时离线对数方案演进介绍
    从零开始写 Docker(八)---实现 mydocker run -d 支持后台运行容器
    pid,ppid,pgid,sid进程间关系
    redis问题记录
    数据包守恒 & TCP 拥塞控制
  • 原文地址：https://blog.csdn.net/m0_63300795/article/details/126458954