初学struts,想用一个display.jsp来显示数据库表中的数据,一个Form,一个方法类,一个action,没有input,如果action执行成功则显示display.jsp 我想直接通过在myeclipse中进入display页面就显示数据,但是好像页面并没有执行到action,所以数据也显示不出来,请教高手怎么能够成功显示数据 啊,卡了一天了。。希望帮忙解决。。。
action的配置:
attribute="assetsaddForm"
name="assetsaddForm"
path="/assetsdisplay"
scope="request"
type="com.school.struts.action.AssetsdisplayAction">
</action>
assetsdisplay.jsp代码:
<%@ page language="java" pageEncoding="UTF-8"%>
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<%@ page import="com.school.struts.model.*" %>
<%@ page import="com.school.struts.form.*" %>
<%@ page import="java.util.*"%>
<%
Collection coll=(Collection)request.getAttribute("display");
%>
资产信息显示
<%
if(coll==null || coll.isEmpty()){
%>
暂无资产信息! |
<%
}else{
//通过迭代方式显示数据
Iterator it=coll.iterator();
int assetsid = 0;
String assetsname = "";
String assetscategory = "";
String assetstype = "";
String assetsfactory = "";
int assetsnum = 0;
String assetsbuydate = "";
String assetsstate = "";
String assetssource = "";
float assetsvalue = 0;
float assetsresidualrate = 0;
int assetsage = 0;
%>
资产编号 | 资产名称 | 资产类别 | 资产型号 | 生产厂家 | 数量 | 购买日期 | 资产状态 | 资产来源 | 资产原值 | 残值率 | 使用年限 |
<%=assetsid%> | <%=assetsname%> | <%=assetscategory%> | <%=assetstype%> | <%=assetsfactory%> | <%=assetsnum%> | <%=assetsbuydate%> | <%=assetsstate%> | <%=assetsresidualrate%> | <%=assetsvalue%> | <%=assetssource%> | <%=assetsage%> |
action代码如下:
public class AssetsdisplayAction extends Action {
public ActionForward execute(ActionMapping mapping, ActionForm form,
HttpServletRequest request, HttpServletResponse response) {
String str = null;
System.out.println("dfoiguj");
request.setAttribute("display", Assetsdatamodel.display(str));
return mapping.findForward("dissuccess");
}
方法如下:
public static Collection display(String queryif){
AssetsaddForm assetsaddForm = null;
Collection assetscoll = new ArrayList();
Statement stmt = null;
ResultSet rs = null;
try{//捕捉异常信息
Class.forName("com.mysql.jdbc.Driver");
Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/logistics","root","123456");
stmt = conn.createStatement();
String sql = "";
if (queryif == null || queryif == "" || queryif == "all") { //当参数queryif的值为null、all或空时查询全部数据
sql = "select * from assetsdata";
}
//sql = "select * from assetsdata";
rs = stmt.executeQuery(sql);
//assets = new ArrayList();
while (rs.next()){
assetsaddForm = new AssetsaddForm();
assetsaddForm.setAssetsid(rs.getInt("assetsid"));
assetsaddForm.setAssetsname(rs.getString("assetsname"));
assetsaddForm.setAssetscategory(rs.getString("assetscategory"));
assetsaddForm.setAssetstype(rs.getString("assetstype"));
assetsaddForm.setAssetsfactory(rs.getString("assetsfactory"));
assetsaddForm.setAssetsnum(rs.getInt("assetsnum"));
assetsaddForm.setAssetsbuydate(rs.getString("assetsbuydate"));
assetsaddForm.setAssetsstate(rs.getString("assetsstate"));
assetsaddForm.setAssetssource(rs.getString("assetssource"));
assetsaddForm.setAssetsvalue(rs.getFloat("assetsvalue"));
assetsaddForm.setAssetsresidualrate(rs.getFloat("assetsresidualrate"));
assetsaddForm.setAssetsage(rs.getInt("assetsage"));
System.out.println(rs.getInt("assetsid"));
assetscoll.add(assetsaddForm);//把查询结果保存到collection集合中
}
}catch(Exception ex){
System.out.println(ex.getMessage());
}finally{
try{
rs.close();
stmt.close();
}catch(SQLException e){
e.printStackTrace();
}
}
System.out.println("dfoiguj");
return assetscoll; //返回查询结果
}