addnewgood.java

还是超市系统

package addnewgood;

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

public class Addnewgood extends HttpServlet{
	
	public void doGet(HttpServletRequest req,HttpServletResponse res)
		throws ServletException,IOException{
			req.setCharacterEncoding("GBK");
			db.ConnOracle conn = new db.ConnOracle();
			ResultSet rs = null;
			HttpSession session = req.getSession();
			session.getAttribute("id");
			
			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 deptId = Integer.parseInt(req.getParameter("id"));
    		
    		try{
    			
    			String sql = "insert into table_good values("+goodId+",'"+goodName+"',"+venderId+","+goodPrice+",'"+goodUnit+"','"+goodMessage+"',"+deptId+")";
    			conn.update(sql);
    		}catch(Exception e){
    			e.printStackTrace();
    		}
    		getServletConfig().getServletContext().getRequestDispatcher("/pages/addnewgood.jsp").forward(req,res);
			
		}
	public void doPost(HttpServletRequest req,HttpServletResponse res)
		throws ServletException,IOException{
			doGet(req,res);
		}
}