jpa 多对多关系的实现注解形式

2022-10-28 17:40:49

1，表结构

　　1）设备表 VTM_DEVICE_INFO

create table VTM_DEVICE_INFO
(
  ID                 INTEGER not null,
  SN                 ) not null,
  STATUS             INTEGER,
  MEMO               ),
  DEVICE_NO          INTEGER,
  START_TIME         ),
  END_TIME           ),
  FACTORY            INTEGER,
  DEVICE_IN_DATE     ),
  ISAFEDOOR_POSITION INTEGER,
  AUDIT_FLAG         )
);
alter table VTM_DEVICE_INFO
  add constraint PK_VTM_DEVICE_INFO primary key (ID);

　　2）模块表 VTM_MODULE_DEFINE

create table VTM_MODULE_DEFINE
(
  ID          INTEGER not null,
  MODULE_NAME ) not null
);
alter table VTM_MODULE_DEFINE
  add constraint PK_VTM_MODULE_DEFINE primary key (ID);

　　3）设备模块关系表 VTM_DEVICE_MODULE

create table VTM_DEVICE_MODULE
(
  DEVICE_ID INTEGER not null,
  MODULE_ID INTEGER not null
)
;
alter table VTM_DEVICE_MODULE
  add constraint FK_VTM_DEVI_REF_DEVIC_VTM_DEVI foreign key (DEVICE_ID)
  references VTM_DEVICE_INFO (ID);
alter table VTM_DEVICE_MODULE
  add constraint FK_VTM_DEVI_REF_DEVIC_VTM_MODU foreign key (MODULE_ID)
  references VTM_MODULE_DEFINE (ID);

　　4）初始化模块表数据

, '读卡器');
, '密码键盘');
, '取款模块');
, '存款模块');

　　5）数据库中要到的序列

create sequence DEVICE_INFO_SEQ
minvalue
maxvalue
start
increment
cache ;

create sequence DEVICE_MODULE_SEQ
minvalue
maxvalue
start
increment
cache ;

　　设备表与模块表之间是多对多的关系，关系表为设备模块表

2，实体类采用注解的形式，体现他们之间的关系

package opstools.vtm.device.entity;

import java.io.Serializable;
import java.util.Date;
import java.util.Set;

import javax.persistence.CascadeType;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.JoinColumn;
import javax.persistence.JoinTable;
import javax.persistence.ManyToMany;
import javax.persistence.ManyToOne;
import javax.persistence.SequenceGenerator;
import javax.persistence.Table;
import javax.persistence.Temporal;
import javax.persistence.TemporalType;/**
 * 设备实体类
 * @author yangw
 */
@Entity
@Table(name = "VTM_DEVICE_INFO")
@SequenceGenerator(name = "deviceInfoSeq", sequenceName = "DEVICE_INFO_SEQ")
public class DeviceInfo implements Serializable {

    private static final long serialVersionUID = -6964820074623402896L;

    @Id
    @Column(name="ID")
    @GeneratedValue(strategy = GenerationType.SEQUENCE, generator = "deviceInfoSeq")
    private Integer deviceId;          //设备Id

    @Column
    private String sn;                 //序号
    @Column
    private Integer status;          //设备使用状态

    @Column
    private Integer branchId;

    @Column
    private String memo;             //备注信息
    @Column
    private Integer deviceNo;        //设备型号

    @Temporal(TemporalType.TIMESTAMP)
    @Column
    private Date startTime;         //开始使用时间
    @Temporal(TemporalType.TIMESTAMP)
    @Column
    private Date endTime;            //设备终止时间
    @Column
    private Integer factory;        //设备厂商
    @Temporal(TemporalType.TIMESTAMP)
    @Column
    private Date deviceInDate;        //设备增加时间
    @Column
    private Integer isafedoorPosition;    //开门方向
    @Column
    private Integer auditFlag;        //审核标志

    @ManyToMany(cascade=CascadeType.PERSIST)
    @JoinTable(name = "VTM_DEVICE_MODULE", joinColumns = {@JoinColumn(name = "deviceId")},inverseJoinColumns=@JoinColumn(name="MODULE_ID"))
    private Set<ModuleDefine> moduleDefine;  

      //get set 省略
}

package opstools.vtm.device.entity;

import java.io.Serializable;
import java.util.Set;

import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.JoinColumn;
import javax.persistence.JoinTable;
import javax.persistence.ManyToMany;
import javax.persistence.SequenceGenerator;
import javax.persistence.Table;

/**
 * 设备模块表
 * @author yangw
 */
@Entity
@Table(name = "VTM_MODULE_DEFINE")
@SequenceGenerator(name = "moduleDefineSeq", sequenceName = "MODULE_DEFINE_SEQ")
public class ModuleDefine implements Serializable {

