用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>
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>
如果删除了没有成功,肯定是没有提交到数据库检查sql语句执行了吗?一步一步查