java sql 参数_java 多参数 怎么写SQL查询？

下面是3个参数，如果五六个参数是不是也得这么判断？？？

@Override

public List 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 rowMapper = new BeanPropertyRowMapper(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 rowMapper = new BeanPropertyRowMapper(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 rowMapper = new BeanPropertyRowMapper(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 rowMapper = new BeanPropertyRowMapper(Pin.class);

return jdbcTemplate.query(sql, rowMapper, q, page, perPage);

}

}