<%@ page contentType="text/html; charset=Shift_JIS" language="java" import="java.sql.*"%><%
//Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
String url="jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ=webapps/info/data/base.mdb";
Connection conn=DriverManager.getConnection(url);
Statement stmt = conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
String id=request.getParameter("id");
String sql="select * from info";
ResultSet rs=stmt.executeQuery(sql);
while(rs.next()){
if(!rs.getString("id").equals(id)){
response.sendRedirect("info_02.jsp");
}else{
out.print("<script>");
out.print("alert('lee000000000000。');");
out.print("history.back();");
out.print("</script>");
}
}
if(conn!=null) {
conn.close();
}
if(stmt!=null) {
stmt.close();}%>
所有的空格回车都取了,还是报错,就是response.sendRedirect("info_02.jsp");有错,大家帮忙看看java.lang.IllegalStateException
org.apache.catalina.connector.ResponseFacade.sendRedirect(ResponseFacade.java:432)
org.apache.jsp.post_jsp._jspService(post_jsp.java:53)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:334)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
//Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
String url="jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ=webapps/info/data/base.mdb";
Connection conn=DriverManager.getConnection(url);
Statement stmt = conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
String id=request.getParameter("id");
String sql="select * from info";
ResultSet rs=stmt.executeQuery(sql);
while(rs.next()){
if(!rs.getString("id").equals(id)){
response.sendRedirect("info_02.jsp");
}else{
out.print("<script>");
out.print("alert('lee000000000000。');");
out.print("history.back();");
out.print("</script>");
}
}
if(conn!=null) {
conn.close();
}
if(stmt!=null) {
stmt.close();}%>
所有的空格回车都取了,还是报错,就是response.sendRedirect("info_02.jsp");有错,大家帮忙看看java.lang.IllegalStateException
org.apache.catalina.connector.ResponseFacade.sendRedirect(ResponseFacade.java:432)
org.apache.jsp.post_jsp._jspService(post_jsp.java:53)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:334)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
解决方案 »
- Flex融合Jsp问题 请大家进来看看
- 急急急死了!关于request.getRemoteAddr()和request.getRemoteHost()的问题
- jsp页面自动刷新
- 给大家推荐一个专业的在线网站设计工具,功能和扩展性远超过Msn Space
- 提示javax.servlet包不存在,该包在哪?
- 奶奶的,我在503room.com下载了一个新闻程序,出错?各位有空看看?
- 初学jsp,问:怎么进行网站前期规划?
- 乱码这种情况,有没有一劳永逸的方法呢??
- 我想要一个现成的论坛代码,数据库是用oracle的
- 在网页中打开word文档的问题
- 连接数据库
- Java applet中用鼠标移到窗口上才能显示按钮 这是咋回事
这个语句会返回多条记录么?
lz你要判断多次么?如果不是,那个while改成if
sendRedirect语句后面加上return;
中间这一段最好加上try{}finally{}
把关闭连接的放到finally{}中
sendRedirect之后没有return
会继续执行
到下一个值再次sendRedirect,这样就会抛IllegalStateException的错了