package holdem;

import java.io.Serializable;
import javax.persistence.Basic;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.Id;
import javax.persistence.Lob;
import javax.persistence.NamedQueries;
import javax.persistence.NamedQuery;
import javax.persistence.Table;
import javax.xml.bind.annotation.XmlRootElement;

/**
*
* @author Sune Utoft Jensen
*/
@Entity
@Table(name = "GTSPILLER")
@XmlRootElement
@NamedQueries({
   @NamedQuery(name = "Gtspiller.findAll", query = "SELECT g FROM Gtspiller g"),
   @NamedQuery(name = "Gtspiller.findByIdnummer", query = "SELECT g FROM Gtspiller g WHERE g.idnummer = :idnummer"),
   @NamedQuery(name = "Gtspiller.findByNavn", query = "SELECT g FROM Gtspiller g WHERE g.navn = :navn"),
   @NamedQuery(name = "Gtspiller.findByRoll", query = "SELECT g FROM Gtspiller g WHERE g.roll = :roll"),
   @NamedQuery(name = "Gtspiller.findByStrategi", query = "SELECT g FROM Gtspiller g WHERE g.strategi = :strategi"),
   @NamedQuery(name = "Gtspiller.findByStack", query = "SELECT g FROM Gtspiller g WHERE g.stack = :stack")})
public class Gtspiller implements Serializable {
   private static final long serialVersionUID = 1L;
   @Id
   @Basic(optional = false)
   @Column(name = "IDNUMMER")
   private Integer idnummer;
   @Column(name = "NAVN")
   private String navn;
   // @Max(value=?)  @Min(value=?)//if you know range of your decimal fields consider using these annotations to enforce field validation
   @Column(name = "ROLL")
   private Double roll;
   @Lob
   @Column(name = "BILLEDE")
   private Serializable billede;
   @Column(name = "STRATEGI")
   private Integer strategi;
   @Column(name = "STACK")
   private Double stack;

   public Gtspiller() {
   }

   public Gtspiller(Integer idnummer) {
       this.idnummer = idnummer;
   }

   public Integer getIdnummer() {
       return idnummer;
   }

   public void setIdnummer(Integer idnummer) {
       this.idnummer = idnummer;
   }

   public String getNavn() {
       return navn;
   }

   public void setNavn(String navn) {
       this.navn = navn;
   }

   public Double getRoll() {
       return roll;
   }

   public void setRoll(Double roll) {
       this.roll = roll;
   }

   public Serializable getBillede() {
       return billede;
   }

   public void setBillede(Serializable billede) {
       this.billede = billede;
   }

   public Integer getStrategi() {
       return strategi;
   }

   public void setStrategi(Integer strategi) {
       this.strategi = strategi;
   }

   public Double getStack() {
       return stack;
   }

   public void setStack(Double stack) {
       this.stack = stack;
   }

   @Override
   public int hashCode() {
       int hash = 0;
       hash += (idnummer != null ? idnummer.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 Gtspiller)) {
           return false;
       }
       Gtspiller other = (Gtspiller) object;
       if ((this.idnummer == null && other.idnummer != null) || (this.idnummer != null && !this.idnummer.equals(other.idnummer))) {
           return false;
       }
       return true;
   }

   @Override
   public String toString() {
       return "holdem.Gtspiller[ idnummer=" + idnummer + " ]";
   }
   
}

package holdem;

import holdem.exceptions.NonexistentEntityException;
import holdem.exceptions.PreexistingEntityException;
import java.io.Serializable;
import java.util.List;
import javax.persistence.EntityManager;
import javax.persistence.EntityManagerFactory;
import javax.persistence.Query;
import javax.persistence.EntityNotFoundException;
import javax.persistence.criteria.CriteriaQuery;
import javax.persistence.criteria.Root;

/**
*
* @author Sune Utoft Jensen
*/
public class GtspillerJpaController implements Serializable {

   public GtspillerJpaController(EntityManagerFactory emf) {
       this.emf = emf;
   }
   private EntityManagerFactory emf = null;

   public EntityManager getEntityManager() {
       return emf.createEntityManager();
   }

