用jsp选择了删除数据后,使数据不会出现在jsp页面和数据库中,也就是要更新数据,各位大侠该怎么做?谢谢!!
index.jsp
<%@ page language="java" import="java.sql.*" pageEncoding="gb2312"%>
<html>
  <body>
    <div align="center"><%
    Connection con;
    Statement sql;
    ResultSet rs;
    try{
    Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
    }
    catch(ClassNotFoundException e){out.print("类找不到!");
    out.print(e);
    }
    try{
    con=DriverManager.getConnection("jdbc:sqlserver://localhost:1433;DatabaseName=user","sa","11011");
    sql=con.createStatement();
    rs=sql.executeQuery("select * from userTable");
    int row=rs.getRow();
    out.print("<table border>");
    out.print("<tr><td colspan=8 align=center>用户数据(共"+row+"条数据)</td></tr>");
    out.print("<tr>");
    out.print("<td width=100>"+"用户id号");
    out.print("<td width=100>"+"用户姓名");
    out.print("<td width=100>"+"用户年龄");
    out.print("<td width=100>"+"用户性别");
    out.print("<td width=100>"+"删除");
    out.print("</tr>"); 
    while(rs.next()){
    out.print("<tr>");
    out.print("<td>"+rs.getInt(1)+"</td>");
    out.print("<td>"+rs.getString(2)+"</td>");
    out.print("<td>"+rs.getInt(3)+"</td>");
    out.print("<td>"+rs.getString(4)+"</td>");
    out.print("<td><a href ='deleteuser.jsp?userid="+rs.getInt(1)+"'>x</a></td>");
    out.print("</tr>");
    }
    out.print("</table>");
    con.close();
    }
    catch(SQLException ee){
    out.print(ee);
    }
     %>  
<br> 
  </div></body>
</html>*******************
deleteuser.jsp
<%@ page language="java" import="java.sql.*" pageEncoding="gb2312"%>
<html>
  <head>   
    <title>用户删除程序</title>  
  </head>
  <body>
<a href="index.jsp">返回首页</a><br>
<%  //接受要删除的用户ID号
int userid;
try{
userid=Integer.parseInt(request.getParameter("id"));
}
catch(Exception e){
userid=0;
}
 %><%String sqlString=null;
if(userid!=0) //接收的参数正确
{
sqlString="delete from userTable where userid="+userid;
    Connection con;
    Statement sql;
   
    try{
    Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
    }
   catch(ClassNotFoundException e){out.print("类找不到!");
    out.print(e);
    }
    try{
    con=DriverManager.getConnection("jdbc:sqlserver://localhost:1433; DatabaseName=user","sa","11011");
    sql=con.createStatement();
   sql.executeUpdate(sqlString);
   sql.close();
    con.close();   
    }
    catch(SQLException e1){out.print(e1);
    }
    
    }
    %>
<center>
<table border="1" width="700">
<tr><td width="100%" align="center">删除用户程序</td>
</tr>
<tr><td width="100%" >删除用户成功</td>
</tr>
</table>
</center>
 <br>
  </body>
</html>