【Java开源代码栏目提醒】:本文主要为网学会员提供Thstat.java,希望对需要Thstat.java网友有所帮助,学习一下!
package swing;
/**
* <p>Title:SeliatF </p>
* <p>Description: </p>
* <p>Copyright: Copyright (c) 2005</p>
* <p>Company: </p>
* @author SeliatF
* @version 1.0
*/
public class Thstat {
private String names;
private String types;
private String bosses;
private String plan;
private String trim;
private String sql="select * from tb_th_plan where";
private String cut="";
private String toTrim(String trims){
//this.trim=trim.trim();
if(!trims.equals("")||trims!=null){
return this.trim=trims.trim();
}
return this.trim="";
}
private void setName(String names){
this.names=toTrim(names);
}
private void setType(String types){
this.types=toTrim(types);
}
private void setBoss(String bosses){
this.bosses=toTrim(bosses);
}
private void setPlan(String plan){
this.plan=toTrim(plan);
}
private String cutString(String cut){
int length=cut.length();
this.cut=cut.substring(0,length-5);
return this.cut;
}
public String toSql(String names,String types,String bosses,String plan){
setName(names);
setType(types);
setBoss(bosses);
setPlan(plan);
if(!names.trim().equals("")){
sql=sql+" Name='"+names+"' and ";
}if(!types.trim().equals("")){
sql=sql+" Type='"+types+"' and ";
}if(!bosses.trim().equals("")){
sql=sql+" Boss='"+bosses+"' and ";
}if(!plan.trim().equals("")){
sql=sql+" Planing="+plan+" and ";
}
return cutString(sql);
}
}