MyException - 我的异常网
当前位置:我的异常网» Java Web开发 » 来看段代码,目前小弟我在维护,呵呵

来看段代码,目前小弟我在维护,呵呵(4)

www.MyException.Cn  网友分享于:2015-08-27  浏览:12次

<tr   bgcolor= "CEDDF0 ">
                    <td   width= "20% "> <div   align= "center "> 分部 </div> </td>
                    <td>   <div   align= "center "> 预算金额(单位:元) </div> </td>
                </tr>
<%
if(! " ".equals(pid)&&pid!=null){
if(! " ".equals(branid)&&branid!=null){
rs=stmt.executeQuery( "select   a.branchdeptid,b.branchdeptname,fee   from   ty_pfeereserve   a,ts_branchdept   b   where   a.areaid= "+aid+ "   and   a.branchdeptid=b.branchdeptid     and   year= ' "+year+ " '   and   b.branchdeptlevel= '2 '   and   upbranchdeptid= "+branid+ "   and   a.branchdeptid!= "+null);
}else{
rs=stmt.executeQuery( "select   a.branchdeptid,b.branchdeptname,fee   from   ty_pfeereserve   a,ts_branchdept   b   where   a.areaid= "+aid+ "   and   a.branchdeptid=b.branchdeptid     and   year= ' "+year+ " '   and   b.branchdeptlevel= '1 '   and   b.upbranchdeptid=null   and   a.branchdeptid!= "+null);
}

}


while(rs.next()){


%>
          <tr   bgcolor= "#FFFFFF ">
        <td   width= "20% "> <div   align= "center "> <%

rset   =   st.executeQuery( "select   branchdeptid   from   ts_branchdept   where   upbranchdeptid= "+rs.getString(1));
if(rset.next()){

out.println( " <a   href= 'feeupdate_project.jsp?year= "+year+ "&pid= "+pid+ "&branid= "+rs.getString(1)+ " '> "+Utility.chgGBK(rs.getString(2))+ " </a> ");

}else{
out.println(Utility.chgGBK(rs.getString(2)));
}
rset.close();
rset=null;
%> </div> <input   type= "hidden "   name= "bid "   value= " <%=rs.getString(1)%> "> </td>
                <td> <div   align= "center "> <input   type= 'text '   size= '20 '   class= 'stedit '   name= 'cbudgetfee '     onkeyup= "value=value.replace(/[^\d.]/g, ' ')   "onbeforepaste= "clipboardData.setData( 'text ',clipboardData.getData( 'text ').replace(/[^\d.]/g, ' ')) "   value= " <%=rs.getString(3)%> "> </div> </td>

                </tr>
        <%}
rs.close();
rs=null;
%>
        </table>   </td>
    </tr>
  </td>
    </tr>


<%}%>
</form>


<%
rs=null;

st.close();

------解决方案--------------------
沙发
这么长??
------解决方案--------------------
学习!
------解决方案--------------------

文章评论

软件开发程序错误异常ExceptionCopyright © 2009-2015 MyException 版权所有