Java论坛网»Java技术»关于页面显示我有3条记录,但是页面上的表格不把具体的数据信息显示出来的问题,高手进!
关于页面显示我有3条记录,但是页面上的表格不把具体的数据信息显示出来的问题,高手进!
问?:
public class PagedRS
{
public PagedRS()
{
logger = Logger.getLogger(org.tseg.cubcc.util.PagedRS.class);
sumColNames = null;
sumMap = new HashMap();
}
public void setSumColNames(String sumColNames[])
{
this.sumColNames = sumColNames;
}
public void getPagedRSBySql()
{
DBMgr dbmgr = new DBMgr(dbIndex);
ResultSet rs;
try
{
Connection conn = dbmgr.getConnection();
Statement stmt = conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_UPDATABLE);
//Statement stmt = conn.createStatement(1004,1007);
rs = null;
logger.info("Pages RS sql is \n" + sQuerySql);
rs = stmt.executeQuery(sQuerySql);
if(rs == null)
{
logger.error("Database operation error:" + sQuerySql);
return;
}
if(!rs.next())
{
vRSData = new Vector();
return;
}
rs.last();
iRecordCount = rs.getRow();
System.out.println("aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa="+sumColNames);
if(sumColNames != null)
{
logger.info("summing " + StringUtil.array2NumberString(sumColNames));
if(rs.first())
{
for(int i = 0; i < sumColNames.length; i++)
sumMap.put(sumColNames[i], new Double(rs.getDouble(sumColNames[i])));
}
while(rs.next())
{
for(int i = 0; i < sumColNames.length; i++)
{
double d = ((Double)sumMap.get(sumColNames[i])).doubleValue();
d += rs.getDouble(sumColNames[i]);
sumMap.put(sumColNames[i], new Double(d));
}
}
}
return;
}
catch(Throwable t)
{
logger.error("error:" + sQuerySql, t);
return;
}
finally
{
dbmgr.free();
}
}
public String getHtmlRecordList(String asCnPropNames[], boolean bIsOrderField[])
{
String sArrayValues = "asCnOrderBy = new Array('" + asCnPropNames[0] + "'";
String sJSCode = "<script language=javascript>\nfunction setOrderBy(iOrderByID, bIsAscend){\nasOrderBy = new Array('" + asRequiredProperties[0] + "'";
for(int i = 1; i < asCnPropNames.length; i++)
{
sArrayValues = sArrayValues + ",'" + asCnPropNames[i] + "'";
sJSCode = sJSCode + ",'" + asRequiredProperties[i] + "'";
}
sJSCode = sJSCode + ");\n" + sArrayValues + ");\n" + " asAsc = new Array(' asc ', ' desc ');\n" + "asCnAsc = new Array('\u5347\u5E8F', '\u964D\u5E8F');\n" + "Form_PageList.OrderBy.value = asOrderBy[iOrderByID] + asAsc[bIsAscend];\n" + "Form_PageList.CnOrderBy.value = '\u6309' + asCnOrderBy[iOrderByID] + asCnAsc[bIsAscend] + '\u6392\u5217\uFF08array\uFF09';\n" + "}\n</script>\n";
String sHtml = "<table border=1 cellspacing=0 cellpadding=1 bordercolorlight=#999999 bordercolordark=#FFFFFF align=center>\n<form name=frmDataList method=post >\n" + sJSCode + "<tr><td rowspan=2 bgcolor=#C4DCFD width=40 align=center>\n" + "<font color=#000066>\u9009\u62E9</font></td>\n";
for(int i = 0; i < asCnPropNames.length; i++)
if(bIsOrderField[i])
sHtml = sHtml + "<td rowspan=2 width=66 align=center bgcolor=#C4DCFD>" + "<table width=80 border=0 cellpadding=0 cellspacing=0>" + "<tr><td rowspan=2 align=center><font color=#000066>" + asCnPropNames[i] + "</font></td><td>" + "<a style='cursor:hand' onclick=\"setOrderBy(" + String.valueOf(i) + ", 0);doPageListSubmit();\">" + "<img src="http://localhost/365java/upload/picture/2007-7/17/0771716571644426.gif" width=10 height=10 border=0></a>" + "</td></tr><tr><td>" + "<a style='cursor:hand' onclick=\"setOrderBy(" + String.valueOf(i) + ", 1);doPageListSubmit();\">" + "<img src="http://localhost/365java/upload/picture/2007-7/17/077171657371384.gif" width=10 height=10 border=0>" + "</td></tr></table></td>\n";
else
sHtml = sHtml + "<td rowspan=2 bgcolor=#C4DCFD width=123 align=center>" + "<font color=#000066>" + asCnPropNames[i] + "</font></td>\n";
sHtml = sHtml + "</tr>\n<tr align=center> </tr>\n";
String asColor[] = {
"#F3F3F3", "#E0E0E0"
};
if(vRSData == null)
vRSData = new Vector();
int vtSize = vRSData.size();
System.out.print("vtSize=" + vtSize);
for(int i = 0; i < vtSize; i++)
{
Hashtable htIC = (Hashtable)vRSData.elementAt(i);
sHtml = sHtml + "<tr bgcolor=" + asColor[i % 2] + "><td align=center width=40 bgcolor=#F3F3F3>" + "<input type=checkbox class=input_checkbox name=chbox value='" + (String)htIC.get(sLinkProp) + "'>" + "</td>";
sHtml = sHtml + "<td><a href=" + sLinkViewForm + "?FormID=" + (String)htIC.get(sLinkProp) + " >" + (String)htIC.get(asRequiredProperties[0]) + "</a>";
for(int j = 1; j < asRequiredProperties.length; j++)
sHtml = sHtml + "<td> " + htIC.get(asRequiredProperties[j]) + "</td>";
sHtml = sHtml + "</tr>\n";
}
sHtml = sHtml + "</form></table>";
return sHtml;
}
public void init(String sQuerySql, String sDefaultOrderBy, boolean abIsOrderField[], String asPropCnNames[], String asRequiredProperties[], String sLink, String sLinkViewForm,
String sLinkCancelForm, String sCnFormName)
{
this.sQuerySql = sQuerySql;
this.sDefaultOrderBy = sDefaultOrderBy;
this.abIsOrderField = abIsOrderField;
this.asPropCnNames = asPropCnNames;
this.asRequiredProperties = asRequiredProperties;
this.sLink = sLink;
this.sLinkViewForm = sLinkViewForm;
this.sLinkCancelForm = sLinkCancelForm;
this.sCnFormName = sCnFormName;
String sWhere = " ";
if(sSearchFieldCnNames != null && sDateFieldName != null)
{
if(sStartDate != null && sStartDate.length() > 0)
sWhere = sWhere + " and " + sDateFieldName + " >= to_date('" + sStartDate + "', 'yyyy-mm-dd') ";
if(sEndDate != null && sEndDate.length() > 0)
sWhere = sWhere + " and " + sDateFieldName + " <= to_date('" + sEndDate + "', 'yyyy-mm-dd') + 1 ";
}
if(sOrderBy == null)
{
this.sQuerySql = sQuerySql + sWhere + " order by " + sDefaultOrderBy;
sOrderBy = sDefaultOrderBy;
} else
{
this.sQuerySql = sQuerySql + sWhere + " order by " + sOrderBy;
}
logger.info("SQL after PagedRS.init():" + this.sQuerySql);
getPagedRSBySql();
}
protected String sumColNames[];
protected HashMap sumMap;
}
这里面的sumColNames[]好象一直得不到值,结果下面的代码就不好使,它一直是空的,哪为大哥帮我把他赋上值,小弟这里谢谢了,他求的好象是列的名字
答!: 1:
我Call
这代码写的
这代码写的
答!: 2:
呵呵 这是别人的class代码 我们给反编译过来的,所以出了很多问题 ,帖出来的代码我还给删了好多方法呢 太长了 关键的地方就在那个sumColNames身上,他一直是空的,传值给他才可以让程序完美的把数据信息具体在表格里显示出来,现在只是在页面的统计上显示有3个记录而已
答!: 3:
getHtmlRecordList这个方法以下就不用看的,呵呵
答!: 4:
为什么没人呢 大哥们 帮帮我啊!
答!: 5:
。。。。反编译人家的代码?
不支持,不鼓励,本来一简单功能写代码还没你反编人家代码时间长
不支持,不鼓励,本来一简单功能写代码还没你反编人家代码时间长
相关JAVA教程:
jsp和javabean结合的问题
添加JavaBean成员变量读写方法的问题
求教:关于电子邮件自动发送的问题(jsp)(急!)
急需高手帮忙!高手请进分不够再给
struts-menu实现的问题
发现java .net 没什么好搞的!
安装j2ee1.4遇到的问题
这个问题应该怎么解决,郁闷了好几天
Hibernate应用程序中能不能同时读取两个hibernate.hbm.xml????
Struts 上传问题 (急) (在线等)
急问:如何将tomcat下的web应用迁移到Resin下?
关于面板数组的使用