弹出图片代码有问题

Question

else if(bm.equals("学校教育信息化建设下一步打算"))
{while(rs.next())
{String n=rs.getString("学校名称");
 if(xx.equals(n))
 {
%>
<table width="752" height="493" border="1" cellpadding="0" cellspacing="0">
  <tr>
    <td width="124" height="30"><div align="center"><span class="style1">学校名称</span></div></td>
    <td width="612"><div align="center"><%=n%></div></td>
  </tr>
  <tr>
    <td height="14" colspan="2"><div align="center" class="style1"> 关于学校教育信息化建设下一步打算</div></td>
  </tr>
  <tr>
    <td height="443" colspan="2"><div align="center"><%=rs.getString(2)%></div></td>
  </tr>
</table>
<%}}}
else if(bm.equals("教育技术资源建设"))
{while(rs.next())
{String n=rs.getString("学校名称");
 if(xx.equals(n))
 {%>
 <table width="753" height="626" border="1" cellpadding="0" cellspacing="0">
       <tr>
         <td width="148" height="27"><div align="center"><span class="style1">学校名称</span></div></td>
         <td width="557"><div align="center"><%=n%></div></td>
       </tr>
       <tr>
         <td height="27" colspan="2"><div align="center" class="style1">学校领导对于信息化的理解</div></td>
       </tr>
       <tr>
         <td height="111" colspan="2"><div align="center"><%=rs.getString("学校领导对于信息化的理解")%></div></td>
       </tr>
       <tr>
         <td height="24" colspan="2"><div align="center"><span class="style1">教师对于信息化的认识</span></div></td>
       </tr>
       <tr>
         <td height="128" colspan="2"><div align="center"><%=rs.getString("教师对于信息化的认识")%></div></td>
       </tr>
       <tr>
         <td height="35"><span class="style1"> 教师独立制作课件的能力 </span></td>
         <td height="35"><div align="center">4</div></td>
       </tr>
       <tr>
         <td height="32"><div align="center" class="style1"> CAI 教材 </div></td>
         <td height="32"><div align="center"><%=rs.getString("CAI教材")%></div></td>
       </tr>
       <tr>
         <td height="31"> <div align="center" class="style1">常规音像教材 </div></td>
         <td height="31"><div align="center"><%=rs.getString("常规音像教材")%></div></td>
       </tr>
       <tr>
         <td height="31"> <div align="center" class="style1">电教课时覆盖率 </div></td>
         <td height="31"><div align="center"><%=rs.getString("电教课时覆盖率")%></div></td>
       </tr>
       <tr>
         <td height="31"> <div align="center" class="style1">电教学科覆盖率 </div></td>
         <td height="31"><div align="center"><%=rs.getString("电教学科覆盖率")%></div></td>
       </tr>
       <tr>
         <td height="31"> <div align="center" class="style1">电教教师普及率 </div></td>
         <td height="31"><div align="center"><%=rs.getString("电教教师普及率")%></div></td>
       </tr>
       <tr>
         <td height="33"><div align="center"><span class="style1"> 教师计算机水平等级 </span></div></td>
         <td height="33"><div align="center"><span class="style1">初 级 （<span class="style3"><%=rs.getString("教师计算机初级")%></span> ） 人； 中 级 （<span class="style3"><%=rs.getString("教师计算机中级")%></span> ） 人； 高 级 （<span class="style3"><%=rs.getString("教师计算机高级")%></span> ） 人 </span></div></td>
       </tr>
       <tr>
         <td height="36"> <div align="center" class="style1">教师信息技术培训情况 </div></td>
         <td height="36"><div align="center" class="style1"> 省 级（<span class="style3"><%=rs.getString("教师信息教育培训（省级人次）")%></span>） 人次； 市 级（<span class="style3"><%=rs.getString("教师信息技术培训（市级人次）")%></span> ）人次； 区 级（<span class="style3"><%=rs.getString("教师信息技术培训（区级人次）")%></span>）人次； 校 级（<span class="style3"><%=rs.getString("教师信息技术培训（校级人次）")%></span>）人次 </div></td>
       </tr>
     </table>
     <table width="753" height="173" border="1" cellpadding="0" cellspacing="0">
       <tr>
         <td width="190" height="31"> <div align="center" class="style1">信息技术开课情况 </div></td>
         <td width="557"> <div align="center" class="style1">每 周（<span class="style3"><%=rs.getString("信息技术每周（）节")%></span> ）节
         </div>
           <div align="center"></div></td>
       </tr>
       <tr>
         <td height="32" colspan="2"><div align="center" class="style1"> 学校现代教育技术方面科研课题研究情况 </div></td>
       </tr>
       <tr>
         <td height="83" colspan="2"><div align="center"><%=rs.getString("学校现代教育方面科研课题研究情况")%></div></td>
       </tr>
     </table>
     <%}}}      待续！！！！！！！

Answer 1