    private static final long serialVersionUID = 1L;

    @Id
    @Column(name="ID")
    @GeneratedValue(strategy = GenerationType.SEQUENCE, generator = "moduleDefineSeq")
    private Integer moduleId;          //模块Id

    @Column
    private String moduleName;         //模块名称

    @ManyToMany(mappedBy = "moduleDefine")
    private Set<DeviceInfo> deviceInfo;  

    //省略 get set 这个类可能不需要再写@ManyToMany来维护关系，因为这个表的数据是初始化好的，不需要修改， 具体没有测试.

}

3, dao层的实现，就是将设备添加到数据库

@Override
    public void createDeviceInfo(DeviceInfo deviceInfo) {
        super.create(deviceInfo);
    }

4，service层的实现，将模块信息设置到设备类的属性中.

@Override
    public void createDeviceInfo(DeviceInfo deviceInfo, Integer[] moduleIds) {
        if(moduleIds!=null){

            Set<ModuleDefine> defineSet=deviceInfo.getModuleDefine();
            if(defineSet==null){
                defineSet=new HashSet<ModuleDefine>();
            }
            for(int i=0;i<moduleIds.length;i++){
                ModuleDefine define=new ModuleDefine();
                define.setModuleId(moduleIds[i]);
                defineSet.add(define);
            }
            deviceInfo.setModuleDefine(defineSet);

        }

        deviceInfoDao.createDeviceInfo(deviceInfo);    

    }

5,action层的简单实现

    @Override
    public void submitPage(String pageName) throws Exception {

        deviceInfo.setStartTime(DateSupportUtils.str2second(startTime));
        deviceInfo.setEndTime(DateSupportUtils.str2second(endTime));

        if(pageName.equals(PAGE_CREATE)){
            deviceInfo.setDeviceInDate(new Date());
            deviceInfoService.createDeviceInfo(deviceInfo,moduleIds);
        }
        else if(pageName.equals(PAGE_UPDATE)){
            deviceInfoService.updateDeviceInfo(deviceInfo);
        }
    }

6，界面jsp页面，简单给大家看看.

<%@ page language="java" pageEncoding="UTF-8"%>
<%@ taglib prefix="s" uri="/struts-tags" %> 

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
    "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
    <head>
        <title>${pageTitle}</title>
        <s:include value="../../../include/page.jsp"/>
        <style type="shett"></style>
        <script type="text/javascript" >
        　　

//这里的代码是级联获取下拉框数据，省略掉，可以参考上一篇处理json的代码</script>
    </head>
    <body onload="Page.init('${pageError}','${pageMessage}',${isSubmit})">
        <div id="title">${pageTitle}</div>
        <s:form id="MYFORM" action="%{pageAction}" method="post" theme="simple">
        <input type="hidden" value="0" name="deviceInfo.status"/>
        <input type="hidden" value="0" name="deviceInfo.auditFlag"/>
        <div id="content">
            <table>

             //下面一种标签只列出来了一个
                <tr>
                    <th width="13%">开始使用时间:</th>
                    <td width="35%"><div>
                        <input name="startTime" value="<s:date name="deviceInfo.startTime" format="yyyy-MM-dd HH:mm:ss"/>" class="Wdate" onfocus="WdatePicker({isShowClear:false,dateFmt:'yyyy-MM-dd HH:mm:ss',readOnly:true})"/>
                    </div></td>

                </tr>
                <tr>

                    <th width="17%">设备厂商:</th>
                    <td width="35%"><s:select name="deviceInfo.factory" id="deviceFactory"
                            list="deviceFactoryList"
                            listKey="realValue"
                            listValue="displayValue"
                            headerKey=""
                            headerValue="请选择"/>
                        </td>

                </tr>
                <tr>
                    <th width="17%">模块:</th>
                    <td width="35%" >
                        <div>
                        <s:checkboxlist name="moduleIds" cssClass="checkbox"
                            list="moduleList"
                            listKey="realValue"
                            listValue="displayValue"
                            >

                        </s:checkboxlist>
                        </div>
                    </td>
                </tr>
                <tr>
                    <th width="13%">备注信息:</th>
                    <td width="35%" colspan="3" ><div>
                        <s:textarea name="deviceInfo.memo"  onblur="Check.checkLength(this,256)"/>
                    </div></td>
                </tr>
            </table>
        </div>
        <div id="operator">
            <div class="left"></div>
            <div class="middle" onclick="Page.submit()">提交</div>
            <div class="right"></div>
            <div class="left"></div>
            <div class="middle" onclick="Page.close()">关闭</div>
            <div class="right"></div>
        </div>
        </s:form>
    </body>
</html>

码农公寓

相关文章