使用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();

}

}

}