goodsadd.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 GoodsAdd extends HttpServlet{

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

		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 code = request.getParameter("code").trim();
            String tname = request.getParameter("tname").trim();   
            String bprice = request.getParameter("bprice").trim();
            String sprice = request.getParameter("sprice").trim();
            String amount = request.getParameter("amount").trim();
            String maker = request.getParameter("maker").trim();          
            String area = request.getParameter("area").trim();
            String type = request.getParameter("type").trim();
            String remark = request.getParameter("remark").trim();

			ConnManager connManager = new ConnManager();
			Connection conn = connManager.getConnection("market");
		    PreparedStatement ps = null;
		    try{
		    	String sql = "INSERT INTO goods (id, code, tname, amount, bprice, sprice, maker, area, remark, type) VALUES (goodsseq.NEXTVAL, '"+code+"', '"+tname+"', '"+amount+"', '"+bprice+"', '"+sprice+"', '"+maker+"', '"+area+"', '"+remark+"', '"+type+"')";
		    	sql = new String(sql.getBytes("ISO8859-1"), "gbk");
		    	System.out.println(sql);
		    	ps = conn.prepareStatement(sql);
		    	int m = ps.executeUpdate();
		    	if(m != 0){
		    		request.getSession(true).setAttribute("message1", "添加成功！");
		    	}
		    	else{
		    		request.getSession(true).setAttribute("message1", "添加失败，请重新添加！");
		    	}
            }
			catch(SQLException e){
				System.out.println(e);
				request.getSession(true).setAttribute("message1", "添加失败，输入的数据格式不正确！");
			}
			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);
		}
}