query.jsp

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

<%@ page contentType="text/html; charset=gb2312" language="java" %>
<%@page import="java.sql.*"%>
<%@page import="java.io.*"%>
<%
request.setCharacterEncoding("GBK");
int count=0;
String str=request.getParameter("med");
String sql="select * from people where ";
if(!((request.getParameter("bm")).equals("")))
{
   count++;
   if(count>=2)
   {
      sql=sql+" "+str+" ";
   }
   sql=sql+"bm="+"'"+request.getParameter("bm")+"'"+" ";
}
//if(!((request.getParameter("sex")).equals("")))
	if(request.getParameter("sex")!=null)
{
   count++;
   if(count>=2)
   {
      sql=sql+" "+str+" ";
   }
   sql=sql+"sex="+"'"+request.getParameter("sex")+"'"+" ";
}
if(!((request.getParameter("name")).equals("")))
{
   count++;
   if(count>=2)
   {
      sql=sql+" "+str+" ";
   }
   sql=sql+"name="+"'"+request.getParameter("name")+"'"+" ";
}
if(!((request.getParameter("xl")).equals("")))
{
   count++;
   if(count>=2)
   {
      sql=sql+" "+str+" ";
   }
   sql=sql+"xl="+"'"+request.getParameter("xl")+"'"+" ";
}
if(!((request.getParameter("zw")).equals("")))
{
   count++;
   if(count>=2)
   {
      sql=sql+" "+str+" ";
   }
   sql=sql+"zw="+"'"+request.getParameter("zw")+"'"+" ";
}
session.setAttribute("sql1",sql);
String sf=(String)session.getAttribute("name2");
if(sf.equals("管理员"))
{
response.sendRedirect("44.jsp");
}
else
	response.sendRedirect("all.jsp");		
%>