iterate标签一问,急急急!!!!!!在先等
nixun 2003-10-19 05:05:50 我想在浏览器输入http://localhost:8080/test2/Test.do
然后显示从数据库中查出的内容,但是它只是进行了乡音的循环,没有显示数据.急急急
config-xml:
<data-sources>
<data-source key="data">
<set-property property="autoCommit" value="true"/>
<set-property property="driverClass" value="oracle.jdbc.driver.OracleDriver"/>
<set-property property="password" value="manager"/>
<set-property property="url" value="jdbc:oracle:thin:@localhost:1521:data"/>
<set-property property="user" value="system"/>
</data-source>
</data-sources>
<action-mappings>
<action path="/Test" type="pub.TestAction">
<forward name="success" path="/index.jsp"/>
<forward name="failure" path="/indexFail.jsp"/>
</action>
</action-mappings>
TestAction.java
package pub;
import org.apache.struts.action.* ;
import javax.servlet.http.* ;
import javax.sql.* ;
import java.util.* ;
import java.sql.* ;
import java.io.* ;
/**
* @author Administrator
*
* To change the template for this generated type comment go to
* Window>Preferences>Java>Code Generation>Code and Comments
*/
public class TestAction extends Action
{
public ActionForward perform( ActionMapping mapping ,
ActionForm form,
HttpServletRequest req ,
HttpServletResponse res )
{
DataSource ds = servlet.findDataSource("data");
try
{
Connection conn = ds.getConnection( );
Statement stmt = conn.createStatement( );
String sql = "select * from Gh_Js" ;
ResultSet rs = stmt.executeQuery( sql );
ResultSetMetaData rsmd = rs.getMetaData();
int columnCount = rsmd.getColumnCount();
ArrayList rows = new ArrayList();
while(rs.next())
{
HashMap row = new HashMap();
for (int i = 1; i <= columnCount; i++)
{
String name = rsmd.getColumnName(i);
row.put(name, rs.getObject(i));
}
rows.add(row);
}
rs.close();
stmt.close();
conn.close();
req.setAttribute("rows",rows);
return mapping.findForward("success") ;
}
catch (Exception ex)
{
return mapping.findForward("failure");
}
}
};
index.jsp
<%@ page contentType="text/html;charset=GB2312"%>
<%@ taglib uri = "/WEB-INF/struts-html.tld" prefix = "html" %>
<%@ taglib uri = "/WEB-INF/struts-bean.tld" prefix = "bean" %>
<%@ taglib uri = "/WEB-INF/struts-logic.tld" prefix = "logic" %>
<%@ page import="java.util.*"%>
<html>
<head>
</head>
<body>
<table border="1" width="200">
<logic:iterate name="rows" id="row" scope="request" >
<tr height="30">
<td><bean:write name="row" property="Jsbh" /></td>
<td><bean:write name="row" property="Jsmc" /></td>
</tr>
</logic:iterate>
</table>
</body>
</html>