谁来帮帮小弟我
日期：2014-05-18 浏览次数：20575 次
谁来帮帮我
我现在编的JSP遇到一个问题请高手们再帮我看看，这个程序是将符合某些条件的员工信息显示出来并可以王成修改或删除的操作，但每次运行时总报错（错误信息：Error 500: No data found ）错误应该在修改和删除功能的实现上，因为我把这两个功能去掉后就正确了，但是我现在还想保留这两个功能，却不知道怎样改，希望哪位高手能再帮我看看。源代码如下：
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN ">
<HTML>
<HEAD>
<%@ page
language= "java "
contentType= "text/html; charset=GB18030 "
pageEncoding= "GB18030 "
import= "java.sql.* "
%>
<META http-equiv= "Content-Type " content= "text/html; charset=GB18030 ">
<META name= "GENERATOR " content= "IBM WebSphere Studio ">
<META http-equiv= "Content-Style-Type " content= "text/css ">
<LINK href= "../theme/Master.css " rel= "stylesheet "
type= "text/css ">
<TITLE> rewardfindFinally.jsp </TITLE>
</HEAD>
<BODY background= "../image/body.gif ">
<jsp:useBean id= "connectdatabase " class= "dbms.Database "/>
<%
String rewardID=new String(request.getParameter( "rewardID ").getBytes( "ISO8859_1 "), "GBK ");
String rewardpunish=new String(request.getParameter( "rewardpunish ").getBytes( "ISO8859_1 "), "GBK ");
String employerID=new String(request.getParameter( "employerID ").getBytes( "ISO8859_1 "), "GBK ");
String employerName=new String(request.getParameter( "employerName ").getBytes( "ISO8859_1 "), "GBK ");
String reson=new String(request.getParameter( "reson ").getBytes( "ISO8859_1 "), "GBK ");
String handlename=new String(request.getParameter( "handlename ").getBytes( "ISO8859_1 "), "GBK ");
rewardID= "% "+rewardID+ "% ";
employerID= "% "+employerID+ "% ";
employerName= "% "+employerName+ "% ";
reson= "% "+reson+ "% ";
handlename= "% "+handlename+ "% ";
String sql= "select * from pertable where rewardID LIKE ' "+rewardID+ " 'and rewardpunish LIKE ' "+rewardpunish+ " 'and employerID LIKE ' "+employerID+ " 'and employerName LIKE ' "+employerName+ " 'and reson LIKE ' "+reson+ " 'and handlename LIKE ' "+handlename+ " '; ";
ResultSet rs=connectdatabase.excute(sql);
%>
<TABLE border= "0 " width= "828 ">
<TBODY>
<TR>
<TD colspan= "3 " align= "center "> <jsp:include page= "../head.jsp "
flush= "true " /> </TD>
</TR>
<TR>
<TD> <jsp:include page= "../reward/rewardleft.jsp " />
我现在编的JSP遇到一个问题请高手们再帮我看看，这个程序是将符合某些条件的员工信息显示出来并可以王成修改或删除的操作，但每次运行时总报错（错误信息：Error 500: No data found ）错误应该在修改和删除功能的实现上，因为我把这两个功能去掉后就正确了，但是我现在还想保留这两个功能，却不知道怎样改，希望哪位高手能再帮我看看。源代码如下：
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN ">
<HTML>
<HEAD>
<%@ page
language= "java "
contentType= "text/html; charset=GB18030 "
pageEncoding= "GB18030 "
import= "java.sql.* "
%>
<META http-equiv= "Content-Type " content= "text/html; charset=GB18030 ">
<META name= "GENERATOR " content= "IBM WebSphere Studio ">
<META http-equiv= "Content-Style-Type " content= "text/css ">
<LINK href= "../theme/Master.css " rel= "stylesheet "
type= "text/css ">
<TITLE> rewardfindFinally.jsp </TITLE>
</HEAD>
<BODY background= "../image/body.gif ">
<jsp:useBean id= "connectdatabase " class= "dbms.Database "/>
<%
String rewardID=new String(request.getParameter( "rewardID ").getBytes( "ISO8859_1 "), "GBK ");
String rewardpunish=new String(request.getParameter( "rewardpunish ").getBytes( "ISO8859_1 "), "GBK ");
String employerID=new String(request.getParameter( "employerID ").getBytes( "ISO8859_1 "), "GBK ");
String employerName=new String(request.getParameter( "employerName ").getBytes( "ISO8859_1 "), "GBK ");
String reson=new String(request.getParameter( "reson ").getBytes( "ISO8859_1 "), "GBK ");
String handlename=new String(request.getParameter( "handlename ").getBytes( "ISO8859_1 "), "GBK ");
rewardID= "% "+rewardID+ "% ";
employerID= "% "+employerID+ "% ";
employerName= "% "+employerName+ "% ";
reson= "% "+reson+ "% ";
handlename= "% "+handlename+ "% ";
String sql= "select * from pertable where rewardID LIKE ' "+rewardID+ " 'and rewardpunish LIKE ' "+rewardpunish+ " 'and employerID LIKE ' "+employerID+ " 'and employerName LIKE ' "+employerName+ " 'and reson LIKE ' "+reson+ " 'and handlename LIKE ' "+handlename+ " '; ";
ResultSet rs=connectdatabase.excute(sql);
%>
<TABLE border= "0 " width= "828 ">
<TBODY>
<TR>
<TD colspan= "3 " align= "center "> <jsp:include page= "../head.jsp "
flush= "true " /> </TD>
</TR>
<TR>
<TD> <jsp:include page= "../reward/rewardleft.jsp " />
免责声明： 本文仅代表作者个人观点，与爱易网无关。其原创性以及文中陈述文字和内容未经本站证实，对本文以及其中全部或者部分内容、文字的真实性、完整性、及时性本站不作任何保证或承诺，请读者仅作参考，并请自行核实相关内容。
