java 多参数 怎么写SQL查询？

Question

下面是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);
        }
    }

Answer 1

建造者模式可以比较好的解决这种问题。

Answer 2

你应该了解一下orm，代码也许会优雅很多
http://stackoverflow.com/questions/452385/what-java-orm-do-you-prefer-and-why