一个网页的代码（和一位朋友的交流）

朋友：
我的代码如下：（整个网页都写上吧）zygjQuery.jsp
<%@ page language="java" contentType="text/html; charset=GB2312"
    pageEncoding="GB2312"%>
<%@ page import="java.sql.*" %>
<%@ page language="java" %>
<%@ include file="top.jsp" %>
<jsp:useBean id="zy"  scope="page" class="form.ZyForm" scope="session"/>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=GB18030">
<title>取得数据</title>
</head>
<body>
<CENTER><FONT size=5 color=blue><br>炸药信息查询结果
</FONT></CENTER>
<BR><HR><BR>
<% 
//得到关键字
String keyword=request.getParameter("keyword");
keyword=new String(keyword.getBytes("ISO-8859-1"),"gbk");
%>
<table width="80%" border="0" cellspacing="0" cellpadding="0">
   <tr>
    <td width="20%">你所查询的关键词为:</td><td><%=keyword%></td>
    <td><a href="zyQuery.jsp">返回</a></td>
  </tr>
</table>
<% 
//连接数据库
Connection con=null; 
Statement stmt=null; 
ResultSet rs=null;  try{
Class.forName("oracle.jdbc.driver.OracleDriver");
        con =DriverManager.getConnection("jdbc:oracle:thin:@192.168.0.8:1521:orcl", "scott", "tiger");
        stmt =con.createStatement();
        rs = stmt.executeQuery("select * from scott.danzhi  where scott.danzhi.EXPLOSIVES_NAME like '%"+keyword+"%' ");

%>
<p>所查到的数据如下：</p>
<table bgcolor=DodgerBlue>
<tr bgcolor=SkyBlue>
    <td width="14%" height="16" align="center">炸药名称</td>
    <td width="10%" align="center">外观</td>
    <td width="9%" align="center">爆热</td>
    <td width="8%" align="center">装药密度</td>
    <td width="7%" align="center">爆速<br></td>
    <td width="10%" align="center">爆压<br></td>
    <td width="9%" align="center">粘度</td>
    <td width="10%" align="center">摩擦感度</td>
    <td width="10%" align="center">撞击感度</td>
    <td width="11%" align="center">详细参数</td>
</tr>
<%
//这部分改了
List list=new ArrayList(); 
while (rs.next()){
%>
<tr>
    <td bgcolor=LightYellow width="14%" height="16" align="center"><%=rs.getString("EXPLOSIVES_NAME")%></td>
    <td bgcolor=LightYellow width="10%" align="center"><%=rs.getString("APPEARANCE")%></td>
    <td bgcolor=LightYellow width="9%" align="center"><%=rs.getString("HOT_BLAST")%></td>
    <td bgcolor=LightYellow width="8%" align="center"><%=rs.getString("CHARGE_DENSITY")%></td>
    <td bgcolor=LightYellow width="7%" align="center"><%=rs.getString("DETONATION_VELOCITY")%></td>
    <td bgcolor=LightYellow width="10%" align="center"><%=rs.getString("DETONATION_PRESSURE")%></td>
    <td bgcolor=LightYellow width="9%" align="center"><%=rs.getString("VISCOSITY")%></td>
    <td bgcolor=LightYellow width="10%" align="center"><%=rs.getString("FRICTION_SENSITIVITY")%></td>
    <td bgcolor=LightYellow width="10%" align="center"><%=rs.getString("IMPACT_SENSITIVITY")%></td>
    <td bgcolor=LightYellow width="11%" align="center"><a href="zyDetail.jsp"><center>查看</center></a></td>
</tr>
<%
zy.setDat(rs.getString("DATA_SOURCES"));
zy.setApl(rs.getString("APPLICATION"));
zy.setMot(rs.getString("MOTYPE_COEFFICIENT"));
zy.setEla(rs.getString("ELASTIC_MODULUS"));
zy.setShe(rs.getString("SHEAR_STRENGTH"));
zy.setVis(rs.getString("VISCOSITY"));
zy.setTen(rs.getString("TENSILE_STRENGTH"));
zy.setCom(rs.getString("COMPRESSIVE_STRENGTH"));
zy.setEle(rs.getString("ELE_SPARK_SENSITIVITY"));
zy.setSen(rs.getString("SENSITIVITY_SHOOTING"));
zy.setSho(rs.getString("SHOCK_SENSITIVITY"));
zy.setSma(rs.getString("SMALLEST_DOSE_INITIATION"));
zy.setFri(rs.getString("FRICTION_SENSITIVITY"));
zy.setImp(rs.getString("IMPACT_SENSITIVITY"));
zy.setThr(rs.getString("THERMAL_STABILITY"));
zy.setBri(rs.getString("BRISANCE"));
zy.setWor(rs.getString("WORK_CAPACITY"));
zy.setBur(rs.getString("BURST_TOLERANCE"));
zy.setDet(rs.getString("DETONATION_TEMPERATURE"));
zy.setDeo(rs.getString("DETONATION_PRESSURE"));
zy.setDen(rs.getString("DETONATION_VELOCITY"));
zy.setDef(rs.getString("DEFLAGRATION_POINT"));
zy.setHot(rs.getString("HOT_BLAST"));
zy.setFla(rs.getString("FLASH_POINT"));
zy.setSol(rs.getString("SOLID_ENTHALPY"));
zy.setCob(rs.getString("COMBUSTION_ENTHALPY"));
zy.setSta(rs.getString("STA_ENT_OF_FORMATION"));
zy.setSpe(rs.getString("SPECIFIC_HEAT_CAPACITY"));
zy.setThe(rs.getString("THERMAL_CONDUCTIVITY"));
zy.setLin(rs.getString("LINEAR_EXPANSION_COEFFICIENT"));
zy.setCha(rs.getString("CHARGE_DENSITY"));
zy.setBul(rs.getString("BULK_DENSITY"));
zy.setCry(rs.getString("CRYSTAL_DENSITY"));
zy.setMoi(rs.getString("MOISTURE_AND_VOLATILE_MATTER"));
zy.setHyg(rs.getString("HYGROSCOPICITY"));
zy.setAsh(rs.getString("ASH"));
zy.setMel(rs.getString("MELTING_POINT"));
zy.setVap(rs.getString("VAPOR_PRESSURE"));
zy.setStr(rs.getBlob("STRUCTURE"));
zy.setApp(rs.getString("APPEARANCE"));
zy.setOxy(rs.getString("OXYGEN_BALANCE"));
zy.setRel(rs.getString("RELATIVE_MOLECULAR_WEIGHT"));
zy.setMol(rs.getString("MOLECULAR_FORMULA"));
zy.setExp(rs.getString("EXPLOSIVES_NAME"));
list.add(zy); 
session.setAttribute('ZyForm',list); 
}}
catch (ClassNotFoundException e1)    {e1.printStackTrace();} 
catch (SQLException e2)              {e2.printStackTrace();} 
catch(NullPointerException e3)      {e3.printStackTrace();} 
try{ 
rs.close(); 
stmt.close(); 
con.close(); 
} 
catch(NullPointerException e)      {e.printStackTrace();} 
%>
</table>
</body>
</html>
<%@ include file="bottom.jsp" %>
红色部分出现错误：Invalid character constant
这个网页还有什么改进的，请指教！以后就开始编辑链接网页：zyDetial.jsp
利用
List l=(List)session.getAttribute('ZyForm'); 
for(int i = 0; i < l.size(); i++){ ZyForm zy=(ZyForm)l.get(i); t.getApp(); }获取内容！

