userdel.java

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

package com.myservlet.user;

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

public class UserDel extends HttpServlet{
	
	/**
	 * 
	 */
	private static final long serialVersionUID = -6791159835365290229L;

	public void doPost(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 consumer 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("message5", "删除成功！");
			}
			else{
				request.getSession(true).setAttribute("message5", "删除失败！");
			}
		}
		catch(SQLException e){
			System.out.println(e);
			//request.getSession(true).setAttribute("message5", "添加失败，输入的数据格式不正确！");
		}
		finally{
			try{
				ps.close();
				conn.close();
			}
			catch(SQLException e){
				System.out.println(e);
			}	 
			connManager.releaseConnection("market",conn);
		}
		RequestDispatcher requestDispatcher = request.getRequestDispatcher("user/result2.jsp");
		requestDispatcher.forward(request, response);
	}

	public void doGet(HttpServletRequest request, HttpServletResponse response)
		throws ServletException, IOException {
		doPost(request,response);
	}
}