使用Parameters动态生成where语句

public class test extends HttpServlet

{   public void doGet(HttpServletRequest request, HttpServletResponse response)

    throws ServletException, IOException

    {   try

        {   ServletOutputStream servletOutputStream = response.getOutputStream();

            InputStream reportStream = getServletConfig().getServletContext()

            .getResourceAsStream("report4.jasper");

            String url = "jdbc:sqlserver://localhost:1079;databaseName=ghydb";

            String username = "sa";

            String password = "";

            String driverName = "com.microsoft.sqlserver.jdbc.SQLServerDriver";

            Class.forName(driverName);

              Connection connection=DriverManager.getConnection(url, username,password);

            HashMap parameters = new HashMap();

            parameters.put("whereSQL", "where id=3");

            JasperRunManager.runReportToPdfStream(reportStream,

            servletOutputStream, parameters, connection);

            response.setContentType("application/pdf");

            servletOutputStream.flush();

            servletOutputStream.close();

        }

        catch (JRException e)

        {   // TODO Auto-generated catch block

            e.printStackTrace();

        }

        catch (ClassNotFoundException e)

        {   // TODO Auto-generated catch block

            e.printStackTrace();

        }

        catch (SQLException e)

        {   // TODO Auto-generated catch block

            e.printStackTrace();

        }

    }

}