图片预览效果:
代码片段:
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);
}
}