jsp 时间段查询数据库连接请教~改改

小弟 初学，很多地方不是很精通。，。不到之处请见谅。。
下面是我写的JSP页面。。就是 时间段的 数据库连接有点问题。。
实在不懂。。想请这里的大哥 帮助下。。写写。。小弟在此谢过。。如能过关 。。再来答谢
就是读取数据库的信息 不是很懂。。望帮助下。。

HTML code

  <TABLE cellSpacing=0 cellPadding=0 width="100%" border=0>
        <TBODY>                                            
        <TR>                            
          <TD height=60>                
            <table width="99%" border="0" align="center">
              <tr>                                                    
                <td width="69">时间查询：</td>                            
                <td width="80"><span class="style_font01">
                  <select   name= "statistic "   id= "statistic "   onchange= "a(this)">
                    <option   value= "1"> 输入日期查询 </option>
                    <option   value= "2"> 按月查询 </option>
                    <option   value= "3"> 按年查询 </option>
                    <option   value= "4"> 历年查询 </option>
                  </select>
                </span></td>
                <td width="39" nowrap>日期：</td>
                <td width="60"><span class="style_font01">
                  <input name="text" type="text" class="Wdate" id="d5221" onFocus="var d5222=$dp.$('d5222');WdatePicker({onpicked:function(){d5222.focus();},maxDate:'#F{$dp.$D(\'d5222\')}'})" size="8.5"/>
                  <select   name="MMfrom"  style='display:none'  onchange= "MMDD(this.value) ">
                    <option   value= " ">选择 月</option>
                  </select>    
                  <select   name="YYYYfrom"  style='display:none' onchange= "YYYYDD(this.value) ">
                    <option   value= " ">请选择 年</option>
                  </select>
                </span></td>
 <td width="73"><span class="style_font01">关键字查询：</span></td>
  <td width="50"><span class="style_font01">                    
                  <INPUT class=style_box size=7 name=zone>
                </span></td>                                                                            
                <td width="44" align="center">                        
                  <input name="submit" type="submit" class=style_but_t2 value="查 询"></td>
                <td width="44">                                                        
                  <input name="reset" type="reset" class=style_but_t2 value="重 置"></td>
              </tr>
            </table>           
 <br>   
 <tr>            
               <td>
                    <%                                     
                            Connection conn=null;
                            Statement stmt=null;    
                            ResultSet rs=null;             
                            try{                    
                            String sql="省略";
                            //System.out.println(sql);    
                            Class.forName("oracle.jdbc.driver.OracleDriver");
                            conn = DriverManager.getConnection("省略");            
                            stmt = conn.createStatement();
                                                            
                            rs=stmt.executeQuery(sql);        
                                                            
                            String date="";                    
                            String unit="";
                            String num="";
                            String no="";                    
                            String ywabstract="";
                            while (rs.next())                
                             {                                
                                unit=rs.getString(1);
                                ywabstract=rs.getString(2);
                                no=rs.getString(3);            
                                num=rs.getString(4);
                                date=rs.getString(5)+"-"+rs.getString(6);
                                
                                out.print("<table width='99%' border='0' align='center' cellpadding='0' cellspacing='0>");
                                out.print("<td width='20%' class='style_font02'>");
                                out.print("<td width='20%' class='style_font02'>");
                                out.print(date);
                                out.print("</td>");
                                out.print("<td width='20%' class='style_font02'>");
                                out.print(unit);
                                out.print("</td>");
                                out.print("<td width='10%' class='style_font02' style='text-align:center'>");
                                out.print(num);
                                out.print("</td>");
                                out.print("<td  width='10%' class='style_font02' style='text-align:center'>");
                                out.print(no);
                                out.print("</td>");
                                out.print("<td width='40%' class='style_font03' style='text-align:center'>");
                                out.print(ywabstract);
                                out.print("</td>");
                                out.print("</td>");
                                out.print("</table>");
                             }    
                               
                            }catch(Exception e){                  
                                 e.printStackTrace();                   
                            } 
                        %>                    </td>
                </tr>

显示什么错误呢，你应该说具体点，把问题和你的目的描述应该尽量详细。我们看的时候可以顺藤摸瓜，你这样写的话，我们还得从头看。