rquery.jsp

一个自已编写的用JSP编写的简单的人事管理系统

<%@ page contentType="text/html; charset=gb2312" language="java" %>
<%@page import="java.sql.*"%>
<%@page import="java.io.*"%>
<%
request.setCharacterEncoding("GBK");
String value="";
String sql="select * from rsbd where ";
int count=0;
String str=request.getParameter("med1");
String a="";
for(int i=1;i<=5;i++)
{
	value="a"+i;
	a=(String)request.getParameter(value);
	if(a!=null)
	{
		count++;
		if(count>=2)
		   {
		      sql=sql+" "+str+" ";
		   }
		   sql=sql+a+"="+"'"+"1"+"'"+" ";
	}		
}
session.setAttribute("sql2",sql);
response.sendRedirect("pview.jsp");
%>