chaxx.java

来自「还是那个超市系统都是组员的成品」· Java 代码 · 共 53 行

package superMarket; 
import java.io.*;
import java.sql.*;
import javax.servlet.*;
import javax.servlet.http.*;
import javabean.OracleBean;
public class Chaxx extends HttpServlet{
	public void doGet(HttpServletRequest request,HttpServletResponse response)
	      throws ServletException,IOException{
	      	try{
	      		response.setContentType("text/html;charset=GBK");
	      	    PrintWriter out = response.getWriter();
	      	    OracleBean conn = new OracleBean();
	      	    ResultSet rs = null;
	      	    ResultSet rs1 = null;
	      	    
	      	    int id = Integer.parseInt(request.getParameter("id"));
	      	    int g_id = Integer.parseInt(request.getParameter("bianhao")); 
	      	    int s_num = Integer.parseInt(request.getParameter("shuliang"));
	      	    int f_id = 0;
	      	    int ss_price = 0;
	      	    rs1 = conn.query("SELECT buy.f_id,goods.ss_price from buy,goods WHERE buy.g_id = buy.g_id AND goods.g_id=goods.g_id");
	      	    while(rs1.next()){//只要查询就必须要进行遍历结果集
	      	    
	      	       f_id = rs.getInt("f_id");
	      	       ss_price = rs.getInt("ss_price"); 
	      	    }
	      	    PreparedStatement pstmt = conn.getConn().prepareStatement("INSERT INTO sales VALUES(?,?,?,?,sysDate,?,?)");
	      	    int s_id = 000;
	      	    int h = s_id++;

	            pstmt.setInt(1,h);
	            pstmt.setInt(2,g_id);
	            pstmt.setInt(3,s_num);
	            pstmt.setInt(4,s_num*ss_price);
	            pstmt.setInt(5,id);
	            pstmt.setInt(6,f_id);
	            pstmt.executeUpdate();
	            pstmt.close();
	            conn.close();
	            getServletConfig().getServletContext().getRequestDispatcher("/tianjia1.jsp").forward(request,response);
	        	 }catch(Exception e){
	   	 	       e.printStackTrace();
	   	 	
	   	 }
	   	 
	      	 
	     }
	     public void doPost(HttpServletRequest request,HttpServletResponse response)
	          throws ServletException,IOException{
	          	  doGet(request,response);
	          }
}