EasyUI (三)

最新推荐文章于 2024-09-24 17:29:02 发布

暂无、

最新推荐文章于 2024-09-24 17:29:02 发布

阅读量142

点赞数

分类专栏：前端文章标签： easyui

本文链接：https://blog.csdn.net/weixin_43939301/article/details/92015358

版权

前端专栏收录该内容

5 篇文章 0 订阅

订阅专栏

今天让我们利用esayui实现增删改查
     今日代码基本步骤：
           1、datagrid布局
           2、dialog布局
           3、form布局
           4、通用的JsonBaseDao增删改方法
           5、dao层
           6、web层
           7、功能完善

下面我们对t_easyui_user_version2表进行操作
原有数据：
在这里插入图片描述
核心代码：
userManage.jsp

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>Insert title here</title>
<link rel="stylesheet" type="text/css" href="${pageContext.request.contextPath }/static/js/easyui5/themes/default/easyui.css">   
<link rel="stylesheet" type="text/css" href="${pageContext.request.contextPath }/static/js/easyui5/themes/icon.css">
<script type="text/javascript" src="${pageContext.request.contextPath }/static/js/easyui5/jquery.min.js"></script>   
<script type="text/javascript" src="${pageContext.request.contextPath }/static/js/easyui5/jquery.easyui.min.js"></script>
<script type="text/javascript" src="${pageContext.request.contextPath }/static/js/userManage.js"></script>
</head>
<body>
<!-- 展示数据所用 -->
<table id="dg"></table> 
<input type="hidden" id="ctx" value="${pageContext.request.contextPath }">
<!-- 弹出框提交表单所用 -->
<div id="dd" class="easyui-dialog" title="编辑窗体" style="width:400px;height:200px;"   
        data-options="iconCls:'icon-save',resizable:true,modal:true,buttons:'#bb',modal:true,closed:true">   
 <form id="ff" method="post">   
 <input type="hidden" name="SerialNo" id="SerialNo">
    <div>   
        <label for="uid">uid:</label>   
        <input class="easyui-validatebox" type="text" name="uid" data-options="required:true" />   
    </div>
    <div>   
        <label for="uname">uname:</label>   
        <input class="easyui-validatebox" type="text" name="uname" data-options="required:true" />   
    </div>
    <div>   
        <label for="upwd">upwd:</label>   
        <input class="easyui-validatebox" type="text" name="upwd" data-options="required:true" />   
    </div>
</form> 
</div> 
<div id="bb">
<a href="#" class="easyui-linkbutton" id="method" value="edit" οnclick='ok()'>保存</a>
<a href="#" class="easyui-linkbutton">关闭</a>
</div>
</body>
</html>

userManage.js

$(function(){
 $('#dg').datagrid({    
     url:'../userAction.action?methodName=list',
     fitColumns: true,
     fit: true,
     pagination:true,
     columns:[[    
         {field:'uid',title:'代码',width:100},    
         {field:'uname',title:'名称',width:100},    
         {field:'upwd',title:'价格',width:100,align:'right'}    
     ]],
     toolbar: [{
   iconCls: 'icon-edit',
   handler: function(){
    var row = $('#dg').datagrid('getSelected');
    if(row){
     $('#ff').form('load',row);
     $('button').attr("value","edit");
     $('#dd').dialog('open');
    }
   }
  },'-',{
   iconCls: 'icon-add',
   handler: function(){
    var row = $('#dg').datagrid('getSelected');
    $('button').attr("value","edit");
    $('#ff').form('clear');
    $('#dd').dialog('open');
   }
  },'-',{
   iconCls: 'icon-remove',
   handler: function(){
    var row=$('#dg').datagrid('getSelected');
    $('#ff').form('load',row);
    if(confirm('你确定要删除吗')){
     $("button").attr("value","del");
     ok();
    }
   }
  }]
 });
})
function ok(){
 $('#ff').form('submit', {    
     url:'../userAction.action?methodName=edit',    
     success: function(edit){    
      $('#dd').dialog('close');
      $('#dg').datagrid('reload');
      $('#ff').form('clear');
     }    
 }); 
}

UserDao.java

package com.liyi.dao;
import java.sql.SQLException;
import java.util.List;
import java.util.Map;
import com.liyi.util.JsonBaseDao;
import com.liyi.util.JsonUtils;
import com.liyi.util.PageBean;
import com.liyi.util.StringUtils;
/**
 * 登录查询用户表
 * @author 224李毅
 *
 */
