goodsdel.java

jsp超市管理系统系统,是用经典的MVC设计模式开发的非常适合初学者学习。

package com.myservlet.goods;

import java.io.*;
import java.sql.*;
import javax.servlet.*;	
import javax.servlet.http.*;

import com.dbconn.*;


public class GoodsDel extends HttpServlet{

	/**
	 * 
	 */
	private static final long serialVersionUID = -7616972735827785646L;
	   
	public void doPost(HttpServletRequest request, HttpServletResponse response)
		throws ServletException, IOException {
		performTask(request, response);
	}

	public void doGet(HttpServletRequest request, HttpServletResponse response)
		throws ServletException, IOException {
		performTask(request, response);
	}
	
	private synchronized void performTask(HttpServletRequest request, HttpServletResponse response)
		throws ServletException, IOException{
        
		String id[] = request.getParameterValues("delete");

		ConnManager connManager = new ConnManager();
		Connection conn = connManager.getConnection("market");		
		PreparedStatement ps = null;
		
		int m = 0;
		
		try{
			for(int i = 0;i < id.length;i++){			
				String sql="DELETE FROM goods WHERE id='"+id[i]+"'";
				sql = new String(sql.getBytes("ISO-8859-1"), "gbk");
				ps = conn.prepareStatement(sql);			
				m = ps.executeUpdate();
			}
			if(m != 0){
				request.getSession(true).setAttribute("message2", "删除成功！");
			}
			else{
				request.getSession(true).setAttribute("message2", "删除失败！");
			}
		}
		catch(SQLException e){
			System.out.println(e);
			request.getSession(true).setAttribute("message2", "删除失败！");
		}
		finally{
			try{
				ps.close();
				conn.close();
			}
			catch(SQLException e){
				System.out.println(e);
			}	 
		    connManager.releaseConnection("market",conn);
		}
	    RequestDispatcher requestDispatcher = request.getRequestDispatcher("goods/result.jsp");
	    requestDispatcher.forward(request, response);
	}
}