chaxun5.java

还是那个超市系统都是组员的成品

package superMarket; 
import java.io.*;
import java.sql.*;
import java.util.*;
import javax.servlet.*;
import javax.servlet.http.*;
import javabean.OracleBean;
public class ChaXun5 extends HttpServlet{
	public void doGet(HttpServletRequest request,HttpServletResponse response)
	      throws ServletException,IOException{
	      	try{
	      		HttpSession session = request.getSession();	
	      		response.setContentType("text/html;charset=GBK");
	      	    PrintWriter out = response.getWriter();
	      	    OracleBean conn = new OracleBean();
	      	    ResultSet rs = null;
	      	     int a = Integer.parseInt(request.getParameter("select1"));    
	      	     int b = Integer.parseInt(request.getParameter("select2"));
	      	     int c = Integer.parseInt(request.getParameter("select3"));
	      	     int d = Integer.parseInt(request.getParameter("select4"));
	      	     int e = Integer.parseInt(request.getParameter("select5"));
	      	     int f = Integer.parseInt(request.getParameter("select6"));
	      	     String time1 = a+"-"+b+"-"+c;
	      	     String time2 = d+"-"+e+"-"+f; 
	      	     String sql = " SELECT SUM(sales.s_num) s_num,SUM(sales.s_price) s_price FROM sales WHERE sale_date BETWEEN TO_DATE('"+time1+"','yyyy-mm-dd') AND TO_DATE('"+time2+"','yyyy-mm-dd')";      
	      	     rs = conn.query(sql);
                 request.setAttribute("result",rs);
	      	     getServletConfig().getServletContext().getRequestDispatcher("/timeselect.jsp").forward(request,response);
	            	}catch(Exception e){
	   	 	       e.printStackTrace();
	   	 	
	   	 }
	      	 
	     }
	     public void doPost(HttpServletRequest request,HttpServletResponse response)
	          throws ServletException,IOException{
	          	  doGet(request,response);
	          }
}