1.请问用Struts2标签如何实现以下三级嵌套查询(关键在于子循环使用了上一级循环中的字段值)
而Struts2标签只能从Action转到jsp页后获取,而嵌套循环需要再传参数到Action,再查询,Struts2能传递参数到Action吗? <%
String sqlA="select * from Main_A";
ResultSet rsA=DB.getResultSet(sqlA);
while(rsA.next()){
//内容 String sqlB="select * from Main_B wherw class='"+rsA.getString("class")+"'";
ResultSet rsB=DB.getResultSet(sqlB);
while(rsB.next()){ //内容 String sqlC="select * from Main_C where classto='"+rsB.getString("class")+"'";
ResultSet rsC=DB.getResultSet(sqlC);
while(rsC.next()){ //内容 } }
} %>
而Struts2标签只能从Action转到jsp页后获取,而嵌套循环需要再传参数到Action,再查询,Struts2能传递参数到Action吗? <%
String sqlA="select * from Main_A";
ResultSet rsA=DB.getResultSet(sqlA);
while(rsA.next()){
//内容 String sqlB="select * from Main_B wherw class='"+rsA.getString("class")+"'";
ResultSet rsB=DB.getResultSet(sqlB);
while(rsB.next()){ //内容 String sqlC="select * from Main_C where classto='"+rsB.getString("class")+"'";
ResultSet rsC=DB.getResultSet(sqlC);
while(rsC.next()){ //内容 } }
} %>
private String/int. x1;
private String/int. x2;
....
private Set<ClassB> classB;
}
public class ClassB{ // 分别加上getter和setter方法
private String/int. x1;
private String/int. x2;
....
private Set<ClassC> classB;
}
public class ClassC{ // 分别加上getter和setter方法
private String/int. x1;
private String/int. x2;
....
}在后天只需要定义一个List<ClassA> classA = new ArrayList<ClassA>();然后按照层次结构将数据放进去即可。