comment faire pour une requete Sql avec jointure de deux ou plusieurs tables !?
comment faire pour recupéré les donné d'une requete Sql avec jointure de deux ou plusieurs tables !?
Mon code --->
source de donnéés :
Code:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29
| public static List List_Client(){
List vec1=new ArrayList<ArrayList>();
//client cl=new client();
if(con==null){
try {
con = connexion.connect();
String req = "select cl.client_id,cl.client_nom,inv.intervention_id from front_client cl, front_intervention inv where cl.client_id=inv.intervention_client_fk";
st = con.createStatement();
rs = st.executeQuery(req);
while (rs.next()) {
vec1.add(new client(rs.getString(1), rs.getString(2),"","")); //client_id
vec1.add(new intervention(rs.getString(3))); //client_id
// vec1.add(vec2);
}
st.close();
} catch (SQLException ex) {
Logger.getLogger(dao_utilisateur.class.getName()).log(Level.SEVERE, null, ex);
}
}
con=null;
return vec1;
} |
page test.jsp :
Code:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26
| <jsp:include page="theme/template.jsp" flush="true" />
<%@ taglib uri="http://displaytag.sf.net" prefix="display" %>
<jsp:directive.page contentType="text/html; charset=UTF-8" />
<jsp:directive.page import="org.displaytag.decorator.*" />
<jsp:scriptlet> Object foo = pageContext.getAttribute( "test" );
if( foo == null ) {
pageContext.setAttribute( "test",new dao.dao_client().List_Client());
}
</jsp:scriptlet>
<display:table name="pageScope.test" pagesize="10" export="true" class="displaytag" decorator="bo.MyDecorator" >
<display:column class="column" property="client_id" title="id" sortable="true" paramId="id" href="index.jsp?"/>
<display:column class="column" property="client_nom" title="nom" />
<display:column class="column" property="client_code" title="code"/>
<display:column class="column" property="client_active" title="active" />
<display:column class="column" property="mylink" title="" />
<display:setProperty name="paging.banner.placement" value="bottom" />
</display:table>
<jsp:include page="theme/footer.html" flush="true" /> |
Merci d'avance :oops: