我是这样做的,你可以参考以下:
<%
String month=request.getParameter("month");
String title="工资表";
String sql="SELECT * FROM tb_wage ORDER BY wageDate desc";
if(month!=null && !month.equals("")){
sql="SELECT * FROM tb_wage where wageDate='"+month+"' ORDER BY wageDate desc";
title=month+title;
}
System.out.println("SQL:"+sql);
ResultSet rs=conn.executeQuery(sql);
%>