easyui_06.DataGrid数据删改

这篇博客介绍了如何使用EasyUI的DataGrid进行数据的删除和修改,包括涉及的entity文件、Dao及DaoImpl实现、Servlet处理和js脚本文件的详细步骤。

摘要生成于 C知道 ,由 DeepSeek-R1 满血版支持, 前往体验 >

目录

效果如图所示:

1.存放entity的文件夹

2.存放Dao的系列文件夹:Dao,DaoImpl

3.存放Servlet的文件夹。

4.存放js的文件夹。


效果如图所示:

 

 

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);
			}
		}
		
  
	}); 
	
	
}

"sgmediation.zip" 是一个包含 UCLA(加利福尼亚大学洛杉矶分校)开发的 sgmediation 插件的压缩包。该插件专为统计分析软件 Stata 设计,用于进行中介效应分析。在社会科学、心理学、市场营销等领域,中介效应分析是一种关键的统计方法,它帮助研究人员探究变量之间的因果关系,尤其是中间变量如何影响因变量与自变量之间的关系。Stata 是一款广泛使用的统计分析软件,具备众多命令和用户编写的程序来拓展其功能,sgmediation 插件便是其中之一。它能让用户在 Stata 中轻松开展中介效应分析,无需编写复杂代码。 下载并解压 "sgmediation.zip" 后,需将解压得到的 "sgmediation" 文件移至 Stata 的 ado 目录结构中。ado(ado 目录并非“adolescent data organization”缩写,而是 Stata 的自定义命令存放目录)目录是 Stata 存放自定义命令的地方,应将文件放置于 "ado\base\s" 子目录下。这样,Stata 启动时会自动加载该目录下的所有 ado 文件,使 "sgmediation" 命令在 Stata 命令行中可用。 使用 sgmediation 插件的步骤如下:1. 安装插件:将解压后的 "sgmediation" 文件放入 Stata 的 ado 目录。如果 Stata 安装路径是 C:\Program Files\Stata\ado\base,则需将文件复制到 C:\Program Files\Stata\ado\base\s。2. 启动 Stata:打开 Stata,确保软件已更新至最新版本,以便识别新添加的 ado 文件。3. 加载插件:启动 Stata 后,在命令行输入 ado update sgmediation,以确保插件已加载并更新至最新版本。4
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值