动态拼接sql比较差(作为程序猿应该极力避免这种写法):
Stirng sql="";
if(条件判断){
sql=“select * from table”;
} else if(..){
sql="select * from table wherer col=**"
}else{
.....
}
推荐
(StringUtils.(opid)) {
condition=DbHelper.(condition, , );
param.add(opid);
}
(StringUtils.(location)){
condition = DbHelper.(condition,,);
param.add(location);
}
DbHelper基本类中写方法:
linkSql(String sql, String keyword, String append) {
(sql.equals()) {
append;
} (append.equals()) {
sql;
} {
(!append.startsWith()) {
append = + append;
}
(!keyword.startsWith()) {
keyword = + keyword;
}
sql + keyword + append;
}
}
这样写的话整体效果很好