解决方案 »

  1.   

    session.setAttribute('ZyForm',list); 
    改成
    session.setAttribute(“ZyForm”,list); 
    还有：
    对数据库的操作，最好不要直接写在jsp中，应该使用MVC来实现。
      

  2.   

    同意楼上的,这么多属性,还是用Hibernate映射作处理吧!
    另外问一下:
    zy.setStr(rs.getBlob("STRUCTURE"))这个是获取什么类型的值啊?
      

  3.   

    今天刚编了个下一个网页：
    zyDetail.jsp代码如下：
    <%@ page language="java" import="java.sql.*" pageEncoding="gbk" errorPage="Error.jsp"%>
    <%@ include file="top.jsp" %>
    <%@ page language="java" %>
    <%@ page import="java.util.*"%>
    <jsp:useBean id="zy"  scope="page" class="form.ZyForm" scope="session"/>
    <html>
    <head>
    <meta http-equiv="Content-Type" content="text/html; charset=GB18030">
    <title>详细信息</title>
    </head>
    <body><table width="103%" border="0" cellspacing="0" cellpadding="0">
      <tr>
        <td><img src="photo/default_04.gif" width="768" height="31" /></td>
      </tr>
    </table>
    <table width="80%" border="0" cellspacing="0" cellpadding="0">
      <tr>
        <td><div align="center"><span class="STYLE18">炸药数据库</span></div></td>
      </tr>
    </table>
    <%  
     List l=(List)session.getAttribute("ZyForm"); 
     for(int i = 0; i < l.size(); i++)
     { 
    ZyForm zy=(ZyForm)l.get(i);%>
    <table width="100%" height="406" border="0" align="center" cellpadding="0" cellspacing="0">
      <tr>
        <td height="406"><table width="80%" height="782" border="0" align="center" cellpadding="0" cellspacing="0">
          <tr>
            <td width="22%" height="29"><div align="right">炸药名称：</div></td>
            <td width="16%"><%=zy.getExp(i)%></td>
            <td width="22%">分子式：</td>
            <td width="40%"><%=zy.getMol(i)%></td>
          </tr>
          <tr>
            <td height="32"><div align="right">应用简况：</div></td>
            <td colspan="3"><%=zy.getApl(i)%></td>
            </tr>
          <tr>
            <td height="31"><div align="right">结构式：</div></td>
            <td colspan="3"><%=zy.getStr(i)%></td>
            </tr>
          <tr>
            <td height="24">炸药性能参数</td>
          </tr>
          <tr>
            <td height="26"><div align="right">相对分子质量：</div></td>
            <td><%=zy.getRel(i)%></td>
            <td><div align="right">氧平衡：</div></td>
            <td><%=zy.getOxy(i)%></td>
          </tr>
          <tr>
            <td height="29"><div align="right">蒸汽压：</div></td>
            <td><%=zy.getVap(i)%></td>
            <td><div align="right">熔点：</div></td>
            <td><%=zy.getMel(i)%></td>
          </tr>
          <tr>
            <td height="27"><div align="right">灰分：</div></td>
            <td><%=zy.getAsh(i)%></td>
            <td><div align="right">吸湿性：</div></td>
            <td><%=zy.getHyg(i)%></td>
          </tr>
          <tr>
            <td height="29"><div align="right">水分和挥发性:</div></td>
            <td><%=zy.getMoi(i)%></td>
            <td><div align="right">晶体密度：</div></td>
            <td><%=zy.getCry(i)%></td>
          </tr>
          <tr>
            <td height="24"><div align="right">堆积密度：</div></td>
            <td><%=zy.getBul(i)%></td>
            <td><div align="right">装药密度：</div></td>
            <td><%=zy.getCha(i)%></td>
          </tr>
          <tr>
            <td height="26"><div align="right">线膨胀系数：</div></td>
            <td><%=zy.getLin(i)%></td>
            <td><div align="right">导热系数：</div></td>
            <td><%=zy.getThe(i)%></td>
          </tr>
          <tr>
            <td height="35"><div align="right">比热容：</div></td>
            <td><%=zy.getSpe(i)%></td>
            <td><div align="right">标准生成焓：</div></td>
            <td><%=zy.getSta(i)%></td>
          </tr>
          <tr>
            <td height="25"><div align="right">爆发点：</div></td>
            <td><%=zy.getFla(i)%></td>
            <td><div align="right">爆热：</div></td>
            <td><%=zy.getHot(i)%></td>
          </tr>
          <tr>
            <td height="29"><div align="right">爆燃点：</div></td>
            <td><%=zy.getDef(i)%></td>
            <td><div align="right">爆速：</div></td>
            <td><%=zy.getDen(i)%></td>
          </tr>
          <tr>
            <td height="36"><div align="right">爆压：</div></td>
            <td><%=zy.getDeo(i)%></td>
            <td><div align="right">爆温：</td>
            <td><%=zy.getDet(i)%></td>
          </tr>
          <tr>
            <td height="27"><div align="right">爆容：</div></td>
            <td><%=zy.getBur(i)%></td>
            <td><div align="right">做功能力：</td>
            <td><%=zy.getWor(i)%></td>
          </tr>
          <tr>
            <td height="29"><div align="right">猛度：</div></td>
            <td><%=zy.getBri(i)%></td>
            <td><div align="right">热安定性：</td>
            <td><%=zy.getThr(i)%></td>
          </tr>
          <tr>
            <td height="35"><div align="right">撞击感度：</div></td>
            <td><%=zy.getImp(i)%></td>
            <td><div align="right">摩擦感度：</td>
            <td><%=zy.getFri(i)%></td>
          </tr>
          <tr>
            <td height="36"><div align="right">最小起爆药量：</div></td>
            <td><%=zy.getSma(i)%></td>
            <td><div align="right">冲击波感度：</td>
            <td><%=zy.getSho(i)%></td>
          </tr>
          <tr>
            <td height="29"><div align="right">枪击感度：</div></td>
            <td><%=zy.getSen(i)%></td>
            <td><div align="right">静电火花感度：</td>
            <td><%=zy.getEle(i)%></td>
          </tr>
          <tr>
            <td height="30"><div align="right">抗压强度：</div></td>
            <td><%=zy.getCom(i)%></td>
            <td><div align="right">抗拉强度：</td>
            <td><%=zy.getTen(i)%></td>
          </tr>
          <tr>
            <td height="30"><div align="right">粘度：</div></td>
            <td><%=zy.getVis(i)%></td>
            <td><div align="right">抗剪强度：</td>
            <td><%=zy.getShe(i)%></td>
          </tr>
          <tr>
            <td height="28"><div align="right">弹性模量：</div></td>
            <td><%=zy.getEla(i)%></td>
            <td><div align="right">莫式系数：</td>
            <td><%=zy.getMto(i)%></td>
          </tr>
          <tr>
            <td height="22"><div align="right">数据来源：</div></td>
            <td><%=zy.getDat(i)%></td>
          </tr>
        </table>
    </td>
      </tr>
    </table>
    <%
    } %>
    <img src="photo/default_04.gif" width="739" height="16" />
    </body>
    </html>
    <%@ include file="bottom.jsp" %>不过红色部分有错误：ZyForm cannt be resolved to  be a type
    错误怎么改？
      

  4.   

    ZyForm这个类没定义或者没加进来