query.java

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

		}
		else{
					sql="select * from "+tableName+" where "+fieldName1+">='"+timea+"' and "+fieldName4+"='"+sales+"' and "+fieldName3+"='"+trade+"' and "+condition+" "+queue+"";
		}
		}else{
		if(timea.equals("")&&timeb.equals("")&&marketarea.equals("")&&sales.equals("")&&trade.equals("")){
			sql="select * from "+tableName+" where "+fieldName5+"='"+fieldValue5+"' 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 "+condition+"&&"+fieldName5+"='"+fieldValue5+"' "+queue+"";
		}
		else if(timea.equals("")&&!timeb.equals("")&&marketarea.equals("")&&(sales.equals("")||sales==null)&&trade.equals("")){
			sql="select * from "+tableName+" where "+fieldName1+"<='"+timeb+"' and "+fieldName5+"='"+fieldValue5+"' 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 "+fieldName5+"='"+fieldValue5+"' 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 "+fieldName5+"='"+fieldValue5+"' and "+condition+" "+queue+"";
		}
		else if(timea.equals("")&&timeb.equals("")&&marketarea.equals("")&&(sales.equals("")||sales==null)&&!trade.equals("")){
			sql="select * from "+tableName+" where "+fieldName3+"='"+trade+"' and "+fieldName5+"='"+fieldValue5+"' 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 "+fieldName3+"='"+trade+"' and "+fieldName5+"='"+fieldValue5+"' 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 "+fieldName3+"='"+trade+"' and "+fieldName5+"='"+fieldValue5+"' 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 "+fieldName3+"='"+trade+"' and "+fieldName5+"='"+fieldValue5+"' 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 "+fieldName3+"='"+trade+"' and "+fieldName5+"='"+fieldValue5+"' 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 "+fieldName3+"='"+trade+"' and "+fieldName5+"='"+fieldValue5+"' 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 "+fieldName5+"='"+fieldValue5+"' 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 "+fieldName5+"='"+fieldValue5+"' 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 "+fieldName5+"='"+fieldValue5+"' 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 "+fieldName5+"='"+fieldValue5+"' 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+"' and "+fieldName5+"='"+fieldValue5+"' 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 "+fieldName5+"='"+fieldValue5+"' 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 "+fieldName5+"='"+fieldValue5+"' 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+"' and "+fieldName5+"='"+fieldValue5+"' 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 "+fieldName5+"='"+fieldValue5+"' 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+"' and "+fieldName5+"='"+fieldValue5+"' 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+"' and "+fieldName5+"='"+fieldValue5+"' 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 "+fieldName5+"='"+fieldValue5+"' 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 "+fieldName5+"='"+fieldValue5+"' 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+"' and "+fieldName5+"='"+fieldValue5+"' 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 "+fieldName5+"='"+fieldValue5+"' 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+"' and "+fieldName5+"='"+fieldValue5+"' 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+"' and "+fieldName5+"='"+fieldValue5+"' 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+"' and "+fieldName5+"='"+fieldValue5+"' 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+"' and "+fieldName5+"='"+fieldValue5+"' 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 "+fieldName5+"='"+fieldValue5+"' and "+condition+" "+queue+"";
		}
		else{
					sql="select * from "+tableName+" where "+fieldName1+">='"+timea+"' and "+fieldName4+"='"+sales+"' and "+fieldName3+"='"+trade+"' and "+fieldName5+"='"+fieldValue5+"' 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;
					intRowCount=0;
					rs1=dbb.executeQuery(sql1);
					if(rs1.last()){
					intRowCount=rs1.getRow();
					}
			try {
											dbb.close();
						} catch (Exception ex) {
							ex.printStackTrace();
							}
		}
				catch (Exception ex){
					ex.printStackTrace();
				}
		return intRowCount;
	}

	public void close() {
		try {
				dba.close();
						} catch (Exception ex) {
							ex.printStackTrace();
							}
	}

	public double sumTotal(String fName) {
		try{
					this.fieldName=fName;
						sql2 = sql;
					dbb=new nseer_db(dbase);
					rs2=dbb.executeQuery(sql2);
					tradeTotal=0;
					while(rs2.next()){
					tradeTotal+=rs2.getDouble(fieldName);
					}
					try {
													dbb.close();
						} catch (Exception ex) {ex.printStackTrace();}
		}
				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;
	}

}