addgood.java

还是超市系统

package addgood;

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

public class Addgood extends HttpServlet{
	
	public void doGet(HttpServletRequest req,HttpServletResponse res)
		throws ServletException,IOException{
			res.setContentType("text/html;charset=GBK");
			req.setCharacterEncoding("GBK");
			PrintWriter out = res.getWriter();
			oracle.OracleBean conn = new oracle.OracleBean();
			ResultSet rs = null;
			HttpSession session = req.getSession();
			
			
			int goodId = Integer.parseInt(req.getParameter("good_id"));
    		String goodName = req.getParameter("good_name");
    		int venderId = Integer.parseInt(req.getParameter("vender_id"));
    		float goodPrice = Float.parseFloat(req.getParameter("good_price"));
    		String goodUnit = req.getParameter("good_unit");
    		String goodMessage = req.getParameter("good_message");
    		int dept_Id = Integer.parseInt(req.getParameter("dept_id"));
    		
    		
			try{
    			
    			String sql = "insert into table_good values("+goodId+",'"+goodName+"',"+venderId+","+goodPrice+",'"+goodUnit+"','"+goodMessage+"',"+dept_Id+")";
    			int flag = conn.update(sql);
    			if(flag != 0)
    				getServletConfig().getServletContext().getRequestDispatcher("/supermaket/hi.jsp").forward(req,res);
    			else 
    				out.println("fail");
			
			}catch(Exception e ){
				e.printStackTrace();
			}
			
		}
		
	public void doPost(HttpServletRequest req,HttpServletResponse res)
		throws ServletException,IOException{
			doGet(req,res);
		}
}