为什么一直提示错误？？！！（JSP）
<%@ page language="java" import="java.util.*,ex8.common.*" pageEncoding="UTF-8"%>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<base href="<%=basePath%>">
<title>My JSP 'subjectList.jsp' starting page</title>
<meta http-equiv="pragma" content="no-cache">
<meta http-equiv="cache-control" content="no-cache">
<meta http-equiv="expires" content="0">
<meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
<meta http-equiv="description" content="This is my page">
<!--
<link rel="stylesheet" type="text/css" href="styles.css">
-->
<meta http-equiv="Content-Type" content="text/html; charset=utf-8"><style type="text/css">
<!--
body,td,th {
font-size: 12px;
}
-->
</style></head>
<body>
<div>
<table width="200" border="0" cellpadding="0" cellspacing="0">
<tr>
<td>欢迎进入选题系统！</td>
</tr>
<tr>
<td>现在时间：</td>
</tr>
</table>
</div>
<form action="" method="post">
<table width="645" height="23" border="1" cellpadding="0" cellspacing="0" bordercolor="#CC9900">
<tr>
<td width="115" bgcolor="#CC9900">组合查询条件：</td>
<td width="234">查找关键词
<label>
<input type="text" name="keyWords" id="textfield" value="<%=request.getParameter("keyWords")%>"/>
</label></td>
<td width="192" valign="middle">查找条件
<select name="order" id="order">
<option value="desc" <%if ("desc".equals(request.getParameter("order"))){out.print("selected='selected'");}%>>按时间降序排列</option>
<option value="asc" <%if ("asc".equals(request.getParameter("order"))){out.print("selected='selected'");}%>>按时间升序排列</option>
</select></td>
<td width="94"><label>
<input type="submit" name="button" id="button" value="提交">
</label></td>
</tr>
</table>
</form>
<form action="" method="post"><table width="645" height="44" border="1" cellpadding="0" cellspacing="0" bordercolor="#CC9900">
<tr>
<td align="center" bgcolor="#CC9900"> </td>
<td align="center" bgcolor="#CC9900">题目序号</td>
<td align="center" bgcolor="#CC9900">题目名称</td>
<td align="center" bgcolor="#CC9900">发布时间</td>
<td align="center" bgcolor="#CC9900">操作</td>
</tr>
<%
String keyWords = request.getParameter("keyWords");
String order = request.getParameter("order");
String str = "";
if("desc".equals(order))
{
str ="order by dtmSubDatetime desc";
}else if("asc".equals(order))
{
str="order by dtmSubDatetime asc";
}else
{
str ="order by dtmSubDatetime desc";
}
String sqlText="select * from subject where chrSubTitle like'%"+keyWords+"%' "+str;
out.print(sqlText);
MySQL conn = new MySQL();
ResultSet rs = conn.executeQuery(sqlText);
int i = 1;
while(rs.next())
{%>
<tr>
<td align="center"><label>
<input type="checkbox" name="checkbox" id="checkbox">
</label></td>
<td align="center"><%=i++ %></td>
<td align="center"><%=rs.getString(2) %></td>
<td align="center"><%=rs.getString(4) %></td>
<td align="center">删除|编辑</td>
</tr>
<%}
conn.close();
%>
</table>
<table width="646" border="0" cellpadding="0" >
<tr>
<td width="636" align="center">
<label>
<input type="submit" name="button2" id="button2" value="删除">
</label></td>
</tr>
</table>
</form>
</body>
</html>
[解决办法]
"+keyWords+"%' "+
改为
"+keyWords+"%'"+ 看看是不是英文的’
还有在看看你连接是不是为空
[解决办法]
rs.hasnext();试试
