useredit.java

来自「jsp超市管理系统系统,是用经典的MVC设计模式开发的非常适合初学者学习。」· Java 代码 · 共 71 行

package com.myservlet.user;

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

public class UserEdit extends HttpServlet{
	
	/**
	 * 
	 */
	private static final long serialVersionUID = 7438867094263440890L;

	public void doPost(HttpServletRequest req, HttpServletResponse resp)
	throws ServletException, IOException {

		String	id = req.getParameter("id");
		
		String sql = "SELECT * FROM consumer WHERE id = '"+id+"'";
		//System.out.println(sql);	
		ConnManager connManager = new ConnManager();
		Connection conn = connManager.getConnection("market");  		
		PreparedStatement ps = null;
		ResultSet rs = null;
	
		try{
			ps = conn.prepareStatement(sql);
			rs = ps.executeQuery(sql);
	
			if(rs.next()){				
				User user = new User();
			
				user.setId(rs.getString("id"));
				user.setName(rs.getString("name"));
				user.setSex(rs.getString("sex"));
				user.setPhone(rs.getInt("phone"));
				user.setPay(rs.getInt("pay"));
				user.setRemark(rs.getString("remark"));
				user.setStatus(rs.getString("status"));
				user.setPwd(rs.getString("pwd"));

				req.getSession(true).setAttribute("user", user);
			}
		}
		catch(SQLException e){
			System.out.println(e);
		}
		finally{
			try{
				rs.close();
				ps.close();
				conn.close();
			}
			catch(SQLException e){
				System.out.println(e);
			}
			connManager.releaseConnection("market", conn);
		}

		resp.sendRedirect("user/userEdit.jsp");	
	}

	public void doGet(HttpServletRequest req, HttpServletResponse resp)
    	throws ServletException, IOException {
			doPost(req, resp);
	}
}