81,090
社区成员
发帖
与我相关
我的任务
分享
String sql="select * from xx where id = ?";
String sql="select * from tablename where 1=1";
if(!key1.equals(""))
sql=sql + " and KEY1='"+key1+"'";
if(!key2.equals(""))
sql=sql + " and KEY2='"+key2+"'";
if(!key3.equals(""))
sql=sql + " and KEY3='"+key3+"'";
String sql="";
if(key1.equals("")&&key2.equals(""))
sql="select * from tablename";
else if(key1.equals(""))
sql="select * from tablename where KEY2='"+key2+"'";
else if(key2.equals(""))
sql="select * from talbename where KEY1='"+kry1+"'";
else
sql="select * from tablename where KEY1='"+key1+"' and KEY2='"+key2+"'";