else if(bm.equals("学校机房网络建设及应用情况"))
{while(rs.next())
{String n=rs.getString("学校名称");
 if(xx.equals(n))
 {%>
 <table width="753" height="916" border="1" cellpadding="0" cellspacing="0">
       <tr>
         <td width="106" height="28"><div align="center" class="style1">学校名称</div></td>
         <td colspan="3"><div align="center"><%=n%></div></td>
       </tr>
       <tr>
         <td height="27"> <div align="center" class="style1">机房位置 </div></td>
         <td width="230" height="27"><div align="center"><%=rs.getString("机房位置")%></div></td>
         <td width="135"> <div align="center" class="style1">多媒体教室数量及位置 </div></td>
         <td width="279"><div align="center"><%=rs.getString("多媒体教室位置")%></div></td>
       </tr>
       <tr>
         <td height="28"> <div align="center" class="style1">电教专用教室数量 </div></td>
         <td height="28"><div align="center"><%=rs.getString("电教专用教室数量")%></div></td>
         <td height="28"> <div align="center" class="style1">计算机数量 </div></td>
         <td height="28"><div align="center"><%=rs.getString("计算机数量")%></div></td>
       </tr>
       <tr>
         <td height="23" colspan="4"><div align="center" class="style1"> 计算机基本配置说明（学生机和教师机） </div></td>
       </tr>
       <tr>
         <td height="77" colspan="4"><div align="center"><%=rs.getString("计算机基本配置说明")%></div></td>
       </tr>
       <tr>
         <td height="32"> <div align="center" class="style1">人机比（学生） </div></td>
         <td height="32"><div align="center"><%=rs.getString("人机比（学生）")%></div></td>
         <td height="32"> <div align="center" class="style1">人机比（老师） </div></td>
         <td height="32"><div align="center"><%=rs.getString("人机比（老师）")%></div></td>
       </tr>
       <tr>
         <td height="29" colspan="4"> <div align="left">
           <table width="752" border="1" cellspacing="0" cellpadding="0">
             <tr>
               <td width="135" height="29"><div align="center" class="style1">校园网络的基本布线</div></td>
               <td width="611"><div align="center"><%=rs.getString("学校网络基本布线")%></div></td>
             </tr>
           </table>
         </div></td>
       </tr>
       <tr>
         <td height="22" colspan="4"><div align="center" class="style1"> 校园网络的网络拓扑结构图 </div></td>
       </tr>
       <tr>
         <td height="367" colspan="4"><div align="center"><img src="showpic.jsp?mc=<%=xx%>&bn=<%=bm%>&zd=<%="网络拓扑结构图"%>"width="700" height="450"></div></td>
       </tr>
       <tr>
         <td height="31"> <div align="center" class="style1">是否有 INTERNET 网络接入 </div></td>
         <td height="31"><div align="center"><%=rs.getString("是否有INTERNET接入")%></div></td>
         <td height="31"> <div align="center" class="style1">网络是否接到多媒体教室 </div></td>
         <td height="31"><div align="center"><%=rs.getString("网络是否接到多媒体教室")%></div></td>
       </tr>
       <tr>
         <td height="29" colspan="4"><div align="center">
           <table width="754" border="1" cellspacing="0" cellpadding="0">
             <tr>
               <td width="104" height="26"><div align="center"><span class="style1"> 网络安全应用实施措施 </span></div></td>
               <td width="644"><div align="center"><%=rs.getString("网络安全应用措施")%></div></td>
             </tr>
           </table>
         </div></td>
       </tr>
       <tr>
         <td height="32"><div align="center"><span class="style1"> 网络信息过滤应用情况 </span></div></td>
         <td height="32"><div align="center"><%=rs.getString("网络信息过滤情况")%></div></td>
         <td height="32"> <div align="center" class="style1">网络防病毒应用情况 </div></td>
         <td height="32"><div align="center"><%=rs.getString("网络防病毒情况")%></div></td>
       </tr>
       <tr>
         <td height="30" colspan="4"><table width="756" height="31" border="1" cellpadding="0" cellspacing="0">
           <tr>
             <td width="104"> <div align="center" class="style1">网络应用的实施情况 </div></td>
             <td width="646"><div align="center"><%=rs.getString("网络应用的实施情况")%></div></td>
           </tr>
         </table></td>
       </tr>
       <tr>
         <td height="34"><div align="center"><span class="style1"> 校园信息发布系统（网址） </span></div></td>
         <td height="34"><div align="center"><%=rs.getString("校园信息发布系统")%></div></td>
         <td height="34"> <div align="center" class="style1">校园广播系统 </div></td>
         <td height="34"><div align="center"><%=rs.getString("校园广播系统")%></div></td>
       </tr>
       <tr>
         <td height="35" colspan="4"><table width="756" border="1" cellspacing="0" cellpadding="0">
           <tr>
             <td width="103" height="35"><div align="center"><span class="style1"> 学校多功能教室的情况 </span></div></td>
             <td width="646"><div align="center"><%=rs.getString("学校功能教室情况")%></div></td>
           </tr>
         </table></td>
       </tr>
       <tr>
         <td height="34" colspan="4"><table width="756" border="1" cellspacing="0" cellpadding="0">
           <tr>
             <td width="102" height="36"> <div align="center" class="style1">学校有线视频网络的情况 </div></td>
             <td width="648"><div align="center"><%=rs.getString("学校有线视频网络情况")%></div></td>
           </tr>
         </table></td>
       </tr>
       <tr>
         <td height="31" colspan="4"><table width="757" height="34" border="1" cellpadding="0" cellspacing="0">
           <tr>
             <td width="102"> <div align="center" class="style1">校园一卡通的应用及实施情况 </div></td>
             <td width="649"><div align="center"><%=rs.getString("学校一卡通的应用情况")%></div></td>
           </tr>
         </table></td>
       </tr>
</table>
<%}}}
 else{%>
<table width="350" border="1">
  
  <%while(rs.next())
  { 
  for(i=1;i<=cols;i++)
   {String z=rs.getString(i);
   if(z==null)
   {z="无信息";}
   %>
   <tr>
    <td><div align="center" class="style1"><%=rmd.getColumnLabel(i)%></div></td>
    <% if(z.length()<300)
{%>
<td><div align="center"><%=z%></div></td>
<%}
else
{%>
<td><img src="showpic.jsp?mc=<%=xx%>&bn=<%=bm%>&zd=<%=rmd.getColumnLabel(i)%>"width="350" height="450"></td>
<%}
        } %>
  </tr>
  <%}%>
</table>
<%}%>

