MuBatis+layUI一对多查关联属性

最新推荐文章于 2023-09-22 20:28:52 发布

java后生

最新推荐文章于 2023-09-22 20:28:52 发布

阅读量361

点赞数 1

分类专栏： Mybatis

本文链接：https://blog.csdn.net/weixin_44840242/article/details/89393897

版权

Mybatis 专栏收录该内容

3 篇文章 0 订阅

订阅专栏

1.domian

public class Employee {
private Long id;

private String username;

private String realnam;

private String password;

private String tel;

private Department department;

//必须要有这个字段的domain

@JsonFormat(pattern = "yyyy-MM-dd ",timezone ="GMT+8" )
private Date inputtime;

private String state;

private Long role;

private String unionid;

private Tenant tenant;

//get.set省略

2.mapper.xml

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd" >
<mapper namespace="cn.itsource.crm.mapper.EmployeeMapper" >
<resultMap id="BaseResultMap" type="cn.itsource.crm.domain.Employee" >
    <id column="id" property="id" jdbcType="BIGINT" />
    <result column="username" property="username" jdbcType="VARCHAR" />
    <result column="realnam" property="realnam" jdbcType="VARCHAR" />
    <result column="password" property="password" jdbcType="VARCHAR" />
    <result column="tel" property="tel" jdbcType="VARCHAR" />
    <result column="inputtime" property="inputtime" jdbcType="TIMESTAMP" />
    <result column="state" property="state" jdbcType="VARCHAR" />
    <result column="role" property="role" jdbcType="BIGINT" />
    <result column="unionid" property="unionid" jdbcType="VARCHAR" />
    <collection property="department" ofType="cn.itsource.crm.domain.Department">
      <id column="did" property="id" jdbcType="BIGINT"/>
      <result column="dname" property="name"></result>
    </collection>
    <collection property="tenant" ofType="cn.itsource.crm.domain.Tenant">
      <id column="tid" property="id" jdbcType="BIGINT"/>
      <result column="tcompanyname" property="companyname"></result>
    </collection>
</resultMap>

<select id="selectByUnionId" parameterType="string" resultMap="BaseResultMap">
    select id, username, realnam, password, tel, department_id, inputtime, state, role,
    unionid, tenant
    from t_employee
    where unionid=#{unionId}
</select>

<update id="updateUnionidById">
    update t_employee
    set unionid = #{unionid}
    where id=#{id}
</update>

<delete id="deleteByPrimaryKey" parameterType="java.lang.Long" >
delete from t_employee
where id = #{id,jdbcType=BIGINT}
</delete>

<insert id="insert" parameterType="cn.itsource.crm.domain.Employee" >
    <selectKey resultType="java.lang.Long" keyProperty="id" order="BEFORE" >
      SELECT LAST_INSERT_ID()
    </selectKey>
    insert into t_employee (username, realnam,
    password, tel, department_id,
    inputtime, state, role,
    unionid, tenant)
    values (#{username,jdbcType=VARCHAR}, #{realnam,jdbcType=VARCHAR},
    #{password,jdbcType=VARCHAR}, #{tel,jdbcType=VARCHAR}, #{department.id,jdbcType=VARCHAR},
    #{inputtime,jdbcType=TIMESTAMP}, #{state,jdbcType=VARCHAR}, #{role,jdbcType=BIGINT},
    #{unionid,jdbcType=VARCHAR}, #{tenant,jdbcType=BIGINT})
</insert>

<update id="updateByPrimaryKey" parameterType="cn.itsource.crm.domain.Employee" >
    update t_employee
    <set>
      <if test="username!=null and username!=''">
        username = #{username,jdbcType=VARCHAR},
      </if>
      <if test="realnam!=null and realnam!=''">
        realnam = #{realnam,jdbcType=VARCHAR},
      </if>
      <if test="password!=null and password!=''">
        password = #{password,jdbcType=VARCHAR},
      </if>
      <if test="tel!=null and tel!=''">
        tel = #{tel,jdbcType=VARCHAR},
      </if>
      <if test="department!=null and department!=''">
        department_id = #{department.id,jdbcType=VARCHAR},
      </if>
      <if test="inputtime!=null and inputtime!=''">
        inputtime = #{inputtime,jdbcType=TIMESTAMP},
      </if>
      <if test="state!=null and state!=''">
        state = #{state,jdbcType=VARCHAR},
      </if>
      <if test="role!=null and role!=''">
        role = #{role,jdbcType=BIGINT},
      </if>
      <if test="unionid!=null and unionid!=''">
        unionid = #{unionid,jdbcType=VARCHAR},
      </if>
      <if test="tenant!=null and tenant!=''">
        tenant = #{tenant,jdbcType=BIGINT}
      </if>
    </set>
    where id = #{id,jdbcType=BIGINT}
</update>

<select id="selectByPrimaryKey" resultMap="BaseResultMap" parameterType="java.lang.Long" >
    select id, username, realnam, password, tel, department_id, inputtime, state, role,
    unionid, tenant
    from t_employee
    where id = #{id,jdbcType=BIGINT}
</select>

<select id="selectAll" resultMap="BaseResultMap" >
    select id, username, realnam, password, tel, department_id, inputtime, state, role,
    unionid, tenant
    from t_employee
</select>

<select id="querySelectAll" parameterType="EmployeeQuery" resultMap="BaseResultMap">
    select e.id, e.username, e.realnam, e.password, e.tel, e.inputtime, e.state, e.role,
    e.unionid, d.id did,d.name dname,t.id tid,t.companyname tcompanyname
    from t_employee e left join t_department d on e.department_id = d.id
    left join t_tenant t on e.tenant=t.id
    <where>
      <if test="username!=null and username!=''">
        and e.username like concat("%",#{username},"%")
      </if>
      <if test="state!=null and state!=''">
        and e.state like concat("%",#{state},"%")
      </if>
      <if test="oldSellerId!=null">
        and e.id != #{oldSellerId}
      </if>
    </where>
</select>

3.前台

1.JSP

<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
    <title>Title</title>
    <link rel="stylesheet" href="/static/layui/css/layui.css">
    <script src="/static/layui/layui.js"></script>
    <script src="/static/js/jquery/jquery.min.js"></script>
    <script src="/static/js/jquery/jquery.jdirk.js"></script>
    <script src="/static/js/jquery/jquery.form.js"></script>
    <%--居中--%>
    <style>
        .layui-table-cell .layui-form-checkbox[lay-skin="primary"] {
            top: 50%;
            transform: translateY(-50%);
        }

        .layui-table-cell {
            text-align: center;
        }

</style>
</head>
<body>
<table class="layui-hide" id="test" lay-filter="test"></table>

      <%-- <div class="layui-form-item">
            <div class="layui-inline">
                <label class="layui-form-label">角色</label>
                <div class="layui-input-inline">
                    <input type="text" name="rool" lay-filter="rool" placeholder="角色"
                           class="layui-input">
                </div>
            </div>
        </div>--%>
        <div class="layui-form-item">
            <div class="layui-inline">
                <label class="layui-form-label">第三方ID</label>
                <div class="layui-input-inline">
                    <input type="text" name="unionid" lay-filter="unionid" placeholder="第三方ID"
                           class="layui-input">
                </div>
            </div>
        </div>

2.js

layui.use(['form','layer','jquery','laypage','table'], function(){
    var table = layui.table;
    $ = layui.jquery;
    var form=layui.form;

    form.verify({
        //用户名认证规则
        length: function(value, item) {
            if(value.trim()&&value.length<6){
                return "输入的用户名不能少于6个字符";
            }
        },
        checkName:function(value, item) {
            var html=$.ajax({
                url:"/employee/checkName",
                data:{"username":value,"id":$("input[username='id']").val()},
                async:false
            }).responseText;
            if(html=='false'){
                return "用户名重复";
            }
        }
    });

    table.render({
        elem: '#test'
        ,url:'/employee/list'
        ,toolbar: '#toolbarDemo'
        ,title: '用户数据表'
        ,cols: [[
            {type: 'checkbox', fixed: 'left'}
            ,{field:'id', title:'ID', fixed: 'left', unresize: true, sort: true}
            ,{field:'username', title:'员工账号', edit: 'text'}
            ,{field:'realnam', title:'真实姓名', edit: 'text'}
            ,{field:'tel', title:'电话', edit: 'text'}
            ,{field:'inputtime', title:'录入时间',edit: 'text', sort: true}
            ,{field:'department', title:'部门', sort: true, templet: function(d){
                    console.debug(d)
                    //在js中认为false的值： 0 "" undefined false null NaN
                    return d.department ? d.department.name:"<span style='color: red'>无部门</span>";
                }}
            ,{field:'state', title:'状态', edit: 'text',
                templet : function(data) {// 替换数据
                    if(data.state==0){
                        return "<span style='color: red'>离职</span>";;
                    }
                    else if(data.state==1){
                        return "在职";
                    }
                }
            }
         /*   ,{field:'rool', title:'角色', edit: 'text'}*/
            ,{field:'unionid', title:'第三方ID', edit: 'text'}
            ,{field:'tenant', title:'租户', sort: true, templet: function(d){
                    console.debug(d)
                    //在js中认为false的值： 0 "" undefined false null NaN
                    return d.tenant ? d.tenant.companyname:"<span style='color: red'>无租户</span>";
                }}
            ,{fixed: 'right', title:'操作', toolbar: '#barDemo', width:150}
        ]]
        ,page: true
    });
    //租户下拉框选择
    $.get("/tenant/list",function (result) {
        var select = $("select[name='tenant.id']");
        select.empty();

        select.append("<option value=''>请选择</option>");
        $.each(result.data,function (index,obj) {
            select.append("<option value='"+obj.id+"'>"+obj.companyname+"</option>");

        });
        form.render('select');
    })

    //部门下拉框
    $.get("/department/list",function (result) {
        var select = $("select[name='department.id']");
        select.empty();

        select.append("<option value=''>请选择</option>");
        $.each(result.data,function (index,obj) {
            select.append("<option value='"+obj.id+"'>"+obj.name+"</option>");

        });
        form.render('select');
    })
    //头工具栏事件
    table.on('toolbar(test)', function(obj){
        var checkStatus = table.checkStatus(obj.config.id);
        switch(obj.event){
            //新增
            case 'add':
                //清空form表单
                $("#addForm").clearForm();
                var data = checkStatus.data;
                layer.open({
                    title : "新增用户",
                    type:1,
                    skin:'layui-layer-rim',
                    area: ['350px', '400px'],
                    content: $("#add"),
                    success : function(layero, index){
                        setTimeout(function(){
                            layui.layer.tips('点击此处可返回', '.layui-layer-setwin .layui-layer-close', {
                                tips: 3
                            });
                        },500)
                    }
                })
                break;
            case 'search':
                table.reload('test', {
                    where: $("#searchForm").serializeObject()//用jquery.jdirk.js实现的，将form表单中的input值转成json格式
                    ,page: {
                        curr: 1 //重新从第 1 页开始
                    }
                });
                break;
            case 'batchDel':
                var data = checkStatus.data;
                if(data.length==0){
                    layer.alert("请至少选中一行再进行操作",{
                        icon:2,
                        title:'错误'
                    });
                    break;
                }
                //准备一个id数组
                var ids=[];
                $.each(data,function (index, obj) {
                    ids.push(obj.id)
                })
                layer.confirm('确定删除这些数据?', function(index) {
                    $.post("/employee/batchDel", {"ids": ids.toString()}, function (result) {
                        if (result.succe) {
                            //刷新页面
                            table.reload('test',{page:{curr:1}});
                            layer.close(index);
                        } else {
                            layer.alert(result.backMessage, {
                                icon: 2,
                                title: '错误'
                            });
                        }
                    })
                })
                break;
        };
    });

    //监听行工具事件
    table.on('tool(test)', function(obj){
        var data = obj.data;
        //console.log(obj)
        if(obj.event === 'del'){
            layer.confirm('真的删除行么', function(index){
                //删除请求
                $.get("/employee/delete",{id: data.id},function (result) {
                    if(result.succe){
                        //刷新页面
                        table.reload('test',{page:{curr:1}});
                        layer.close(index);
                    }else {
                        layer.alert(result.backMessage,{
                            icon:2,
                            title:'错误'
                        });
                    }
                })
            });
        } else if(obj.event === 'edit'){
            layer.open({
                title : "修改用户",
                type:1,
                skin:'layui-layer-rim',
                area: ['350px', '400px'],
                content: $("#add"),
                success : function(layero, index){
                    setTimeout(function(){
                        layui.layer.tips('点击此处可返回', '.layui-layer-setwin .layui-layer-close', {
                            tips: 3
                        });
                    },200)
                }
            })
            //动态赋值解决下拉框字段不一样
            if(data.tenant){
                data['tenant.id']=data.tenant.id;
            }
            if(data.department){
                data['department.id']=data.department.id;
            }
            form.val("editForm", data)
        }
    });
    //提交保存
    form.on('submit(*)', function(data){

java后生

关注

1
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
MuBatis+layUI一对多查关联属性

1.domianpublic class Employee { private Long id; private String username; private String realnam; private String password; private String tel; private Department departm...
复制链接

扫一扫

专栏目录