今天在做自己的毕业的时候,看到之前写的一条sql语句,是用String拼接的,如下:
String sql = "select count(*) from t_imployeeinfo where " +
(departId.equals("0000") ? " " : ("departId='" + departId + "' and ")) //这里有个三元表达式+ "impState=0";
乍眼看就觉得这条sql语句挺难看的,所以就想用StringBuilder拼接看看能不能好看些(上学的时候记得老师说过用StringBuilder拼接的话相对于String能好让人理解些),我就如下做了:
String query = (departId.equals("0000") ? " " : ("departId='" + departId + "' "));
StringBuilder sb = new S