加分
我有个查询是这样做的
sql.jsp为:
public String getStr(String str)
{
try
{
String temp_p=str;
byte[] temp_t=temp_p.getBytes("gb2312");
String temp=new String(temp_t,"ISO8859-1");
return temp;
}
catch(Exception e)
{
e.printStackTrace();
}
return "null";
}
%>
bgcolor="#3399ff"> <font color="#ff0000" size=4>查 询 投 诉 信 息</font>
</td>
</tr>
<tr>
<td width="100%" align="center" colspan="4" height="36"><b> 注:按时间查询时输入开始时间和结束时间格式必须为:2003-03-08</b> </td>
</tr>
<form name="form1" method="post" action="sql_ok.jsp">
<tr>
<td align="right">请输入投诉开始时间:</td>
<td> </td>
<td colspan="2">
<input type="text" name="tousu_start_date" value="2003-01-01">
</td>
</tr>
<tr>
<td align="right">请输入投诉结束时间:</td>
<td> </td>
<td colspan="2">
<input type="text" name="tousu_end_date" value="2003-02-01">
</td>
</tr>
<tr>
<td align="right">投诉部门:</td>
<td> </td>
<td colspan="2">
<select name=depart size=1>
<option value="all" selected>全部</option>
<option value="xx">xx</option>
<option value="xx">xx</option>
<option value="其他">其他</option>
</select>
</td>
</tr>
<tr>
<td align="right">投诉业务类别:</td>
<td> </td>
<td colspan="2">
<select name=tousu_class size=1>
<option value="null" selected>全部</option>
<option value="17901">17901</option>
<option value="其他">其他</option>
</select>
</td>
</tr>
<tr>
<td align="right">投诉情况描述:</td>
<td> </td>
<td colspan="2">
<input type="text" name="details" value="卡号和密码不对">
</td>
</tr>
<tr>
<td align="right">处理情况:</td>
<td> </td>
<td colspan="2">
<select name=handle size=1>
<option value="null" selected>全部</option>
<option value="已处理">已处理</option>
<option value="正在处理">正在处理</option>
<option value="无法处理">无法处理</option>
<option value="未处理">未处理</option>
<option value="其他">其他</option>
</select>
</td>
</tr>
<tr>
<td align="right">处理人:</td>
<td> </td>
<td colspan="2">
<select name=person size=1>
<option value="null" selected>全部</option>
<option value="哥哥">哥哥</option>
<option value="啊啊">啊啊</option>
<option value="其他">其他</option>
</select>
</td>
</tr>
<br>
<br>
<tr>
<td align="left"> </td>
<td> </td>
<td align="left" colspan="2">
<input type="submit" value="开始搜索">
<input type="reset" value="重填">
</td>
</tr>
</form>
</table>
</td>
</tr>
</table>
<table>
<tr>
<td>
<%@ include file="footer.inc"%>
</td>
</tr>
</table>
</html>
sql_ok.jsp为:
<%@ include file="head.jsp"%>
<%@ page language="java" import="java.sql.*" %>
<jsp:useBean id="workM" scope="page" class="Show.DBconn" />
<%!
public String getStr(String str)
{
try
{
String temp_p=str;
byte[] temp_t=temp_p.getBytes("gb2312");
String temp=new String(temp_t,"ISO8859-1");
return temp;
}
catch(Exception e)
{
e.printStackTrace();
}
return "null";
}
%>
</tr>
<table border="0" width="100%" cellspacing="0" cellpadding="0">
<tr>
<td width="10%" height="20" bgcolor="#3399ff"><font color="Red">投诉类别</font>
</td>
<td width="15%" height="20" bgcolor="#3399ff"> <font color="Red">投诉时间</font>
</td>
<td width="15%" height="20" bgcolor="#3399ff"><font color="Red">投诉部门</font>
</td>
<td width="10%" height="20" bgcolor="#3399ff"> <font color="Red">处理情况</font>
</td>
<td width="10%" height="20" bgcolor="#3399ff"> <font color="Red">处理人</font>
</td>
<td width="10%" height="20" bgcolor="#3399ff"> <font color="Red">详情</font>
</td>
</tr>
<ul>
<%
String tousu_start_date1,tousu_end_date1,depart1,details1,handle1,person1,tousu_class1;
String strSQL="";
tousu_start_date1=request.getParameter("tousu_start_date");
tousu_end_date1=request.getParameter("tousu_end_date");
depart1=request.getParameter("depart.value");
details1=request.getParameter("details");
handle1=request.getParameter("handle.value");
person1=request.getParameter("person.value");
tousu_class1=request.getParameter("tousu_class.value");
strSQL="select * FROM data where";
strSQL=strSQL+"tousu_class = '"+tousu_class1+"' and ";
strSQL=strSQL+"depart = '"+depart1+"' and ";
strSQL=strSQL+"handle = '"+handle1+"' and ";
strSQL=strSQL+"details = '"+details1+"' and ";
strSQL=strSQL+"person = '"+person1+"' and ";
strSQL=strSQL+"tousu_date between #"+tousu_start_date1+"# and #"+tousu_end_date1+"# order by tousu_date desc";
ResultSet RSa = workM.executeQuery(strSQL);
int searchnum;
searchnum=0;
while (RSa.next()) {
String tousu_class,depart,handle,details,person,tousu_date;
int id;
id=RSa.getInt("id");
tousu_class=getStr(RSa.getString("tousu_class"));
tousu_date=getStr(RSa.getString("tousu_date"));
//tousu_date=RSa.getDate("tousu_date");;
depart=getStr(RSa.getString("depart"));
handle=getStr(RSa.getString("handle"));
details=getStr(RSa.getString("details"));
//details=details.substring(2,10);
person=getStr(RSa.getString("person"));
out.println("<td> "+tousu_class+" </td>");
out.println("<td> "+tousu_date.substring(0,10)+" </td>");
out.println("<td> "+depart+" </td>");
out.println("<td> "+handle+" </td>");
out.println("<td> "+person+" </td>");
//out.println("<td> "+details+" </td>");
out.println("<td><a href=javascript:show('data.jsp?id="+id+"','详细资料',800,600)>详情</a></td>");
out.println("</tr>");
searchnum=searchnum+1;
}
//sout.println("strSQL");
RSa.close();
out.println("</ul>");
out.println("共搜索到<b><font color=Red>"+searchnum+"</font></b>条纪录");
%>
<script language="javascript">
function show(mylink,mytitle,width,height){
mailwin=window.open(mylink,mytitle,'top=60,left=50,width='+width+',height='+height+',scrollbars=yes');
}
</script>
</td>
<td width="1%"></td>
</tr>
</table>
</td>
</tr>
</table>
<%@ include file="footer.inc"%>
</html>
但是执行是总是报什么from子句出错是怎么回事情,高手指点