   public void create(Gtspiller gtspiller) throws PreexistingEntityException, Exception {
       EntityManager em = null;
       try {
           em = getEntityManager();
           em.getTransaction().begin();
           em.persist(gtspiller);
           em.getTransaction().commit();
       } catch (Exception ex) {
           if (findGtspiller(gtspiller.getIdnummer()) != null) {
               throw new PreexistingEntityException("Gtspiller " + gtspiller + " already exists.", ex);
           }
           throw ex;
       } finally {
           if (em != null) {
               em.close();
           }
       }
   }

   public void edit(Gtspiller gtspiller) throws NonexistentEntityException, Exception {
       EntityManager em = null;
       try {
           em = getEntityManager();
           em.getTransaction().begin();
           gtspiller = em.merge(gtspiller);
           em.getTransaction().commit();
       } catch (Exception ex) {
           String msg = ex.getLocalizedMessage();
           if (msg == null || msg.length() == 0) {
               Integer id = gtspiller.getIdnummer();
               if (findGtspiller(id) == null) {
                   throw new NonexistentEntityException("The gtspiller with id " + id + " no longer exists.");
               }
           }
           throw ex;
       } finally {
           if (em != null) {
               em.close();
           }
       }
   }

   public void destroy(Integer id) throws NonexistentEntityException {
       EntityManager em = null;
       try {
           em = getEntityManager();
           em.getTransaction().begin();
           Gtspiller gtspiller;
           try {
               gtspiller = em.getReference(Gtspiller.class, id);
               gtspiller.getIdnummer();
           } catch (EntityNotFoundException enfe) {
               throw new NonexistentEntityException("The gtspiller with id " + id + " no longer exists.", enfe);
           }
           em.remove(gtspiller);
           em.getTransaction().commit();
       } finally {
           if (em != null) {
               em.close();
           }
       }
   }

   public List<Gtspiller> findGtspillerEntities() {
       return findGtspillerEntities(true, -1, -1);
   }

   public List<Gtspiller> findGtspillerEntities(int maxResults, int firstResult) {
       return findGtspillerEntities(false, maxResults, firstResult);
   }

   private List<Gtspiller> findGtspillerEntities(boolean all, int maxResults, int firstResult) {
       EntityManager em = getEntityManager();
       try {
           CriteriaQuery cq = em.getCriteriaBuilder().createQuery();
           cq.select(cq.from(Gtspiller.class));
           Query q = em.createQuery(cq);
           if (!all) {
               q.setMaxResults(maxResults);
               q.setFirstResult(firstResult);
           }
           return q.getResultList();
       } finally {
           em.close();
       }
   }

   public Gtspiller findGtspiller(Integer id) {
       EntityManager em = getEntityManager();
       try {
           return em.find(Gtspiller.class, id);
       } finally {
           em.close();
       }
   }

   public int getGtspillerCount() {
       EntityManager em = getEntityManager();
       try {
           CriteriaQuery cq = em.getCriteriaBuilder().createQuery();
           Root<Gtspiller> rt = cq.from(Gtspiller.class);
           cq.select(em.getCriteriaBuilder().count(rt));
           Query q = em.createQuery(cq);
           return ((Long) q.getSingleResult()).intValue();
       } finally {
           em.close();
       }
   }
   
}

      public void savepic(String a, int b) throws IOException//a navn og b sæde
      {
         
  EntityManagerFactory  factory = Persistence.createEntityManagerFactory("Contact DB");
  EntityManager em = factory.createEntityManager();
  em.getTransaction().begin();
          Gtspiller dyr = em.find(Gtspiller.class, b);    
  File fi = new File("D:\\portræt\\"+a+".gif");
 byte[] content = new byte[(int)fi.length()];
  dyr.setBillede(content);
  updatebillede(1,content);
     em.getTransaction().commit();
  em.close();
 
      }

File fi = new File( "yourimage.gif" );
   BufferedImage bufferedImage = ImageIO.read( fi );

   WritableRaster raster = bufferedImage.getRaster( );
   DataBufferByte data = (DataBufferByte) raster.getDataBuffer( );

   //Store base64 encoded bytes (returns string) in database
   Base64.encodeBytes( data.getData( ) );