querya.java

ERO系统.针对生产型、分销型、服务型企业等不同的行业特点

		}
		else if(!timea.equals("")&&!timeb.equals("")&&!marketarea.equals("")&&(sales.equals("")||sales==null)&&!trade.equals("")){
			sql="select * from "+tableName+" where "+fieldName1+">='"+timea+"' and "+fieldName1+"<='"+timeb+"' and "+fieldName2+"='"+marketarea+"' and ("+fieldName3+"='"+trade+"' or "+fieldName3+"='"+trade1+"' or "+fieldName3+"='"+trade2+"' or "+fieldName3+"='"+trade3+"' or "+fieldName3+"='"+trade4+"' or "+fieldName3+"='"+trade5+"') and "+condition+" "+queue+"";
		}
		else if(!timea.equals("")&&!timeb.equals("")&&!marketarea.equals("")&&(!sales.equals("")&&sales!=null)&&trade.equals("")){
			sql="select * from "+tableName+" where "+fieldName1+">='"+timea+"' and "+fieldName1+"<='"+timeb+"' and "+fieldName2+"='"+marketarea+"' and "+fieldName4+"='"+sales+"' and "+condition+" "+queue+"";
		}
		else if(!timea.equals("")&&!timeb.equals("")&&marketarea.equals("")&&(sales.equals("")||sales==null)&&trade.equals("")){
					sql="select * from "+tableName+" where "+fieldName1+">='"+timea+"' and "+fieldName1+"<='"+timeb+"' and "+condition+" "+queue+"";
		}
		else if(!timea.equals("")&&timeb.equals("")&&!marketarea.equals("")&&(sales.equals("")||sales==null)&&trade.equals("")){
					sql="select * from "+tableName+" where "+fieldName1+">='"+timea+"' and "+fieldName2+"='"+marketarea+"' and "+condition+" "+queue+"";
		}
		else if(!timea.equals("")&&timeb.equals("")&&marketarea.equals("")&&(!sales.equals("")&&sales!=null)&&trade.equals("")){
					sql="select * from "+tableName+" where "+fieldName1+">='"+timea+"' and "+fieldName4+"='"+sales+"' and "+condition+" "+queue+"";
		}
		else if(!timea.equals("")&&timeb.equals("")&&marketarea.equals("")&&(sales.equals("")||sales==null)&&!trade.equals("")){
					sql="select * from "+tableName+" where "+fieldName1+">='"+timea+"' and ("+fieldName3+"='"+trade+"' or "+fieldName3+"='"+trade1+"' or "+fieldName3+"='"+trade2+"' or "+fieldName3+"='"+trade3+"' or "+fieldName3+"='"+trade4+"' or "+fieldName3+"='"+trade5+"') and "+condition+" "+queue+"";
		}
		else if(timea.equals("")&&!timeb.equals("")&&!marketarea.equals("")&&(sales.equals("")||sales==null)&&trade.equals("")){
					sql="select * from "+tableName+" where "+fieldName1+"<='"+timeb+"' and "+fieldName2+"='"+marketarea+"' and "+condition+" "+queue+"";
		}
		else if(timea.equals("")&&!timeb.equals("")&&marketarea.equals("")&&(!sales.equals("")&&sales!=null)&&trade.equals("")){
					sql="select * from "+tableName+" where "+fieldName1+"<='"+timeb+"' and "+fieldName4+"='"+sales+"' and "+condition+" "+queue+"";
		}
		else if(!timea.equals("")&&!timeb.equals("")&&marketarea.equals("")&&(sales.equals("")||sales==null)&&!trade.equals("")){
					sql="select * from "+tableName+" where "+fieldName1+"<='"+timeb+"' and ("+fieldName3+"='"+trade+"' or "+fieldName3+"='"+trade1+"' or "+fieldName3+"='"+trade2+"' or "+fieldName3+"='"+trade3+"' or "+fieldName3+"='"+trade4+"' or "+fieldName3+"='"+trade5+"') and "+condition+" "+queue+"";
		}
		else if(timea.equals("")&&timeb.equals("")&&!marketarea.equals("")&&(!sales.equals("")&&sales!=null)&&trade.equals("")){
					sql="select * from "+tableName+" where "+fieldName2+"='"+marketarea+"' and "+fieldName4+"='"+sales+"' and "+condition+" "+queue+"";
		}
		else if(timea.equals("")&&timeb.equals("")&&!marketarea.equals("")&&(sales.equals("")||sales==null)&&!trade.equals("")){
					sql="select * from "+tableName+" where "+fieldName2+"='"+marketarea+"' and ("+fieldName3+"='"+trade+"' or "+fieldName3+"='"+trade1+"' or "+fieldName3+"='"+trade2+"' or "+fieldName3+"='"+trade3+"' or "+fieldName3+"='"+trade4+"' or "+fieldName3+"='"+trade5+"') and "+condition+" "+queue+"";
		}
		else if(timea.equals("")&&timeb.equals("")&&marketarea.equals("")&&(!sales.equals("")&&sales!=null)&&!trade.equals("")){
					sql="select * from "+tableName+" where "+fieldName4+"='"+sales+"' and ("+fieldName3+"='"+trade+"' or "+fieldName3+"='"+trade1+"' or "+fieldName3+"='"+trade2+"' or "+fieldName3+"='"+trade3+"' or "+fieldName3+"='"+trade4+"' or "+fieldName3+"='"+trade5+"') and "+condition+" "+queue+"";
		}

		else if(!timea.equals("")&&!timeb.equals("")&&!marketarea.equals("")&&(sales.equals("")||sales==null)&&trade.equals("")){
					sql="select * from "+tableName+" where "+fieldName1+">='"+timea+"' and "+fieldName1+"<='"+timeb+"' and "+fieldName2+"='"+marketarea+"' and "+condition+" "+queue+"";
		}
		else if(!timea.equals("")&&!timeb.equals("")&&marketarea.equals("")&&(!sales.equals("")&&sales!=null)&&trade.equals("")){
					sql="select * from "+tableName+" where "+fieldName1+">='"+timea+"' and "+fieldName1+"<='"+timeb+"' and "+fieldName4+"='"+sales+"' and "+condition+" "+queue+"";
		}
		else if(!timea.equals("")&&!timeb.equals("")&&marketarea.equals("")&&(sales.equals("")||sales==null)&&!trade.equals("")){
					sql="select * from "+tableName+" where "+fieldName1+">='"+timea+"' and "+fieldName1+"<='"+timeb+"' and ("+fieldName3+"='"+trade+"' or "+fieldName3+"='"+trade1+"' or "+fieldName3+"='"+trade2+"' or "+fieldName3+"='"+trade3+"' or "+fieldName3+"='"+trade4+"' or "+fieldName3+"='"+trade5+"') and "+condition+" "+queue+"";
		}
		else if(timea.equals("")&&!timeb.equals("")&&!marketarea.equals("")&&(!sales.equals("")&&sales!=null)&&trade.equals("")){
					sql="select * from "+tableName+" where "+fieldName1+"<='"+timeb+"' and "+fieldName2+"='"+marketarea+"' and "+fieldName4+"='"+sales+"' and "+condition+" "+queue+"";
		}
		else if(timea.equals("")&&!timeb.equals("")&&!marketarea.equals("")&&(sales.equals("")||sales==null)&&!trade.equals("")){
					sql="select * from "+tableName+" where "+fieldName1+"<='"+timeb+"' and "+fieldName2+"='"+marketarea+"' and ("+fieldName3+"='"+trade+"' or "+fieldName3+"='"+trade1+"' or "+fieldName3+"='"+trade2+"' or "+fieldName3+"='"+trade3+"' or "+fieldName3+"='"+trade4+"' or "+fieldName3+"='"+trade5+"') and "+condition+" "+queue+"";
		}
		else if(timea.equals("")&&timeb.equals("")&&!marketarea.equals("")&&(!sales.equals("")&&sales!=null)&&!trade.equals("")){
					sql="select * from "+tableName+" where "+fieldName2+"='"+marketarea+"' and "+fieldName4+"='"+sales+"' and ("+fieldName3+"='"+trade+"' or "+fieldName3+"='"+trade1+"' or "+fieldName3+"='"+trade2+"' or "+fieldName3+"='"+trade3+"' or "+fieldName3+"='"+trade4+"' or "+fieldName3+"='"+trade5+"') and "+condition+" "+queue+"";
		}
		else if(!timea.equals("")&&timeb.equals("")&&!marketarea.equals("")&&(sales.equals("")||sales==null)&&!trade.equals("")){
					sql="select * from "+tableName+" where "+fieldName1+">='"+timea+"' and "+fieldName2+"='"+marketarea+"' and ("+fieldName3+"='"+trade+"' or "+fieldName3+"='"+trade1+"' or "+fieldName3+"='"+trade2+"' or "+fieldName3+"='"+trade3+"' or "+fieldName3+"='"+trade4+"' or "+fieldName3+"='"+trade5+"') and "+condition+" "+queue+"";
		}
		else if(timea.equals("")&&!timeb.equals("")&&marketarea.equals("")&&(!sales.equals("")&&sales!=null)&&!trade.equals("")){
					sql="select * from "+tableName+" where "+fieldName1+"<='"+timeb+"' and "+fieldName4+"='"+sales+"' and ("+fieldName3+"='"+trade+"' or "+fieldName3+"='"+trade1+"' or "+fieldName3+"='"+trade2+"' or "+fieldName3+"='"+trade3+"' or "+fieldName3+"='"+trade4+"' or "+fieldName3+"='"+trade5+"') and "+condition+" "+queue+"";
		}
		else if(!timea.equals("")&&timeb.equals("")&&!marketarea.equals("")&&(!sales.equals("")&&sales!=null)&&trade.equals("")){
					sql="select * from "+tableName+" where "+fieldName1+">='"+timea+"' and "+fieldName2+"='"+marketarea+"' and "+fieldName4+"='"+sales+"' and "+condition+" "+queue+"";
		}
		else{
					sql="select * from "+tableName+" where "+fieldName1+">='"+timea+"' and "+fieldName4+"='"+sales+"' and ("+fieldName3+"='"+trade+"' or "+fieldName3+"='"+trade1+"' or "+fieldName3+"='"+trade2+"' or "+fieldName3+"='"+trade3+"' or "+fieldName3+"='"+trade4+"' or "+fieldName3+"='"+trade5+"') and "+condition+" "+queue+"";
		}
			rs=dba.executeQuery(sql);
		}catch (Exception ex) {
			ex.printStackTrace();
		}

		return rs;
		}

	public int intRowCount() {
		try{
					dbb=new nseer_db(dbase);
					sql1 = sql;
					rs1=dbb.executeQuery(sql1);
					intRowCount=0;
					if(rs1.last()){
					intRowCount=rs1.getRow();
					}
				dbb.close();
		}
				catch (Exception ex){
					ex.printStackTrace();
				}
		return intRowCount;
	}


	public void close() {
	dba.close();
	}

	public double sumTotal(String fName) {
		try{
					this.fieldName=fName;
					dbb=new nseer_db(dbase);
					sql2 = sql;
					rs2=dbb.executeQuery(sql2);
					tradeTotal=0;
					while(rs2.next()){
					tradeTotal += rs2.getDouble(fieldName);
					}
				dbb.close();
		}
				catch (Exception ex){
					ex.printStackTrace();
				}
		return tradeTotal;
	}

	public int intTotal(String fName) {
		try{
					this.fieldName=fName;
					dbb=new nseer_db(dbase);
					sql4 = sql;
					backTimeTotal=0;
					rs4=dbb.executeQuery(sql4);
					while(rs4.next()){
					backTimeTotal += rs4.getInt(fieldName);
				}
				dbb.close();
		}
				catch (Exception ex){
					ex.printStackTrace();
				}
		return backTimeTotal;
	}

}