goodsedit2.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 GoodsEdit2 extends HttpServlet{

	/**
	 * 
	 */
	private static final long serialVersionUID = -1206875507194924422L;

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

	public void doPost(HttpServletRequest request, HttpServletResponse response)
		throws ServletException, IOException {
		performTask(request, response);
	}
	
	private synchronized void performTask(HttpServletRequest request, HttpServletResponse response)
		throws ServletException, IOException{
		
		String id = request.getParameter("id");
		String code = request.getParameter("code").trim();
        String tname = request.getParameter("tname").trim();
        	   //tname = handleString(tname);
        String bprice = request.getParameter("bprice").trim();
        String sprice = request.getParameter("sprice").trim();
        String amount = request.getParameter("amount").trim();
        String maker = request.getParameter("maker").trim();
        	   //maker = handleString(maker);	            
        String area = request.getParameter("area").trim();
        	   //area = handleString(area);	
        String type = request.getParameter("type").trim();
        	   //type = handleString(type);	
        String remark = request.getParameter("remark").trim();
        	   //remark = handleString(remark);	

		ConnManager connManager = new ConnManager();
		Connection conn = connManager.getConnection("market");
		PreparedStatement ps = null;
		
		try{
            String sql = "UPDATE goods SET code='"+code+"'"+", tname='"+tname+"'"+", bprice='"+bprice+"'"+", sprice='"+sprice+"'"+", amount='"+amount+"'"+", maker='"+maker+"'"+", area='"+area+"', type='"+type+"', remark='"+remark+"' 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("message3", "修改成功!");
            }
            else{
            	request.getSession(true).setAttribute("message3", "修改失改!");
            }
		}
		catch(SQLException e){
			System.out.println(e);	
			request.getSession(true).setAttribute("message3", "修改失改,数据格式不正确!");
		}
		finally{
			try{
				ps.close();
				conn.close();
			}
			catch(SQLException e){
				System.out.println(e);
			}
			connManager.releaseConnection("market",conn);
		}
	        RequestDispatcher dispatcher= request.getRequestDispatcher("goods/result.jsp");
	        dispatcher.forward(request, response);
		
	}

}