buy2.java

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

package com.myservlet.buy;

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

import com.dbconn.*;

public class Buy2 extends HttpServlet{

	/**
	 * 
	 */
	private static final long serialVersionUID = 4235684279698135867L;
	
	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 opname = (String)request.getSession(true).getAttribute("opname");
		String goodsid = request.getParameter("id");				//商品ID
		String opid = request.getParameter("op");				//员工编号
		String bamount = request.getParameter("bamount");	//进货数量
		String remark = request.getParameter("bremark");	//进货备注
		String time = request.getParameter("time");			//进货时间

		ConnManager connManager = new ConnManager();
		Connection conn = connManager.getConnection("market");
		//Connection conn2 = connManager.getConnection("market");
		PreparedStatement ps = null;
		//PreparedStatement ps2 = null;
		
		try{
			String sql = "UPDATE goods SET amount=amount+'"+bamount+"' WHERE id='"+goodsid+"'";
			sql = new String(sql.getBytes("ISO8859-1"), "gbk");
			System.out.println(sql);
			ps = conn.prepareStatement(sql);
			int m = ps.executeUpdate();
			if(m != 0){
				String sql2 = "INSERT INTO buy (id, goodsid, amount, time, opid, opname, remark) VALUES (buyseq.NEXTVAL, '"+goodsid+"', '"+bamount+"', '"+time+"', '"+opid+"', '"+opname+"', '"+remark+"')";
				sql2 = new String(sql2.getBytes("ISO8859-1"), "gbk");
				System.out.println(sql2);
				ps = conn.prepareStatement(sql2);
				int n = ps.executeUpdate();
				if(n != 0){				
					request.getSession(true).setAttribute("message7", "进货成功！");
				}
			}
			else{
				request.getSession(true).setAttribute("message7", "进货失败，输入数据格式错误！");
			}
		}
		catch(SQLException e){
			System.out.println(e);
			request.getSession(true).setAttribute("message7", "进货失败，输入数据格式错误！");
		}
		finally{
			try{
				ps.close();
				conn.close();
			}
			catch(SQLException e){
				System.out.println(e);
			}
			connManager.releaseConnection("market",conn);
		}
	
		RequestDispatcher dispatcher= request.getRequestDispatcher("buy/result3.jsp");
		dispatcher.forward(request, response);		
	}
}