Boa tarde pessoal,
Eu tenho 2 tabelas Farmacia e Farmaceutico.
Tabela Farmaceutico possui o codigo da farmacia(Chave Estrangeira)
Na tela de cadastro de Farmaceutico eu possuo um combo que exibe as farmacias cadastradas.
Mas quando eu vou dar o insert na tabela. O que eu devo pegar do combo???
/*
* To change this template, choose Tools | Templates
* and open the template in the editor.
*/
package br.com.rme.entity;
import java.io.Serializable;
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;
/**
*
* @author Allan Furlani
*/
@Entity
@Table(name = "farmaceutico", catalog = "jsf", schema = "")
@NamedQueries({
@NamedQuery(name = "Farmaceutico.findAll", query = "SELECT f FROM Farmaceutico f"),
@NamedQuery(name = "Farmaceutico.findByCodFarmaceutico", query = "SELECT f FROM Farmaceutico f WHERE f.codFarmaceutico = :codFarmaceutico"),
@NamedQuery(name = "Farmaceutico.findByCpfFarmaceutico", query = "SELECT f FROM Farmaceutico f WHERE f.cpfFarmaceutico = :cpfFarmaceutico"),
@NamedQuery(name = "Farmaceutico.findByNomeFarmaceutico", query = "SELECT f FROM Farmaceutico f WHERE f.nomeFarmaceutico = :nomeFarmaceutico"),
@NamedQuery(name = "Farmaceutico.findByStatusFarmaceutico", query = "SELECT f FROM Farmaceutico f WHERE f.statusFarmaceutico = :statusFarmaceutico"),
@NamedQuery(name = "Farmaceutico.findBySenhaFarmaceutico", query = "SELECT f FROM Farmaceutico f WHERE f.senhaFarmaceutico = :senhaFarmaceutico"),
@NamedQuery(name = "Farmaceutico.findByLoginFarmaceutico", query = "SELECT f FROM Farmaceutico f WHERE f.loginFarmaceutico = :loginFarmaceutico")})
public class Farmaceutico implements Serializable {
private static final long serialVersionUID = 1L;
@Id
@GeneratedValue(strategy = GenerationType.IDENTITY)
@Basic(optional = false)
@Column(name = "cod_farmaceutico", nullable = false)
private Integer codFarmaceutico;
@Column(name = "cpf_farmaceutico", length = 14)
private String cpfFarmaceutico;
@Column(name = "nome_farmaceutico", length = 50)
private String nomeFarmaceutico;
@Column(name = "status_farmaceutico")
private Integer statusFarmaceutico;
@Column(name = "senha_farmaceutico", length = 8)
private String senhaFarmaceutico;
@Column(name = "login_farmaceutico", length = 20)
private String loginFarmaceutico;
@JoinColumn(name = "cod_farmacia", referencedColumnName = "cod_farmacia")
@ManyToOne
private Farmacia codFarmacia;
@JoinColumn(name = "cod_cargo", referencedColumnName = "cod_cargo")
@ManyToOne
private Cargo cargo;
public Farmaceutico() {
}
public Farmaceutico(Integer codFarmaceutico) {
this.codFarmaceutico = codFarmaceutico;
}
public Integer getCodFarmaceutico() {
return codFarmaceutico;
}
public void setCodFarmaceutico(Integer codFarmaceutico) {
this.codFarmaceutico = codFarmaceutico;
}
public String getCpfFarmaceutico() {
return cpfFarmaceutico;
}
public void setCpfFarmaceutico(String cpfFarmaceutico) {
this.cpfFarmaceutico = cpfFarmaceutico;
}
public String getNomeFarmaceutico() {
return nomeFarmaceutico;
}
public void setNomeFarmaceutico(String nomeFarmaceutico) {
this.nomeFarmaceutico = nomeFarmaceutico;
}
public Integer getStatusFarmaceutico() {
return statusFarmaceutico;
}
public void setStatusFarmaceutico(Integer statusFarmaceutico) {
this.statusFarmaceutico = statusFarmaceutico;
}
public String getSenhaFarmaceutico() {
return senhaFarmaceutico;
}
public void setSenhaFarmaceutico(String senhaFarmaceutico) {
this.senhaFarmaceutico = senhaFarmaceutico;
}
public String getLoginFarmaceutico() {
return loginFarmaceutico;
}
public void setLoginFarmaceutico(String loginFarmaceutico) {
this.loginFarmaceutico = loginFarmaceutico;
}
public Farmacia getCodFarmacia() {
return codFarmacia;
}
public void setCodFarmacia(Farmacia codFarmacia) {
this.codFarmacia = codFarmacia;
}
public Cargo getCargo() {
return cargo;
}
public void setCargo(Cargo codCargo) {
this.cargo = codCargo;
}
@Override
public int hashCode() {
int hash = 0;
hash += (codFarmaceutico != null ? codFarmaceutico.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 Farmaceutico)) {
return false;
}
Farmaceutico other = (Farmaceutico) object;
if ((this.codFarmaceutico == null && other.codFarmaceutico != null) || (this.codFarmaceutico != null && !this.codFarmaceutico.equals(other.codFarmaceutico))) {
return false;
}
return true;
}
@Override
public String toString() {
return "br.com.rme.entity.Farmaceutico[codFarmaceutico=" + codFarmaceutico + "]";
}
}
public void adicionaFarmacia(Farmacia farmacia){
Session sessao = HibernateUtil.getSession();
Transaction trans = sessao.beginTransaction();
sessao.save(farmacia);
trans.commit();
sessao.close();
}
private void btnCadastrarActionPerformed(java.awt.event.ActionEvent evt) {
try{
farmaceutico.setCodFarmaceutico(0);
farmaceutico.setNomeFarmaceutico(txtNome.getText());
farmaceutico.setCpfFarmaceutico(maskCPF.getText());
farmaceutico.setStatusFarmaceutico(1);
farmaceutico.setCodFarmacia(?????? o que eu passo aqui ??????);
farmaceutico.setLoginFarmaceutico("teste");
farmaceuticoCMD.adicionaFarmaceutico(farmaceutico);
JOptionPane.showMessageDialog(null, "Cadastro Efetuado com sucesso!", "RM(e)", JOptionPane.INFORMATION_MESSAGE);
}catch(HibernateException he){
he.printStackTrace();
}
}