</p>
<%}
   catch(SQLException e1)
   {out.print("SQL语句错误" +e1);}
   %></body>
</html>     完了！！！！！！！！！！！！

Answer 2

FT，我是说把showpic.jsp的代码贴出来，不是这个显示信息的。<meta http-equiv="Content-Type" content="image/jpeg"; charset=gb2312">
这个页面上的ContentTYpe不需要改成这样。

Answer 3

<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<%@ page import="java.util.*"%> 
<%@ page import="java.text.*"%> 
<%@ page import="java.io.*"%> 
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>无标题文档</title>
</head>
<%
String xx=request.getParameter("mc");
 
   if(xx==null)
   {xx="?";}
   byte b[] =xx.getBytes("ISO-8859-1");
   xx=new String(b);
   
   String bm=request.getParameter("bn");
   if(bm==null)
   {bm="a";}
   byte c[] =bm.getBytes("ISO-8859-1");
   bm=new String(c);   String zd=request.getParameter("zd");
   byte d[] =zd.getBytes("ISO-8859-1");
   zd=new String(d);
      Connection con =null; 
   Statement sql=null;
   ResultSet rs =null;
   try{Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");}
   catch(ClassNotFoundException e)
   {out.print("数据库建桥失败");} con =DriverManager.getConnection("jdbc:odbc:pc","","");
        sql=con.createStatement();
        String condition ="select * from "+ bm + " where 学校名称=" + "'"+ xx+"'";
rs=sql.executeQuery(condition); byte[] Buffer=new byte[1024*10];
InputStream InData=null;
OutputStream outData=null;
int iSize;
if(rs.next())
{
outData=response.getOutputStream();
InData=rs.getBinaryStream(zd);
response.setContentType("image/jpg");
while(true)
{
iSize=InData.read(Buffer);
if(iSize==-1)
{
break;
}
outData.write(Buffer,0,iSize);
}
outData.flush();
response.flushBuffer();
}
rs.close();
%>
<body></body>
</html>

Answer 4

换成下面这样，多于的全部不要，还有你要把Connection连接关一下，你没有关。<%@ page import="java.util.*"%> 
<%@ page import="java.text.*"%> 
<%@ page import="java.io.*"%> 
<%
String xx=request.getParameter("mc");
 
   if(xx==null)
   {xx="?";}
   byte b[] =xx.getBytes("ISO-8859-1");
   xx=new String(b);
   
   String bm=request.getParameter("bn");
   if(bm==null)
   {bm="a";}
   byte c[] =bm.getBytes("ISO-8859-1");
   bm=new String(c);   String zd=request.getParameter("zd");
   byte d[] =zd.getBytes("ISO-8859-1");
   zd=new String(d);
      Connection con =null; 
   Statement sql=null;
   ResultSet rs =null;
   try{Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");}
   catch(ClassNotFoundException e)
   {out.print("数据库建桥失败");} con =DriverManager.getConnection("jdbc:odbc:pc","","");
        sql=con.createStatement();
        String condition ="select * from "+ bm + " where 学校名称=" + "'"+ xx+"'";
rs=sql.executeQuery(condition); byte[] Buffer=new byte[1024*10];
InputStream InData=null;
OutputStream outData=null;
int iSize;
if(rs.next())
{
outData=response.getOutputStream();
InData=rs.getBinaryStream(zd);
response.setContentType("image/jpg");
while(true)
{
iSize=InData.read(Buffer);
if(iSize==-1)
{
break;
}
outData.write(Buffer,0,iSize);
}
outData.flush();
response.flushBuffer();
}
rs.close();
%>