delstudent.java

基于jsp的图书管理系统的功能和实现

import javax.servlet.*;
import javax.servlet.http.*;
import java.io.*;
import java.util.*; 
import java.sql.*;
import data.LoginData;
public class DelStudent extends HttpServlet{
	private static final String CONTENT_TYPE="text/html;charset=GBK";
	public void doPost(HttpServletRequest request,HttpServletResponse response)
	throws ServletException,IOException{
		String strSql=null;
		String stautes=null;
		ResultSet rs=null;
		Statement stmt=null;
		int result=0;
		request.setCharacterEncoding("GBK");
    	String Rnumber =null;
		HttpSession session =request.getSession(false);
         if(session==null)
        {
         response.sendRedirect("tushu/error.jsp");
         return;
        }
        Rnumber=(String)session.getAttribute("Rnum");
		LoginData loginData = new LoginData();
		Connection conn = loginData.getConn();
        try{
             stmt = conn.createStatement();
             strSql="delete from Reader where Rnumber='"+Rnumber+"'";
   			 result=stmt.executeUpdate(strSql);
		     if(result>0){
			   	  	      stautes ="删除成功!";
			   	  	      session.setAttribute("Modify",stautes);
			   		   	  response.sendRedirect("tushu/DelStudent_Success.jsp");
			   		     }
			   		else 
			   		  {        stautes ="删除失败,系统问题,请下次删除!";
			   		  	       session.setAttribute("Modify",stautes);
			   		    	  response.sendRedirect("tushu/DelStudent_Success.jsp");	
			   		  }
			   
		   }catch(Exception ex){
		   	ex.printStackTrace();
		   	}
		
		}
		public void destroy(){
			}
	
	}