java中SQL拼接的问题

java中SQL拼接的问题

你可以 定义一个 Stringbuffer 例如

Stringbuffer sql=new Stringbuffer( " select * from intern t WHERe 1=1 " );

if(name!=null ){
sql.append( " and t.name='"+name+"' " );
}
以此类推

最后把sql.tostring () 就能转换成 Strings类型的 sql 语句啦

String basesql="select * from intern t where 1=1";
if(name!=null){
basesql+=" and name=?";
}
if(institute!=null){
basesql+=" and institute =?";
}
.........

用OR/AND 操作
select * from intern
WHERe (name=? OR name IS NULL) and institute=? and gender=? and majorCd=? and provinceCd=?

StringBuilder sql = new StringBuilder();
sql.append(" select * from intern t WHERe 1=1 ");
if(name.length!=0)
{
sql.append(" name= " +name);
}
sql.toString

我暂时保留我的看法！