public class UserDao extends JsonBaseDao {
 public List<Map<String, Object>> list(Map<String, String[]>paMap,PageBean pageBean) throws InstantiationException, IllegalAccessException, SQLException{
  String sql = "select * from t_easyui_user_version2 where true";
  String uid = JsonUtils.getParamVal(paMap, "uid");
  String upwd = JsonUtils.getParamVal(paMap, "upwd");
  if(StringUtils.isNotBlank(uid)) {
   sql = sql + " and uid="+uid;
  }
  if(StringUtils.isNotBlank(upwd)) {
   sql = sql + " and upwd="+upwd;
  }
  return super.executeQuery(sql, pageBean);
 }
 /**
  * 通过中间表查询登录所对应的权限
  * @param paMap
  * @param pageBean
  * @return
  * @throws InstantiationException
  * @throws IllegalAccessException
  * @throws SQLException
  */
 public List<Map<String, Object>> listMenu(String uid,PageBean pageBean) throws InstantiationException, IllegalAccessException, SQLException{
  String sql = "select * from t_easyui_usermenu where true";
  if(StringUtils.isNotBlank(uid)) {
   sql = sql + " and uid="+uid;
  }
  return super.executeQuery(sql, pageBean);
 }
 /**
  * 修改方法
  * @param paMap
  * @return
  * @throws NoSuchFieldException
  * @throws SecurityException
  * @throws IllegalArgumentException
  * @throws IllegalAccessException
  * @throws SQLException
  */
 public int edit(Map<String, String[]> paMap) throws NoSuchFieldException, SecurityException, IllegalArgumentException, IllegalAccessException, SQLException {
  String sql = "update t_easyui_user_version2 set uid=?,uname=?,upwd=? where serialno=?";
  return super.executeUpdate(sql, new String[] {"uid","uname","upwd","SerialNo"}, paMap);
 }
 /**
  * 增加方法
  * @param paMap
  * @return
  * @throws NoSuchFieldException
  * @throws SecurityException
  * @throws IllegalArgumentException
  * @throws IllegalAccessException
  * @throws SQLException
  */
 public int add(Map<String, String[]> paMap) throws NoSuchFieldException, SecurityException, IllegalArgumentException, IllegalAccessException, SQLException {
  String sql = "insert into t_easyui_user_version2 (uid,uname,upwd)values(?,?,?)";
  return super.executeUpdate(sql, new String[] {"uid","uname","upwd"}, paMap);
 }
 /**
  * 删除方法
  * @param paMap
  * @return
  * @throws NoSuchFieldException
  * @throws SecurityException
  * @throws IllegalArgumentException
  * @throws IllegalAccessException
  * @throws SQLException
  */
 public int del(Map<String, String[]> paMap) throws NoSuchFieldException, SecurityException, IllegalArgumentException, IllegalAccessException, SQLException {
  String sql = "delete from t_easyui_user_version2 where SerialNo=?";
  return super.executeUpdate(sql, new String[] {"SerialNo"}, paMap);
 }
}

UserAction.java

package com.liyi.web;
import java.util.HashMap;
import java.util.List;
import java.util.Map;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import com.fasterxml.jackson.databind.ObjectMapper;
import com.liyi.dao.UserDao;
import com.liyi.util.PageBean;
import com.liyi.util.ResponseUtil;
import com.zking.framework.ActionSupport;
public class UserAction extends ActionSupport {
 private UserDao userDao = new UserDao();
 public String login(HttpServletRequest req,HttpServletResponse resp) {
  try {
   List<Map<String, Object>> list = this.userDao.list(req.getParameterMap(), null);
   if(list!=null&&list.size()>0) {
    List<Map<String, Object>> listMenu = this.userDao.listMenu(req.getParameter("uid"), null);
    StringBuilder sb = new StringBuilder();
    for (Map<String, Object> map : listMenu) {
     sb.append(","+map.get("menuId"));
    }
    req.setAttribute("menuHid", sb.substring(1));
   }else {
    return "login";
   }
  } catch (Exception e) {
   e.printStackTrace();
  }
  return "index";
 }
 /**
  * datagrid所需数据后端程序员开发完毕
  * @param req
  * @param resp
  * @return
  */
 public String list(HttpServletRequest req,HttpServletResponse resp) {
  try {
   PageBean pageBean = new PageBean();
   pageBean.setRequest(req);
   List<Map<String, Object>> list = this.userDao.list(req.getParameterMap(), pageBean);
   ObjectMapper om = new ObjectMapper();
   Map<String, Object>map = new HashMap<>();
   map.put("total", pageBean.getTotal());
   map.put("rows", list);
   ResponseUtil.write(resp, om.writeValueAsString(map));
  } catch (Exception e) {
   e.printStackTrace();
  }
  return null;
 }
 /**
  * form组件提交所需后端程序员处理完毕
  * @param req
  * @param resp
  * @return
  */
 public String edit(HttpServletRequest req,HttpServletResponse resp) {
  try {
   int edit = this.userDao.edit(req.getParameterMap());
   ObjectMapper om = new ObjectMapper();
   ResponseUtil.write(resp, om.writeValueAsString(edit));
  } catch (Exception e) {
   e.printStackTrace();
  }
  return null;
 }
 /**
  * form组件提交所需后端程序员处理完毕
  * @param req
  * @param resp
  * @return
  */
 public String add(HttpServletRequest req,HttpServletResponse resp) {
  try {
   int add = this.userDao.add(req.getParameterMap());
   ObjectMapper om = new ObjectMapper();
   ResponseUtil.write(resp, om.writeValueAsString(add));
  } catch (Exception e) {
   e.printStackTrace();
  }
  return null;
 }
 /**
  * 删
  * @param req
  * @param resp
  * @return
  */
 public String del(HttpServletRequest req,HttpServletResponse resp) {
  try {
   int del = this.userDao.del(req.getParameterMap());
   ObjectMapper om = new ObjectMapper();
   ResponseUtil.write(resp, om.writeValueAsString(del));
  } catch (Exception e) {
   e.printStackTrace();
  }
  return null;
 }
}