第一个页面 while(rs.next())
{
out.print("<tr>");
out.print(" <td height='26'><input type='checkbox' name='checkbox' value='rs.getInt(1)'></td>");
out.print(" <td height='30'>"+rs.getString(2)+"</td>");
out.print(" <td >"+rs.getInt(3)+"</td>");
out.print(" <td >"+rs.getString(4)+"</td>");
out.print(" <td >"+rs.getInt(5)+"</td>");
out.print("</tr>");
}
第二个页面
<%
try
{
Connection con;
Statement sql;
String sqlString=null;
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
con=DriverManager.getConnection("jdbc:odbc:cwgl","sa","123");
sql=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
String[]s=request.getParameterValues("checkbox"); for(int i=0;i<s.length;i++)
{
int n=Integer.parseInt(s[i]);
sqlString="delete from sbgl where id="+n;
sql.executeUpdate(sqlString);
}
con.close();
}
catch(SQLException e)
{
out.print("sql异常"); }
%>
错误提示::
exception org.apache.jasper.JasperException
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:372)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
root cause java.lang.NullPointerException
org.apache.jsp.shanchu_jsp._jspService(shanchu_jsp.java:68)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:324)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)各位大侠 帮忙啊
{
out.print("<tr>");
out.print(" <td height='26'><input type='checkbox' name='checkbox' value='rs.getInt(1)'></td>");
out.print(" <td height='30'>"+rs.getString(2)+"</td>");
out.print(" <td >"+rs.getInt(3)+"</td>");
out.print(" <td >"+rs.getString(4)+"</td>");
out.print(" <td >"+rs.getInt(5)+"</td>");
out.print("</tr>");
}
第二个页面
<%
try
{
Connection con;
Statement sql;
String sqlString=null;
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
con=DriverManager.getConnection("jdbc:odbc:cwgl","sa","123");
sql=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
String[]s=request.getParameterValues("checkbox"); for(int i=0;i<s.length;i++)
{
int n=Integer.parseInt(s[i]);
sqlString="delete from sbgl where id="+n;
sql.executeUpdate(sqlString);
}
con.close();
}
catch(SQLException e)
{
out.print("sql异常"); }
%>
错误提示::
exception org.apache.jasper.JasperException
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:372)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
root cause java.lang.NullPointerException
org.apache.jsp.shanchu_jsp._jspService(shanchu_jsp.java:68)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:324)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)各位大侠 帮忙啊
rs怎么来的~~代码贴上来~~估计就是rs是空的~~~~
String[]s=request.getParameterValues("checkbox"); for(i=0;i<s.length;i++)
{
int n=Integer.parseInt(s[i]);
sqlString="delete from sbgl where id="+n;
sql.executeUpdate(sqlString);
}好像s.length 这个有问题??
String[]s=request.getParameterValues("checkbox"); for(i=0;i<3;i++)
{
sqlString="delete from sbgl where id="+i;
sql.executeUpdate(sqlString);
}
把代码改成这个样子,可以运行 ,错误在哪里呀 ,求救
可能是s字符串数组里有个值为null,检查看看!
数组为空或里面有为空的值
我用这个输出试验了一下,有问题,但是什么问题,我想不通