极客观点
项目管理
HarmonyOS
下面是3个参数，如果五六个参数是不是也得这么判断？？？
@Override
public List<Pin> getPins(String c, String categoryId, String q, Integer page, Integer perPage) {
q = "%" + q + "%";
if(perPage == null) {
perPage = PER_PAGE;
}
if(page == null) {
page = PAGE;
} else if(page > PAGE) {
page = (page - 1) * perPage;
}
if(StringUtils.isNotBlank(c) && StringUtils.isBlank(categoryId)) {
String sql = "SELECT p.* FROM tz_pin p, tz_file f WHERE p.deleting = 0 AND p.is_private = 0 AND p.file_id = f.file_id AND f.theme = ? AND p.raw_text LIKE ? ORDER BY p.pin_id DESC LIMIT ?, ?";
RowMapper<Pin> rowMapper = new BeanPropertyRowMapper<Pin>(Pin.class);
return jdbcTemplate.query(sql, rowMapper, c, q, page, perPage);
} else if(StringUtils.isBlank(c) && StringUtils.isNotBlank(categoryId)) {
String sql = "SELECT p.* FROM tz_pin p, tz_board b WHERE p.deleting = 0 AND p.is_private = 0 AND b.deleting = 0 AND p.board_id = b.board_id AND b.category_id = ? AND p.raw_text LIKE ? ORDER BY p.pin_id DESC LIMIT ?, ?";
RowMapper<Pin> rowMapper = new BeanPropertyRowMapper<Pin>(Pin.class);
return jdbcTemplate.query(sql, rowMapper, categoryId, q, page, perPage);
} else if(StringUtils.isNotBlank(c) && StringUtils.isNotBlank(categoryId)) {
String sql = "SELECT p.* FROM tz_pin p, tz_board b, tz_file f WHERE p.deleting = 0 AND p.is_private = 0 AND b.deleting = 0 AND p.board_id = b.board_id AND p.file_id = f.file_id AND f.theme = ? AND b.category_id = ? AND p.raw_text LIKE ? ORDER BY p.pin_id DESC LIMIT ?, ?";
RowMapper<Pin> rowMapper = new BeanPropertyRowMapper<Pin>(Pin.class);
return jdbcTemplate.query(sql, rowMapper, c, categoryId, q, page, perPage);
} else {
String sql = "SELECT * FROM tz_pin WHERE deleting = 0 AND is_private = 0 AND raw_text LIKE ? ORDER BY pin_id DESC LIMIT ?, ?";
RowMapper<Pin> rowMapper = new BeanPropertyRowMapper<Pin>(Pin.class);
return jdbcTemplate.query(sql, rowMapper, q, page, perPage);
}
}
java
建造者模式可以比较好的解决这种问题。