useredit2.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 UserEdit2 extends HttpServlet{
	
	/**
	 * 
	 */
	private static final long serialVersionUID = -6531999539164364592L;

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

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

		String id = request.getParameter("id");
		String name = request.getParameter("name").trim();
		String sex = request.getParameter("sex").trim();
		String phone = request.getParameter("phone").trim();
		String pay = request.getParameter("pay").trim();
		String remark = request.getParameter("remark").trim();
		String status = request.getParameter("status").trim();
		String pwd = request.getParameter("pwd").trim();

		ConnManager connManager = new ConnManager();
		Connection conn = connManager.getConnection("market");
		PreparedStatement ps = null;

		try{
			String sql = "UPDATE consumer SET name='"+name+"'"+", sex='"+sex+"'"+", phone='"+phone+"'"+", pay='"+pay+"'"+", remark='"+remark+"'"+", status='"+status+"', pwd='"+pwd+"' WHERE id='"+id+"'";
			sql = new String(sql.getBytes("ISO8859-1"), "gbk");
    
			ps = conn.prepareStatement(sql);
			int m = ps.executeUpdate();
			if(m != 0){
				request.getSession(true).setAttribute("message6", "修改成功!");
			}
			else{
				request.getSession(true).setAttribute("message6", "修改失改!");
			}
		}
		catch(SQLException e){
			System.out.println(e);	
			request.getSession(true).setAttribute("message6", "修改失改,数据格式不正确!");
		}
		finally{
			try{
				ps.close();
				conn.close();
			}		
			catch(SQLException e){
				System.out.println(e);
			}
			connManager.releaseConnection("market",conn);
		}
		RequestDispatcher dispatcher= request.getRequestDispatcher("user/result2.jsp");
		dispatcher.forward(request, response);
	}
}