checkservlet.java

基于JSP的家电连锁超市管理系统 数据库也在文件内

package servlet;

import java.io.*;
import javax.servlet.*;
import javax.servlet.http.*;
import java.sql.*;
import java.util.*;
import electric.dbs.*;
import electric.electricUtils.*;

public class CheckServlet extends HttpServlet
{
	public void doPost(HttpServletRequest request,HttpServletResponse response)
	  throws ServletException,java.io.IOException
	{
         
          	String Ayear = ParamUtils.getEscapeHTMLParameter(request, "Ayear","2007");
		 	String Amonth = ParamUtils.getEscapeHTMLParameter(request, "Amonth","01");
		 	String Aday = ParamUtils.getEscapeHTMLParameter(request, "Aday","01");
		 	String Byear = ParamUtils.getEscapeHTMLParameter(request, "Byear","2007");
		 	String Bmonth = ParamUtils.getEscapeHTMLParameter(request, "Bmonth","01");
		 	String Bday = ParamUtils.getEscapeHTMLParameter(request, "Bday","01");
		 	int Dqidtemp = ParamUtils.getIntParameter(request, "Dqid",0);
		 	int Proidtemp = ParamUtils.getIntParameter(request, "Proid",0);
		  	String Atime=Ayear+Amonth+Aday;
		  	String Btime=Byear+Bmonth+Bday;
		  	String sql="";
			if((Dqidtemp==0) && (Proidtemp==0)){
		     	sql="SELECT * FROM [SELL] WHERE STATUS<>"+new Integer(1).toString()+" AND PTIME BETWEEN '"+Atime+"'AND'"+Btime+"' order by Ptime";
		 	}
		 	if((Dqidtemp==0) && (Proidtemp!=0)){
		 		 sql="SELECT * FROM SELL WHERE STATUS<>"+new Integer(1).toString()+" AND PTIME BETWEEN '"+Atime+"'AND'"+Btime+"' AND PRODUCTID="+Proidtemp+"  order by Ptime";
		 	}
			 if((Dqidtemp!=0) && (Proidtemp==0)){
			 	 sql="SELECT * FROM SELL WHERE STATUS<>"+new Integer(1).toString()+" AND PTIME BETWEEN '"+Atime+"'AND'"+Btime+"' AND SHOPID="+Dqidtemp+"  order by Ptime";
		 	}
			if((Dqidtemp!=0) && (Proidtemp!=0)){
			    sql="SELECT * FROM SELL WHERE STATUS<>"+new Integer(1).toString()+" AND PTIME BETWEEN '"+Atime+"'AND'"+Btime+"' AND SHOPID="+Dqidtemp+" AND PRODUCTID="+Proidtemp+"  order by Ptime";
		 	}		                                                                       

		try
		{
	  		Connection con=null;
			PreparedStatement ps=null;
			ResultSet rs=null;
			Vector v=new Vector();			
			con=DbConnectionManager.getConnection();
			ps=con.prepareStatement(sql);
			rs=ps.executeQuery();
			while(rs.next())
			{
				String[] str=new String[4];
				str[0]=rs.getString(9);
				str[1]=rs.getInt(7)+"";
				str[2]=rs.getString(6);
			    Dbshop dbshop=new Dbshop(rs.getInt(2));			    				
				str[3]=dbshop.getShopname();
				v.add(str);								
			}
			String Proid=Proidtemp+"";
			String Dqid=Dqidtemp+"";
			request.setAttribute("CheckV",v);
			request.setAttribute("Atime",Atime);
			request.setAttribute("Btime",Btime);
			request.setAttribute("Proid",Proid);
			request.setAttribute("Dqid",Dqid);;
			this.getServletConfig().getServletContext().getRequestDispatcher("/checksell.jsp").forward(request,response);
		}
		catch(SQLException e)
		{
			e.printStackTrace();
		}
		catch(ShopNotFoundException ee)
		{
			ee.printStackTrace();
		}
  		
	}
	
	public void doGet(HttpServletRequest request,HttpServletResponse response)
	  throws ServletException,java.io.IOException
	{
	  	this.doPost(request,response);
	}
	
	public static void main(String args[])
	{
     		try
		{
	  		Connection con=null;
			PreparedStatement ps=null;
			ResultSet rs=null;
			Vector v=new Vector();			
			con=DbConnectionManager.getConnection();
			ps=con.prepareStatement("SELECT * FROM [SELL] WHERE STATUS<>"+new Integer(1).toString()+" AND PTIME BETWEEN '"[phone]+"'AND'"[phone]+"' order by Ptime");
			rs=ps.executeQuery();
			while(rs.next())
			{
				String[] str=new String[4];
				str[0]=rs.getString(9);
				str[1]=rs.getInt(7)+"";
				str[2]=rs.getString(6);
			    Dbshop dbshop=new Dbshop(rs.getInt(2));			    				
				str[3]=dbshop.getShopname();
				System.out.print("## date ## "+str[0]+"   ");
				System.out.print("## shuliang ## "+str[1]+"   ");
				System.out.print("## companytype ## "+str[2]+"   ");
				System.out.print("## shopname ## "+str[3]);
				System.out.println(" ");
				v.add(str);								
			}

		}
		catch(SQLException e)
		{
			e.printStackTrace();
		}
		catch(ShopNotFoundException ee)
		{
			ee.printStackTrace();
		}
  		
	}
}