天易06----简化sql多条件查询简单实例（2）

图片预览效果：

代码片段：

package com.test;

import java.util.ArrayList;
import java.util.List;

public class MyTest {

	/**
	 * @param args
	 */
	
	public String a(List list){
		StringBuffer str=new StringBuffer();
		if(list.size()>=1){
			if("users".equals(list.get(0).toString())){
				str.append("select * from users where 1=1");
				
			//System.out.println(str.append(" and id='"+list.get(0)+"'"));
			
		}
		
		}
		if(list.size()>=2){
			if(!"".equals(list.get(1).toString())){
				str.append(" and name='"+list.get(1)+"'");
			//System.out.println(str.append(" and name='"+list.get(1)+"'"));
			
		}}
		if(list.size()>=3){
			if(!"".equals(list.get(2).toString())){
				str.append(" and age='"+list.get(2)+"'");	
			//System.out.println(str.append(" and age='"+list.get(2)+"'"));
			
		}}
		if(list.size()>=4){
			if(!"".equals(list.get(3).toString())){
				str.append(" and email='"+list.get(3)+"'");
			//System.out.println(str.append(" and email='"+list.get(3)+"'"));
			
		}}
		if(list.size()>=5){
		if(!"".equals(list.get(4).toString())){
			
			str.append(" and id='"+list.get(4)+"'");
		}}
		return str.toString();
		
	}
	public static void main(String[] args) {
		
		List list=new ArrayList();
		list.add("users");
		list.add("java");
		list.add("oracle");
		list.add("websphere");
		list.add("mysql");

		MyTest mt=new MyTest();
		String sql=mt.a(list);
		System.out.println("sql--------------->"+sql);

	}

}