|
hi,
thanks for your replay.
Maybe i don't catch some basic concepts, but i don't want the ESRITSOC be canceled when i delete ESRITBAN.
Thanks a lot.
here is my code:
package entities;
import java.io.Serializable;
import java.util.Date;
import java.util.List;
import javax.persistence.Basic;
import javax.persistence.CascadeType;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.FetchType;
import javax.persistence.Id;
import javax.persistence.NamedQueries;
import javax.persistence.NamedQuery;
import javax.persistence.OneToMany;
import javax.persistence.Table;
import javax.persistence.Temporal;
import javax.persistence.TemporalType;
/**
* ESSoc.java
*/
@Entity
@Table(name = "esritsoc")
@NamedQueries({
@NamedQuery(name = "ESSoc.findAll", query = "SELECT e FROM ESSoc e"),
@NamedQuery(name = "ESSoc.findByA2id", query = "SELECT e FROM ESSoc e WHERE e.a2id = :a2id"),
@NamedQuery(name = "ESSoc.findByA2deso", query = "SELECT e FROM ESSoc e WHERE e.a2deso = :a2deso")})
public class ESSoc implements Serializable {
private static final long serialVersionUID = 1L;
@Id
@Basic(optional = false)
@Column(name = "A2ID")
private Integer a2id;
@Basic(optional = false)
@Column(name = "A2DESO")
private String a2deso;
@Basic(optional = false)
@Column(name = "A2USIN")
private String a2usin;
@Basic(optional = false)
@Column(name = "A2DTIN")
@Temporal(TemporalType.TIMESTAMP)
private Date a2dtin;
@Column(name = "A2USVA")
private String a2usva;
@Basic(optional = false)
@Column(name = "A2DTVA")
@Temporal(TemporalType.TIMESTAMP)
private Date a2dtva;
@OneToMany(cascade = CascadeType.ALL, mappedBy = "a1idso", fetch = FetchType.EAGER)
private List<ESBank> eSBankList;
public ESSoc() {
}
public ESSoc(Integer a2id) {
this.a2id = a2id;
}
public ESSoc(Integer a2id, String a2deso, String a2usin, Date a2dtin, Date a2dtva) {
this.a2id = a2id;
this.a2deso = a2deso;
this.a2usin = a2usin;
this.a2dtin = a2dtin;
this.a2dtva = a2dtva;
}
public Integer getA2id() {
return a2id;
}
public void setA2id(Integer a2id) {
this.a2id = a2id;
}
public String getA2deso() {
return a2deso;
}
public void setA2deso(String a2deso) {
this.a2deso = a2deso;
}
public String getA2usin() {
return a2usin;
}
public void setA2usin(String a2usin) {
this.a2usin = a2usin;
}
public Date getA2dtin() {
return a2dtin;
}
public void setA2dtin(Date a2dtin) {
this.a2dtin = a2dtin;
}
public String getA2usva() {
return a2usva;
}
public void setA2usva(String a2usva) {
this.a2usva = a2usva;
}
public Date getA2dtva() {
return a2dtva;
}
public void setA2dtva(Date a2dtva) {
this.a2dtva = a2dtva;
}
public List<ESBank> getESBankList() {
return eSBankList;
}
public void setESBankList(List<ESBank> eSBankList) {
this.eSBankList = eSBankList;
}
@Override
public int hashCode() {
int hash = 0;
hash += (a2id != null ? a2id.hashCode() : 0);
return hash;
}
@Override
public boolean equals(Object object) {
if (!(object instanceof ESSoc)) {
return false;
}
ESSoc other = (ESSoc) object;
if ((this.a2id == null && other.a2id != null) || (this.a2id != null && !this.a2id.equals(other.a2id))) {
return false;
}
return true;
}
@Override
public String toString() {
return a2id + " - " + a2deso;
}
}
package entities;
import java.io.Serializable;
import java.util.Date;
import javax.persistence.Basic;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.FetchType;
import javax.persistence.Id;
import javax.persistence.JoinColumn;
import javax.persistence.ManyToOne;
import javax.persistence.NamedQueries;
import javax.persistence.NamedQuery;
import javax.persistence.Table;
import javax.persistence.Temporal;
import javax.persistence.TemporalType;
/**
* ESBank.java
*
*/
@Entity
@Table(name = "esritban")
@NamedQueries({
@NamedQuery(name = "ESBank.findAll", query = "SELECT e FROM ESBank e"),
@NamedQuery(name = "ESBank.findByA1id", query = "SELECT e FROM ESBank e WHERE e.a1id = :a1id"),
@NamedQuery(name = "ESBank.findByA1deba", query = "SELECT e FROM ESBank e WHERE e.a1deba = :a1deba")})
public class ESBank implements Serializable {
private static final long serialVersionUID = 1L;
@Id
@Basic(optional = false)
@Column(name = "A1ID")
private Integer a1id;
@Basic(optional = false)
@Column(name = "A1USER")
private String a1user;
@Basic(optional = false)
@Column(name = "A1DEBA")
private String a1deba;
@Column(name = "A1PCMO")
private String a1pcmo;
@Column(name = "A1PCIM")
private String a1pcim;
@Column(name = "A1PCZI")
private String a1pczi;
@Column(name = "A1CLCI")
private String a1clci;
@Column(name = "A1CLCR")
private String a1clcr;
@Column(name = "A1CLCC")
private String a1clcc;
@Column(name = "A1CLCA")
private String a1clca;
@Column(name = "A1PTMO")
private String a1ptmo;
@Column(name = "A1PTIM")
private String a1ptim;
@Column(name = "A1PTZI")
private String a1ptzi;
@Column(name = "A1CLTI")
private String a1clti;
@Column(name = "A1CLTR")
private String a1cltr;
@Column(name = "A1CLTC")
private String a1cltc;
@Column(name = "A1CLTA")
private String a1clta;
@Basic(optional = false)
@Column(name = "A1USIN")
private String a1usin;
@Basic(optional = false)
@Column(name = "A1DTIN")
@Temporal(TemporalType.TIMESTAMP)
private Date a1dtin;
@Column(name = "A1USVA")
private String a1usva;
@Basic(optional = false)
@Column(name = "A1DTVA")
@Temporal(TemporalType.TIMESTAMP)
private Date a1dtva;
@JoinColumn(name = "A1IDSO", referencedColumnName = "A2ID")
@ManyToOne(optional = false, fetch = FetchType.EAGER)
private ESSoc a1idso;
public ESBank() {
}
public ESBank(Integer a1id) {
this.a1id = a1id;
}
public ESBank(Integer a1id, String a1user, String a1deba, String a1usin, Date a1dtin, Date a1dtva) {
this.a1id = a1id;
this.a1user = a1user;
this.a1deba = a1deba;
this.a1usin = a1usin;
this.a1dtin = a1dtin;
this.a1dtva = a1dtva;
}
public Integer getA1id() {
return a1id;
}
public void setA1id(Integer a1id) {
this.a1id = a1id;
}
public String getA1user() {
return a1user;
}
public void setA1user(String a1user) {
this.a1user = a1user;
}
public String getA1deba() {
return a1deba;
}
public void setA1deba(String a1deba) {
this.a1deba = a1deba;
}
public String getA1pcmo() {
return a1pcmo;
}
public void setA1pcmo(String a1pcmo) {
this.a1pcmo = a1pcmo;
}
public String getA1pcim() {
return a1pcim;
}
public void setA1pcim(String a1pcim) {
this.a1pcim = a1pcim;
}
public String getA1pczi() {
return a1pczi;
}
public void setA1pczi(String a1pczi) {
this.a1pczi = a1pczi;
}
public String getA1clci() {
return a1clci;
}
public void setA1clci(String a1clci) {
this.a1clci = a1clci;
}
public String getA1clcr() {
return a1clcr;
}
public void setA1clcr(String a1clcr) {
this.a1clcr = a1clcr;
}
public String getA1clcc() {
return a1clcc;
}
public void setA1clcc(String a1clcc) {
this.a1clcc = a1clcc;
}
public String getA1clca() {
return a1clca;
}
public void setA1clca(String a1clca) {
this.a1clca = a1clca;
}
public String getA1ptmo() {
return a1ptmo;
}
public void setA1ptmo(String a1ptmo) {
this.a1ptmo = a1ptmo;
}
public String getA1ptim() {
return a1ptim;
}
public void setA1ptim(String a1ptim) {
this.a1ptim = a1ptim;
}
public String getA1ptzi() {
return a1ptzi;
}
public void setA1ptzi(String a1ptzi) {
this.a1ptzi = a1ptzi;
}
public String getA1clti() {
return a1clti;
}
public void setA1clti(String a1clti) {
this.a1clti = a1clti;
}
public String getA1cltr() {
return a1cltr;
}
public void setA1cltr(String a1cltr) {
this.a1cltr = a1cltr;
}
public String getA1cltc() {
return a1cltc;
}
public void setA1cltc(String a1cltc) {
this.a1cltc = a1cltc;
}
public String getA1clta() {
return a1clta;
}
public void setA1clta(String a1clta) {
this.a1clta = a1clta;
}
public String getA1usin() {
return a1usin;
}
public void setA1usin(String a1usin) {
this.a1usin = a1usin;
}
public Date getA1dtin() {
return a1dtin;
}
public void setA1dtin(Date a1dtin) {
this.a1dtin = a1dtin;
}
public String getA1usva() {
return a1usva;
}
public void setA1usva(String a1usva) {
this.a1usva = a1usva;
}
public Date getA1dtva() {
return a1dtva;
}
public void setA1dtva(Date a1dtva) {
this.a1dtva = a1dtva;
}
public ESSoc getA1idso() {
return a1idso;
}
public void setA1idso(ESSoc a1idso) {
this.a1idso = a1idso;
}
public String getDescSoc() {
try {
return a1idso.getA2deso();
} catch (Throwable t) {
}
return "";
}
@Override
public int hashCode() {
int hash = 0;
hash += (a1id != null ? a1id.hashCode() : 0);
return hash;
}
@Override
public boolean equals(Object object) {
if (!(object instanceof ESBank)) {
return false;
}
ESBank other = (ESBank) object;
if ((this.a1id == null && other.a1id != null) || (this.a1id != null && !this.a1id.equals(other.a1id))) {
return false;
}
return true;
}
@Override
public String toString() {
return a1id + " - " + a1deba;
}
}
package jpa;
import entities.ESBank;
import java.util.List;
import javax.persistence.EntityManager;
import javax.persistence.EntityManagerFactory;
import javax.persistence.Persistence;
import javax.persistence.Query;
import javax.persistence.EntityNotFoundException;
import jpa.exceptions.NonexistentEntityException;
import jpa.exceptions.PreexistingEntityException;
import uty.ESMessageManager;
import entities.ESSoc;
/**
* ESBankController.java
*
*/
public class ESBankController {
public ESBankController() {
emf = Persistence.createEntityManagerFactory("EasyReconPU");
}
private EntityManagerFactory emf = null;
public EntityManager getEntityManager() {
return emf.createEntityManager();
}
public void create(ESBank ESBank) throws PreexistingEntityException, Exception {
EntityManager em = null;
try {
em = getEntityManager();
em.getTransaction().begin();
em.persist(ESBank);
em.getTransaction().commit();
} catch (Exception ex) {
if (findESBank(ESBank.getA1id()) != null) {
throw new PreexistingEntityException(
ESMessageManager.getMessage(
"errJpaDupBank",
new String[]{ESBank.toString()}).getSummary());
}
throw ex;
} finally {
if (em != null) {
em.close();
}
}
}
public void edit(ESBank ESBank) throws NonexistentEntityException, Exception {
EntityManager em = null;
try {
em = getEntityManager();
em.getTransaction().begin();
ESBank = em.merge(ESBank);
em.getTransaction().commit();
} catch (Exception ex) {
String msg = ex.getLocalizedMessage();
if (msg == null || msg.length() == 0) {
Integer id = ESBank.getA1id();
if (findESBank(id) == null) {
throw new NonexistentEntityException(
ESMessageManager.getMessage(
"errJpaNotFoundBank",
new String[]{Integer.toString(id)}).getSummary());
}
}
throw ex;
} finally {
if (em != null) {
em.close();
}
}
}
public void destroy(Integer id) throws NonexistentEntityException {
EntityManager em = null;
try {
em = getEntityManager();
em.getTransaction().begin();
ESBank ESBank;
try {
ESBank = em.getReference(ESBank.class, id);
ESBank.getA1id();
} catch (EntityNotFoundException enfe) {
throw new NonexistentEntityException(
ESMessageManager.getMessage(
"errJpaNotFoundBank",
new String[]{Integer.toString(id)}).getSummary(), enfe);
}
em.remove(ESBank);
em.getTransaction().commit();
} finally {
if (em != null) {
em.close();
}
}
}
public List<ESBank> findESBankEntities() {
return findESBankEntities(true, -1, -1);
}
public List<ESBank> findESBankEntities(int maxResults, int firstResult) {
return findESBankEntities(false, maxResults, firstResult);
}
private List<ESBank> findESBankEntities(boolean all, int maxResults, int firstResult) {
EntityManager em = getEntityManager();
try {
Query q = em.createQuery("select object(o) from ESBank as o");
if (!all) {
q.setMaxResults(maxResults);
q.setFirstResult(firstResult);
}
return q.getResultList();
} finally {
em.close();
}
}
public ESBank findESBank(Integer id) {
EntityManager em = getEntityManager();
try {
return em.find(ESBank.class, id);
} finally {
em.close();
}
}
public int getESBankCount() {
EntityManager em = getEntityManager();
try {
Query q = em.createQuery("select count(o) from ESBank as o");
return ((Long) q.getSingleResult()).intValue();
} finally {
em.close();
}
}
}
|
Login
FAQ
Search
