-->
These old forums are deprecated now and set to read-only. We are waiting for you on our new forums!
More modern, Discourse-based and with GitHub/Google/Twitter authentication built-in.

All times are UTC - 5 hours [ DST ]



Forum locked This topic is locked, you cannot edit posts or make further replies.  [ 1 post ] 
Author Message
 Post subject: CRUD Hibernate Strut2 2 tablet join
PostPosted: Sat Mar 28, 2015 12:14 pm 
Newbie

Joined: Sat Mar 28, 2015 10:29 am
Posts: 1
I 'm trying to make a crud in Strud2 with hibernate and I can not combine two tables. Can you help me
Table 1 is Trama



@Entity
@Table(name="trama", catalog="bd_1")

public class Trama implements java.io.Serializable {

private int traNoca; //Int
private int catNoca; //Enlace con categoria
private String tradat; //Dato sin importancia

public Trama() {}

public Trama(int traNoca, int catNoca, String tradat)
{this.traNoca = traNoca; this.catNoca = catNoca; this.tradat = tradat; }

@Id
@Column(name="tra_noca", nullable=false)
public int getTraNoca() {return this.traNoca;} ES
public void setTraNoca(int traNoca) {this.traNoca = traNoca; }

@Column(name="cat_noca", nullable=false)
public int getCatNoca() {return this.catNoca;}
public void setCatNoca(int catNoca) {this.catNoca = catNoca;}

@Column(name="tra_dat", nullable=false, length=45)
public String getTradat() {return this.tradat;}
public void setTradat(String tradat) { this.tradat = tradat; }
}


This is His mapping

<hibernate-mapping>
<class name="entidad.Trama" table="trama" catalog="bd_1">
<id name="TraNoca" type="int">
<column name="tra_noca" />
<generator class="assigned"></generator>
</id>
<property name="CatNoca" type="int">
<column name="cat_noca" />
</property>
<property name="Tradat" type="string">
<column name="cat_dat" length="50" />
</property>
</class>
</hibernate-mapping>

Categoria is 2 Table is which is the main

package entidad;

import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.Id;
import javax.persistence.Table;

@Entity
@Table(name = "trama", catalog = "bd_1" )

public class Categoria implements java.io.Serializable {

private int catNoca;
private String catNom;

public Categoria() {}

public Categoria(int catNoca, String catNom)
{this.catNoca = catNoca; this.catNom = catNom;}

@Id
@Column(name="cat_noca", nullable=false)
public int getCatNoca() {return this.catNoca;}
public void setCatNoca(int catNoca) {this.catNoca = catNoca;}

@Column(name="cat_nom", nullable=false, length=45)
public String getCatNom() {return this.catNom;}
public void setCatNom(String catNom) { this.catNom = catNom; }
}
This is His mapping

<hibernate-mapping>
<class name="entidad.Categoria" table="categoria" catalog="bd_1">
<id name="CatNoca" type="int">
<column name="cat_noca" />
<generator class="assigned"></generator>
</id>
<property name="CatNom" type="string">
<column name="cat_nom" length="50" />
</property>
</class>
</hibernate-mapping>
Strut2
Which sends the order

public void detalle2(String noca,T entity) {

Session session = HibernateUtil.getSessionFactory().openSession();
Transaction beginTransaction = session.beginTransaction();
session.createSQLQuery("select c.CatNoca, c.CatNom, t.CatNoca, t.TraNoca, t.CatNom, t.tradat from Trama t INNER JOIN Categoria c ON t.CatNoca="+entity);
beginTransaction.commit();
session.close();
}



package acciones;

import static com.opensymphony.xwork2.Action.INPUT;
import static com.opensymphony.xwork2.Action.SUCCESS;
import com.opensymphony.xwork2.ActionSupport;
import entidad.Categoria;
import java.util.List;
import servicio.ServicioCategoria;

public class CategoriaAction extends ActionSupport {

private ServicioCategoria sc= new ServicioCategoria();
private List<Categoria> lstCat;
private Categoria cat;
private String m;
private String i;
private Integer noca;

@Override
public String input() throws Exception {
if (getNoca()!=null) {setCat(sc.find(noca));}
return INPUT;}

public String detalle2() throws Exception {
if (getNoca()!=null) {setCat(sc.find(noca)); }
return INPUT;}

@Override
public String execute() throws Exception {return SUCCESS;}
public String save() { sc.save(getCat()); return "ok"; }
public String remove(){ sc.remove(getNoca()); return "ok"; }
public String list() throws Exception { lstCat=sc.findAll(); return execute();}
public String search() throws Exception { lstCat = sc.search(m);return execute();}
public String indice() throws Exception { lstCat = sc.search(i);return execute();}



//<editor-fold defaultstate="collapsed" desc="Getter y Setter">
public ServicioCategoria getSc() {return sc; }
public void setSc(ServicioCategoria sc) {this.sc = sc;}
public String getM() { return m;}
public void setM(String m) { this.m = m; }
public String getI() { return i; }
public void setI(String i) { this.i = i;}
public Integer getNoca() { return noca; }
public void setNoca(Integer noca) {this.noca = noca;}
public Categoria getCat() {return cat;}
public void setCat(Categoria cat) { this.cat = cat; }
public List<Categoria> getLstCat() {return lstCat;}
public void setLstCat(List<Categoria> lstCat) {this.lstCat = lstCat;}
//</editor-fold>
}
ServicioCategoria.java
public class ServicioCategoria extends AbstractFacade<Categoria> {
public ServicioCategoria() {super(Categoria.class);}


//CATEGORIA

public List<Categoria> findAll() {return super.findAll();}
public void save(Categoria cat) {super.createEdit(cat);}
public void remove(int noca) {
final Categoria find = super.find(noca);
if (find!=null){
super.remove(find);}
}
public Categoria find (int noca) {
return super.find(noca);
}

//TRAMA
}
The JSP SAMPLE ONLY data table category
No I Get to join the tables I'm desperate

<%@ taglib prefix="s" uri="/struts-tags" %>
<%@page contentType="text/html" pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>JSP Page</title>
</head>
<body>
<br/>
<h2>Mopstrar Datos</h2>
<s:iterator>
<s:form action="categoriaDetalle2">
<s:label label="Nombre" name="cat.catNoca" />
<s:label label="Nombre" name="cat.catNom" />
<s:label label="La 2 tabla" />
<s:label label="Nombre de trama" name="tra.Tradat" />
<s:label label="Nombre de trama" name="tra.catNom" />
</s:form>
</s:iterator>

</body>
</html>


Top
 Profile  
 
Display posts from previous:  Sort by  
Forum locked This topic is locked, you cannot edit posts or make further replies.  [ 1 post ] 

All times are UTC - 5 hours [ DST ]


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum

Search for:
© Copyright 2014, Red Hat Inc. All rights reserved. JBoss and Hibernate are registered trademarks and servicemarks of Red Hat, Inc.