CREATE TABLE container.ac_container
    (
    id serial NOT NULL,
    ser_number character varying(100) NOT NULL, -- серийный номер
    manufacture_id integer NOT NULL, -- производитель
    mass_passp integer, -- масса по паспорту
    mass_fact integer, -- фактическая масса
    volume_passp integer,
    reg_number character varying(50),
    d_fabric date,
    d_from date,
    d_to date,
    d_control date,
    CONSTRAINT container_pkey PRIMARY KEY (id ),
    CONSTRAINT manufacture1 FOREIGN KEY (manufacture_id)
    REFERENCES container.ac_manufacture (id) MATCH SIMPLE
    ON UPDATE CASCADE ON DELETE RESTRICT,
    CONSTRAINT ser_reg_number UNIQUE (ser_number , reg_number )
    )

package entity.spr;
 
import java.io.Serializable;
import java.util.Date;
import javax.persistence.Basic;
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.ManyToOne;
import javax.persistence.NamedQueries;
import javax.persistence.NamedQuery;
import javax.persistence.Table;
import javax.persistence.Temporal;
import javax.persistence.TemporalType;
import javax.validation.constraints.NotNull;
import javax.validation.constraints.Size;
import javax.xml.bind.annotation.XmlRootElement;
 
/**
*
* @author jane
*/
@Entity
@Table(name = "ac_container")
@XmlRootElement
@NamedQueries({
@NamedQuery(name = "AcContainer.findAll", query = "SELECT a FROM AcContainer a")
})
public class AcContainer implements Serializable {
private static final long serialVersionUID = 1L;
@Id
@GeneratedValue(strategy = GenerationType.IDENTITY)
@Basic(optional = false)
@Column(name = "id")
private Integer id;
@Basic(optional = false)
@NotNull
@Size(min = 1, max = 100)
@Column(name = "ser_number")
private String serNumber;
@Column(name = "mass_passp")
private Integer massPassp;
@Column(name = "mass_fact")
private Integer massFact;
@Column(name = "volume_passp")
private Integer volumePassp;
@Size(max = 50)
@Column(name = "reg_number")
private String regNumber;
@Column(name = "d_fabric",nullable=true)
@Temporal(TemporalType.DATE)
private Date dFabric;
@Column(name = "d_from",nullable=true)
@Temporal(TemporalType.DATE)
private Date dFrom;
@Column(name = "d_to",nullable=true)
@Temporal(TemporalType.DATE)
private Date dTo;
@Column(name = "d_control",nullable=true)
@Temporal(TemporalType.DATE)
private Date dControl;
@JoinColumn(name = "manufacture_id", referencedColumnName = "id")
@ManyToOne(optional = false)
private AcManufacture manufactureId;
 
public AcContainer() {
}
 
public AcContainer(Integer id) {
this.id = id;
}
 
public AcContainer(Integer id, String serNumber) {
this.id = id;
this.serNumber = serNumber;
}
 
public Integer getId() {
return id;
}
 
public void setId(Integer id) {
this.id = id;
}
 
public String getSerNumber() {
return serNumber;
}
 
public void setSerNumber(String serNumber) {
this.serNumber = serNumber;
}
 
public Integer getMassPassp() {
return massPassp;
}
 
public void setMassPassp(Integer massPassp) {
this.massPassp = massPassp;
}
 
public Integer getMassFact() {
return massFact;
}
 
public void setMassFact(Integer massFact) {
this.massFact = massFact;
}
 
public Integer getVolumePassp() {
return volumePassp;
}
 
public void setVolumePassp(Integer volumePassp) {
this.volumePassp = volumePassp;
}
 
public String getRegNumber() {
return regNumber;
}
 
public void setRegNumber(String regNumber) {
this.regNumber = regNumber;
}
 
public Date getDFabric() {
return dFabric;
}
 
public void setDFabric(Date dFabric) {
this.dFabric = dFabric;
}
 
public Date getDFrom() {
return dFrom;
}
 
public void setDFrom(Date dFrom) {
this.dFrom = dFrom;
}
 
public Date getDTo() {
return dTo;
}
 
public void setDTo(Date dTo) {
this.dTo = dTo;
// this.dTo = null == dTo? null : dTo;
}
 
public Date getDControl() {
return dControl;
}
 
public void setDControl(Date dControl) {
this.dControl = dControl;
}
 
public AcManufacture getManufactureId() {
return manufactureId;
}
 
public void setManufactureId(AcManufacture manufactureId) {
this.manufactureId = manufactureId;
}
 
@Override
public int hashCode() {
int hash = 0;
hash += (id != null ? id.hashCode() : 0);
return hash;
}
 
@Override
public boolean equals(Object object) {
// TODO: Warning - this method won't work in the case the id fields are not set
if (!(object instanceof AcContainer)) {
return false;
}
AcContainer other = (AcContainer) object;
if ((this.id == null && other.id != null) || (this.id != null && !this.id.equals(other.id))) {
return false;
}
return true;
}
 
@Override
public String toString() {
return "entity.spr.AcContainer[ id=" + id + " ]";
}
}

    package session.spr;
     
    import entity.spr.AcContainer;
    import entity.spr.AcManufacture;
    import java.util.List;
    import javax.ejb.Stateless;
    import javax.persistence.EntityManager;
    import javax.persistence.PersistenceContext;
     
    /**
    *
    * @author jane
    */
    @Stateless
    public class AcContainerFacade extends AbstractFacade<AcContainer> {
     
    @PersistenceContext(unitName = "containerPU")
    private EntityManager em;
     
    @Override
    protected EntityManager getEntityManager() {
    return em;
    }
     
    public AcContainerFacade() {
    super(AcContainer.class);
    }
     
    public void addContainer(AcContainer c) {
    em.persist(c);
    }
    }

    package spr;
     
    import entity.spr.AcContainer;
    import entity.spr.AcManufacture;
    import java.io.IOException;
    import java.io.PrintWriter;
    import java.text.DateFormat;
    import java.text.ParseException;
    import java.text.SimpleDateFormat;
    import java.util.Date;
    import java.util.logging.Level;
    import java.util.logging.Logger;
    import javax.ejb.EJB;
    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 session.spr.AcContainerFacade;
    import session.spr.AcManufactureFacade;
     
    /**
    *
    * @author jane
    */
    @WebServlet(name = "NewServlet", urlPatterns = {"/NewServlet"})
    public class NewServlet extends HttpServlet {
     
    @EJB
    private AcContainerFacade containerFacade;
    @EJB
    private AcManufactureFacade manufactureFacade;
     
    @Override
    protected void service(HttpServletRequest request, HttpServletResponse response)
    throws ServletException, IOException {
    response.setContentType("text/html;charset=UTF-8");
     
    try (PrintWriter out = response.getWriter()) {
     
    AcContainer c = new AcContainer();
    DateFormat DF = new SimpleDateFormat("yyyy-mm-dd");
    Date myDate = null;
    try {
    myDate = DF.parse("2014-01-01");
    } catch (ParseException ex) {
    Logger.getLogger(NewServlet.class.getName()).log(Level.SEVERE, null, ex);
    }
    c.setDControl(myDate);
    c.setDFabric(myDate);
    c.setDFrom(null);
    c.setDTo(null);
    String serNumber = request.getParameter("ser_number");
    c.setSerNumber(serNumber);
    AcManufacture m = manufactureFacade.findManufacture(3);
    c.setManufactureId(m);
    containerFacade.addContainer(c);
     
    }
     
    }
    }

 
 public void createContainer(AcContainer c) {
        String query = "INSERT INTO ac_container (d_control, d_fabric, d_from, d_to, mass_fact, mass_passp, reg_number, ser_number, volume_passp, manufacture_id) "
                + " VALUES (to_date(?, 'yyyy-mm-dd'),to_date(?, 'yyyy-mm-ddy'), to_date(?, 'yyyy-mm-dd'), to_date(?, 'yyyy-mm-dd'), ? :: Integer, ?:: Integer, ?:: Integer, ?, ?:: Integer, ?)";

        em.createNativeQuery(query)
                .setParameter(1, c.getDControl())
                .setParameter(2, c.getDFabric())
                .setParameter(3, c.getDFrom())
                .setParameter(4, c.getDTo())
                .setParameter(5, c.getMassFact())
                .setParameter(6, c.getMassPassp())
                .setParameter(7, c.getRegNumber())
                .setParameter(8, c.getSerNumber())
                .setParameter(9, c.getVolumePassp())
                .setParameter(10, c.getManufactureId().getId())
                .executeUpdate();
    }