package com.edu.ytu;
import java.sql.ResultSet;
import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;
import java.util.Map;
import javax.servlet.http.HttpServletRequest;
import org.apache.struts2.ServletActionContext;
import com.opensymphony.xwork2.ActionSupport;
import db2.Db2;public class ResearchAction extends ActionSupport {
/**
*
*/
private static final long serialVersionUID = 1L; private ResultSet rst = null;
Db2 db2 = null;
private String keyword;
public String getKeyword() {
return keyword;
}
public void setKeyword(String keyword) {
this.keyword = keyword;
} public String execute() throws Exception {
db2 = new Db2();
HttpServletRequest request = ServletActionContext.getRequest();
if(keyword!=null&&!keyword.equals("")){
db2.dbConnect();
String sqlStr = "select * from db2admin.news where code like '%"+keyword+"%' or title like '%"+keyword+"%' or from like '%"+keyword+"%' or author like '%"+keyword+"%' ";
db2.setSqlStr(sqlStr);
rst = db2.executeQuery(sqlStr);
List list = new ArrayList();
Map map = null ;
while(rst.next()){
map = new HashMap();
String id = rst.getString("id");
//String title=rst.getString("title");
map.put("id",id);
//map.put("title",title);
list.add(map);
System.out.println(id);
request.setAttribute("id",rst.getString("id"));
request.setAttribute("myList",list);
}
rst.close();
db2.dbClose();
return "research_list";
}
else{
return "index";
}
}
}
jsp获取输出列表:<%
List list = (List)request.getAttribute("myList");
for( int i = 0 ; i < list.size() ; i ++ ){
%>
<LI><span class="news"><a href="index.action?id=<%=list.get(i) %>" target="_blank"><%=list.get(i)%></a></span></LI>
<% }
%>这是一个查询,我提交验证信息到java后台验证,验证成功保存列表,然后在jsp页面下打印列表<%=list.get(i)%>,
我现在要做的是,打印列表的两个或者更多属性的列表。
请问我该怎样去做??
import java.sql.ResultSet;
import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;
import java.util.Map;
import javax.servlet.http.HttpServletRequest;
import org.apache.struts2.ServletActionContext;
import com.opensymphony.xwork2.ActionSupport;
import db2.Db2;public class ResearchAction extends ActionSupport {
/**
*
*/
private static final long serialVersionUID = 1L; private ResultSet rst = null;
Db2 db2 = null;
private String keyword;
public String getKeyword() {
return keyword;
}
public void setKeyword(String keyword) {
this.keyword = keyword;
} public String execute() throws Exception {
db2 = new Db2();
HttpServletRequest request = ServletActionContext.getRequest();
if(keyword!=null&&!keyword.equals("")){
db2.dbConnect();
String sqlStr = "select * from db2admin.news where code like '%"+keyword+"%' or title like '%"+keyword+"%' or from like '%"+keyword+"%' or author like '%"+keyword+"%' ";
db2.setSqlStr(sqlStr);
rst = db2.executeQuery(sqlStr);
List list = new ArrayList();
Map map = null ;
while(rst.next()){
map = new HashMap();
String id = rst.getString("id");
//String title=rst.getString("title");
map.put("id",id);
//map.put("title",title);
list.add(map);
System.out.println(id);
request.setAttribute("id",rst.getString("id"));
request.setAttribute("myList",list);
}
rst.close();
db2.dbClose();
return "research_list";
}
else{
return "index";
}
}
}
jsp获取输出列表:<%
List list = (List)request.getAttribute("myList");
for( int i = 0 ; i < list.size() ; i ++ ){
%>
<LI><span class="news"><a href="index.action?id=<%=list.get(i) %>" target="_blank"><%=list.get(i)%></a></span></LI>
<% }
%>这是一个查询,我提交验证信息到java后台验证,验证成功保存列表,然后在jsp页面下打印列表<%=list.get(i)%>,
我现在要做的是,打印列表的两个或者更多属性的列表。
请问我该怎样去做??
List list = (List)request.getAttribute("myList");
for( int i = 0 ; i < list.size() ; i ++ ){
if(i%2==0){out.print("<br>");}
%>
<LI> <span class="news"> <a href="index.action?id= <%=list.get(i) %>" target="_blank"> <%=list.get(i)%> </a> </span> </LI>
<% }
%>