modifyitem.java

还是超市系统

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

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

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

import test.bean.Good;
import test.bean.SetPage_Oracle_g;

/**订购记录的单条修改
 * @version 0.1
 * @author kyle
 * @date 20060802 pm 14:29
 */
public class ModifyItem extends HttpServlet{

	public void doGet(HttpServletRequest req,HttpServletResponse res)throws ServletException ,IOException{
		
		Connection conn;
		Statement stmt;
		//ResultSet rs;
		
		try{
			
			Class.forName("oracle.jdbc.driver.OracleDriver");
			conn = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:SMarket","scott","tiger");
			stmt = conn.createStatement();
			stmt.executeUpdate("UPDATE table_bill SET good_amount="+req.getParameter("goodAmount")+"WHERE bill_id ="+req.getParameter("billId"));
		}catch(Exception e){
			e.printStackTrace();
		}
		getServletConfig().getServletContext().getRequestDispatcher("/pages/showdate.jsp").forward(req,res);
	}
	public void doPost(HttpServletRequest req,HttpServletResponse res)throws ServletException ,IOException{
		
		doGet(req,res);
	}
	
}