selectmanage.java

用J2EE开发的网站,可以应用到图书馆,图书超市

package ksnb;

import javax.servlet.*;
import javax.servlet.http.*;
import java.io.*;
import java.util.*;
import java.sql.*;
public class selectManage extends HttpServlet {
    private static final String CONTENT_TYPE = "text/html; charset=GB2312";

    //Initialize global variables
    public void init() throws ServletException {
    }

    //Process the HTTP Get request
    public void doPost(HttpServletRequest request, HttpServletResponse response) throws
            ServletException, IOException {
        response.setContentType(CONTENT_TYPE);
        HttpSession session=request.getSession();
        ManageSql ms=new ManageSql();
        ResultSet rs;
        Collection c=new ArrayList();
        String name=request.getParameter("name");
        String level=request.getParameter("level");
        String selectsql="select * from Shop_Admin where ";
        selectsql=selectsql+"Name like '%"+name+"%' "+"and Level like'%" + level +"%'";
        System.out.println(selectsql);
        rs=ms.Query_Manage(selectsql);
        try
        {
            while(rs.next())
            {
                String Name;
                String Level;
                Name=rs.getString("Name");
                c.add(Name);
                Level=rs.getString("Level");
                c.add(Level);
            }

        }
        catch(Exception e)
        {
            System.out.println(e.toString());
        }
        request.setAttribute("manage",c);
        RequestDispatcher rd=request.getRequestDispatcher("ShowManage.jsp");
        rd.forward(request,response);
    }

    //Clean up resources
    public void destroy() {
    }
}