makenewgood.java

还是超市系统

/**@(#)MakeNewGood.java*/
package test.expense;

import java.io.IOException;
import java.sql.*;

import javax.servlet.*;
import javax.servlet.http.*;

/**添加新的货物到table_good
 * @version 0.1
 * @author Administrator
 * @date 20060803 pm 16:23
 */
public class MakeNewGood extends HttpServlet{
Connection conn;
	
	int     goodId ;
	String  goodName;
    int     venderId;
    float   goodPrice;
    String  goodUnit;
    String  goodMessage;
    int     deptId;
	
	public MakeNewGood(){
		try{
			Class.forName("oracle.jdbc.driver.OracleDriver");
			conn = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:SMarket","scott","tiger");
		}catch(Exception e){
			e.printStackTrace();
		}
	}
	
    public void doGet(HttpServletRequest req,HttpServletResponse res)throws ServletException ,IOException{
		
    	req.setCharacterEncoding("gbk");
    	
    	goodId = Integer.parseInt(req.getParameter("goodId"));
    	goodName = req.getParameter("goodName");
    	venderId = Integer.parseInt(req.getParameter("venderId"));
    	goodPrice = Float.parseFloat(req.getParameter("goodPrice"));
    	goodUnit = req.getParameter("goodUnit");
    	goodMessage = req.getParameter("goodMessage");
    	deptId = Integer.parseInt(req.getParameter("deptId"));
    	
    	try{
    		Statement mm = conn.createStatement();
    		mm.executeUpdate("INSERT INTO table_good VALUES("+goodId+",'"+goodName+"',"+venderId+","+goodPrice+",'"+goodUnit+"','"+goodMessage+"',"+deptId+")");
    		System.out.println();
    	}catch(Exception e){
    		e.printStackTrace();
    	}finally{
    		
    		try{
    			if(conn!=null){
    				//conn.close();
    			}
    		}catch(Exception e){
    			e.printStackTrace();
    		}
    	}
    	
    	getServletConfig().getServletContext().getRequestDispatcher("/pages/newok.html").forward(req,res);
    }
	public void doPost(HttpServletRequest req,HttpServletResponse res)throws ServletException ,IOException{
		
		doGet(req,res);
	}
}