Question

I am trying to insert the values from textfields in the database using hibernate and it doesn t work. For example I want to insert into the Product table, where I have the following columns: idproduct, idprovider, idcategory, name, quantity.

    Session session = HibernateUtil.getSessionFactory().openSession();
    org.hibernate.Transaction tx = session.beginTransaction();
    Product product = new Product();
    int idProduct = Integer.parseInt(IdProductTextField.getText());
    product.setIdproduct(idProduct);
    session.save(product);
    tx.commit();

这是唯一插入的列, 因为在设定方法中, 我有一个 int 参数。

但所有其他的栏目都行不通,问题就在这里:

我想在产品表格中插入的其他列的所有其他套用方法都以“类”变量作为参数。例如:

如果我想插入提供商, 设定的方法就是

public void setProduct(Product product) {
    this.product = product;
时 时

我真的不知道怎么用这个方法插入提供商。

我时间不多,如果有人能尽快帮助我,我将不胜感激。

我在此附上产品.java和提供者.java

package sakila.entity;

import java.util.HashSet;
import java.util.Set;

public class Product  implements java.io.Serializable {

 private int idproduct;
 private Istoricprod istoricprod;
 private Provider provider;
 private Category category;
 private String name;
 private Integer quantity;
 private String unitmas;
 private Set comdetals = new HashSet(0);
 private Set stocs = new HashSet(0);
 private Set bondetals = new HashSet(0);

public Product() {
时 时


public Product(int idproduct) {
    this.idproduct = idproduct;
时 时
public Product(int idproduct, Istoricprod istoricprod, Provider provider, Category category, String name, Integer quantity, String unitmas, Set comdetals, Set stocs, Set bondetals) {
   this.idproduct = idproduct;
   this.istoricprod = istoricprod;
   this.provider = provider;
   this.category = category;
   this.name = name;
   this.quantity = quantity;
   this.unitmas = unitmas;
   this.comdetals = comdetals;
   this.stocs = stocs;
   this.bondetals = bondetals;
时 时

public int getIdproduct() {
    return this.idproduct;
时 时

public void setIdproduct(int idproduct) {
    this.idproduct = idproduct;
时 时
public Istoricprod getIstoricprod() {
    return this.istoricprod;
时 时

public void setIstoricprod(Istoricprod istoricprod) {
    this.istoricprod = istoricprod;
时 时
public Provider getProvider() {
    return this.furnizor;
时 时

public void setProvider(Provider provider) {
    this.provider = provider;
时 时
public Category getCategory() {
    return this.category;
时 时

public void setCategory(Category category) {
    this.category = category;
时 时

public String getName() {
    return this.name;
时 时

public void setName(String name) {
    this.name = name;
时 时
public Integer getQuantity() {
    return this.quantity;
时 时

public void setQuantitaty(Integer quantity) {
    this.quantity = quantity;
时 时
public String getUnitmas() {
    return this.unitmas;
时 时

public void setUnitmas(String unitmas) {
    this.unitmas = unitmas;
时 时
public Set getComdetals() {
    return this.comdetals;
时 时

public void setComdetals(Set comdetals) {
    this.comdetals = comdetals;
时 时
public Set getStocs() {
    return this.stocs;
时 时

public void setStocs(Set stocs) {
    this.stocs = stocs;
时 时
public Set getBondetals() {
    return this.bondetals;
时 时

public void setBondetals(Set bondetals) {
    this.bondetals = bondetals;
时 时

时时

提供者贾瓦

package sakila.entity;

/ 2012年4月9日 10:19:40 下午由休眠工具3.2.1.GA制作

import java.util.HashSet;
import java.util.Set;


public class Provider  implements java.io.Serializable {


 private int idprovider;
 private String denumire;
 private Integer codfiscal;
 private Integer nrfirma;
 private String stradadom;
 private Integer numardom;
 private String orasdom;
 private String judetdom;
 private Integer telefon;
 private Integer codiban;
 private String banca;
 private Set produses = new HashSet(0);
 private Set chitantas = new HashSet(0);
 private Set comandas = new HashSet(0);
 private Set facturas = new HashSet(0);

public Provider() {
时 时


public Provider(int idprovider) {
    this.idprovider = idprovider;
时 时
public Provider(int idprovider, String denumire, Integer codfiscal, Integer nrfirma, String stradadom, Integer numardom, String orasdom, String judetdom, Integer telefon, Integer codiban, String banca, Set produses, Set chitantas, Set comandas, Set facturas) {
   this.idprovider = idprovider;
   this.denumire = denumire;
   this.codfiscal = codfiscal;
   this.nrfirma = nrfirma;
   this.stradadom = stradadom;
   this.numardom = numardom;
   this.orasdom = orasdom;
   this.judetdom = judetdom;
   this.telefon = telefon;
   this.codiban = codiban;
   this.banca = banca;
   this.produses = produses;
   this.chitantas = chitantas;
   this.comandas = comandas;
   this.facturas = facturas;
时 时

public int getIdprovider() {
    return this.idprovider;
时 时

public void setIdprovider(int idprovider) {
    this.idprovider = idprovider;
时 时
public String getDenumire() {
    return this.denumire;
时 时

public void setDenumire(String denumire) {
    this.denumire = denumire;
时 时
public Integer getCodfiscal() {
    return this.codfiscal;
时 时

public void setCodfiscal(Integer codfiscal) {
    this.codfiscal = codfiscal;
时 时
public Integer getNrfirma() {
    return this.nrfirma;
时 时

public void setNrfirma(Integer nrfirma) {
    this.nrfirma = nrfirma;
时 时
public String getStradadom() {
    return this.stradadom;
时 时

public void setStradadom(String stradadom) {
    this.stradadom = stradadom;
时 时
public Integer getNumardom() {
    return this.numardom;
时 时

public void setNumardom(Integer numardom) {
    this.numardom = numardom;
时 时
public String getOrasdom() {
    return this.orasdom;
时 时

public void setOrasdom(String orasdom) {
    this.orasdom = orasdom;
时 时
public String getJudetdom() {
    return this.judetdom;
时 时

public void setJudetdom(String judetdom) {
    this.judetdom = judetdom;
时 时
public Integer getTelefon() {
    return this.telefon;
时 时

public void setTelefon(Integer telefon) {
    this.telefon = telefon;
时 时
public Integer getCodiban() {
    return this.codiban;
时 时

public void setCodiban(Integer codiban) {
    this.codiban = codiban;
时 时
public String getBanca() {
    return this.banca;
时 时

public void setBanca(String banca) {
    this.banca = banca;
时 时
public Set getProduses() {
    return this.produses;
时 时

public void setProduses(Set produses) {
    this.produses = produses;
时 时
public Set getChitantas() {
    return this.chitantas;
时 时

public void setChitantas(Set chitantas) {
    this.chitantas = chitantas;
时 时
public Set getComandas() {
    return this.comandas;
时 时

public void setComandas(Set comandas) {
    this.comandas = comandas;
时 时
public Set getFacturas() {
    return this.facturas;
时 时

public void setFacturas(Set facturas) {
    this.facturas = facturas;
时 时

时时

Answer 1

以提供者为例。如果您有现有提供者的提供者代号,您可以这样做

load the provider with the id first
set the provider into the product
save the product

示例( 不完整)

Provider provider = session.load(provider, idProvider);
product.setProvider(provider);
session.save(product);

如果您不想先装入提供者( 可能是多余的数据库访问), 那么您可以完成

Provider provider = new Provider(idProvider);
product.setProvider(provider);
session.save(product);

在此情况下, 请在映射文件中确保 cascade 设置为 noone ; 如果没有的话, 将会创建一个新的提供者( 如果您也想要创建新的提供者, 请设定 < code> cascade=all )。

第三种可能性是,在产品中,您不放一个提供者对象,而只放一个提供者的代号,并将其标为简单的整数。 (您甚至可以同时放一个单独的id和提供者的对象,但这有点棘手,一般不推荐。 )

Answer 2

要明确这一点,您在产品及其提供者之间存在许多对一的联系。当您插入产品时,您希望它与现有提供者连接。所以您得到了拥有给定身份的提供者,并将这个提供者附加在产品上:

Provider provider = (Provider) session.load(Provider.class, idOfTheProvider);
product.setProvider(provider);
session.save(product);

协会的情况也是如此。

友情链接